Estimate the least squares regression line

Assignment Help Operation Management

Reference no: EM13104390

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 using Excel.

(b) Determine the predicted value for 2004.

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

Reference no: EM13104390

Questions Cloud

Explain history of world civilizations : A famous publishing company, has contacted you about possibility of writing new textbook for first semester History of World Civilizations course, potentially very lucrative undertaking.

Analyzing or rejection of a lot of incoming material : The quality control manager for ENTA Inc. must decide whether to accept (a1), further analyze (a2) or reject (a3) a lot of incoming material. Assume the following payoff table is available.

What is the transverse speed for a point on the string : The function y(x, t) = (25.0 cm) cos(?x - 20?t), with x in meters and t in seconds, describes a wave on a taut string. What is the transverse speed for a point on the string at an instant when that point has the displacement y = +22.0 cm?

Determing confidence interval estimation : Compute the 99% confidence interval for the population mean based on the sample 62, 68, 61, 64, 65, 62, and 66. Then, change the number from 66 to 16 and calculate the confidence interval.

Estimate the least squares regression line : Determine the least squares regression line using Excel. Determine the MSE for the trend line (in a) and the 3 month moving average (in c.) Which forecasting method is better? Explain.

What is the tangential speed of a wad of chewing gum : A wheel with radius 43.9 cm rotates 4.27 times every second. Find the period of this motion.

Point estimates and confidence intervals : The Warren County Telephone Company claims in its annual report that "the typical customer spends $70 per month on local and long-distance service.

What is the total distance the car travels : A car travels north at 28.9 m/s for 14.3 min. It then travels south at 40.1 m/s for 28.5 min. a) What is the total distance the car travels? b) What is the displacement of the car?

Randomly selected five pound box of nails : What is the probability that there are less than 500 nails in a randomly selected five pound box of nails?

User Account

All Pages