least squares regression in excel with future prediction and mse

1.  For the data below:

Year

Automobile Sales

Year

Automobile Sales

1990

116

1997

119

1991

105

1998

34

1992

29

1999

34

1993

59

2000

48

1994

108

2001

53

1995

94

2002

65

1996

27

2003

111

(a) Determine the least squares regression trend line using the Excel output from the Data Analysis tool. (5 pts)

(b) Determine the predicted value for 2004. Use the information from part (a). (5 pts)

(c) Determine the 3 year moving average. (10 pts)

(d) Determine the MSE for the trend line (in a) and the 3 year moving average (in c.)  Which forecasting method is better? Explain. (20 pts)

ALL WORK NEEDS TO BE SHOWN

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code “Newclient” for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.


The post least squares regression in excel with future prediction and mse appeared first on Nursing Writers Hub.

"Is this qustion part of your assignmentt? We will write the assignment for you. click order now and get up to 40% Discount"