Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consumers are considered to be under Debt Stress when they have to use a significant proportion of their available income to pay off existing debt.
Consumers are considered to be under Debt Stress when they have to use a significant proportion of their available income to pay off existing debt. Calculate a new column (column K) called DSI for Debt Stress Index. Debt stress is measured as Average Monthly Unpaid Credit Card Balance other monthly loan payments expressed as a proportion of Average Monthly Income DSI= (Balance Loans)/Income If the DSI is > 0.333 the consumer is said to be in stress. Create a new column (column L) title "In Stress" and use an IF function to identifying which customers are in stress as Yes or No. Create a Pivot Table which includes all of the data including your new variables. Use the Pivot Table to construct a Frequency Distribution for the variable Balance using an appropriate number of classes. Copy the Frequency Distribution to your solution document. Using the Frequency Distribution in d. create an appropriate Graph and label it. Save the graph to your solution document. Note: Make sure all classes are shown, including those with no observations. From the graph in part e. are their any outliers? Do you think they should be excluded from the data set? In one sentence what
Step 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