Preview the Edt Viewe Tools Who T Sat SM O HARE Data Analysis One of the following analysis tasks will be present on the final exam. You should be prepared for all tasks. Only one task will appear, there will not be a choice. A solution to these tasks is not provided as solutions will vary by students. Refer to CLA 16 (and the corresponding sample solution) as an example #1:Provide an analysis and summary that compares the percentage of courses taken by males that are technical courses with the percentage of courses taken by females that are technical courses. This comparison should show the trend across all semesters in the database. To correctly calculate the percentages, it is necessary to determine the number of courses taken by males in cach semester and use this to determine the percentage of courses taken by males that are technical in each semester. The same calculations must then be performed for the female students #2: Provide an analysis and summary that compares the average credit hour load taken by students from the states of OHIN and those not from OH or IN. This comparison should show the trend across all semesters in the database. To correctly determine the average, it will be necessary to determine the total number of credits taken by each OH/IN & Non-OHIN student in each semester, and then calculate an average across all OHIN students and the average across all Non-OHIN students for each semester #3: Provide an analysis and summary that compares the overall grade point average by entry year of ACC major vs MIS majors for entry years of 2003, 2004, 2005, 2006, 2007, 2008 and 2009. For this analysis it will be necessary to determine the total number of credits accumulated for each entry year and the total number of Grade Points accumulated for each entry year. Grade Points is the calculation of the point value for a grade multiplied times the number of credits for the course. The point values for grades are: A-4B-3,0-2:-1,F0 Analysis Instructions 96 5 3 4 B 6 7 Preview the Edt Viewe Tools Who T Sat SM O HARE Data Analysis One of the following analysis tasks will be present on the final exam. You should be prepared for all tasks. Only one task will appear, there will not be a choice. A solution to these tasks is not provided as solutions will vary by students. Refer to CLA 16 (and the corresponding sample solution) as an example #1:Provide an analysis and summary that compares the percentage of courses taken by males that are technical courses with the percentage of courses taken by females that are technical courses. This comparison should show the trend across all semesters in the database. To correctly calculate the percentages, it is necessary to determine the number of courses taken by males in cach semester and use this to determine the percentage of courses taken by males that are technical in each semester. The same calculations must then be performed for the female students #2: Provide an analysis and summary that compares the average credit hour load taken by students from the states of OHIN and those not from OH or IN. This comparison should show the trend across all semesters in the database. To correctly determine the average, it will be necessary to determine the total number of credits taken by each OH/IN & Non-OHIN student in each semester, and then calculate an average across all OHIN students and the average across all Non-OHIN students for each semester #3: Provide an analysis and summary that compares the overall grade point average by entry year of ACC major vs MIS majors for entry years of 2003, 2004, 2005, 2006, 2007, 2008 and 2009. For this analysis it will be necessary to determine the total number of credits accumulated for each entry year and the total number of Grade Points accumulated for each entry year. Grade Points is the calculation of the point value for a grade multiplied times the number of credits for the course. The point values for grades are: A-4B-3,0-2:-1,F0 Analysis Instructions 96 5 3 4 B 6 7