DataPRODUKSI PADIThProduksi Padi (ku)Curah Hujan (mm)Lama Penyinaran (jam)199310,820,8621896335119949,860,37518963351199510,722,71719033022199610,747,65919873170199710,352,6501484333319989,795,6382819276019999,993,01418602896200010,749,8681870286720019,237,5932458287820029,166,8721650332020038,776,8891755377620049,602,3021816358420059,787,2172658335220069,418,5722658316420079,914,01925272791200810,111,06917333062200910,620,61311622389

Regresi SederhanaHasil Perhitungan dari Data Analysis: RegressionVariabel Y: Produksi Padi, Variabel X: Curah Hujan (mm)SUMMARY OUTPUTRegression StatisticsMultiple R0.3061094427R Square0.0937029909Adjusted R Square0.0332831903Standard Error612775.809422323Observations17ANOVAdfSSMSFSignificance FRegression1582341029960.128582341029960.1281.55086560970.2321111964Residual155632412889197.76375494192613.184Total166214753919157.88Untuk mengetahui apakah F hitung signifikan atau non signifikan, bandingkan dengan F tabel.F tabel didapat dari fungsi "=finv(probabilitas; derajat bebas regression; derajat bebas residual)Sebagai contoh, ada di sheet berikutnya (Hasil Perhitungan)CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Intercept10818263.3242394688506.27914724415.71265746140.00000000019350746.93524112285779.7132377Curah Hujan (mm)-416.9927841246334.8431793689-1.24533754850.2321111964-1130.6941233146296.7085550654Persamaan regresi sederhana didapat dari persamaan Y=b0+b1x

koefisien korelasikoefisien determinasiadjusted r squareGalat bakujumlah sampelderajat bebasjumlah kuadratrata-rata jumlah kuadratF hitungb0 adalah koefisien intercept, b1 adalah koefisien dari variabel curah hujan

Regresi Sederhana 2Hasil Perhitungan dari Data Analysis: RegressionVariabel Y: Produksi Padi, Variabel X: Lama Penyinaran (jam)SUMMARY OUTPUTRegression StatisticsMultiple R0.4095732048R Square0.1677502101Adjusted R Square0.1122668908Standard Error587209.652714112Observations17ANOVAdfSSMSFSignificance FRegression11042526275548.461042526275548.463.02343500920.1025450886Residual155172227643609.42344815176240.628Total166214753919157.88CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Intercept12321848.07025531353722.369978689.10219727730.00000016979436457.1533301215207238.9871805Lama Penyinaran (jam)-749.9082530148431.2785060276-1.73880275170.1025450886-1669.1566244344169.3401184049

Regresi BergandaHasil Perhitungan dari Data Analysis: RegressionVariabel Y: Produksi Padi, Variabel X: Curah Hujan (mm) dan Lama Penyinaran (jam)SUMMARY OUTPUTRegression StatisticsMultiple R0.5290585373R Square0.2799029359Adjusted R Square0.1770319267Standard Error565383.943595766Observations17ANOVAdfSSMSFSignificance FRegression21739527867695.28869763933847.642.72091173360.1004008251Residual144475226051462.6319659003675.9Total166214753919157.88CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0%Intercept13371074.95637361484504.298817419.00709749850.000000335610187129.90796416555020.004783110187129.90796416555020.0047831Curah Hujan (mm)-457.2712684416309.6709739716-1.47663587120.1619111228-1121.4494489956206.9069121124-1121.4494489956206.9069121124Lama Penyinaran (jam)-791.9240925593416.2222415681-1.90264722420.0778577497-1684.6320127279100.7838276094-1684.6320127279100.7838276094

Hasil PerhitunganRingkasan Hasil PerhitunganRegresi Linear SederhanaCurah Hujan:ANOVAY = 10818263.32 - 416.99XdfSSMSF hitF0.05r = 0.306Regresi1582341029960.128582341029960.1281.5508656097ns4.5430771231r = 0.094Sisa155632412889197.76375494192613.184Total166214753919157.88* = signifikanns = non signifikanLama Penyinaran:ANOVAY = 12321848.07 - 749.91XdfSSMSF hitF0.05r = 0.410Regresi11042526275548.461042526275548.463.0234350092ns4.5430771231r = 0.168Sisa155172227643609.42344815176240.628Total166214753919157.88* = signifikanns = non signifikanRegresi BergandaANOVAY = 13371074.96 - 457.27X1 - 791.92X2dfSSMSF hitF0.05X1: curah hujanRegresi21739527867695.28869763933847.642.7209117336ns3.7388918325X2: lama penyinaranX1/X21697001592146.814697001592146.8142.1804534962ns4.6001099082X2/X111157186837735.151157186837735.153.6200664597ns4.6001099082r = 0.529Sisa144475226051462.6319659003675.9r = 0.280Total166214753919157.88* = signifikanns = non signifikan

F hitF 0.05: *