WPC 300 Practice Final Exam
QUESTIONS AND CORRECT
DETAILED ANSWERS (VERIFIED
ANSWERS) |ALREADY GRADED A+
Using a pivot table. determine which of the following statements is incorrect - CORRECT ANSWERS
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 ANSWERS 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 ANSWERS Category 2 has
28% of the respondents
Which of the following statements is not correct based on the sample data provided? - CORRECT
ANSWERS The standard deviation for HDL is 0.6152
Looking at the distribution of BMI, you observe that the data centrality is measured as: - CORRECT
ANSWERS 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
ANSWERS 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 ANSWERS Average BMI of at least one of the age
categories is different from the other.
QUESTIONS AND CORRECT
DETAILED ANSWERS (VERIFIED
ANSWERS) |ALREADY GRADED A+
Using a pivot table. determine which of the following statements is incorrect - CORRECT ANSWERS
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 ANSWERS 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 ANSWERS Category 2 has
28% of the respondents
Which of the following statements is not correct based on the sample data provided? - CORRECT
ANSWERS The standard deviation for HDL is 0.6152
Looking at the distribution of BMI, you observe that the data centrality is measured as: - CORRECT
ANSWERS 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
ANSWERS 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 ANSWERS Average BMI of at least one of the age
categories is different from the other.
