Question: ou can find more information about the FREQUENCY function at Office Support. requency tables and histograms are common methods for describing data. Excel now has

ou can find more information about the FREQUENCY function at Office Support.
requency tables and histograms are common methods for describing data. Excel now has the FREQUENCY function that is simple to use and can offer insights into how your data is 0 EREQUENCY needs are two simple parameters: 1) the data you wish to analyze and 2) a list of the upper range for each frequency bin.
The data you need to analyze is the Sales ( $ ) column in Table1. The bin ranges are in cells F15:F19. Note that the numbers in F15:F19 are the upper boundary of each bin range.
In cell G15, use the FREQUENCY function to create a frequency table. In cell G21, count the total number of records. Enter your values below:
\table[[Lower Bin,Upper Bin,Frequency],[0,600,
ou can find more information about the FREQUENCY

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!