Final exam scores from two different biology classes are listed below: Class A Class B 91 89
Question:
Final exam scores from two different biology classes are listed below:
Class A | Class B |
---|---|
91 89 87 75 86 77 85 92 84 77 79 66 90 84 81 72 92 75 81 79 | 72 80 72 70 77 64 100 69 83 93 98 73 65 99 84 82 78 68 81 74 |
Compute themean, median, mode, First Quartile (Q1), Third Quartile (Q3), Inner Quartile Range (IQR), Lower Bound, and Upper Boundexam score for each class using Excel spreadsheet functions (AVERAGE, MEDIAN, MODE.MULT, and QUARTILE.INC). Be sure all your work is shown and clearly labeled. Provide a screenshot of the functions and results from Excel and paste it into your assignment document (be sure I can see the numbers and labels clearly). (2 pts)
Respond to the following questions: 2. Which class did better? How do you know? (2 pts)
3. Do any outliers exist? How do you know? (1 pts)
4. Did you double-check your answers and notice anything peculiar? Explain. (2 pts)
5. Make up an example (not in the text or in your lectures) in which the median would be the preferred measure of central tendency (over the mean) and explain why it would be the preferred measure of central tendency in your example. (3 pts)