Simple linear regression model using excel

Reference no: EM1313493

(a) Plot the data on U.S. general aviation shipments.

(b) Describe the pattern and discuss possible causes.

(d) Make a similar graph for 1992-2003 only. Would a fitted trend be helpful in making a prediction for 2004?

(e) Fit a trend model of your choice to the 1992-2003 data.

(f) Make a forecast for 2004, using either the fitted trend model or a judgment forecast. Why is it best to ignore earlier years in this data set?

U.S Manufactured general aviation shipments( 1966 - 2003)
Year	planes	year	planes	year	planes	year	planes
1966	15,587	1976	15,451	1986	1,495	1996	1,053
1967	13,484	1977	16,904	1987	1,085	1997	1,482
1968	13,556	1978	17,811	1988	1,143	1998	2,115
1969	12,407	1979	17,048	1989	1,535	1999	2,421
1970	7,277	1980	11,877	1990	1,134	2000	2,714
1971	7,346	1981	9,457	1991	1,021	2001	2,538
1972	9,774	1982	4,266	1992	856	2002	2,169
1973	13,646	1983	2,691	1993	870	2003	2,090
1974	14,166	1984	2,431	1994	881

Reference no: EM1313493

Questions Cloud

Determining population mean using confidence level : Based on this information, confidence level would be 90% that population mean is somewhere between?

What is the spacing d between the planes of the crystal : When the tire surface is rotating at the maximum speed of 12 m/s stone flies out of the tread. The magnitude FN of the normal force that each side of the tread channel exerts on the stone is 1.8 N. suppose that only static friction supplies centripet..

Conditions and symptoms linked with paresis : A person in the car accident shows the following symptoms: extreme paresis on right side, involving the arm and leg; reduction of the pain sensation on left side.

Determine the retained earnings on december : Computation of retained earnings using given information and evaluate the retained earnings on December 31, 2005, and 2006.

Simple linear regression model using excel : Make a forecast for 2004, using either the fitted trend model or a judgment forecast. Why is it best to ignore earlier years in this data set?

Secondary line voltage : Three single-phase step-up transformers rated at 10MVA, 4.6kV/13.8kV are connected in Wye-Delta configuration. The three transformers are used to feed a 20MVA load at 0.9 p.f. With an efficiency of 96%. Find the secondary line voltage.

How the trade-offs you face in allocating the time : The subsequent tables Explain how the trade-offs you face in allocating the time you will spend in studying each subject.

Estimate the vapor pressure of the compound at 300 degree : Explain how Gestalt psychologists understand perceptual organization, including the discussion of form perception, depth perception, and perceptual constancy.

Compute the net present value and profitability index : Compute the net present value and profitability index of a project and with a net investment of $20,000 and expected net cash flows of $3,000

User Account

All Pages