Mastering Data Analysis in Excel, week (1-6) All Quiz Answers with Assignments. - THINK TO MAKE

week 6 Assignment : PROMPT What is your predictive model? a. Describe the arithmetic clearly so that another learner could implement your model on new standardized input data if they wished. b. Give an example of the score you would assign the following applicant, whether they would be approved or rejected for a credit card and why. a) The first thing we must do is analyze the correlation of the variables, and identify which are the most relevant in the model. Then, we must identify the parameters or coefficients that will accompany the variables of said model, using the linear regression methodology in Excel seen in the course. The most relevant parametric values are: Years at a current employer: -0.19 income over the past year: -0.08 Current credit card debt: -0.19 Current automobile debt: -0.07 Then, with these coefficients and taking into account the correlation, we will make our model. Which is: SCORE = 0.19 * Years at a current employer -0.08 * income over the past year -0.19 * Current credit card debt-0.07 * Current automobile debt b)Considering that by optimizing AUC, we got the threshold for the minimum cost / event as 0.25. A score below -0.04 for example will be determined as a negative test, which translates as a financially profitable person, who could be approved for a credit card. PROMPT Mastering Data Analysis in E… Mastering Data Analysis in Excel, week (1-6) All Quiz Answers with Assignments.  SHARE:  Facebook  Twitter  Google+  Pinterest Think to make YouTube 4K SUBSCRIBE Select Language Select Language Powered by Translate Powered by Translate TRANSLATE Write Professional Emails in English , week (1-5), All quiz Answers with Assignments.  JUNE 16, 2020 Marketing in a Digital World week (1-4) All Quiz Answers with Assignments.  JULY 06, 2020 Engineering Project Management Initiating and Planning, All Quiz Answers with Assignments.  JULY 05, 2020 POPULAR  T