Trusted by Students Everywhere
Why Choose Us?
0% AI Guarantee
Human-written only.
24/7 Support
Anytime, anywhere.
Plagiarism Free
100% Original.
Expert Tutors
Masters & PhDs.
100% Confidential
Your privacy matters.
On-Time Delivery
Never miss a deadline.
Excel Assignment 3 Due Friday October 21, 2016 by 11:30 pm This is an individual assignment
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)
- What is the equation of the line?
- How good is the line (support your answer)?
- 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 |
||||||
Expert Solution
Buy This Solution
4.98 USD
Instant Access
Already a member? Sign In
Important Note:
This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.
For ready-to-submit work, please order a fresh solution below.
For ready-to-submit work, please order a fresh solution below.
Or get a fresh solution
Get Custom Quote
