Description Book used: Lind, D. A., Marchal, W. G., & Wathen, S. A. (2018). Statistical techniques ...
Description Book used: Lind, D. A., Marchal, W. G., & Wathen, S. A. (2018). Statistical techniques in business and economics (17th ed.). New York, NY: McGraw Hill Education, ISBN-13: 9781259666360 4 attachments Slide 1 of 4 attachment_1 attachment_1 attachment_2 attachment_2 attachment_3 attachment_3 attachment_4 attachment_4 UNFORMATTED ATTACHMENT PREVIEW 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) Balance 1756 748 1501 1831 1622 1886 740 1593 1169 2125 1554 1474 1913 1218 1006 2215 137 167 343 2557 2276 1494 2144 1995 1053 1526 1120 1838 1746 1616 1958 634 580 1320 1675 789 1735 1784 1326 2051 1044 1885 1790 765 1645 32 1266 890 2204 2409 1338 ATM Services 13 9 10 10 14 17 6 10 6 18 12 12 6 10 12 20 7 5 7 20 15 11 17 10 8 8 8 7 11 10 6 2 4 4 6 8 12 11 16 14 7 10 11 4 6 2 11 7 14 16 14 4 2 1 4 6 3 3 8 4 6 6 7 5 3 4 3 2 4 2 7 4 2 3 7 4 4 6 5 2 4 2 7 1 5 7 4 7 5 8 4 5 6 4 3 9 0 7 1 5 8 4 Debit Interest 0 1 0 0 0 0 0 1 0 0 1 1 0 1 0 1 0 0 0 1 1 0 0 0 1 0 1 1 0 1 1 1 0 1 1 0 0 0 0 1 1 1 0 0 0 0 0 0 0 0 1 1 0 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 1 0 1 0 0 0 0 0 0 1 0 0 0 0 1 1 0 1 0 0 1 0 0 0 City 2 1 1 3 4 1 3 1 4 2 3 1 1 1 1 4 3 4 1 4 3 1 3 2 3 2 3 3 2 2 2 4 1 1 2 4 3 1 3 4 1 2 3 4 4 3 4 1 2 2 2 2076 1708 2138 2375 1455 1487 1125 1989 2156 12 13 18 12 9 8 6 12 14 5 3 5 4 5 4 4 3 5 1 1 0 0 1 1 1 0 1 0 0 1 0 1 0 0 1 0 2 1 4 2 3 4 2 2 2 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 Team Salary Mean 121,94 Standard Error 7,40904 Median Mode 116,8 #N/A Standard Deviation 40,581 Sample Variance 1646,82 Kurtosis 0,80568 Skewness 1,00949 Range Minimum Maximum Sum Count 164,6 65,8 230,4 3658,2 30 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 Complete the problems below from the textbook. You will need to use the "Baseball 2016 Data," "Lincolnville School District Bus Data," and the "Century National Bank Data" files for this assignment. The files are located in the attached links. 1. Chapter 11 – Problem 14 The null and alternate hypotheses are: H0: ?1 ? ?2 H1: ?1 > ?2 A random sample of 20 items from the first population showed a mean of 100 and a standard deviation of 15. A sample of 16 items for the second population showed a mean of 94 and a standard deviation of 8. Use the .05 significant level. 2. Chapter 11 – Problem 41 An investigation of the effectiveness of an antibacterial soap in reducing operating room contamination resulted in the accompanying table. The new soap was tested in a sample of eight operating rooms in the greater Seattle area during the last year. The following table reports the contamination levels before and after the use of the soap for each operating room. At the .05 significance level, can we conclude the contamination measurements are lower after use of the new soap? 3. Chapter 11 – Problem 48 48. Refer to the Baseball 2016 data, which report information on the 30 Major League Baseball teams for the 2016 season. a. At the .05 significance level, can we conclude that there is a difference in the mean salary of teams in the American League versus teams in the National League? b. At the .05 significance level, can we conclude that there is a difference in the mean home attendance of teams in the American League versus teams in the National League? c. Compute the mean and the standard deviation of the number of wins for the 10 teams with the highest salaries. Do the same for the 10 teams with the lowest salaries. At the .05 significance level, is there a difference in the mean number of wins for the two groups? At the .05 significance level, is there a difference in the mean attendance for the two groups? 4. Chapter 11 – Problem 49 49. Refer to the Lincolnville School District bus data. Is there a difference in the mean maintenance cost for the diesel versus the gasoline buses? Use the .05 significance level. 5. Chapter 12 Case A – Century National Bank A. Century National Bank Refer to the description of Century National Bank on page 129 at the end of the Review of Chapters 1–4. With many other options available, customers no longer let their money sit in a checking account. For many years, the mean checking balance has been $1,600. Do the sample data indicate that the mean account balance has declined from this value? Recent years have also seen an increase in the use of ATM machines. When Mr. Selig took over the bank, the mean number of transactions per month per customer was 8; now he believes it has increased to more than 10. In fact, the advertising agency that prepares TV commercials for Century would like to use this on the new commercial being designed. Is there sufficient evidence to conclude that the mean number of transactions per customer is more than 10 per month? Could the advertising agency say the mean is more than 9 per month? The bank has branch offices in four different cities: Cincinnati, Ohio; Atlanta, Georgia; Louisville, Kentucky; and Erie, Pennsylvania. Mr. Selig would like to know whether there is a difference in the mean checking ac-count balances among the four branches. If there are differences, between which branches do these differences occur? Mr. Selig is also interested in the bank’s ATMs. Is there a difference in ATM use among the branches? Also, do customers who have debit cards tend to use ATMs differently from those who do not have debit cards? Is there a difference in ATM use by those with checking accounts that pay interest versus those that do not? Prepare a report for Mr. Selig answering these questions. 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 Tags: standard deviation applied business probability Century National Bank Data Statistical techniques in business The null hypostesis fail User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
