Course: Business administration and data analysis.

Solve the "car evaluation dataset" in weka and excel.

1. Summary Statistics (#of observations, Mean, standard deviation, minimum, maximum)

2. Confirm if there is any missing value or error from your data.

Find a categorical attribute (2-4 categories), and draw a pie chart to describe the composition of the attribute.

*When you do not have a categorical (nominal) attribute, then you can make a new attribute.

3. Find a categorical attribute and a numerical attribute, and draw a box plot to describe the

relationship between the categorical attribute and the numerical attribute. Add your explanation.

4. Find a categorical attribute (more than 4 categories), and draw a histogram chart to describe the distribution of the attribute. Add your explanation.

5. Find one numerical attribute and divide them into 8-10 categories. Draw a histogram chart based on the categories to describe the distribution of the attribute. Add your explanation.

6. Draw a line chart from at least two numerical attributes when you consider there is similar pattern between two attributes. You can utilize two different axis units. Add your explanation.

7. Draw a scatterplot using two numerical attributes and confirm if there is any association between those attributes. Add your explanation.

8. Open the data file in Weka, and try to find any meaningful associations among attributes. (Capture the Weka screen with your group name and add it to the Excel worksheet. Explain the result.)

9. Try to select important attributes or find rankings to analyze your data using Weka's Select attributes menu. (Capture the Weka screen with your group name and add it to the Excel worksheet. Explain the result.)

10. If you have any idea to make a new attribute from the original raw data, then try to generate one.

11. Try to find any attribute that is not necessary for the analysis and explain the reason.