b. Numerical variables
2.b.1. Provide a table with the list of all numerical variables, their min, max,
average, Q1, Q2 and Q3 and Q4. Provide an interpretation of the quartiles.
2.b.2. Create a histogram for one numerical variable. What is the shape of the
distribution? Interpret? If it is right or left skewed, relate this to a meaningful
sentence explaining what most range most of the values fall in. If it is a normal
distribution, use the empirical rule to report the percentage of data points and
associated range of values.
2.b.3. Create a box plot for two numerical variables. You may try many
numerical variables and keep only the one that exhibits outliers. Interpret the
results (how is the variability of the distribution (high/low), are there outliers?
3. Data Visualization
Use PowerBI to create a dashboard showing the following elements:
a. show one pie chart for one categorical variable.
b. Show a scatter chart between two numerical variables. The target variable should
show on the y-axis.
c. Show a pivot table between one numerical variable (target var) and one categorical
variable.
