How to find additional cumulative percentage in a histogram

how is this histogram results presented ?
is it like data in a regular worksheet ?
if that is the case , you can use vba from access to read the values and make comparison..

are you looking for exact values of 80%, 90% and, 95% ?

upload a copy of the excel fle..

Thank you capricorn,
Yes I am interested in these values and also 50% and 60%.
You want all the data used for histogram or only the the histogram I posted here?
Thank you and I will send the data you want a little later - I have to go for 1 hour
Thanks again

I attached the file with the data you requested.
Thank you
Book1.xls

where do you want to display the results ?

also, in the excel file you uploaded, the values you wanted to find, does not exists.

You can display the results on other worksheet.
I am not sure what you are saying. I would like if possible what are the bin values and frequency values if cumulative percent are 50%, 60%, 80% ,90% and 95%.
Thank you

in the excel file you uploaded, the values you wanted to find, 50%, 60%, 80% ,90% and 95%. does not exists. so there is nothing to find

sorry, i think i misunderstood what you want to find..

Do I have to understand that what I want is not possible to get with Access or Excel?
Thank you

the way i see it, perhaps, not sure it can be done by reverse calculation but, i am not well verse with this. ask this question to be deleted and post another question and add the Math zone.. sorry

What's the application? How much accuracy is needed? is this something you need to repeat for many data sets or is this it?

The solution is to fit a cumulative frequency distribution to the bin bounds and interpolate to your required percentages. I've attached a linear interpolation, implemented directly in Excel.

A smoother interpolation, say cubic splines, could be done with a little bit of VBA programming.

If the data are rough and it makes more sense to fit a curve that doesn't go exactly through the bin values, that can also be done with a spline with fewer knots and some fancier math involving some linear algebra. I can do that too but haven't time right now; someone on the Math forum probably knows of a software library.
Linear.xls

Thank you for your help ifpugnacious.
Can you send me a link or something to see the formula you used to interpolate the cumulative percentage?
Thanks again

"A smoother interpolation, say cubic splines, could be done with a little bit of VBA programming."
Can you please do it?
Thank a lot,
Marian

I want to compare some yearly statistical results using the same cumulative percentages of different years.
Unfortunately histograms in Excel doesn't allow me to do that.
"A smoother interpolation, say cubic splines, could be done with a little bit of VBA programming."
Can you please do it?
Thanks a lot,
Marian

My Excel 2010, maybe with some add-ins, does. Look at Percentile functions under Statistics.

I will do it.
I don't have Excel 2010 but I will try.
Thanks again

Thank you very much