Question

In: Statistics and Probability

I don't know if you have the stats for this but I tried to put them...

I don't know if you have the stats for this but I tried to put them in here and it told me this is too long. I do not have Minitab so I would need it in Excel please and thank you so much. It will not let me put all the info in here. Says its too long.

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?

Team Team Salary Attendance Wins
Arizona 65.80 2080145 79
Atlanta 89.60 2001392 67
Baltimore 118.90 2281202 81
Boston 168.70 2880694 78
Chicago Cubs 117.20 2959812 97
Chicago White Sox 110.70 1755810 76
Cincinnati 117.70 2419506 64
Cleveland 87.70 1388905 81
Colorado 98.30 2506789 68
Detroit 172.80 2726048 74
Houston 69.10 2153585 86
Kansas City 112.90 2708549 95
LA Angels 146.40 3012765 85
LA Dodgers 230.40 3764815 92
Miami 84.60 1752235 71
Milwaukee 98.70 2542558 68
Minnesota 108.30 2220054 83
NY Mets 100.10 2569753 90
NY Yankees 213.50 3193795 87
Oakland 80.80 1768175 68
Philadelphia 133.00 1831080 63
Pittsburgh 85.90 2498596 98
San Diego 126.60 2459742 74
San Francisco 166.50 3375882 84
Seattle 123.20 2193581 76
St. Louis 120.30 3520889 100
Tampa Bay 74.80 1287054 80
Texas 144.80 2491875 88
Toronto 116.40 2794891 93
Washington 174.50 2619843 83

Solutions

Expert Solution

For a and b National team data is needed. hence cannot solve it.

Question C have been done in detail to help you understand.

Finding the top 10 and lowest 10 based on team salary.

Hypothesis for wins

By Hand

By Excel

Using two t test for equal variance from the data analysis tab and updated the values as shown

Hypothesis for attendance

By Hand

By Excel

Using two t test for equal variance from the data analysis tab and updated the values as shown


Related Solutions

I know the what the answers are but I don't know how to get them. Can...
I know the what the answers are but I don't know how to get them. Can you please explain the process? Thank you. Part VII. Discontinued Operations and Earnings per Share (11 points) Todd Corporation had pre-tax income for 2017 of $2,500,000. On December 31, 2017, Boyd disposed of a component of its business that represented a strategic shift in operation. That component had a Loss on Discontinued Operations of $450,000 (pre-tax). Boyd received $1,000,000 net cash proceeds from the...
I have a problem, and I have the answer but I don't know where the solution...
I have a problem, and I have the answer but I don't know where the solution comes from. ( I have to be able to solve these myself so please help me by answering the questions about the problem.) Here is the answer given to me by the professor: What is the density of SF4 vapor at 650 torr and 100 C? 650 torr (1atm/760 Torr)=0.855atm 100C=373K PV=nRT n/v=P/RT= 0.855atm/0.8206l-atm/molek) (373)=0.0279 mole/l M.W. of SF4=108.1 gm/mole Density=mass/volume 0.0279 mole/l(108.1gm/mole) Answer...
I already answered the first three questions and put the answer down I just don't know...
I already answered the first three questions and put the answer down I just don't know how to answer the last question which asks to calculate K in the rate law? A clock reaction is run at 20 ÂșC with several different mixtures of iodide, sodium bromate and acid, to form iodine. Thiosulfate is used to react with the iodine formed initially. Starch indicator is added to form a blue color when all the thiosulfate has been used up and...
Below is a diffraction problem. I have the solutions to the problem but I don't know...
Below is a diffraction problem. I have the solutions to the problem but I don't know how to arrive at these solutions. A) In an experiment two slits are separated by 0.22mm and illuminated by light of wavelength 640nm. How far must a screen be placed in order for the bright fringes to be separated by 5 mm? (1.72 m) B) A soap film is illuminated by white light normal to its surface. The index of refraction of the film...
HI, I hope you are doing well. I really don't understand this question and don't know...
HI, I hope you are doing well. I really don't understand this question and don't know how to solve it at all because I am completely new to this c++ programming. can you please explain each line of code with long and clear comments? please think of me as someone who doesn't know to code at all. and I want this code to be written in c++ thank you very much and I will make sure to leave thumbs up....
I have tried to answer the following questions. Please let me know if I missed one...
I have tried to answer the following questions. Please let me know if I missed one and why. 1) A light car and a heavy car are headed toward each other from opposite directions at the same speed. The ground is level. Which of the two will be harder to stop? the heavier car 2) Instead of stopping the cars, you jump out of the way. The two cars crash head-on. After the crash what do you see? The two...
I have the formulas for how to calculate ROI, Margin and Turnover. But I don't know...
I have the formulas for how to calculate ROI, Margin and Turnover. But I don't know if I am using the right numbers and it gets frustrating. A worked out calculation for each would really be helpful so I know what numbers from what years you plugged in. Your time is valuable and would really appreciate the help. If the response is correct, I would not mind giving a like! Return on Investment, Margin, Turnover Ready Electronics is facing stiff...
IMPORTANT: I know the answer is "C". However, I don't know why. Could you please explain...
IMPORTANT: I know the answer is "C". However, I don't know why. Could you please explain why? Thank you A linear total cost curve that passes through the origin implies that a.         average cost is constant and marginal cost is variable. b.         average cost is variable and marginal cost is constant.             c.         average and marginal costs are constant and equal.             d.         you need more information to answer question.
I have n books with n different titles. I want to put them on the shelves...
I have n books with n different titles. I want to put them on the shelves in my library. How many different ways are there to arrange them on one shelf? On two shelves? On k shelves?
Hi, I have a set of three similar questions here. I don't necessarily need them all...
Hi, I have a set of three similar questions here. I don't necessarily need them all answered. Maybe just one or two, what I really need is the formulas used in solving these types of questions and an explanation of that, which doesn't need to be detailed, just an explanation of the notation and variables used. Please!! Thanks! 25. A levered firm has a debt-to-equity ratio of 0.38 and an equity beta of 1.42. What would be the beta of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT