Part 1
(100 points)
Analyze the data in the
CreditCard
dataset in AER package. (Note that you have to install AER package and any other additional package that are required by AER)
The following variables are included in the dataset:
1. card: was the application for a card accepted? (Binary: 1/0) Response Variable
2. reports: Number of major derogatory reports
3. income: Yearly income (in USD 10,000)
4. Age: Age in years plus 12ths of a year
5. Owner: Does the individual own his/her home?
6. dependents: number of dependents
7. months: Months living at current address
8. share: ratio of monthly credit card expenditure to yearly income
9. selfemp: Is the individual self-employed?
10. majorcards: number of major credit cards held
11. active: number of active credit accounts
12. expenditure: average monthly credit card expenditure
Use variables 2 to 8 to determine which of the predictors influence the probability that an application is accepted. Online
Quiz 3B
will be based on your analysis below:
- Provide summary stat of the predictors. (5 points)
- There are some values of variable age under one year. Consider data with age>18 for your analysis for the rest of the questions. (5 points)
- Plot of income vs. reports (Number of major derogatory reports): mark individuals with card application accepted as blue, and not accepted as red. (5 points)
The online Quiz will be based on your interpretation of the plot.
- Boxplots of income as a function of card acceptance status. Boxplots of reports as a function of card acceptance status (mark card application accepted as blue, and not accepted as red). (Display two boxplots in same page). (10 points)
- Construct the histogram for the predictors. (5 points)
Note that share is highly right-skewed, so log(share) will be used in the analysis. reports is also extremely right skewed (most values of reports are 0 or 1, but the maximum value is 14. To reduce the skewness, log(reports+1) will be used for your analysis. Highly skewed predictors have high leverage points and are less likely to be linearly related to the response.
- Use variables 2 to 8 to determine which of the predictors influence the probability that an application is accepted. Use the summary function to print the results. (10 points)
Online Quiz will be based on the following and related concepts:
- Do any of the predictors appear to be statistically significant? If so, which ones? Explain how each of the significant predictors influences the response variable.
- To predict whether the application will be accepted or not, convert the predicted probabilities into class labels yes with the following condition: probs >.5="yes". Compute the confusion matrix and overall fraction of correct predictions. (30 points)
Online Quiz will be based on the following and related questions: