Hi Bruce,

To calculate the median of grouped data, you can use the following steps:

1. Create a table with two columns: one for the Likert scale values and one for the frequency of each value. In your example, it would look like this:
   
   | Likert Scale | Frequency |
   |--------------|-----------|
   | 1 | 3 |
   | 2 | 5 |
   | 3 | 3 |
   | 4 | 6 |
   | 5 | 2 |
   
2. Add a third column for the cumulative frequency. This column will show the running total of the frequency column. In your example, it would look like this:
   
   | Likert Scale | Frequency | Cumulative Frequency |
   |--------------|-----------|----------------------|
   | 1 | 3 | 3 |
   | 2 | 5 | 8 |
   | 3 | 3 | 11 |
   | 4 | 6 | 17 |
   | 5 | 2 | 19 |
   
3. Calculate the median position using the formula (n+1)/2, where n is the total number of values. In your example, n is 19, so the median position is (19+1)/2 = 10.
   
4. Find the median value by looking up the cumulative frequency that corresponds to the median position. In your example, the median position is in the range of the "threes" column, which has a cumulative frequency of 11. Therefore, the median value is 3.
   

You can use the following formula to calculate the median value directly from the grouped data:

This is an array formula, so you need to press Ctrl+Shift+Enter instead of just Enter to enter it. The formula assumes that your table starts in cell A1 and that the Likert scale values are in column A and the frequencies are in column B.