wk10

Sheet1

Sales	Income	Year			Sales (X)	Income (Y)
0	-0.3	1995			0	-0.3
0.02	-5.7	1996			0.02	-5.7
0.15	-27.5	1997			0.15	-27.5
0.61	-124.5	1998			0.61	-124.5
1.64	-719.9	1999			1.64	-719.9
2.76	-1411.2	2000			2.76	-1411.2
3.12	-567.3	2001			3.12	-567.3
3.93	-149.1	2002			3.93	-149.1
5.26	35.3	2003			5.26	35.3
6.92	588.5	2004			6.92	588.5
8.49	359	2005			8.49	359
10.71	190	2006			10.71	190
14.84	476	2007			14.84	476
19.17	645	2008			19.17	645
24.51	902	2009			24.51	902
34.2	1150	2010			34.2	1150
48.08	631	2011			48.08	631
61.09	-39	2012			61.09	-39		SUMMARY OUTPUT
74.45	274	2013			74.45	274
88.99	-241	2014			88.99	-241		Regression Statistics
107.01	596	2015			107.01	596		Multiple R	0.2940977822	29%
								R Square	0.0864935055	9%
								Adjusted R Square	0.0384142163
								Standard Error	569.1317742054
								Observations	21
								ANOVA
									df	SS	MS	F	Significance F
								Regression	1	582708.194873737	582708.194873737	1.7989763772	0.1956502894
								Residual	19	6154308.55179293	323910.976410154
								Total	20	6737016.74666667
									Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
								Intercept	-7.6495190193	157.3631910602	-0.0486105993	0.9617369786	-337.0144631868	321.7154251482	-337.0144631868	321.7154251482
								Sales (X)	5.2755885249	3.9333100761	1.3412592506	0.1956502894	-2.9569240779	13.5081011276	-2.9569240779	13.5081011276
			Sales (X)	Sales (x2)	Income (Y)
			0	0	-0.3
			0.02	0.0004	-5.7
			0.15	0.0225	-27.5
			0.61	0.3721	-124.5
			1.64	2.6896	-719.9
			2.76	7.6176	-1411.2
			3.12	9.7344	-567.3
			3.93	15.4449	-149.1
			5.26	27.6676	35.3
			6.92	47.8864	588.5
			8.49	72.0801	359
			10.71	114.7041	190
			14.84	220.2256	476
			19.17	367.4889	645
			24.51	600.7401	902
			34.2	1169.64	1150
			48.08	2311.6864	631
			61.09	3731.9881	-39		SUMMARY OUTPUT
			74.45	5542.8025	274
			88.99	7919.2201	-241		Regression Statistics
			107.01	11451.1401	596		Multiple R	0.509316216	51%
							R Square	0.2594030079	26%
							Adjusted R Square	0.1771144533
							Standard Error	526.4880677206
							Observations	21
							ANOVA
								df	SS	MS	F	Significance F
							Regression	2	1747602.40852807	873801.204264037	3.1523582951	0.0670251037
							Residual	18	4989414.33813859	277189.685452144
							Total	20	6737016.74666667
								Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
							Intercept	-189.1550305132	170.3833255083	-1.1101733691	0.2815355668	-547.1171143632	168.8070533368	-547.1171143632	168.8070533368
							Sales (X)	30.6713882395	12.911473883	2.3755140983	0.028838109	3.5453881867	57.7973882924	3.5453881867	57.7973882924
							Sales (x2)	-0.2764199936	0.1348387573	-2.0500040129	0.0552203725	-0.5597057107	0.0068657235	-0.5597057107	0.0068657235

Income (Y)

y = 5.2756x - 7.6495 R² = 0.0865

0 0.02 0.15 0.61 1.64 2.76 3.12 3.93 5.26 6.92 8.49 10.71 14.84 19.170000000000002 24.51 34.200000000000003 48.08 61.09 74.45 88.99 107.01 -0.3 -5.7 -27.5 -124.5 -719.9 -1411.2 -567.29999999999995 -149.1 35.299999999999997 588.5 359 190 476 645 902 1150 631 -39 274 -241 596

Income (Y) 0 4.0000000000000002E-4 2.2499999999999999E-2 0.37209999999999999 2.6895999999999995 7.6175999999999986 9.7344000000000008 15.444900000000001 27.667599999999997 47.886400000000002 72.080100000000002 114.70410000000003 220.22559999999999 367.48890000000006 600.7401000000001 1169.6400000000001 2311.6864 3731.9881000000005 5542.8025000000007 7919.2200999999986 11451.140100000001 -0.3 -5.7 -27.5 -124.5 -719.9 -1411.2 -567.29999999999995 -149.1 35.299999999999997 588.5 359 190 476 645 902 1150 631 -39 274 -241 596