Directions. Access https://auciello.tripod.com/701-math-trig-stat.xls by clicking its name. This brings up
a worksheet that looks like:
Next click Help, Microsoft Excel Help. Type "Function" for keyword as I did below:
Open Excel, click Help, click Microsoft Excel
Help, and enter "function" as a Keyword, then click "function" ...
Then click "Math and Trignometry" ...
which gives the list on the left column below:
List of Math and Trignometric Functions in EXCEL: | List of Statistical Functions in EXCEL: |
ABS Returns the absolute value of a number |
AVEDEV Returns the average of the absolute deviations of data points from their mean |
ACOS Returns the arccosine of a number |
AVERAGE Returns the average of its arguments |
ACOSH Returns the inverse hyperbolic cosine of a number |
AVERAGEA Returns the average of its arguments, including numbers, text, and logical values |
ASIN Returns the arcsine of a number |
BETADIST Returns the cumulative beta probability density function |
ASINH Returns the inverse hyperbolic sine of a number |
BETAINV Returns the inverse of the cumulative beta probability density function |
ATAN Returns the arctangent of a number |
BINOMDIST Returns the individual term binomial distribution probability |
ATAN2 Returns the arctangent from x- and y-coordinates |
CHIDIST Returns the one-tailed probability of the chi-squared distribution |
ATANH Returns the inverse hyperbolic tangent of a number |
CHIINV Returns the inverse of the one-tailed probability of the chi-squared distribution |
CEILING Rounds a number to the nearest integer or to the nearest multiple of significance |
CHITEST Returns the test for independence |
COMBIN Returns the number of combinations for a given number of objects |
CONFIDENCE Returns the confidence interval for a population mean |
COS Returns the cosine of a number |
CORREL Returns the correlation coefficient between two data sets |
COSH Returns the hyperbolic cosine of a number |
COUNT Counts how many numbers are in the list of arguments |
COUNTIF Counts the number of nonblank cells within a range that meet the given criteria |
COUNTA Counts how many values are in the list of arguments |
DEGREES Converts radians to degrees |
COVAR Returns covariance, the average of the products of paired deviations |
EVEN Rounds a number up to the nearest even integer |
CRITBINOM Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value |
EXP Returns e raised to the power of a given number |
DEVSQ Returns the sum of squares of deviations |
FACT Returns the factorial of a number |
EXPONDIST Returns the exponential distribution |
FACTDOUBLE Returns the double factorial of a number |
FDIST Returns the F probability distribution |
FLOOR Rounds a number down, toward zero |
FINV Returns the inverse of the F probability distribution |
GCD Returns the greatest common divisor |
FISHER Returns the Fisher transformation |
INT Rounds a number down to the nearest integer |
FISHERINV Returns the inverse of the Fisher transformation |
LCM Returns the least common multiple |
FORECAST Returns a value along a linear trend |
LN Returns the natural logarithm of a number |
FREQUENCY Returns a frequency distribution as a vertical array |
LOG Returns the logarithm of a number to a specified base |
FTEST Returns the result of an F-test |
LOG10 Returns the base-10 logarithm of a number |
GAMMADIST Returns the gamma distribution |
MDETERM Returns the matrix determinant of an array |
GAMMAINV Returns the inverse of the gamma cumulative distribution |
MINVERSE Returns the matrix inverse of an array |
GAMMALN Returns the natural logarithm of the gamma function, Γ(x) |
MMULT Returns the matrix product of two arrays |
GEOMEAN Returns the geometric mean |
MOD Returns the remainder from division |
GROWTH Returns values along an exponential trend |
MROUND Returns a number rounded to the desired multiple |
HARMEAN Returns the harmonic mean |
MULTINOMIAL Returns the multinomial of a set of numbers |
HYPGEOMDIST Returns the hypergeometric distribution |
ODD Rounds a number up to the nearest odd integer |
INTERCEPT Returns the intercept of the linear regression line |
PI Returns the value of pi |
KURT Returns the kurtosis of a data set |
POWER Returns the result of a number raised to a power |
LARGE Returns the k-th largest value in a data set |
PRODUCT Multiplies its arguments |
LINEST Returns the parameters of a linear trend |
QUOTIENT Returns the integer portion of a division |
LOGEST Returns the parameters of an exponential trend |
RADIANS Converts degrees to radians |
LOGINV Returns the inverse of the lognormal distribution |
RAND Returns a random number between 0 and 1 |
LOGNORMDIST Returns the cumulative lognormal distribution |
RANDBETWEEN Returns a random number between the numbers you specify |
MAX Returns the maximum value in a list of arguments |
ROMAN Converts an arabic numeral to roman, as text |
MAXA Returns the maximum value in a list of arguments, including numbers, text, and logical values |
ROUND Rounds a number to a specified number of digits |
MEDIAN Returns the median of the given numbers |
ROUNDDOWN Rounds a number down, toward zero |
MIN Returns the minimum value in a list of arguments |
ROUNDUP Rounds a number up, away from zero |
MINA Returns the smallest value in a list of arguments, including numbers, text, and logical values |
SERIESSUM Returns the sum of a power series based on the formula |
MODE Returns the most common value in a data set |
SIGN Returns the sign of a number |
NEGBINOMDIST Returns the negative binomial distribution |
SIN Returns the sine of the given angle |
NORMDIST Returns the normal cumulative distribution |
SINH Returns the hyperbolic sine of a number |
NORMINV Returns the inverse of the normal cumulative distribution |
SQRT Returns a positive square root |
NORMSDIST Returns the standard normal cumulative distribution |
SQRTPI Returns the square root of (number * pi) |
NORMSINV Returns the inverse of the standard normal cumulative distribution |
SUBTOTAL Returns a subtotal in a list or database |
PEARSON Returns the Pearson product moment correlation coefficient |
SUM Adds its arguments |
PERCENTILE Returns the k-th percentile of values in a range |
SUMIF Adds the cells specified by a given criteria |
PERCENTRANK Returns the percentage rank of a value in a data set |
SUMPRODUCT Returns the sum of the products of corresponding array components |
PERMUT Returns the number of permutations for a given number of objects |
SUMSQ Returns the sum of the squares of the arguments |
POISSON Returns the Poisson distribution |
SUMX2MY2 Returns the sum of the difference of squares of corresponding values in two arrays |
PROB Returns the probability that values in a range are between two limits |
SUMX2PY2 Returns the sum of the sum of squares of corresponding values in two arrays |
QUARTILE Returns the quartile of a data set |
SUMXMY2 Returns the sum of squares of differences of corresponding values in two arrays |
RANK Returns the rank of a number in a list of numbers |
TAN Returns the tangent of a number |
RSQ Returns the square of the Pearson product moment correlation coefficient |
TANH Returns the hyperbolic tangent of a number |
SKEW Returns the skewness of a distribution |
TRUNC Truncates a number to an integer |
SLOPE Returns the slope of the linear regression line |
|
SMALL Returns the k-th smallest value in a data set |
|
STANDARDIZE Returns a normalized value |
|
STDEV Estimates standard deviation based on a sample |
|
STDEVA Estimates standard deviation based on a sample, including numbers, text, and logical values |
|
STDEVP Calculates standard deviation based on the entire population |
|
STDEVPA Calculates standard deviation based on the entire population, including numbers, text, and logical values |
|
STEYX Returns the standard error of the predicted y-value for each x in the regression |
|
TDIST Returns the Student's t-distribution |
|
TINV Returns the inverse of the Student's t-distribution |
|
TREND Returns values along a linear trend |
|
TRIMMEAN Returns the mean of the interior of a data set |
|
TTEST Returns the probability associated with a Student's t-test |
|
VAR Estimates variance based on a sample |
|
VARA Estimates variance based on a sample, including numbers, text, and logical values |
|
VARP Calculates variance based on the entire population |
|
VARPA Calculates variance based on the entire population, including numbers, text, and logical values |
|
WEIBULL Returns the Weibull distribution |
|
ZTEST Returns the two-tailed P-value of a z-test |
Grading: 20 points for using each function, for example, ABS (returns the Absolute Value of a number which means "remove" the minus or plus sign, considering the number as a value in magnitude, not direction.) The absolute value of (-3) would, of course, be 3. In Excel, you would write =ABS(-3). The "=" sign says that you are starting a formula. All Excel formulas start with an "equal" sign.
When you type =ABS(-3) into a cell, you are saying "return to me the absolute value of -3", then pressing the <Enter> key, the value of "3" appears. Try it now. If you can't get this to work, stop this lesson now, and contact your instructor!
If you can get this to work, you may proceed to do this for each of the functions listed below, do it on a spreadsheet, making it look like this example.
Let me know if any problems: joseph@auciello.net