Question

Explain how to do the following using EXCEL

1. Apply Box plot for the field/variable, “Months Employed”. Briefly interpret what the plot shows.

2. Construct a histogram of the z-scores of the “Savings” field. Briefly explain information provided by the chart.

	Savings	Months Employed	Age	Housing	Credit Risk
1	$739	12	23	Own	Low
2	$1,230	0	32	Own	High
3	$389	119	38	Own	High
4	$347	14	36	Own	High
5	$4,754	45	31	Rent	Low
6	$0	13	25	Own	Low
7	$229	16	26	Own	Low
8	$533	2	27	Own	Low
9	$493	9	25	Own	High
10	$0	4	43	Own	High
11	$989	0	32	Rent	High
12	$3,305	15	34	Rent	Low
13	$578	14	26	Own	Low
14	$821	63	44	Own	High
15	$228	26	46	Own	Low
16	$129	8	39	Own	Low
17	$732	4	25	Own	High
18	$683	33	31	Own	Low
19	$0	116	47	Own	Low
20	$12,348	2	23	Rent	High

Answer 1

for box plot

min = 0

Q1 = 4

Median =13.5

mean = 25.75

Q3 =31.25

max = 63

outlier = 2 (116,119)

2) z score = (x - µ) / std.dev

Savings	zscore
$739	$738.49
$1,230	$1,229.49
$389	$388.49
$347	$346.49
$4,754	$4,753.49
$0	($0.51)
$229	$228.49
$533	$532.49
$493	$492.49
$0	($0.51)
$989	$988.49
$3,305	$3,304.49
$578	$577.49
$821	$820.49
$228	$227.49
$129	$128.49
$732	$731.49
$683	$682.49
$0	($0.51)
$12,348	$12,347.49

there are outliers in the data..