statistics 2

profileStudent6423
practiceexam2data.xlsx
Home>Mathematics homework help>statistics 2

Sheet1

MAKE/Model EngineSize CabSpace HorsePower TopSpeed Weight MPG
GM/GeoMetroXF1 4 89 49 96 17.5 65.4
GM/GeoMetro 4 92 55 97 20 56
GM/GeoMetroLSI 4 92 55 97 20 55.9
SuzukiSwift 4 92 70 105 20 49
DaihatsuCharade 4 92 53 96 20 46.5
GM/GeoSprintTurbo 4 89 70 105 20 46.2
GM/GeoSprint 4 92 55 97 20 45.4
HondaCivicCRXHF 4 50 62 98 22.5 59.2
HondaCivicCRXHF 4 50 62 98 22.5 53.3
DaihatsuCharade 4 94 80 107 22.5 43.4
SubaruJusty 6 89 73 103 22.5 41.1
HondaCivicCRX 4 50 92 113 22.5 40.9
HondaCivic 4 99 92 113 22.5 40.9
SubaruJusty 6 89 73 103 22.5 40.4
SubaruJusty 6 89 66 100 22.5 39.6
SubaruJusty4wd 6 89 73 103 22.5 39.3
ToyotaTercel 4 91 78 106 22.5 38.9
HondaCivicCRX 4 50 92 113 22.5 38.8
ToyotaTercel 4 91 78 106 22.5 38.2
FordEscort 4 103 90 109 25 42.2
HondaCivic 4 99 92 110 25 40.9
PontiacLeMans 6 107 74 101 25 40.7
IsuzuStylus 6 101 95 111 25 40
DodgeColt 4 96 81 105 25 39.3
GM/GeoStorm 4 89 95 111 25 38.8
HondaCivicCRX 4 50 92 110 25 38.4
HondaCivicWagon 4 117 92 110 25 38.4
HondaCivic 4 99 92 110 25 38.4
SubaruLoyale 6 102 90 109 25 29.5
VolksJettaDiesel 6 104 52 90 27.5 46.9
Mazda323Protege 6 107 103 112 27.5 36.3
FordEscortWagon 6 114 84 103 27.5 36.1
FordEscort 4 101 84 103 27.5 36.1
GM/GeoPrism 4 97 102 111 27.5 35.4
ToyotaCorolla 4 113 102 111 27.5 35.3
EagleSummit 4 101 81 102 27.5 35.1
NissanCentraCoupe 4 98 90 106 27.5 35.1
NissanCentraWagon 6 88 90 106 27.5 35
ToyotaCelica 4 86 102 109 30 33.2
ToyotaCelica 4 86 102 109 30 32.9
ToyotaCorolla 4 92 130 120 30 32.3
ChevroletCorsica 6 113 95 106 30 32.2
ChevroletBeretta 6 106 95 106 30 32.2
ToyotaCorolla 4 92 102 109 30 32.2
PontiacSunbirdConv 6 88 95 106 30 32.2
DodgeShadow 4 102 93 105 30 31.5
DodgeDaytona 4 99 100 108 30 31.5
EagleSpirit 4 111 100 108 30 31.4
FordTempo 6 103 98 107 30 31.4
ToyotaCelica 4 86 130 120 30 31.2
ToyotaCamry 6 101 115 109 35 33.7
ToyotaCamry 6 101 115 109 35 32.6
ToyotaCamry 6 101 115 109 35 31.3
ToyotaCamryWagon 6 124 115 109 35 31.3
OldsCutlassSup 8 113 180 133 35 30.4
OldsCutlassSup 8 113 160 125 35 28.9
Saab9000 8 124 130 115 35 28
FordMustang 8 92 96 102 35 28
ToyotaCamry 6 101 115 109 35 28
ChryslerLebaronConv 8 94 100 104 35 28
DodgeDynasty 6 115 100 105 35 28
Volvo740 8 111 145 120 35 27.7
FordThunderbird 8 116 120 107 40 25.6
ChevroletCaprice 6 131 140 114 40 25.3
LincolnContinental 8 123 140 114 40 23.9
ChryslerNewYorker 8 121 150 117 40 23.6
BuickReatta 8 50 165 122 40 23.6
OldsTrof/Toronado 6 114 165 122 40 23.6
Oldsmobile98 8 127 165 122 40 23.6
PontiacBonneville 8 123 165 122 40 23.6
LexusLS400 8 112 245 148 40 23.5
Nissan300ZX 8 50 280 160 40 23.4
Volvo760Wagon 6 135 162 121 40 23.4
Audi200QuatroWag 6 132 162 121 40 23.1
BuickElectraWagon 6 160 140 110 45 22.9
CadillacBrougham 8 129 140 110 45 22.9
CadillacBrougham 8 129 175 121 45 19.5
Mercedes500SL 8 50 322 165 45 18.1
Mercedes560SEL 8 115 238 140 45 17.2
JaguarXJSConvert 6 50 263 147 45 17
BMW750IL 6 119 295 157 45 16.7
Rolls-RoyceVarious 8 107 236 130 55 13.2

Sheet2

