How can I do this in Excel? Although controversial and the subject of some recen
ID: 3132223 • Letter: H
Question
How can I do this in Excel? Although controversial and the subject of some recent lawsuits (e.g., Satchell et al. vs. FedEx Express), some human resource departments administer standard IQ tests to all employees. The Stanford-Binet test scores are well modeled by a Normal model with mean 100 and standard deviation 16. If the applicant pool is well modeled by this distribution, a randomly selected applicant would have what probability of scoring in the following regions? a) 100 or below I need to know how to do this in Excel.
Explanation / Answer
a)
We first get the z score for the critical value. As z = (x - u) / s, then as
x = critical value = 100
u = mean = 100
s = standard deviation = 16
Thus,
z = (x - u) / s = 0
Thus, using a table/technology, the left tailed area of this is
P(z < 0 ) = 0.5 [ANSWER]
[You can type =NORMSDIST(0) for this part.]
***************************************
To get the left tailed area of a z score in Excel, you can type on any empty cell
=NORMSDIST(z value)
on any empty cell. Ex. =NORMSDIST(1.23) gives you the left tailed area of z = 1.23, which is 0.890651448.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.