ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¦p¦ó¥h°£Åܲ§¼Æ¸û¤jªº¼Æ­È«á,¨D¥­§¡¼Æ

[µo°Ý] ¦p¦ó¥h°£Åܲ§¼Æ¸û¤jªº¼Æ­È«á,¨D¥­§¡¼Æ

A       B    C    D      E     F      G     H
83        88        77        71        89        73        94        71

A-H¥­§¡¼Æ        80.75
A-H¼Ð·Ç®t        8.988087354
¥­§¡¼Æ+¼Ð·Ç®t        89.73808735
¥­§¡¼Æ-¼Ð·Ç®t        71.76191265

¥u¥­§¡­pºâA-H¤¤²Å¦X"¥­§¡¼Æ+¼Ð·Ç®t"¨ì"¥­§¡¼Æ-¼Ð·Ç®t"½d³òªº¼Æ¦r
´N¬O§R°£94 ©M 71(D.G.H ),¨ä¾l¥­§¡ µ¥©ó82=>½Ð°Ý­n¦p¦ó³]¤½¦¡¨D¥X82?
¬¡­¶Ã¯1.zip (10.63 KB)

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

=AVERAGE(IF((A1:H1>=AVERAGE(A1:H1)-STDEV(A1:H1))*(A1:H1<=AVERAGE(A1:H1)+STDEV(A1:H1)),A1:H1))
°}¦C¤½¦¡¡A­n¨Ï¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

ÁÂÁÂhcm19522 ¤Îª©¥D,«D±`·PÁÂ

TOP

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD