Question: Would you please help with the below question, explanation, and calculations? I am confused with the T-test from my last incorrect answer; it stated that


Would you please help with the below question, explanation, and calculations?
I am confused with the T-test from my last incorrect answer; it stated that 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.
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



46.35962 2 40.99771 44.29998 A 49.34543 5 56.45518 6 40.05374 45.96145 8 37.25028 9 40.5271 10 35.06629 11 49.40933 12 30.06225 13 50.84365 14 42.31591 15 53.33114 16 41.46249 17 37.31356 18 45.99592 19 60.73918 20 36.37469 21 30.80368 22 41.01212 23 40.34205 24 51.23818 25 41.37963 26 41.12105 27 45.13226 28 52.14477 29 26.53811 30 33.1227 31 41.57607 32 37.2205333 23.30731 34 49.56084 35 30.34152 36 44.97724 37 37.39641 38 44.19479 39 38.18501 40 37.2403 41 35.52391 42 35.6745 43 47.35078 44 41.2035 45 43.4136 46 37.44117 47 51.29911 48 34.53062 49 46.29112 50 58.4883 51 44.7413 52 38.60842 53 51.64968 54 47.97294 55 37.43458 56 33.96244 57 42.32039 58 44.72328 59 41.7972 60 36.38942T= Ex: 1.234 t= p =
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
