# Question: Find the p value using Excel not Appendix D a t

Find the p-value using Excel (not Appendix D):

a. t = 1.457, d.f. = 14, right-tailed test

b. t = 2.601, d.f. = 8, two-tailed test

c. t = 21.847, d.f. = 22, left-tailed test

a. t = 1.457, d.f. = 14, right-tailed test

b. t = 2.601, d.f. = 8, two-tailed test

c. t = 21.847, d.f. = 22, left-tailed test

## Answer to relevant Questions

Use Excel to find the p-value for each test statistic. a. Right-tailed test, t = + 1.677, n = 13 b. Left-tailed test, t = – 2.107, n = 5 c. Two-tailed test, t = – 1.865, n = 34 According to J.D. Power & Associates, the mean purchase price of a smartphone device (such as an iPhone or Blackberry) in 2008 was $216. In 2009, a random sample of 20 business managers who owned a smartphone device showed a ...Calculate the test statistic and p-value for each sample. a. H0: π = .20 versus H1: π ≠ 20, α = .025, p = .28, n = 100 b. H0: π ≤ .20 versus H1: π > 50, α = .025, p = .60, n = 90 c. H0: π ≤ .20 versus H1: π > ...The recent default rate on all student loans is 5.2 percent. In a recent random sample of 300 loans at private universities, there were 9 defaults. (a) Does this sample show sufficient evidence that the private university ...Repeat the previous exercise, using lower? α = .05. For each true value of, is the power higher or lower? Previous exercise For a certain wine, the mean pH (a measure of acidity) is supposed to be 3.50 with a known standard ...Post your question