Last answered:

18 May 2023

Posted on:

27 Apr 2023

0

Resolved: Task 2 - switch problem

When I try to switch row/column I got this Error !

How can I fix this problem ?




2 answers ( 1 marked as helpful)
Posted on:

27 Apr 2023

0

Also I cant find Pin wedth in my Format axis options!



Posted on:

18 May 2023

0

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. 

Submit an answer