data correlation and plotting irregular data

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
 
M

Michael R Middleton

Ian -

Don't use an Excel Line chart type.

An XY (Scatter) chart of your data shows a reasonably strong linear
relationship between Y Income and X quantity.

Worksheet functions yield CORREL = +.89, SLOPE = +2352.705, and INTERCEPT =
+2540709.

Fitted Income = 2540709 + 2352.705*quantity

- Mike

www.mikemiddleton.com

++++++++++++++++++++++++++++++++
 
Top