Correlation using EXCEL

Presentation on theme: "Correlation using EXCEL"— Presentation transcript:

1 Correlation using EXCEL
請用EXCEL計算x, y之相關係數 2019/4/29 Copyright©Kuo-Hsien Su 2004

2 Correlation using EXCEL
2019/4/29 Copyright©Kuo-Hsien Su 2004

3 Correlation using EXCEL
2019/4/29 Copyright©Kuo-Hsien Su 2004

4 Correlation using EXCEL
2019/4/29 Copyright©Kuo-Hsien Su 2004

5 Correlation using EXCEL
2019/4/29 Copyright©Kuo-Hsien Su 2004

6 Correlation using EXCEL
2019/4/29 Copyright©Kuo-Hsien Su 2004

7 Correlation using EXCEL
2019/4/29 Copyright©Kuo-Hsien Su 2004

8 Correlation using EXCEL
2019/4/29 Copyright©Kuo-Hsien Su 2004

9 Correlation using EXCEL
2019/4/29 Copyright©Kuo-Hsien Su 2004

10 Correlation using EXCEL
2019/4/29 Copyright©Kuo-Hsien Su 2004

11 Correlation using EXCEL
2019/4/29 Copyright©Kuo-Hsien Su 2004

12 Correlation using EXCEL
2019/4/29 Copyright©Kuo-Hsien Su 2004

13 Correlation using EXCEL
2019/4/29 Copyright©Kuo-Hsien Su 2004

14 Copyright©Kuo-Hsien Su 2004
Regression in EXCEL 2019/4/29 Copyright©Kuo-Hsien Su 2004

15 Copyright©Kuo-Hsien Su 2004
Regression in EXCEL 2019/4/29 Copyright©Kuo-Hsien Su 2004

16 Copyright©Kuo-Hsien Su 2004
Regression in EXCEL 2019/4/29 Copyright©Kuo-Hsien Su 2004

17 Copyright©Kuo-Hsien Su 2004
Regression in EXCEL 2019/4/29 Copyright©Kuo-Hsien Su 2004

18 Copyright©Kuo-Hsien Su 2004
Regression in EXCEL 2019/4/29 Copyright©Kuo-Hsien Su 2004

19 Copyright©Kuo-Hsien Su 2004
Regression in EXCEL 2019/4/29 Copyright©Kuo-Hsien Su 2004

20 Copyright©Kuo-Hsien Su 2004
Regression in EXCEL 2019/4/29 Copyright©Kuo-Hsien Su 2004

21 Copyright©Kuo-Hsien Su 2004
Regression in EXCEL 2019/4/29 Copyright©Kuo-Hsien Su 2004

22 Copyright©Kuo-Hsien Su 2004
Regression in EXCEL 2019/4/29 Copyright©Kuo-Hsien Su 2004

23 Copyright©Kuo-Hsien Su 2004
Regression in EXCEL 2019/4/29 Copyright©Kuo-Hsien Su 2004

24 Copyright©Kuo-Hsien Su 2004
Regression in EXCEL 2019/4/29 Copyright©Kuo-Hsien Su 2004

25 Copyright©Kuo-Hsien Su 2004
Regression in EXCEL 2019/4/29 Copyright©Kuo-Hsien Su 2004

26 Copyright©Kuo-Hsien Su 2004
Regression in EXCEL 2019/4/29 Copyright©Kuo-Hsien Su 2004

27 Copyright©Kuo-Hsien Su 2004
Regression in EXCEL 將迴歸線連上 2019/4/29 Copyright©Kuo-Hsien Su 2004

28 Copyright©Kuo-Hsien Su 2004
Regression in EXCEL 2019/4/29 Copyright©Kuo-Hsien Su 2004

29 Copyright©Kuo-Hsien Su 2004
練習 請開啟grades.xls 用EXCEL計算本學期期中考統計成績(mstat2)與資楚成績(mcom2)之相關係數及迴歸（以資處為依變項，統計為自變項) 2019/4/29 Copyright©Kuo-Hsien Su 2004

30 Copyright©Kuo-Hsien Su 2004
Regression in STATA 請開啟Stata，並進入資料編輯視窗 2019/4/29 Copyright©Kuo-Hsien Su 2004

31 Copyright©Kuo-Hsien Su 2004
Regression in STATA 請將grades.xls中的資料以剪貼方式存成stata系統檔 2019/4/29 Copyright©Kuo-Hsien Su 2004

32 Copyright©Kuo-Hsien Su 2004
Regression in STATA 請將grades.xls中的資料以剪貼方式存成stata系統檔 2019/4/29 Copyright©Kuo-Hsien Su 2004

33 Copyright©Kuo-Hsien Su 2004
Regression in STATA 計算上下學期所有成績的相關係數 2019/4/29 Copyright©Kuo-Hsien Su 2004

34 Copyright©Kuo-Hsien Su 2004
Regression in STATA corr mcom1 fcom1 mcom2 mstat1 fstat1 mstat2, means 2019/4/29 Copyright©Kuo-Hsien Su 2004

35 Copyright©Kuo-Hsien Su 2004
Regression in STATA 畫出mcom2 與 mstat2之間的scatter plot，以mcom2為Y。 2019/4/29 Copyright©Kuo-Hsien Su 2004

36 Copyright©Kuo-Hsien Su 2004
Regression in STATA 以統計成績為自變數，資處成績為依變數，作迴歸分析 Linear regression command: regress dep_var ind_varlist regress mcom2 mstat2 2019/4/29 Copyright©Kuo-Hsien Su 2004

37 Copyright©Kuo-Hsien Su 2004
Regression in STATA regress mcom2 mstat2 SSE SSR b0常數項 b1常數項 2019/4/29 Copyright©Kuo-Hsien Su 2004

38 Copyright©Kuo-Hsien Su 2004
Regression in STATA 在迴歸指令之後立刻輸入估計預測值的指令 predict newvarname predict mcom2hat 電腦算出迴歸的預測值並將數值存在mcom2hat中。 2019/4/29 Copyright©Kuo-Hsien Su 2004

39 Copyright©Kuo-Hsien Su 2004
Regression in STATA 2019/4/29 Copyright©Kuo-Hsien Su 2004

40 Regression in STATA twoway scatter mcom2hat mstat2 2019/4/29
Copyright©Kuo-Hsien Su 2004

41 Regression in STATA twoway connected mcom2hat mstat2 2019/4/29
Copyright©Kuo-Hsien Su 2004

42 Copyright©Kuo-Hsien Su 2004
Regression in STATA regress mcom2 mstat2 2019/4/29 Copyright©Kuo-Hsien Su 2004

43 Copyright©Kuo-Hsien Su 2004
Regression in STATA 2019/4/29 Copyright©Kuo-Hsien Su 2004

44 Copyright©Kuo-Hsien Su 2004
Regression in STATA 2019/4/29 Copyright©Kuo-Hsien Su 2004

45 Copyright©Kuo-Hsien Su 2004
Regression in STATA 2019/4/29 Copyright©Kuo-Hsien Su 2004

46 Copyright©Kuo-Hsien Su 2004
Regression in STATA 2019/4/29 Copyright©Kuo-Hsien Su 2004

47 Copyright©Kuo-Hsien Su 2004
Regression in STATA 2019/4/29 Copyright©Kuo-Hsien Su 2004

48 Copyright©Kuo-Hsien Su 2004
練習 上學期作業成績與本次期中考統計是否有關？ 請以迴歸分析說明。並畫出預測值之直線。 2019/4/29 Copyright©Kuo-Hsien Su 2004