EXCEL

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)