excel edit olah data

7/24/2019 Excel Edit Olah Data

1/42

Jmlh_faktor_rsk * SS_drjt Crosstabulation

Derajat Syntax

Low

Jmlh_faktor_rsk

1

Count 13

Expected Count 5!

" w#th#n Jmlh_faktor_rsk 1$$$"

%

Count &'

Expected Count %5(

" w#th#n Jmlh_faktor_rsk ()3"

3

Count 1$

Expected Count %5(

" w#th#n Jmlh_faktor_rsk 1(%"

&

Count $

Expected Count 111

" w#th#n Jmlh_faktor_rsk $$"

5

Count $

Expected Count )

" w#th#n Jmlh_faktor_rsk $$"

*otal

Count ')

Expected Count ')$

" w#th#n Jmlh_faktor_rsk &&%"


2/42

Scores*otal

+ed#um ,#-h

$ $ 13

%1 5% 13$

$$" $$" 1$$$"

( 5 5!

)3 %31 5!$

1%1" !'" 1$$$"

1& 3& 5!

)3 %31 5!$

%&1" 5!'" 1$$$"

& %1 %5

&$ )) %5$

1'$" !&$" 1$$$"

$ % %

3 ! %$

$$" 1$$$" 1$$$"

%5 '% 15'

%5$ '%$ 15'$

1'$" 3)(" 1$$$"


3/42

Chi-Square Tests

.alue df /symp S#- 0%s#ded2

earson Ch#S4uare ! $$$

L#kel#hood at#o 1$)!&& ! $$$

6 of .al#d Cases 15'

