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.in cell E20, please type in The Z-score for ??? = .

The Z-score for ??? = =STANDARDIZE(F12,F3,F7)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!