1 7 504 MAKE/Model Weight TopSpeed ProdVolume Cost SUMMARY OUTPUT
2 10 503 20 137
3 11 506 GM/GeoMetro 20 97 25 122 Regression Statistics
4 12 504 GM/GeoMetroLSI 20 97 28 123 Multiple R 0.9583
5 13 500 SuzukiSwift 20 105 30 120 R Square 0.9183
6 14 490 DaihatsuCharade 20 96 35 106 Adjusted R Square 0.9020
7 15 486 GM/GeoSprintTurbo 20 105 40 109 Standard Error 4.1442
8 16 476 GM/GeoSprint 20 97 45 97 Observations 7
9 17 464 HondaCivicCRXHF 22.5 98
10 18 450 HondaCivicCRXHF 22.5 98 ANOVA
11 19 434 DaihatsuCharade 22.5 107 df SS MS F Significance F
12 20 416 SubaruJusty 22.5 103 Regression 1 965.556 965.556 56.221 0.00067
13 21 396 HondaCivicCRX 22.5 113 Residual 5 85.872 17.174
14 22 374 HondaCivic 22.5 113 Total 6 1051.429
15 23 350 SubaruJusty 22.5 103
1 8 515 SubaruJusty 22.5 100 Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
2 9 515 SubaruJusty4wd 22.5 103 Intercept 162.7007 6.3854 25.4802 0.0000 146.2865 179.1148
3 11 525 ToyotaTercel 22.5 106 ProdVolume -1.4570 0.1943 -7.4980 0.0007 -1.9565 -0.9575
4 12 518 HondaCivicCRX 22.5 113
5 13 515 ToyotaTercel 22.5 106
6 14 506 FordEscort 25 109
7 14 500 HondaCivic 25 110
8 16 494 PontiacLeMans 25 101
9 17 483 IsuzuStylus 25 111
10 16 480 DodgeColt 25 105
11 19 460 GM/GeoStorm 25 111
12 20 438 HondaCivicCRX 25 110
13 21 419 HondaCivicWagon 25 110
14 21 398 HondaCivic 25 110
15 23 375 Subaru Loyale 25 109
1 9 496 VolksJettaDiesel 27.5 105
2 10 497 Mazda323Protege 27.5 112
3 11 508 FordEscortWagon 27.5 103
4 12 502 FordEscort 27.5 103
5 13 500 GM/GeoPrism 27.5 111
6 14 492 ToyotaCorolla 27.5 111
7 15 487 EagleSummit 27.5 102
8 16 482 NissanCentraCoupe 27.5 106
9 17 472 NissanCentraWagon 27.5 106
10 18 470 ToyotaCelica 30 109
11 19 451 ToyotaCelica 30 109
12 20 430 ToyotaCorolla 30 120
13 21 412 ChevroletCorsica 30 106
14 22 380 ChevroletBeretta 30 106
15 23 370 ToyotaCorolla 30 109
0 8 500 PontiacSunbirdConv 30 106
0 8 470 DodgeShadow 30 105
0 8 486 DodgeDaytona 30 108
-1 7 450 EagleSpirit 30 108
-1 7 440 FordTempo 30 107
-1 7 478 ToyotaCelica 30 120
-1 6 469 ToyotaCamry 35 109
ToyotaCamry 35 109
ToyotaCamry 35 109
ToyotaCamryWagon 35 109
OldsCutlassSup 35 123
OldsCutlassSup 35 125
Saab9000 35 115
FordMustang 35 102
ToyotaCamry 35 109
ChryslerLebaronConv 35 104
DodgeDynasty 35 105
Volvo740 35 120
FordThunderbird 40 107
ChevroletCaprice 40 114
LincolnContinental 40 114
ChryslerNewYorker 40 117
BuickReatta 40 122
OldsTrof/Toronado 40 122
Oldsmobile98 40 122
PontiacBonneville 40 122
LexusLS400 40 118
Nissan300ZX 40 130
Volvo760Wagon 40 121
Audi200QuatroWag 40 121
BuickElectraWagon 45 110
CadillacBrougham 45 110
CadillacBrougham 45 121
Mercedes500SL 45 125
Mercedes560SEL 45 140
JaguarXJSConvert 45 137
BMW750IL 45 138
7 10 11 12 13 14 15 16 17 18 19 20 21 22 23 8 9 11 12 13 14 14 16 17 16 19 20 21 21 23 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 8 8 8 7 7 7 6 504 503 506 504 500 490 486 476 464 450 434 416 396 374 350 515 515 525 518 515 506 500 494 483 480 460 438 419 398 375 496 497 508 502 500 492 487 482 472 470 451 430 412 380 370 500 470 486 450 440 478 469 TopSpeed 20 20 20 20 20 20 22.5 22.5 22.5 22.5 22.5 22.5 22.5 22.5 22.5 22.5 22.5 22.5 25 25 25 25 25 25 25 25 25 25 27.5 27.5 27.5 27 .5 27.5 27.5 27.5 27.5 27.5 30 30 30 30 30 30 30 30 30 30 30 30 35 35 35 35 35 35 35 35 35 35 35 35 40 40 40 40 40 40 40 40 40 40 40 40 45 45 45 45 45 45 45 97 97 105 96 105 97 98 98 107 103 113 113 103 100 103 106 113 106 109 110 101 111 105 111 110 110 110 109 105 112 103 103 111 111 102 106 106 109 109 120 106 106 109 106 105 108 108 107 120 109 109 109 109 123 125 115 102 109 104 105 120 107 114 114 117 122 122 122 122 118 130 121 121 110 110 121 125 140 137 138

Weight

TopSpeed

Cost 20 25 28 30 35 40 45 137 122 123 120 106 109 97