Consider a right-tailed test with a test statistic of 1.27. Which Excel statement will find the p-value for the z-test? =1- NORM.DIST(1.27,TRUE) =1- NORM.S.DIST(1.27,TRUE) =NORM.S.DIST(1.27,TRUE) =NORM.DIST(1.27,FALSE)

A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
icon
Related questions
Question

Answer it correctly and show in excel. I will rate accordingly

Consider a right-tailed test with a test
statistic of 1.27. Which Excel statement will
find the p-value for the z-test?
=1-
NORM.DIST(1.27,TRUE)
=1-
NORM.S.DIST(1.27,TRUE)
=NORM.S.DIST(1.27,TRUE)
=NORM.DIST(1.27,FALSE)
Transcribed Image Text:Consider a right-tailed test with a test statistic of 1.27. Which Excel statement will find the p-value for the z-test? =1- NORM.DIST(1.27,TRUE) =1- NORM.S.DIST(1.27,TRUE) =NORM.S.DIST(1.27,TRUE) =NORM.DIST(1.27,FALSE)
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer