2013.1 - Prof Damazio - Regressão linear - Memoria_calculo

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

p=0,3333
	Ad(Km2)	Q(m3/s)	p =	0 1/3	Ad(Km2) - xi	Q(m3/s) - yi	xi2	xi*yi	yi2	(xi - x)*(yi-y)	(xi - x)^2	(yi-y)^2
	1	4772	33.18	16.8357891612	3.2133556392	283.4437966819	54.0993780415	10.325654463925375	6.7232036466165441	51.972236659195673	0.86972334037273535
	2	6418	52.03	18.5837449999	3.7332288094	345.3555782228	69.3773722209	13.936997343572314	2.2539357406621701	29.824939331538467	0.17033484181012984
	3	4734	5.46	P=1/3	16.7909815542	1.7608845416	281.9370615539	29.5669798571	3.1007143688391618	17.301194105396348	52.620296343589089	5.6885144758229753
	4	5383	51.97	P=1/2	17.5256765937	3.7317932281	307.1493400676	65.4022012308	13.92628069751135	2.6999769140071801	42.501139758614613	0.17152187865018706
	5	24061	110.36	P=1	28.8694088485	4.7966411687	833.442767264	138.476194999	23.007766501293077	3.1392451104361125	23.275244805787231	0.42340520779170054
	6	2704	12.85	P=1,5	13.9316395358	2.342256085	194.0905801545	32.6314674768	5.4861635677774849	18.241297885219236	102.27938054261627	3.2532945230212897
	7	3564	21.88	P=2	15.274930109	2.7969354226	233.3234898342	42.7229930992	7.8228477580750839	11.830864965476691	76.913536788439174	1.8198274539935406
	8	7620	50.19	19.6781827921	3.6886920402	387.2308779988	72.58675623	13.606448967152099	1.9967257298149681	19.068799199139296	0.20908047740547153
	9	8321	42.1	20.2639998703	3.4787832096	410.6296907446	70.4940625082	12.101932619383103	2.5225172690915412	14.295708003107521	0.44510515823923325
	10	8474	41.16	20.3874458192	3.4526969041	415.6479470324	70.3916710618	11.921115911323863	2.5355700204369835	13.377456899874263	0.48059323806150589
	11	33022	180.93	32.0824695706	5.6559235132	1029.2848537513	181.4559940061	31.989470787171978	12.136455237380119	64.601456995767506	2.2800344230406684
	12	34062	176.89	32.4157978134	5.6135090522	1050.7839478788	181.9663744585	31.51148387868502	12.284729343646774	70.070818319900312	2.1537435792125739
	13	36080	178.24	33.0437131141	5.6277533845	1091.8869763651	185.9618683153	31.671608157140415	13.334416262772384	80.977442175092207	2.1957554140130653
	14	39757	174.79	34.1301241931	5.591206437	1164.8653774335	190.828570083	31.261589420865697	14.575687328925685	101.71040743188883	2.0887799633766488
	15	6441	33.86	18.6059178764	3.2351591582	346.1801800251	60.1931056147	10.466254778892463	4.9538096385332828	29.583248992028693	0.82953126417716005
	16	14551	93.91	24.4135506565	4.5453843626	596.021455656	110.9689713883	20.660519003338866	0.14722697104330484	0.13585434392086088	0.15955162254666583
	17	18249	91.34	26.3277062519	4.5035363149	693.1481164886	118.5677811941	20.281839339777036	0.8162874208149915	5.2109011685029536	0.12787138574194459
	18	21954	92.29	28.0008503143	4.5190958068	784.0476183246	126.5385252426	20.422226911157278	1.4761403688388899	15.649017434090322	0.13924135478110156
	19	62535	272.87	39.6924327884	6.4861242462	1575.4892206623	257.4500507005	42.06980773746637	36.617872504714441	244.84320394350999	5.4764378392993338
	∑	456.8544	78.7730	12023.9589	2059.6803	355.5707	165.5872	1038.9111	28.9823
	B0	0.31353
	B1	0.15939
	r2	0.91063	0.91063
	
	Regression Statistics
	Multiple R	0.9542686976
	R Square	0.9106287473
	Adjusted R Square	0.9053716148
	Standard Error	0.3903383673
	Observations	19
	ANOVA
	df	SS	MS	F	Significance F
	Regression	1	26.3921587444	26.3921587444	173.2177656305	0.0000000002
	Residual	17	2.590188697	0.152364041
	Total	18	28.9823474414
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95,0%	Upper 95,0%
	Intercept	0.3135310226	0.3046484627	1.0291567527	0.3178271627	-0.3292210498	0.956283095	-0.3292210498	0.956283095
	X Variable 1	0.1593853008	0.0121102205	13.1612220417	0.0000000002	0.133834969	0.1849356327	0.133834969	0.1849356327
	RESIDUAL OUTPUT
	Observation	Predicted Y	Residuals	Standard Residuals
	1	2.9969083425	0.2164472967	0.5705881088
	2	3.2755068097	0.4577219997	1.2066250502
	3	2.9897666686	-1.228882127	-3.2395208425
	4	3.1068662585	0.6249269696	1.6474028702
	5	4.9148904363	-0.1182492676	-0.311723117
	6	2.5340295809	-0.1917734959	-0.5055442041
	7	2.748130353	0.0488050696	0.1286576123
	8	3.4499441064	0.2387479337	0.6293759917
	9	3.5433147377	-0.0645315281	-0.170114957
	10	3.5629902074	-0.1102933033	-0.2907499808
	11	5.427005086	0.2289184272	0.6034639122
	12	5.4801327083	0.1333763439	0.3516003987
	13	5.5802131774	0.0475402072	0.1253232418
	14	5.753371134	-0.162164697	-0.4274908914
	15	3.2790408403	-0.0438816821	-0.1156788113
	16	4.204692138	0.3406922246	0.8981167015
	17	4.5097804034	-0.0062440884	-0.0164603701
	18	4.7764549731	-0.2573591662	-0.6784380411
	19	6.6399213627	-0.1537971165	-0.405432672
p=0,5
	Ad(Km2)	Q(m3/s)	p =	0 1/2	Ad(Km2) - xi	Q(m3/s) - yi	xi2	xi*yi	yi2	(xi - x)*(yi-y)	(xi - x)^2	(yi-y)^2
	1	4772	33.18	69.0796641567	5.7602083296	4772	397.9132568789	33.18	157.02947908032738	2803.7678784310979	8.7946857120129973
	2	6418	52.03	80.1124210095	7.2131823767	6418	577.8655033829	52.03	63.405353570793793	1757.1070292052482	2.2879874672493661
	3	4734	5.46	P=1/3	68.8040696471	2.3366642891	4734	160.7720124897	5.46	340.06905805091498	2833.0296296119782	40.820951194737766
	4	5383	51.97	P=1/2	73.3689307541	7.2090221251	5383	528.9182451003	51.97	73.808064386901066	2367.9270576952663	2.3005904471749989
	5	24061	110.36	P=1	155.1160855617	10.5052367893	24061	1629.5312086609	110.35999999999999	58.87436604626464	1094.6704295423081	3.1664242349168106
	6	2704	12.85	P=1,5	52	3.5846896658	2704	186.4038626209	12.850000000000001	360.03283437403394	4904.2403288110727	26.430931833804522
	7	3564	21.88	P=2	59.6992462264	4.6776062254	3564	279.2495658009	21.879999999999995	252.32760201556906	3885.1579599184529	16.387806981280058
	8	7620	50.19	87.2926113712	7.0844901016	7620	618.423641204	50.19	57.01499929694603	1206.7057268922765	2.6938714819913585
	9	8321	42.1	91.2195154558	6.488451279	8321	591.8733817296	42.099999999999994	68.934177418763312	949.30330503770392	5.0056929025574224
	10	8474	41.16	92.0543317829	6.4156059729	8474	590.5843208213	41.16	69.250016200150313	898.55756222926323	5.336958860847596
	11	33022	180.93	181.7195641641	13.451022266	33022	2444.3139037366	180.93	282.04561293116888	3562.8104633881076	22.327802332226721
	12	34062	176.89	184.558933677	13.3	34062	2454.6338179044	176.88999999999996	286.01906933136729	3909.8323414306665	20.923380052467188
	13	36080	178.24	189.9473611293	13.3506554146	36080	2535.9217653548	178.24000000000004	314.10722584075512	4612.7297035918946	21.389362842688747
	14	39757	174.79	199.3915745462	13.2208169188	39757	2636.1195022229	174.79	347.740950293374	5984.7696597404138	20.20525022448129
	15	6441	33.86	80.2558409089	5.8189346104	6441	467.003490351	33.86	121.43233577252386	1745.1038877952556	8.4498191049248472
	16	14551	93.91	120.6275258803	9.6907172077	14551	1168.9672407728	93.910000000000011	-1.3535544582824506	1.9677233655215154	0.93108091494900003
	17	18249	91.34	135.0888596443	9.5571962416	18249	1291.0707416714	91.340000000000018	10.856958996073683	170.52646280759546	0.69123323560297889
	18	21954	92.29	148.1688226315	9.6067684473	21954	1423.4235701294	92.29000000000002	23.02744259258991	683.22333179479506	0.77611973666362943
	19	62535	272.87	250.0699902027	16.5187771945	62535	4130.8504511783	272.87000000000006	997.81157126788742	16394.167001315785	60.730620328326644
	∑	2318.5753	165.7900	342702.0000	24113.8395	1716.3000	3882.4336	59765.5975	269.6506
	B0	0.79858
	B1	0.06496
	r2	0.93531	0.93531
	SUMMARY OUTPUT
	Regression Statistics
	Multiple R	0.9671141303
	R Square	0.935309741
	Adjusted R Square	0.9315044317
	Standard Error	1.0129678354
	Observations	19
	ANOVA
	df	SS	MS	F	Significance F
	Regression	1	252.2068046849	252.2068046849	245.7907240497	0
	Residual	17	17.443765204	1.0261038355
	Total	18	269.6505698889
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95,0%	Upper 95,0%
	Intercept	0.7985815544	0.5564825389	1.4350523127	0.1694148732	-0.3754939749	1.9726570836	-0.3754939749	1.9726570836
	X Variable 1	0.0649610098	0.0041435256	15.6777142482	0	0.056218935	0.0737030846	0.056218935	0.0737030846
	RESIDUAL OUTPUT
	Observation
Predicted Y	Residuals	Standard Residuals
	1	5.2860662937	0.4741420358	0.4816422721
	2	6.0027653196	1.2104170571	1.2295640916
	3	5.2681633961	-2.931499107	-2.9778711523
	4	5.5647013832	1.6443207419	1.6703315006
	5	10.8750791067	-0.3698423174	-0.375692684
	6	4.1765540633	-0.5918643975	-0.6012268301
	7	4.6767048728	0.0009013526	0.0009156107
	8	6.469197736	0.6152923656	0.6250253945
	9	6.7242933907	-0.2358421117	-0.2395727903
	10	6.7785239023	-0.3629179293	-0.3686587623
	11	12.6032679406	0.8477543254	0.8611645638
	12	12.7877162513	0.5122837487	0.5203873313
	13	13.1377539397	0.2129014749	0.2162692661
	14	13.7512595799	-0.5304426612	-0.5388334913
	15	6.0120820211	-0.1931474107	-0.1962027214
	16	8.6346674437	1.056049764	1.0727549329
	17	9.5740902879	-0.0168940463	-0.0171612855
	18	10.4237778915	-0.8170094442	-0.8299333434
	19	17.0433806354	-0.524603441	-0.5329019032
p=1
	Ad(Km2)	Q(m3/s)	p =	1	Ad(Km2) - xi	Q(m3/s) - yi	xi2	xi*yi	yi2	(xi - x)*(yi-y)	(xi - x)^2	(yi-y)^2
	1	4772	33.18	4772	33.18	22771984	158334.96	1100.9124	758112.6867590029	175958828.68698063	3266.3029761773
	2	6418	52.03	6418	52.03	41190724	333928.54	2707.1209	445024.0299168976	134999937.9501385	1467.0109498615
	3	4734	5.46	P=1/3	4734	5.46	22410756	25847.64	29.8116	1129042.1478116347	176968408.68698063	7203.1849130194
	4	5383	51.97	P=1/2	5383	51.97	28976689	279754.51	2700.8809	485425.4009695292	160122384.0027701	1471.6107393352
	5	24061	110.36	P=1	24061	110.36	578931721	2655371.96	12179.3296	120652.2625484764	36289210.10803323	401.1376498615
	6	2704	12.85	P=1,5	2704	12.85	7311616	34746.4	165.1225	1188020.972022161	235099275.0027701	6003.3950761773
	7	3564	21.88	P=2	3564	21.88	12702096	77980.32	478.7344	990696.099390582	209466205.5290859	4685.6186603878
	8	7620	50.19	7620	50.19	58064400	382447.8	2519.0361	418152.7151800555	108512792.4764543	1611.3463603878
	9	8321	42.1	8321	42.1	69239041	350314.1	1772.41	468615.4825484766	94399633.26592799	2326.2852077562
	10	8474	41.16	8474	41.16	71808676	348789.84	1694.1456	470225.221495845	91449962.37119114	2417.8441761773
	11	33022	180.93	33022	180.93	1090452484	5974670.46	32735.6649	1357622.1078116342	224551802.3711911	8208.0738972299
	12	34062	176.89	34062	176.89	1160219844	6025227.18	31290.0721	1387103.2530747917	256802311.84487534	7492.3602551246
	13	36080	178.24	36080	178.24	1301766400	6430899.2	31769.4976	1586136.2678116343	325551748.265928	7727.8904919668
	14	39757	174.79	39757	174.79	1580619049	6949126.029999999	30551.5441	1834441.350443213	471760686.3185595	7133.2248867036
	15	6441	33.86	6441	33.86	41486481	218092.26	1146.4996	654841.4572853186	134465995.37119114	3189.0392288089
	16	14551	93.91	14551	93.91	211731601	1366484.41	8819.0881	-12474.1874515235	12151829.055401668	12.8050972299
	17	18249	91.34	18249	91.34	333026001	1666863.6600000001	8342.9956	213.8383379501	44966.3185595565	1.0169130194
	18	21954	92.29	21954	92.29	481978116	2026134.6600000001	8517.4441	7671.2383379501	15343301.318559552	3.8354130194
	19	62535	272.87	62535	272.87	3910626225	17063925.45	74458.0369	8122604.267285318	1980076688.00277	33320.2751603878
	∑	342702	1716.3	11025313904	52368939.379999995	252978.347	21412126.61157895	4844015966.947369	97942.2580526316
	B0	10.6024031201
	B1	0.0044203254
	r2	0.9663710854	0.9663710854
	SUMMARY OUTPUT
	Regression Statistics
	Multiple R	0.9830417516
	R Square	0.9663710854
	Adjusted R Square	0.964392914
	Standard Error	13.9192879935
	Observations	19
	ANOVA
	df	SS	MS	F	Significance F
	Regression	1	94648.5662224632	94648.5662224632	488.5173564339	0
	Residual	17	3293.6918301683	193.7465782452
	Total	18	97942.2580526316
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95,0%	Upper 95,0%
	Intercept	10.6024031201	4.8176241887	2.2007534637	0.0418625567	0.4381045586	20.7667016815	0.4381045586	20.7667016815
	X Variable 1	0.0044203254	0.0001999927	22.1024287451	0	0.0039983776	0.0048422732	0.0039983776	0.0048422732
	RESIDUAL OUTPUT
	Observation	Predicted Y	Residuals	Standard Residuals
	1	31.6961957268	1.4838042732	0.1096910993
	2	38.9720512655	13.0579487345	0.9653165021
	3	31.5282233632	-26.0682233632	-1.9271086679
	4	34.3970145203	17.5729854797	1.2990932358
	5	116.9598515506	-6.5998515506	-0.4878978883
	6	22.5549628872	-9.7049628872	-0.717445061
	7	26.3564426947	-4.4764426947	-0.3309236459
	8	44.2852823454	5.9047176546	0.4365097082
	9	47.3839304211	-5.2839304211	-0.3906176487
	10	48.0602402008	-6.9002402008	-0.5101042951
	11	156.5703870805	24.3596129195	1.800798641
	12	161.1675254525	15.7224745475	1.1622931321
	13	170.0877420242	8.1522579758	0.6026604418
	14	186.3412783643	-11.5512783643	-0.8539350132
	15	39.0737187487	-5.2137187487	-0.3854272097
	16	74.9225573993	18.9874426007	1.4036578062
	17	91.2689205719	0.0710794281	0.0052545883
	18	107.646226022	-15.356226022	-1.1352179955
	19	287.027449361	-14.157449361	-1.0465977293
