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)
     



Source link