Question 1 Using the MLB data file, answer the following questions. a. Conduct a test of the hypothesis to determine whether the mean salary of the teams was different from $100.0 million. H o : μ =...

1 answer below »


Question 1



Using the MLB data file, answer the following questions.




a.Conduct a test of the hypothesis to determine whether the mean salary of the teams was different from $100.0 million.


Ho: μ = 100 H1: μ ≠ 100


Use the .05 significance level. Use thetdistribution for this calculation (since you do not have all of the player salaries, the data in the file represents a sample of the player salaries). Should we reject or fail to reject the null hypothesis? See LO10-6.




b.Using the 5% significance level, conduct a test of the hypothesis to determine whether the mean attendance was more than 2,000,000 per team.


Ho: μ ≤ 2,000,000 H1: μ > 2,000,000 This is a one-tail test. Be sure to choose the correct value from thetdistribution table.


Should we reject or fail to reject the null hypothesis?




c.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? See LO11-3 and LO11-04. Use t-test - two-sample assuming equal variances.



d.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? See LO11-3 and LO11-04. Use t-test - two-sample assuming equal variances.




e.Create a variable that classifies a team's total attendance into three groups: less than 2.0 million; 2.0 million up to 3.0 million; and, 3.0 million or more. At the .05 significance level, is there a difference in the mean number of games won among the three groups? (you will use the ANOVA function)




f.Using the same attendance variable developed in part b, is there a difference in the mean number of home runs hit per team? Usethe .05 significance level.(you will use the ANOVA function)




Question 2



Using the LincolnvilleSchool District bus data
file, answer the following.




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. (use thetdistribution table)


Ho: μ = 10,000 H1: μ ≠ 10,000




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. (use thetdistribution table)


Ho: μ ≤ 4,000 H1: μ > 4,000



Is there a difference in the mean maintenance costs for the diesel versus gasoline buses? Use the .05 significance level.





assignment7buena-54dn4uly.xlsx assignment7mlb-3-tizrvvey.xlsx
Answered Same DayOct 09, 2021

Answer To: Question 1 Using the MLB data file, answer the following questions. a. Conduct a test of the...

Pooja answered on Oct 10 2021
135 Votes
MLB Data Set 17e
    Team    League    Year Opened    Team Salary     Attendance    Wins    ERA    BA    HR            Year    Average salary
    Arizona    National    1998    65.80    2080145    79    4.04    0.264    154            2000    1988034
    Atlanta    National    1996    89.60    2001392    67    4.41    0.251    100            2001    2264403
    Baltimore    American    1992    118.90    2281202    81    4.05    0.250    217            2002    2383235
    Boston    American    1912    168.70    2880694    78    4.31    0.265    161            2003    2555476
    Chicago Cubs    National    1914    117.20    2959812    97    3.36    0.244    171            2004    2486609
    Chicago Sox    American    1991    110.70    1755810    76    3.98    0.250    136            2005    2632655
    Cincinnati    National    2003    117.70    2419506    64    4.33    0.248    167            2006    2866544
    Cleveland    American    1994    87.70    1388905    81    3.67    0.256    141            2007    2944556
    Colorado    National    1995    98.30    2506789    68    5.04    0.265    186            2008    3154845
    Detroit    American    2000    172.80    2726048    74    4.64    0.270    151            2009    3240206
    Houston    American    2000    69.10    2153585    86    3.57    0.250    230            2010    3297828
    Kansas City    American    1973    112.90    2708549    95    3.73    0.269    139            2011    3305393
    LA Angels    American    1966    146.40    3012765    85    3.94    0.246    176            2012    3440000
    LA Dodgers    National    1962    230.40    3764815    92    3.44    0.250    187            2013    3650000
    Miami    National    2012    84.60    1752235    71    4.02    0.260    120            2014    3950000
    Milwaukee    National    2001    98.70    2542558    68    4.28    0.251    145            2015    4250000
    Minnesota    American    2010    108.30    2220054    83    4.07    0.247    156
    NY Mets    National    2009    100.10    2569753    90    3.43    0.244    177
    NY Yankees    American    2009    213.50    3193795    87    4.05    0.251    212
    Oakland    American    1966    80.80    1768175    68    4.14    0.251    146
    Philadelphia    National    2004    133.00    1831080    63    4.69    0.249    130
    Pittsburgh    National    2001    85.90    2498596    98    3.21    0.260    140
    San Diego    National    2004    126.60    2459742    74    4.09    0.243    148
    San Francisco    National    2000    166.50    3375882    84    3.72    0.267    136
    Seattle    American    1999    123.20    2193581    76    4.16    0.249    198
    St. Louis    National    2006    120.30    3520889    100    2.94    0.253    137
    Tampa Bay    American    1990    74.80    1287054    80    3.74    0.252    167
    Texas    American    1994    144.80    2491875    88    4.24    0.257    172
    Toronto    American    1989    116.40    2794891    93    3.8    0.269    232
    Washington    National    2008    174.50    2619843    83    3.62    0.251    177
1a
    Ho: mean salary of the teams was $100.0 million. u=100,000,000                                Year    Average salary
    H1: mean salary of the teams was different from $100.0 million. u=/= 100,000,000                                2000    1988034
                                    2001    2264403
    mean =    3025612                            2002    2383235
    sd=    626994.051429624                            2003    2555476
    n=    16                            2004    2486609
    u=    100000000                            2005    2632655
    alpha=    5%                            2006    2866544
                                    2007    2944556
    test statistic, t = (mean-u)/(sd/sqrt(n))                                2008    3154845
    -618.6622554322                                2009    3240206
                                    2010    3297828
    p-value =     2*(1-P(T<|t|)                            2011    3305393
    p-value =     1.80061771144008E-34                            2012    3440000
                                    2013    3650000
    With t(15) = -618.66, p<5%, i reject null hypothesis at 5% level of...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?