Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Derivatives And Risk Management

Authors: Robert Brooks, Don M Chance, Roberts Brooks

8th Edition

0324601212, 9780324601213

More Books

Students also viewed these Finance questions

Question

How does your message use nonverbal communication?

Answered: 1 week ago

Question

What reactive strategies might you develop?

Answered: 1 week ago