Excel 計算 樣本 數

�@

�ԭz�έp�P�ϯä��R

�@ �����q�� �@	�ƾǤ���	Excel����	Excel���
���饭����		=(A1+A2......+A10       )/10 �� =sum(A1:A10)/10 �� =sum(A1:A10)/count(A1:A10)	=Average(A1:A10)
�˥�������		�P�W	�P�W
���ƩΤ����	�N�ƭȥѤp��j�ƦC,���̤������ƭȧY�O	�@ �L �@	=Median(A1:A10)
����	�ƭȤ��X�{���Ƴ̦h�̧Y�O	�@ �L �@	=Mode(A1:A10)
�X�󥭧���		=(A1*A2*....*A10)^(1/10)	=Geomean(A1:A10)
�թM������		=1/((1/A1+1/A2+...+1/A10)/10)	=Harmean(A1:A10)

�@

�@ ����(�ܲ�)�q�� �@	�ƾǤ���	Excel����	Excel���
���Z�νd��	�@ ���Z�̤j�ȴ�h�̤p�� �@	�L²������,�i�H�Ƨǩ�Rank()��ƴM��	=Max(A1:A10)-Min(A1:A10)
�|����Z	�NN�ӼƭȥѤp��j�ƦC��,��1/4��4����Ƭ�Q1,��2/44����Ƭ�Q2...�|����Z=Q3-Q1	�L²������,�i�H�Ƨǩ�Rank()��ƴM��	=Quantile(A1:A10,3)-Quantile(A1:A10,1)
�����������t		(��)	=Avedev(A1:A10)
�����ܲ���		(��)	=Var(A1:A10)
�˥��ܲ���		(��)	=Varp(A1:A10)
����зǮt		(��)	=Stdevp(A1:A10)
�˥��зǮt		(��)	=Stdev(A1:A10)
�ܲ��Y��		(��)	=stdev(A1:A10)/average(A1:A10)

          <�d��>

�W�q�q�������Ƕq�����W�פ��G: �HCOUNTIF��ƭp��

<�y�k> COUNTIF(��ƽd��,���O�W��)

    �Ҧp: COUNTIF($A$1:$B$10, "�k��")

              COUNTIF($A$1:$B$100, 1)

�@

<�d��>

          ���Z�q������v�q�����W�פ��G: �HFREQUENCY��ƭp���ֿn�W��,�A�Ѭ۾F�֭p�W�רD���U�նZ���W��(��ƭӼ�)

          <�y�k> FREQUENCY(��ƽd��,�նZ���W��)

              �Ҧp: FREQUENCY($A$1:$B$100,1)     �N��<1���֭p�W��

                        FREQUENCY($A$1:$B$100,2)     �N��<2���֭p�W��

           <�d��>

�@

                                                           <<�����>>�ֳt������Ƥ��W�פ��G���Τ�����

�@

             <�d��>

IF (Logical_test, Value_if_true, Value_if_false)         �򥻫�

IF (Logical_test_1, IF(Logical_test_2, Value_if_true, Value_if_false), Value_if_false)   �_���z��

IF (Logical_test_1, Value_if_true, IF(Logical_test_2, Value_if_true, Value_if_false))�@�_���^�O

�@	���T	���T	���~	���~
Logical_test_1	>20	<0	<20	>0
Logical_test_2	>15	<5	<15	>5
Logical_test_3	>10	<10	<10	>10
Logical_test_4	>5	<15	<5	>15
Logical_test_5	>0	<20	<0	>20

         <�d��>

            �ϯä��R��(Pivot analysis): �N��ƾ�z���C�p��,�p����椺��C�����椧�έp�q(�Ӽ�,������,�зǮt,...)

�@

            �إ߼ϯä��R��

            �s�׼ϯä��R��

�@

            <�d��>     <�d��>