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?

Please include your research references in APA format.

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

COUNTIF function in Excel. Retrieved from https://www.excel-easy.com/examples/countif.html

POST 3:
Katherin Percca
The function that I use most of the time is sum, for example =Sum(B2:B16). I understand that financial and statistical functions are advance functions because they can combine functions to create a particular function that meet the certain conditions to work. There are many advance function that can simplify a statistical or financial job. For example, the SUMIF it will add the cells that meet a criteria, such as case when I want to add all the numbers in the cells except the ones that are greater or equal to 40 =SUMIF(B2:B26>=40).

There are other functions like Average, Vlookup, Min, Max, Countif, PMT functions that help a business to maintain and analyze information to growth as a company.
https://www.educba.com/advanced-excel-formulas-and-functions/

POST 4:
Caroline Testaverde
Excel provides an extensive range of Statistical Functions, that perform calculations from basic mean, median & mode to the more complex statistical distribution and probability tests. I chose the standard deviation (STDEF) function which I learned about in my statistics class last semester. The Standard Deviation is a statistical measure, that is used to identify the amount that a set of values differ (or deviate) from the average value. When your data set is a of a population, (rather than an entire population), you should use a slightly modified form of the Standard Deviation, known as the Sample Standard Deviation. The Excel STDEV function calculates the sample standard deviation of a supplied set of values. Exceljet.net. (2018). How to use the Excel STDEV function | Exceljet. [online] Available at: https://exceljet.net/excel-functions/excel-stdev-function [Accessed 27 Nov. 2018].