Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribed

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

image text in transcribedimage text in transcribedimage text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Interconnection Networks

Authors: J C Bermond

1st Edition

1483295273, 9781483295275

More Books

Students also viewed these Mathematics questions