Call/WhatsApp: +1 914 416 5343

## Posts & Questions

FIRST PART
WEEK 5: SPECIALIZED AND STATISTICAL FUNCTIONS

11 11 unread replies. 16 16 replies.
Functions in Excel are grouped for easy reference. Locate the Statistical Functions group and select one of these functions. What is it? What does it do?

SECOND PART:

Second part is reply to 4 discussion posts on your own words with comment .

POST 1:
Darlene Dunn

I have used most of these in our labs that we have created since week 1. However, I have not used in any in my personal or professional area of life. My job creates and sends down all of our data per store for us on spreadsheets so that we can see the day before totals when we arrive on the next business day. So, I have more experience spreadsheets and not actually creating spreadsheets. Creating a spreadsheet has been a little difficult for me for this session. I think there are some functions I have grasped really well and others I am having a hard time with. I think that when doing this weeks lab the average and mean function will be helpful for calculating totals in our spreadsheets.

Average Function in Excel (Mean)
One of the most used statistical functions in Excel is Average. Calculating the Average in Excel is much simpler than it was in the school. Simply use the Average function and select the range which needs to be averaged. In the example below we want to know the average of the marks obtained by the students so we use =AVERAGE(B2:B12).

POST 2:
Eve Manukyan

Excel COUNTIF function is used for counting cells within a specified range that meet a certain criterion, or condition.

For example, you can write a COUNTIF formula to find out how many cells in worksheet contain a number greater than or less than the number specified or counting cells with a specific word or starting with a particular letter.

The syntax of the COUNTIF function is very simple:

COUNTIF(range, criteria)

There are two arguments and both are required:

range – The range of cells to count.
criteria – The criteria that controls which cells should be counted

Some examples:

=COUNTIF(A1:A10,10) (count cells equal to 10)

=COUNTIF(A1:A10,”>2″) (count cells greater than 2)

=COUNTIF(A1:A10,”Miami”) (count cells equal to “Miami”)

Reference