xander wrote:NeoThermic wrote:ewanm wrote:Why don't you plot as a scater and use regresion.
Right click on plotted point -> add trendline -> polynomial, then set the order, then ok. Order two gives quadratic regression, 3 cubic regression etc.
Set the order to? I've tried 2 - 6, and all don't look right. I must be missing something...
He is talking the order of the polynomial. A first order polynomial only contains the variable; a second order polynomial contains the variable squared; a third order polynomial contains the variable cubed; &c. But, as I said above, what is being compared? Regression is a comparitive technique...
Right, so I'm back to square one, Excel doesn't have a usefull easy to plot histogram chart type