I will let you do the leg work, but it appears to me that either you or your instructor have misunderstood the order and meaning of the arguments to the NORM.DIST() function. Compare your proposed formula/arguments to what is described in the help file: https://support.office.com/en-us/art...rs=en-US&ad=US
Originally Posted by shg
Thanks for replying.
When I try to remove the /sqrt(size), it gives an actual answer of .805.
I also tried to compute the test statistic first and use the norm.s.dist (z,cumulative) and the answer excel gives is also 1.
I'm not sure if there's something with excel or what
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks