Homework Help is Here – Start Your Trial Now!
Math
Statistics
4. (2 Test (in Excel) for Two Samples with Known Variance) A random selection of volunteers at a research institute have been exposed to a typical cold virus. After they started to have cold symptoms, 10 of them were given multivitamin tablets daily which contain grams of vitamin C and various other vitamins and minerals. The remaining 10 volunteers were given placebo tablets. For each individual, the length of time taken to recover from cold is recorded. At the end of the experiment following data are obtained: Treated with multivitamin Treated with placebo Days to recover from cold 4.4, 6.5, 4.7, 4.5, 3.6, 5.0, 5.6, 6.6, 2.7, 5.5 4.0, 4.3, 3.8, 6.8, 4.1, 3.3, 4.4, 5.1, 2.2, 3.5 It is known that the population standard deviation of recovery time from cold is 1.8 days when treated with multivitamin, and the population standard deviation of recovery time from cold is 1.5 days when treated with placebo tablets. It is also known that both populations are approximately normally distributed. The researchers claim that the mean recovery time, #₁, of the patients treated with multivitamin is not equal to the mean recovery time µ₂, of the patients who are treated with placebo tablets. At the 0.05 level of significance, is there enough evidence to support this claim? Use Excel to perform the hypothesis test. a. State the null and alternate hypotheses that would be appropriate for this hypothesis test. Use proper notation and formatting. b. Give the value of the test statistic. Round to three decimal places if needed. c. Give the p-value of the test statistic. d. Using the p-value method, should Ho be rejected at the a= 0.05 level of significance? Why or why not? ii. e. Choose an appropriate conclusion based on your decision in part d. L The mean recovery time of the patients treated with multivitamin differs from those treated with placebo tablets. There is not enough evidence to conclude that the mean recovery time of the patients treated with multivitamin differs from those treated with placebo tablets.

4. (2 Test (in Excel) for Two Samples with Known Variance) A random selection of volunteers at a research institute have been exposed to a typical cold virus. After they started to have cold symptoms, 10 of them were given multivitamin tablets daily which contain grams of vitamin C and various other vitamins and minerals. The remaining 10 volunteers were given placebo tablets. For each individual, the length of time taken to recover from cold is recorded. At the end of the experiment following data are obtained: Treated with multivitamin Treated with placebo Days to recover from cold 4.4, 6.5, 4.7, 4.5, 3.6, 5.0, 5.6, 6.6, 2.7, 5.5 4.0, 4.3, 3.8, 6.8, 4.1, 3.3, 4.4, 5.1, 2.2, 3.5 It is known that the population standard deviation of recovery time from cold is 1.8 days when treated with multivitamin, and the population standard deviation of recovery time from cold is 1.5 days when treated with placebo tablets. It is also known that both populations are approximately normally distributed. The researchers claim that the mean recovery time, #₁, of the patients treated with multivitamin is not equal to the mean recovery time µ₂, of the patients who are treated with placebo tablets. At the 0.05 level of significance, is there enough evidence to support this claim? Use Excel to perform the hypothesis test. a. State the null and alternate hypotheses that would be appropriate for this hypothesis test. Use proper notation and formatting. b. Give the value of the test statistic. Round to three decimal places if needed. c. Give the p-value of the test statistic. d. Using the p-value method, should Ho be rejected at the a= 0.05 level of significance? Why or why not? ii. e. Choose an appropriate conclusion based on your decision in part d. L The mean recovery time of the patients treated with multivitamin differs from those treated with placebo tablets. There is not enough evidence to conclude that the mean recovery time of the patients treated with multivitamin differs from those treated with placebo tablets.

MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
See similar textbooks
icon
Related questions
Question
AutoSave OFF Home Insert Draw Design Layout Paste Page 4 of 4 B I vab References A^ A Aa v A 1115 words English (United States) As A v Av 18 W Using Excel for Hypothesis Testing with Two Means - Read-Only - Saved to my Mac Mailings = Review V V View Treated with multivitamin 트 쉰 E V Treated with placebo Tell me V 4. (z Test (in Excel) for Two Samples with Known Variance) A random selection of volunteers at a research institute have been exposed to a typical cold virus. After they started to have cold symptoms, 10 of them were given multivitamin tablets daily which contain grams of vitamin C and various other vitamins and minerals. The remaining 10 volunteers were given placebo tablets. For each individual, the length of time taken to recover from cold is recorded. At the end of the experiment following data are obtained: i. ii. Accessibility: Investigate AaBbCcDdEe Normal AaBb CcDdEe No Spacing Days to recover from cold 4.4, 6.5, 4.7, 4.5, 3.6, 5.0, 5.6, 6.6, 2.7, 5.5 It is known that the population standard deviation of recovery time from cold is 1.8 days when treated with multivitamin, and the population standard deviation of recovery time from cold is 1.5 days when treated with placebo tablets. It is also known that both populations are approximately normally distributed. The researchers claim that the mean recovery time, μ₁, of the patients treated with multivitamin is not equal to the mean recovery time µ₂, of the patients who are treated with placebo tablets. At the 0.05 level of significance, is there enough evidence to support this claim? Use Excel to perform the hypothesis test. c. Give the p-value of the test statistic. 4.0, 4.3, 3.8, 6.8, 4.1, 3.3, 4.4, 5.1, 2.2, 3.5 a. State the null and alternate hypotheses that would be appropriate for this hypothesis test. Use proper notation and formatting. b. Give the value of the test statistic. Round to three decimal places if needed. e. Choose an appropriate conclusion based on your decision in part d. AaBbCcDc AaBbCcDdEe AaBb( Heading 1 Heading 2 Title d. Using the p-value method, should Ho be rejected at the a = 0.05 level of significance? Why or why not? The mean recovery time of the patients treated with multivitamin differs from those treated with placebo tablets. There is not enough evidence to conclude that the me recovery time of the patients treated with multivitamin differs from those treated with placebo tablets. Focus Aa Bb CcDd Ee Subtitle Share E Styles Pane I Viewing Dictate Comments Editor BOD + 100%
Transcribed Image Text:AutoSave OFF Home Insert Draw Design Layout Paste Page 4 of 4 B I vab References A^ A Aa v A 1115 words English (United States) As A v Av 18 W Using Excel for Hypothesis Testing with Two Means - Read-Only - Saved to my Mac Mailings = Review V V View Treated with multivitamin 트 쉰 E V Treated with placebo Tell me V 4. (z Test (in Excel) for Two Samples with Known Variance) A random selection of volunteers at a research institute have been exposed to a typical cold virus. After they started to have cold symptoms, 10 of them were given multivitamin tablets daily which contain grams of vitamin C and various other vitamins and minerals. The remaining 10 volunteers were given placebo tablets. For each individual, the length of time taken to recover from cold is recorded. At the end of the experiment following data are obtained: i. ii. Accessibility: Investigate AaBbCcDdEe Normal AaBb CcDdEe No Spacing Days to recover from cold 4.4, 6.5, 4.7, 4.5, 3.6, 5.0, 5.6, 6.6, 2.7, 5.5 It is known that the population standard deviation of recovery time from cold is 1.8 days when treated with multivitamin, and the population standard deviation of recovery time from cold is 1.5 days when treated with placebo tablets. It is also known that both populations are approximately normally distributed. The researchers claim that the mean recovery time, μ₁, of the patients treated with multivitamin is not equal to the mean recovery time µ₂, of the patients who are treated with placebo tablets. At the 0.05 level of significance, is there enough evidence to support this claim? Use Excel to perform the hypothesis test. c. Give the p-value of the test statistic. 4.0, 4.3, 3.8, 6.8, 4.1, 3.3, 4.4, 5.1, 2.2, 3.5 a. State the null and alternate hypotheses that would be appropriate for this hypothesis test. Use proper notation and formatting. b. Give the value of the test statistic. Round to three decimal places if needed. e. Choose an appropriate conclusion based on your decision in part d. AaBbCcDc AaBbCcDdEe AaBb( Heading 1 Heading 2 Title d. Using the p-value method, should Ho be rejected at the a = 0.05 level of significance? Why or why not? The mean recovery time of the patients treated with multivitamin differs from those treated with placebo tablets. There is not enough evidence to conclude that the me recovery time of the patients treated with multivitamin differs from those treated with placebo tablets. Focus Aa Bb CcDd Ee Subtitle Share E Styles Pane I Viewing Dictate Comments Editor BOD + 100%
Expert Solution
steps

Step by step

Solved in 6 steps with 8 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman
SEE MORE TEXTBOOKS