1. Create a frequency and relative frequency distribution for each quantitative variable. Create a histogram and a pie graph for each quantitative variable. Which class has the largest frequency for each variable? Which class has the smallest frequency smallest frequency? Around which values does the data tend to cluster? To answer these questions, use the exercises shown in the online lecture. Specifically, perform these calculations by writing formulas in excel.
2. Create a frequency polygon for the quantitative variables. What is the mean, median and mode for each quantitative variable? Is the data skewed? If so, is the skewness positive or negative? What is the skewness coefficient?
3. What is the data minimum, maximum and median for your quantitative data? Create a boxplot to display those values. What is the interquartile range of the data, are there any outliers?
4. Create a table in Microsoft Excel illustrating how one would find standard deviation in stepwise fashion. You will need to understand the formula to do this.
5. Create a scatter plot between the profit variable and age variables. Is there a direct or indirect relationship between the two variables? What is the correlation coefficient?
6. About 95% of the data fall between what two values for the quantitative variables? About 70% of the data fall between what two values for the quantitative variables? Explain which rule (Empirical or Chebychev) you used to calculate this outcome and why. What does this say about how the data varies about the mean?
7. Create a frequency and relative frequency table for each qualitative variable. Be sure to create bar graph and pie chart for each variable. Which category has the largest frequency for each variable? Which category has the smallest frequency smallest frequency? Around which categories does the data tend to cluster? To answer these questions, use the exercises shown in the online lecture. Specifically, perform these calculations by writing formulas in excel.
8. Based on the descriptive statistics, what useful advice can you give?
Buyer’s Age | Profit | Location | Vehicle-Type | Previously Owned (Yes=1) |
21 | 1387 | Tionesta | Sedan | 0 |
23 | 1754 | Sheffield | SUV | 1 |
24 | 1817 | Sheffield | Hybrid | 1 |
25 | 1040 | Sheffield | Compact | 0 |
26 | 1273 | Kane | Sedan | 1 |
27 | 1529 | Sheffield | Sedan | 1 |
27 | 3082 | Kane | Truck | 0 |
28 | 1951 | Kane | SUV | 1 |
28 | 2692 | Tionesta | Compact | 0 |
29 | 1342 | Kane | Sedan | 2 |
29 | 1206 | Sheffield | Sedan | 0 |
30 | 443 | Kane | Sedan | 3 |
30 | 1621 | Sheffield | Truck | 1 |
30 | 754 | Olean | Sedan | 2 |
31 | 1174 | Kane | Truck | 0 |
31 | 2415 | Kane | Sedan | 0 |
31 | 1412 | Sheffield | Sedan | 1 |
31 | 870 | Tionesta | Sedan | 1 |
31 | 1809 | Tionesta | Sedan | 1 |
32 | 2207 | Sheffield | Compact | 0 |
32 | 1546 | Sheffield | Truck | 3 |
32 | 2252 | Tionesta | SUV | 0 |
32 | 2148 | Tionesta | SUV | 2 |
33 | 1889 | Olean | SUV | 1 |
33 | 1428 | Kane | SUV | 2 |
34 | 1320 | Tionesta | Sedan | 1 |
34 | 1166 | Olean | Sedan | 1 |
34 | 2265 | Olean | Sedan | 0 |
35 | 1919 | Tionesta | SUV | 1 |
35 | 1323 | Olean | Sedan | 2 |
35 | 1761 | Kane | Sedan | 1 |
36 | 2357 | Kane | SUV | 2 |
36 | 2866 | Kane | Sedan | 1 |
37 | 1464 | Olean | Sedan | 3 |
37 | 1761 | Olean | SUV | 1 |
37 | 1626 | Tionesta | Compact | 4 |
37 | 1915 | Tionesta | SUV | 2 |
37 | 2119 | Kane | Hybrid | 1 |
37 | 732 | Olean | SUV | 1 |
38 | 1766 | Sheffield | SUV | 0 |
38 | 2201 | Sheffield | Hybrid | 2 |
39 | 2813 | Tionesta | SUV | 0 |
39 | 996 | Kane | Compact | 2 |
40 | 1961 | Sheffield | Sedan | 1 |
40 | 1509 | Kane | SUV | 2 |
40 | 2430 | Tionesta | Sedan | 1 |
40 | 1144 | Tionesta | Truck | 0 |
40 | 323 | Kane | Sedan | 0 |
40 | 1638 | Sheffield | Sedan | 0 |
40 | 1485 | Sheffield | Compact | 0 |
40 | 352 | Sheffield | Compact | 0 |
40 | 482 | Olean | Sedan | 1 |
40 | 2127 | Olean | Truck | 0 |
41 | 2389 | Kane | Truck | 1 |
41 | 2165 | Tionesta | SUV | 0 |
41 | 1876 | Kane | Sedan | 2 |
41 | 2231 | Tionesta | SUV | 2 |
41 | 2010 | Tionesta | Sedan | 1 |
41 | 1704 | Sheffield | Sedan | 1 |
42 | 1553 | Tionesta | Compact | 0 |
42 | 963 | Kane | Sedan | 0 |
42 | 1298 | Tionesta | Sedan | 1 |
42 | 2071 | Kane | SUV | 0 |
42 | 335 | Olean | SUV | 1 |
42 | 2116 | Kane | Compact | 2 |
42 | 1410 | Kane | SUV | 2 |
42 | 1648 | Olean | SUV | 0 |
43 | 1500 | Tionesta | Sedan | 0 |
43 | 2348 | Tionesta | Sedan | 0 |
43 | 2498 | Tionesta | SUV | 1 |
43 | 1549 | Kane | SUV | 2 |
44 | 1532 | Tionesta | SUV | 3 |
44 | 1897 | Sheffield | Compact | 0 |
44 | 294 | Kane | SUV | 1 |
44 | 1115 | Kane | Truck | 0 |
44 | 2445 | Kane | SUV | 0 |
44 | 1822 | Kane | SUV | 0 |
44 | 1124 | Tionesta | Compact | 2 |
44 | 1688 | Kane | Sedan | 4 |
44 | 2886 | Olean | SUV | 1 |
45 | 1266 | Olean | Sedan | 0 |
45 | 1932 | Tionesta | Sedan | 1 |
45 | 2422 | Kane | Sedan | 1 |
45 | 820 | Kane | Compact | 1 |
45 | 1772 | Olean | Compact | 1 |
45 | 2350 | Sheffield | Compact | 0 |
45 | 2446 | Olean | Compact | 1 |
45 | 1741 | Olean | Compact | 2 |
46 | 369 | Olean | Sedan | 1 |
46 | 1238 | Sheffield | Compact | 1 |
46 | 1818 | Kane | SUV | 0 |
46 | 1907 | Olean | Sedan | 0 |
46 | 1940 | Kane | Truck | 3 |
46 | 1938 | Kane | Sedan | 0 |
46 | 978 | Kane | Sedan | 1 |
46 | 2646 | Tionesta | Sedan | 2 |
46 | 1824 | Olean | Truck | 0 |
46 | 2197 | Sheffield | Sedan | 1 |
47 | 1461 | Kane | Sedan | 0 |
47 | 1731 | Tionesta | Compact | 0 |
47 | 3292 | Olean | Sedan | 2 |
47 | 2230 | Tionesta | Sedan | 1 |
47 | 2341 | Sheffield | SUV | 1 |
48 | 1952 | Tionesta | Compact | 1 |
48 | 2070 | Kane | SUV | 1 |
48 | 1344 | Sheffield | SUV | 0 |
48 | 1295 | Sheffield | SUV | 1 |
48 | 1108 | Sheffield | Sedan | 1 |
48 | 1906 | Kane | Sedan | 1 |
48 | 2454 | Kane | Sedan | 1 |
49 | 1827 | Tionesta | Truck | 3 |
49 | 1680 | Kane | SUV | 3 |
49 | 1915 | Tionesta | SUV | 1 |
49 | 2084 | Tionesta | Sedan | 0 |
49 | 1606 | Olean | Compact | 0 |
49 | 2639 | Sheffield | SUV | 0 |
50 | 3043 | Kane | Sedan | 0 |
50 | 2059 | Sheffield | Sedan | 1 |
50 | 1963 | Sheffield | Sedan | 1 |
50 | 842 | Kane | SUV | 0 |
50 | 2338 | Tionesta | SUV | 0 |
51 | 1674 | Sheffield | Sedan | 1 |
51 | 1059 | Kane | SUV | 1 |
51 | 1807 | Tionesta | Sedan | 1 |
51 | 2928 | Kane | SUV | 0 |
51 | 2056 | Sheffield | Hybrid | 0 |
51 | 2236 | Tionesta | SUV | 2 |
52 | 1269 | Tionesta | Sedan | 1 |
52 | 1797 | Kane | Sedan | 1 |
52 | 1955 | Olean | Hybrid | 2 |
52 | 1717 | Sheffield | SUV | 3 |
52 | 2701 | Sheffield | SUV | 0 |
52 | 2482 | Olean | Compact | 0 |
52 | 2199 | Tionesta | SUV | 0 |
52 | 3210 | Olean | Truck | 4 |
53 | 1220 | Olean | Sedan | 0 |
53 | 1401 | Tionesta | Sedan | 2 |
53 | 377 | Olean | SUV | 1 |
53 | 2175 | Olean | Sedan | 1 |
54 | 2991 | Tionesta | Sedan | 0 |
54 | 1118 | Sheffield | Compact | 1 |
54 | 2666 | Tionesta | Truck | 0 |
54 | 2584 | Olean | Compact | 2 |
55 | 2063 | Kane | SUV | 1 |
55 | 2083 | Sheffield | Sedan | 1 |
55 | 2856 | Olean | Hybrid | 1 |
55 | 934 | Sheffield | Truck | 1 |
55 | 2989 | Tionesta | Compact | 1 |
56 | 2695 | Kane | Sedan | 2 |
56 | 1957 | Sheffield | SUV | 1 |
56 | 1536 | Kane | Sedan | 0 |
56 | 2240 | Olean | Sedan | 0 |
56 | 910 | Sheffield | SUV | 0 |
57 | 1325 | Olean | Sedan | 1 |
57 | 2250 | Sheffield | Sedan | 2 |
57 | 2626 | Sheffield | Sedan | 2 |
57 | 2279 | Sheffield | Hybrid | 1 |
58 | 2058 | Kane | SUV | 1 |
58 | 1752 | Kane | Sedan | 3 |
58 | 2637 | Sheffield | SUV | 1 |
58 | 1501 | Sheffield | Hybrid | 1 |
58 | 2370 | Tionesta | Compact | 0 |
59 | 1426 | Sheffield | Sedan | 0 |
59 | 2944 | Olean | SUV | 2 |
60 | 2147 | Olean | Sedan | 2 |
61 | 1973 | Kane | SUV | 3 |
61 | 2502 | Olean | Sedan | 0 |
62 | 783 | Sheffield | Hybrid | 1 |
62 | 1538 | Olean | Truck | 1 |
63 | 2339 | Olean | Compact | 1 |
64 | 2700 | Kane | Truck | 0 |
65 | 2597 | Sheffield | Truck | 0 |
65 | 2222 | Kane | Truck | 1 |
65 | 2742 | Tionesta | SUV | 2 |
68 | 1837 | Sheffield | Sedan | 1 |
69 | 2842 | Kane | SUV | 0 |
70 | 2434 | Olean | Sedan | 4 |
72 | 1640 | Olean | Sedan | 1 |
72 | 1821 | Tionesta | SUV | 1 |
73 | 2487 | Olean | Compact | 4 |