What is the mean savings?
What is the standard deviation of education?
What is the median of education?
Transcribed Image Text: AutoSave OFF GARS
Home Insert
X
B5
1
2
3
4
Paste
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
A
Variable
App Num
Income
Education
Age
Residence
Employ
Savings
Debt
Credit ca
Credit cards
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
AC
Draw Page Layout
esc
Arial
B I U •
X V fx The age of the applicant
4 ▶
Data Dictionary
Ready Accessibility: Investigate
Sheet1
✓11
Description
The identification number for the applicant.
The income of the applicant, in US dollars
The education level of the applicant, in years
The age of the applicant
!
1
38
***
The length of time that the applicant has lived at the current residence, in years
The length of time that the applicant has worked for the current employer, in years
The amount of savings that the applicant has, in US dollars
The amount of debt that the applicant has, in US dollars
The number of credit cards that the applicant has
F1
C
Formulas Data Review View
A Α' Α΄
2
V
1UA-
F2
+
B
W
EME
#3
80
F3
E
54
$
000
ODD
F4
V
E
R
Automate Tell me
475
%
Wrap Text v
Merge & Center v
C
LoanApp.xlsx - Read-Only
F5
T
D
General
A
$%9
6
E
MacBook Air
F
F6
Y
A bank requires eight pieces of information from loan applicants: income,
education level, age, length of time at current residence, length of time with
current employer, savings, debt, and number of credit cards. A bank
administrator wants to analyze this data to determine the best way to group
and report it. The administrator collects this information for 30 loan
applicants.
&
←898
7
G
H
Ja
F7
✓ E D
Conditional Format -Cell
Formatting as Table Styles
* 00
8
U
I
DII
J
F8
(
9
K
1
DD
V
F9
$x
L
o
Transcribed Image Text: AutoSave OFF A B C ...
Insert Draw Page Layout
X
LG
Home
✩
A2
1
2
Paste
3
4
5
6
7
3
8
9
10
11
12
A
App Num
640
345
981
915
26
27
807
co
310
849
sk
390
20%
929
729
res
P
923
825
785
13
14 515
15 1015
16 587
17 534
18 286
19 596
725
411
351
23 737
20
21
22
24
415
334
25
675
314
28
262
29 1021
30
737
31 1004
32
33
34
35
36
37
38
39
40
41
42
43
44
< ▶
Calibri (Body)
B I U v
Xfx 640
esc
B
C
Income Education
50000
72000
16
18
61000
01000
18
10
68000
88000
91100
31100
45100
13:00
36200
50200
41000
40000
20000
32000
32000
29000
23000
21240
58700
41000
38720
88240
40000
34600
29800
56400
39800
54200
42650
62200
72200
26530
36500
40000
41200
50000
20
20
Sheet1
18
10
14
14
14
24
12
22
16
16
16
12
12
14
16
16
16
18
16
12
16
14
16
16
14
16
12
16
16
12
16
!
D
Age
28
35
36
25
F1
35
38
11
41
29
34
32
30
28
26
38
29
36
38
39
40
27
30
29
31
27
40
34
30
26
29
Data Dictionary
Ready Accessibility: Investigate
34
35
✓11
V
E
Residence
2
10
6
4
-
8
15
6
9
8
2
1
2
2
9
5
11
13
7
14
1
2
3
5
3
8
5
1
2
3
5
8
(@
+
F2
Formulas
• Α' Α'
Av
F
Employ
2
8
5
4
9
14
5
8
7
2
4
2
9
3
4
11
12
6
12
3
1
2
3
2
10
4
2
2
2
4
6
G
Savings
5000
12000
15000
40000
980
-
20000
40000
3900
9900
100
400
Data
3000
5000
19000
16000
2100
100
4500
300
24500
13600
16000
34000
100
3000
2500
14200
5200
10000
12000
0
3100
1900
1000
4500
#
20
F3
E
H
Debt
1200
5400
1000
1100
o
0
9
22000
7000
200
1760
550
4600
10010
7800
10000
540
8100
1300
100
10000
1200
900
800
Review View
1000
700
400
12000
800
1300
1200
1400
E
$
Credit cards
2
4
3
2
4
2
3
3
2
2
I
2
4
-
4
F
2
3
3
2
1
2
6
2
2
5
2
5
3
2
1
2
3
5
E
000
000
F4
J
Automate
ab Wrap Text v
%
Merge & Center ✓
F5
LoanApp.xlsx - Read-Only
Tell me
K
L
+
<<
General
F6
$ % 9
V
MacBook Air
M
N
&
7
F7
0
.00
*
Definition Definition Middle value of a data set. The median divides a data set into two halves, and it also called the 50th percentile. The median is much less affected by outliers and skewed data than the mean. If the number of elements in a dataset is odd, then the middlemost element of the data arranged in ascending or descending order is the median. If the number of elements in the dataset is even, the average of the two central elements of the arranged data is the median of the set. For example, if a dataset has five items—12, 13, 21, 27, 31—the median is the third item in ascending order, or 21. If a dataset has six items—12, 13, 21, 27, 31, 33—the median is the average of the third (21) and fourth (27) items. It is calculated as follows: (21 + 27) / 2 = 24.
Expert Solution
Step 1: Determine the given data in the question The data is given in the Excel sheet whose name is LoanApp.
The data contains 9 variables.
Sample size
To find summary statistics for savings and education.
Step by step
Solved in 3 steps with 9 images