Question 1 Part (a) Open the “Bus Maintenance.xls” file that is posted with the Assignment. In order to test...

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

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