Arizona College of Allied Lincolnville School District Bus Data Worksheet

User Generated

XF88

Mathematics

Arizona College of Allied Health

Description

Complete the problems below from the textbook. You will need to use the "Baseball 2016 Data" and the "Lincolnville School District Bus Data" files for this assignment. The files are located in the topic materials.

  1. Chapter 10 – Problem 8
  2. Chapter 10 – Problem 13
  3. Chapter 10 – Problem 53
  4. Chapter 10 – Problem 54

For problems requiring computations, please ensure that your Excel file includes the associated cell computations and/or statistics output. This information is needed in order to receive full credit on these problems.

Submit output in one Excel file.

All questions in word document. All data must be in one excel sheet. Data files also attached.

Unformatted Attachment Preview

Team League Opened Team Salary Attendance Arizona National 1998 65.80 2080145 Atlanta National 1996 89.60 2001392 Baltimore American 1992 118.90 2281202 Boston American 1912 168.70 2880694 National 1914 117.20 2959812 American 1991 110.70 1755810 Cincinnati National 2003 117.70 2419506 Cleveland American 1994 87.70 1388905 Colorado National 1995 98.30 2506789 Detroit American 2000 172.80 2726048 Houston American 2000 69.10 2153585 Kansas City American 1973 112.90 2708549 LA Angels American 1966 146.40 3012765 LA Dodgers National 1962 230.40 3764815 Miami National 2012 84.60 1752235 National American 2001 2010 98.70 108.30 2542558 2220054 National 2009 100.10 2569753 NY Yankees American 2009 213.50 3193795 Oakland American 1966 80.80 1768175 Philadelphia National 2004 133.00 1831080 Pittsburgh National 2001 85.90 2498596 San Diego National 2004 126.60 2459742 San Francisco National 2000 166.50 3375882 Seattle American 1999 123.20 2193581 St. Louis National 2006 120.30 3520889 Tampa Bay American 1990 74.80 1287054 Texas American 1994 144.80 2491875 Toronto American 1989 116.40 2794891 National 2008 174.50 2619843 Chicago Cubs Chicago White Sox Milwaukee Minnesota NY Mets Washington Wins ERA BA HR Year 79 4.04 0.264 154 2000 67 4.41 0.251 100 2001 81 4.05 0.25 217 2002 78 4.31 0.265 161 2003 97 3.36 0.244 171 2004 76 3.98 0.25 136 2005 64 4.33 0.248 167 2006 81 3.67 0.256 141 2007 68 5.04 0.265 186 2008 74 4.64 0.27 151 2009 86 3.57 0.25 230 2010 95 3.73 0.269 139 2011 85 3.94 0.246 176 2012 92 3.44 0.25 187 2013 71 4.02 0.26 120 2014 68 83 4.28 4.07 0.251 0.247 145 156 2015 90 3.43 0.244 177 87 4.05 0.251 212 68 4.14 0.251 146 63 4.69 0.249 130 98 3.21 0.26 140 74 4.09 0.243 148 84 3.72 0.267 136 76 4.16 0.249 198 100 2.94 0.253 137 80 3.74 0.252 167 88 2.24 0.257 172 93 3.8 0.269 232 83 3.62 0.251 177 2016 Average Salary 1.99 2.26 2.38 2.56 2.49 2.63 2.87 2.94 3.15 3.24 3.3 3.31 3.44 3.65 3.95 4.25 4.4 Team = Team’s name League = American or National League Year Opened = First year the team’s stadium was used Team Salary = Total team salary expressed in millions of dollars Attendance = Total number of people attending regular season games Wins = Number of regular season games won ERA = Team earned run average BA = Team batting average HR = Team home runs Year = Year of operation Average salary = Average annual player salary in dollars Data Set 3 --Lincolnville School District Bus Data ID 10 396 122 751 279 500 520 759 714 875 600 953 101 358 29 365 162 686 370 887 464 948 678 481 43 704 814 39 699 75 693 989 982 321 724 732 880 193 884 57 Manufacturer Keiser Thompson Bluebird Keiser Bluebird Bluebird Bluebird Keiser Bluebird Bluebird Bluebird Bluebird Bluebird Bluebird Bluebird Keiser Keiser Bluebird Keiser Bluebird Bluebird Keiser Keiser Keiser Bluebird Bluebird Bluebird Bluebird Bluebird Bluebird Keiser Keiser Bluebird Bluebird Keiser Keiser Keiser Thompson Bluebird Bluebird Engine Type (0=diesel) 1 0 1 0 0 1 0 0 0 0 0 0 0 0 1 0 1 0 1 0 1 0 0 1 1 0 0 1 1 0 1 0 0 0 0 0 1 0 0 0 Capacity 14 14 55 14 55 55 55 55 42 55 55 55 55 55 55 55 55 55 55 55 55 42 55 6 55 55 55 55 55 55 55 55 55 42 42 42 55 14 55 55 Maintenance Cost 4646 1072 9394 1078 1008 5329 4794 3952 3742 4376 4832 5160 1955 2775 5352 3065 3143 1569 7766 3743 2540 4342 3361 3097 8263 4218 2028 5821 9069 3011 9193 4795 505 2732 3754 4640 8410 5922 4364 3190 Age 5 2 10 2 2 5 10 8 7 9 10 10 4 6 6 6 3 3 8 8 3 9 7 3 9 8 4 6 9 6 9 9 1 6 8 9 9 11 9 7 Odometer Miles 54375 21858 116580 22444 22672 50765 119130 87872 73703 97947 119860 117700 41096 70086 69438 63384 31266 34674 86528 93672 34530 97956 75229 34362 102969 83424 40824 69444 98307 71970 101889 106605 10276 70122 91968 101196 97065 128711 92457 79240 731 61 135 833 671 692 200 754 540 660 353 482 398 984 977 705 767 326 120 554 695 9 861 603 156 427 883 168 954 768 490 725 45 38 314 507 40 918 387 418 Bluebird Keiser Bluebird Thompson Thompson Bluebird Bluebird Keiser Bluebird Bluebird Keiser Bluebird Thompson Bluebird Bluebird Keiser Keiser Bluebird Keiser Bluebird Bluebird Keiser Bluebird Keiser Thompson Keiser Bluebird Thompson Bluebird Bluebird Bluebird Bluebird Keiser Keiser Thompson Bluebird Bluebird Bluebird Bluebird Bluebird 0 0 0 0 1 0 0 0 1 1 1 1 0 0 0 0 0 0 0 0 0 1 1 0 0 1 1 1 0 0 1 0 0 1 0 0 1 0 1 0 42 55 55 14 14 55 55 14 55 55 55 55 6 55 55 42 55 55 42 42 55 55 55 14 14 55 55 14 42 42 55 55 55 14 6 55 55 55 55 55 3213 4139 3560 3920 6733 3770 5168 7380 3656 6213 4279 10575 4752 3809 3769 2152 2985 4563 4723 1826 1061 3527 9669 2116 6212 6927 1881 7004 5284 3173 10133 2356 3124 5976 5408 3690 9573 2470 6863 4513 6 9 7 8 8 8 10 14 4 6 4 10 9 8 7 4 6 9 10 4 2 4 10 4 12 7 2 7 10 7 10 5 6 6 11 7 10 5 8 9 68526 103536 76426 90968 89792 93248 103700 146860 45284 64434 45744 116534 95922 87664 79422 47596 71538 107343 110320 44604 23152 46848 106040 44384 140460 73423 20742 83006 101000 71778 106240 57065 60102 61662 128117 72849 118470 53620 89960 104715 Miles 11973 11969 11967 11948 11925 11922 11896 11889 11837 11814 11800 11798 11789 11782 11781 11778 11757 11707 11704 11698 11698 11691 11668 11662 11615 11610 11576 11533 11518 11462 11461 11418 11359 11358 11344 11342 11336 11248 11231 11222 Variables ID = Bus identification number Manufacturer = Source of the bus (Bluebird, Keiser, or Thompson) Engine type = If the engine is diesel then engine type = 0; if the engine is gasolin Capacity = number of seats on the bus Maintenance cost = dollars spent to maintain a bus last year Age = number of years since the bus left the manufacturer Odometer Miles = total number of miles traveled by a bus Miles = number of miles traveled since last maintenance 11168 11148 11127 11112 11100 11048 11018 11003 10945 10911 10902 10802 10802 10760 10759 10755 10726 10724 10674 10662 10633 10591 10551 10518 10473 10355 10344 10315 10235 10227 10210 10209 10167 10140 10128 10095 10081 10075 10055 10000 ine type = 0; if the engine is gasoline, then engine type = 1) Complete the problems below from the textbook. You will need to use the "Baseball 2016 Data" and the "Lincolnville School District Bus Data" files for this assignment. The files are located in the topic materials. 1. Chapter 10 – Problem 8 For Exercises 8: (a) State the null hypothesis and the alternate hypothesis. (b) State the decision rule. (c) Compute the value of the test statistic. (d) What is your decision regarding H0? (e) What is the p-value? Interpret it. 8. At the time she was hired as a server at the Grumney Family Restaurant, Beth Brigden was told, “You can average $80 a day in tips.” Assume the population of daily tips is normally distributed with a standard deviation of $9.95. Over the first 35 days she was employed at the restaurant, the mean daily amount of her tips was $84.85. At the .01 significance level, can Ms. Brigden conclude that her daily tips average more than $80? 2. Chapter 10 – Problem 13 13. The mean income per person in the United States is $50,000, and the distribution of incomes follows a normal distribution. A random sample of 10 residents of Wilm-ington, Delaware, had a mean of $60,000 with a standard deviation of $10,000. At the .05 level of significance, is that enough evidence to conclude that residents of Wilmington, Delaware, have more income than the national average? 3. Chapter 10 – Problem 53 53. Refer to the Baseball 2016 data, which report information on the 30 Major League Baseball teams for the 2016 season.a. Conduct a test of hypothesis to determine whether the mean salary of the teams was different from $100.0 million. Use the .05 significance level. b. Using a 5% significance level, conduct a test of hypothesis to determine whether the mean attendance was more than 2,000,000 per team. 4. Chapter 10 – Problem 54 54. Refer to the Lincolnville School District bus data.a. Select the variable for the number of miles traveled last month. Conduct a hypothesis test to determine whether the mean miles traveled last month equals 10,000. Use the .01 significance level. Find the p-value and explain what it means.b. A study of school bus fleets reports that the average per bus maintenance cost is $4,000 per year. Using the maintenance cost variable, conduct a hypothesis test to determine whether the mean maintenance cost for Lincolnville’s bus fleet is more than $4,000 at the .05 significance level. Determine the p-value and report the results. For problems requiring computations, please ensure that your Excel file includes the associated cell computations and/or statistics output. This information is needed in order to receive full credit on these problems. Submit output in one Excel file.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached. Please let me know if you have any questions or need revisions.

