LinkBack URL
About LinkBacks
Let say I have these datas:
Zone:
4.3
5.0
3.2
1.2
1.3
3.7
4.4
1.1
2.2
4.9
3.7
And I want to make a graph or table with Zone 1-5
And I want percentage of each zone:
Like:
zone 1: 14%
zone 2:20 %
zone 3:40%
zone 4:15%
zone 5:11%
How do I do that?
Let say I have these datas:
Zone:
4.3
5.0
3.2
1.2
1.3
3.7
4.4
1.1
2.2
4.9
3.7
And I want to make a graph or table with Zone 1-5
And I want percentage of each zone:
Like:
zone 1: 14%
zone 2:20 %
zone 3:40%
zone 4:15%
zone 5:11%
How do I do that?
How does your list of numbers correspond to zones 1-5?
I am not really sure how to sort it into zones.
Because its average intensity on a training session: So one session can be at intensity 3.4 in average. Like f.ex one session has 5 intervals at 3.1, 3.5, 3.2, 3.1, 3.5 in intensity.
So I guess sessions at an intensity zone below 1.5 should be sorted into zone one, and above 1.5 into zone 2.
Like Jeff, I am not sure what you mean by zone or how you are coming up with the results you have. My first expectation would be to use either the =FREQUENCY() function or a =COUNTIF() or =COUNTIFS() function to get the number of entries in each zone. Then, divide the result for each zone by the total entries to get the fraction/ratio/percentage for each zone.
Help files for these functions can be found here: https://support.office.com/en-us/art...__toc309306716
Originally Posted by shg
Here is a solution using COUNTIFS. The zones that values fall into are defined as
1: <=1
2: >1, <=2
and so forth.
But in your formala I cant see the how the zones are defined.
Btw: zone 1 is anything less than 1.5 anything above 1.5 is 2
Same for zone 2 and the others.
In your attached excel file there is 0% in zone 1, but there is already many datas with less than 1.5
OK, here is a revision that uses 0.5 above the zone number as the maximum value for that zone. Note that the intervals for zones 1 and 5 are only 0.5 where the intervals for the other zones are 1.0.
Thanks a lot this worked
If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
And thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks