[Solved]1 Use Confidencenorm Function Cell H8 Calculate 95 Confidence Interval Weight Men 2 Use Co Q37229853

1. Use the CONFIDENCE.NORM function in cell H8 to calculate the95% confidence interval for the weight of the men.

2. Use the CONFIDENDE.NORM function in cell I8 to calculate the95% confidence interval for the height of the men.

3. Use the CONFIDENDE.NORM function in cell J8 to calculate the95% confidence interval for the BMI of the men.

4. Use the CORREL function in cell J11 to determine if there isa statistical relationship between the height and weight of the menin the sample.

5. Use the FORECAST.LINEAR function (or the FORECAST function ifyou are not using Excel 2016) in cell J15 to predict Jim’s weightfrom his height. Reference Jim’s height in cell J14 and appropriatecolumns from the sample data table.

6. In cells J18 and J19, use the information you calculatedabout the confidence interval for weight to determine the lower andupper bounds for the 95% confidence interval for your prediction ofJim’s weight in cell J15. Be sure to reference the confidenceinterval calculation rather than hard coding it in yourcalculation.

Survey of Men’s Weight and Height Statistics Wei 185.22 173.09 173.24 155.81 162.83 141.69 194.85 201.81 136.98 156.22 194.71 125.78 183.75 128.15 202.77 154.39 139.91 200.67 206.44 250.26 153.79 219.13 181.56 166.69 207.97 119.41 207.78 168.17 178.07 187.84 BMI 24.61 25.53 24.71 BMI 72.74 69.03 70.21 68.76 70.94 67.50 76.92 70.74 63.36 70.40 70.61 72.47 70.82 71.02 70.00 70.06 70.35 Weight Height Count 200.00 173.67 Average 22.75 21.86 23.15 95% Cl** Correlation coefficient> 23.99 27.46 16.84 25.76 17.86 29.09 Jim’s Height (in inches)-> Predict Jim’s Weight-> Forecast Confidence Interval Lower Weight Bound-> Upper Weight Bound-> 19.87 Note: the STDEVS function is not available in Excel 2007. Ifyou are using Excel 2007, use the STDEV funtion instead 27.41 27.88 22.01 29.41 25.37 23.53 30.80 16.45 30.74 24.92 72.77 79.44 70.09 Note: the CONFIDENCE.NORMfunction is not available in Excel 2007. ifyou are using Excel 2007, use the CONFIDENCE function instead 70.93 70.58 68.89 Note: the FORECAST.LINEAR function is not available prior to Excel 2016. Ifyou are using a prior version ofExcel, use the FORECASTfunction instead 68.94 68.88 68.66 25.78 Show transcribed image text Survey of Men’s Weight and Height Statistics Wei 185.22 173.09 173.24 155.81 162.83 141.69 194.85 201.81 136.98 156.22 194.71 125.78 183.75 128.15 202.77 154.39 139.91 200.67 206.44 250.26 153.79 219.13 181.56 166.69 207.97 119.41 207.78 168.17 178.07 187.84 BMI 24.61 25.53 24.71 BMI 72.74 69.03 70.21 68.76 70.94 67.50 76.92 70.74 63.36 70.40 70.61 72.47 70.82 71.02 70.00 70.06 70.35 Weight Height Count 200.00 173.67 Average 22.75 21.86 23.15 95% Cl** Correlation coefficient> 23.99 27.46 16.84 25.76 17.86 29.09 Jim’s Height (in inches)-> Predict Jim’s Weight-> Forecast Confidence Interval Lower Weight Bound-> Upper Weight Bound-> 19.87 Note: the STDEVS function is not available in Excel 2007. Ifyou are using Excel 2007, use the STDEV funtion instead 27.41 27.88 22.01 29.41 25.37 23.53 30.80 16.45 30.74 24.92 72.77 79.44 70.09 Note: the CONFIDENCE.NORMfunction is not available in Excel 2007. ifyou are using Excel 2007, use the CONFIDENCE function instead 70.93 70.58 68.89 Note: the FORECAST.LINEAR function is not available prior to Excel 2016. Ifyou are using a prior version ofExcel, use the FORECASTfunction instead 68.94 68.88 68.66 25.78

Expert Answer

---

Answer to 1. Use the CONFIDENCE.NORM function in cell H8 to calculate the 95% confidence interval for the weight of the men. 2. Us… . . .