I am using open office version 2.3, and running windows XP. I'm an Economics Student in Britain.. and I cannot afford Microsoft Office.. and open office has always done me good soo....
In the spreadsheet program (Calc) is there a way of replicating the 'REGRESSION' command that Excel has in 'Tools>Data Analysis' ?
The command basically works out alpha and beta in the function yt= a + bt
Just don't have a clue how it's done in Calc any help? thanks
[Solved] Regression Function
Re: Regression Function
Array function
=LINEST(Y_values;X_values) [Ctrl+Shift+Enter]
Returns 2 values for slope and y-intersection.
=LINEST(Y_values;X_values) [Ctrl+Shift+Enter]
Returns 2 values for slope and y-intersection.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Regression Function
Thanks. I didn't get the (ctrl shift enter) bit! Much love xx