Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus Early Transcendentals

Authors: James Stewart, Daniel K. Clegg, Saleem Watson, Lothar Redlin

9th Edition

1337613924, 978-1337613927

More Books

Students also viewed these Mathematics questions

Question

The structure of DNA was first discovered by.........

Answered: 1 week ago

Question

The three components of a nucleotide are....... and........?

Answered: 1 week ago

Question

Primary function of root ?

Answered: 1 week ago

Question

The only phyto hormone which is a gas at ordinary temperature?

Answered: 1 week ago