MATH 110 Homework #2 Percentages (35 points HW + 5 Data Project) Open the HW 2 excel file. Do all calculations for the questions #1-7 below in the file in the cell next to the question number. Save the file and attach in Homework submission along with this document with your answers as well as your Data Analysis Project updated file (this will be the excel file for either Homicide, Voting 2020, or Drug deaths). Put all answers here in complete sentences with context and correct interpretation following 8. Your Data Analysis Project Data [5 pts] Open your Data Analysis Project topic excel file (saved from HW 1: this is either Homicide, Drug Death, or Voting 2020) and investigate the data. a. Go to the page in the file that lists years and either number, percent, or rate. Calculate the overall percent change from the first year given to the last in that data set. Put answer in complete sentence with context and correct interpretation. The first years percent change that was in 1999 was 3% and in 2019 the percent change was 447%. b. Go to a different page in the file. Calculate the ratio of the highest value and the lowest value from that data set. Interpret answer in complete sentence with context and correct interpretation. The lowest value will be in 1999 with 0.3 of ratio with the lowest and the highest will be 2014 with a ratio of 1.1 with the highest value. Save your updated project data excel file and attach it with this homework when you submit.
