Specifically, you must address the following rubric criteria:

Create an accurate line chart for Edgards course GPA with all 16 data points. Include the following detail in your response:

Create an accurate column chart for the total number of each grade earned for Edgard. Include the following detail in your response:

Calculate each outcome accurately using Excel functions. Include the following details in your response:

Overall GPA for three semesters

Median (midpoint) of Edgards GPA

Mode (most frequently occurring) of the course GPA earned

\begin{tabular}{|l|l|c|c|} \hline Year/Semester & \multicolumn{1}{|c|}{ Course } & Grade Earned & GPA \\ \hline Year 2 Fall & ACCT 201 & A & 4 \\ \hline Year 2 Fall & ACCT 202 & A & 4 \\ \hline Year 2 Fall & MGMT 229 & B & 3 \\ \hline Year 2 Fall & MGMT 255 & A & 4 \\ \hline Year 2 Fall & COMM 195 & B & 3 \\ \hline Year 2 Spring & ACCT 301 & C & 2 \\ \hline Year 2 Spring & ACCT 302 & A & 4 \\ \hline Year 2 Spring & FIN 275 & B & 3 \\ \hline Year 2 Spring & ECON 210 & B & 3 \\ \hline Year 2 Spring & STAT 205 & A & 4 \\ \hline Year 3 Fall & MGMT 300 & A & 4 \\ \hline Year 3 Fall & MKTG 300 & B & 3 \\ \hline Year 3 Fall & FIN 290 & C & 2 \\ \hline Year 3 Fall & ACCT 310 & B & 3 \\ \hline Year 3 Fall & INSY 280 & A & 4 \\ \hline \end{tabular}