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...
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...
If the 95% confidence interval for the average number of runs scored in a baseball game...
If the 95% confidence interval for the average number of runs scored in a baseball game is 5.8<population mean<6.7, what does this maen?
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...
In 2012, the mean number of runs scored by both teams in a Major League Baseball...
In 2012, the mean number of runs scored by both teams in a Major League Baseball game was 8.62. Following are the numbers of runs scored in sample of 24 games in 2013. A test of whether the mean number of runs in 2013 is less than it was in 2012 will be conducted, using significance level 0.05, by answering the questions below.. 2 10 3 9 15 10 7 4 3 7 5 9 5 9 15 15 4...
Suppose a statistician built a multiple regression model for predicting the total number of runs scored...
Suppose a statistician built a multiple regression model for predicting the total number of runs scored by a baseball team during a season. Using data for n=200 samples, the results below were obtained. Complete parts a through d. Ind. Var. β estimate Standard Error Ind. Var.. β estimate Standard Error Intercept 3.88 17.03 Doubles (X3) 0.74 0.04 Walks (X1) 0.37 0.05 Triples (X4) 1.17 0.23 Singles (X2) 0.51 0.05 Home Runs (X5) 1.44 0.04 a. Write the least squares prediction...
The number of victories (W), earned run average (ERA), runs scored (R), batting average (AVG), and...
The number of victories (W), earned run average (ERA), runs scored (R), batting average (AVG), and on-base percentage (OBP) for each team in the American League in the 2012 season are provided in the following table. The ERA is one measure of the effectiveness of the pitching staff, and a lower number is better. The other statistics are measures of effectiveness of the hitters, and higher numbers are better for each of these. W ERA R AVG OBP Team 1...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT