How to do distribution curve in excel 2013.

smilemoar88

Estimable
Aug 22, 2014
1
0
4,510
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.
 
Solution
"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.
"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.
 
Solution