Question

In: Statistics and Probability

Part 4 of 4 - F-Distribution and Three or More Means The following data represent weights...

Part 4 of 4 - F-Distribution and Three or More Means

The following data represent weights (pounds) of a random sample of professional football players on the following teams.

X1 = weights of players for the Dallas Cowboys

X2 = weights of players for the Green Bay Packers

X3 = weights of players for the Denver Broncos

X4 = weights of players for the Miami Dolphins

X5 = weights of players for the San Francisco Forty Niners

You join a Fantasy Football league and you are wondering if weight is a factor in winning Football games.

Looking at the Summary output, which two teams have the biggest difference in weight?

See Attached Excel for Data.

Reference: The Sports Encyclopedia Pro Football

Dallas Cowboys Wt. 250 255 255 264 250 265 245 252 266 246 251 263 248 228 221 223 220

Green Bay Packers Wt. 260 271 258 263 267 254 255 250 248 240 254 275 270 225 222 230 225

Denver Broncos Wt. 270 250 281 273 257 264 233 254 268 252 256 265 252 256 235 216 241

Miami Dolphins Wt. 260 255 265 257 268 263 247 253 251 252 266 264 210 236 225 230 232

San Fran. 49ers Wt. 247 249 255 247 244 245 249 260 217 208 228 253 249 223 221 228 271

  • A. San Francisco 49ers and Green Bay Packers
  • B. San Francisco 49ers and Miami Dolphins
  • C. Denver Broncos and San Francisco 49ers
  • D. Denver Broncos and Miami Dolphins

Solutions

Expert Solution

Summary data from excel can be calculated using Data Analysis option under the menu DATA.

Excel --> Click on Data menu --> Data Analysis --> Descriptive statistics

under that select the in row wise or column wise with labels on and click on summary statistics and press ok.

Summary statistics Dallas Cowboys Wt. Green Bay Packers Wt. Denver Broncos Wt. Miami Dolphins Wt. San Fran. 49ers Wt.
Mean 247.18 251.00 254.29 249.06 240.82
Standard Error 3.72 4.14 3.94 4.07 4.12
Median 250.00 254.00 256.00 253.00 247.00
Mode 250.00 254.00 252.00 #N/A 249.00
Standard Deviation 15.34 17.08 16.24 16.76 16.99
Sample Variance 235.28 291.63 263.60 281.06 288.53
Kurtosis -0.58 -0.93 0.64 0.14 -0.55
Skewness -0.73 -0.49 -0.68 -0.96 -0.36
Range 46.00 53.00 65.00 58.00 63.00
Minimum 220.00 222.00 216.00 210.00 208.00
Maximum 266.00 275.00 281.00 268.00 271.00
Sum 4202.00 4267.00 4323.00 4234.00 4094.00
Count 17.00 17.00 17.00 17.00 17.00

Looking at the Summary output, Denver Broncos and San Francisco 49ers teams have the biggest difference in weight.


Related Solutions

