« Conditional Formatting IV : Masking errors | Main | Regression Analysis II : Basic functions, charting »
April 12, 2005
Regression analysis I : Basic linear formulas
As requested by Joerg in Germany, I am going to cover the topic of regression analysis over the next few days - including formulas, built-in functions and charting with trendlines.Consider a set of data point pairs - which suggests a possible linear relationship between the two variables.
The equations below are used to calculate the slope m and y-intercept point b for a given set of data, as well as the correlation coefficient r.
Given the formula above, it is a straightforward process to extract the linear coefficients for the given set of data points.
Next, we will look at buil-in OOo Calc functions and the plotting of the trendline for this linear regression example.
Posted by Dave at April 12, 2005 10:15 PM
Comments
One can alos use linest and forecast functions to reache the same results
Posted by: Joseph at April 13, 2005 07:06 AM