Question

In: Statistics and Probability

PLEASE COMPUTE THE FOLLOWING IN EXCEL and show the excel sheet, Thank you so much! The...

PLEASE COMPUTE THE FOLLOWING IN EXCEL and show the excel sheet, Thank you so much!

The following are the runs scored totals for 9 players for the 2016 New York Yankees: 56,43,63,68,58,80,71,32,19

(a) Find the mean and median

(b) Find the standard deviation of this population

(c) Considering this as a normal sample of American League players for the 2016 season, find a 99% Confidence Interval for the actual mean of Runs Scored for AL players, 2016 .

(d) Considering this as a normal sample of American League players for the 2016 season, find a 90% Confidence Interval for the actual mean of Runs Scored for AL players, 2016 .

Solutions

Expert Solution

(a) In order to find the mean and the median we use : 1. AVERAGE

2. MEDIAN

(b) In order to find Sd, we use STDEV

(C) we then find the confidence intervals.

(d)

The following table shows the measures

Runs scored Measures:
56
43 mean 54.44444
63 median 58
68 standard dev 19.65395
58 99% CI 16.87507
80 90% CI 10.77596
71
32
19

(c)

Considering this as a normal sample of American League players for the 2016 season, find a 99% Confidence Interval for the actual mean of Runs Scored for AL players, 2016 is given as:

(54.44-16.875,54.44+16.875)

=(37.565,71.315)

(d)

Considering this as a normal sample of American League players for the 2016 season, find a 90% Confidence Interval for the actual mean of Runs Scored for AL players, 2016 is given as:

(54.44-10.776,54.44+10.776)

=(44.664,65.216)

orchestra answered 1 year ago
Next > < Previous

Related Solutions

FIND THE ANSWER WITH EXCEL PLEASE! THANK YOU SO MUCH! (2) The lifetime of a computer...
FIND THE ANSWER WITH EXCEL PLEASE! THANK YOU SO MUCH! (2) The lifetime of a computer circuit has an exponential distribution with mean of three years. Find the probability that a circuit lasts longer than 4 years.
Please show your work and formula on excel sheet. Thank you. Assume you borrow $8,000,000 with...
Please show your work and formula on excel sheet. Thank you. Assume you borrow $8,000,000 with a coupon rate of 8% from a bank as a mortgage against your newly renovated plant. The loan is paid off in 7 years. You will pay an equal amount every year until the loan is fully paid off. What are the interest and principal payments for each year of the loan.
*will someone please explain/show the steps in this process for me? Thank you so much! Amy...
*will someone please explain/show the steps in this process for me? Thank you so much! Amy company produces and sells a toy for $205 per unit. In the first year of operations, 100,000 units were produced and 75,000 were sold. other information for the year includes: direct materials $31 per unit direct manufacturing labor $3 per unit variable manufacturing overhead costs $4 per unit sales selling expenses $4 per unit total fixed manufacturing costs $1,250,000 total fixed administrative expenses $950,000...
Please answer each question and show calculation/ provide explanations. Thank you so much. Question 1 You...
Please answer each question and show calculation/ provide explanations. Thank you so much. Question 1 You have just been hired as the staff accountant for Maximum Corporation. However, the accounting manager is unclear about your ability to determine where certain increases and decreases should be placed. Indicate in the columns below by placing a check-mark (√        ) in the appropriate column identified. Office rent is increased.                                   Service Revenue is increased. Prepaid Expense is reduced. Cash is decreased. Plant and machinery...
Please use excel to find the following, thank you very much! (8) A sample of 600...
Please use excel to find the following, thank you very much! (8) A sample of 600 Scholastic Aptitude Test (SAT) results has mean of 500 and standard deviation of 100. a. Determine the score below which 10% of the values lie. b. Determine the score above which 10% of the values lie. c. Determine a 95% confidence interval for the true mean.
PLEASE ANSWER USING EXCEL. please show formulas used in excel. THANK YOU :) Parry Enterprises sells...
PLEASE ANSWER USING EXCEL. please show formulas used in excel. THANK YOU :) Parry Enterprises sells copy paper by the case to office supply stores. Each case of paper costs Parry $15. The operating costs are $30,000 per period. Each period, Parry sells approximately 15,000 cases of copy paper at $35 per case. Texas Office Emporium is requesting an order of 4,000 cases of copy paper in the next period at a price of $25 per case. Since Parry has...
PLEASE ANSWER USING EXCEL. please show formulas used in excel. THANK YOU :) Parry Enterprises sells...
PLEASE ANSWER USING EXCEL. please show formulas used in excel. THANK YOU :) Parry Enterprises sells copy paper by the case to office supply stores. Each case of paper costs Parry $15. The operating costs are $30,000 per period. Each period, Parry sells approximately 15,000 cases of copy paper at $35 per case. Texas Office Emporium is requesting an order of 4,000 cases of copy paper in the next period at a price of $25 per case. Since Parry has...
Audit and Investigation- Please assist me in answering this in essayform please. Thank you so much...
Audit and Investigation- Please assist me in answering this in essayform please. Thank you so much As part of the planning an audit and designing an audit approach one major part of the planning is to understand the client’s business and industry. Select a specific business example and provide a bullet point analysis of what would be of interest in the understanding of that client business and industry and its impact on the audit
Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use...
Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use the stocks of Apple, SAP, IBM, Oracle, and Amazon Download the historical data of weekly stock prices and S&P 500 index prices from year 2017-2019 on the website of yahoo finance and save it on an excel file. B. Use a different sheet to save the market adjusted prices of Apple, SAP, IBM, Oracle, and Amazon t and the index. For each stock, compute...
Please if you could do each problem, and show steps for excel! Thank you! You will...
Please if you could do each problem, and show steps for excel! Thank you! You will graduate in a few years and start working and it’s never too early to start planning for your retirement and other financial events. Let’s fast forward to the beginning of your career. Here’s some assumptions to help you get started. Your starting annual salary will be $60,000. You plan to work for 43 years before retiring. You expect your salary to grow at an...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT