Name: Date: Topic 2: Population and Sampling Distribution Excel Worksheet Directions: Answer all questions and submit to instructor at the end of Topic 2 1 A. For a normal distribution that has a mean of 100, and a standard deviation of 8, determine the Z-score for each of the following X values: X = 108 Z= X = 112 Z= X = 98 Z= X = 70 Z= X = 124 Z= 1 B. Use the information in 1 A. to determine the area or probability of the following: p(x > 108) p(x < 98) p(92 < x < 108) p(84 < x < 116) p(x < 84) 7. Find the mean and standard error of the sample means that is normally distributed with a mean of 10 and a standard deviation of 2 and a sample size of 25. 8. Using the above distribution find the probability of a score less than 11. Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 mean SE Exercise 18 MEAN, STANDARD DEVIATION, AND 95% AND 99% OF THE NORMAL CURVE Name Date Course Section HLT362v 1. Assuming that the distribution is normal for weight relative to the ideal and 99% of the male participants scored between (-53.68, 64.64), where did 95% of the values for weight relative to the ideal lie? Round your answer to two decimal places. 2. Which of the following values from Table 1 tells us about variability of the scores in a distribution? a. 60.22 b. 11.94 c. 22.57 d. 53.66? 3. Assuming that the distribution for General Health Perceptions is normal, 95% of the females' scores around the mean were between what values? Round your answer to two decimal places. 4. Assuming that the distribution of scores for Pain is normal, 95% of the men's scores around the mean were between what two values? Round your answer to two decimal places. 5. Were the body image scores significantly different for women versus men? Provide a rationale for your answer. 6. Assuming that the distribution of Mental Health scores for men is normal, where are 99% of the men's mental health scores around the mean in this distribution? Round your answer to two decimal places. 7. Assuming that the distribution of scores for Physical Functioning in women is normal, where are 99% of the women's scores around the mean in this distribution? Round your answer to two decimal places. 8. Assuming that the distribution of scores is normal, 99% of HIV-positive body image scores around the mean were between what two values? Round your answer to two decimal places. 9. Assuming that the distribution of scores for Role Functioning is normal, 99% of the men's scores around the mean were between what values? Round your answer to two decimal places. 10. What are some of the limitations of this study that decrease the potential for generalizing the findings to the target population