Your job is to analyze data from a recent Troy undergraduate

Your job is to analyze data from a recent Troy undergraduate statistics course. Here are some details about the course and the data file –There are 4 exams plus a Final Exam –Connect 1 – is the grade on Chapter 1 Connect homework.Connect 2 – is the grade on Chapter 2 Connect homework, and so on.Connect Grade is the combined grade on all Connect homework (total points earned divided by total points possible).iClicker is a grade that is a combination of student participation and accuracy on questions asked in classExam 1- covers Chapters 1-4, includes multiple choice and some problems that must be worked by hand (partial credit given for problems)Exam 2- covers Chapters 5-7, includes multiple choice and some problems that must be worked by hand (partial credit given for problems)Exam 3- covers Chapters 8 and 9, all problems that must be worked by hand (partial credit given for problems)Exam 4- covers Chapters 10-11, includes a few multiple choice, but mainly problems that must be worked by hand (partial credit given for problems)Final Exam- covers Chapters 1-11, 40 multiple choice with no partial credit.Your job is to analyze the data. That’s right – no real question being asked. You decide as a group what would be interesting to consider and to conduct the appropriate analysis (tables, charts, summary statistics). Tell me (and each other) what you ‘see’ in the data.use excel to do the table and chart.