RAVI-i-Mathmtisfrnr li in Practical Exercise #1 The following problem will ask you to demonstrate the descriptive statistics skills we learned in class. Remember to make use of the denitions covered in the reading and lecture and review the details in the rubric before submitting. You will be scored on: a Mathematical Correctness a Organization and neatness In Depth of Reection in Part 2 Part 1 - Computation In this exercise, you will be analyzing some student dam, 1?on in the linked Google Sheet. 1. Create a histogram of the GPAs, Using Google Sheets or Microsoft EXcel. (Be sure to include the histogram in your submission}. 2. Outliers a. Based on your histogram1 do you think this data has outliers? 3. Measure of Center a. What is the hen measure of center for this data? Why? b. Compute it. 4. Measure of Spread a. What is the be\" measure of spread for this data? Why? b. Compute it. 5. Outliers Revisited a. Using your measure of spread, and either the LSIQRs or in rule discussed in class, detemrine the upper and lower threshold for outliers. b. Does your data have outliers, according to these rules of thumb? Part 2 - Rgggm n Imagine you are the dean of the college for these students. Respond to the following questions in a few sentences (there is not one correct answer here]: a What is the benet of knowing the center and spread of your student GPA data, rather than trying to look at all of it at once? a What do you miss out on by only knowing the center and spread of your dam, ratlm than having all the dam in from of you? a What questions would you have about your college and its students after reviewing this data? 100% Y $ % .0 .00 123- Calibri 11 Y BIS. A1 fx Student GPAs A B C D E F Student GPAs 2 3.26 3) Measure of Center: 3 3.21 4) Measure of Spread: 4 3.94 5) Outliers Revisited 5 2.81 Lower Threshold: 6 2.53 Upper Threshold: 7 2.59 8 2.56 2.73 3 11 3.5 12 3.65 13 2.84 14 3.9 15 2.68 16 3.57 17 3.09 18 3.5 19 2.17 20 3.36 21 3.4 22 2.75 23 3.2 24 2.44 25 2.83 26 3 27 3.27 28 3.14 29 3.37 30 2.79 31 2.9 32 3.38 3.3 2.95