Penggunaan LibreOffice (OpenOffice) untuk mengerjakan regresi (statistik)

LibreOffice Calc (OpenOffice Calc) dapat dipergunakan untuk melakukan perhitungan terhadap regresi. Ini cukup membantu baik dalam belajar Statistika maupun mengerjakan perhitungan dari eksperimen yang sedang dikerjakan.

Untuk pengerjaan regresi secara otomatis dengan menampilkan chart , dapat dilakukan dengan menggunakan fasilitas Trend Line:

 

When you have a scattered grouping of points in a graph, you may want to show the relationship of the points. A trend line is what you need. Calc has a good selection of regression types you can use for trend lines: linear, logarithm, exponential, and power. Choose the type that comes closest to passing through all of the points.

To insert trend lines for all data series, double-click the chart to enter edit mode. Choose Insert → Trend Lines, then select the type of trend line from None, Linear, Logarithmic, Exponential, orPower. You can also choose whether to show the equation for the trend line and the coefficient of determination (R2).

To insert a trend line for a single data series, first select the data series in the chart, and then right-click and choose Insert → Trend Line from the context menu. The dialog for a single trend line is similar to the one below but has a second tab (Line), where you can choose attributes (style, color,width, and transparency) of the line. [1]

 

 

Berikut pengembangan yang saya coba dari contoh yang diperoleh dari http://www2.latech.edu/~strimbu/Teaching/FOR425/Regression_OO.pdf:

 

 

 

Berikut beberapa screenshots dari dokumen asli Regression_OO.pdf:

 

 

 

Referensi:

[1] http://wiki.documentfoundation.org/images/6/6d/0300CG3-CalcGuideLibO3.pdf

[2] http://www2.latech.edu/~strimbu/Teaching/FOR425/Regression_OO.pdf

[3] http://help.libreoffice.org/Chart/Trend_Lines

[4] http://people.hofstra.edu/Stefan_Waner/calctopic1/regression.html

[5] http://www2.latech.edu/~dehall/LWTL/home/content_fundamentals.html

[6] http://web.cecs.pdx.edu/~gerry/class/EAS199A/notes/

[7] http://www2.latech.edu/~dehall/LWTL/ENGR120/

[8] http://www2.latech.edu/~dehall/LWTL/ENGR120/

[9] Introduction to Statistics Using LibreOffice.org Calc

[10] http://mathbits.com/mathbits/tisection/statistics2/correlation.htm

[11] Correlation and Simple Linear Regression 

[12] http://www.le.ac.uk/bl/gat/virtualfc/Stats/regression/regr1.html

[13] http://terpconnect.umd.edu/~toh/spectrum/CurveFitting.html

[14] Linear Regression in Excel

[15] Regression and Correlation

[16] SIMPLE LINEAR REGRESSION

[17] http://en.wikipedia.org/wiki/Coefficient_of_determination 

[18] FX-570ES ‘ One Page Wonder’ Natural Textbook Display

[19] http://www.openofficetips.com/category/math-statistics/

[20] http://dean.serenevy.net/teaching/guides/Software/Spreadsheets/BasicStats

[21] http://dean.serenevy.net/teaching/classes/Fall2007/M111-2/Statistics_in_OpenOffice.pdf