Jamie24 week 3

profileDSran2U1102
week_3_excel_bus660.v10m3templatepcandmac.xlsx
Home>Business & Finance homework help>Jamie24 week 3

4-13

Problem 4-13 Data
Student Final Average First Test Grade
1 93 98
2 78 77
3 84 88
4 73 80
5 84 96
6 64 61
7 64 66
8 95 95
9 76 69

4-19

Problem 4-19 Data
Year Number of Tourists (1,000,000s) Ridership (100,000s)
1 7 15
2 2 10
3 6 13
4 4 15
5 14 25
6 15 27
7 16 24
8 12 20
9 14 27
10 20 44
11 15 34
12 7 17

4-32

Problem 4-32 Data
Team W ERA AVG
New York Yankees 103 4.26 0.283
Los Angeles Angels 97 4.45 0.285
Boston Red Sox 95 4.35 0.270
Minnesota Twins 87 4.50 0.274
Texas Rangers 87 4.38 0.260
Detroit Tigers 86 4.29 0.260
Seattle Mariners 85 3.87 0.258
Tampa Bay Rays 84 4.33 0.263
Chicago White Sox 79 4.14 0.258
Toronto Blue Jays 75 4.47 0.266
Oakland Athletics 75 4.26 0.262
Cleveland Indians 65 5.06 0.264
Kansas City Royals 65 4.83 0.259
Baltimore Orioles 64 5.15 0.268

4-27

Problem 4-27 Data
MPG HORSEPOWER WEIGHT
44 67 1,844
44 50 1,998
40 62 1,752
37 69 1,980
37 66 1,797
34 63 2,199
35 90 2,404
32 99 2,611
30 63 3,236
28 91 2,606
26 94 2,580
26 88 2,507
25 124 2,922
22 97 2,434
20 114 3,248
21 102 2,812
18 114 3,382
18 142 3,197
16 153 4,380
16 139 4,036
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.9034722053
R Square 0.8162620258
Adjusted R Square 0.7946457936
Standard Error 4.1231815706
Observations 20
ANOVA
df SS MS F Significance F
Regression 2 1283.9393535124 641.9696767562 37.7615310629 0.0000005568
Residual 17 289.0106464875 17.000626264
Total 19 1572.95
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 57.6858614914 3.6512176772 15.7990748818 0 49.9824656283 65.3892573545 49.9824656283 65.3892573545
HORSEPOWER -0.165665619 0.0595462354 -2.7821342158 0.0127765318 -0.2912971929 -0.040034045 -0.2912971929 -0.040034045
WEIGHT -0.0050460122 0.0024441245 -2.0645478978 0.0545681737 -0.0102026642 0.0001106398 -0.0102026642 0.0001106398

4-26

Problem 4-26 Data
HOSPITAL NUMBER OF BED's ADMISSSIONS (100s) TOTAL EXPENSES (MILLIONS)
1 215 77 57
2 336 160 127
3 520 230 157
4 135 43 24
5 35 9 14
6 210 155 93
7 140 53 45
8 90 6 6
9 410 159 99
10 50 18 12
11 65 16 11
12 42 29 15
13 110 28 21
14 305 98 63
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.9873617765
R Square 0.9748832777
Adjusted R Square 0.9703166009
Standard Error 8.3686260948
Observations 14
ANOVA
df SS MS F Significance F
Regression 2 29901.3413558581 14950.6706779291 213.4776172469 0.0000000016
Residual 11 770.3729298561 70.0339027142
Total 13 30671.7142857143
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 0.6538922402 3.756493221 0.1740698576 0.864972755 -7.614093588 8.9218780684 -7.614093588 8.9218780684
NUMBER OF BED's 0.0230619146 0.0451544214 0.5107343621 0.619630815 -0.0763222968 0.1224461261 -0.0763222968 0.1224461261
ADMISSSIONS (100s) 0.6229709806 0.0950065282 6.5571386781 0.0000409548 0.4138630221 0.832078939 0.4138630221 0.832078939

4-10

Problem 4-10 Data
Demand for Bass Drums Green Shades TV Appearance
3 3
6 4
7 7
5 6
10 8
8 5