Question

I have an upcoming exam, and based on the wording of the questions we are to us a certain Excel Function . Can you provide a list of assistance what to keywords or problems and what their Excel Function would be. For instance, i what functions would be for probability, what functions would be for sample sizes, Binomial, etc

Answer 1

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.

Mode

To find the most frequently occurring number, use the MODE function.

Standard Deviation

To calculate the standard deviation, use the STEDV function.

Formula

=NORMDIST(x,mean,standard_dev,cumulative)

The NORMDIST function uses the following arguments:

X (required argument) – It the value for which we wish to calculate the distribution.Mean (required argument) – It is the arithmetic mean of the distribution.Standard_dev (required argument) – It is the standard deviation of the distribution.Cumulative (required argument) – It is a logical value. It specifies the type of distribution to be used: TRUE (Cumulative Normal Distribution Function) and FALSE (Normal Probability Density Function).

What is frequency and its formula?

please be prepare

All the best for u r exam thanks....please like