The average population in US states is 6,000,000 with a standard deviation of 750,000 people. Assume starting salaries are normally distributed. Use this information to answer the questions below. Reference values instead of hard-coding (typing) them. Population Mean $6,000,000 Population Standard Deviation $750,000 Questions Given Z score Answer 1 What percentage of states have this population or less? 5,061,794 -1.25 2 How many standard deviations is this value from the mean? 6,034,745 3 What population is at or below the 75th percentile? 75% 4 What percentage of states have a population higher than this one? 7,019,740 5 What population is at the top 25%? 25% Question Answer "What function do you use to find an X value? A. Norm.S.Dist B. Z Score C. Norm.S.Inv" B "Why do you use Norm.S.Inv(1-%) to find a value ABOVE a percentage? A. Norm.S.Inv is the opposite of a percentile, so it finds the percent above a given value by default B. Norm.S.Inv (%) finds the value below a percentage; Norm.S.Inv (1-%) is the opposite side of the curve C. Norm.S.Inv (1-%) integrates a z-score which is required to find a percentage above a given value" "Two of your answers above the same value. Why is this logical? A. The population mean is the same, so every percentile will result in the same number of hours B. The same value divides the curve into 2 parts; 25% is at or below th

The average population in US states is 6,000,000 with a standard deviation of 750,000 people. Assume starting salaries are normally distributed. Use this information to answer the questions below. Reference values instead of hard-coding (typing) them. Population Mean 6,000,000 Population Standard Deviation 750,000 Questions Given Z score Answer 1 What percentage of states have this population or less? 5,061,794 -1.25 2 How many standard deviations is this value from the mean? 6,034,745 3 What population is at or below the 75th percentile? 759% 4 What percentage of states have a population higher than this one? 7,019,740 5 What population is at the top 25%? 25% Question Answer What function do you use to find an X value? A. Norm.S.Dist B B. Z Score C. Norm.S.Inv Why do you use Norm.S. Inv(1-%) to find a value ABOVE a percentage? A. Norm.S. Inv is the opposite of a percentile, so it finds the percent above a given value by default B. Norm.S.Inv (9%) finds the value below a percentage; Norm.S. Inv (1-%) is the opposite side of the curve C. Norm.S. Inv (1-9%) Integrates a z-score which is required to find a percentage above a given value Two of your answers above the same value. Why is this logical? A. The population mean is the same, so every percentile will result in the same number of hours B. The same value divides the curve into 2 parts; 25% is at or below that value and 75% is at or above it C. The same value divides the curve into 2 parts; 75% is at or below that value and 25% is at or above It When you are looking for the percentile is associated with a given value, which of the following do you use? A. Norm.S.Dist B. Norm.S.Inv C. The standard deviation equation Which of these is equal to the mean value in a normally distributed data set? A. Median B. Mode C. Both Answer Block