Team

League

Opened

Team Salary

Arizona

National

1998

65.80

Atlanta

National

1996

89.60

Baltimore

American

1992

118.90

Boston

American

1912

168.70

National

1914

117.20

American

1991

110.70

Cincinnati

National

2003

117.70

Cleveland

American

1994

87.70

Colorado

National

1995

98.30

Detroit

American

2000

172.80

Houston

American

2000

69.10

Kansas City

American

1973

112.90

LA Angels

American

1966

146.40

LA Dodgers

National

1962

230.40

Miami

National

2012

84.60

National
American

2001
2010

98.70
108.30

National

2009

100.10

NY Yankees

American

2009

213.50

Oakland

American

1966

80.80

Philadelphia

National

2004

133.00

Pittsburgh

National

2001

85.90

San Diego

National

2004

126.60

San Francisco

National

2000

166.50

Seattle

American

1999

123.20

St. Louis

National

2006

120.30

Tampa Bay

American

1990

74.80

Texas

American

1994

144.80

Toronto

American

1989

116.40

National

2008

174.50

Chicago Cubs
Chicago White Sox

Milwaukee
Minnesota
NY Mets

Washington
Salary
mean

Attendance
121.94

Sample mean

Standard Deviation

39.89889

Standard Deviation

Attendance

Wins

ERA

BA

HR

2080145

79

4.04

0.264

154

2001392

67

4.41

0.251

100

2281202

81

4.05

0.25

217

2880694

78

4.31

0.265

161

2959812

97

3.36

0.244

171

1755810

76

3.98

0.25

136

2419506

64

4.33

0.248

167

1388905

81

3.67

0.256

141

2506789

68

5.04

0.265

186

2726048

74

4.64

0.27

151

2153585

86

3.57

0.25

230

2708549

95

3.73

0.269

139

3012765

85

3.94

0.246

176

3764815

92

3.44

0.25

187

1752235

71

4.02

0.26

120

2542558
2220054

68
83

4.28
4.07

0.251
0.247

145
156

2569753

90

3.43

0.244

177

3193795

87

4.05

0.251

212

1768175

68

4.14

0.251

146

1831080

63

4.69

0.249

130

2498596

98

3.21

0.26

140

2459742

74

4.09

0.243

148

3375882

84

3.72

0.267

136

2193581

76

4.16

0.249

198

3520889

100

2.94

0.253

137

1287054

80

3.74

0.252

167

2491875

88

2.24

0.257

172

2794891

93

3.8

0.269

232

2619843

83

3.62

0.251

177

2458667

584126.6166

Year

Average...


Anonymous
Just what I needed…Fantastic!

Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Related Tags