Based on the "Times" data, is the proposed method of production lower variance than the current? Use alpha = 0.05 (i.e., 95% confidence level) Select one: a. Yes, the F statistic is greater than the F critical for a one tail test at the 95% confidence level. b. Yes because the current variance is 2.5 times the variance of the proposed method. c. No. because the p value is very small. d. No because the f critical is below 2.\fA B C D F I am supposed to give an equal number of grades to each letter value. Based on Actual Grades 20 10 35 15 20 the sample data in the Grades tab, can we reject the claim that my grades are Expected 20 20 20 20 20 equally distributed? Use alpha = 0.05 (i.e., 95% confidence level) Select one: a. Yes, the chi value of 17.5 is greater than chi critical of 9.5. b. No, the chi value of 17.5 is greater than chi critical of 9.5. c. Yes, the p value is high enough to reject that claim. d. No, the sample is too small and there are not enough different grade Use excel and show the formulasIs there a difference in the mean price for vitamins at the retail outlets provided in the "Vitamins" tab? Use alpha = .05. a. Yes, the average ranges from $4.92 to $5.93 -- the range of means is very spread out. b. Yes, the sum of squared errors between stores is two times that within group - enough to reject the claim the means are equal. c. No, the F value is far less than F critical, thus we cannot reject the claim that the means are equal. d. No, the t-value comparing the difference of means is insufficiently different to reject the claim of equal means. Use excel and show formulars Rite- Item CVS Kmart Aid Wegmans Caltrate +D (600mg/60 tablets) 8.49 5.99 7.99 5.99 Centrum (130 tablets) 9.49 9.47 9.89 7.97 Cod liver oil (100 gel tablets) 2.66 2.59 1.99 2.69 Fish oil (1,000 mg, 60 tablets) 6.19 4.99 4.99 5.99 Flintstones Children's (60 tablets) 7.69 5.99 5.99 6.29 Folic acid (400 mcg/250 tablets) 2.19 2.49 3.74 2.69 One-a-Day Maximum (100 tablets) 8.99 7.49 6.99 6.99 One-a-Day Scooby (50 tablets) 7.49 5.99 6.49 5.47 Poly-Vi-Sol (drops, 50 ml.) 9.99 8.49 9.99 8.37 Vitamin B-12 (100 mcg/100tablets) 3.59 1.99 1.99 1.79 Vitamin C (500 mg/100tablets) 2.99 2.49 1.99 2.39 Vitamin E (200 IU/100tablets) 4.69 3.49 2.99 3.29 Zinc (50 mg/100 tablets) 2.66 2.59 3.99 2.79