Hello,

I need assistance with the below question, explanation, and calculations.

I also need to understand the T-test as my calculations prior were incorrect. I received a response that says, "The "T-test: Two-Sample Assuming Unequal Variances" function from the Analysis ToolPak should be used, with a column of zeros for the Variable two values." Thanks.

Use Sheet 8 of the Excel file to answer the following questions. A power company is installing utility poles that are supposed to have a height of 40 feet. The foreman checks a random sample of 60 poles to determine if the mean height is 40 feet at a significance level of 0.05. Create a histogram, and calculate x, the t-statistic, and the p-value.

From the histogram, can normality be assumed? Yes or No

T= Ex: 1.234 t= p =