Share With

Excel Assignment 3

Due Friday October 21, 2016 by 11:30 pm

This is an individual assignment.

Open the Excel assignment Labeled “Excel Assignment 3”
Run the regression you are using advertising dollars and the month to predict the sales.
Answer the following 3 questions: (this can be done on the Excel file)
1. What is the equation of the line?
2. How good is the line (support your answer)?
3. What is the Forecast for December 2016, with Advertising of $2100?

Please submit your assignment via Dropbox by October 21, 2016 at 11:30 pm (Please be aware of any iCollege maintenance downtimes)

Run the regression for the following data, you are using Advertising dollars and the month to predict Sales
Answer the following questions:
1. What is the line?
2. How good is the line ( support your answer)?
3. What is the Forecast for December 2016, with Advertising of $2,100

Sales (thousands of units)	Advertising (thousands of $)	Month, 1 = January 2016
175	2.5	1
116	1.3	2
165	1.4	3
101	1	4
209	2	5
160	1.5	6
230	2.2	7
200	0.7	8

pur-new-sol

PFA

Related Questions