For effective learning, an instructor advised his students to practice solving statistical problems on StatCrunch, a web-based software, at least 7 hours per week. In an in class activity, a student surveyed 15 of her 35 classmates to assess the number of hours they spend per week practicing statistics on StatCrunch. The following data was collected: 6.5, 4, 3.5, 0, 12, 5, 12, 15, 12, 0, 1, 8, 0.5, 2, 7. Is there strong evidence that the mean number of hours of StatCrunch usage in the entire class is larger than 7? Let the confidence level be 95% Use Microsoft excel to do the following. State the hypothesis Construct one sample t-test. Provide the table from excel Draw the rejection region from excel What is the p-value? Conclusion is the hypothesis rejected pr not?
For effective learning, an instructor advised his students to practice solving statistical problems on StatCrunch, a web-based software, at least 7 hours per week. In an in class activity, a student surveyed 15 of her 35 classmates to assess the number of hours they spend per week practicing statistics on StatCrunch. The following data was collected: 6.5, 4, 3.5, 0, 12, 5, 12, 15, 12, 0, 1, 8, 0.5, 2, 7. Is there strong evidence that the mean number of hours of StatCrunch usage in the entire class is larger than 7? Let the confidence level be 95% Use Microsoft excel to do the following. State the hypothesis Construct one sample t-test. Provide the table from excel Draw the rejection region from excel What is the p-value? Conclusion is the hypothesis rejected pr not?
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.6: Summarizing Categorical Data
Problem 10CYU
Related questions
Question
For effective learning, an instructor advised his students to practice solving statistical problems on StatCrunch, a web-based software, at least 7 hours per week. In an in class activity, a student surveyed 15 of her 35 classmates to assess the number of hours they spend per week practicing statistics on StatCrunch. The following data was collected: 6.5, 4, 3.5, 0, 12, 5, 12, 15, 12, 0, 1, 8, 0.5, 2, 7. Is there strong evidence that the mean number of hours of StatCrunch usage in the entire class is larger than 7? Let the confidence level be 95%
Use Microsoft excel to do the following.
- State the hypothesis
- Construct one sample t-test. Provide the table from excel
- Draw the rejection region from excel
- What is the p-value?
- Conclusion is the hypothesis rejected pr not?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL