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