Resolved: Task 2 - switch problem

Hi Khaled,

I believe you are tying to replicate the histogram shown in task 2 sheet.

Where y axis represents the frequency and x axis represents the interval. As I saw on your chart, you plotted y as price.

To solve the task you should build the data interval (x) and then apply countfs function to find the frequency (y)

data interval = (Maximum Value - Minimum Value) / Number of elements you want to show 

You will find something like this:

Use the following formula to calculate the frequency:

=COUNTIFS(<PriceInterval>;CONCATENATE(">=";<LowerValue>);<PriceInterval>;CONCATENATE("<";<HigherValue>))

Following theses steps you will see something like this:

I hope this might help.