Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Download the data and perform logistic regression using only analysis tool in excel. https://archive-beta.ics.uci.edu/ml/datasets/default+of+credit+card+clients Component 1: Excel-based statistical analysis using the function of Data Analysis
Download the data and perform logistic regression using only analysis tool in excel.
https://archive-beta.ics.uci.edu/ml/datasets/default+of+credit+card+clients
Component 1: Excel-based statistical analysis using the function of Data Analysis 1. Use the Analysis Tool of Descriptive Analysis and produce the descriptive statistics for variables of Gender, Education, Marriage, Age. Save the resultant worksheet in your Excel data file. 2. Use the Analysis Tool of Regression to run a logistic regression of Default Payment Next Month (Y) on each of the variables of Gender (X2), Education (X3), Marriage (X4), and Age (X5) individually first and then on all 4 variables together. Save the resultant worksheets in your Excel data fileStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started