ChartDataSheet_ This worksheet contains values required for MegaStat charts. Boxplot 12/5/2012 16:43.50 21559681 2 XXXXXXXXXX 3 XXXXXXXXXX 3 XXXXXXXXXX 1 XXXXXXXXXX 3 XXXXXXXXXX 3 XXXXXXXXXX 2...

1 answer below »
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.
Answered Same DaySep 21, 2021

Answer To: ChartDataSheet_ This worksheet contains values required for MegaStat charts. Boxplot 12/5/2012...

Mohd answered on Sep 22 2021
149 Votes
Chapter 11 – Problem 14
    
                                        sample size    sample mean    st.dev    alpha=0.05
                                        20    100    15
                                        16    94    8
                                    DF    34
                                    Numerator    6
                                sample mean squre 1    11.25
                                sample mean squre 2    4.00
                                sum    15.25
                                Sqrt of sample meam squre sum    3.91
                                t_value    1.54
                                Critical value    2.03    Alpha = 0.05, df= 34
                                        As we have t-value less than critical value we will accept the null hypothesis.
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 a
nd 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
                                            A    B    C    D    E    F    H    H    t-Test: Paired Two Sample for Means
                                        Before    6.6    6.5    9    10.3    11.2    8.1    6.3    11.6
                                        After    6.8    2.4    7.4    8.5    8.1    6.1    3.4    2        Before    After
                                                                            Mean    8.7    5.5875
                                                                            Variance    4.6685714286    6.8041071429
                                                                            Observations    8    8
                                                                            Pearson Correlation    0.2658886949
                                                                            Hypothesized Mean Difference    0
                                                                            df    7
                                                                            t Stat    3.0239233218
                                                                            P(T<=t) one-tail    0.0096396128
                                                                            t Critical one-tail    1.8945786037
                                                                            P(T<=t) two-tail    0.0192792256
                                                                            t Critical two-tail    2.3646242509
                                                                            Yes, the contamination measurements are lower after use of the new soap.
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?
sol11;48;a
    t-Test: Paired Two Sample for Means
        American    National            data analysis toolpack >> t-Test: Paired Two Sample for Means >> select salary data>> click ok
    Mean    123.27    120.61
    Variance    1611.84    1795.65
    Observations    15    15
    Pearson Correlation    -0.33
    Hypothesized Mean Difference    0.00
    df    14.00
    t Stat    0.15
    P(T<=t) one-tail    0.44
    t Critical one-tail    1.76
    P(T<=t) two-tail    0.88
    t Critical two-tail    2.14
        Salary is relatively higher for American teams than national team.
data 11;48;a
    
        American    National
        118.90    65.8
        168.70    89.6
        110.70    117.2
        87.70    117.7
        172.80    98.3
        69.10    230.4
        112.90    84.6
        146.40    98.7
        108.30    100.1
        213.50    133
        80.80    85.9
        123.20    126.6
        74.80    166.5
        144.80    120.3
        116.40    174.5
t test for 11;48;b
    t-Test: Paired Two Sample for Means
        American    National
    Mean    2323798.86666667    2593535.8        t
    Variance    338601203389.267    353572512947.315
    Observations    15    15
    Pearson Correlation    -0.4499998444
    Hypothesized Mean Difference    0
    df    14
    t Stat    -1.0428222324
    P(T<=t) one-tail    0.1573522121
    t Critical one-tail    1.7613101151
    P(T<=t) two-tail    0.3147044241
    t Critical two-tail    2.1447866813
    same conclusion by student t.test.
chapter 11;48;b part
    American        National
    Mean    2323798.87    Mean    2593535.80        data analysis toolpack >> descriptive statistics >> select Attendance >> click ok
    Standard Error    150244.51    Standard Error    153530.13
    Median    2281202.00    Median    2506789.00
    Standard Deviation    581894.50    Standard Deviation    594619.64
    Sample Variance    338601203389.27    Sample Variance    353572512947.32
    Kurtosis    -0.79    Kurtosis    -0.21
    Skewness    -0.38    Skewness    0.60
    Range    1906741.00    Range    2012580.00
    Minimum    1287054.00    Minimum    1752235.00
    Maximum    3193795.00    Maximum    3764815.00
    Sum    34856983.00    Sum    38903037.00
    Count    15.00    Count    15.00
    Confidence Level(95.0%)    322242.43    Confidence Level(95.0%)    329289.38
    National team has higher mean attendance than American team as displayed vin cell B3: D3.
11;48;2
    American    National
    2281202    2080145
    2880694    2001392
    1755810    2959812
    1388905    2419506
    2726048    2506789
    2153585    3764815
    2708549    1752235
    3012765    2542558
    2220054    2569753
    3193795    1831080
    1768175    2498596
    2193581    2459742
    1287054    3375882
    2491875    3520889
    2794891    2619843
Chapter 11 – Problem 48
    
                                    Team    League    Opened    Team Salary    Attendance    Wins    ERA    BA    HR                Year    Average Salary
                                    Baltimore    American    1992    118.90    2281202    81    4.05    0.25    217                2000    1.99
                                    Boston    American    1912    168.70    2880694    78    4.31    0.265    161                2001    2.26
                                    Chicago White Sox    American    1991    110.70    1755810    76    3.98    0.25    136                2002    2.38
                                    Cleveland    American    1994    87.70    1388905    81    3.67    0.256    141                2003    2.56
                                    Detroit    American    2000    172.80    2726048    74    4.64    0.27    151                2004    2.49
                                    Houston    American    2000    69.10    2153585    86    3.57    0.25    230                2005    2.63
                                    Kansas City    American    1973    112.90    2708549    95    3.73    0.269    139                2006    2.87
                                    LA Angels    American    1966    146.40    3012765    85    3.94    0.246    176                2007    2.94
                                    Minnesota    American    2010    108.30    2220054    83    4.07    0.247    156                2008    3.15
                                    NY Yankees    American    2009    213.50    3193795    87    4.05    0.251    212                2009    3.24
                                    Oakland    American    1966    80.80    1768175    68    4.14    0.251    146                2010    3.3
                                    Seattle    American    1999    123.20    2193581    76    4.16    0.249    198                2011    3.31
                                    Tampa Bay    American    1990    74.80    1287054    80    3.74    0.252    167                2012    3.44
                                    Texas    American    1994    144.80    2491875    88    2.24    0.257    172                2013    3.65
                                    Toronto    American    1989    116.40    2794891    93    3.8    0.269    232                2014    3.95
                                    Arizona    National    1998    65.80    2080145    79    4.04    0.264    154                2015    4.25
                                    Atlanta    National    1996    89.60    2001392    67    4.41    0.251    100                2016    4.4
                                    Chicago...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here