Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Explore the use of the NORM.S.DIST Excel function to find p-values. For example, for a 1 tail test, using the left tail, find the p-value
Explore the use of the NORM.S.DIST Excel function to find p-values. For example, for a 1 tail test, using the left tail, find the p-value corresponding to an observed z value of 2.05? Is your p-value 2%? If the alpha is 5% what can you infer regarding the null hypothesis? The p value is equal to 0.9798 using =NORMSDIST(2.05) in excel. Clearly, p value is not 2% even it is 98%. Since p value (98%) is greater than alpha (5%). The null hypothesis is not rejected.What if the test was a right tail test?
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