Linear regression in spreadsheet

[Tomm]

Hi

I'm new on a mac and just got NeoOffice.
I'm trying to let spreadsheet do my linear regression.
I have a data table and I now need to Fit the data on the formel y = ax + b. I need to know how to make a graph out of my data and I need the values of “a“ and “b“ in (y=ax+b).
Is this possible in spreadsheet/calc? and how do I do it?

I hope one of you can help me

Tomm

[Lorinda]

Hi Tomm,

Welcome to the mac and NeoOffice.

I don't know the answer to your question for sure, but I looked through the Open Office and Star Office Manuals and didn't find a reference to graphs. Charts, yes. Graphs, no. (Neo Office is based on the Open Office Code)

Hopefully someone else can give you a definitive answer!

If you haven't done so already, you might also check out the sticky thread about support/help for Neo Office. There are several excellent links there.

[valterb]

Hi Tomm.
I think you can do like this.
Insert you data in two coloumns (first row as heading, lets say X and Y)
Than select all your data and go to Insert -> Chart
Click on Next (or change etries according to your data) and choose the chart type: one of that is called XY Chart (in myy window is the second type of chart in the second row). Click on Next.
Now you have to coose if you want only symbols 8(only your data are displayed), or only lines or both or other kind of curves.. Click on Next and make your adjustment for title chart, legend, and so on.
Click on Create. A chart will be displeyd on your Calc sheet.
Now click on your chart and click on Insert -> Statistic, choose the regrssion curve you want (Linear regression is the second), and if you want to can even choose to displey an error category (i.e. variance) and and put on the chart an error indicator.

Hope this helps you.

[jgd]

[valterb]

[jgd]

[valterb]

Excellent, thanks!
So in italian the function is REGR.LIN.
In english you could get the information needed in the help typing Regression lines.

So, Tomm could get his information doing like this:
you can follow two ways: first via wizard, second via direct typing
via wizard: click on function wizard icon, choose Category -> Array than Function LINEST, and click on next
now in data_Y put your cell range or select them clicking on Shrink icon on the right. Repeat the same for data_X and click on OK.
You will see that in the cell where you start the procedure the "a" (slope), and in the next right cell the "b" (intersection with y axis).

Than if you want to display also the graph do what I write before.
Remember that if your data interval doesn't have the (0,0) (axises origin))) you can expand your axis just clicking on the graph and than Format -> Axis -> X Axis -> Scale and than deselect Minimum and type the value you want. Repeate the same for Y axis.

Valter

[jgd]

I think that adding this tip in NeoWiki would be helpful for statisticians. I can do that in French (but unfortunately only in French), and cite your name. But only if you and Sardisson agree, of course.

Jacqueline

[sardisson]

Sure; we don't have many Calc-related tips, and this one seemed like it took a good bit of work to put together

Smokey

[RoyFocker]

And I will give you the spanish translation:

[b]NeoOffice ayuda
Contenidos
Hojas de cálculo
Fórmulas y cálculos
Introducir fórmulas de matriz
En temas relacionados apretar “Calcular con fórmulas”
Ir de nuevo a “temas relacionados” y apretar “asistente para funciones”
Allí ir a “lista de categorías y funciones”
Matriz[b]

I think that the function is “crecimiento”
Maybe this translation can help...

Anche verto il consiglio del nostro "pisano":

[b]Introduce tu información en dos columnas (los nombres de las filas han de ser «x» e «y»).
Selecciona toda la información y ve a «Insertar» y escoge «diagrama»
Apreta «Siguiente» (o cambia las coordenadas de acuerdo con tus datos) y escoge el tipo de diagrama que deseas.
Apreta “Avanzar”
Ahora hay que escoger si quieres que se vean sólo los datos o también las líneas u otros tipos de curvas.
Apreta “Avanzar”
Hay que poner título al diagrama y los títulos de los ejes.
Apreta “Crear”. Se verá el diagrama en la hoja de cálculo.
Entonces apreta en el diagrama y ve a “insertar” y luego a “Estadística”, escoge la curva de regresión que quieras. Si escoges “desviación predeterminada” podrás cambiar el indicador de error.[b]

Greetings from Rome to "Pisa"... Speriamo che anche questa traduzione possa aiutare qualcuno!

[jgd]

Thank you very much RoyFocker.
You can get the help a bit more quickly:
go to menu Help > NeoOffice Help > NeoOffice Calc > Find
enter "linear regression" as search term, and choose "Array Functions" at the top of the list.
There is a page in NeoWiki (only in French)
http://neowiki.sixthcrusade.com/index.php/Fr:Droite_de_Régression

Jacqueline

[valterb]

[jgd]

[valterb]

[jgd]