a 5 cells 0333"2 ha7e expected count less than 5 *he m#n#mum expected count #s 3%

)$((5a


4/42

JK * SS_drjt Crosstabulation

Derajat Syntax Scores

Low +ed#um

J8

L

Count '% %%

Expected Count '15 %%3

" w#th#n J8 &&'" 15!"

Count ( 3

Expected Count (5 %(

" w#th#n J8 &1%" 1('"

*otal

Count ') %5

Expected Count ')$ %5$

" w#th#n J8 &&%" 1'$"


5/42

*otal,#-h

55 13)

55% 13)$

3)'" 1$$$"

( 1(

'! 1($

&1%" 1$$$"

'% 15'

'%$ 15'$

3)(" 1$$$"


6/42

Chi-Square Tests


earson Ch#S4uare % )'$

L#kel#hood at#o $!1 % )'$


a 1 cells 01'("2 ha7e expected count less than 5 *he m#n#mum expected count #s %(%

$!1a


7/42

Umur * SS_drjt * JK Crosstabulation

J8

Derajat Syntax

Low

L 9mur 3$ Count 1

Expected Count &

" w#th#n 9mur 1$$$"

3( Count 1

Expected Count &

" w#th#n 9mur 1$$$"

3) Count 3

Expected Count 13

" w#th#n 9mur 1$$$"

&% Count %

Expected Count )

" w#th#n 9mur 1$$$"

&3 Count $

Expected Count )

" w#th#n 9mur $$"

&& Count $

Expected Count )

" w#th#n 9mur $$"

&5 Count 5

Expected Count %(

" w#th#n 9mur !33"

&' Count 3

Expected Count 1!" w#th#n 9mur (5$"

&( Count %

Expected Count %%

" w#th#n 9mur &$$"

&! Count 1

Expected Count &

" w#th#n 9mur 1$$$"

&) Count 3

Expected Count %(

" w#th#n 9mur5$$"

5$ Count 5

Expected Count 31

" w#th#n 9mur (1&"

51 Count 3

Expected Count %%

" w#th#n 9mur '$$"

5% Count %

Expected Count )


8/42

" w#th#n 9mur 1$$$"

53 Count %

Expected Count 31

" w#th#n 9mur %!'"

5& Count 3

Expected Count 3'

" w#th#n 9mur 3(5"55 Count '

Expected Count &5

" w#th#n 9mur '$$"

5' Count %

Expected Count 31

" w#th#n 9mur %!'"

5( Count %

Expected Count 1!

" w#th#n 9mur 5$$"

5! Count%

Expected Count 13

" w#th#n 9mur ''("

5) Count 1

Expected Count 1!

" w#th#n 9mur %5$"

'$ Count %

Expected Count %(

" w#th#n 9mur 333"

'1 Count %

Expected Count %%

" w#th#n 9mur &$$"

'% Count 1

Expected Count 1!

" w#th#n 9mur %5$"

'3 Count %

Expected Count %%

" w#th#n 9mur &$$"

'& Count $

Expected Count 13

" w#th#n 9mur $$"

'5 Count $

Expected Count %%

" w#th#n 9mur $$"

'' Count 1

Expected Count )

" w#th#n 9mur 5$$"

'! Count $

Expected Count )


9/42

" w#th#n 9mur $$"

') Count $

Expected Count 13

" w#th#n 9mur $$"

($ Count 1

Expected Count 13

" w#th#n 9mur 333"(1 Count 1

Expected Count &

" w#th#n 9mur 1$$$"

(% Count $

Expected Count 13

" w#th#n 9mur $$"

(3 Count $

Expected Count &

" w#th#n 9mur $$"

(& Count1

Expected Count )

" w#th#n 9mur 5$$"

(5 Count 1

Expected Count )

" w#th#n 9mur 5$$"

(! Count $

Expected Count &

" w#th#n 9mur $$"

!5 Count 1

Expected Count &

" w#th#n 9mur 1$$$"

*otal Count '%

Expected Count '%$

" w#th#n 9mur &&'"

9mur 3& Count $

Expected Count &

" w#th#n 9mur $$"

&! Count 1

Expected Count &

" w#th#n 9mur 1$$$"

5$ Count 1

Expected Count &

" w#th#n 9mur 1$$$"

5% Count $

Expected Count !

" w#th#n 9mur $$"

5' Count 1

Expected Count !


10/42

" w#th#n 9mur 5$$"

'$ Count 1

Expected Count !

" w#th#n 9mur 5$$"

'& Count $

Expected Count &

" w#th#n 9mur $$"'5 Count $

Expected Count &

" w#th#n 9mur $$"

'' Count $

Expected Count &

" w#th#n 9mur $$"

'! Count 1

Expected Count &

" w#th#n 9mur 1$$$"

($ Count$

Expected Count &

" w#th#n 9mur $$"

(3 Count $

Expected Count &

" w#th#n 9mur $$"

(& Count 1

Expected Count &

" w#th#n 9mur 1$$$"

(! Count 1

Expected Count &

" w#th#n 9mur 1$$$"

*otal Count (

Expected Count ($

" w#th#n 9mur &1%"

*otal 9mur 3$ Count 1

Expected Count &

" w#th#n 9mur 1$$$"

3& Count $

Expected Count &

" w#th#n 9mur $$"

3( Count 1

Expected Count &

" w#th#n 9mur 1$$$"

3) Count 3

Expected Count 13

" w#th#n 9mur 1$$$"

&% Count %

Expected Count )


11/42

" w#th#n 9mur 1$$$"

&3 Count $

Expected Count )

" w#th#n 9mur $$"

&& Count $

Expected Count )

" w#th#n 9mur $$"&5 Count 5

Expected Count %(

" w#th#n 9mur !33"

&' Count 3

Expected Count 1!

" w#th#n 9mur (5$"

&( Count %

Expected Count %%

" w#th#n 9mur &$$"

&! Count%

Expected Count )

" w#th#n 9mur 1$$$"

&) Count 3

Expected Count %(

" w#th#n 9mur 5$$"

5$ Count '

Expected Count 35

" w#th#n 9mur (5$"

51 Count 3

Expected Count %%

" w#th#n 9mur '$$"

5% Count %

Expected Count 1!

" w#th#n 9mur 5$$"

53 Count %

Expected Count 31

" w#th#n 9mur %!'"

5& Count 3

Expected Count 35

" w#th#n 9mur 3(5"

55 Count '

Expected Count &&

" w#th#n 9mur '$$"

5' Count 3

Expected Count &$

" w#th#n 9mur 333"

5( Count %

Expected Count 1!


12/42

" w#th#n 9mur 5$$"

5! Count %

Expected Count 13

" w#th#n 9mur ''("

5) Count 1

Expected Count 1!

" w#th#n 9mur %5$"'$ Count 3

Expected Count 35

" w#th#n 9mur 3(5"

'1 Count %

Expected Count %%

" w#th#n 9mur &$$"

'% Count 1

Expected Count 1!

" w#th#n 9mur %5$"

'3 Count%

Expected Count %%

" w#th#n 9mur &$$"

'& Count $

Expected Count 1!

" w#th#n 9mur $$"

'5 Count $

Expected Count %(

" w#th#n 9mur $$"

'' Count 1

Expected Count 13

" w#th#n 9mur 333"

'! Count 1

Expected Count 13

" w#th#n 9mur 333"

') Count $

Expected Count 13

" w#th#n 9mur $$"

($ Count 1

Expected Count 1!

" w#th#n 9mur %5$"

(1 Count 1

Expected Count &

" w#th#n 9mur 1$$$"

(% Count $

Expected Count 13

" w#th#n 9mur $$"

(3 Count $

Expected Count )


13/42

" w#th#n 9mur $$"

(& Count %

Expected Count 13

" w#th#n 9mur ''("

(5 Count 1

Expected Count )

" w#th#n 9mur 5$$"(! Count 1

Expected Count )

" w#th#n 9mur 5$$"

!5 Count 1

Expected Count &

" w#th#n 9mur 1$$$"

*otal Count ')

Expected Count ')$

" w#th#n 9mur &&%"


14/42

Chi-Square

Scores

*otal

J8

+ed#um ,#-h L

$ $ 1

% & 1$

$$" $$" 1$$$"

$ $ 1

% & 1$

$$" $$" 1$$$" *otal

$ $ 3

5 1% 3$

$$" $$" 1$$$" a 11( cells 01$

$ $ % : 11& cells 01$

3 ! %$ c &% cells 01$$

$$" $$" 1$$$"

1 1 %

3 ! %$

5$$" 5$$" 1$$$"

% $ %

3 ! %$

1$$$" $$" 1$$$"

1 $ '

) %& '$

1'(" $$" 1$$$"

$ 1 &

' 1' &$$$" %5$" 1$$$"

$ 3 5

! %$ 5$

$$" '$$" 1$$$"

$ $ 1

% & 1$

$$" $$" 1$$$"

1 % '

) %& '$

1'(" 333" 1$$$"1 1 (

11 %! ($

1&3" 1&3" 1$$$"

1 1 5

! %$ 5$

%$$" %$$" 1$$$"

$ $ %

3 ! %$


15/42

$$" $$" 1$$$"

1 & (

11 %! ($

1&3" 5(1" 1$$$"

$ 5 !

13 3% !$

$$" '%5" 1$$$"1 3 1$

1' &$ 1$$

1$$" 3$$" 1$$$"

% 3 (

11 %! ($

%!'" &%)" 1$$$"

1 1 &

' 1' &$

%5$" %5$" 1$$$"

$ 1 35 1% 3$

$$" 333" 1$$$"

$ 3 &

' 1' &$

$$" (5$" 1$$$"

1 3 '

) %& '$

1'(" 5$$" 1$$$"

% 1 5

! %$ 5$

&$$" %$$" 1$$$"

$ 3 &

' 1' &$

$$" (5$" 1$$$"

1 % 5

! %$ 5$

%$$" &$$" 1$$$"

$ 3 3

5 1% 3$

$$" 1$$$" 1$$$"

3 % 5

! %$ 5$

'$$" &$$" 1$$$"

$ 1 %

3 ! %$

$$" 5$$" 1$$$"

1 1 %

3 ! %$


16/42

5$$" 5$$" 1$$$"

$ 3 3

5 1% 3$

$$" 1$$$" 1$$$"

$ % 3

5 1% 3$

$$" ''(" 1$$$"$ $ 1

% & 1$

$$" $$" 1$$$"

1 % 3

5 1% 3$

333" ''(" 1$$$"

$ 1 1

% & 1$

$$" 1$$$" 1$$$"

$ 1 %3 ! %$

$$" 5$$" 1$$$"

$ 1 %

3 ! %$

$$" 5$$" 1$$$"

1 $ 1

% & 1$

1$$$" $$" 1$$$"

$ $ 1

% & 1$

$$" $$" 1$$$"

%% 55 13)

%%$ 55$ 13)$

15!" 3)'" 1$$$"

$ 1 1

% & 1$

$$" 1$$$" 1$$$"

$ $ 1

% & 1$

$$" $$" 1$$$"

$ $ 1

% & 1$

$$" $$" 1$$$"

% $ %

& ! %$

1$$$" $$" 1$$$"

$ 1 %

& ! %$


17/42

$$" 5$$" 1$$$"

$ 1 %

& ! %$

$$" 5$$" 1$$$"

1 $ 1

% & 1$

1$$$" $$" 1$$$"$ 1 1

% & 1$

$$" 1$$$" 1$$$"

$ 1 1

% & 1$

$$" 1$$$" 1$$$"

$ $ 1

% & 1$

$$" $$" 1$$$"

$ 1 1% & 1$

$$" 1$$$" 1$$$"

$ 1 1

% & 1$

$$" 1$$$" 1$$$"

$ $ 1

% & 1$

$$" $$" 1$$$"

$ $ 1

% & 1$

$$" $$" 1$$$"

3 ( 1(

3$ ($ 1($

1('" &1%" 1$$$"

$ $ 1

% & 1$

$$" $$" 1$$$"

$ 1 1

% & 1$

$$" 1$$$" 1$$$"

$ $ 1

% & 1$

$$" $$" 1$$$"

$ $ 3

5 1% 3$

$$" $$" 1$$$"

$ $ %

3 ! %$


18/42

$$" $$" 1$$$"

1 1 %

3 ! %$

5$$" 5$$" 1$$$"

% $ %

3 ! %$

1$$$" $$" 1$$$"1 $ '

1$ %& '$

1'(" $$" 1$$$"

$ 1 &

' 1' &$

$$" %5$" 1$$$"

$ 3 5

! %$ 5$

$$" '$$" 1$$$"

$ $ %3 ! %$

$$" $$" 1$$$"

1 % '

1$ %& '$

1'(" 333" 1$$$"

1 1 !

13 3% !$

1%5" 1%5" 1$$$"

1 1 5

! %$ 5$

%$$" %$$" 1$$$"

% $ &

' 1' &$

5$$" $$" 1$$$"

1 & (

11 %! ($

1&3" 5(1" 1$$$"

$ 5 !

13 3% !$

$$" '%5" 1$$$"

1 3 1$

1' &$ 1$$

1$$" 3$$" 1$$$"

% & )

1& 3' )$

%%%" &&&" 1$$$"

1 1 &

' 1' &$


19/42

%5$" %5$" 1$$$"

$ 1 3

5 1% 3$

$$" 333" 1$$$"

$ 3 &

' 1' &$

$$" (5$" 1$$$"1 & !

13 3% !$

1%5" 5$$" 1$$$"

% 1 5

! %$ 5$

&$$" %$$" 1$$$"

$ 3 &

' 1' &$

$$" (5$" 1$$$"

1 % 5! %$ 5$

%$$" &$$" 1$$$"

1 3 &

' 1' &$

%5$" (5$" 1$$$"

3 3 '

1$ %& '$

5$$" 5$$" 1$$$"

$ % 3

5 1% 3$

$$" ''(" 1$$$"

1 1 3

5 1% 3$

333" 333" 1$$$"

$ 3 3

5 1% 3$

$$" 1$$$" 1$$$"

$ 3 &

' 1' &$

$$" (5$" 1$$$"

$ $ 1

% & 1$

$$" $$" 1$$$"

1 % 3

5 1% 3$

333" ''(" 1$$$"

$ % %

3 ! %$


20/42

$$" 1$$$" 1$$$"

$ 1 3

5 1% 3$

$$" 333" 1$$$"

$ 1 %

3 ! %$

$$" 5$$" 1$$$"1 $ %

3 ! %$

5$$" $$" 1$$$"

$ $ 1

% & 1$

$$" $$" 1$$$"

%5 '% 15'

%5$ '%$ 15'$

1'$" 3)(" 1$$$"


21/42

ests


earson Ch#S4uare (& 1)'

L#kel#hood at#o )&153 (& $5(

6 of .al#d Cases 13)

earson Ch#S4uare %' 3$5

L#kel#hood at#o %)($( %' %!$

6 of .al#d Cases 1(

earson Ch#S4uare (' %$)

L#kel#hood at#o 1$$&%( (' $3%


$$"2 ha7e expected count less than 5 *he m#n#mum expected count #s 1'

$$"2 ha7e expected count less than 5 *he m#n#mum expected count #s 1'

$"2 ha7e expected count less than 5 *he m#n#mum expected count #s 1!

!&1(3:

%)1&3c

!5'!!a


22/42


23/42


24/42


25/42


26/42


27/42


28/42

Dislipidemia * Derajat Synta S!ores Crosstabulation

Derajat Syntax Sc

Low +ed#um

D#sl#p#dem#a

*#dak

Count 3' (

Expected Count %3) !(" w#th#n D#sl#p#dem#a ''(" 13$"

;a

Count 33 1!

Expected Count &51 1'3

" w#th#n D#sl#p#dem#a 3%&" 1('"

*otal

Count ') %5


" w#th#n D#sl#p#dem#a &&%" 1'$"


29/42

Chi-Squar

res*otal .alue

,#-h earson Ch#S4uare

11 5& L#kel#hood at#o 1!11&

%15 5&$ 6 of .al#d Cases 15'%$&" 1$$$"

a $ cells 0$$"2 ha7e expected count less than 551 1$%

&$5 1$%$

5$$" 1$$$"

'% 15'

'%$ 15'$

3)(" 1$$$"

1('!%a


30/42

e Tests

df /symp S#- 0%s#ded2

% $$$

% $$$

*he m#n#mum expected count #s !'5


31/42

D" * Derajat Synta S!ores Crosstabulation


Low +ed#um

D+

*#dak

Count '$ 1)

Expected Count 5&& 1)(

" w#th#n D+ &!!" 15&"

;a

Count ) '

Expected Count 1&' 53

" w#th#n D+ %(3" 1!%"

*otal

Count ') %5


" w#th#n D+ &&%" 1'$"


32/42

Chi-Square Tests

*otal.alue df

,#-h earson Ch#S4uare %

&& 1%3 L#kel#hood at#o 5%)' %

&!) 1%3$


35!" 1$$$"a $ cells 0$$"2 ha7e expected count less than 5 *he m#n#mu

1! 33

131 33$

5&5" 1$$$"

'% 15'

'%$ 15'$

3)(" 1$$$"

515$a


33/42

/symp S#- 0%s#ded2

$('

$(1

expected count #s 5%)


34/42

#ipertensi * Derajat Synta S!ores Crosstabulation


Low +ed#um ,#-h

,#pertens#

*#dak

Count &' ) 15

Expected Count 31$ 11% %(!

" w#th#n ,#pertens# '5(" 1%)" %1&"

;a

Count %3 1' &(

Expected Count 3!$ 13! 3&%

" w#th#n ,#pertens# %'(" 1!'" 5&("

*otal

Count ') %5 '%

Expected Count ')$ %5$ '%$

" w#th#n ,#pertens# &&%" 1'$" 3)("


35/42

Chi-Square Tests

*otal.alue df

earson Ch#S4uare %

($ L#kel#hood at#o %5&)) %

($$ 6 of .al#d Cases 15'

1$$$"

a $ cells 0$$"2 ha7e expected count less than 5 *he m#n#mum!'

!'$

1$$$"

15'

15'$

1$$$"

%&('%a


36/42

/symp S#- 0%s#ded2

$$$

$$$

expected count #s 11%%


37/42

"erokok * Derajat Synta S!ores Crosstabulation


Low +ed#um ,#-h

+erokok

*#dak

Count %& ' 1$

Expected Count 1(( '& 15)

" w#th#n +erokok '$$" 15$" %5$"

;a

Count &5 1) 5%

Expected Count 513 1!' &'1

" w#th#n +erokok 3!!" 1'&" &&!"

*otal

Count ') %5 '%

Expected Count ')$ %5$ '%$

" w#th#n +erokok &&%" 1'$" 3)("


38/42

Chi-Square Tests

*otal.alue df

earson Ch#S4uare %

&$ L#kel#hood at#o '11& %

&$$ 6 of .al#d Cases 15'

1$$$"

a $ cells 0$$"2 ha7e expected count less than 5 *he m#n#mu11'

11'$

1$$$"

15'

15'$

1$$$"

'$$%a


39/42

/symp S#- 0%s#ded2

$5$

$&(

expected count #s '&1


40/42

$i%ayat keluar&a untuk seran&an jantun& * Derajat Synta S!ores Cro

Derajat Syntax Sc

Low +ed#um

*#dak

Count '' %5

Expected Count '(% %&&

&3&" 1'&"

;a

Count 3 $

Expected Count 1! '

(5$" $$"

*otal

Count ') %5


&&%" 1'$"

#wayatkeluar-a untukseran-an

jantun-

" w#th#n #wayat keluar-a untukseran-an jantun-




41/42

sstabulation Chi-Square Tests

res*otal

.alue df

,#-h earson Ch#S4uare %

'1 15% L#kel#hood at#o %%!' %

'$& 15%$ 6 of .al#d Cases 15'

&$1" 1$$$"a 3 cells 05$$"2 ha7e expected count less than 5 *he m#n#m

1 &

1' &$

%5$" 1$$$"

'% 15'

'%$ 15'$

3)(" 1$$$"

1('1a


42/42

/symp S#- 0%s#ded2

&15

31)

m expected count #s '&

excel edit olah data

Documents