![]() ![]() To find median or mode, repeat the steps. The average appears in the cell you selected earlier, and you’re done. ![]() ![]() The cells you have selected will appear in the brackets of the formula. In this case, I will click in cell D2, keep the mouse button pressed down and drag down to the bottom of column D. Using the mouse, highlight the cells you wish to use. Then, in the list of functions, scroll down until you find the word average, which is the same as mean. In the function category, click on All or Statistical. To enter the mean formula, first click on the fx bar in the menu bar above the data to open the Function Wizard. Now, click in the cell beneath that, and this is where you will paste the formula. But I like to keep my work organized, so I am going to click in the cell at the bottom of the row containing the height data, and type Mean. You can use any empty cell to calculate the mean. Go to the column containing the height data, which is column D for me. So, for our first calculation, let’s find the mean, or the average, (these are the same thing) for the height data. Since mean and median are numeric calculations, we will be working on numeric data. This episode will show you how to use the spreadsheet formulas to find the measures of central tendency: mean, median and mode. Spreadsheet programs, like Excel, have built-in formula commands that make these calculations fast and easy. Your students probably already know how to calculate mean, median and mode by hand, but this can be a tedious process for larger datasets. Hi, I’m Angela McCanny and I am a resource teacher for Statistics Canada. To access the Rich-Text Format (RTF) version, use the document conversion features available in most word processing software, or use a file viewer capable of reading RTF. This episode will show you how to use spreadsheet formulas to find the three measures of central tendency: mean, median and mode. Most of the information is still relevant. NOTE: These videos were prepared when the Census at School Project was managed by Statistics Canada. ![]()
0 Comments
Leave a Reply. |