I
Ian Murdoch
Im sure Im missing something but I have two issues regarding dat
correlation. Is there a way to automatically scale the X axis for rea
non arithmetic series data so I can then determine the trend
correlation coefficient, equation to the line etc. for say the exampl
below. Secondly, how do I determine Y from corresponding values of
from the equation to the trend line rather than the interval value.
quantity Income
680 7,092,102
1,423 4,549,599
1,535 8,279,940
2,010 7,304,693
2,086 6,596,971
2,142 6,586,680
2,882 7,327,627
3,428 8,520,046
3,496 8,824,036
4,073 14,400,000
4,576 12,208,911
5,526 18,795,575
6,081 16,505,354
Any guidence would be appreciated
Ia
correlation. Is there a way to automatically scale the X axis for rea
non arithmetic series data so I can then determine the trend
correlation coefficient, equation to the line etc. for say the exampl
below. Secondly, how do I determine Y from corresponding values of
from the equation to the trend line rather than the interval value.
quantity Income
680 7,092,102
1,423 4,549,599
1,535 8,279,940
2,010 7,304,693
2,086 6,596,971
2,142 6,586,680
2,882 7,327,627
3,428 8,520,046
3,496 8,824,036
4,073 14,400,000
4,576 12,208,911
5,526 18,795,575
6,081 16,505,354
Any guidence would be appreciated
Ia