Statistical Analysis with Excel-Chapter11

3 min readMar 24, 2022

This first part of the chapter is not so important but I still decided to cover these formulae that are actually under the Measures of Frequency.

I feel we use Excel so much and these are very frequently used so do not require any explanation.

Counting:

COUNT-Counts the number of cells that contain numerical data.

COUNTA-Count the number of cells that includes cells that contain text and logical values.

COUNTBLANK-counts the number of cells that are blank

COUNTIF-counts on the basis o a condition.
COUNTIFS-counts on the basis of conditions

Some more are:

MAX-gives the maximum value from the array

MAXA-gives the maximum value considering the text and logical values

MIN-minimum value from the group

MINA-minimum value from the group taking into account for logical and text data.

FREQUENCY-number of scores that fall into that interval

Let me explain this by taking small data set of scores.

Data Analysis Tool: Histogram

We can do the same thing by using the Histogram from the Data Analysis tool.

Finally, we are done with the basics of Statistics and together they are all called as Descriptive statistics.

I now will give a one-step solution to all the things we learned in all the last four chapters.

Data tab-Analysis group-Data Analysis tool-Descriptive statistics

Only two important calculations you see in the descriptive statistics are not previously explained as I have a reason to hold those topics, because I feel they should be learned after learning histogram.

Skewness and Kurtosis.

I always work with large datasets so for me knowing mean and variance is not helpful to describe data,so I go for other statistics,skewness and Kurtosis.

Skewness: indicates how symmetrically the scores are distributed.

Kurtosis:shows whether or not the scores are distributed with a peak in the neighborhood of the mean.