Have a Question ?

Home / Answered Questions / WPC 300 / wpc-300-practical-exam-q-785

(Solved): WPC 300: Practical Exam...



Practical Exam (Oct 23 UPDATE)  is now ready 

Get the summer 2021 version of all sections and data files

(Has higher score)


WPC 300: Practical Exam

Started: Sep 26 

Quiz Instructions

Practical Exam Instructions (already distributed).

This exam has a total of four sections. You are required to use four 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: This is an open book/note exam. You are expected to work individually to complete this exam before the due date. Remember the honor code.

Note: this is a timed quiz. You may check the remaining time you have at any point while taking the quiz by pressing the keyboard combination SHIFT, ALT, and 

 

SECTION A:

Instructions:

  • Use the following data file for this section
  • Remember the honor code.
  • This section is worth a total of 37.5 points. 
  • In addition to responding to multiple-choice questions, you need to submit an updated data file with your name appended to the front of the filename (e.g. firstname_lastname_filename). 
  • Create 2 new columns as follows:
    • The first new column shows the outcome when you calculate the total score for a school as a combination of 'critical reading mean' + 'mathematics mean' + 'writing mean'.
    • The second column will use a vlookup() function to segment the performance of a school according to the following Table:

Total score

Performance

0-1099

D

1100-1199

C

1200-1399

B

1400+

A

 

 

Question 1                                               15 pts

Create a pivot table on a new sheet to calculate how many schools were in each performance category. Show the outcome in both a table and a pie chart.

Screenshot of the 2 new columns (1 screenful is enough), pivot table output, and pie chart output (3 x 5 points).

Create a word document (that you will upload here) and paste those screenshot in sequence as follows:

1. Two-column output. 

2. Pivot Table output

3.  pie chart output

Upload 

 

 

Question 2                                       5 pts

 

What is the average (with 0 decimal places) across all schools for the total score?

Group of answer choices

  1215

  1287

   0

   2115

 

Question 3                                 5 pts

Which performance category has the least number of schools?

Group of answer choices

 A

 C

 B

 D

 

Question 4                            5 pts

How many schools were in the C category?

Group of answer choices

 77

 150

  43

  116

 

Question 5                                    5 pts

What is the average SAT score for performance category A (0 decimal places)?

Group of answer choices

 1268

  1141

 1058

 1609

Question 6                             2.5 pts

Add your name to the Excel filename (as the first part of the filename) and submit the completed file.

Upload 

 

 

 

SECTION B

Instructions:

  • Use the following data file for this section.
  • Remember the honor code.
  • This section is worth a total of 37.5 points.  Must use JMP Pro to complete the analysis and respond to the questions in this section. 
  • In addition to responding to multiple-choice questions, you need to submit an updated data file with your name appended to the front of the filename (e.g. firstname_lastname_filename). 
  • For this dataset, create a new column 'Total SAT Score' which is a combination of 'critical reading mean' + 'mathematics mean' + 'writing means'.

 

Question 7                         5 pts

What is the 95% confidence interval for the population mean of the total SAT score? 

Group of answer choices

 1109.00 & 1259.25

 1197.37 & 1232. 38

  -1 & 1

  1747.42 & 1968.25

 

Question 8                               5 pts

A principal from one of the schools believes that the mean value of the district's total  SAT score distribution is more than 1225. The null hypothesis for this test is:

Group of answer choices

 The mean of the district scores is not equal to 1225

 The mean of the district scores is greater than 1225

 The mean of the district scores is less than or equal to 1225

 The mean of the district scores is equal to 1225

 

Question 9                        5 pts

Perform the appropriate test with a 5% margin of error and take a screenshot. Make sure your name is visible in the screenshot. Upload the screenshot here.

Upload 

 

Question 10                 5 pts

Based on the test, what can we conclude about the district’s total SAT mean score?

Group of answer choices

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

 We fail to reject the null hypothesis

 We accept the null hypothesis

 We reject the null hypothesis

 

Question 11                                          5 pts

If your hypothesis for the district mean score is that the mean of total SAT score is below 1225, what would you conclude form your statistical test (with an alpha level of 5%)? 

Group of answer choices

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

   We fail to reject the null hypothesis

  We reject the null hypothesis

  We accept the null hypothesis

 

Question 12                                   5 pts

When you remove the data outliers from the total SAT score distribution by excluding and hiding the data points outside the interquartile range of the box plot, how will your answer change for the above question? 

Group of answer choices

 We reject the null hypothesis

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

   We fail to reject the null hypothesis

  We accept the null hypothesis

 

Question 13                            2.5 pts

Add your name to the JMP filename (as the first part of the filename) and submit the completed file with the saved scripts to answer Q 12.

Upload 

 

Question 14                                 5 pts

What is the median (with 1 decimal place) across all schools (prior to data outlier removal) for the total SAT score?

Group of answer choices

 1170.0

 1214.9

 174.9

  8.9

 

SECTION C

