Q7. Descriptive Statistics of Quantitative Data (measured on Ratio scale) In a s
ID: 3266822 • Letter: Q
Question
Q7. Descriptive Statistics of Quantitative Data (measured on Ratio scale)
In a sample survey of 40 units selected randomly from a population, the following information were collected from each unit about two variables X and Y.
Use the data given in the table below and the Data Analysis Option on Excel 2010 or later to obtain
the 18 descriptive statistics (Mean, Standard Error, Median, Mode, ….. MAD, IQR ) of both variables X and Y .
Table Data on X and Y collected from a sample of 40 units selected randomly from a population.
ID
X
Y
1
31
155
2
39
108
3
44
86
4
48
72
5
51
63
6
54
56
7
57
50
8
59
45
9
61
41
10
63
38
11
65
35
12
67
32
13
69
30
14
70
28
15
72
26
16
74
24
17
75
22
18
77
21
19
78
19
20
80
18
21
82
17
22
83
16
23
85
15
24
86
14
25
88
13
26
90
12
27
91
11
28
93
10
29
95
9
30
97
8
31
99
8
32
101
7
33
103
6
34
106
5
35
109
5
36
112
4
37
116
3
38
121
2
39
129
1
40
138
1
Note: Copy the data for the two variables into an excel file and follow the instructions given in the word file (Descriptive Statistics using Excel) on Week 2 of Moodle and the example (Descriptive Statistics using Excel example) in the same place. After you find the required statistics in excel copy them and paste your answer below.
Answer:
ID
X
Y
1
31
155
2
39
108
3
44
86
4
48
72
5
51
63
6
54
56
7
57
50
8
59
45
9
61
41
10
63
38
11
65
35
12
67
32
13
69
30
14
70
28
15
72
26
16
74
24
17
75
22
18
77
21
19
78
19
20
80
18
21
82
17
22
83
16
23
85
15
24
86
14
25
88
13
26
90
12
27
91
11
28
93
10
29
95
9
30
97
8
31
99
8
32
101
7
33
103
6
34
106
5
35
109
5
36
112
4
37
116
3
38
121
2
39
129
1
40
138
1
Explanation / Answer
Solution:
Discriptive Statistic of Variable X Discriptive Statistic of Variable Y Mean 81.45 Mean 28.4 Standard Error 3.911185472 Standard Error 5.027590543 Median 81 Median 17.5 Mode #N/A Mode 8 Standard Deviation 24.73650888 Standard Deviation 31.79727452 Sample Variance 611.8948718 Sample Variance 1011.066667 Kurtosis -0.285915392 Kurtosis 6.070200424 Skewness 0.162594597 Skewness 2.262807041 Range 107 Range 154 Minimum 31 Minimum 1 Maximum 138 Maximum 155 Sum 3258 Sum 1136 Count 40 Count 40 Largest(1) 138 Largest(1) 155 Smallest(1) 31 Smallest(1) 1 Confidence Level(95.0%) 7.91111934 Confidence Level(95.0%) 10.16926174 1st Quartile 63.5 1st Quartile 8 2nd Quartile 81 2nd Quartile 17.5 3rd Quartile 98.5 3rd Quartile 37.25 IQR 35 IQR 29.25 Quartile devation (Q.D) 17.5 Quartile devation (Q.D) 14.625 Interquartile (I.Q) 35 Interquartile (I.Q) 29.25 MAD 39.5 MAD 44.18Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.