scientific calulations using scattter and trendlines

ecellium

New Member
Joined
Jan 7, 2010
Messages
1
:confused: Hi all, firstly I am wanting to plot a non linear XY data set (essentially 2 sets of nearly linear data with different slopes). then I would like to start working from the end pair of XY point with a linear trendline adding a pair to the trendlne fit at a time, examining the r value (correlation coefficient) to find where it begins to reduce (this being the end of the first linear set of data). Then spit the XY data set so that 2 series are plotted the first ending based on the last highest r value. Finally fit the 2 series with linear trendlines to get the equations and using simulataneous equations (here i suppose an input box for the equations would work) work out the intersect of the linear fit lines.

I can do this manually but have only managed to imlement a slider to work the data series fit by adding pairs of data points. this obviously takes time and then i have to fit the lines and carry out the simultaneous equation calcs.

I have never tried vba so this is quite a daunting task - any help here very much appreciated.

Steve
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Watch MrExcel Video

Forum statistics

Threads
1,108,939
Messages
5,525,739
Members
409,661
Latest member
pprabha

This Week's Hot Topics

Top