ML089

¦^´_ 3# jj369963
>>¾Ç¸¹1000093¡A²Ä1ÃD¦³¿òº|­È¡A
>>¥­§¡(²Ä1ÃD,²Ä10ÃD,²Ä14ÃD,²Ä17ÃD,²Ä26ÃD,²Ä34ÃD,²Ä44ÃD,²Ä46ÃD) ¡A¿òº|­È¤£ºâ
>>
>>average(²Ä1ÃD,²Ä10ÃD,²Ä14ÃD,²Ä17ÃD,²Ä26ÃD,²Ä34ÃD,²Ä44ÃD,²Ä46ÃD)=3.333333
>>¥|±Ë¤­¤J=3
>>
>>³o1®æ¶ñ 3

²Ä1ÃD=ªÅ®æ,²Ä10ÃD=2,²Ä14ÃD=2,²Ä17ÃD=2,²Ä26ÃD=2,²Ä34ÃD=2,²Ä44ÃD=ªÅ®æ,²Ä46ÃD2

ºÃ°Ý1¡A¬JµM²Ä¤@ÃDªÅ®æ­n¥Î¨ä¥L®æ¨Ó¨D­È¡A´N¤£¯à©ñ¨ìaverage¤¤
ºÃ°Ý2¡A¥Î¬Ýªº´Nª¾¹Daverage¤£·|¤j©ó2¡Caverage(²Ä1ÃD,²Ä10ÃD,²Ä14ÃD,²Ä17ÃD,²Ä26ÃD,²Ä34ÃD,²Ä44ÃD,²Ä46ÃD)=3.333333¡A¬Ý¥X¨Ó§A«ç¼Ë­pºâ¥X¨Óªº?
ºÃ°Ý3¡Aaverage¶µ¥Ø¬Ý¤£¥X³W«ß

ML089

¦^´_ 5# jj369963
³Ì«á­n¨DªºÁÙ¬OCP2~CU2¡Aª½±µ¥Î¤½¦¡¦p¤U¨D¸Ñ¡A¤£¥²¤j¶O©P³¹¦^¶ñªÅ®æ¡A³o¼Ë¤Ï¦Ó·|¨Ï­ì¸ê®Æ³à¥¢­ì»ª

CP2=(SUM(I2,K2,X2,AC2,AF2,AR2,AV2,AZ2)+ROUND(AVERAGE(I2,K2,X2,AC2,AF2,AR2,AV2,AZ2),0)*(8-COUNT(I2,K2,X2,AC2,AF2,AR2,AV2,AZ2)))/8
CQ2=(SUM(J2,L2,T2,Y2,AA2,AH2,AN2,AS2)+ROUND(AVERAGE(J2,L2,T2,Y2,AA2,AH2,AN2,AS2),0)*(8-COUNT(J2,L2,T2,Y2,AA2,AH2,AN2,AS2)))/8
CR2=(SUM(G2,N2,Q2,W2,AB2,AG2,AK2,AO2)+ROUND(AVERAGE(G2,N2,Q2,W2,AB2,AG2,AK2,AO2),0)*(8-COUNT(G2,N2,Q2,W2,AB2,AG2,AK2,AO2)))/8
CS2=(SUM(H2,P2,AD2,AI2,AL2,AP2,AT2,AX2)+ROUND(AVERAGE(H2,P2,AD2,AI2,AL2,AP2,AT2,AX2),0)*(8-COUNT(H2,P2,AD2,AI2,AL2,AP2,AT2,AX2)))/8
CT2=(SUM(M2,R2,U2,Z2,AJ2,AQ2,AU2,BA2)+ROUND(AVERAGE(M2,R2,U2,Z2,AJ2,AQ2,AU2,BA2),0)*(8-COUNT(M2,R2,U2,Z2,AJ2,AQ2,AU2,BA2)))/8
CU2=(SUM(F2,O2,S2,V2,AE2,AM2,AW2,AY2)+ROUND(AVERAGE(F2,O2,S2,V2,AE2,AM2,AW2,AY2),0)*(8-COUNT(F2,O2,S2,V2,AE2,AM2,AW2,AY2)))/8