Question
Hello, I've been asked to use Excel to solve the problem below. Need assistance with how to best answer the question in Excel. Is there
Hello, I've been asked to use Excel to solve the problem below. Need assistance with how to best answer the question in Excel. Is there a formula to enter, what exactly is the question looking for? A hint was provided below. Thank you
According to the National Survey of Student Engagement, the average student spends about 17 hours each week preparing for classes; preparation for classes includes homework, reading and any other assignments. Assume the standard deviation of time spent preparing for classes is 4 hours. If you select a random sample of 16 students:
A)What is the probability that the mean time spent preparing for classes is at least 16 hours per week?
B)There are 85% chance that the sample mean is less than how many hours per week?
C)What assumption must you make in order to sole (A) and (B)?
D)If you select a random sample of 64 students, there is an 85% chance that the sample mean is less than how many hours per week?
Hint :( Notice the variable we are dealing with is X_bar)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started