The following data were collected for 12 months using a company's sales reports. The report shows, for
Fantastic news! We've Found the answer you've been seeking!
Question:
Month x y
1 90 9,200
2 116 9,850
3 138 12,640
4 150 14,100
5 166 14,620
6 164 13,800
7 156 13,180
8 130 12,280
9 108 9,280
10 102 9,760
11 68 6,850
12 84 8,720
(a) Provide the scatter plot for advertising vs sales dollars with the trend line. (4 points)
(b) Obtain a linear regression line for the data. (Hint: You need to calculate a and b to get the linear
regression equation: y= a + bx) (12 points) You need to show all the work in Excel or manually
when you computed the line equation.
(c) Predict the sales figures in months 13 and 14 if the advertising budgets allocated for months 13
and 14 are $135,000 and $128,000, respectively. (4 points)
Related Book For
Intermediate Accounting Volume 1
ISBN: 9781260881233
8th Edition
Authors: Thomas H. Beechy, Joan E. Conrod, Elizabeth Farrell, Ingrid McLeod-Dick, Kayla Tomulka, Romi-Lee Sevel
Posted Date: