G5 G25 H5 I5 J5 K5 AVERAGE B5 F5 AVERAGE G5 G24 MAX B5 F5 MIN B5 F5 $G$25 0.58 $H$25 $G$25 $G$25 0.58 $H$25 G24 H25 H24 I24 J24 K24 A5 A24 G5 G24, I5

C15 B6 B12 / B6 B7 C16 F6 F12 / F6 F7 G16 C16/C15 1 C18 B6 B12 / B6 B8 B9 C19 F6 F12 / F6 F8 F9 G19 C19/C18 1 1

G5 G25 H5 I5 J5 K5 AVERAGE B5 F5 AVERAGE G5 G24 MAX B5 F5 MIN B5 F5 $G$25 0.58 $H$25 $G$25 $G$25 0.58 $H$25 G24 H25 H24 I24 J24 K24 A5 A24 G5 G24, I5 I24, J5 J24, K5 K24..... UCL.. 2

UCL 3.5141.. CL 3.4995 LCL 3.4848.... G5 MAX B5 F5 MIN B5 F5 G24 G25 AVERAGE G5 G24 H5 2.11 $G$25 H24 I5 $G$25 I24 J5 0 $G$25 J24 A5 A24 G5 G24, H5 H24, I5:I24, J5 J24. 3

D5 D20 D21 E5 F5 G5 C5/B5 SUM D5 D19 AVERAGE D5 D19) $D$21 3 SQRT $D$21 1 $D$21 /50 $D$21 IF $D$21 3 SQRT $D$21 1 $D$21 /50 0, 0 D19 E19 F19 G19 A5 A19 D5 D19, E5 E19, F5 F19, G5 G19. R 4

B18 C5 D5 E5 AVERAGE B5:B16 $B$18 3 SQRT $B$18 $B$18 IF $B$18 3 SQRT $B$18 <0, 0 C16 D16 E16 A5 A16 B5 B16, C5 C16, D5 D16, E5 E16., R, P. 5

C9 SUM B6 B8 /3 C14 D11 SUM B6 B10 /5 D14 E9 B9 C9 E13 F11 B11 D11 F13 Excel... 6

B6 C14.. 1 E. 7

. 2 E. 3.. 8

C8 D8 0.1 B5 0.3 B6 0.6 B7 B8 C8 C13 D12 C8 D8 E7 F7 C7 0.2 B7 C7 D7 0.8 (B7 D7) B7 C7 B7 D7 C17 D17 E17 F17 Excel.. damping factor 1 α. 9

. 1 a 1 0.8 0.2. H6. B6 B17.. 1 E.. Alpha 0.2 C6 C17. Alpha 0.8, D6 D17. 10

B9 SUM B6 B8 F9 F6 SUM B6 E6 F8 B11 INTERCEPT F6 F8, A6 A8 B12 SLOPE F6 F8, A6 A8 B14 B11 3 B12 G6 G8 TREND F6 F8, A6 A8.. A6:A8 F6 F8.,. ( ).. 11

4 5. B16 B17 B9/$F$9 B16 $B$14 E16 E17 D5 E5 B12 H4 H5 H6 B5 C5 B5 2 SUM B5:B11 INTERCEPT C5 C11, B5 B11 SLOPE C5 C11, B5 B11 H4+45 H5 D11 E11 E12 12

F4 CORREL C5 C11, B5 B11 13

4 3. G6 H6 I6 J6 G18 G19 I20 ABS E6 ABS F6 E6 2 F6 2 SUM G6 G17 G18/ COUNT A6 A17 1) I18/(COUNT A6 A17) 1 G17 H17 I17 J17 J18 H19 J20 14

D5 B5 C5 D10 E5 D5 E6 E5 D6 E10 F6 ABS D6 F10 G5 F5 G6 G5 F6 G10 H5 G5/A5 H10 I5 E5/H5 I10 15

B8 B4 D4 B11 B7 1 1 E7 1 E4 1 1 H7 1 H4 16

E4 B5/B4 E5 B4 B6 B5 B6/2 E6 B5/E5 E7 E6 24 365 E8 E7 50 E9 1/E6 D5 B5/ B5 C5 D7 17

B9 B4/ B6 B5 18

B13 B14 B15 B16 B17 B18 B4 B5 B6 B7 /B8 B4 B5 B6 B7 B6-B7 B9 B10 /B8 B4 B5 B6 B7 B6-B7 B9 B10 B11 /B8 B15/B14 B15/B13 1 B17 19

F7 B7 C7 D7 E7 F9 F6 G6 H6 F12 B6 E6 C6 E6 D6 E6 SUM F6 F11 F11 G11 H11 H12 20

B16 C16 G16 H16 H18 B20 B22 B23 C23 B24 C24 B26 B27 B28 B29 H26 B14 B15 C14 G14 G15 SUM B16 G16 SUM B18 G18 B18 B19 ROUND B17/B20, 0 IF B11 B22, 0, B11 B22 IF B22 22, 0, C22 B22 IF B11 B22, B11 B22, 0 IF B22 C22, B22 C22, 0 B23 $B$4 B24 $B$5 B17 $B$9 SUM B26 B28 SUM B26 G26 F16 G20 G22 G23 G24 G26 G27 G28 H29 H28 21

Excel. 22

Excel. 23

B10 B11 B12 B13 B14 SQRT 2 B6 B4/B5 B4/B8 B7 B10/2 B5+B4/B10 B6 B4/B10 B8 B10/B4 B11 B12 B13 B14 B15 B16 SQRT 2 B4 B6/ 1 B8/B9 B5 0.5 1 B8/B9 B11 B5 B6/B11 B4 B11 1 B8/B9 B6/B11 B11/B8 B11/B9 24

B9 NORMSINV B7/100 B6 SQRT B5 B10 B4 B5 NORMSINV B7/100 B6 SQRT B5 25

B11 B4 B8 B6 NORMSINV B7 B5 SQRT B8 B6 B9 26

H9 H10 H11 H12 H16 H18 H19 H20 H21 H25 H27 H28 H29 H30 IF G9 G11 H8 G7, G9 G11 H8 G7.0 IF H9 H7, 0, H7 H9 H10 $B$9 OFFSET H12, 1, $B$8 H12 $B$16 IF G18 G20 H17 G16, G18 G20 H17 G16, 0 IF H18 H16, 0, H16 H18 H19 $B$18 OFFSET(H21, 1, $B$17 H21 $B$25 IF G27 G29 H26 G25, G27 G29 H26 G25, 0 IF H27 H25, 0, H25 H27 H28 $B$27 OFFSET H30, 1, $B$26 Q9 Q10 Q11 Q12 Q16 Q18 Q19 Q20 Q21 Q25 Q27 Q28 Q29 Q30 27

Excel. 28

Excel. 29

Excel. Excel. Excel. 30

F5 D5/E5 F9 G5 B5/C5 G9 A4 G9.... B10 SUM B5 B9 C10 C5 B5 C6 C5+B6 C9 E5 IF C5 D5, 0, C5 D5 E9 E10 SUM(E5:E9) C13 AVERAGE C5 C9 C14 AVERAGE E5 E9 C5 C10/B10 31

Excel. 32

Excel. Excel. 33

B18 VLOOKUP B13,$A$6 $C$10,2 C18 B18 VLOOKUP C13,$A$6 $C$10,2 F18 B19 B18 VLOOKUP B13,$A$6 $C$10,3 C19 MAX C18, B19 VLOOKUP C13,$A$6 $C$10,3 F19 B21 F19 34

C8 C7 C6 G8 C11 C10 C9 G11 C12 B12 C7 C10 G12 35

M7 J7 K13 SUMPRODUCT $C$7 $J$7, C13 J13 K22....., Excel 2008 p 418 36

.. 1. E5 B5 4 C5 D5 /6 E14 F5 (D5 B5) 2/36 F14 D17 SUMPRODUCT F5 F14, G5 F14 E17 NORMDIST 20, B17, SQRT D17, TRUE 37

. E5 B5 C5 E14 H5 G5 F5 /E5 H14 M25 B5 D5 M34 L5 L6 L7 M21 SUM F5 F14 SUMPRODUCT D5 D14, H5:H14 L5 L6 11 16~11 0.5.. 38

.. 39