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
Chapter4: Polynomial And Rational Functions
Section4.6: Rational Functions
Problem 11SC: Find the mean hourly cost when the cell phone described above is used for 240 minutes.
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 98.83 101.49 99.12 101.20 100.29 108.60 104.35 99.86 108.52 98.04 99.85 104.61 100.54 102.83 98.58 92.59 102.45 98.88 98.85 106.84 100.43 93.41 98.31 108.35 99.85 96.08 97.14 97.85 102.16 100.68 99.67 103.87 101.55 102.16 95.60 102.23 107.93 99.43 96.54 103.00 99.52 109.33 93.08 105.23 102.38 96.85 96.76 98.83 99.20 102.46 97.38 101.29 93.57 100.07 99.40 104.86 101.71 101.02 104.12 105.26 100.18 100.61 103.50 101.57 101.07 100.15 97.07 96.16 97.77 102.14 99.35 93.08 100.95 104.60 104.25 97.53 95.81 98.98 98.53 105.70
Transcribed Image Text:X1 X2 98.83 101.49 99.12 101.20 100.29 108.60 104.35 99.86 108.52 98.04 99.85 104.61 100.54 102.83 98.58 92.59 102.45 98.88 98.85 106.84 100.43 93.41 98.31 108.35 99.85 96.08 97.14 97.85 102.16 100.68 99.67 103.87 101.55 102.16 95.60 102.23 107.93 99.43 96.54 103.00 99.52 109.33 93.08 105.23 102.38 96.85 96.76 98.83 99.20 102.46 97.38 101.29 93.57 100.07 99.40 104.86 101.71 101.02 104.12 105.26 100.18 100.61 103.50 101.57 101.07 100.15 97.07 96.16 97.77 102.14 99.35 93.08 100.95 104.60 104.25 97.53 95.81 98.98 98.53 105.70
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 5 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
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
SEE MORE TEXTBOOKS