Resolucao atividade 5

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

Dados
	Cidade	% de motoristas habilitados com menos de 21 (x)	Acidentes fatais por mil CNH (y)	xi - mediax	(xi-mediax)^2	yi - mediay	(yi - mediay)^2	D * F	Ŷ	(yi - Ŷ)^2	(Ŷ-mediay)^2
	1	13	2.962	0.7380952381	0.5447845805	1.0395952381	1.0807582591	0.7673202948	2.1342773403	0.6851248014	0.0448899895	media de x	12.2619047619
	2	12	0.708	-0.2619047619	0.0685941043	-1.2144047619	1.4747789257	0.31805839	1.8472241696	1.2978317086	0.0056521215	desvio padrão de x	3.1317378002
	3	8	0.885	-4.2619047619	18.1638321995	-1.0374047619	1.07620864	4.4213202948	0.6990114868	0.0345917271	1.4966911057	media de y	1.9224047619
	4	12	1.652	-0.2619047619	0.0685941043	-0.2704047619	0.0731187353	0.0708202948	1.8472241696	0.0381124764	0.0056521215	desvio padrão de y	1.0709896053
	5	11	2.091	-1.2619047619	1.5924036281	0.1685952381	0.0284243543	-0.2127511338	1.5601709989	0.2817794284	0.1312132991	pearson xy	0.8393874795
	6	17	2.627	4.7380952381	22.4495464853	0.7045952381	0.4964544495	3.3384393424	3.2824900231	0.4296671704	1.8498319177
	7	18	3.83	5.7380952381	32.9257369615	1.9075952381	3.6389195924	10.9459631519	3.5695431938	0.0678377479	2.7130650138
	8	8	0.368	-4.2619047619	18.1638321995	-1.5544047619	2.4161741638	6.6247250567	0.6990114868	0.1095686044	1.4966911057
	9	13	1.142	0.7380952381	0.5447845805	-0.7804047619	0.6090315924	-0.5760130385	2.1342773403	0.98461432	0.0448899895
	10	8	0.645	-4.2619047619	18.1638321995	-1.2774047619	1.6317629257	5.4441774376	0.6990114868	0.0029172407	1.4966911057
	11	9	1.028	-3.2619047619	10.6400226757	-0.8944047619	0.7999598781	2.9174631519	0.9860646575	0.001758573	0.8767327912
	12	16	2.801	3.7380952381	13.9733560091	0.8785952381	0.7719295924	3.2842726757	2.9954368524	0.0378056896	1.1513978672	b1	0.2870531707	0.2870531707
	13	12	1.405	-0.2619047619	0.0685941043	-0.5174047619	0.2677076876	0.135510771	1.8472241696	0.1955622162	0.0056521215	b0	-1.5974138789
	14	9	1.433	-3.2619047619	10.6400226757	-0.4894047619	0.239517021	1.5963917234	0.9860646575	0.1997512004	0.8767327912
	15	10	0.039	-2.2619047619	5.1162131519	-1.8834047619	3.5472134972	4.2600821995	1.2731178282	1.5230468138	0.4215735223	R^2	0.7045713408	0.7045713408
	16	9	0.338	-3.2619047619	10.6400226757	-1.5844047619	2.5103384495	5.1681774376	0.9860646575	0.4199878003	0.8767327912
	17	11	1.849	-1.2619047619	1.5924036281	-0.0734047619	0.0053882591	0.0926298186	1.5601709989	0.0834221919	0.1312132991
	18	12	2.246	-0.2619047619	0.0685941043	0.3235952381	0.1047138781	-0.0847511338	1.8472241696	0.1590221629	0.0056521215	AS RESPOSTAS DEFINITIVAS ESTÃO 
	19	14	2.855	1.7380952381	3.0209750567	0.9325952381	0.8697338781	1.6209393424	2.421330511	0.1880692257	0.2489269031	NO PRÓXIMO WORKSHEET
	20	14	2.352	1.7380952381	3.0209750567	0.4295952381	0.1845520686	0.7466774376	2.421330511	0.0048067198	0.2489269031
	21	11	1.294	-1.2619047619	1.5924036281	-0.6284047619	0.3948925448	0.7929869615	1.5601709989	0.0708470006	0.1312132991
	22	17	4.1	4.7380952381	22.4495464853	2.1775952381	4.741921021	10.3176536281	3.2824900231	0.6683225623	1.8498319177
	23	8	2.19	-4.2619047619	18.1638321995	0.2675952381	0.0716072115	-1.1404654195	0.6990114868	2.2230467466	1.4966911057
	24	16	3.623	3.7380952381	13.9733560091	1.7005952381	2.8920241638	6.3569869615	2.9954368524	0.3938355042	1.1513978672
	25	15	2.623	2.7380952381	7.4971655329	0.7005952381	0.4908336876	1.9182964853	2.7083836817	0.0072903731	0.6177628623
	26	9	0.835	-3.2619047619	10.6400226757	-1.0874047619	1.1824491162	3.547010771	0.9860646575	0.0228205307	0.8767327912
	27	8	0.82	-4.2619047619	18.1638321995	-1.1024047619	1.2152962591	4.6983441043	0.6990114868	0.0146382203	1.4966911057
	28	14	2.89	1.7380952381	3.0209750567	0.9675952381	0.9362405448	1.6817726757	2.421330511	0.2196510899	0.2489269031
	29	8	1.267	-4.2619047619	18.1638321995	-0.6554047619	0.4295554019	2.7932726757	0.6990114868	0.3226109512	1.4966911057
	30	15	3.224	2.7380952381	7.4971655329	1.3015952381	1.6941501638	3.5638917234	2.7083836817	0.2658601877	0.6177628623
	31	10	1.014	-2.2619047619	5.1162131519	-0.9084047619	0.8251992115	2.0547250567	1.2731178282	0.0671420489	0.4215735223
	32	10	0.493	-2.2619047619	5.1162131519	-1.4294047619	2.0431979734	3.2331774376	1.2731178282	0.6085838258	0.4215735223
	33	14	1.443	1.7380952381	3.0209750567	-0.4794047619	0.2298289257	-0.8332511338	2.421330511	0.9571305887	0.2489269031
	34	18	3.614	5.7380952381	32.9257369615	1.6915952381	2.8614944495	9.7065345805	3.5695431938	0.0019764076	2.7130650138
	35	10	1.926	-2.2619047619	5.1162131519	0.0035952381	0.0000129257	-0.0081320862	1.2731178282	0.4262551303	0.4215735223
	36	14	1.643	1.7380952381	3.0209750567	-0.2794047619	0.078067021	-0.4856320862	2.421330511	0.6057983843	0.2489269031
	37	16	2.943	3.7380952381	13.9733560091	1.0205952381	1.04161464	3.8150821995	2.9954368524	0.0027496235	1.1513978672
	38	12	1.913	-0.2619047619	0.0685941043	-0.0094047619	0.0000884495	0.0024631519	1.8472241696	0.0043264599	0.0056521215
	39	15	2.814	2.7380952381	7.4971655329	0.8915952381	0.7949420686	2.4412726757	2.7083836817	0.0111548067	0.6177628623
	40	13	2.634	0.7380952381	0.5447845805	0.7115952381	0.5063677829	0.5252250567	2.1342773403	0.2497227366	0.0448899895
	41	9	0.926	-3.2619047619	10.6400226757	-0.9964047619	0.9928224495	3.2501774376	0.9860646575	0.0036077631	0.8767327912
	42	17	3.256	4.7380952381	22.4495464853	1.3335952381	1.7784762591	6.3187012472	3.2824900231	0.0007017213	1.8498319177
	Σ	402.11904761904782	47.027768119	115.429547619	13.8933504822	33.1344176368
Respostas
	a)
	Uma simples análise visual já nos mostra que existe uma correlação positiva entre
	a % de motoristas abaixo de 21 anos e o número de acidentes fatais numa cidade
	b)
	equação de regressão
	Ŷ = -1,597 + 0,287 * X
	c)
	R² = 0,705
	d)
	Dada a natureza do estudo, o R² de 0,7 é um valor bastante razoável
	e nos permite concluir que o modelo calculado é adequado