Try   HackMD

Google試算表_統計_簡單線性回歸_檢量線

LHB阿好伯, 2020/05/29

tags: Google

如果常用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 →