Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

GPA TUCE PSI GRADE 2.6 20 0 0 2.89 22 0 0 Apply Logistic Regression Model 3.28 24 0 0 2.92 12 0 0 to

image text in transcribedimage text in transcribed

image text in transcribedimage text in transcribed
GPA TUCE PSI GRADE 2.6 20 0 0 2.89 22 0 0 Apply Logistic Regression Model 3.28 24 0 0 2.92 12 0 0 to this Scenario 4.00 21 0 1 2.86 17 0 0 2.76 17 0 0 The following variables are included in the model: 2.87 21 0 0 3.03 25 0 0 GRADE: dependent variable, which is binary. 1 if a student receives an A, 0 if 3.92 29 0 1 else 2.63 20 0 0 3.32 23 0 0 Independent variables: 3.57 23 0 0 GPA: Cumulative Grade Point Average. Numeric 3.26 25 0 1 variable. 3.53 26 0 0 2.74 10 0 0 TUCE (Test of Understanding in College Economics): 2.75 25 0 0 Score in taking the TUCE 2.83 19 0 0 exam. Numeric variable. 3.12 23 1 0 3.16 25 1 1 PSI: Personalizes System of Instruction (of Economics 2.06 22 1 0 course). 1 if a student 3.62 28 1 1 takes PSI course; 0 if not. Categorical variable. 2.89 14 1 0 3.51 26 0 3.54 24 1 1 In this example, we want to use a logistic regression 2.83 27 1 1 model to relate the probability of making an A in an 3.39 17 1 1 economics course to three independent variables, 2.67 24 1 0 GPA, TUCE (score), and PSI. 3.65 21 1 1.OC 23 1 1 3.10 21 1 0 2.39 19 1 1The logistic regression model is in a form of: Pr(GRADE; = 1) = - It e - ( a+ B, GPA; + B,TUCE, +ByPSI;) Here Pr represents Pr(obability). Note that there are four coefficients in this model: a, B1, B2, B3. Estimation Results from a Software Package Estimate Std. Error z value Pr(> |z|) -13.021 4.931 -2.641 0.008 * * 2.826 1.263 2.238 0.025 * 0.095 0.142 0.672 0.501 2.379 1.065 2.234 0.025 * Here * * means that the coefficient is statistically significant at 0.1% significance level; * means the coefficient is statistically significant at 5% significance level. How do I get the above estimation results in Excel? Can you provide screenshots or step by step instruction

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Mathematics

Authors: OpenStax

1st Edition

1711470554, 978-1711470559

More Books

Students also viewed these Mathematics questions