7 Stat101 questions to be solved on excel

Description

1 attachments

Slide 1 of 1

attachment_1

attachment_1

Unformatted Attachment Preview

A data has been collected through a survey for 50 people
about their wage rates , Education, Eperience and age.Values
are repoted below. Answer the following Questions
1: How many variables are used in data set
2: Is it a time series or Crossectional Data
3:Is it an ordinal data
DATA SET
obs
1
2
3
4
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
31
32
Wage Rate Education Experince
11.55
5.00
12.00
7.00
21.15
6.92
10.00
8.00
15.63
18.22
20.00
4.35
5.00
8.25
15.00
19.00
18.00
7.07
8.00
25.00
17.30
16.00
5.00
8.25
8.00
13.69
19.90
22.00
6.50
12.00
13.39
36.85
12
9
16
14
16
12
12
12
18
18
20
12
5
12
12
14
14
16
14
14
12
12
12
12
12
12
12
12
12
12
12
20
20
9
15
38
19
4
14
32
7
5
31
7
31
14
15
26
23
4
16
27
44
38
19
13
14
20
26
17
1
19
34
21
Age
38
24
37
58
41
22
32
50
31
29
57
25
42
32
33
46
43
26
36
47
62
56
37
31
32
38
44
35
19
37
52
47
33
34
35
36
37
38
39
40
27.47
6.00
21.54
12.43
19.70
7.50
25.95
25.95
16
12
18
12
12
12
18
16
25
2
19
7
33
11
12
13
47
20
43
25
51
29
36
35
Answers
DATA SET
obs
Wage Rate Education Experince
Age
1
11.55
12
20
38
2
5.00
9
9
24
3
4
5
6
7
8
9
12.00
7.00
21.15
6.92
10.00
8.00
15.63
16
14
16
12
12
12
18
15
38
19
4
14
32
7
37
58
41
22
32
50
31
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
18.22
20.00
4.35
5.00
8.25
15.00
19.00
18.00
7.07
8.00
25.00
17.30
16.00
5.00
8.25
8.00
13.69
19.90
22.00
6.50
12.00
13.39
36.85
27.47
6.00
21.54
12.43
19.70
7.50
25.95
25.95
18
20
12
5
12
12
14
14
16
14
14
12
12
12
12
12
12
12
12
12
12
12
20
16
12
18
12
12
12
18
16
5
31
7
31
14
15
26
23
4
16
27
44
38
19
13
14
20
26
17
1
19
34
21
25
2
19
7
33
11
12
13
29
57
25
42
32
33
46
43
26
36
47
62
56
37
31
32
38
44
35
19
37
52
47
47
20
43
25
51
29
36
35
Mean =
What are the average,median and mode
wage rates.
Median =
Mode =
Are the wage rates Normaly distibuted? If not eplain the
distribution
Answers
DATA SET
Draw the Box and Whisker
“Eperien
obs
Wage Rate Education Experince
Age
1
11.55
12
20
38
2
3
4
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
31
32
33
34
35
36
37
38
39
40
5.00
12.00
7.00
21.15
6.92
10.00
8.00
15.63
18.22
20.00
4.35
5.00
8.25
15.00
19.00
18.00
7.07
8.00
25.00
17.30
16.00
5.00
8.25
8.00
13.69
19.90
22.00
6.50
12.00
13.39
36.85
27.47
6.00
21.54
12.43
19.70
7.50
25.95
25.95
9
16
14
16
12
12
12
18
18
20
12
5
12
12
14
14
16
14
14
12
12
12
12
12
12
12
12
12
12
12
20
16
12
18
12
12
12
18
16
9
15
38
19
4
14
32
7
5
31
7
31
14
15
26
23
4
16
27
44
38
19
13
14
20
26
17
1
19
34
21
25
2
19
7
33
11
12
13
24
37
58
41
22
32
50
31
29
57
25
42
32
33
46
43
26
36
47
62
56
37
31
32
38
44
35
19
37
52
47
47
20
43
25
51
29
36
35
Draw the Box and Whisker plot For the variable
“Eperience”.
DATA SET
Which variable has mor
obs
1
2
3
4
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
31
32
33
34
35
36
37
38
39
40
Wage Rate Education Experince
11.55
5.00
12.00
7.00
21.15
6.92
10.00
8.00
15.63
18.22
20.00
4.35
5.00
8.25
15.00
19.00
18.00
7.07
8.00
25.00
17.30
16.00
5.00
8.25
8.00
13.69
19.90
22.00
6.50
12.00
13.39
36.85
27.47
6.00
21.54
12.43
19.70
7.50
25.95
25.95
12
9
16
14
16
12
12
12
18
18
20
12
5
12
12
14
14
16
14
14
12
12
12
12
12
12
12
12
12
12
12
20
16
12
18
12
12
12
18
16
20
9
15
38
19
4
14
32
7
5
31
7
31
14
15
26
23
4
16
27
44
38
19
13
14
20
26
17
1
19
34
21
25
2
19
7
33
11
12
13
Age
38
24
37
58
41
22
32
50
31
29
57
25
42
32
33
46
43
26
36
47
62
56
37
31
32
38
44
35
19
37
52
47
47
20
43
25
51
29
36
35
Which variable has more variability?
DATA SET
Draw a scattar digram between Ag
Eperience, Is their any relationship
variables?
obs
1
2
3
4
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
31
32
33
34
35
36
37
Wage Rate Education Experince
11.55
5.00
12.00
7.00
21.15
6.92
10.00
8.00
15.63
18.22
20.00
4.35
5.00
8.25
15.00
19.00
18.00
7.07
8.00
25.00
17.30
16.00
5.00
8.25
8.00
13.69
19.90
22.00
6.50
12.00
13.39
36.85
27.47
6.00
21.54
12.43
19.70
12
9
16
14
16
12
12
12
18
18
20
12
5
12
12
14
14
16
14
14
12
12
12
12
12
12
12
12
12
12
12
20
16
12
18
12
12
20
9
15
38
19
4
14
32
7
5
31
7
31
14
15
26
23
4
16
27
44
38
19
13
14
20
26
17
1
19
34
21
25
2
19
7
33
Age
38
24
37
58
41
22
32
50
31
29
57
25
42
32
33
46
43
26
36
47
62
56
37
31
32
38
44
35
19
37
52
47
47
20
43
25
51
38
39
40
7.50
25.95
25.95
12
18
16
11
12
13
29
36
35
raw a scattar digram between Age(Independent variable) and
perience, Is their any relationship exits between two
ariables?
Draw a stem and leaf Diagram
DATA SET
obs
1
2
3
4
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
31
32
33
34
35
36
37
38
39
40
Wage Rate Education Experince
11.55
5.00
12.00
7.00
21.15
6.92
10.00
8.00
15.63
18.22
20.00
4.35
5.00
8.25
15.00
19.00
18.00
7.07
8.00
25.00
17.30
16.00
5.00
8.25
8.00
13.69
19.90
22.00
6.50
12.00
13.39
36.85
27.47
6.00
21.54
12.43
19.70
7.50
25.95
25.95
12
9
16
14
16
12
12
12
18
18
20
12
5
12
12
14
14
16
14
14
12
12
12
12
12
12
12
12
12
12
12
20
16
12
18
12
12
12
18
16
20
9
15
38
19
4
14
32
7
5
31
7
31
14
15
26
23
4
16
27
44
38
19
13
14
20
26
17
1
19
34
21
25
2
19
7
33
11
12
13
Age
38
24
37
58
41
22
32
50
31
29
57
25
42
32
33
46
43
26
36
47
62
56
37
31
32
38
44
35
19
37
52
47
47
20
43
25
51
29
36
35
raw a stem and leaf Diagram for variable” Age’
Draw a freuency Distributio
Experience and then draw H
DATA SET
obs Wage Rate Education Experince Age
1
2
3
4
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
31
32
33
34
35
36
37
38
39
11.55
5.00
12.00
7.00
21.15
6.92
10.00
8.00
15.63
18.22
20.00
4.35
5.00
8.25
15.00
19.00
18.00
7.07
8.00
25.00
17.30
16.00
5.00
8.25
8.00
13.69
19.90
22.00
6.50
12.00
13.39
36.85
27.47
6.00
21.54
12.43
19.70
7.50
25.95
12
9
16
14
16
12
12
12
18
18
20
12
5
12
12
14
14
16
14
14
12
12
12
12
12
12
12
12
12
12
12
20
16
12
18
12
12
12
18
20
9
15
38
19
4
14
32
7
5
31
7
31
14
15
26
23
4
16
27
44
38
19
13
14
20
26
17
1
19
34
21
25
2
19
7
33
11
12
38
24
37
58
41
22
32
50
31
29
57
25
42
32
33
46
43
26
36
47
62
56
37
31
32
38
44
35
19
37
52
47
47
20
43
25
51
29
36
40
25.95
16
13
35
raw a freuency Distribution Table for the Variable
xperience and then draw Histogram for that table.

Purchase answer to see full
attachment

User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.



^{Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."}