Management of a home appliance store would like to understand the growth pattern

Management of a home appliance store would like to understand the growth pattern of the monthly sales of Blu- ray disc players over the past two years. Managers have recorded the relevant data in the file P10_ 09. xlsx.a. Create a scatterplot for these data. Comment on the observed behavior of monthly sales at this store over time.b. Estimate an appropriate regression equation to explain the variation of monthly sales over the given time period. Interpret the estimated regression coefficients.c. Analyze the estimated equation s residuals. Do they suggest that the regression equation is adequate? If not return to part b and revise your equation. Continue to revise the equation until the results are satisfactory.
Data
Source
Month
Blu-ray disc players sold
1.00
23.00
2.00
156.00
3.00
330.00
4.00
482.00
5.00
1209.00
6.00
1756.00
7.00
2000.00
8.00
2512.00
9.00
2366.00
10.00
2942.00
11.00
2872.00
12.00
2937.00
13.00
3136.00
14.00
3241.00
15.00
3149.00
16.00
3524.00
17.00
3542.00
18.00
3312.00
19.00
3547.00
20.00
3376.00
21.00
3375.00
22.00
3403.00
23.00
3697.00
24.00
3495.00
This is fictitious data.
Data
Source
Month
Blu-ray disc players sold
1.00
23.00
2.00
156.00
3.00
330.00
4.00
482.00
5.00
1209.00
6.00
1756.00
7.00
2000.00
8.00
2512.00
9.00
2366.00
10.00
2942.00
11.00
2872.00
12.00
2937.00
13.00
3136.00
14.00
3241.00
15.00
3149.00
16.00
3524.00
17.00
3542.00
18.00
3312.00
19.00
3547.00
20.00
3376.00
21.00
3375.00
22.00
3403.00
23.00
3697.00
24.00
3495.00
This is fictitious data.

Attachments: