how do I display a Linear regression formula using Open Office?
Hello,
I am using openoffice's spreadsheet program to generate a graph. I have already made a graph and inserted the linear regression line. What I would like to know is how do I display the formula for the linear regression line? Can someone tell my how to do this. |
Insert->Object->OLE Object->OpenOffice.org Formula
Edit the formula to your needs |
I saw on a website that I could use the formula Linest() which is one of the functions I can access by clicking on the function autopilot button.
Can you tell me what parameter to put in, for the following data: Current (A) 0.001078 0.00245 0.004116 0.005648 0.00735 0.00882 0.010584 0.012054 0.013524 0.015092 Force (N) 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 The current is the in the X axis and the Force is in the Y axis |
All times are GMT -5. The time now is 02:54 PM. |