# Linear Regression Equations

#### GaelanK7008

Hi guys im using Open Office to try to solve math problems and i find its not working for linear equations.

That above is the data ive entered into my open office when I try to tun [h=1]LINEST function or use a t 83 graphing calculator to find the regression equation, I am completely unable to do so. If anyone has any tips on how to find regression equation on a computer or using software, I would be very obliged. [/h]Here are some related articles
https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_LINEST_function
Thanks

#### HallsofIvy

MHF Helper
What, exactly do you mean by "unable to do so"? Certainly using "Linest" should give you some answer- though here it won't be a very convincing answer because this is far from a straight line!

#### skeeter

MHF Helper

here is a plot of your data ... hardly looks linear in total. Might be a reasonable linear fit from t = 1 to t = 2.5.

#### Attachments

• 762 bytes Views: 0

#### Debsta

MHF Helper

here is a plot of your data ... hardly looks linear in total. Might be a reasonable linear fit from t = 1 to t = 2.5.
I would suggest you try a polynomial of order 2 (a quadratic) regression. I'm not familiar with TI calculators but know it can be done. Try this:
http://www.pstcc.edu/facstaff/jahrens/calculator/stats83.pdf

#### GaelanK7008

Thanks for the feedback guys ive been working it out using statistics by hand. But im still working on it. Ill look at the links youve guys have posted. Thanks again.

#### GaelanK7008

And actually Linest function in open office dosent give me any answer at all, i cant get the function to work.

#### skeeter

MHF Helper
Performed a cubic regression on the data with my TI84 ... not a bad fit.

#### Attachments

• 1.1 KB Views: 0
• 2.5 KB Views: 0