Question: How do I use ms excel to create a graph to show the locaion of z or t value? I can not figure out the steps to use to do this on excel. here is what I am working on below. I am not sure how to do b sketch its location. a) State the null and alternate hypotheses. Will we use a left-tailed, right-tailed, or two-tailed test? What is the level of significance? b) Identify the sampling distribution to be used: standard normal or the Student’s t. Compute the z or t value of the sample test statistic and sketch its location. c) Find the P value for the sample test statistic. d) Should we reject or fail to reject the null hypothesis? A new bus route has been established between downtown Denver and Englewood, a suburb of Denver. Dan has taken the bus to work for many years. For the old bus route, he knows that the mean waiting time between buses at his stop was 18.3 minutes. However, a random sample of 5 waiting times between buses using the new route had a mean of 15.1 minutes with s = 6.2 minutes. Does this indicate that the population mean waiting time for the new route is different from what it used to be? Use α = .05.
Question:
How do I use ms excel to create a graph to show the locaion of z or t value? I can not figure out the steps to use to do this on excel. here is what I am working on below. I am not sure how to do b sketch its location.
a) State the null and alternate hypotheses. Will we use a left-tailed, right-tailed, or two-tailed test? What is the level of significance?
b) Identify the sampling distribution to be used: standard normal or the
Student’s t. Compute the z or t value of the sample test statistic and sketch its location.
c) Find the P value for the sample test statistic.
d) Should we reject or fail to reject the null hypothesis?
A new bus route has been established between downtown Denver and Englewood, a suburb of Denver. Dan has taken the bus to work for many years. For the old bus route, he knows that the mean waiting time between buses at his stop was 18.3 minutes. However, a random sample
of 5 waiting times between buses using the new route had a mean of 15.1 minutes with s = 6.2 minutes. Does this indicate that the population mean waiting time for the new route is different from what it used to be? Use α = .05.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