p=1,5
	Ad(Km2)	Q(m3/s)	p =	1.5	Ad(Km2) - xi	Q(m3/s) - yi	xi2	xi*yi	yi2	(xi - x)*(yi-y)	(xi - x)^2	(yi-y)^2
	1	4772	33.18	329648.1573556878	191.123712375	108667907648.00027	63003579.611395724	36528.273432	2371608066.854019	7573272336399.16	742680.9142639829
	2	6418	52.03	514161.5180388362	375.3018790614	264362066632.00055	192965783.861025	140851.500427	1739729184.3257055	6591771511939.33	459156.9397259232
	3	4734	5.46	P=1/3	325718.4657092686	12.7581870185	106092518904.00002	4155577.100910214	162.771336	2866549973.1589985	7594916470893.17	1081922.2015290335
	4	5383	51.97	P=1/2	394944.954249323	374.6528798408	155981516886.99985	147967264.48809928	140364.780373	1822255304.2628129	7218147934713.272	460036.8992085311
	5	24061	110.36	P=1	3732248.1347012506	1159.357932071	13929676138980.965	4327011479.423176	1344110.8146559994	69257498.60624303	423335100275.4992	11330.5065185292
	6	2704	12.85	P=1,5	140608.0000000002	46.0632622054	19770609664.000042	6476863.172171652	2121.824125	2961143368.0752425	8649469630039.243	1013746.5557245049
	7	3564	21.88	P=2	212768.1135508795	102.346024212	45270270143.99996	21775970.50101646	10474.708672	2727022847.1208105	8230231203093.08	903577.727673562
	8	7620	50.19	665169.6986483975	355.5705582005	442450727999.9999	236514761.0464549	126430.421859	1685083831.0251415	5839164722244.223	486286.5928007307
	9	8321	42.1	759037.5881081262	273.163798846	576138060161.0015	207341591.03455174	74618.461	1811021101.9905972	5394324339095.92	608008.9415618873
	10	8474	41.16	780068.4075284686	264.0663418461	608506720424.001	205989810.76578307	69731.032896	1815560475.554747	5297075597919.919	622279.1763989495
	11	33022	180.93	6000743.447827769	2433.6934585845	36008921926647.91	14603970075.62226	5922863.850357	4030687617.6627746	8521363048204.068	1906554.4537037483
	12	34062	176.89	6286446.398906783	2352.637	39519408326328.06	14789726396.584858	5534900.853769001	4165407638.9637685	10271001553080.121	1689282.2680505312
	13	36080	178.24	6853300.78954661	2379.6208211024	46967731712000.19	16308257252.082548	5662595.252224004	5003936585.24467	14225681080160.963	1760153.430127844
	14	39757	174.79	7927210.829231988	2310.8665892342	62840671531092.9	18318726651.08791	5340104.393239006	6095545514.708079	23479885511861.688	1582447.0312305097
	15	6441	33.86	516927.8712944385	197.0291259078	267214424120.99957	101849846.63853377	38820.4764559999	2195066915.273327	6577574247476.526	732537.3429841704
	16	14551	93.91	1755251.1290840963	910.055252977	3080906526150.9946	1597375510.3167617	828200.5634710001	189480184.37705004	1759217421307.5212	20408.3587603836
	17	18249	91.34	2465236.5996490116	872.9543047056	6077391492249.021	2152038901.7813487	762049.2181040007	110921094.51179218	379911320270.2823	32385.1608289556
	18	21954	92.29	3252898.3320515887	886.6086600011	10581347558664.008	2884047831.3001723	786074.9159890006	-28486660.802529085	29341040069.910507	27657.1601328658
	19	62535	272.87	15638126.837328527	4507.4787330506	244551010980374.72	70488524144.00546	20317364.52890303	43377325374.207756	157666213855941.47	11934023.850785723
	∑	58550515.2728	20005.3485	466151521015073.7500	146657719290.4244	47138368.6413	85009115915.1210	285721897924985.4000	26074475.5120
B0	136.06138
	B1	0.00030
	r2	0.97000	0.97000
	SUMMARY OUTPUT
	Regression Statistics
	Multiple R	0.9848859585
	R Square	0.9700003513
	Adjusted R Square	0.968235666
	Standard Error	214.5069732105
	Observations	19
	ANOVA
	df	SS	MS	F	Significance F
	Regression	1	25292250.405559633	25292250.405559633	549.6733016477	0
	Residual	17	782225.1064507315	46013.2415559254
	Total	18	26074475.512010366
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95,0%	Upper 95,0%
	Intercept	136.0613817671	62.8573986824	2.1646040819	0.0449393638	3.4438628449	268.6789006892	3.4438628449	268.6789006892
	X Variable 1	0.000297524	0.0000126902	23.4451125322	0	0.0002707499	0.000324298	0.0002707499	0.000324298
	RESIDUAL OUTPUT
	Observation	Predicted Y	Residuals	Standard Residuals
	1	234.139613164	-43.015900789	-0.206347589
	2	289.0367623854	86.265116676	0.4138143922
	3	232.9704356697	-220.2122486512	-1.0563597586
	4	253.566975982	121.0859038588	0.5808499616
	5	1246.4946968577	-87.1367647866	-0.4179956945
	6	177.8956333852	-131.8323711798	-0.6324008435
	7	199.3649974831	-97.0189732711	-0.4654007205
	8	333.9653171192	21.6052410813	0.1036404986
	9	361.8932650775	-88.7294662314	-0.4256358949
	10	368.1504381499	-104.0840963038	-0.4992921671
	11	1921.4264484209	512.2670101636	2.4573485741
	12	2006.429927195	346.207072805	1.6607578466
	13	2175.0827009266	204.5381201758	0.9811708503
	14	2494.5966888604	-183.7300996262	-0.8813546244
	15	289.8598188129	-92.8306929051	-0.4453095091
	16	658.2906815726	251.7645714044	1.2077164804
	17	869.5283837005	3.4259210051	0.016434168
	18	1103.8766363125	-217.2679763114	-1.0422360628
	19	4788.7791001649	-281.3003671143	-1.3493999073
