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.