Descriptive statistics [40%]

2.1.

Categorical variables

[20%]

2.1.1. Consider each of the categorical variables and create a frequency table including

frequency, relative frequency, cumulative frequency and relative cumulative frequency.

Provide a summative interpretation of the values in the frequency table. What is the

most frequent category and the least frequent ones with their percentages?

Report any invalid values or errors in the data and explain how to correct them.

Correct the errors in the data and show the frequency table for each categorical variable

after the corrections.

2.1.2. Create a pivot table with one categorical variable selected in the ROWS, one numerical

variable in the COLUMNS (apply grouping), and the average of the target variable in the

VALUES. When a column contains a missing value, it is represented with '?', grouping does

not work. You will have to replace those missing values with the mean, save the worksheet

and recreate the pivot table