WPC 300 PRACTICE FINAL QUESTIONS WITH
VERIFIED ACCURATE ANSWERS
Using a pivot table. determine which of the following statements is incorrect - 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 - 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. - Answers
-Category 2 has 28% of the respondents
Which of the following statements is not correct based on the sample data provided? -
Answers -The standard deviation for HDL is 0.6152
Looking at the distribution of BMI, you observe that the data centrality is measured as: -
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? - 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? - Answers -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. - Answers -The correlation between Age and BP is approximately 0.33
If we were interested in determining a possible cause and effect relationship where BMI
and Age are causing disease progression (Y), ______ is the independent variable and
_____ is the dependent variable? - Answers -BMI, Y respectively
Perform a simple linear regression to predict Y using respondents' BMI. What is the
correct equation for the regression line? - Answers -Y = -118 + 10.2*BMI
Perform a multiple regression analysis (with a margin of error of 5%) that examines all
of the variables in the sample (excluding variables: Y binary Gender and Category) as
potential predictors of Y. Which of the following conclusions can be made based on the
VERIFIED ACCURATE ANSWERS
Using a pivot table. determine which of the following statements is incorrect - 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 - 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. - Answers
-Category 2 has 28% of the respondents
Which of the following statements is not correct based on the sample data provided? -
Answers -The standard deviation for HDL is 0.6152
Looking at the distribution of BMI, you observe that the data centrality is measured as: -
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? - 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? - Answers -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. - Answers -The correlation between Age and BP is approximately 0.33
If we were interested in determining a possible cause and effect relationship where BMI
and Age are causing disease progression (Y), ______ is the independent variable and
_____ is the dependent variable? - Answers -BMI, Y respectively
Perform a simple linear regression to predict Y using respondents' BMI. What is the
correct equation for the regression line? - Answers -Y = -118 + 10.2*BMI
Perform a multiple regression analysis (with a margin of error of 5%) that examines all
of the variables in the sample (excluding variables: Y binary Gender and Category) as
potential predictors of Y. Which of the following conclusions can be made based on the
