WPC 300 Final questions with complete
solutions
Using a pivot table. determine which of the following statements is incorrect - correct answer
✔✔Category 3 has 54 respondents
Using a pivot table, determine which of the following statements is incorrect about the average age of
respondents in each age category - correct 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. - correct answer ✔✔Category 2 has 28% of the
respondents
Which of the following statements is not correct based on the sample data provided? - correct answer
✔✔The standard deviation for HDL is 0.6152
Looking at the distribution of BMI, you observe that the data centrality is measured as: - correct 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 statistical test on the sample to see if the average age for the sample is
consistent with your hypothesis (use a margin of error 5%) What is the p-value from the test? - correct
answer ✔✔0.0089
You believe that the average BMIs across different age categories are different. Perform an appropriate
statistical test on the sample diabetes data to see if your hypothesis is true (use a margin of error of 5%).
What can you conclude? - correct answer ✔✔Average BMI of at least one of the age categories is
different from the other.
Using the sample. perform a correlation analysis of the variables Age, BMI, BP, Total Cholesterol, LDL, &
HDL. Which of the following statements is true based on your analysis. - correct answer ✔✔The
correlation between Age and BP is approximately 0.33
solutions
Using a pivot table. determine which of the following statements is incorrect - correct answer
✔✔Category 3 has 54 respondents
Using a pivot table, determine which of the following statements is incorrect about the average age of
respondents in each age category - correct 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. - correct answer ✔✔Category 2 has 28% of the
respondents
Which of the following statements is not correct based on the sample data provided? - correct answer
✔✔The standard deviation for HDL is 0.6152
Looking at the distribution of BMI, you observe that the data centrality is measured as: - correct 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 statistical test on the sample to see if the average age for the sample is
consistent with your hypothesis (use a margin of error 5%) What is the p-value from the test? - correct
answer ✔✔0.0089
You believe that the average BMIs across different age categories are different. Perform an appropriate
statistical test on the sample diabetes data to see if your hypothesis is true (use a margin of error of 5%).
What can you conclude? - correct answer ✔✔Average BMI of at least one of the age categories is
different from the other.
Using the sample. perform a correlation analysis of the variables Age, BMI, BP, Total Cholesterol, LDL, &
HDL. Which of the following statements is true based on your analysis. - correct answer ✔✔The
correlation between Age and BP is approximately 0.33
