customer sales dataset- HW 1

MCOM 160 – Homework 1

(customer sales dataset)

Due – 09/19/2021 11:59 PM

1. Plot the frequency distribution for “Age group” & “Total number with BAC”

(10)

2. Plot a histogram for “Prevalence of binge drinking percentage” variable. (10)

3. Identify outliers in “Cost per drink” variable using a visual method. (10)

4. Is there a correlation between “prevalence of binge drinking” and “fatalities

with BAC”? What is the correlation value and the linear equation representing

the relationship? (20)

5. Create a dashboard similar to the one shown below with a synchronized state

slider. You can customize the charts and text as you please. (50)