### Question Description

I’m studying for my Mathematics class and need an explanation.

The question is based for Statistical Foundations for Business analytics. Please do in the right way by use excel calculate

### Unformatted Attachment Preview

Purchase answer to see full attachment

## Final Answer

Hello again! So herewith are my answers highlighted in green.

QUESTION 1

Are nursing hourly pay in Tampa, Florida lower than in Dallas, Texas? The data is shown below:

Tampa: sample mean = 39, sample standard deviation = 6.2, sample size = 42

Dallas: sample mean = 48, sample standard deviation = 6.3, sample size = 33

Provide the test statistics value for the analysis.

The two samples are independent of each other. However, if we test for variance using F-test, the

result would be equal variances.

Equal Variances Test Statistics Value = -6.1962

But based on the notes, unequal variances are assumed.

Unequal Variances Test Statistics Value = -6.1842

QUESTION 2

The director of a green energy company is interested ...