Transcription of 迴歸分析 - spaces.isu.edu.tw
1 EXCEL 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 A B C D E F G H I J K L M N O P Q R RestaurantPopulatuonSales 1258 Excel 26105 A1:C1 Restaurant population sales 3888 A2:A11 48118 B2:C11 Excel 512117616137 1 Tools( ) 720157820169 2 Date Analysis( )9221491026202 3 Date Analysis( ) ; Regression( ) OK( ) R R 10 ANOVA 4 Regression( ) ; SSMSF Input Y Range( Y ) C1:C11 X Range( X ) B1:B11 Labels( ) 915730 Confidence Level ( ) Confidence Level ( ) 99 t P- 95% 95% Output Range( ) Output Range( ) ( ) OK ( ) (R ) ANOVA A28:130 y b0=60 B29.
2 B1=5 B30 A29 A30 Population b1 sb1= 03 C30 C28 Excel b1 t t=b1/sb1 t=5 / D28 t D30 t = n 2=10 2=8 t 1 0 E30 t p Excel p P = < = H0 F28:130 y Excel 95% 99 99% H30 1 99% 130 1 99% 1 99% F30 G30 95% 95% ANOVA A22:F26 B23 C23 sso B23 MS P = < = H0 D25 F F24 F p B17 A17 R B16 Excel R ( A16) A19 B19 Excel ; sb1 b1
