Sort the variable ascending by going to Data ! Title the A1 and B2 column Intervals and Frequency accordingly. Frequency Counts and Histograms in Excel for Mac 2011. Sort… and selecting the appropriate column. The add-in works fine with Mac Excel 2011 update 14.1.3. To make your teacher happy, in step 4 above choose Clustered Column (it's the only chart type your teacher will like), and then complete the steps as shown through step 11 above.
We would like to observe the frequency distribution of median family incomes.