The following data represent weights (pounds) of a random sample of professional football players on the...
The following data represent weights (pounds) of a random sample of professional football players on the following teams. X1 = weights of players for the Dallas Cowboys X2 = weights of players for the Green Bay Packers X3 = weights of players for the Denver Broncos X4 = weights of players for the Miami Dolphins X5 = weights of players for the San Francisco Forty Niners You join a Fantasy Football league and you are wondering if weight is a...
The following data represent weights (pounds) of a random sample of professional football players on the...
The following data represent weights (pounds) of a random sample of professional football players on the following teams. X1 = weights of players for the Dallas Cowboys X2 = weights of players for the Green Bay Packers X3 = weights of players for the Denver Broncos X4 = weights of players for the Miami Dolphins X5 = weights of players for the San Francisco Forty Niners You join a Fantasy Football league and you are wondering if weight is a...
Estimating and testing for means We will work with the following (sorted) data, assumed to represent...
Estimating and testing for means We will work with the following (sorted) data, assumed to represent a simple random sample from a normal distribution −1.0173 −0.3243 0.36416 0.96709 −0.7724 −0.1004 0.49382 0.98607 −0.7492 −0.0661 0.49734 1.08517 −0.6438 0.08449 0.51945 1.15909 −0.5727 0.11064 0.64080 1.23061 −0.4562 0.15022 0.66312 1.30328 −0.3986 0.25865 0.84739 1.57912 The usual summaries are Sum 7.83952 Count 28 Sum of squares 16.1280 1. Confidence Intervals Determine a confidence interval for the mean of the normal distribution we sampled...
The following data represent weights in kilograms of maize harvest from a random sample of 72...
The following data represent weights in kilograms of maize harvest from a random sample of 72 experimental plots on St. Vincent, an island in the Caribbean (Reference: B. G. F. Springer, Proceedings, Caribbean Food Corps. Soc., Vol. 10, pp. 147–152). Note: These data are also available with other software on the Stat Space CD-ROM. For convenience, the data are presented in increasing order. 7.8, 9.1, 9.5, 10.0, 10.2, 10.5, 11.1, 11.5, 11.7, 11.8, 12.2, 12.2, 12.5, 13.1, 13.5, 13.7, 13.7,...
The distribution of weights for an industrial part appears to follow a normal distribution. You randomly...
The distribution of weights for an industrial part appears to follow a normal distribution. You randomly selected 21 parts from a large batch of those parts, and determined the sample standard deviation = 4 g. If you want to test H0: σ2 = 16 versus Ha: σ2 ≠ 16, what is the absolute value of the test statistic you would use?
The data in the accompanying table represent the heights and weights of a random sample of...
The data in the accompanying table represent the heights and weights of a random sample of professional baseball players. Complete parts ​(a) through ​(c) below. Player   Height_(inches)   Weight_(pounds) Player_1   76   227 Player_2   75   197 Player_3   72   180 Player_4   82   231 Player_5   69   185 Player_6   74   190 Player_7   75   228 Player_8   71   200 Player_9   75   230 (b) Determine the​ least-squares regression line. Test whether there is a linear relation between height and weight at the alphaαequals=0.05 level of significance. Determine the​...
The data in the accompanying table represent the heights and weights of a random sample of...
The data in the accompanying table represent the heights and weights of a random sample of professional baseball players. Complete parts ​(a) through ​(c) below. Player Height​ (inches) Weight​ (pounds) Player 1 75 225 Player 2 75 197 Player 3 72 180 Player 4 82 231 Player 5 69 185 Player 6 7474 190190 Player 7 75 228 Player 8 71 200 Player 9 75 230 (a) Draw a scatter diagram of the​ data, treating height as the explanatory variable...
The data in the accompanying table represent the heights and weights of a random sample of...
The data in the accompanying table represent the heights and weights of a random sample of professional baseball players. Complete parts ​(a) through ​(c) below. Player   Height_(inches)   Weight_(pounds) Player_1   75   227 Player_2   75   195 Player_3   72   180 Player_4   82   231 Player_5   69   185 Player_6   74   190 Player_7   75   228 Player_8   71   200 Player_9   75   230 ​(a) Draw a scatter diagram of the​ data ​(b) Determine the​ least-squares regression line. Test whether there is a linear relation between height and weight...
The following data represent the probability distribution of the holding period returns for an investment in...
The following data represent the probability distribution of the holding period returns for an investment in Lazy Rapids Kayaks (LARK) stock. State of the Economy Scenario #(s) Probability, p(s) HPR Boom 1 0.324 30.80% Normal growth 2 0.396 8.90% Recession 3 0.28 -18.00% a. What is the expected return on LARK? (Round your answer to 2 decimal places.) Expected return % b. What is the standard deviation of the returns on LARK? (Round your answer to 2 decimal places.) Standard...
The following data represent the probability distribution of the holding period returns for an investment in...
The following data represent the probability distribution of the holding period returns for an investment in Lazy Rapids Kayaks (LARK) stock. State of the Economy Scenario #(s) Probability, p(s) HPR Boom 1 0.328 30.00% Normal growth 2 0.402 9.40% Recession 3 0.27 -18.30% a. What is the expected return on LARK? (Round your answer to 2 decimal places.) Expected return               % b. What is the standard deviation of the returns on LARK? (Round your answer to 2 decimal places.) Standard deviation...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT