90.2K

Verified Solution

Link Copied!

Median Income and Median Home Price in Selected Eastern Cities (n = 34)
	City	Income	Home
	Alexandria, VA	59.976	290.000		Note: All values are in thousands of dollars.
	Bernards Twp., NJ	112.435	279.900
	Brentwood, TN	107.866	338.250		Key:	Income = median family income (thousands)
	Bridgewater, NJ	93.484	316.000			Home = median home price (thousands)
	Cary, NC	77.091	207.000
	Centerville, VA	77.243	250.000
	Chantilly, VA	94.864	320.000
	Chesapeake, VA	53.758	150.000
	Collierville, TN	85.716	230.000
	Columbia, MD	77.033	199.000
	Coral Springs, FL	62.632	218.500
	Dranesville, VA	109.502	290.000
	Dunwoody, GA	86.971	315.000
	Ellicott City, MD	83.583	248.000
	Franconia, VA	84.537	290.000
	Gaithersburg, MD	64.944	220.000
	Hoover, AL	64.431	170.450
	Hunter Mill, VA	93.987	290.000
	Lower Makefield Twp., PA	102.997	205.000
	Manalapan Twp., NJ	91.245	410.000
	Marlboro Twp., NJ	108.759	379.975
	Matoaca, VA	65.149	135.000
	Newtown, CT	97.723	358.500
	North Andover, MA	79.169	342.500
	Oakton, VA	90.824	341.000
	Olney, MD	100.716	287.450
	Peachtree City, GA	79.805	214.500
	Ramapo, NY	64.954	330.875
	Randolph Twp., NJ	104.121	444.500
	Reston, VA	85.264	240.000
	Roswell, GA	76.530	226.450
	Sugarland Run, VA	103.350	278.250
	Sully, VA	92.942	290.000
	Wellington, FL	76.076	230.000

	Cruise Speed and Horsepower of Single-Engine Aircraft (n = 52)
	Obs	Mfgr/Model	Year	Cruise	TotalHP
	1	AMD CH 2000	2000	100	116
	2	Beech Baron 58	1984	200	600
	3	Beech Baron 58P	1984	241	650
	4	Beech Baron D55	1968	199	570
	5	Beech Bonanza B36 TC	1982	174	300
	6	Beech Duchess	1982	164	360
	7	Beech Sierra	1972	141	360
	8	Bellanca Super Viking	1973	161	300
	9	Cessna 152	1978	107	110
	10	Cessna 170B	1953	104	145
	11	Cessna 172 R Skyhawk	1997	122	160
	12	Cessna 172 RG Cutlass	1982	129	180
	13	Cessna 182Q Skylane	1977	144	230
	14	Cessna 310 R	1975	194	570
	15	Cessna 337G Skymotor II	1975	170	420
	16	Cessna 414A	1985	223	620
	17	Cessna 421B	1974	234	750
	18	Cessna Cardinal	1970	124	180
	19	Cessna P210	1982	186	285
	20	Cessna T210K	1970	190	285
	21	Cessna T303 Crusader	1983	190	500
	22	Cessna Turbo Skylane RG	1979	159	235
	23	Cessna Turbo Skylane T182T	2001	160	235
	24	Cessna Turbo Stationair TU206	1981	148	310
	25	Cessna U206H	1998	143	300
	26	Cirrus SR20	1999	160	200
	27	Diamond C1 Eclipse	2002	140	125
	28	Extra Extra 400	2000	235	350
	29	Lancair Columbia 300	1998	191	310
	30	Liberty XL-2	2003	132	125
	31	Maule Comet	1996	115	180
	32	Mooney 231	1982	170	210
	33	Mooney Eagle M205	1999	175	244
	34	Mooney M20C	1965	156	200
	35	Mooney Ovation 2 M20R	2000	188	280
	36	OMF Aircraft Symphony	2002	128	160
	37	Piper 125 Tri Pacer	1951	107	125
	38	Piper 6X	2004	148	300
	39	Piper Archer III	1997	129	180
	40	Piper Aztec F	1980	191	500
	41	Piper Dakota	1979	147	235
	42	Piper Malibu Mirage	1998	213	350
	43	Piper Saratoga II TC	1998	186	300
	44	Piper Satatoga SP	1980	148	300
	45	Piper Seneca III	1982	180	440
	46	Piper Seneca V	2002	186	440
	47	Piper Super Cab	1975	100	150
	48	Piper Turbo Lance	1979	176	300
	49	Rockwell Commander 114	1976	151	260
	50	Sky Arrow 650 TC	1998	98	81
	51	Socata TB20 Trinidad	1999	163	250
	52	Tiger AG-5B	2002	143	180

HELP WITH DATA ANALYSIS ASSIGNMENT

Time Series Forecasting

Choose a company that interests you, and for which you can find data on its annual revenue for the last 10 years.

A) Use Excel and Megastat to make an attractive, well-labeled time series line chart of the last 10 years of revenue for the company. Post this first graphic in your discussion. Adjust the Y-axis scale if necessary to show more detail. Label it Figure 1.

B) Describe the trend and discuss possible causes.

C) Fit both a linear and an exponential trend to the data. Use Excels option to display the equation and R2 statistic. Attach this as Figure 2.

D) Which model is better? Why?

E) Make annual forecasts for 2014-2015 using a trend model of your choice. Explain to us the model that you used, and why you chose it. Attach this as Figure 3 in your discussion thread.

Make sure to cite your data!

Answer & Explanation Solved by verified expert

See Answer