Please complete Business Stats problems on XLS sheet labeled Week 6 Stats. There are a total of 5 problems, one for each tab. The last three problems require data sets, I have included these as attachments. Problems that require excel outputs must be computed through excel, formulas within text block are okay.
ChartDataSheet_ This worksheet contains values required for MegaStat charts. Boxplot 12/5/2012 16:43.50 21559681 22093854.25 32093854.25 32359022.5 12359022.5 32359022.5 33039260.5 23039260.5 23565718 23039260.5 13039260.5 12093854.25 22093854.25 1-742364.5 3-742364.5 1675744.875 3675744.875 14457369.875 34457369.875 15875479.25 35875479.25 Dotplot 12/5/2012 16:44.17 15596811 16035961 16077331 16790131 17219201 17398591 19659551 20919181 20996631 21022401 21237211 21776171 22194441 22428031 23472511 23707941 24201711 26304581 27763541 28313851 28827561 30280331 30430031 30617701 32621091 33242461 33773711 34602801 35424061 35657181 2012 Season TeamLeagueOpenedTeam SalaryAttendanceWinsERABAHRYearAverage Salary ArizonaNational199865.802080145794.040.26415420001.99 AtlantaNational199689.602001392674.410.25110020012.26 Baltimore American1992118.902281202814.050.2521720022.38 Boston American1912168.702880694784.310.26516120032.56 Chicago CubsNational1914117.202959812973.360.24417120042.49 Chicago White SoxAmerican1991110.701755810763.980.2513620052.63 CincinnatiNational2003117.702419506644.330.24816720062.87 Cleveland American199487.701388905813.670.25614120072.94 ColoradoNational199598.302506789685.040.26518620083.15 DetroitAmerican2000172.802726048744.640.2715120093.24 HoustonAmerican200069.102153585863.570.2523020103.3 Kansas City American1973112.902708549953.730.26913920113.31 LA AngelsAmerican1966146.403012765853.940.24617620123.44 LA DodgersNational1962230.403764815923.440.2518720133.65 MiamiNational201284.601752235714.020.2612020143.95 MilwaukeeNational200198.702542558684.280.25114520154.25 MinnesotaAmerican2010108.302220054834.070.24715620164.4 NY MetsNational2009100.102569753903.430.244177 NY YankeesAmerican2009213.503193795874.050.251212 OaklandAmerican196680.801768175684.140.251146 PhiladelphiaNational2004133.001831080634.690.249130 PittsburghNational200185.902498596983.210.26140 San DiegoNational2004126.602459742744.090.243148 San FranciscoNational2000166.503375882843.720.267136 SeattleAmerican1999123.202193581764.160.249198 St. LouisNational2006120.3035208891002.940.253137 Tampa Bay American199074.801287054803.740.252167 TexasAmerican1994144.802491875882.240.257172 TorontoAmerican1989116.402794891933.80.269232 WashingtonNational2008174.502619843833.620.251177 Key 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 ChartDataSheet_ This worksheet contains values required for MegaStat charts. Boxplot 1/28/2010 16:03.39 2741 2806 3806 3827 1827 3827 3851.5 2851.5 2908 2851.5 1851.5 1806 2806 1669.5 3669.5 1737.75 3737.75 1919.75 3919.75 1988 3988 Boxplot 1/28/2010 16:06.08 2741 2806 3806 3827 1827 3827 3851.5 2851.5 2908 2851.5 1851.5 1806 2806 1669.5 3669.5 1737.75 3737.75 1919.75 3919.75 1988 3988 Dotplot 1/28/2010 16:06.08 7411 7511 7571 7572 7601 7741 7751 7801 7841 7851 7901 7921 7981 7991 7992 8001 8021 8031 8041 8061 8062 8091 8121 8151 8152 8153 8161 8162 8171 8172 8173 8181 8191 8192 8211 8221 8231 8261 8271 8272 8273 8281 8301 8311 8321 8351 8361 8371 8381 8391 8421 8422 8423 8441 8451 8461 8471 8481 8491 8511 8531 8561 8571 8572 8581 8591 8592 8641 8651 8661 8662 8691 8701 8731 8741 8821 8831 8851 8951 9081 Boxplot 1/28/2010 16:08.20 2741 2806 3806 3827 1827 3827 3851.5 2851.5 2895 2851.5 1851.5 1806 2806 1669.5 3669.5 1737.75 3737.75 1919.75 3919.75 1988 3988 1.8980 1.81008 Dotplot 1/28/2010 16:08.20 7411 7511 7571 7572 7601 7741 7751 7801 7841 7851 7901 7921 7981 7991 7992 8001 8021 8031 8041 8061 8062 8091 8121 8151 8152 8153 8161 8162 8171 8172 8173 8181 8191 8192 8211 8221 8231 8261 8271 8272 8273 8281 8301 8311 8321 8351 8361 8371 8381 8391 8421 8422 8423 8441 8451 8461 8471 8481 8491 8511 8531 8561 8571 8572 8581 8591 8592 8641 8651 8661 8662 8691 8701 8741 8821 8831 8851 8951 9801 10081 Bus Data Set 3 --Lincolnville School District Bus Data IDManufacturerEngine Type (0=diesel)CapacityMaintenance CostAgeOdometer MilesMiles 10Keiser114464655437511973 396Thompson014107222185811969 122Bluebird15593941011658011967 751Keiser014107822244411948 279Bluebird055100822267211925 500Bluebird155532955076511922Variables 520Bluebird05547941011913011896 759Keiser055395288787211889ID = Bus identification number 714Bluebird042374277370311837 875Bluebird055437699794711814Manufacturer = Source of the bus (Bluebird, Keiser, or Thompson) 600Bluebird05548321011986011800 953Bluebird05551601011770011798Engine type = If the engine is diesel then engine type = 0; if the engine is gasoline, then engine type = 1) 101Bluebird055195544109611789 358Bluebird055277567008611782Capacity = number of seats on the bus 29Bluebird155535266943811781 365Keiser055306566338411778Maintenance cost = dollars spent to maintain a bus last year 162Keiser155314333126611757 686Bluebird055156933467411707Age = number of years since the bus left the manufacturer 370Keiser155776688652811704 887Bluebird055374389367211698Odometer Miles = total number of miles traveled by a bus 464Bluebird155254033453011698 948Keiser042434299795611691Miles = number of miles traveled since last maintenance 678Keiser055336177522911668 481Keiser16309733436211662 43Bluebird1558263910296911615 704Bluebird055421888342411610 814Bluebird055202844082411576 39Bluebird155582166944411533 699Bluebird155906999830711518 75Bluebird055301167197011462 693Keiser1559193910188911461 989Keiser0554795910660511418 982Bluebird05550511027611359 321Bluebird042273267012211358 724Keiser042375489196811344 732Keiser0424640910119611342 880Keiser155841099706511336 193Thompson01459221112871111248 884Bluebird055436499245711231 57Bluebird055319077924011222 731Bluebird042321366852611168 61Keiser0554139910353611148 135Bluebird055356077642611127 833Thompson014392089096811112 671Thompson114673388979211100 692Bluebird055377089324811048 200Bluebird05551681010370011018 754Keiser01473801414686011003 540Bluebird155365644528410945 660Bluebird155621366443410911 353Keiser155427944574410902 482Bluebird155105751011653410802 398Thompson06475299592210802 984Bluebird055380988766410760 977Bluebird055376977942210759 705Keiser042215244759610755 767Keiser055298567153810726 326Bluebird0554563910734310724 120Keiser04247231011032010674 554Bluebird042182644460410662 695Bluebird055106122315210633 9Keiser155352744684810591 861Bluebird15596691010604010551 603Keiser014211644438410518 156Thompson01462121214046010473 427Keiser155692777342310355 883Bluebird155188122074210344 168Thompson114700478300610315 954Bluebird04252841010100010235 768Bluebird042317377177810227 490Bluebird155101331010624010210 725Bluebird055235655706510209 45Keiser055312466010210167 38Keiser114597666166210140 314Thompson0654081112811710128 507Bluebird055369077284910095 40Bluebird15595731011847010081 918Bluebird055247055362010075 387Bluebird155686388996010055 418Bluebird0554513910471510000 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. https://www.slader.com/discussion/question/the-null-and-alternate-hypotheses-area-random-sample-of-20-items-from-the-first-population-showed-a/ Chapter 11 – Problem 41 Operating Room ABCDEFHH Before6.66.5910.311.28.16.311.6 After6.82.47.48.58.16.13.42 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? Chapter 11 – Problem 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? Chapter 11 – Problem 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. Chapter 12 Case A – Century Nat A. Century National BankRefer 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 lon-ger 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 transac-tions 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.