Try it! Find the median of the numbers in column A (which extend well below row 10). Is it the same as the average? Why or why not? (Scroll to the right to see the answers.)
The mode is the most likely value, the one that occurs most often. If no value occurs more than once or twice, then the mode isn’t very useful. However, if a clothing retailer records the size of each dress sold, then the mode is quite useful. It is the best-selling dress size. Excel’s MODE function calculates the mode.
To use the MODE function:
Enter the formula =MODE(datarange), where datarange is any range that contains a set of values.
Try it! Calculate the mode of the set of values in the above spreadsheet. How many times does this value occur? (Again, answers are to the right.)
Dostları ilə paylaş: |
