help in homework

New User?

Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / 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

Statistics

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

            

 

Option 1

Low Cost Option
Download this past answer in few clicks

4.98 USD

PURCHASE SOLUTION

Already member?

Option 2

Custom new solution created by our subject matter experts

GET A QUOTE

rated 5 stars

Purchased 9 times

Completion Status 100%
View Answer

Sitejabber (5.0)

BBC (5.0)

Trustpilot (4.9)

Google (5.0)