Question

In: Statistics and Probability

Can you show how to answer this in excel and not Minitab? Refer to the Baseball...

Can you show how to answer this in excel and not Minitab? Refer to the Baseball 2016 data, which reports information on the 2016 Major League Baseball season. Let attendance be the dependent variable and total team salary be the independent variable. Determine the regression equation and answer the following questions. a. Draw a scatter diagram. From the diagram, does there seem to be a direct relationship between the two variables? b. What is the expected attendance for a team with a salary of $100.0 million? c. If the owners pay an additional $30 million, how many more people could they expect to attend? d. At the .05 significance level, can we conclude that the slope of the regression line is positive? Conduct the appropriate test of hypothesis. e. What percentage of the variation in attendance is accounted for by salary? f. Determine the correlation between attendance and team batting average and between attendance and team ERA. Which is stronger? Conduct an appropriate test of hypothesis for each set of variables.

Team Salary Attendance
118.90 2281202
168.70 2880694
110.70 1755810
87.70 1388905
172.80 2726048
69.10 2153585
112.90 2708549
146.40 3012765
108.30 2220054
213.50 3193795
80.80 1768175
123.20 2193581
74.80 1287054
144.80 2491875
116.40 2794891
65.80 2080145
89.60 2001392
117.20 2959812
117.70 2419506
98.30 2506789
230.40 3764815
84.60 1752235
98.70 2542558
100.10 2569753
133.00 1831080
85.90 2498596
126.60 2459742
166.50 3375882
120.30 3520889
174.50 2619843

Solutions

Expert Solution

(a)

From the scatter plot, it is observed that Team Salary and Attendance are positively correlated and there seems to be a direct relationship between these two variables.

(b)

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.706773855
R Square 0.499529282
Adjusted R Square 0.481655328
Standard Error 427738.1077
Observations 30
ANOVA
df SS MS F Significance F
Regression 1 5.11324E+12 5.11324E+12 27.94733 1.26761E-05
Residual 28 5.12288E+12 1.8296E+11
Total 29 1.02361E+13
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 1196918.806 251124.0645 4.766244957 5.25E-05 682514.4788 1711323.133
Team Salary 10347.28988 1957.295783 5.286523357 1.27E-05 6337.951214 14356.62854


Related Solutions

Show how to answer this in EXCEL ONLY, NO megastat or minitab, etc.. Please highlight what...
Show how to answer this in EXCEL ONLY, NO megastat or minitab, etc.. Please highlight what data tools or formulas were used. A survey investigated the public’s attitude toward the federal deficit. Each sampled citizen was classified as to whether he or she felt the government should reduce the deficit or increase the deficit, or if the individual had no opinion. The sample results of the study by gender are reported to below. Gender Reduce the Deficit Increase the Deficit...
PLEASE SHOW HOW TO SOLVE IN EXCEL SHOW STEPS Refer to the Johnson Filtration problem introduced...
PLEASE SHOW HOW TO SOLVE IN EXCEL SHOW STEPS Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Repair Time in Hours Months Since Last Service Type of Repair Repairperson 2.9 2 Electrical Dave Newton 3 6 Mechanical...
How can I solve this in Excel? Please show how to solve it in excel step...
How can I solve this in Excel? Please show how to solve it in excel step by step. 1) Speedy Wheels is a wholesale distributor of bicycles for the western United States. Its Inventory Manager, Ricky Sapolo, is currently reviewing the inventory policy for one popular model — a small, one-speed girl's bicycle that is selling at the rate of 250 per month. The administrative cost for placing an order for this model from the manufacturer is $200 and the...
Can you put this in excel and show the formulas of how you're getting the answers...
Can you put this in excel and show the formulas of how you're getting the answers please! Hi-Tek Manufacturing Inc. makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown below: Hi-Tek Manufacturing Inc. Income Statement Sales $ 1,718,000 Cost of goods sold 1,220,369 Gross margin 497,631 Selling and administrative expenses 650,000 Net operating loss $ (152,369) Hi-Tek produced and sold 60,300 units of B300 at a...
Conduct an analysis (you can use Excel) to answer the following question. Show an ANOVA table....
Conduct an analysis (you can use Excel) to answer the following question. Show an ANOVA table. A grower wishes to compare yields of four different varieties of pumpkins for yield (tons/ac).  His experiment consisted of four replications for each variety.  Is there a significant difference between the varieties in yield?  Do a Tukey’s test. Give complete conclusions with a properly labeled tabulated results. Data are as follows: Variety A        Variety B        Variety C       Variety D 27                   29                   30                   32 28                   28                   29                   29 29                   29                   29                   31 25                   27                   31                   32 An experiment was conducted to compare the...
Please answer in excel only. How do I create the graphs in excel and show the...
Please answer in excel only. How do I create the graphs in excel and show the data. Discuss the following two cost functions: TC=20+4Q TC=20+2Q+0.5Q^2 a) Calculate all cost curves and plot these curves on graphs. Total Cost Total Fixed Cost Total Variable Cost Average Total Cost Average Fixed Cost Average Variable Cost Marginal Cost b) In each case, indicate the point at which diminishing returns occur. (For question a), compute the required costs and plot the curves for quantities...
Hello! Can you show me how to this problem by hand? No Excel please! An organization...
Hello! Can you show me how to this problem by hand? No Excel please! An organization is considering the purchase of new machines to automatically conduct some quality control tasks. The machines are expected to save production cost which is given below as Annual Income. The machines are expected to be part of the production process for 5 years. The company has a minimum attractive rate of return (MARR) of 5.4%. The following data is available for these new machines:...
Show all work. Use Minitab as much as you can. Majority of problems from: Montgomery &...
Show all work. Use Minitab as much as you can. Majority of problems from: Montgomery & Runger, 2007 Question 1: The following data are the joint temperatures of the O-rings (degrees F) for each test firing or actual launch of the space shuttle rocket motor: 84, 49, 61, 40, 83, 67, 45, 66, 70, 69, 80, 58, 68, 60, 67, 72, 73, 70, 57, 63, 70, 78, 52, 67, 53, 67, 75, 61, 70, 81, 76, 79, 75, 76, 58,...
Can you show me how to use Excel to do the calculations? Sam Strother and Shawna...
Can you show me how to use Excel to do the calculations? Sam Strother and Shawna Tibbs are vice presidents of Mutual of Seattle Insurance Company and co-directors of the company’s pension fund management division. An important new client, the North-Western Municipal Alliance, has requested that Mutual of Seattle present an investment seminar to the mayors of the represented cities, and Strother and Tibbs, who will make the actual presentation, have asked you to help them by answering the following...
Show work and explain how you got your answer, do not just post an excel spreadsheet...
Show work and explain how you got your answer, do not just post an excel spreadsheet with answers please. You are deciding between two mutually exclusive investment opportunities. Both require the same initial investment of $ 10.3 million. Investment A will generate $ 2.18 million per year​ (starting at the end of the first​ year) in perpetuity. Investment B will generate $ 1.51 million at the end of the first​ year, and its revenues will grow at 2.2 % per...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT