Base de datos Proyecto Integrador 1
Enviado por elizuriel538 • 11 de Febrero de 2018 • Apuntes • 1.054 Palabras (5 Páginas) • 210 Visitas
Resumen | ||||||||
Estadísticas de la regresión | ||||||||
Coeficiente de correlación múltiple | 0.07318861 | |||||||
Coeficiente de determinación R^2 | 0.00535657 | |||||||
R^2 ajustado | -0.0002313 | |||||||
Error típico | 0.89957656 | |||||||
Observaciones | 180 | |||||||
ANÁLISIS DE VARIANZA | ||||||||
| Grados de libertad | Suma de cuadrados | Promedio de los cuadrados | F | Valor crítico de F | |||
Regresión | 1 | 0.77573943 | 0.77573943 | 0.95860482 | 0.32886746 | |||
Residuos | 178 | 144.04436 | 0.80923798 | |||||
Total | 179 | 144.8201 |
|
|
| |||
| Coeficientes | Error típico | Estadístico t | Probabilidad | Inferior 95% | Superior 95% | Inferior 95.0% | Superior 95.0% |
Intercepción | 90.5562926 | 1.09877798 | 82.4154597 | 1.046E-143 | 88.3879852 | 92.7246001 | 88.3879852 | 92.7246001 |
Variable X 1 | 0.00084389 | 0.00086192 | 0.97908367 | 0.32886746 | -0.000857 | 0.00254479 | -0.000857 | 0.00254479 |
Análisis de los residuales | Resultados de datos de probabilidad | |||||||
Observación | Pronóstico para Y | Residuos | Residuos estándares | Percentil | Y | |||
1 | 91.6909038 | -0.1589038 | -0.1771383 | 0.27777778 | 90.003 | |||
2 | 91.7288535 | 0.42614647 | 0.47504777 | 0.83333333 | 90.064 | |||
3 | 91.6071307 | -0.7981307 | -0.8897181 | 1.38888889 | 90.102 | |||
4 | 91.7208619 | -0.1278619 | -0.1425343 | 1.94444444 | 90.11 | |||
5 | 91.4884459 | -0.6114459 | -0.6816108 | 2.5 | 90.126 | |||
6 | 91.5166403 | 1.23035968 | 1.37154631 | 3.05555556 | 90.131 | |||
7 | 91.6795112 | 0.24948877 | 0.27811818 | 3.61111111 | 90.134 | |||
8 | 91.7022963 | 1.25870372 | 1.40314289 | 4.16666667 | 90.246 | |||
9 | 91.6938574 | 1.29914262 | 1.44822226 | 4.72222222 | 90.264 | |||
10 | 91.6525067 | 0.83849327 | 0.93471232 | 5.27777778 | 90.347 | |||
11 | 91.6010294 | 1.14597061 | 1.2774734 | 5.83333333 | 90.356 | |||
12 | 91.7345582 | 0.16144177 | 0.17996759 | 6.38888889 | 90.359 | |||
13 | 91.6989207 | 1.28607928 | 1.43365986 | 6.94444444 | 90.37 | |||
14 | 91.7114947 | -0.1404947 | -0.1566168 | 7.5 | 90.371 | |||
15 | 91.5453326 | 0.8236674 | 0.91818514 | 8.05555556 | 90.373 | |||
16 | 91.5225476 | 0.32945245 | 0.36725788 | 8.61111111 | 90.38 | |||
17 | 91.7006085 | -0.9266085 | -1.032939 | 9.16666667 | 90.395 | |||
18 | 91.5833077 | 1.38369231 | 1.54247422 | 9.72222222 | 90.396 | |||
19 | 91.519172 | -0.116172 | -0.129503 | 10.2777778 | 90.415 | |||
20 | 91.5352059 | -0.1422059 | -0.1585244 | 10.8333333 | 90.456 | |||
21 | 91.4862603 | 0.12073975 | 0.13459492 | 11.3888889 | 90.481 | |||
22 | 91.5699742 | -0.5799742 | -0.6465276 | 11.9444444 | 90.482 | |||
23 | 91.673604 | 0.020396 | 0.02273649 | 12.5 | 90.498 | |||
24 | 91.5352059 | -0.6272059 | -0.6991792 | 13.0555556 | 90.503 | |||
25 | 91.6153755 | -0.8843755 | -0.9858597 | 13.6111111 | 90.517 | |||
26 | 91.7073596 | -1.0483596 | -1.1686613 | 14.1666667 | 90.541 | |||
27 | 91.7092584 | 0.11374162 | 0.12679373 | 14.7222222 | 90.583 | |||
28 | 91.5402693 | 0.16473074 | 0.18363398 | 15.2777778 | 90.59 | |||
29 | 91.4987498 | 0.91225017 | 1.01693299 | 15.8333333 | 90.63 | |||
30 | 91.6474434 | -0.1554434 | -0.1732809 | 16.3888889 | 90.644 | |||
31 | 91.7225497 | -1.0785497 | -1.2023157 | 16.9444444 | 90.653 | |||
32 | 91.6156287 | -0.5776287 | -0.6439129 | 17.5 | 90.659 | |||
33 | 91.6516628 | -1.1956628 | -1.3328679 | 18.0555556 | 90.659 | |||
34 | 91.7073596 | -1.0483596 | -1.1686613 | 18.6111111 | 90.663 | |||
35 | 91.5402693 | -0.8772693 | -0.9779379 | 19.1666667 | 90.696 | |||
36 | 91.7031402 | -0.6461402 | -0.7202863 | 19.7222222 | 90.697 | |||
37 | 91.7082035 | -0.3202035 | -0.3569476 | 20.2777778 | 90.731 | |||
38 | 91.6533506 | -0.5903506 | -0.6580947 | 20.8333333 | 90.736 | |||
39 | 91.5875271 | -0.8905271 | -0.9927172 | 21.3888889 | 90.746 | |||
40 | 91.6381606 | -1.5041606 | -1.6767665 | 21.9444444 | 90.755 | |||
41 | 91.5056697 | 1.66133026 | 1.85197177 | 22.5 | 90.774 | |||
42 | 91.6719162 | 0.87208378 | 0.97215742 | 23.0555556 | 90.785 | |||
43 | 91.6156793 | 1.28232066 | 1.42946994 | 23.6111111 | 90.793 | |||
44 | 91.5697126 | 0.34528739 | 0.38490992 | 24.1666667 | 90.809 | |||
45 | 91.7133513 | 0.77864875 | 0.8680005 | 24.7222222 | 90.861 | |||
46 | 91.7411153 | 0.69988474 | 0.78019814 | 25.2777778 | 90.876 | |||
47 | 91.7385836 | 1.26441641 | 1.40951113 | 25.8333333 | 90.877 | |||
48 | 91.7444908 | -1.6804908 | -1.873331 | 26.3888889 | 90.905 | |||
49 | 91.7402714 | -1.1502714 | -1.2822677 | 26.9444444 | 90.908 | |||
50 | 91.6474434 | -1.5374434 | -1.7138686 | 27.5 | 90.954 | |||
51 | 91.5605226 | -1.0625226 | -1.1844496 | 28.0555556 | 90.954 | |||
52 | 91.5208598 | -1.0178598 | -1.1346615 | 28.6111111 | 90.98 | |||
53 | 91.6192574 | 0.22174257 | 0.24718804 | 29.1666667 | 90.99 | |||
54 | 91.5335181 | -0.3515181 | -0.3918557 | 29.7222222 | 91.038 | |||
55 | 91.6073755 | -0.0513755 | -0.0572709 | 30.2777778 | 91.047 | |||
56 | 91.7282712 | -1.3812712 | -1.5397753 | 30.8333333 | 91.057 | |||
57 | 91.6195697 | 0.08343033 | 0.09300415 | 31.3888889 | 91.063 | |||
58 | 91.5605226 | -1.1655226 | -1.2992691 | 31.9444444 | 91.064 | |||
59 | 91.6990895 | 0.0149105 | 0.01662152 | 32.5 | 91.073 | |||
60 | 91.6725913 | -0.0105913 | -0.0118067 | 33.0555556 | 91.15 | |||
61 | 91.6276963 | -1.2716963 | -1.4176265 | 33.6111111 | 91.169 | |||
62 | 91.5871474 | -0.3081474 | -0.343508 | 34.1666667 | 91.182 | |||
63 | 91.6227596 | -0.2317596 | -0.2583545 | 34.7222222 | 91.212 | |||
64 | 91.630228 | 1.47877199 | 1.64846451 | 35.2777778 | 91.219 | |||
65 | 91.5721261 | -1.5691261 | -1.749187 | 35.8333333 | 91.22 | |||
66 | 91.5284801 | -0.3594801 | -0.4007313 | 36.3888889 | 91.224 | |||
67 | 91.7121529 | -0.5001529 | -0.5575466 | 36.9444444 | 91.243 | |||
68 | 91.6297217 | -0.8367217 | -0.9327374 | 37.5 | 91.243 | |||
69 | 91.5384633 | -0.6774633 | -0.7552038 | 38.0555556 | 91.245 | |||
70 | 91.6492831 | -0.7732831 | -0.8620191 | 38.6111111 | 91.25 | |||
71 | 91.619595 | -1.517595 | -1.6917425 | 39.1666667 | 91.279 | |||
72 | 91.5760165 | 0.31598353 | 0.35224337 | 39.7222222 | 91.304 | |||
73 | 91.6181604 | 0.34183962 | 0.38106651 | 40.2777778 | 91.315 | |||
74 | 91.7228197 | 1.00918029 | 1.12498607 | 40.8333333 | 91.331 | |||
75 | 91.5594762 | 0.70452379 | 0.78536953 | 41.3888889 | 91.361 | |||
76 | 91.675123 | 0.191877 | 0.21389533 | 41.9444444 | 91.381 | |||
77 | 91.675123 | -0.920123 | -1.0257093 | 42.5 | 91.388 | |||
78 | 91.4922434 | -0.7462434 | -0.8318766 | 43.0555556 | 91.391 | |||
79 | 91.541611 | -0.845611 | -0.9426469 | 43.6111111 | 91.393 | |||
80 | 91.541611 | -1.182611 | -1.3183184 | 44.1666667 | 91.403 | |||
81 | 91.6419328 | -0.4919328 | -0.5483832 | 44.7222222 | 91.469 | |||
82 | 91.6934017 | -1.1764017 | -1.3113965 | 45.2777778 | 91.492 | |||
83 | 91.6280086 | -1.2320086 | -1.3733844 | 45.8333333 | 91.53 | |||
84 | 91.4983701 | -0.5443701 | -0.6068378 | 46.3888889 | 91.532 | |||
85 | 91.7291236 | -1.3141236 | -1.4649223 | 46.9444444 | 91.556 | |||
86 | 91.7401532 | -1.4761532 | -1.6455452 | 47.5 | 91.561 | |||
87 | 91.7433009 | -1.6123009 | -1.7973162 | 48.0555556 | 91.571 | |||
88 | 91.7120348 | -0.3970348 | -0.4425954 | 48.6111111 | 91.572 | |||
89 | 91.597291 | 1.58170904 | 1.76321383 | 49.1666667 | 91.587 | |||
90 | 91.511155 | 1.43184497 | 1.59615251 | 49.7222222 | 91.593 | |||
91 | 91.5981264 | 0.01187359 | 0.01323611 | 50.2777778 | 91.607 | |||
92 | 91.5216108 | -1.1506108 | -1.2826461 | 50.8333333 | 91.61 | |||
93 | 91.7099504 | -0.6629504 | -0.7390255 | 51.3888889 | 91.625 | |||
94 | 91.5946665 | 0.30033354 | 0.33479751 | 51.9444444 | 91.655 | |||
95 | 91.5177205 | -0.2987205 | -0.3329994 | 52.5 | 91.662 | |||
96 | 91.5366237 | -1.1636237 | -1.2971522 | 53.0555556 | 91.692 | |||
97 | 91.734111 | -0.489111 | -0.5452376 | 53.6111111 | 91.694 | |||
98 | 91.5292734 | -0.9882734 | -1.10168 | 54.1666667 | 91.694 | |||
99 | 91.6752918 | 1.26270822 | 1.40760692 | 54.7222222 | 91.703 | |||
100 | 91.7360519 | 0.32494809 | 0.36223663 | 55.2777778 | 91.705 | |||
101 | 91.7031402 | 1.33885982 | 1.4924971 | 55.8333333 | 91.714 | |||
102 | 91.6761357 | 0.28086433 | 0.31309416 | 56.3888889 | 91.743 | |||
103 | 91.573181 | 1.235819 | 1.3776321 | 56.9444444 | 91.751 | |||
104 | 91.6153755 | -0.9623755 | -1.0728104 | 57.5 | 91.761 | |||
105 | 91.5849955 | 0.17600453 | 0.19620146 | 58.0555556 | 91.823 | |||
106 | 91.5710038 | -1.0900038 | -1.2150842 | 58.6111111 | 91.83 | |||
107 | 91.6069366 | -1.3609366 | -1.5171073 | 59.1666667 | 91.841 | |||
108 | 91.720018 | -0.766018 | -0.8539203 | 59.7222222 | 91.848 | |||
109 | 91.6398484 | -1.2698484 | -1.4155664 | 60.2777778 | 91.852 | |||
110 | 91.6440678 | 0.04993218 | 0.05566201 | 60.8333333 | 91.854 | |||
111 | 91.580776 | -0.950776 | -1.0598798 | 61.3888889 | 91.863 | |||
112 | 91.5352059 | -0.9522059 | -1.0614738 | 61.9444444 | 91.867 | |||
113 | 91.7284569 | -1.3484569 | -1.5031955 | 62.5 | 91.892 | |||
114 | 91.7267691 | 0.10323088 | 0.11507687 | 63.0555556 | 91.895 | |||
115 | 91.6314095 | -0.1014095 | -0.1130464 | 63.6111111 | 91.896 | |||
116 | 91.588371 | -0.027371 | -0.0305119 | 64.1666667 | 91.911 | |||
117 | 91.7082035 | -1.5822035 | -1.763765 | 64.7222222 | 91.915 | |||
118 | 91.5250792 | 0.32292077 | 0.35997668 | 65.2777778 | 91.929 | |||
119 | 91.5368937 | 0.3171063 | 0.35349499 | 65.8333333 | 91.957 | |||
120 | 91.7141108 | 1.14488925 | 1.27626795 | 66.3888889 | 91.96 | |||
121 | 91.5976538 | -0.8616538 | -0.9605306 | 66.9444444 | 91.979 | |||
122 | 91.6145316 | 0.89146835 | 0.99376642 | 67.5 | 92.061 | |||
123 | 91.7174863 | 0.60851368 | 0.67834204 | 68.0555556 | 92.155 | |||
124 | 91.5478643 | -0.0788643 | -0.0879141 | 68.6111111 | 92.164 | |||
125 | 91.6406923 | 0.81430774 | 0.90775145 | 69.1666667 | 92.202 | |||
126 | 91.7174863 | 1.28151368 | 1.42857035 | 69.7222222 | 92.205 | |||
127 | 91.6330972 | -0.0080972 | -0.0090264 | 70.2777778 | 92.264 | |||
128 | 91.64238 | -1.16038 | -1.2935363 | 70.8333333 | 92.311 | |||
129 | 91.6212828 | 1.27771723 | 1.42433825 | 71.3888889 | 92.313 | |||
130 | 91.6330972 | -0.7280972 | -0.8116481 | 71.9444444 | 92.326 | |||
131 | 91.6148354 | -0.5418354 | -0.6040123 | 72.5 | 92.357 | |||
132 | 91.6148354 | 1.19316455 | 1.33008296 | 73.0555556 | 92.369 | |||
133 | 91.6508189 | 0.55118105 | 0.61443036 | 73.6111111 | 92.384 | |||
134 | 91.6179072 | 0.76609279 | 0.85400372 | 74.1666667 | 92.411 | |||
135 | 91.6179072 | 1.38709279 | 1.54626491 | 74.7222222 | 92.422 | |||
136 | 91.6288778 | 1.33712221 | 1.49056009 | 75.2777778 | 92.441 | |||
137 | 91.647975 | -0.404975 | -0.4514469 | 75.8333333 | 92.455 | |||
138 | 91.6183629 | 0.12463709 | 0.13893949 | 76.3888889 | 92.485 | |||
139 | 91.619595 | -0.639595 | -0.71299 | 76.9444444 | 92.491 | |||
140 | 91.619595 | 0.07240501 | 0.08071365 | 77.5 | 92.492 | |||
141 | 91.6350888 | 0.56991118 | 0.63530981 | 78.0555556 | 92.506 | |||
142 | 91.6204389 | 0.69256112 | 0.77203412 | 78.6111111 | 92.544 | |||
143 | 91.6139662 | 0.69703376 | 0.77702 | 79.1666667 | 92.592 | |||
144 | 91.6204389 | 1.27056112 | 1.41636096 | 79.7222222 | 92.647 | |||
145 | 91.6229706 | 1.15602945 | 1.28868651 | 80.2777778 | 92.656 | |||
146 | 91.6148354 | -0.5508354 | -0.6140451 | 80.8333333 | 92.663 | |||
147 | 91.6142447 | -0.2532447 | -0.2823051 | 81.3888889 | 92.671 | |||
148 | 91.6156793 | 0.24732066 | 0.27570128 | 81.9444444 | 92.732 | |||
149 | 91.6148101 | -0.3648101 | -0.4066729 | 82.5 | 92.747 | |||
150 | 91.6381606 | 1.28283941 | 1.43004822 | 83.0555556 | 92.747 | |||
151 | 91.6339411 | -0.4099411 | -0.4569828 | 83.6111111 | 92.757 | |||
152 | 91.6229706 | -0.0359706 | -0.0400983 | 84.1666667 | 92.779 | |||
153 | 91.6190887 | -0.2880887 | -0.3211475 | 84.7222222 | 92.808 | |||
154 | 91.6243377 | 1.48666234 | 1.6572603 | 85.2777778 | 92.809 | |||
155 | 91.6372407 | 1.23175925 | 1.37310649 | 85.8333333 | 92.841 | |||
156 | 91.6316879 | -0.3886879 | -0.4332908 | 86.3888889 | 92.859 | |||
157 | 91.6209537 | -0.4009537 | -0.446964 | 86.9444444 | 92.869 | |||
158 | 91.6130464 | 0.1379536 | 0.1537841 | 87.5 | 92.891 | |||
159 | 91.6231225 | 1.13387755 | 1.26399263 | 88.0555556 | 92.893 | |||
160 | 91.6135696 | 1.04243039 | 1.1620517 | 88.6111111 | 92.898 | |||
161 | 91.6351057 | 1.2578943 | 1.40224059 | 89.1666667 | 92.899 | |||
162 | 91.6272238 | 1.03577624 | 1.15463397 | 89.7222222 | 92.921 | |||
163 | 91.6226752 | 0.73432481 | 0.81859029 | 90.2777778 | 92.938 | |||
164 | 91.6339411 | -0.2529411 | -0.2819667 | 90.8333333 | 92.943 | |||
165 | 91.6345825 | 1.47541751 | 1.6447251 | 91.3888889 | 92.961 | |||
166 | 91.6279242 | 0.85707581 | 0.95542725 | 91.9444444 | 92.966 | |||
167 | 91.6235528 | 0.79844716 | 0.89007083 | 92.5 | 92.967 | |||
168 | 91.6280086 | 1.04299142 | 1.16267711 | 93.0555556 | 92.985 | |||
169 | 91.6343209 | 0.27667912 | 0.30842869 | 93.6111111 | 92.993 | |||
170 | 91.6309031 | 1.01609687 | 1.13269635 | 94.1666667 | 92.999 | |||
171 | 91.6167258 | 0.03827424 | 0.0426663 | 94.7222222 | 93.003 | |||
172 | 91.6410383 | 0.95096175 | 1.06008681 | 95.2777778 | 93.005 | |||
173 | 91.6245993 | 0.35440074 | 0.39506905 | 95.8333333 | 93.028 | |||
174 | 91.6335276 | -0.8485276 | -0.9458981 | 96.3888889 | 93.042 | |||
175 | 91.6241773 | 1.48382268 | 1.65409478 | 96.9444444 | 93.108 | |||
176 | 91.648397 | -0.076397 | -0.0851637 | 97.5 | 93.109 | |||
177 | 91.7398832 | -0.4358832 | -0.4859018 | 98.0555556 | 93.11 | |||
178 | 91.7385751 | 1.10242485 | 1.22893066 | 98.6111111 | 93.111 | |||
179 | 91.7254189 | 1.30258111 | 1.45205532 | 99.1666667 | 93.167 | |||
180 | 91.7251826 | 0.4388174 | 0.48917271 | 99.7222222 | 93.179 |
Respuesta:
a. ¿Cuántas variables hay en el banco de datos?
La respuesta a esta pregunta es que son 7 variables y son las columnas llamadas:
• Size
• Displacement
• Cylinders
• Drive
• Fuel Type
• City MPG
• Hwy MPG
Existe una columna que contiene elementos o entidades a partir de las cuales se han
...