Exercise 1: Monthly Income (25 pts) The monthly income of workers at a particular corporation is given below: $1200, $1800, $2150, $6495, $875, $1430, $1965, $2025 a) Determine the mean monthly income of the workers at the corporation. b) Determine the median monthly income of the workers at the corporation. c) Does the monthly income have a mode? If yes, what is the mode? d) What measure of central tendency should be used when discussing the "average" monthly income? Mean, median, or mode? e) Explain your answer to part (d).Exercise 2: Assignment Scores (25 pts) The scores on 12 lab assignments for an imaginary student are given below: 34, 78, 65, 60, 95, 100, 45, 97,71, 75, 71, 80 a) Determine the mean score on the student's lab assignments. b) Determine the median score on the student's lab assignments. c) Do the assignment grades have a mode? If yes, what is the mode? d) What measure of central tendency should be used when discussing the "average" grade for the imaginary student? Mean, median, or mode? e) Explain your answer to part (d).Exercise 3: Favorite Sodas (25 pts) The table below provides the results of a survey asking participants which of the soft drinks on the list was their favorite. Use the table to answer the questions. (Note: I am not sure if Barq's Root Beer exists in North Carolina, but it is a real drink!) Drink Frequency Coke 157 Pepsi 112 7up 85 Dr. Pepper 136 Barq's Root Beer 149 a) Does the data have a mean? If so, what is the mean? b) Does the data have a median? If so, what is the median? c) Does the data have a mode? If so, what is the mode? d) What measure of central tendency should be used to describe the "average" favorite soft drink? Mean, median, or mode? e) Explain you answer to part (d). BONUS (10 pts): What percentage of those surveyed choose Coke as their favorite drink? What percentage chose 7up? (Both must be correct for points) BONUS (10 pts): Generate a pie chart that shows the data in Exercise 3. Insert the pie chart into this document!Exercise 4: Grouped Data (25 pts) A researcher surveyed 150 people and asked them to report their age. The data were grouped into 5 classes, each representing Age Frequency 18 - 24 54 25 - 31 15 32 - 38 37 39 - 45 26 46 - 52 18 a) (15 pts) What is the mean of the grouped data? Or what is the "average" age of the participant? b) (10 pts) Make a histogram of your data. Refer to the video from Section 4.4 if you need a refresher on histograms!Exercise 5: Using Excel (30 pts) In this final exercise, I want you to use Excel to calculate the final grade for an imaginary student in this class. The course syllabus will give you the weights for each category. The file attached on Blackboard contains an imaginary student's grades for every assignment. (Any relation to a real student's grades is purely coincidental as I just made these numbers up.) Use they syllabus and the data to answer the questions below. A) What is the mean, median, and mode of each assignment category? You should have 3 answers for 4 categories or a total of 12 answers! Use Excel to make a table with these answers and insert the table below! B) What is the student's overall grade in the class? Calculate this value using Excel. Insert the table provided in the Excel File to show your work!Complete the fields below and insert this table for Exercise 5: Part B Category Weight Average Product (Weight x Average) ALEKS LAB TEST DISCUSSION CLASS AVERAGEStudent, Imaginary ALEKS LAB TEST DISCUSSION 100 45 90 70 90 60 87 75 95 70 64 60 86 75 42 90 95 90 100 86 75 87 95 84 100 O 85 80 90 80 90 67 90 45 58 95 65 54 28 90 HANNTODD JAVIAWN 90 36 95 95 90 90 82 26 27 28Q Complete the fields below and insert this table for Exercise 5: Part A Complete the fi Category MEAN MEDIAN MODE MIDRANGE Category ALEKS ALEKS LAB LAB TEST TEST DISCUSSION DISCUSSION Complete the fields below and insert this table for Exercise 5: Part B