(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...

## See

This Answer NowStart your **48-hour free trial** to unlock this answer and thousands more. Enjoy eNotes ad-free and cancel anytime.

Already a member? Log in here.

(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.

**Further Reading**