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 Cars 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.