The next way to create frequency table is using Frequency Function. Frequency Function computes the number of observations made within a range of values and the returns a vertical array of numbers.1. Select the entire Cells for getting the number of observation.2. Then Type the Formula as given below Syntax : = Frequency(data_array, bins_array)3. Hold the Control + Shift Buttons while pressing Enter key for executing the formula.