Question

In: Statistics and Probability

The following are the runs scored totals for 9 players for the 2016 New York Mets:...

The following are the runs scored totals for 9 players for the 2016 New York Mets:

88,72,65,57,45,38,31,30,27

  1. Find the mean and median
  2. Find the standard deviation of this population
  3. Considering this as a normal sample of National League players for the 2016 season, find a 99% Confidence Interval for the actual mean of Runs Scored for NL players, 2016 .
  4. Considering this as a normal sample of National League players for the 2016 season, find a 90% Confidence Interval for the actual mean of Runs Scored for NL players, 2016 .

**PLEASE SHOW HOW TO DO IN EXCEL

**

Solutions

Expert Solution

## There is direct function to calculate mean , median , mode and standard deviation for sample and population in Excel . used funtion and calculate values .

## confidece interval calculate by using tools and without tools :

point estimate of the population mean is sample mean :

lower limit = mean - margin of error  

upper limit = mean + margin of error


Related Solutions

Listed below are the 25 players on the opening-day roster of the 2016 New York Yankees...
Listed below are the 25 players on the opening-day roster of the 2016 New York Yankees Major League Baseball team, their salaries, and fielding positions. Player Position Salary (US$) C.C. Sabathia Starting Pitcher $ 25,000,000 Mark Teixeira First Base $ 23,125,000 Masahiro Tanaka Starting Pitcher $ 22,000,000 Jacoby Ellsbury Center Field $ 21,142,857 Alex Rodriguez Designated Hitter $ 21,000,000 Brian McCann Catcher $ 17,000,000 Carlos Beltran Right Field $ 15,000,000 Brett Gardner Left Field $ 13,500,000 Chase Headley Third Base...
Listed below are the 25 players on the opening-day roster of the 2016 New York Yankees...
Listed below are the 25 players on the opening-day roster of the 2016 New York Yankees Major League Baseball team, their salaries, and fielding positions. Player Position Salary (US$) C.C. Sabathia Starting Pitcher $ 25,000,000 Mark Teixeira First Base $ 23,125,000 Masahiro Tanaka Starting Pitcher $ 22,000,000 Jacoby Ellsbury Center Field $ 21,142,857 Alex Rodriguez Designated Hitter $ 21,000,000 Brian McCann Catcher $ 17,000,000 Carlos Beltran Right Field $ 15,000,000 Brett Gardner Left Field $ 13,500,000 Chase Headley Third Base...
On July​ 1, 2000, the New York Mets reached an agreement with Bobby Bonilla to defer...
On July​ 1, 2000, the New York Mets reached an agreement with Bobby Bonilla to defer the remaining​ $5.9 million on​ Bonilla’s contract​ (with interest), which would have otherwise been due to be paid immediately. The deferment agreement called for the salary to be paid in 25 equal​ installments, with the first payment being made on July​ 1, 2011. The agreement stipulated that the relevant interest rate applied to this deal would be​ 9%. Beginning on July​ 1, 2011​ (and...
25 New York Yankees players from the Major League Baseball, 2016 season, were asked about their...
25 New York Yankees players from the Major League Baseball, 2016 season, were asked about their salaries. They were further classified into pitchers and non-pitchers and the following data on their wages were obtained: 14 pitchers with sample mean = 8,592,211 and sample standard deviation = 8,869,873 11 non-pitchers with sample mean = 8,335,158 and sample standard deviation = 8,969,283 Assume that the population deviations are the same. to. Considering a significance level of 0.01, can it be concluded that...
1. Definition of economic costs Yakov lives in New York City and runs a business that...
1. Definition of economic costs Yakov lives in New York City and runs a business that sells pianos. In an average year, he receives $851,000 from selling pianos. Of this sales revenue, he must pay the manufacturer a wholesale cost of $476,000; he also pays wages and utility bills totaling $281,000. He owns his showroom; if he chooses to rent it out, he will receive $71,000 in rent per year. Assume that the value of this showroom does not depreciate...
Read the July 9, 2006 the Freakonomics column in the New York Times Magazine uploaded in...
Read the July 9, 2006 the Freakonomics column in the New York Times Magazine uploaded in the docs and stuff section of this site. The authors examine a simple supply-and-demand gap with tragic implications: the shortage of human organs for transplantation. In the space of just a few decades, transplant surgery has become remarkably safe and reliable. But this success has bred huge demand: as more patients get new organs, more patients want them. So, while the number of kidney...
The following is a chart of 25 baseball players' salaries and statistics from 2016. Player Name...
The following is a chart of 25 baseball players' salaries and statistics from 2016. Player Name RBI's HR's AVG Salary (in millions) Joe Mauer 49 11 0.261 23.000 Robinson Cano 103 39 0.298 24.050 Leonys Martin 47 15 0.245 4.150 Brandon Crawford 84 12 0.275 6.000 Colby Rasmus 54 15 0.206 15.800 Carlos Gonzalez 100 25 0.298 17.454 Matt Kemp 108 35 0.268 21.500 Prince Fielder 44 8 0.212 18.000 Mark Teixeira 44 15 0.204 23.125 Yoenis Cespedes 86 31...
Suncor Energy Inc. (SU) shares are listed on the New York Stock Exchange. At 9:30 a.m....
Suncor Energy Inc. (SU) shares are listed on the New York Stock Exchange. At 9:30 a.m. on January 14, 2016, these shares sold for $21.85 per share. The volatility on the returns of Suncor shares is approximately 24%. The following call and put option contracts were available for the months of January, February, and March: CALLS Strike/Expiry January 22, 2016 February 19, 2016 March 18, 2016 23 0.34 0.72 0.96 24 0.13 0.41 0.69 25 0.25 0.26 0.40 PUTS Strike/Expiry...
Suncor Energy Inc. (SU) shares are listed on the New York Stock Exchange. At 9:30 a.m....
Suncor Energy Inc. (SU) shares are listed on the New York Stock Exchange. At 9:30 a.m. on January 14, 2016, these shares sold for $21.85 per share. The volatility on the returns of Suncor shares is approximately 24%. The following call and put option contracts were available for the months of January, February, and March: CALLS Strike/Expiry January 22, 2016 February 19, 2016 March 18, 2016 23 0.34 0.72 0.96 24 0.13 0.41 0.69 25 0.25 0.26 0.40 PUTS Strike/Expiry...
a. In an article in the New York Times in 2009, the author makes the following...
a. In an article in the New York Times in 2009, the author makes the following statement: “And whenever the economy begins growing again, it won’t feel good for a while. The unemployment rate may continue to rise into 2010.” Why would the unemployment rate continue to rise if the economy has begun to grow again? (3pts) b. Why isn’t unemployment rate equal to zero when the economy is at full employment? Briefly explain. (3pts) c. If the quantity of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT