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
OR
OR