Excel
SOLUTION: Answer questions based on a some given data
SOLUTION: Answer questions based on a some given data.
Homework 1
June 28, 2019
Due Monday July 1st.
Information about mtcars data:
1. mile per gallon-mpg
2. cyl-cylinders
3. disp-displacement
4. hp-horsepower
5. drat-rear axel ratio
6. wt-weight 1000 lbs
7. qsec-1/4 mile time
8. vs-engine (0- V-shaped,1 = straight)
9. am-transmission
10. gear-number of forward gears
11. carb-number of carbuerators
Questions
1. Describe the data in the dataset mtcars labeling each column as either Categorical, Numerical, or
Ordinal.
2. Form a frequency table for the column cyl.
3. Form a relative frequency table from the previous question.
4. Find the 3rd, 5th, and 7th percentiles of qsec.
5. Form two boxplots, one on V-shaped engines and the other on straight comparing quartiles of 1/4 mile
times.
6. Plot horsepower vs. 1/4 mile times and also wt vs 1/4 mile times.
7. Compute the descriptive statistics of car weight. Descriptive statistics include mean, quartiles, min,
max and standard deviation.
8. Standardize the dataset’s numerical variables (mpg, disp, hp, drat, wt, qsec) and write down the first
three values of each variable to prove you did it correctly.
9. Form a histogram of displacement and describe its distribution (symmetry and appearance of modes).
10. If you wanted as fast a car as possible how would you design it?
1
mpg
cyl
21
21
22.8
21.4
18.7
18.1
14.3
24.4
22.8
19.2
17.8
16.4
17.3
15.2
10.4
10.4
14.7
32.4
30.4
33.9
21.5
15.5
15.2
13.3
19.2
27.3
26
30.4
15.8
19.7
15
21.4
disp
6
6
4
6
8
6
8
4
4
6
6
8
8
8
8
8
8
4
4
4
4
8
8
8
8
4
4
4
8
6
8
4
hp
160
160
108
258
360
225
360
146.7
140.8
167.6
167.6
275.8
275.8
275.8
472
460
440
78.7
75.7
71.1
120.1
318
304
350
400
79
120.3
95.1
351
145
301
121
drat
110
110
93
110
175
105
245
62
95
123
123
180
180
180
205
215
230
66
52
65
97
150
150
245
175
66
91
113
264
175
335
109
wt
3.9
3.9
3.85
3.08
3.15
2.76
3.21
3.69
3.92
3.92
3.92
3.07
3.07
3.07
2.93
3
3.23
4.08
4.93
4.22
3.7
2.76
3.15
3.73
3.08
4.08
4.43
3.77
4.22
3.62
3.54
4.11
qsec
2.62
2.875
2.32
3.215
3.44
3.46
3.57
3.19
3.15
3.44
3.44
4.07
3.73
3.78
5.25
5.424
5.345
2.2
1.615
1.835
2.465
3.52
3.435
3.84
3.845
1.935
2.14
1.513
3.17
2.77
3.57
2.78
vs
16.46
17.02
18.61
19.44
17.02
20.22
15.84
20
22.9
18.3
18.9
17.4
17.6
18
17.98
17.82
17.42
19.47
18.52
19.9
20.01
16.87
17.3
15.41
17.05
18.9
16.7
16.9
14.5
15.5
14.6
18.6
am
0
0
1
1
0
1
0
1
1
1
1
0
0
0
0
0
0
1
1
1
1
0
0
0
0
1
0
1
0
0
0
1
1
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
1
1
0
0
0
0
0
1
1
1
1
1
1
1
gear
carb
4
4
4
3
3
3
3
4
4
4
4
3
3
3
3
3
3
4
4
4
3
3
3
3
3
4
5
5
5
5
5
4
4
4
1
1
2
1
4
2
2
4
4
3
3
3
4
4
4
1
2
1
1
2
2
4
2
1
2
2
4
6
8
2
Purchase answer to see full
attachment
June 28, 2019
Due Monday July 1st.
Information about mtcars data:
1. mile per gallon-mpg
2. cyl-cylinders
3. disp-displacement
4. hp-horsepower
5. drat-rear axel ratio
6. wt-weight 1000 lbs
7. qsec-1/4 mile time
8. vs-engine (0- V-shaped,1 = straight)
9. am-transmission
10. gear-number of forward gears
11. carb-number of carbuerators
Questions
1. Describe the data in the dataset mtcars labeling each column as either Categorical, Numerical, or
Ordinal.
2. Form a frequency table for the column cyl.
3. Form a relative frequency table from the previous question.
4. Find the 3rd, 5th, and 7th percentiles of qsec.
5. Form two boxplots, one on V-shaped engines and the other on straight comparing quartiles of 1/4 mile
times.
6. Plot horsepower vs. 1/4 mile times and also wt vs 1/4 mile times.
7. Compute the descriptive statistics of car weight. Descriptive statistics include mean, quartiles, min,
max and standard deviation.
8. Standardize the dataset’s numerical variables (mpg, disp, hp, drat, wt, qsec) and write down the first
three values of each variable to prove you did it correctly.
9. Form a histogram of displacement and describe its distribution (symmetry and appearance of modes).
10. If you wanted as fast a car as possible how would you design it?
1
mpg
cyl
21
21
22.8
21.4
18.7
18.1
14.3
24.4
22.8
19.2
17.8
16.4
17.3
15.2
10.4
10.4
14.7
32.4
30.4
33.9
21.5
15.5
15.2
13.3
19.2
27.3
26
30.4
15.8
19.7
15
21.4
disp
6
6
4
6
8
6
8
4
4
6
6
8
8
8
8
8
8
4
4
4
4
8
8
8
8
4
4
4
8
6
8
4
hp
160
160
108
258
360
225
360
146.7
140.8
167.6
167.6
275.8
275.8
275.8
472
460
440
78.7
75.7
71.1
120.1
318
304
350
400
79
120.3
95.1
351
145
301
121
drat
110
110
93
110
175
105
245
62
95
123
123
180
180
180
205
215
230
66
52
65
97
150
150
245
175
66
91
113
264
175
335
109
wt
3.9
3.9
3.85
3.08
3.15
2.76
3.21
3.69
3.92
3.92
3.92
3.07
3.07
3.07
2.93
3
3.23
4.08
4.93
4.22
3.7
2.76
3.15
3.73
3.08
4.08
4.43
3.77
4.22
3.62
3.54
4.11
qsec
2.62
2.875
2.32
3.215
3.44
3.46
3.57
3.19
3.15
3.44
3.44
4.07
3.73
3.78
5.25
5.424
5.345
2.2
1.615
1.835
2.465
3.52
3.435
3.84
3.845
1.935
2.14
1.513
3.17
2.77
3.57
2.78
vs
16.46
17.02
18.61
19.44
17.02
20.22
15.84
20
22.9
18.3
18.9
17.4
17.6
18
17.98
17.82
17.42
19.47
18.52
19.9
20.01
16.87
17.3
15.41
17.05
18.9
16.7
16.9
14.5
15.5
14.6
18.6
am
0
0
1
1
0
1
0
1
1
1
1
0
0
0
0
0
0
1
1
1
1
0
0
0
0
1
0
1
0
0
0
1
1
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
1
1
0
0
0
0
0
1
1
1
1
1
1
1
gear
carb
4
4
4
3
3
3
3
4
4
4
4
3
3
3
3
3
3
4
4
4
3
3
3
3
3
4
5
5
5
5
5
4
4
4
1
1
2
1
4
2
2
4
4
3
3
3
4
4
4
1
2
1
1
2
2
4
2
1
2
2
4
6
8
2
Purchase answer to see full
attachment