Isaiah A. answered 10/30/20
Statistics, Finance, Math tutor. Econ Major with Math minor
You can solve this in Excel by using the functions below:
Lower = NORM.INV(.25,174,51)
Upper = NORM.INV(.75,174,51)
Here's the explanation:
We know that on the normal distribution curve, 50% falls to the left of the mean and 50% to the right.
You could picture the probabilities increasing as shown below moving from left to right
Similarly, the Z scores are shown underneath. At 50% which is the mean, Z = 0. We're interested in the Z values at 25% and 75%.
Probabilities--> 0% 25% 50% 75% 100%
Z score --> ? 0 ?
If we're looking for the middle 50% around the mean, that has to be what's between p = 25% and p = 75% (75%-25% = 50%).The NORM.INV function tells you exactly that.
Alternatively, you could look on a Z table for 25%, and 75% to get Z scores for each of them.
When you get the Z scores you could use the formula for Z scores:
Z = (x - mean) / stdev
If you substitute in the Z you found, the mean, and stdev, then all that's left to solve for is x (do this with both z scores). Hope this makes sense