Least Squares Regression Line and MAD
Not what you're looking for?
For the data below
Year Automobile Sales Year Automobile Sales
1990 116 1977 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 line.
(b) Determine the predicted value for 2004.
(c) Determine the MAD.
(d) Determine the unadjusted forecasting MSE.
Purchase this Solution
Solution Summary
The expert determines the MAD and the unadjusted forecasting MSE.
Solution Preview
Please see attachment.
LEAST SQUARES REGRESSION LINE
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 line.
Y X
Year Automobile sales y =average of sales x =average of year (Y-y) (X-x) (Y-y)(X-x) (X-x)2
1990 116.00 1.00 71.57 7.50 44.43 -6.50 -288.79 42.25
1991 105.00 2.00 71.57 7.50 33.43 -5.50 -183.86 30.25
1992 29.00 3.00 71.57 7.50 -42.57 -4.50 191.57 20.25
1993 59.00 4.00 71.57 7.50 -12.57 -3.50 44.00 12.25
1994 108.00 5.00 71.57 7.50 36.43 -2.50 -91.07 6.25
1995 94.00 6.00 71.57 7.50 22.43 -1.50 -33.64 2.25
1996 27.00 7.00 71.57 7.50 -44.57 -0.50 22.29 0.25
1997 119.00 8.00 71.57 7.50 47.43 0.50 23.71 0.25
1998 34.00 9.00 ...
Education
- B. Sc., University of Nigeria
- M. Sc., London South Bank University
Recent Feedback
- "Thank you."
- "thank you Chidi Ngene.. if you have any APA references would be great"
- "Thank you so much for your help, your explanations were easy to understand and apply!"
- "are you able to highlight the equations used either on the xlsx or a word doc as to how each graph was formed- overall looks fine i just need help understanding this myself"
- "Chidi Ngene, M. Sc. Was extremely helpful as without the help and guidance I would have failed, but with the help I passed. I still have a lot to learn and in need of the guidance to understand and learn more on the subject. I would recommend Chidi Ngene and BrainMass to anyone that are in need of help. Thank you!!"
Purchase this Solution
Free BrainMass Quizzes
Probability Quiz
Some questions on probability
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.