WPC 300 FINAL UPDATED COMPLETE
QUESTIONS AND ANSWERS PREMIUM
REVIEW SHEET
●● Using a pivot table, determine which of the following statements is
incorrect about the average age of respondents in each age category
Answer: Category 1 average age is 71.2 years
●● Create a pivot table pie chart for people of age 40 or older using the
same age categories as before, determine which of the following
statements is correct.
Answer: Category 2 has 28% of the respondents
●● Which of the following statements is not correct based on the sample
data provided?
Answer: The standard deviation for HDL is 0.6152
●● Looking at the distribution of BMI, you observe that the data
centrality is measured as:
Answer: Mean = 26.4
●● It is generally believed that the average population age is 50. You
claim that the population average age is less than 50. Perform a
QUESTIONS AND ANSWERS PREMIUM
REVIEW SHEET
●● Using a pivot table, determine which of the following statements is
incorrect about the average age of respondents in each age category
Answer: Category 1 average age is 71.2 years
●● Create a pivot table pie chart for people of age 40 or older using the
same age categories as before, determine which of the following
statements is correct.
Answer: Category 2 has 28% of the respondents
●● Which of the following statements is not correct based on the sample
data provided?
Answer: The standard deviation for HDL is 0.6152
●● Looking at the distribution of BMI, you observe that the data
centrality is measured as:
Answer: Mean = 26.4
●● It is generally believed that the average population age is 50. You
claim that the population average age is less than 50. Perform a
