Get instant live expert help on I need help with calculating 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
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
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
Find the z score given the information x=18 mean=14 and standard deviation= 3.2. I'm stumped on what formula to use
Solved by Z. Y. in 17 mins