Homework Help is Here – Start Your Trial Now!
Math
Statistics
Using Excel, conduct a t-test (at the alpha = 0.10 significance level) on whether the mean of X2 is equal to 100. What do you conclude from this sample data? Is the population mean equal to 100?

Using Excel, conduct a t-test (at the alpha = 0.10 significance level) on whether the mean of X2 is equal to 100. What do you conclude from this sample data? Is the population mean equal to 100?

College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
12th Edition
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:R. David Gustafson, Jeff Hughes
Chapter8: Sequences, Series, And Probability
Section8.CR: Chapter Review
Problem 37E: Find the positive geometric mean between 4 and 64.
See similar textbooks
icon
Related questions
Question

Using Excel, conduct a t-test (at the alpha = 0.10 significance level) on whether the mean of X2 is equal to 100. What do you conclude from this sample data? Is the population mean equal to 100?

X1 X2 102.04 96.13 100.47 97.63 103.17 95.42 95.09 104.41 103.81 102.08 95.36 103.33 103.38 112.25 100.26 96.93 97.24 100.19 99.61 102.70 96.00 106.94 100.69 102.29 100.50 100.00 98.81 97.67 95.15 99.09 100.01 98.57 102.88 97.70 101.36 108.11 103.05 106.94 96.17 104.36 98.44 96.87 101.00 102.42 96.93 100.17 91.57 106.98 100.99 100.54 103.18 110.63 104.37 100.11 100.99 107.77 102.50 104.10 107.25 102.75 100.45 99.85 105.07 100.93 96.16 98.94 102.03 103.83 99.17 104.88 98.65 97.33
Transcribed Image Text:X1 X2 102.04 96.13 100.47 97.63 103.17 95.42 95.09 104.41 103.81 102.08 95.36 103.33 103.38 112.25 100.26 96.93 97.24 100.19 99.61 102.70 96.00 106.94 100.69 102.29 100.50 100.00 98.81 97.67 95.15 99.09 100.01 98.57 102.88 97.70 101.36 108.11 103.05 106.94 96.17 104.36 98.44 96.87 101.00 102.42 96.93 100.17 91.57 106.98 100.99 100.54 103.18 110.63 104.37 100.11 100.99 107.77 102.50 104.10 107.25 102.75 100.45 99.85 105.07 100.93 96.16 98.94 102.03 103.83 99.17 104.88 98.65 97.33
Expert Solution
steps

Step by step

Solved in 4 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Trigonometry (MindTap Course List)
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781305652224
Author:
Charles P. McKeague, Mark D. Turner
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS