ICT oxford school Azuero

  Statistical Functions   This chapter gives an overview of some very useful statistical functions in Excel . Average To calculate the average of a group of numbers, use the AVERAGE function. Averageif To average cells based on one criteria, use the AVERAGEIF function. For example, to calculate the average excluding zeros. Median To find the median (or middle number), use the MEDIAN function. Check: Mode To find the most frequently occurring number, use the MODE function. Standard Deviation To calculate the standard deviation, use the STEDV function. Note: standard deviation is a number that tells you how far numbers are from their mean.  Min To find the minimum value, use the MIN function. Max To find the maximum value, use the MAX function. Large To find the third largest number, use the following LARGE function. Check: Small To find the second smallest number, use the following SMALL function. Check:...

  List of all Excel functions translated from English to Spanish English Spanish ABS ABS ACCRINT INT.ACUM ACCRINTM INT.ACUM.V ACOS ACOS ACOSH ACOSH ACOT ACOT ACOTH ACOTH ADDRESS DIRECCION AGGREGATE AGREGAR AMORDEGRC AMORTIZ.PROGRE AMORLINC AMORTIZ.LIN AND Y ARABIC NUMERO.ARABE AREAS AREAS ASC ASC ASIN ASENO ASINH ASENOH ATAN ATAN ATAN2 ATAN2 ATANH ATANH AVEDEV DESVPROM AVERAGE PROMEDIO AVERAGEA PROMEDIOA AVERAGEIF PROMEDIO.SI AVERAGEIFS PROMEDIO.SI.CONJUNTO BAHTTEXT TEXTOBAHT BASE BASE BESSELI BESSELI BESSELJ BESSELJ BESSELK BESSELK BESSELY BESSELY BETA.DIST DISTR.BETA BETA.INV INV.BETA BETADIST DISTR.BETA BETAINV DISTR.BETA.INV BIN2DEC BIN.A.DEC BIN2HEX BIN.A.HEX BIN2OCT BIN.A.OCT BINOM.DIST DISTR.BINOM.N BINOM.DIST.RANGE DISTR.BINOM.SERIE BINOM.INV INV.BINOM BINOMDIST DISTR.BINOM BITAND BIT.Y BITLSHI...