How to do distribution curve in excel 2013.

smilemoar88

Estimable
Aug 22, 2014
1
0
4,510
0
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.
 
"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.
 
Thread starter Similar threads Forum Replies Date
J Apps General Discussion 1
A Apps General Discussion 3
M Apps General Discussion 1
C Apps General Discussion 3
Ne0Wolf7 Apps General Discussion 4
B Apps General Discussion 1
G Apps General Discussion 0
rishiswaz Apps General Discussion 4
H Apps General Discussion 4
Z Apps General Discussion 2
shadowmax Apps General Discussion 3
calmstateofmind Apps General Discussion 2
coyotethunderhawk Apps General Discussion 4
A Apps General Discussion 3
A Apps General Discussion 4
RussK1 Apps General Discussion 15
Y Apps General Discussion 2
G Apps General Discussion 2
king smp Apps General Discussion 6
P Apps General Discussion 1

ASK THE COMMUNITY