Pikir dan Rasa

cogito ergo sum

Penggunaan LibreOffice (OpenOffice) untuk mengerjakan regresi (statistik)

leave a comment »

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


About these ads

Written by sunupradana

February 25, 2012 at 9:57 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 82 other followers

%d bloggers like this: