Calculate the the percentage of ADD/ADHD children who are on medication for their ADHD who need substance abuse treatment or counseling

Based on the attached spreadsheet I filtered what was requested to answer the following questions below:
1 which represents “Yes”, 0 which represents “No”
  • Calculate the the percentage of ADD/ADHD children who are on medication for their ADHD who need substance abuse treatment or counseling
  • Calculate the percentage of ADD/ADHD who are NOT on medication for their ADHD who need substance abuse treatment or counseling
  • Produce a data visualization in Excel that helps summarize what you found
  • Describe if you think there is a causal relationship between ADD/ADHD counseling and substance abuse.  Could it just be that children who take medication for ADD/ADHD are older, and therefore more likely to need substance abuse treatment or counseling?  Can you use the data to investigate that possibility),  you could calculate the correlation instead using the =CORREL() function
Type of paper Academic level Subject area
Number of pages Paper urgency Cost per page:
 Total: