Question: in cell E20, please type in The Z-score for ??? = . For ??? you will have to pinpoint which zip code corresponds to the
in cell E20, please type in The Z-score for ??? = . For ??? you will have to pinpoint which zip code corresponds to the lowest or minimum value in cell F12. You can do this by studying the list. Then in cell E21, type =STANDARDIZE(F12,F3,F7) which will give you a z-score for the lowest value on the list. Do the same for highest value in cells F20 and F21 and be sure to identify which zip code has the highest income level by examining the list.
Finally, answer the following questions:
Is the histogram or data distribution skewed left, skewed right, or normal or approximately normal? How do you know this? That is, justify your answer by citing whether the mean is equal to, less than, or greater than the median, or by referring the shape of the histogram, etc.
Interpret the z-score for the lowest income zip code.
Interpret the z-score for the highest income zip code.
The Z-score for ??? = =STANDARDIZE(F12,F3,F7)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
