(a) I do not have a current copy of Excel. Here are the instructions to get the results from the F-Test:

(1) Enter the data into columns A and B

(2) From the toolbar select Data -> Data Analysis

(3) Analysis Tools -> F-Test

(4) Input the ranges for A and B

(5) Input the confidence level: Here since we are looking for a difference (not
that one is greater/less than the other) we must use `alpha/2=.025 `

(6) Select where you want the output to be sent.

You should get the following information:

F=1.941286452

p=0.0673612091

`S_(x1)=71.8375172 `

`S_(x2)=51.5592394 `

` bar(x_1)=448.7179487 `

`bar(x_2)=451.7 `

n1=39

n2=30

(b)Do not reject the null hypothesis. p>.05.

If p<alpha we reject the null hypothesis as the random sample should not occur by chance if the variances are actually equal.

## See eNotes Ad-Free

Start your **48-hour free trial** to get access to more than 30,000 additional guides and more than 350,000 Homework Help questions answered by our experts.

Already a member? Log in here.

**Further Reading**