# (Solved): WPC300 Practice Test (Practical) - Score for this attempt: 20 out of 20 - JUNE 2021 UPDATE...

**WPC300
Practice Test (Practical)
JUNE 2021 UPDATE**

**Score for this attempt: 20 out of 20**

**Instructions**

**PRACTICE Practical Exam Instructions
This exam has a total of two sections. You are required to use two sets of data to answer all the questions. Please see the individual instructions for each section. The total time allowed for this exam is 75 minutes. You must complete the exam in one seating. You will need JMP Pro and Excel software to analyze data and answer questions.
Note: You are expected to work individually to complete this exam before the due date. Getting help from outside resources other than what is made available to you via the canvas course site is considered a violation of the code of academic integrity for which you will be liable for the consequence. **

**Score for this attempt: 20 out of 20
Data background**

The sample includes various demographic and blood test responses for 442 diabetes patients (respondents). The response variable Y is a quantitative measure of disease progression one year after baseline measurements were taken. The ten variables measured at baseline time are age, gender (1 = male, 2 = female), body mass index (BMI), average blood pressure (BP), and six blood serum measurements (Total Cholesterol, LDL, HDL, TCH, LTG, & Glucose). The response Y Binary is constructed from the response Y and defined as high if Y is above 200 or low otherwise.

**Section A:**

Instructions:

• Use the following data file for this section: SampleDiabetes.xlsx

• Remember the honor code.

• Use Excel to prepare your responses to the questions in this section

• Note that sometimes numbers have been rounded.

Create a new column using a vlookup() function to categorize the age variable into age categories as follows:

**Age Category**

70+ 1

60-69 2

50-59 3

40-49 4

30-39 5

19-29 6

**Question 1**

1 / 1 pts

Using a pivot table, determine which of the following statements is incorrect.

• Category 4 has 97 respondents Correct!

• Category 3 has 54 respondents

• Category 5 has 73 respondents

• Category 2 has 90 respondents

**Question 2**

1 / 1 pts

Using a pivot table, determine which of the following statements is incorrect about the average age of respondents in each age category.

• Category 3 average age is 54.0 years

• Category 2 average age is 63.8 years

• Category 4 average age is 44.9 years!

• Category 1 average age is 71.2 years

**Question 3**

1 / 1 pts

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.

• Category 3 has 28% of the respondents

• Category 2 has 20% of the respondentst!

• Category 2 has 28% of the respondents

• Category 4 has 22% of the respondents

**Section B
Instructions**

• Use the following JMP data file for this section

**[Diabetes.JMP]**

• Remember the

**honor code.**

• Use JMP Pro to prepare your responses to the questions in this section

• Note that sometimes numbers have been rounded.

**Question 4**

1 / 1 pts

Which of the following statements is not correct based on the sample data provided?

• The mean for LDL is 115

• The upper limit of the 95% confidence interval for BP is 95.9

• The median for Total Cholesterol is 186

• The standard deviation for HDL is 0.6152

**Question 5**

1 / 1 pts

Looking at the distribution of BMI, you observe that the data centrality is measured as:

• n = 442

• Standard Error = 0.21

• Standard deviation = 4.41orrect!

• Mean = 26.4

**Question 6**

1/ 1 pts

Looking at the distribution of Glucose, you observe that the distribution spread is measured as:Answered

• Mean is 91.3

• 95% confidence interval is 90.2 to 92.3

• Standard error is 11.5

• Interquartile range is 15

**Question 7**

1 / 1 pts

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 of 5%). What is the p-value from the test?

• 0.05Correct!

• 0.0089

• 0.9911

• 0.0179

** Question 8**

1/ 1 pts

It is generally believed that the average population age is 50. You claim that the population average age is more 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 of 5%). What can you conclude?

• We fail to reject the null hypothesis

• We accept the null hypothesis

• We do not have enough information to make a judgement on the null hypothesisAnswered

• We reject the null hypothesis

**Question 9**

1 / 1 pts

Perform a pairwise correlation analysis of the variables Y, age, BMI, BP, Total Cholesterol, LDL, HDL, TCH, LTG, & Glucose in the sample suggests that:

• The population has a significant negative correlation between TCH and Total Cholesterol

• The population has no correlation between Total Cholesterol and LDLt!

• The population has a significant negative correlation between HDL and TCH

• The population has a significant negative correlation between Y and BMI

**Question 10**

1 / 1 pts

If we are 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?

• Age, BMI respectivelyAnswered

• BMI, Y respectively

• BMI, Age respectively

• Y, BMI respectively

**Question 11**

1 / 1 pts

Perform a simple linear regression to predict Y using respondents’ BMI. What is the correct equation for the regression line?

• Y = 10.2*BMI

• BMI = -118 + 10.2*YCorrect!

• Y = -118 + 10.2*BMI

• BMI = 21 + 0.034*Y

**Question 12**

1 / 1 pts

Perform a multiple regression analysis (with a margin of error of 5%) that examines all of the variables in the sample (excluding Y binary) as potential predictors of Y. Which of the following conclusions can be made based on the analysis without removing any of the predictor variables?

• LDL is a significant predictor in the model, LTG is not.

• TCH is a significant predictor in the model, Glucose is not.Correct!

• BMI is a significant predictor in the model, HDL is not.

• Age is a significant predictor in the model, Total Cholesterol is not.

**Question 13**

1 / 1 pts

After performing model building by applying backward deletion to the model described in Q12, which of the following conclusions is valid based on the final model?

• Glucose is not a significant predictor, but Gender is

• Total Cholesterol is not a significant predictor, but BP isYou Answered

• HDL is not a significant predictor, but LTG is

• Age is not a significant predictor, but LDL is

**Question 14**

1/ 1 pts

Based on the final model developed in Q13, which is the strongest predictor in the model?

• Intercept

• BMIou Answered

• Total Cholesterol

• Gender

**Question 15**

1 / 1 pts

Based on the final model developed in Q13, which is the weakest predictor in the model?ct!

• Gender

• Total Cholesterol

• Intercept

• BMI

**Question 16**

1 / 1 pts

How much of the variation in the dependent variable can be explained by the final regression model developed in Q13?

• 50.8%You Answered

• 51.5%

• <.0001

• We cannot determine this quantity

**Question 17**

1 / 1 pts

Is there a multicollinearity concern for the final model developed in Q13?

• There is a multicollinearity problem in the final model and we should delete the LTG variableCorrect!

• There is a multicollinearity problem in the final model and we should delete the Total Cholesterol variable

• There is no multicollinearity problem in the final model

• There is a multicollinearity problem in the final model and we should delete the Gender variable

**Question 18**

1 / 1 pts

The Y Binary variable was developed to categorize respondents into high and low development of Diabetes over the year since their baseline measurements were taken. What proportion of high development respondents are female? Answered

• 75.3%

• 69.6%

• 24.7%

• 30.4%

**Question 19**

1 / 1 pts

In an initial logistic regression analysis attempting to establish if all of the variables (excluding Y) in the sample can predict (with a margin of error of 5%) the level (high/low) of the disease, it can be concluded that:u Answered

• Some of the predictors are not significant and can be deleted from the model

• The overall model is significant in predicting the level of development of the disease

• The model accuracy can be determined by the confusion matrix

• All the other answer choices are correct

**Question 20**

1 / 1 pts

In the final logistic regression model to predict/classify Y binary, which of the following statements is true:

• 77 respondents were correctly classified by the model as high disease development

• 291 respondent were correctly classified by the model as low disease development

• 44 respondents were incorrectly classified by the model as low disease developmentCorrect!

• All of the other answer choices are correct

### Expert Answer

**Question 1**

**1 / 1 pts**

Using a pivot table, determine which of the following statements is incorrect.

- Category 4 has 97 respondents
**Correct!** **Category 3 has 54 respondents**- Category 5 has 73 respondents
- Category 2 has 90 respondents

**Question 2**

**1 / 1 pts**

Using a pivot table, determine which of the following statements is incorrect about the average age of respondents in each age category.

- Category 3 average age is 54.0 years
- Category 2 average age is 63.8 years
- Category 4 average age is 44.9 years
**!** **Category 1 average age is 71.2 years**