prairiebliss
New Member
Hi there,
I'm wondering if this can be done, I have spend several days looking up formulas but I just don't have enough knowledge to make the formulas do what I want to do.
I need to find values associated with the 25th, 50th, 75th percentiles. Because of the format of my data I need to sum the data until it is as close to the percentile as possible, then report the value of the adjacent column.
Sorry, I'm not sure what the best formatting is, but here is an example.. The rows are incomplete, as they do not equate 100% but hopefully you get the idea...
And this is how I would like to present my results, with what the results of the above data should be...
Thank you so much for your time, I really appreciate it. Let me know if there is anything that I could present better.
I'm wondering if this can be done, I have spend several days looking up formulas but I just don't have enough knowledge to make the formulas do what I want to do.
I need to find values associated with the 25th, 50th, 75th percentiles. Because of the format of my data I need to sum the data until it is as close to the percentile as possible, then report the value of the adjacent column.
Sorry, I'm not sure what the best formatting is, but here is an example.. The rows are incomplete, as they do not equate 100% but hopefully you get the idea...
A1-Size Class | B1-Sample 1 % | C1-Sample 2 % |
---|---|---|
1 | 12.81 | 15.65 |
2 | 12.52 | 7.92 |
3 | 7.64 | 2.85 |
4 | 3.54 | 5.24 |
5 | 3.62 | 4.68 |
And this is how I would like to present my results, with what the results of the above data should be...
A84 - Percentiles (%) | B84 - Class at % | C84 - Class at % |
---|---|---|
25 | 2 | 3 |
50 | ||
75 |
Thank you so much for your time, I really appreciate it. Let me know if there is anything that I could present better.