Emily is trying to check if the nutritional content of different formulas have different effects on mice. She uses five mice to test each type of formulas (A, B, an C) and Formula A is simply a placebo. Each mouse's weight is recorded in grams. At the end of a specified time period, each mouse is weighed again and the net gain in grams is recorded as shown in Table 1 below. Formula Formula Formula A В C 40 47 51 32 38 41 42 49 38 36 46 46 39 44 49 Using an F-test, determine whether or not the variance in weight gain is statistically the same among the mice that were using Formula B an Formula C. Test at a confidence level of 90%. (HINT: Remember that the bigger standard deviation goes in the numerator when calculating the tes statistic) a. Should we run the test on all three columns or only on two columns? (Write "2" or "3" in the blank): b. The F-test statistic calculated for this problem is (Round to three decimal places). c. The critical-F value for this problem is (Round to three decimal places). d. We have enough evidence that the variance of weight gains being compared are different. Write "True" or "False" in the blank:

Linear Algebra: A Modern Introduction
4th Edition
ISBN:9781285463247
Author:David Poole
Publisher:David Poole
Chapter4: Eigenvalues And Eigenvectors
Section4.6: Applications And The Perron-frobenius Theorem
Problem 22EQ
icon
Related questions
Topic Video
Question

Can someone help with the following question on excel 

Emily is trying to check if the nutritional content of different formulas have different effects on mice. She uses five mice to test each type of formulas (A, B, anc
C) and Formula A is simply a placebo. Each mouse's weight is recorded in grams. At the end of a specified time period, each mouse is weighed again and the
net gain in grams is recorded as shown in Table 1 below.
Formula
Formula
Formula
A
В
C
40
47
51
32
38
41
42
49
38
36
46
46
39
44
49
Using an F-test, determine whether or not the variance in weight gain is statistically the same among the mice that were using Formula B an
Formula C. Test at a confidence level of 90%. (HINT: Remember that the bigger standard deviation goes in the numerator when calculating the tes
statistic)
a. Should we run the test on all three columns or only on two columns? (Write "2" or "3" in the blank):
b. The F-test statistic calculated for this problem is
(Round to three decimal places).
c. The critical-F value for this problem is
(Round to three decimal places).
d. We have enough evidence that the variance of weight gains being compared are different. Write "True" or "False" in the blank:
Transcribed Image Text:Emily is trying to check if the nutritional content of different formulas have different effects on mice. She uses five mice to test each type of formulas (A, B, anc C) and Formula A is simply a placebo. Each mouse's weight is recorded in grams. At the end of a specified time period, each mouse is weighed again and the net gain in grams is recorded as shown in Table 1 below. Formula Formula Formula A В C 40 47 51 32 38 41 42 49 38 36 46 46 39 44 49 Using an F-test, determine whether or not the variance in weight gain is statistically the same among the mice that were using Formula B an Formula C. Test at a confidence level of 90%. (HINT: Remember that the bigger standard deviation goes in the numerator when calculating the tes statistic) a. Should we run the test on all three columns or only on two columns? (Write "2" or "3" in the blank): b. The F-test statistic calculated for this problem is (Round to three decimal places). c. The critical-F value for this problem is (Round to three decimal places). d. We have enough evidence that the variance of weight gains being compared are different. Write "True" or "False" in the blank:
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Discrete Probability Distributions
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL