Using a pivot table. determine which of the following statements is incorrect - 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 - Answer-Category 1 average age is 71.2 yea...
WPC 300 Practice Final Exam Questions
and Answers
Using a pivot table. determine which of the following statements is incorrect - 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 - 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 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? - 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? - 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. - Answer-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? - Answer-BMI, Y respectively
Perform a simple linear regression to predict Y using respondents' BMI. What is the
correct equation for the regression line? - Answer-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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller lectknancy. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £8.56. You're not tied to anything after your purchase.
