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

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)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!