How to Calculate a Mean, Median and Mode Online for Grouped Data
- 1). Visit docs.google.com in your Web browser. Enter your Google account name and password, if necessary. Click the "Create" button and choose "Spreadsheet" to open up a new spreadsheet.
- 2). Click cell "A1" and enter the lower limit for the first data range in your grouped data, then click cell "B1" and enter the upper limit for that range. Click cell "A2" and repeat the process for the second range of numbers for which you have data. Continue until you have entered all the ranges for your statistical data into the first two columns.
- 3). Select cell "C1" and enter the frequency number for the group you entered into the first two columns. Continue down the column, entering in the frequency numbers for your data.
- 4). Click cell "D1" and type in whatever number is in cell "C1," then click cell "D2" and enter the following formula: "=D1+C2." Press "Enter" to complete the formula, then move your mouse over the bottom-right corner of the cell and press down on the mouse button. Drag the mouse down to copy your formula down the column. This will create a running total, which you will need to figure out the median class.
- 5). Select cell "E1" and type "=(A1+B1)/2" into the cell, then copy this formula down the column in the same way you copied the last formula. This will create a list of midpoints for your groups, which you will need to find the mean.
- 6). Click cell "F1" and type the following formula into the cell: "=sum(C:C)/2." This will give you half of the number of frequencies in your grouped data, which you will need in later calculations. Take the result in this cell and visually compare it to column "D." Note the first value that is higher than this number and note the row number for the cell that contains that value. This row represents the median class, and you will need this number in your median calculations.
- 7). Select cell "F2" and enter "=SUMPRODUCT(C:C,E:E)/(F1/2)." This formula will give you the mean for your grouped data.
- 8). Click cell "F3" and type the following formula into the cell: "Ax+(F1-(sum(C1:Cy)))/Cx+(Bx-Ax)." Change each "x" to be equal to the row number for your median class. Change the "y" to be equal to one less than the row number for your median class. This formula will give you the median for your grouped data.
- 9). Look through column "C" to find the largest number. Look down the row when you find this number, and the value in column "E" will be the mode for the grouped data.