Thursday, 10 October 2019

Excel histogram

I am attempting to make a histogram in Excel. I would like the X axis to be a percent distribution.


    |                     |||
||| ||||||
||||| |||||||||
0 10 20 30 40 50 60 70 80 90 100


Sample Percent MC Percent Bins MC Average Average
1 100 37.15 0 41.31 99.048
2 95.24 36.31 10
3 100 51.47 20
4 100 35.98 30
5 100 45.63 40
50
60
70
80
90
100

How can I do this?

No comments:

Post a Comment

How can I VLOOKUP in multiple Excel documents?

I am trying to VLOOKUP reference data with around 400 seperate Excel files. Is it possible to do this in a quick way rather than doing it m...