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