Simon Recently Completed the Third Year of His Four-Year College

Essay

Simon recently completed the third year of his four-year college and is trying to decide what he would like to do after graduation. Simon decided to pursue a one-year graduate degree in Accounting with a minor in Finance. Simon also accepted an internship for the coming summer at a local accounting firm where he is hoping to gain insight into what his life would look like if he went into an accounting-specific position after 4th year. Simon's grades and GPA for the first three years of his college look as follows: In order to be accepted into the graduate program, Simon needs a minimum GPA of 3.5. He believes he would be offered a starting salary of $48,000 if he went straight into working as opposed to attending graduate school. After graduate school, he expects a starting salary of $58,000, assuming he does complete his graduation. With all of this in mind, please help Simon evaluate his past three year's performances by answering the following questions.
a. Use Excel to calculate the following totals for Simon's GPA: Average, Median, and Mode. What does each of these figures tell you?
b. Based on data calculated in part a), is Simon's GPA on track for what will be needed to get into graduate school? Is there any additional advice to give Simon about his senior year?
c. Simon would like to know how many As he has earned compared to Bs and Cs. Create a Count Data chart that summarizes this data.
d. Using Excel, create a graph that displays the information you collected in part c). Why did you select the graph you did, and why is it the best way to represent this data?
e. Assume Simon's GPA is sufficient and does not change much. He is accepted into a graduate program, so how many years would it take him after entering his profession to make up the lost year of income from extending his time in school? Please ignore inflation, and please explain how you arrived at your answer.