Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored 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

Calculus Early Transcendentals

Authors: James Stewart

8th edition

1285741552, 9781305482463 , 978-1285741550

More Books

Students also viewed these Mathematics questions