...and its turning out in the opposite direction it should!
I am trying to make a couple of plots, but they are not looking like some examples I have.
In the attachment is my data. I need to make 2 plots (though once it I figure out how to to do the first one I should be ok).
Plot 1: Resource Grade (log scale) against the proportion of deposits (linear scale)
Plot 2:Tonnage (log scale) against proportion of deposits (linear scale)
They are meant to cumulative proportion plots. As a line or scattergram. An example of what they are meant to look like is at: http://www.nbmg.unr.edu/dox/ofr962/c11.pdf on Page 4 and 5.
My main problem is that my curve always turns out in the opposite direction to those above. I use Data Analysis > Rank and Percentile to get the cumulative list. (Not sure if that is even the right method)
"Proportion of deposits" is supposed to be a cumulative percentage, so I guess i need know how many of the same number there are, and find out their proportion to the overall.
e.g . all the deposits together = 100%....3 deposits have a tonnage = to 1.5 t which together represents 2% of the total deposits tonnages at a cumulative proportion rate of 12.9% (f I add all the ones below it). I just did that my calculation, though im sure there is an easier way in excel....and thats what im trying to do, and make a plot of them.
Anyone have any idea....or am i even confusing myself?
Btw the way im new....so hello!And....I have posted on another forum for help, as its 4.30am, and this assignment is due in 3 and half hours...aha...
http://www.mrexcel.com/forum/showthr...=1#post1716732 Link to other forum
Bookmarks