SNHU Edgards Course GPA Line Chart
Description
Use the Module Two Data Set to correctly customize data visualizations targeted for the scenario. This assignment uses a complete/incomplete rubric. If your data visualizations do not match the two contained within the textbook, course GPA and total number of each grade earned, rework the steps until you reach the correct data visualizations. You will also need to accurately calculate specific outcomes related to Edgardàgrades.
Specifically, you must address the following rubric criteria:
Create an accurate line chart for Edgardàcourse GPA with all 16 data points. Include the following detail in your response:
Title of chart as it is in the textbook
Create an accurate column chart for the total number of each grade earned for Edgard. Include the following detail in your response:
Title of chart as it is in the textbook
Calculate each outcome accurately using Excel functions. Include the following details in your response:
Overall GPA for three semesters
Median (midpoint) of EdgardàGPA
Mode (most frequently occurring) of the course GPA earned
Unformatted Attachment Preview
Course
Year 2 Fall
ACCT 201
Year 2 Fall
ACCT 202
Year 2 Fall
MGMT 229
Year 2 Fall
MGMT 255
Year 2 Fall
COMM 195
Year 2 Spring ACCT 301
Year 2 Spring ACCT 302
Year 2 Spring FIN 275
Year 2 Spring ECON 210
Year 2 Spring STAT 205
Year 3 Fall
MGMT 300
Year 3 Fall
MKTG 300
Year 3 Fall
FIN 290
Year 3 Fall
ACCT 310
Year 3 Fall
INSY 280
Grade Earned
A
A
B
A
B
C
A
B
B
A
A
B
C
B
A
GPA
4
4
3
4
3
2
4
3
3
4
4
3
2
3
4
Purchase answer to see full
attachment
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."