(See Steps) An investigation is taking place to see whether the average price of a particular good in the market predicts the total number of weekly sales.
Question:
An investigation is taking place to see whether the average price of a particular good in the market predicts the total number of weekly sales. 22 observations of average price and total sales have been observed and are given below.
| Average Price (£) | Total Weekly Sales |
| 20 | 335 |
| 22 | 328 |
| 18 | 360 |
| 21 | 328 |
| 24 | 296 |
| 19 | 332 |
| 20 | 343 |
| 17 | 373 |
| 24 | 324 |
| 23 | 319 |
| 26 | 292 |
| 29 | 263 |
| 28 | 281 |
| 24 | 307 |
| 20 | 321 |
| 21 | 349 |
| 24 | 309 |
| 23 | 328 |
| 19 | 361 |
| 26 | 292 |
| 17 | 370 |
| 23 | 314 |
- Create a scatterplot of the data.
- Fit a linear regression model and derive the relationship between weekly sales and average price.
- Calculate the predicted number of sales when average price is £27.
- Calculate 99% confidence interval for the change in sales for each £1 increase in the average price.
- Calculate the 95% confidence interval for the mean number of sales when average price is £27
- Calculate the 95% prediction interval of the number of weekly sales when average price is £27
vii) Explain why you may not be confident predicting a value for the mean number of weekly sales when average price is £45.
Price: $2.99
Solution: The downloadable solution consists of 5 pages
Deliverable: Word Document 