Using Cars Data file summarize the data using Excel Descriptive Statistics. Create pie-charts for MPG on Cars’ CYL. Create a Histogram for MPG, include Normal distribution density
Week 6 Problem
Download Week 6-Cars – Data.xls
Using Cars Data file summarize the data using Excel Descriptive Statistics.
- Create pie-charts for MPG on Cars’ CYL.
- Create a Histogram for MPG, include Normal distribution density curve.
- Make a scatter plot with MPG and x-axis and Cars’ CYL on y-axis, include trend line. What can you conclude?
- Make a scatter plot with Car’s CYL on the x-axis and MPG on the y-axis, include trend line. What can you conclude?
Problem Guide:
- You will manipulate and analyze data using Excel or SPSS.
- You will copy charts, graphs, tables, from Excel or SPSS into a Word document.
- Write a report on your findings in the Word document referencing the charts, graphs, and tables from Excel or SPSS.
The original questions must be typed out as headings, with follow up answers + charts, graphs, and tables in paragraph format, and a summary or conclusion at the end of the paper. Problems have no references limit and must be in APA format.
Rubric
Problems Grading Rubric
Sheet1
MPG | CYL | ENG | WGT |
18 | 8 | 307 | 3504 |
15 | 8 | 350 | 3693 |
18 | 8 | 318 | 3436 |
16 | 8 | 304 | 3433 |
17 | 8 | 302 | 3449 |
15 | 8 | 429 | 4341 |
14 | 8 | 454 | 4354 |
14 | 8 | 440 | 4312 |
14 | 8 | 455 | 4425 |
15 | 8 | 390 | 3850 |
15 | 8 | 383 | 3563 |
14 | 8 | 340 | 3609 |
15 | 8 | 400 | 3761 |
14 | 8 | 455 | 3086 |
24 | 4 | 113 | 2372 |
22 | 6 | 198 | 2833 |
18 | 6 | 199 | 2774 |
21 | 6 | 200 | 2587 |
27 | 4 | 97 | 2130 |
26 | 4 | 97 | 1835 |
25 | 4 | 110 | 2672 |
24 | 4 | 107 | 2430 |
25 | 4 | 104 | 2375 |
26 | 4 | 121 | 2234 |
21 | 6 | 199 | 2648 |
10 | 8 | 360 | 4615 |
10 | 8 | 307 | 4376 |
11 | 8 | 318 | 4382 |
9 | 8 | 304 | 4732 |
27 | 4 | 97 | 2130 |
28 | 4 | 140 | 2264 |
25 | 4 | 113 | 2228 |
19 | 6 | 232 | 2634 |
16 | 6 | 225 | 3439 |
17 | 6 | 250 | 3329 |
19 | 6 | 250 | 3302 |
18 | 6 | 232 | 3288 |
14 | 8 | 350 | 4209 |
14 | 8 | 400 | 4464 |
14 | 8 | 351 | 4154 |
14 | 8 | 318 | 4096 |
12 | 8 | 383 | 4955 |
13 | 8 | 400 | 4746 |
13 | 8 | 400 | 5140 |
18 | 6 | 258 | 2962 |
22 | 4 | 140 | 2408 |
19 | 6 | 250 | 3282 |
18 | 6 | 250 | 3139 |
23 | 4 | 122 | 2220 |
28 | 4 | 116 | 2123 |
30 | 4 | 79 | 2074 |
30 | 4 | 88 | 2065 |
31 | 4 | 71 | 1773 |
35 | 4 | 72 | 1613 |
27 | 4 | 97 | 1834 |
26 | 4 | 91 | 1955 |
24 | 4 | 113 | 2278 |
25 | 4 | 97.5 | 2126 |
23 | 4 | 97 | 2254 |
20 | 4 | 140 | 2408 |
21 | 4 | 122 | 2226 |
13 | 8 | 350 | 4274 |
14 | 8 | 400 | 4385 |
15 | 8 | 318 | 4135 |
14 | 8 | 351 | 4129 |
17 | 8 | 304 | 3672 |
11 | 8 | 429 | 4633 |
13 | 8 | 350 | 4502 |
12 | 8 | 350 | 4456 |
13 | 8 | 400 | 4422 |
19 | 3 | 70 | 2330 |
15 | 8 | 304 | 3892 |
13 | 8 | 307 | 4098 |
13 | 8 | 302 | 4294 |
14 | 8 | 318 | 4077 |
18 | 4 | 121 | 2933 |
22 | 4 | 121 | 2511 |
21 | 4 | 120 | 2979 |
26 | 4 | 96 | 2189 |
22 | 4 | 122 | 2395 |
28 | 4 | 97 | 2288 |
23 | 4 | 120 | 2506 |
28 | 4 | 98 | 2164 |
27 | 4 | 97 | 2100 |
13 | 8 | 350 | 4100 |
14 | 8 | 304 | 3672 |
13 | 8 | 350 | 3988 |
14 | 8 | 302 | 4042 |
15 | 8 | 318 | 3777 |
12 | 8 | 429 | 4952 |
13 | 8 | 400 | 4464 |
13 | 8 | 351 | 4363 |
14 | 8 | 318 | 4237 |
13 | 8 | 440 | 4735 |
12 | 8 | 455 | 4951 |
13 | 8 | 360 | 3821 |
18 | 6 | 225 | 3121 |
16 | 6 | 250 | 3278 |
18 | 6 | 232 | 2945 |
18 | 6 | 250 | 3021 |
23 | 6 | 198 | 2904 |
26 | 4 | 97 | 1950 |
11 | 8 | 400 | 4997 |
12 | 8 | 400 | 4906 |
13 | 8 | 360 | 4654 |
12 | 8 | 350 | 4499 |
18 | 6 | 232 | 2789 |
20 | 4 | 97 | 2279 |
21 | 4 | 140 | 2401 |
22 | 4 | 108 | 2379 |
18 | 3 | 70 | 2124 |
19 | 4 | 122 | 2310 |
21 | 6 | 155 | 2472 |
26 | 4 | 98 | 2265 |
15 | 8 | 350 | 4082 |
16 | 8 | 400 | 4278 |
29 | 4 | 68 | 1867 |
24 | 4 | 116 | 2158 |
20 | 4 | 114 | 2582 |
19 | 4 | 121 | 2868 |
15 | 8 | 318 | 3399 |
24 | 4 | 121 | 2660 |
20 | 6 | 156 | 2807 |
11 | 8 | 350 | 3664 |
20 | 6 | 198 | 3102 |
19 | 6 | 232 | 2901 |
15 | 6 | 250 | 3336 |
31 | 4 | 79 | 1950 |
26 | 4 | 122 | 2451 |
32 | 4 | 71 | 1836 |
25 | 4 | 140 | 2542 |
16 | 6 | 250 | 3781 |
16 | 6 | 258 | 3632 |
18 | 6 | 225 | 3613 |
16 | 8 | 302 | 4141 |
13 | 8 | 350 | 4699 |
14 | 8 | 318 | 4457 |
14 | 8 | 302 | 4638 |
14 | 8 | 304 | 4257 |
29 | 4 | 98 | 2219 |
26 | 4 | 79 | 1963 |
26 | 4 | 97 | 2300 |
31 | 4 | 76 | 1649 |
32 | 4 | 83 | 2003 |
28 | 4 | 90 | 2125 |
24 | 4 | 90 | 2108 |
26 | 4 | 116 | 2246 |
24 | 4 | 120 | 2489 |
26 | 4 | 108 | 2391 |
31 | 4 | 79 | 2000 |
19 | 6 | 225 | 3264 |
18 | 6 | 250 | 3459 |
15 | 6 | 250 | 3432 |
15 | 6 | 250 | 3158 |
16 | 8 | 400 | 4668 |
15 | 8 | 350 | 4440 |
16 | 8 | 318 | 4498 |
14 | 8 | 351 | 4657 |
17 | 6 | 231 | 3907 |
16 | 6 | 250 | 3897 |
15 | 6 | 258 | 3730 |