HOMEWORK HELP Please show ALL WORK For the data given in Dat

+++HOMEWORK HELP+++++

Please show ALL WORK!!

For the data given in Data file, what is a 95% confidence interval for the ratio of the variances? Is there a statistically significant difference?

****BELOW IS THE DATA FILE FOR THE QUESTION++++

A

51.48109487

B

48.52637986

50.08031663

48.43083057

47.88392403

47.81756817

49.35999966

46.4905916

51.95918198

44.35583896

49.09059232

46.77662118

52.00914735

48.19272724

50.26982418

45.87110579

50.4841277

48.37722266

52.60938847

49.72156327

49.12544544

53.03961373

50.36511393

50.681865

48.284102

47.80812

52.96071753

48.54547686

51.85808724

51.29993879

54.74097428

51.35508836

49.82247882

44.94534908

50.66792392

50.65288313

48.75793211

51.17800447

50.78750697

55.24274031

53.1641828

50.15494518

54.46020249

48.72252441

48.82830497

49.15901043

48.66530492

51.31846538

49.4502203

44.22434958

51.4646407

52.08588382

47.12500348

55.63320798

51.30900894

48.82502316

49.061804

54.27478884

48.61617422

53.55006887

Comment

A 51.48109487	B 48.52637986
50.08031663	48.43083057
47.88392403	47.81756817
49.35999966	46.4905916
51.95918198	44.35583896
49.09059232	46.77662118
52.00914735	48.19272724
50.26982418	45.87110579
50.4841277	48.37722266
52.60938847	49.72156327
49.12544544	53.03961373
50.36511393	50.681865
48.284102	47.80812
52.96071753	48.54547686
51.85808724	51.29993879
54.74097428	51.35508836
49.82247882	44.94534908
50.66792392	50.65288313
48.75793211	51.17800447
50.78750697	55.24274031
53.1641828	50.15494518
54.46020249	48.72252441
48.82830497	49.15901043
48.66530492	51.31846538
49.4502203	44.22434958
51.4646407	52.08588382
47.12500348	55.63320798
51.30900894	48.82502316
49.061804	54.27478884
48.61617422	53.55006887

Solution

Using Excel, we find the F test for the two samples for variances.

The results obtained were as follows:

From the above we see that the F statistic is 0.4006 for the numerator and the denominator.

As the p value is less than 0.05, we can reject the null hypothesis that the variances of the two groups are equal.

	Variable 1		Variable 2
Mean	50.49142		49.57526
Variance	3.62484		9.047359
Observations	30		30
df	29		29
F	0.400652
P(F<=f) one-tail	0.008167
F Critical one-tail	0.5374