Get instant live expert help on How do I calculate z score in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Using the NORM.S.DIST function, compute the probability that a score would fall between +1 and +2 z scores. Remember, you dont need any raw score valures becasue a z score of 1 is a z score of 1 is a z score of 1.
Solved by X. D. in 28 mins
using the Norm.s.Dist function, compute the probability that a score would fall between +1 and +2 z scores. rember you dont need any raw score because a z of 1 is a z score of 1is a z score of 1
Solved by B. F. in 30 mins
1. departments use exams as part of their promotion process where officers have to score higher than 80% of those taking the exam to be considered for promotion. (This is a z-score of 0.83 or above). Two officers write their exams. officer #1 receives a grade of 70 and officer #2 receives a grade of 72. Note that the mean (of all officers taking the exam is) is 62 and the standard deviation is 11. (20pts) a. Calculate the z-score for officer #1. Was this score high enough to be considered for promotion? b. Calculate the z-score for officer #2. Was this score high enough to be considered for promotion?
Solved by V. U. in 13 mins
need to use excel data analysis plug in for z score for one-tailed where you are not given the data set. have std dev, mean, and # of observations
Solved by D. A. in 30 mins
I couldn't find this info online. I'm working on statistics, and not familiar with calculus, and I'm using a z-table to lookup the probability score for each z value. This is the only part I'm doing by hand, and the rest of statistics is pretty easy to calculate by hand, and even easier in Excel. Any idea if there's a function to return p for a value of x?
Solved by I. C. in 26 mins