Correlação e Regressão

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

Exemplo
	xi	yi	xi*yi	xi²	yi²
	0	2160	0	0	4665600
	50	2880	144000	2500	8294400
	100	3360	336000	10000	11289600
	150	3720	558000	22500	13838400
	200	4020	804000	40000	16160400
	500	16140	1842000	75000	54248400
	1140000
	1158792.4749496779
	0.9837827088
	9.12	b
	2316	a
	y=a+bx	y = 2316 + 9,12x
	xi	yi	Y = 2316 + 9,12x	ei=yi-Yi
	0	2160	2316	-156
	50	2880	2772	108
	100	3360	3228	132
	150	3720	3684	36
	200	4020	4140	-120
	Yi	Yi-ý	(Yi-ý)²	yi	yi-ý	(yi-ý)²
	2316	-912	831744	2160	-1068	1140624
	2772	-456	207936	2880	-348	121104	ý
	3228	0	0	3360	132	17424	3228
	3684	456	207936	3720	492	242064
	4140	912	831744	4020	792	627264
	2079360	2148480
	0.9678284182
1
	xi	yi	xi*yi	xi²	yi²
	250	160	40000	62500	25600
	241	170	40970	58081	28900
	340	166	56440	115600	27556
	215	170	36550	46225	28900
	222	170	37740	49284	28900
	218	173	37714	47524	29929
	200	180	36000	40000	32400
	199	181	36019	39601	32761
	197	195	38415	38809	38025
	2082	1565	359848	497624	272971
	-19698
	32881.674044975269
	-0.599057091
	-0.1368943374	b
	205.56	a
	Y=a+bx	Y = 205,55-0,1369x
	xi	yi	Y = 205,55-0,1369x	ei=yi-Yi
	250	160	239.78	-79.78
	241	170	238.55	-68.55
	340	166	252.10	-86.10
	215	170	234.99	-64.99
	222	170	235.95	-65.95
	218	173	235.40	-62.40
	200	180	232.94	-52.94
	199	181	232.80	-51.80
	197	195	232.53	-37.53
	Yi	Yi-ý	(Yi-ý)²	yi	yi-ý	(yi-ý)²
	239.78	65.89	4341.7303278642	160	-13.89	192.90
	238.55	64.66	4180.8843961664	170	-3.89	15.12	ý
	252.10	78.21	6117.1635760344	166	-7.89	62.23	173.89
	234.99	61.10	3733.2718255138	170	-3.89	15.12
	235.95	62.06	3851.2904742988	170	-3.89	15.12
	235.40	61.51	3783.6263657063	173	-0.89	0.79
	232.94	59.05	3486.5589406483	180	6.11	37.35
	232.80	58.91	3470.4112559444	181	7.11	50.57
	232.53	58.64	3438.2283268945	195	21.11	445.68
	36403.17	834.89
	43.60
2
	xi	yi	xi*yi	xi²	yi²
	2	80	160	4	6400
	3	92	276	9	8464
	6	95	570	36	9025
	7	96	672	49	9216
	8	100	800	64	10000
	8	105	840	64	11025
	9	110	990	81	12100
	10	115	1150	100	13225
	11	105	1155	121	11025
	13	120	1560	169	14400
	16	125	2000	256	15625
	93	1143	10173	953	120505
	5604
	5919.49
	0.95
	3.0556	b
	78.075	a
	Y=a+bx	Y = 78,075 + 3,0556x
	xi	yi	Y = 78,075 + 3,0556x	ei=yi-Yi
	2	80	84.19	-4.19
	3	92	87.24	4.76
	6	95	96.41	-1.41
	7	96	99.46	-3.46
	8	100	102.52	-2.52
	8	105	102.52	2.48
	9	110	105.58	4.42
	10	115	108.63	6.37
	11	105	111.69	-6.69
	13	120	117.80	2.20
	16	125	126.97	-1.97
	Yi	Yi-ý	(Yi-ý)²	yi	yi-ý	(yi-ý)²
	84.19	-19.72	388.98	80	-23.91	571.64
	87.24	-16.67	277.79	92	-11.91	141.83	ý
	96.41	-7.50	56.25	95	-8.91	79.37	103.91
	99.46	-4.44	19.75	96	-7.91	62.55
	102.52	-1.39	1.93	100	-3.91	15.28
	102.52	-1.39	1.93	105	1.09	1.19
	105.58	1.67	2.78	110	6.09	37.10
	108.63	4.72	22.30	115	11.09	123.01
	111.69	7.78	60.50	105	1.09	1.19
	117.80	13.89	192.91	120	16.09	258.92
	126.97	23.06	531.58	125	21.09	444.83
	1556.70	1736.91
	0.90
3
	xi	yi	xi*yi	xi²	yi²
	230	5.2	1196	52900	27.04
	90	1.8	162	8100	3.24
	130	3.4	442	16900	11.56
	450	5.8	2610	202500	33.64
	200	3.0	600	40000	9
	340	6.0	2040	115600	36
	300	7.0	2100	90000	49
	490	9.2	4508	240100	84.64
	180	5.2	936	32400	27.04
	2410	46.6	14594	798500	281.16
	19039.999999999985
	22241.41
	0.86
	0.0138	b
	1.4789	a
	Y=a+bx	Y = 1,4789 + 0,0138x
	xi	yi	Y = 1,4789 + 0,0138x	ei=yi-Yi
	230	5.2	4.66	0.54
	90	1.8	2.72	-0.92
	130	3.4	3.27	0.13
	450	5.8	7.69	-1.89
	200	3.0	4.24	-1.24
	340	6.0	6.18	-0.18
	300	7.0	5.62	1.38
	490	9.2	8.25	0.95
	180	5.2	3.97	1.23
	Yi	Yi-ý	(Yi-ý)²	yi	yi-ý	(yi-ý)²
	4.66	-0.52	0.27	5.2	0.02	0.0005
	2.72	-2.46	6.03	1.8	-3.38	11.41	ý
	3.27	-1.90	3.62	3.4	-1.78	3.16	5.18
	7.69	2.52	6.34	5.8	0.62	0.39
	4.24	-0.94	0.88	3.0	-2.18	4.74
	6.18	1.00	1.00	6.0	0.82	0.68
	5.62	0.45	0.20	7.0	1.82	3.32
	8.25	3.07	9.42	9.2	4.02	16.18
	3.97	-1.21	1.47	5.2	0.02	0.0005
	29.22	39.88
	0.73
4
	xi	yi	xi*yi	xi²	yi²
	42	27	1134	1764	729
	50	24	1200	2500	576
	42	30	1260	1764	900
	50	20	1000	2500	400
	40	34	1360	1600	1156
	35	40	1400	1225	1600
	48	28	1344	2304	784
	35	38	1330	1225	1444
	342	241	10028	14882	7589
	-2198
	2346.07
	-0.94
	-1.0507	b
	75.041	a
	Y=a+bx	Y = 75,041-1,0507x
	xi	yi	Y = 75,041-1,0507x	ei=yi-Yi
	42	27	30.91	-3.91
	50	24	22.51	1.49
	42	30	30.91	-0.91
	50	20	22.51	-2.51
	40	34	33.01	0.99
	35	40	38.27	1.73
	48	28	24.61	3.39
	35	38	38.27	-0.27
	Yi	Yi-ý	(Yi-ý)²	yi	yi-ý	(yi-ý)²
	30.91	0.79	0.62	27	-3.13	9.77
	22.51	-7.62	58.02	24	-6.13	37.52	ý
	30.91	0.79	0.62	30	-0.13	0.02	30.13
	22.51	-7.62	58.02	20	-10.13	102.52
	33.01	2.89	8.35	34	3.88	15.02
	38.27	8.14	66.30	40	9.88	97.52
	24.61	-5.52	30.43	28	-2.13	4.52
	38.27	8.14	66.30	38	7.88	62.02
	288.67	328.88
	0.88