Google試算表_統計_簡單線性回歸_檢量線
LHB阿好伯, 2020/05/29
Image Not Showing
Possible Reasons
- The image file may be corrupted
- The server hosting the image is unavailable
- The image path is incorrect
- The image format is not supported
Learn More →
如果常用Excel的可以參考之前所寫Excel_統計_簡單線性回歸_檢量線
然而這一篇以Google試算表操作
最近Google試算表有更新,步驟有些差異
Image Not Showing
Possible Reasons
- The image file may be corrupted
- The server hosting the image is unavailable
- The image path is incorrect
- The image format is not supported
Learn More →
Fig 1. 與Excel一樣選取資料儲存格後點取插入->圖表
Image Not Showing
Possible Reasons
- The image file may be corrupted
- The server hosting the image is unavailable
- The image path is incorrect
- The image format is not supported
Learn More →
Fig 2. 一樣選取散佈圖
Image Not Showing
Possible Reasons
- The image file may be corrupted
- The server hosting the image is unavailable
- The image path is incorrect
- The image format is not supported
Learn More →
Fig 3. 之後點取自定於系列中加入趨勢線,標籤選擇:使用方程式,在勾選顯示R平方值
Image Not Showing
Possible Reasons
- The image file may be corrupted
- The server hosting the image is unavailable
- The image path is incorrect
- The image format is not supported
Learn More →
然而結束後會發現其R平方值沒有顯示至小數點,這時候我們可以依靠試算表內建函數來輔助
Fig 4.利用函數"=RSQ(Y,X)"即可求出其相關係數 R平方值
Image Not Showing
Possible Reasons
- The image file may be corrupted
- The server hosting the image is unavailable
- The image path is incorrect
- The image format is not supported
Learn More →
Fig 5. 補充函數說明
若是要將回歸線使其通過原點也可依下列步驟計算
Image Not Showing
Possible Reasons
- The image file may be corrupted
- The server hosting the image is unavailable
- The image path is incorrect
- The image format is not supported
Learn More →
Fig 6. 先計算原資料截距
Image Not Showing
Possible Reasons
- The image file may be corrupted
- The server hosting the image is unavailable
- The image path is incorrect
- The image format is not supported
Learn More →
Fig 7. 將原數據y軸數值減去其截距
Image Not Showing
Possible Reasons
- The image file may be corrupted
- The server hosting the image is unavailable
- The image path is incorrect
- The image format is not supported
Learn More →
Fig 8. 修正後我們再進行確認,即可發現其回歸線截距為0
原理
其截距的意義就是回歸線通過Y軸的數值,而扣除其原截距就是將其回歸線移至通過原點
全文分享至
https://www.facebook.com/LHB0222/
有疑問想討論的都歡迎於下方留言
喜歡的幫我分享給所有的朋友 \o/
有所錯誤歡迎指教
Image Not Showing
Possible Reasons
- The image file may be corrupted
- The server hosting the image is unavailable
- The image path is incorrect
- The image format is not supported
Learn More →