Description
I am working on a project but need someone to review and add to what I’ve done so far for questions 1, 3 and 4 and answer completely questions 2 and 5.
Unformatted Attachment Preview
Business Analytics – BA 728 ONLS 01
Fatma Abdel-Raouf
Homework Set # 2
Fall I, 2023
Due on September 16, 2023
1. Data Visualization: A researcher is interested in examining whether there is a difference in negotiation
by gender. The researcher collected data on the prices men and women pay for new cars. These are the
prices they pay after the discount they get from the dealer as a result of negotiation. The “Car Discounts
Data” file posted on Canvas has data on the discount the customer receives, the gender of the customer
along with other variables. Present the data in a more useful way, what conclusions can you draw about
the car discount customers receive?
2. COVID-19 Pandemic: During COVID-19 pandemic, many workers lost their jobs. The Bureau of Labor
Statistics (BLS) provides a weekly publication about the number of people who file for unemployment
insurance (UI). The report comes out every Thursday morning at 8:30 AM. Get data about the number of
workers who filed for initial unemployment insurance during the pandemic and present it graphically.
Comment on the data and the graph.
For your convenience, the website for the report is https://www.dol.gov/ui/data.pdf
3. Dashboard: “Credit Risk Data” file posted on Canvas contains data on loan applications and measures
of credit risk for the applicants. The database contains the purpose of the loan, the balance of checking
and savings accounts, the length of time the applicant has been a customer and other demographic
data. Your supervisor asks you to create a useful dashboard to present this data to the board of
directors to convey information about the loan applicants, their demographic, and credit risk. How
would you present it?
4. Data Summary Measure: “Home Market Value Data” file posted on Canvas contains data on the home
value, size, and age for a sample of 42 houses on the market.
a. Summarize this data set using different data summary measures.
b. Check for outliers in the data and make sure you identify the outliers in each variable.
BA728 HW#2
Page 1 of 2
c. Is there any correlation between the home value and its size? How about home value and its
age?
5. Descriptive Analytics in Business:
Find an article in any business publications such as the Wall Street Journal, Financial Times, Business
Week, Bloomberg, CNN, CNBC, … The article should include different methods of data summary
measures. Read the article and summarize your findings. Make sure you address the following points:
–
What data summary measures does the article include? What information can you conclude
from there? Are there any outliers in the data?
BA728 HW#2
Page 2 of 2
Count of Gender Column Labels
Row Labels
F
M Grand Total
Business
9 35
44
Education
12 11
23
Furniture
37 48
85
Large Appliance
1
3
4
New Car
34 70
104
Other
1
5
6
Repairs
4
8
12
Retraining
2
2
Small Appliance
32 73
105
Used Car
5 35
40
Grand Total
135 290
425
Count of Gender
120
100
80
60
40
20
0
Loan Purpose
Gender
M
F
Count of Gender
Count of Gender Column Labels
Row Labels
F
M Grand Total
High
78 133
211
Low
57 157
214
Grand Total
135 290
425
Low
Credit Risk
High
0
Credit Risk by Gender
157
57
Gender
M
F
133
78
50
100
150
200
Row Labels
Sum of Checking Sum of Savings
Business
77647
62560
Education
16714
30760
Furniture
62903
162879
Large Appliance
0
18222
New Car
141417
157949
Other
2275
5878
Repairs
4078
9042
Retraining
644
603
Small Appliance
122609
251299
Used Car
17119
71147
Grand Total
445406
770339
Sum of Checking Sum of Savings
300000
250000
200000
150000
100000
50000
0
Loan Purpose
um of Savings
Values
Sum of Checking
Sum of Savings
Credit Risk Data File
Loan Purpose
Small Appliance
Furniture
New Car
Furniture
Education
Furniture
New Car
Business
Small Appliance
Small Appliance
Business
New Car
Business
New Car
New Car
Used Car
Furniture
New Car
Repairs
Education
Furniture
Furniture
Furniture
Furniture
New Car
Business
Used Car
Used Car
Small Appliance
Small Appliance
Education
Small Appliance
Small Appliance
Business
Business
Small Appliance
Furniture
Small Appliance
Small Appliance
New Car
Other
Used Car
Small Appliance
Checking Savings
$0
$0
$0
$638
$963
$2.827
$0
$0
$6.509
$966
$0
$0
$322
$0
$396
$0
$652
$708
$207
$287
$0
$101
$0
$0
$0
$141
$0
$2.484
$237
$0
$335
$3.565
$0
$16.647
$0
$0
$0
$940
$0
$0
$218
$0
$16.935
$739
$1.230
$389
$347
$4.754
$0
$229
$533
$493
$0
$989
$3.305
$578
$821
$228
$129
$732
$683
$0
$12.348
$17.545
$3.871
$0
$485
$10.723
$245
$0
$0
$236
$485
$1.708
$0
$407
$895
$150
$490
$162
$715
$323
$128
$0
$109
$189
Months Customer Months Employed Gender Marital Status
13
25
19
13
40
11
13
14
37
25
49
11
10
25
13
31
49
13
28
7
34
13
25
37
11
22
19
49
37
19
37
31
13
16
49
5
25
9
49
13
49
25
37
12 M
0M
119 M
14 M
45 M
13 M
16 M
2M
9M
4F
0M
15 M
14 M
63 M
26 M
8M
4F
33 M
116 M
2F
16 F
5F
23 M
23 F
15 M
33 M
58 M
46 M
24 M
12 M
7M
32 M
2F
34 M
46 F
41 M
1M
40 F
42 M
74 M
0M
26 M
60 M
Single
Divorced
Single
Single
Single
Married
Married
Single
Single
Divorced
Single
Single
Married
Single
Single
Divorced
Divorced
Single
Single
Divorced
Divorced
Divorced
Married
Divorced
Single
Single
Single
Single
Single
Single
Single
Single
Divorced
Single
Divorced
Single
Divorced
Divorced
Married
Single
Single
Single
Single
Furniture
Furniture
Small Appliance
Furniture
New Car
Business
Small Appliance
Small Appliance
Furniture
Business
New Car
Used Car
Education
Furniture
New Car
New Car
Furniture
New Car
New Car
Small Appliance
New Car
Small Appliance
Small Appliance
Business
Used Car
Furniture
Furniture
New Car
Small Appliance
Business
Furniture
Small Appliance
New Car
Business
Business
Repairs
Business
New Car
Education
New Car
Education
New Car
Small Appliance
Used Car
Small Appliance
Small Appliance
Furniture
$664
$150
$0
$216
$0
$0
$0
$265
$4.256
$870
$162
$0
$0
$0
$461
$0
$0
$0
$580
$0
$0
$0
$0
$758
$399
$513
$0
$0
$565
$0
$0
$0
$166
$9.783
$674
$0
$15.328
$0
$713
$0
$0
$0
$0
$0
$303
$900
$0
$537
$6.520
$138
$0
$660
$724
$897
$947
$0
$917
$595
$789
$0
$746
$140
$659
$717
$667
$0
$763
$1.366
$552
$14.643
$2.665
$0
$442
$8.357
$0
$863
$322
$800
$656
$922
$885
$2.886
$626
$0
$904
$784
$806
$3.281
$759
$680
$104
$899
$1.732
$706
31
12
7
19
17
25
19
25
16
28
22
25
37
13
19
19
37
29
11
13
19
25
16
13
31
7
25
22
10
28
13
37
13
13
49
43
25
12
61
19
19
16
25
37
13
37
31
33 M
1F
119 M
3F
75 M
8M
5M
5M
36 F
6M
10 M
28 M
114 M
16 F
32 M
5F
60 M
10 M
8M
46 F
17 M
4M
115 M
31 M
0F
0M
5M
9M
81 M
28 M
69 M
85 M
2F
3F
32 M
0M
9M
6M
17 M
3F
20 F
59 M
3F
25 M
3M
11 F
14 M
Single
Divorced
Married
Divorced
Single
Single
Married
Married
Divorced
Single
Divorced
Single
Single
Divorced
Single
Divorced
Single
Single
Single
Divorced
Single
Married
Single
Single
Divorced
Single
Single
Single
Single
Single
Single
Single
Divorced
Divorced
Single
Single
Single
Single
Single
Divorced
Divorced
Single
Divorced
Single
Single
Divorced
Divorced
Education
Small Appliance
Repairs
Business
Small Appliance
Small Appliance
Small Appliance
New Car
Small Appliance
Furniture
Small Appliance
New Car
Retraining
Furniture
New Car
Education
Business
Furniture
New Car
Used Car
Small Appliance
Furniture
Business
Used Car
Furniture
Furniture
Small Appliance
Used Car
Large Appliance
Furniture
Furniture
Small Appliance
Small Appliance
Furniture
New Car
New Car
New Car
Furniture
Small Appliance
Business
Furniture
Small Appliance
Small Appliance
Small Appliance
Other
Business
Repairs
$1.257
$0
$273
$522
$0
$0
$0
$0
$514
$457
$5.133
$0
$644
$305
$9.621
$0
$0
$0
$0
$0
$6.851
$13.496
$509
$0
$19.155
$0
$0
$374
$0
$828
$0
$829
$0
$0
$939
$0
$889
$876
$893
$12.760
$0
$0
$959
$0
$0
$0
$0
$0
$576
$904
$194
$710
$5.564
$192
$637
$405
$318
$698
$369
$0
$492
$308
$127
$565
$12.632
$116
$178
$901
$650
$241
$609
$131
$544
$10.853
$0
$409
$391
$322
$583
$12.242
$479
$496
$466
$1.583
$1.533
$0
$4.873
$0
$717
$7.876
$4.449
$0
$104
$897
10
7
7
25
25
25
46
13
49
19
19
10
13
19
25
13
19
16
49
13
13
19
25
37
25
19
25
25
49
9
13
7
25
19
19
25
37
31
16
13
13
22
28
25
25
25
19
65 F
14 F
2M
79 M
1F
93 M
13 M
21 F
13 F
108 M
14 M
16 M
88 M
1F
41 M
22 M
14 M
9F
45 M
89 M
21 F
20 M
14 M
6M
24 M
15 F
81 F
14 M
15 M
12 F
9F
18 F
53 M
0M
56 M
42 M
79 M
21 F
94 M
73 M
94 M
10 F
20 M
87 M
54 M
23 M
2F
Divorced
Divorced
Married
Divorced
Divorced
Single
Single
Divorced
Divorced
Single
Single
Single
Single
Divorced
Single
Single
Married
Divorced
Single
Single
Divorced
Single
Single
Single
Single
Divorced
Divorced
Single
Single
Divorced
Divorced
Divorced
Single
Single
Single
Single
Single
Divorced
Single
Single
Single
Divorced
Single
Single
Single
Married
Divorced
New Car
Furniture
Furniture
Small Appliance
Small Appliance
Furniture
Small Appliance
Business
Repairs
Small Appliance
Furniture
New Car
New Car
Used Car
New Car
Used Car
New Car
Small Appliance
New Car
Used Car
Education
Furniture
Large Appliance
Furniture
Furniture
Business
Used Car
Small Appliance
Small Appliance
Used Car
Small Appliance
Repairs
Furniture
Used Car
New Car
New Car
New Car
Repairs
Furniture
Used Car
Small Appliance
New Car
Business
Small Appliance
Small Appliance
Business
Furniture
$698
$0
$0
$0
$12.974
$0
$317
$0
$0
$0
$192
$0
$0
$0
$0
$0
$942
$0
$3.329
$0
$0
$0
$0
$0
$0
$339
$0
$0
$0
$105
$0
$216
$113
$109
$0
$0
$8.176
$0
$468
$7.885
$0
$0
$0
$0
$0
$0
$0
$4.033
$945
$836
$325
$19.568
$803
$10.980
$265
$609
$1.851
$199
$500
$509
$270
$457
$260
$3.036
$643
$0
$6.345
$922
$909
$775
$979
$948
$2.790
$309
$762
$970
$320
$861
$262
$692
$540
$470
$192
$12.230
$772
$14.186
$6.330
$18.716
$886
$750
$3.870
$3.273
$406
$461
16
13
25
19
13
13
13
13
31
12
25
28
16
25
13
25
25
19
19
25
37
25
19
25
19
22
49
10
13
28
13
37
11
37
13
7
7
25
22
16
19
22
37
25
13
6
13
20 M
6M
99 M
13 F
7F
89 M
17 M
10 F
3M
0F
5F
7F
3M
25 M
63 M
78 M
36 M
6M
15 M
19 M
9F
3M
8M
48 M
2F
55 M
37 M
1F
14 F
54 M
111 M
2M
14 M
1M
0F
2M
5M
19 M
24 M
14 M
93 M
96 M
2M
11 F
4M
35 M
48 F
Married
Divorced
Single
Divorced
Divorced
Single
Single
Divorced
Divorced
Divorced
Divorced
Divorced
Single
Single
Single
Single
Single
Single
Single
Single
Divorced
Single
Married
Single
Divorced
Divorced
Single
Divorced
Divorced
Single
Single
Single
Divorced
Married
Divorced
Single
Married
Divorced
Single
Single
Single
Single
Divorced
Divorced
Married
Single
Divorced
Furniture
Small Appliance
Small Appliance
Furniture
Used Car
Business
New Car
New Car
Furniture
New Car
Small Appliance
Furniture
Small Appliance
Business
Small Appliance
New Car
Education
New Car
New Car
New Car
Furniture
Small Appliance
Business
Other
Small Appliance
New Car
Small Appliance
New Car
Furniture
Business
Used Car
Used Car
Small Appliance
Small Appliance
Education
Small Appliance
Large Appliance
Education
Furniture
Business
New Car
Repairs
Furniture
Small Appliance
New Car
Small Appliance
Business
$0
$0
$734
$0
$0
$172
$644
$0
$617
$0
$586
$0
$0
$0
$0
$0
$522
$585
$5.588
$0
$352
$0
$2.715
$560
$895
$305
$0
$0
$0
$8.948
$0
$0
$0
$0
$0
$483
$0
$0
$0
$663
$624
$0
$0
$152
$0
$0
$498
$340
$6.490
$348
$506
$14.717
$0
$1.571
$0
$411
$544
$0
$835
$823
$5.180
$408
$821
$385
$2.223
$0
$605
$7.525
$3.529
$1.435
$887
$243
$4.553
$418
$771
$463
$110
$10.099
$13.428
$208
$552
$3.105
$415
$1.238
$238
$127
$0
$785
$718
$493
$757
$9.125
$364
$598
19
19
7
25
28
25
19
25
31
25
13
19
25
22
16
48
10
16
22
37
13
14
49
25
13
7
19
25
11
31
16
7
13
13
16
19
13
13
31
19
37
19
13
49
13
13
37
4M
85 M
100 M
3F
7M
36 M
1F
19 F
3M
0F
0M
42 F
47 M
4M
12 M
5F
66 M
0M
10 F
20 F
4F
0F
14 M
20 M
4M
2F
4M
0M
13 M
90 M
108 M
0F
23 M
15 F
19 F
6M
0F
2F
35 F
57 M
9F
0F
21 M
45 M
24 F
12 F
14 M
Married
Single
Single
Divorced
Single
Single
Divorced
Divorced
Married
Divorced
Single
Divorced
Single
Single
Single
Divorced
Single
Single
Divorced
Divorced
Divorced
Divorced
Divorced
Single
Married
Divorced
Single
Single
Single
Single
Single
Divorced
Single
Divorced
Divorced
Married
Divorced
Divorced
Divorced
Single
Divorced
Divorced
Single
Single
Divorced
Divorced
Divorced
New Car
Small Appliance
Used Car
New Car
Small Appliance
Furniture
New Car
Used Car
Business
Furniture
Used Car
Small Appliance
Small Appliance
Business
Furniture
Small Appliance
Small Appliance
New Car
New Car
Used Car
Small Appliance
Business
Education
Furniture
Business
Other
Furniture
New Car
New Car
Business
Used Car
Business
Small Appliance
New Car
New Car
Furniture
Repairs
Small Appliance
Small Appliance
Furniture
Furniture
Furniture
Furniture
Other
Education
Small Appliance
New Car
$0
$156
$1.336
$0
$0
$0
$2.641
$0
$0
$0
$0
$0
$887
$0
$0
$0
$0
$18.408
$497
$0
$946
$986
$8.122
$0
$778
$645
$0
$682
$19.812
$0
$0
$859
$0
$0
$0
$0
$0
$0
$795
$0
$0
$0
$0
$852
$0
$0
$425
$374
$0
$0
$508
$956
$636
$0
$1.519
$922
$180
$701
$296
$519
$800
$736
$11.838
$364
$212
$888
$999
$0
$578
$136
$734
$861
$855
$4.486
$2.017
$0
$500
$859
$3.305
$1.218
$9.016
$11.587
$8.944
$807
$867
$16.804
$347
$836
$142
$169
$3.613
$403
$836
$0
10
13
37
13
25
22
13
40
19
5
22
16
7
49
13
7
5
13
16
25
16
28
22
37
49
25
10
37
25
25
31
25
13
49
22
25
25
31
49
16
16
7
19
61
7
25
19
19 M
58 F
11 M
3M
4F
41 F
71 F
74 M
29 M
2F
108 M
8M
42 M
2F
6F
70 M
35 M
9F
3F
0M
83 M
1F
4M
111 M
21 M
17 M
3F
85 M
37 M
1M
89 M
26 M
38 M
22 M
46 F
66 M
75 M
27 F
40 M
5F
4M
53 F
6M
83 F
5F
0M
7F
Single
Divorced
Single
Single
Divorced
Divorced
Divorced
Single
Single
Divorced
Single
Single
Married
Divorced
Divorced
Single
Single
Divorced
Divorced
Single
Single
Divorced
Divorced
Single
Single
Single
Divorced
Single
Single
Single
Single
Single
Single
Single
Divorced
Single
Single
Divorced
Single
Divorced
Single
Divorced
Single
Divorced
Divorced
Single
Divorced
Business
Business
Education
New Car
Used Car
Used Car
New Car
New Car
New Car
Small Appliance
New Car
New Car
Furniture
Retraining
New Car
Education
Education
Furniture
New Car
Small Appliance
Business
New Car
Small Appliance
New Car
Furniture
New Car
Furniture
Small Appliance
Small Appliance
Furniture
New Car
New Car
New Car
New Car
New Car
Furniture
Small Appliance
Furniture
New Car
Repairs
New Car
Small Appliance
Small Appliance
New Car
Used Car
New Car
Other
$0
$0
$0
$11.072
$0
$219
$8.060
$0
$0
$0
$0
$1.613
$757
$0
$0
$977
$197
$0
$0
$0
$0
$0
$256
$296
$0
$0
$0
$298
$0
$8.636
$0
$0
$19.766
$0
$0
$0
$0
$4.089
$0
$271
$949
$0
$911
$0
$0
$0
$0
$11.481
$3.285
$164
$891
$0
$841
$607
$486
$108
$0
$113
$0
$208
$603
$343
$463
$0
$299
$490
$6.628
$859
$750
$954
$591
$13.970
$857
$5.857
$3.326
$726
$214
$207
$713
$2.141
$483
$127
$367
$813
$0
$102
$759
$0
$503
$823
$693
$973
$648
$523
25
7
13
61
37
43
19
12
25
43
25
25
25
13
19
10
37
19
13
37
19
13
10
37
13
11
19
73
19
11
13
13
11
19
7
37
43
7
7
19
49
13
46
19
49
15
37
18 M
21 M
65 F
17 M
49 M
0M
71 F
22 M
52 M
28 F
31 F
118 M
36 M
35 M
22 F
61 F
17 M
11 M
15 F
65 M
23 M
14 M
13 M
103 M
24 F
34 M
20 M
15 M
7F
3F
119 M
29 M
54 F
90 F
13 M
22 M
28 M
14 M
0F
0F
36 F
62 M
4M
28 M
81 F
57 M
0M
Single
Single
Divorced
Single
Single
Single
Divorced
Single
Single
Divorced
Divorced
Married
Divorced
Married
Divorced
Divorced
Married
Single
Divorced
Single
Single
Single
Single
Single
Divorced
Single
Single
Married
Divorced
Divorced
Single
Single
Divorced
Divorced
Single
Single
Single
Married
Divorced
Divorced
Divorced
Single
Single
Single
Divorced
Divorced
Divorced
Used Car
Small Appliance
Used Car
New Car
Furniture
New Car
Business
Small Appliance
New Car
Education
Education
Furniture
New Car
Small Appliance
Furniture
Furniture
Furniture
Small Appliance
Business
Small Appliance
Small Appliance
Small Appliance
Small Appliance
Small Appliance
New Car
Furniture
Education
Repairs
Small Appliance
Furniture
Small Appliance
Small Appliance
Repairs
Small Appliance
Small Appliance
New Car
Small Appliance
New Car
Business
Small Appliance
Used Car
New Car
Furniture
New Car
Used Car
Small Appliance
Used Car
$271
$0
$0
$0
$0
$4.802
$177
$0
$0
$996
$705
$0
$0
$5.960
$0
$759
$0
$651
$257
$955
$0
$8.249
$0
$956
$382
$0
$842
$3.111
$0
$0
$2.846
$231
$0
$17.366
$0
$332
$242
$0
$929
$0
$0
$0
$0
$0
$0
$0
$646
$7.090
$596
$904
$541
$154
$0
$0
$337
$716
$837
$0
$7.710
$531
$129
$941
$596
$987
$0
$460
$0
$798
$0
$959
$1.482
$883
$12.721
$0
$0
$302
$538
$0
$702
$2.688
$0
$425
$214
$0
$272
$124
$17.124
$612
$862
$146
$14.190
$396
$519
$0
25
13
49
19
37
37
49
25
19
49
25
25
13
13
13
10
37
37
49
49
25
31
11
46
31
37
37
13
10
25
13
10
10
16
13
25
19
7
9
13
49
49
25
37
49
31
25
2F
67 M
119 M
13 M
2F
12 M
9M
107 M
33 M
83 M
24 F
114 M
5M
16 M
111 M
18 F
101 M
102 M
75 F
29 M
42 M
77 M
21 M
19 M
20 F
31 F
9M
27 F
30 M
59 M
14 M
99 M
89 M
21 M
10 M
2M
6M
90 M
1M
95 M
32 M
62 M
46 M
92 M
73 M
23 F
9M
Divorced
Single
Single
Single
Divorced
Single
Single
Single
Single
Single
Divorced
Single
Single
Married
Single
Divorced
Single
Single
Divorced
Single
Single
Single
Single
Single
Divorced
Divorced
Single
Divorced
Single
Single
Single
Single
Single
Single
Single
Single
Single
Single
Married
Married
Single
Single
Single
Single
Single
Divorced
Divorced
New Car
Furniture
Small Appliance
Furniture
Small Appliance
New Car
Used Car
New Car
New Car
Small Appliance
Small Appliance
Furniture
Furniture
Small Appliance
Small Appliance
Business
New Car
New Car
New Car
Furniture
Small Appliance
Education
Business
Business
New Car
Used Car
Used Car
Large Appliance
Furniture
Business
Furniture
New Car
Education
Used Car
New Car
Furniture
Furniture
Used Car
New Car
Small Appliance
Furniture
New Car
Furniture
Used Car
Used Car
Education
New Car
$538
$0
$0
$0
$0
$135
$2.472
$0
$10.417
$211
$16.630
$0
$642
$0
$296
$898
$478
$315
$122
$0
$0
$0
$670
$444
$3.880
$819
$0
$0
$0
$0
$0
$0
$0
$0
$0
$161
$0
$0
$789
$765
$0
$0
$983
$0
$0
$798
$0
$344
$204
$148
$435
$914
$0
$0
$412
$19.811
$822
$0
$3.369
$0
$707
$818
$177
$4.071
$466
$460
$991
$17.653
$497
$4.014
$921
$0
$0
$607
$15.800
$369
$4.973
$0
$761
$471
$674
$547
$524
$815
$0
$989
$10.406
$957
$770
$950
$160
$276
$137
$579
13
31
43
19
19
37
37
25
13
8
11
25
13
7
19
22
10
13
37
7
22
41
31
28
23
13
37
16
7
25
40
25
7
37
13
13
19
11
31
10
19
37
13
13
25
25
22
40 M
5M
2M
16 F
0F
7M
41 M
22 M
27 M
5F
47 M
17 M
65 F
26 M
93 M
105 F
40 M
3M
109 M
3F
4F
24 M
21 F
51 F
37 F
23 M
17 M
40 M
23 M
17 M
30 M
92 M
52 F
69 M
40 M
106 M
13 M
4F
0M
24 F
11 F
3F
5F
7M
91 M
25 F
70 M
Married
Divorced
Single
Divorced
Divorced
Single
Single
Single
Married
Divorced
Single
Single
Divorced
Single
Married
Divorced
Single
Single
Single
Divorced
Divorced
Single
Divorced
Divorced
Divorced
Single
Single
Single
Single
Single
Single
Single
Divorced
Single
Divorced
Single
Single
Divorced
Married
Divorced
Divorced
Divorced
Divorced
Married
Single
Divorced
Married
New Car
Small Appliance
Furniture
New Car
New Car
New Car
$193
$497
$0
$0
$0
$0
$2.684
$0
$0
$0
$712
$912
13
7
31
25
16
7
5F
51 M
53 M
103 F
6F
39 M
Divorced
Single
Single
Divorced
Divorced
Single
Age
Housing Years
23 Own
32 Own
38 Own
36 Own
31 Rent
25 Own
26 Own
27 Own
25 Own
43 Own
32 Rent
34 Rent
26 Own
44 Own
46 Own
39 Own
25 Own
31 Own
47 Own
23 Rent
22 Own
26 Rent
19 Own
27 Own
39 Rent
26 Own
50 Other
34 Other
23 Rent
23 Own
46 Other
35 Own
28 Own
25 Rent
36 Rent
41 Own
54 Own
43 Own
33 Own
34 Own
39 Other
34 Own
30 Own
Job
3 Unskilled
1 Skilled
4 Management
2 Unskilled
3 Skilled
1 Skilled
3 Unskilled
1 Unskilled
2 Skilled
1 Skilled
2 Management
2 Unskilled
1 Skilled
1 Skilled
3 Unskilled
4 Management
2 Skilled
2 Skilled
4 Skilled
2 Skilled
4 Skilled
4 Skilled
4 Skilled
2 Management
2 Unskilled
3 Skilled
4 Skilled
1 Skilled
4 Skilled
2 Skilled
4 Skilled
3 Skilled
2 Skilled
4 Skilled
4 Skilled
1 Unskilled
1 Skilled
2 Unskilled
1 Skilled
3 Skilled
4 Unemployed
3 Unskilled
2 Skilled
Credit Risk
Low
High
High
High
Low
Low
Low
Low
High
High
High
Low
Low
High
Low
Low
High
Low
Low
High
High
High
High
High
Low
Low
High
Low
Low
Low
High
Low
Low
Low
High
Low
High
Low
High
High
Low
Low
Low
48 Own
19 Own
29 Rent
26 Rent
42 Rent
30 Rent
38 Own
21 Own
32 Rent
35 Own
46 Own
37 Own
39 Own
29 Own
27 Rent
22 Rent
40 Own
44 Own
26 Own
57 Own
34 Own
47 Own
46 Own
38 Own
52 Own
34 Own
29 Other
39 Own
36 Own
25 Own
59 Own
27 Own
24 Rent
25 Own
29 Own
64 Own
31 Own
38 Own
41 Other
22 Own
29 Own
32 Rent
34 Own
23 Own
21 Own
49 Other
31 Own
2 Skilled
1 Skilled
2 Skilled
3 Skilled
4 Skilled
2 Skilled
4 Skilled
1 Skilled
4 Unskilled
2 Skilled
4 Skilled
3 Management
4 Management
3 Skilled
3 Unskilled
3 Skilled
2 Skilled
2 Unskilled
4 Unskilled
3 Unskilled
4 Unskilled
4 Skilled
3 Skilled
4 Unskilled
1 Management
1 Management
4 Skilled
2 Unskilled
4 Unskilled
4 Skilled
3 Skilled
2 Skilled
1 Skilled
1 Unemployed
2 Skilled
4 Unemployed
4 Skilled
4 Unskilled
4 Skilled
2 Unskilled
2 Skilled
3 Skilled
4 Skilled
4 Skilled
1 Skilled
4 Skilled
2 Skilled
High
Low
Low
High
High
High
Low
High
Low
High
Low
Low
High
Low
Low
High
High
High
High
Low
Low
High
Low
Low
High
Low
High
High
Low
Low
High
Low
High
High
Low
Low
Low
Low
High
High
High
High
High
High
High
High
Low
40 Rent
28 Own
21 Own
30 Own
37 Own
33 Own
22 Other
23 Own
21 Own
40 Own
36 Own
29 Own
37 Own
26 Own
37 Other
39 Rent
27 Own
19 Rent
45 Other
34 Other
43 Rent
33 Own
35 Own
31 Other
25 Own
27 Own
56 Rent
45 Own
53 Own
23 Own
25 Own
63 Own
34 Own
24 Own
35 Own
30 Own
29 Other
20 Rent
49 Own
56 Rent
48 Rent
24 Own
22 Own
30 Own
39 Own
20 Own
22 Own
4 Unskilled
1 Skilled
1 Unskilled
4 Skilled
3 Skilled
2 Skilled
4 Skilled
2 Unskilled
2 Skilled
1 Skilled
2 Skilled
1 Skilled
4 Skilled
1 Skilled
3 Skilled
4 Unskilled
2 Skilled
4 Skilled
4 Skilled
4 Skilled
2 Unskilled
1 Unskilled
4 Unskilled
2 Management
2 Skilled
2 Skilled
4 Management
4 Management
4 Skilled
4 Skilled
1 Skilled
3 Skilled
2 Skilled
1 Unemployed
4 Skilled
3 Skilled
3 Skilled
4 Skilled
4 Skilled
4 Unskilled
4 Skilled
2 Skilled
2 Unskilled
4 Skilled
3 Management
2 Unskilled
4 Skilled
Low
Low
Low
High
Low
Low
High
High
High
Low
High
Low
Low
Low
High
High
High
Low
High
High
Low
High
High
Low
Low
Low
Low
Low
High
High
Low
Low
High
High
High
High
Low
High
Low
Low
Low
High
High
High
High
Low
High
24 Rent
41 Own
32 Own
23 Own
41 Rent
52 Other
65 Own
26 Own
33 Own
56 Own
24 Own
20 Rent
35 Own
34 Own
38 Own
34 Own
37 Own
31 Other
67 Rent
26 Own
24 Own
21 Other
46 Own
22 Rent
20 Rent
60 Rent
25 Own
21 Rent
22 Own
29 Own
56 Own
32 Rent
30 Own
27 Rent
37 Own
39 Own
26 Own
32 Own
31 Own
35 Own
31 Own
64 Own
27 Own
31 Own
32 Own
73 Own
30 Own
2 Skilled
1 Skilled
4 Skilled
2 Skilled
3 Skilled
4 Management
3 Unskilled
2 Skilled
1 Unskilled
4 Unskilled
4 Unskilled
3 Skilled
3 Skilled
3 Skilled
4 Management
4 Management
3 Skilled
2 Management
4 Skilled
2 Skilled
2 Management
1 Skilled
3 Unskilled
4 Skilled
4 Skilled
2 Unskilled
3 Skilled
4 Skilled
1 Skilled
2 Management
4 Unskilled
1 Unskilled
2 Unskilled
4 Management
2 Unemployed
4 Unskilled
2 Unemployed
2 Skilled
2 Skilled
2 Skilled
3 Management
4 Skilled
1 Skilled
2 Unskilled
3 Unskilled
4 Unskilled
4 Unskilled
High
Low
Low
High
Low
High
High
Low
High
Low
High
High
Low
Low
Low
Low
Low
Low
High
Low
High
Low
High
High
Low
High
Low
High
Low
Low
High
High
Low
High
Low
Low
Low
Low
Low
Low
Low
Low
High
High
High
Low
Low
42 Own
45 Own
27 Own
22 Rent
26 Own
33 Own
27 Own
24 Rent
21 Own
28 Rent
51 Own
21 Own
27 Own
40 Own
34 Other
34 Own
63 Own
33 Own
28 Own
24 Own
18 Rent
63 Own
37 Own
38 Own
22 Rent
31 Own
31 Own
42 Other
24 Rent
65 Own
22 Rent
22 Rent
51 Own
23 Own
30 Own
32 Own
21 Own
52 Own
22 Rent
41 Own
53 Rent
54 Other
37 Own
27 Own
25 Own
34 Own
29 Own
1 Unskilled
4 Skilled
4 Skilled
4 Unskilled
2 Skilled
3 Skilled
3 Skilled
4 Skilled
1 Skilled
4 Unemployed
1 Management
1 Skilled
2 Skilled
2 Unskilled
4 Skilled
1 Unskilled
4 Unskilled
2 Management
4 Skilled
2 Skilled
4 Unskilled
4 Skilled
2 Skilled
3 Management
1 Skilled
1 Unskilled
2 Skilled
2 Skilled
2 Unskilled
4 Management
4 Skilled
2 Unemployed
4 Skilled
4 Unskilled
3 Skilled
2 Skilled
3 Skilled
4 Skilled
4 Skilled
2 Skilled
2 Skilled
4 Unemployed
3 Unskilled
4 Skilled
2 Skilled
2 Skilled
2 Management
High
Low
Low
High
Low
Low
High
High
Low
High
High
High
Low
High
Low
Low
Low
High
High
High
Low
Low
High
High
High
High
Low
High
High
High
Low
Low
Low
High
Low
High
High
High
High
Low
Low
High
Low
High
High
Low
High
27 Own
32 Own
29 Own
32 Own
28 Rent
25 Rent
51 Other
44 Own
33 Own
22 Rent
35 Own
30 Own
27 Own
23 Rent
19 Rent
44 Own
41 Own
35 Own
25 Rent
28 Other
34 Own
31 Own
32 Rent
41 Own
22 Own
28 Own
21 Rent
41 Own
36 Own
26 Own
37 Other
35 Rent
34 Own
43 Other
30 Own
31 Rent
43 Other
24 Own
26 Own
45 Rent
26 Own
48 Own
43 Own
59 Other
55 Own
29 Own
32 Own
3 Unskilled
3 Unskilled
2 Management
1 Unskilled
2 Unskilled
4 Unskilled
4 Management
2 Management
1 Skilled
3 Unskilled
4 Management
2 Skilled
3 Unskilled
4 Skilled
4 Skilled
4 Unskilled
1 Unskilled
2 Skilled
1 Unemployed
2 Management
2 Skilled
1 Skilled
1 Skilled
2 Skilled
2 Skilled
3 Management
4 Skilled
4 Management
2 Unskilled
2 Skilled
4 Management
4 Management
1 Skilled
2 Skilled
2 Management
3 Skilled
4 Skilled
2 Skilled
2 Skilled
1 Skilled
3 Unskilled
1 Skilled
3 Skilled
4 Management
2 Skilled
2 Management
2 Skilled
High
High
Low
High
High
Low
Low
Low
Low
Low
Low
Low
Low
High
High
Low
Low
Low
High
Low
Low
Low
High
High
High
High
Low
High
High
High
Low
Low
Low
High
Low
Low
Low
Low
High
Low
Low
Low
High
High
Low
High
High
53 Own
33 Own
56 Other
33 Other
46 Other
54 Other
22 Own
35 Rent
46 Own
29 Own
22 Rent
53 Own
42 Own
20 Rent
35 Own
33 Own
26 Own
46 Other
28 Own
38 Own
35 Own
47 Own
23 Own
56 Other
28 Rent
48 Own
27 Own
23 Own
24 Rent
22 Own
42 Rent
25 Own
47 Other
32 Rent
25 Rent
36 Own
25 Own
26 Own
53 Own
66 Own
23 Own
25 Own
24 Own
31 Other
57 Other
44 Own
42 Own
3 Management
2 Unskilled
4 Unskilled
4 Skilled
4 Skilled
2 Management
2 Management
2 Skilled
4 Unskilled
3 Management
4 Skilled
4 Skilled
3 Skilled
4 Skilled
3 Skilled
3 Management
2 Skilled
4 Skilled
2 Skilled
4 Skilled
2 Skilled
4 Skilled
3 Skilled
4 Skilled
4 Unskilled
3 Skilled
2 Skilled
2 Skilled
4 Skilled
2 Skilled
4 Skilled
2 Skilled
4 Unskilled
4 Skilled
3 Skilled
2 Skilled
2 Skilled
2 Skilled
4 Unemployed
4 Skilled
2 Skilled
2 Skilled
2 Unskilled
4 Unskilled
4 Unskilled
4 Management
3 Management
High
Low
Low
Low
High
Low
Low
Low
High
High
High
Low
High
High
Low
High
Low
Low
High
Low
High
High
Low
High
High
Low
Low
High
High
Low
High
High
High
High
Low
Low
High
Low
Low
Low
Low
Low
High
High
High
High
Low
27 Rent
51 Own
23 Other
31 Own
22 Rent
35 Own
37 Other
35 Own
30 Own
49 Other
32 Own
52 Own
45 Own
23 Own
41 Own
28 Own
30 Own
50 Own
58 Rent
36 Own
23 Rent
48 Own
37 Own
20 Rent
23 Own
39 Own
34 Other
22 Own
21 Own
38 Rent
36 Other
26 Own
47 Own
38 Other
27 Rent
25 Own
28 Own
67 Own
25 Own
34 Own
38 Other
41 Other
26 Own
35 Own
45 Other
32 Own
47 Other
4 Skilled
4 Skilled
4 Skilled
2 Skilled
4 Skilled
4 Skilled
4 Skilled
1 Management
2 Skilled
4 Skilled
2 Skilled
4 Skilled
2 Skilled
1 Skilled
4 Skilled
2 Skilled
4 Skilled
2 Skilled
3 Skilled
3 Skilled
4 Unskilled
4 Unskilled
4 Skilled
4 Skilled
2 Skilled
4 Skilled
4 Unskilled
4 Skilled
2 Skilled
2 Management
4 Skilled
4 Unskilled
4 Skilled
4 Skilled
2 Skilled
1 Skilled
3 Skilled
4 Management
2 Skilled
1 Skilled
4 Skilled
4 Management
4 Skilled
4 Skilled
4 Skilled
2 Skilled
4 Skilled
High
Low
High
High
High
Low
Low
Low
High
High
Low
Low
High
Low
Low
High
High
Low
High
Low
High
Low
Low
High
High
Low
Low
Low
High
High
Low
Low
Low
High
High
Low
Low
High
Low
Low
High
High
High
Low
High
Low
Low
24 Own
30 Own
33 Own
23 Rent
21 Rent
36 Other
30 Own
52 Other
27 Own
44 Own
26 Own
24 Own
24 Own
50 Own
31 Own
38 Own
28 Own
48 Own
56 Other
31 Own
28 Own
26 Own
25 Rent
41 Other
24 Rent
29 Own
25 Own
35 Own
35 Own
26 Own
29 Own
59 Own
34 Other
41 Other
35 Own
27 Rent
41 Own
30 Rent
27 Own
65 Own
19 Rent
33 Own
24 Rent
40 Rent
62 Own
33 Other
29 Own
3 Unskilled
4 Unskilled
3 Skilled
4 Skilled
4 Skilled
4 Skilled
2 Management
4 Skilled
2 Skilled
1 Skilled
2 Skilled
1 Skilled
2 Skilled
2 Skilled
2 Unskilled
4 Skilled
3 Skilled
3 Unskilled
2 Management
4 Skilled
2 Skilled
3 Skilled
4 Unskilled
4 Management
4 Skilled
2 Skilled
2 Skilled
3 Skilled
2 Unskilled
3 Unskilled
4 Management
4 Unskilled
4 Skilled
4 Skilled
3 Skilled
4 Skilled
3 Skilled
4 Skilled
2 Management
3 Unskilled
4 Skilled
4 Skilled
3 Skilled
4 Skilled
4 Skilled
4 Unskilled
3 Skilled
High
High
High
High
High
High
Low
High
High
Low
Low
Low
High
Low
Low
High
High
Low
High
High
Low
High
High
High
Low
Low
High
Low
Low
Low
Low
High
High
Low
High
Low
High
Low
High
Low
High
High
High
Low
Low
High
Low
22 Own
35 Other
30 Own
28 Own
28 Own
44 Own
2 Unskilled
4 Skilled
4 Skilled
2 Skilled
2 Skilled
3 Management
High
Low
High
High
High
Low
Count of Gender
Count of Gender
120
Credit Risk by Gender
100
80
157
Low
60
57
Gender
Credit Risk
40
M
F
133
35
20
9
0
High
78
0
50
100
150
Loan Purpose
200
Sum of Checking Sum of Savings
Account Amounts by Loan Purpose
300000
250000
200000
150000
100000
50000
0
Business
Education
Sum of Checking
77647
16714
Sum of Savings
62560
30760
Loan Purpose
Large
Appliance
New Car
Other
62903
0
141417
2275
162879
18222
157949
5878
Furniture
Job
Count of Gender
Management
Skilled
Unemployed
70
Unskilled
73
48
Gender
Housing
M
F
35
11
9
37
12
34
35
Own
5
Rent
32
5
1
3
1
8
4
2
Other
Marital Status
Divorced
Married
Loan Purpose
Single
ts by Loan Purpose
Values
Sum of Checking
Sum of Savings
Repairs
Retraining
Small
Appliance
Used Car
4078
644
122609
17119
9042
603
251299
71147
Job
Management
Skilled
Unemployed
Unskilled
Housing
Other
Own
Rent
Marital Status
Divorced
Married
Single
Row Labels
Frequency
131-630
631-1130
1131-1630
1631-2130
2131-2630
Grand Total
Relative Frequency
12
30
29
23
6
100
Frequency
Row Labels
131-630
631-1130
1131-1630
1631-2130
2131-2630
Grand Total
Column Labels
F
Frequency
Row Labels
131-630
631-1130
1131-1630
1631-2130
2131-2630
Grand Total
Column Labels
F
0.00%
5.00%
18.00%
17.00%
6.00%
46.00%
5
18
17
6
46
12%
30%
29%
23%
6%
100%
M
12
25
11
6
54
M
12.00%
25.00%
11.00%
6.00%
0.00%
54.00%
Cumulative
Cumulative relative
Frequency
frequency
12
12.00%
42
42.00%
71
71.00%
94
94.00%
100
100.00%
Grand Total
12
30
29
23
6
100
Grand Total
12.00%
30.00%
29.00%
23.00%
6.00%
100.00%
Frequency
Chart Title
35.00%
% of Car Buyers
30.00%
25.00%
11.00%
20.00%
6.00%
Gender
25.00%
15.00%
M
F
10.00%
5.00%
18.00%
17.00%
12.00%
0.00%
6.00%
5.00%
0.00%
0.00%
131-630
631-1130
1131-1630
1631-2130
2131-2630
Discount
Discount
Conclusions:
– Cumulatively, females receive more discount than males.
– 58% of customer received a discount over $1,130. 41% of those customers were
females.
– Most males received a discount between $631 and $1,130.
Gender
M
F
ustomers were
Discount Age
$998
1422
2520
1649
1354
1525
1400
676
919
1431
1838
1376
950
1472
2147
1538
988
1164
131
564
1827
1075
1334
1526
1844
2375
1679
945
1116
1538
532
2133
1918
1743
648
990
1766
1948
1557
800
339
569
1138
1968
1273
1657
27
41
21
46
27
43
55
34
39
19
46
34
35
39
19
29
43
35
38
40
52
46
41
21
28
42
43
37
44
38
53
18
36
33
43
48
46
39
31
35
44
41
25
31
57
26
Income
Gender
$47,645 F
32253 F
28650 F
29190 M
37997 F
25400 M
30282 M
45671 M
46477 M
27826 F
31731 F
20293 F
32655 M
35605 F
25801 F
20930 F
49336 M
39360 F
40623 M
47474 M
36371 F
37546 M
31734 M
21903 F
30568 M
21020 F
28799 F
50837 F
41937 M
30610 F
48257 M
20689 F
32626 F
27015 F
41184 M
43452 M
29314 F
38072 F
21022 F
33224 M
61025 M
46329 M
28018 M
23280 F
47204 F
26161 F
Female
1
1
1
0
1
0
0
0
0
1
1
1
0
1
1
1
0
1
0
0
1
0
0
1
0
1
1
1
0
1
0
1
1
1
0
0
1
1
1
0
0
0
0
1
1
1
Discount
Gender
Discount of the car price the shopper receive
1 for Female, 0 for male
1852
2137
673
2162
1733
1821
336
884
892
801
1495
1014
1574
1048
1057
785
1541
1990
804
361
1490
1655
597
1735
189
697
692
1642
859
2110
1233
419
1982
1791
1487
877
1203
410
997
727
1321
864
786
421
1832
1382
679
25
29
43
25
42
39
30
33
30
37
37
31
40
35
41
42
30
51
50
54
21
57
27
56
54
39
38
31
52
38
35
42
20
24
23
25
57
29
40
22
37
51
23
35
23
33
55
28876 F
21388 F
54008 M
27396 F
38142 F
33869 F
38950 M
32990 M
37660 F
45593 M
20758 M
28605 M
33357 F
33795 M
48092 F
40369 M
20610 F
24734 M
44085 M
60448 M
20912 F
40701 F
37258 M
34783 F
43000 M
41004 M
43955 M
28891 M
45577 M
19016 F
36357 F
64663 M
27712 F
21559 M
28597 F
36041 M
50666 F
47653 M
47659 F
38710 M
36310 M
51353 M
29645 M
42593 M
26356 M
28056 M
55157 M
1
1
0
1
1
1
0
0
1
0
0
0
1
0
1
0
1
0
0
0
1
1
0
1
0
0
0
0
0
1
1
0
1
0
1
0
1
0
1
0
0
0
0
0
0
0
0
1342
1266
1460
1621
1181
784
1690
33
41
39
33
45
41
27
27594 M
42611 F
32851 M
30493 M
42076 M
41515 M
22180 F
0
1
0
0
0
0
1
f the car price the shopper receives, measured as the amount in $ below the listed price of the car
Row Labels
27
28
32
33
Grand Total
Count of House Age
9
13
14
6
42
Sum of Market Value
829500
1103100
1372900
561400
3866900
Count of House AgeSum of Market Value
16
14
12
10
8
6
4
2
0
27
House Age
28
32
33
1600000
1400000
1200000
1000000
800000
600000
400000
200000
0
Values
Count of House Age
Sum of Market Value
Home Market Value
House Age
House Age Square Feet
Market Value
33
1.812
$90
