# Question: Use Excel or an appropriate calculator software website or table

Use Excel or an appropriate calculator, software, website, or table to find the p-value in each of the following situations.

a. Alternative hypothesis is “greater than,” t = +2.5, df = 40.

b. Alternative hypothesis is “less than,” t = –2.5, df = 40.

c. Alternative hypothesis is “not equal,” t = 2.5, df = 40.

d. Alternative hypothesis is “greater than,” z = +1.75.

e. Alternative hypothesis is “less than,” z = – 1.75.

f. Alternative hypothesis is “not equal,” z = –1.75.

a. Alternative hypothesis is “greater than,” t = +2.5, df = 40.

b. Alternative hypothesis is “less than,” t = –2.5, df = 40.

c. Alternative hypothesis is “not equal,” t = 2.5, df = 40.

d. Alternative hypothesis is “greater than,” z = +1.75.

e. Alternative hypothesis is “less than,” z = – 1.75.

f. Alternative hypothesis is “not equal,” z = –1.75.

## Answer to relevant Questions

On January 30, 1995, Time magazine reported the results of a poll of adult Americans, in which they were asked, “Have you ever driven a car when you probably had too much alcohol to drive safely?” The exact results were ...a. Refer to Exercise 24. State the alternative hypothesis for each test. Explain whether you decided to use a one- sided or a two-sided test and why. b. Write the conclusion for the Time 2 test in statistical language and in ...Suppose you wanted to see whether a training program helped raise students’ scores on a standardized test. You administer the test to a random sample of students, give them the training program, and then read minister the ...Refer to the list of warnings on pages 527– 528. Explain which ones should be of concern if the sample size(s) for a test are large. From this discussion, you should realize that you can’t simply rely on news reports to ...Refer to the quote in Exercise 25. Explain what is meant by the second sentence of the quote.Post your question