p=2
	Ad(Km2)	Q(m3/s)	p =	2	Ad(Km2) - xi	Q(m3/s) - yi	xi2	xi*yi	yi2	(xi - x)*(yi-y)	(xi - x)^2	(yi-y)^2
	1	4772	33.18	22771984	1100.9124	518563255296256	25069959558.2016	1212008.1124737598	6809252610611.786	310814830160268100	149175382.304684
	2	6418	52.03	41190724	2707.1209	1696675743644176	111508269826.5316	7328503.56721681	5718401694206.654	290616901573230660	112519670.25760078
	3	4734	5.46	P=1/3	22410756	29.8116	502241984491536	668100493.5696	888.73149456	7411198404450.082	311217735425349060	176486927.11890244
	4	5383	51.97	P=1/2	28976689	2700.8809	839648505402721	78262585865.34009	7294757.635984808	5851402554627.626	303934986957035780	112652091.15639825
	5	24061	110.36	P=1	578931721	12179.3296	335161937580021820	7051000245954.241	148336069.50543615	1530364182.1688097	1816991195434.9553	1288952.0521339527
	6	2704	12.85	P=1,5	7311616	165.1225	53459728531456	1207312312.96	27265.44000625	7534259212647.832	328292401398909250	172910069.3207739
	7	3564	21.88	P=2	12702096	478.7344	161343242793216	6080930307.3024	229186.6257433599	7285377864249.205	322144312903356930	164760725.23687634
	8	7620	50.19	58064400	2519.0361	3371474547360000	146266319724.84	6345542.873103209	5637634444014.305	272708797785957920	116545276.068732
	9	8321	42.1	69239041	1772.41	4794044798599681	122719968658.81001	3141437.2081000004	5898553614680.951	261162533848828288	133223300.57268211
	10	8474	41.16	71808676	1694.1456	5156485948872976	121654352487.22559	2870129.3139993595	5908689449183.834	258542761052395808	135036118.8407864
	11	33022	180.93	1090452484	32735.6649	1189086619861770240	35696687105596.62	1071623756.4450922	9908073724966.922	260276290800460832	377175825.8789744
	12	34062	176.89	1160219844	31290.0721	1346110086411384320	36303362570610.74	979068612.023198	10424669347349.918	336330594797088260	323115805.3496173
	13	36080	178.24	1301766400	31769.4976	1694595760168960000	41356464520560.64	1009300977.756406	13314927592483.756	520543088351493950	340581405.7670726
	14	39757	174.79	1580619049	30551.5441	2498356578061664300	48290352580823.555	933396846.8942446	17242743939977.418	1000678854856100220	297110523.65784436
	15	6441	33.86	41486481	1146.4996	1721128105763361	47564233871.90759	1314461.3328001597	6556116584609.655	290298110381212420	148063880.31444636
	16	14551	93.91	211731601	8819.0881	44830270862023200	1867279642773.0479	77776314.91556159	1656830640293.0518	135827685913877680	20210075.377080508
	17	18249	91.34	333026001	8342.9956	110906317342052000	2778434461028.5957	69605575.58161937	1229259797889.8264	61134381362607792	24717345.903043244
	18	21954	92.29	481978116	8517.4441	232302904302909440	4105221660453.316	72546853.99662483	471572823238.9756	9663197319285566	23013182.932087693
	19	62535	272.87	3910626225	74458.0369	15292997471657750000	291177551763157.75	5543999259.001762	203628667889346.66	11091208115402443000	3738513780.911531
	∑	11025313904.0000	252978.3470	22763163012109290000.0000	469287356584065.2000	9935418446.9609	322489162553010.6000	16365397397281098000.0000	6567100339.0213
	B0	1879.91940
	B1	0.00002
	r2	0.96768	0.96768
	SUMMARY OUTPUT
	Regression Statistics
	Multiple R	0.9837053213
	R Square	0.9676761592
	Adjusted R Square	0.9657747568
	Standard Error	3533.6525527723
	Observations	19
	ANOVA
	df	SS	MS	F	Significance F
	Regression	1	6354826432.838122	6354826432.838122	508.9275987838	0
	Residual	17	212273906.18314555	12486700.363714444
	Total	18	6567100339.021268
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95,0%	Upper 95,0%
	Intercept	1879.9194023025	956.0928515502	1.9662519171	0.065816647	-137.2601897532	3897.0989943582	-137.2601897532	3897.0989943582
	X Variable 1	0.0000197056	0.0000008735	22.5594237246	0	0.0000178626	0.0000215485	0.0000178626	0.0000215485
	RESIDUAL OUTPUT
	Observation	Predicted Y	Residuals	Standard Residuals
	1	2328.653879783	-1227.741479783	-0.3575155003
	2	2691.6052883977	15.5156116023	0.0045181105
	3	2321.5356832381	-2291.7240832381	-0.6673447917
	4	2450.9210066217	249.9598933783	0.0727877471
	5	13288.0875847434	-1108.7579847434	-0.3228677797
	6	2023.9988195943	-1858.8763195943	-0.5413005167
	7	2130.2211946921	-1651.4867946921	-0.4809091632
	8	3024.1103605529	-505.0742605529	-0.1470764651
	9	3244.3128115193	-1471.9028115193	-0.4286147195
	10	3294.9488834154	-1600.8032834154	-0.466150241
	11	23367.885739584	9367.779160416	2.7278757851
	12	24742.6899654607	6547.3821345393	1.9065826462
	13	27531.9427528258	4237.5548471742	1.233966243
	14	33026.8876703649	-2475.3435703649	-0.7208143648
	15	2697.4333428551	-1550.9337428551	-0.4516283453
	16	6052.2071283459	2766.8809716541	0.8057093868
	17	8442.3800357797	-99.3844357797	-0.0289405195
	18	11377.5634389539	-2860.1193389539	-0.8328601853
	19	78940.9614132721	-4482.9245132721	-1.3054173264