f you can can you show me in Excel? That is my question for 25 students Below you are given the examination scores of 25 students. 52 99 83 82 84 23 25 76 90 88 19 78 75 79 80 89 73 74 86 99 a. Calculate the mean for this data. b. Calculate a trimmed mean eliminating the obvious outliers. c. Now calculate the median for the data. Which of the above calculations do you regard as the best measure of ‘average’ class performance? Explain why
f you can can you show me in Excel? That is my question for 25 students Below you are given the examination scores of 25 students. 52 99 83 82 84 23 25 76 90 88 19 78 75 79 80 89 73 74 86 99 a. Calculate the mean for this data. b. Calculate a trimmed mean eliminating the obvious outliers. c. Now calculate the median for the data. Which of the above calculations do you regard as the best measure of ‘average’ class performance? Explain why
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.3: Simple Regression Models
Problem 6P: Do the sales prices of houses in a given community vary systematically with their sizes (as measured...
Related questions
Question
If you can can you show me in Excel? That is my question for 25 students
Below you are given the examination scores of 25 students.
52 99 83 82 84
23 25 76 90 88
19 78 75 79 80
89 73 74 86 99
a. Calculate the mean for this data.
b. Calculate a trimmed mean eliminating the obvious outliers.
c. Now calculate the median for the data.
Which of the above calculations do you regard as the best measure of ‘average’ class performance? Explain why.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,