How to do distribution curve in excel 2013.

[smilemoar88]

Hi guys,

As the title says I am trying to figure out how to do a distribution curve for some data from my calculations.

This here the finalised data: http/imgur.com/j3nQMtv

And what I am wanting to do is a curve of dt (in micrometers and rounded) vs fm (wt%) distribution curve similar to this one here: http/imgur.com/OCrwcOQ

Obviously, mine will match my data but this is the general idea I am aiming for. Please note that the fm (wt%) is a range over the the cells it's next to. i.e. 0.6 is over 80 and 60.

Any help on the matter would be greatly appreciated.

 

[joex444]

Your example is a histogram.

 

[Alabalcho]

"Distribution curve" means that this is a graph showing frequency of data - that is, for your "dt=10" how many sample data fail there. Your source data (the table) does not seem to have that data - there is one row for each "dt" value, so your "distribution curve" will be flat line - all counts equal to one.