2957-Applied Business Analytics-2425_S2

This 45-minute collaborative activity is designed for students to work in pairs to solve the following problem.

•  Jupyter Notebook Development (45 minutes) Students will develop a Jupyter Notebook to solve a more complex problem. The task involves writing and executing code, analyzing the results, and documenting their approach. The completed notebook must be submitted at the end of the session. This activity encourages teamwork, critical thinking, and hands-on coding experience.

The file households.xlsx contains data from a survey of 500 randomly selected households. The list of variables is the following:

1. Indicate the type of data for each of the variables included in the survey.
2. For each of the categorical variables in the survey, indicate whether the variable is nominal or ordinal, and why. 
3. Create a bar plot for location variable with the frequency in the y-axis.
4. Create a pie chart with the relative frequencies of variable Ownership.
5. Create a histogram for each of the numeric variables in this data set. Indicate whether each of these distributions is approximately symmetric or skewed (to the right or to the left)?
6. Find the maximum and minimum debt levels for the households in this sample.
7. Find the indebtedness levels at each of the 25th, 50th, and 75th percentiles.
8. Find and interpret the interquartile range for the indebtedness levels of these households.
9. For the nominal variables in the dataset, replace each of them with dummy variables.
10. The variable “Second Income” as several missing values, the reason is because there is no second income in that household. Therefore, instead of NA it should be 0. Replace all missing values in that column by 0. 
11. Using the MinMaxScaler, normalize the numerical variables.