Instructions:

  • Use the following data file for this section:
  • Remember the honor code.
  • This section is worth a total of 37.5 points.  Must use JMP Pro to complete the analysis and respond to the questions in this section. 
  • In addition to responding to multiple-choice questions, you need to submit an updated data file with your name appended to the front of the filename (e.g. firstname_lastname_filename). 
  • For each action that you are asked to do, ensure that you save the script for that action.

Question: The local school district is wondering if there is a difference among the 3 categories of the SAT test, critical reading, writing & mathematics. In particular, if the mean scores of each category of SAT test are different. 

 

Question 15                     5 pts

What kind of statistical test would you perform to answer this question?

Group of answer choices

 Z-test

 ANOVA

 Regression

T-test

 

Question 16                               5 pts

Perform an appropriate analysis to answer the following question. 

What is the 95% confidence interval for the mean score (rounded up to the first decimal place)  in the writing category?

Group of answer choices

  391.9 – 403.5

 406.9 – 419.0

 398.3 – 410.2

 403.5 – 409.9

 

Question 17                           5 pts

Based on the appropriate statistical test, do you believe that mean SAT scores are different for different categories of tests (with a 5% margin of error)? Which of the following statements is true?

Group of answer choices

 You could not reject the null hypothesis

 You reject the null hypothesis and confirm that the means are same

 You could not conclude anything

 You reject the null hypothesis and confirm at least one of the means is different from the other

 

Question 18                         5 pts

Provide a screenshot of the box plots, and results from oneway ANOVA test.

Upload 

 

Question 19                         5 pts

Which value (from the one way ANOVA test) would you use to either reject or not reject a null hypothesis? 

Group of answer choices

 Root Mean Square error in “Summary of Fit” table

 Mean square value in the “Analysis of Variance” table

 p-value in the “Analysis of Variance” table

 Adjusted R^2 in “Summary of fit” table

 

Question 20                         5 pts

Which of the following tables from a statistical analysis helps you learn if the mean SAT score of one category is significantly different from the other two categories?

 

Group of answer choices

 Analysis of Variance

 Connecting Letter Reports

 Means for one-way ANOVA

 Summary of fit

 

Question 21                           5 pts

Based on the interpretation of the analysis, identify which categories of mean SAT scores are significantly different. 

Group of answer choices

 Mathematics is significantly different from Writing

 Mathematics is significantly different from Critical reading

 Writing is significantly different from Critical Reading

 Mathematics, Critical Reading and Writing are all significantly different from each other.

 

Question 22                      2.5 pts

Add your name to the JMP filename (as the first part of the filename) and submit the completed file, including scripts for all of your actions.

Upload 

 

 

SECTION D

Instructions:

  • Use the following data file for this section
  • Remember the honor code.
  • This section is worth a total of 37.5 points.  Must use JMP Pro to complete the analysis and respond to the questions in this section. 
  • In addition to responding to multiple-choice questions, you need to submit an updated data file with your name appended to the front of the filename (e.g. firstname_lastname_filename). 
  • For each action that you are asked to do, ensure that you save the script for that action.

Question: The loan manager would like to construct a statistical model to understand which one or more of the provided variables influence the amount of the loan requested. This information would help the bank to target those types of customers to promote their products such as a line of credit offer.  

 

 

Question 23                                       5 pts

What kind of statistical test would you perform to answer this question?

Group of answer choices

 Multiple linear regression

 T-test

 Simple logistic regression

 ANOVA

 

Question 24                             5 pts

What would be an example of a dependent and an independent variable respectively in this case?

Group of answer choices

  'Loan Amount’ and ‘Applicant Income’

 ‘Loan Status’ and ‘Credit history’

 ‘Applicant Income’ and ‘Loan Status’

 ‘Applicant Income’ and ‘Loan Amount’

 

Question 25                          5 pts

Perform a multivariate correlation analysis using all the continuous variables in the data.

What is the correlation coefficient between ‘loan amount’ and ‘loan amount term’?

Group of answer choices

 0.551

 0.17 0

 0.039

 -0.030

 

Question 26                          5 pts

Based on a standard least square regression analysis (assuming 5% margin of error) which of the following variables are significantly influencing the variable ‘Loan Amount’ in loan application process?

Group of answer choices

 Credit history, Education and Property area

 Education, Co-applicant income, and Applicant’s income

 Credit history, Education and Loan Amount term

 Education, Co-applicant income, and Loan Status

 

Question 27                        5 pts

Based on your analysis, which of the following variables have the most significant influence in predicting ‘Loan Amount’ in bank loan applications. 

Group of answer choices

 Married

 Applicant Income

 Education

 Loan Amount Term

 

Question 28                      5 pts

In your final regression model, what is the proportion of variance for the variable “Loan Amount” that is explained by the significant independent variables?

Group of answer choices

 0.41

 41.00

 0.38

 0.66

 

Question 29                                             5 pts

What is the regression equation for the final model? Get a screenshot and upload it here.

Upload 

Choose a File

 

Question 30                             2.5 pts

Add your name to the JMP filename (as the first part of the filename) and submit the completed file.

Upload 

 



We have an Answer from Expert View Expert Answer

Expert Answer


We have an Answer from Expert
Buy This Answer $15

-- OR --

Subscribe To View Unlimited Answers
Subscribe $12 / Month