Use the COUNT function in cell H5 to calculate the number of men in the sample. Use C4:C203 as the argument for your function.

Summary Statistics Height BMI Count Average Standard* 95% CI** Weight =COUNT(C4:C203) =AVERAGE(C4:C203) ESTDEV.S(C4:C203) =CONFIDENCE.NORM(0.05, H7,H5) AVERAGE(D4:D203) ESTDEV.S(D4:D203) =CONFIDENCE.NORM(0.05,17,H5) =AVERAGE(E4:E203) ESTDEV.S(E4:E203) =CONFIDENCE.NORM(0.05,37,45) Correlation Correlation coefficient ---> =CORREL(D4:D203,C4:C203) Forecast*** 70 Jim's Height (in inches) ---> Predict Jim's Weight ---> =FORECAST.LINEAR(J14,C4:C203,D4:D203) Forecast Confidence Interval Lower Weight Bound ---> Upper Weight Bound ---> =J15-H8 =)15+18 Statistical Analysis 1990 Wins Task Response =COUNT(G4:G33) Number of MLB Teams in 1990 76 88 67 T=COUNT(F4:F33) Number of MLB teams in 2010 =AVERAGE(E4:E33) Average salary for the teams in 1990. =AVERAGE(D4:D33) Average salary for the teams in 2010. -STDEV.P(G4:G33) Population standard deviation for wins 1990. TESTDEV.P(F4:F33) Population standard deviation* for wins in 2010. 103 1990 Were teams more similar regarding wins in 1990 or 2010? 83 =CORREL(F4:F33,D4:033) Correlation between the number of wins a team earned in 2010 and the amount team =CORREL(G4:G33, E4:E33) Correlation between the number of wins a team earned in 1990 and the amount team 2010 Is the relationship between wins and salary stronger in 1990 or 2010? 750 =FORECAST.LINEAR(129,74:F33,D4:D33) Salary Amount 150000000 How many wins could a team expect to earn in 2010 if they paid $150,000,000 in sala NA 86 =CONFIDENCE.NORM(0.05,114,16) What is the 95% confidence interval*** for wins in 2010? 85 =127+131 Upper 95% confidence interval level. =127-131 Lower 95% confidence interval level. Summary Statistics Height BMI Count Average Standard* 95% CI** Weight =COUNT(C4:C203) =AVERAGE(C4:C203) ESTDEV.S(C4:C203) =CONFIDENCE.NORM(0.05, H7,H5) AVERAGE(D4:D203) ESTDEV.S(D4:D203) =CONFIDENCE.NORM(0.05,17,H5) =AVERAGE(E4:E203) ESTDEV.S(E4:E203) =CONFIDENCE.NORM(0.05,37,45) Correlation Correlation coefficient ---> =CORREL(D4:D203,C4:C203) Forecast*** 70 Jim's Height (in inches) ---> Predict Jim's Weight ---> =FORECAST.LINEAR(J14,C4:C203,D4:D203) Forecast Confidence Interval Lower Weight Bound ---> Upper Weight Bound ---> =J15-H8 =)15+18 Statistical Analysis 1990 Wins Task Response =COUNT(G4:G33) Number of MLB Teams in 1990 76 88 67 T=COUNT(F4:F33) Number of MLB teams in 2010 =AVERAGE(E4:E33) Average salary for the teams in 1990. =AVERAGE(D4:D33) Average salary for the teams in 2010. -STDEV.P(G4:G33) Population standard deviation for wins 1990. TESTDEV.P(F4:F33) Population standard deviation* for wins in 2010. 103 1990 Were teams more similar regarding wins in 1990 or 2010? 83 =CORREL(F4:F33,D4:033) Correlation between the number of wins a team earned in 2010 and the amount team =CORREL(G4:G33, E4:E33) Correlation between the number of wins a team earned in 1990 and the amount team 2010 Is the relationship between wins and salary stronger in 1990 or 2010? 750 =FORECAST.LINEAR(129,74:F33,D4:D33) Salary Amount 150000000 How many wins could a team expect to earn in 2010 if they paid $150,000,000 in sala NA 86 =CONFIDENCE.NORM(0.05,114,16) What is the 95% confidence interval*** for wins in 2010? 85 =127+131 Upper 95% confidence interval level. =127-131 Lower 95% confidence interval level