A mathematical technique is applied to a collection of cells in a worksheet using statistical functions. The SUM function, for example, is used to add the values in a set of cells. Table 2.4 shows a collection of regularly used statistical functions.
Microsoft Excel is a commonly used tool that is excellent for managing and manipulating data sets. Many people use Excel for statistical calculations since it offers statistical skills. Pace's excellent book (2008) provides a wealth of additional information (it can be purchased as a printed book, or as a pdf download).
When a mathematical operation is necessary for a group of cells, such as summing the values in many cell locations, statistical functions are used. Functions are preferable to formulas for these calculations because adding many cell positions to a formula one at a time can take a long time.
A successful Excel spreadsheet will organise raw data into a digestible format, making actionable insights easier to extract. Excel allows you to modify fields and functions that perform computations for you when working with more complex data.
Learner's Ratings
3.7
Overall Rating
48%
21%
5%
7%
19%
Reviews
R
Rao Zeeshan
5
best course
A
Adit kumar
4
very good class
W
Wasik Ahemmed Khan
4
practice file
P
pavan solanki
5
POWER BI AND DATA ANALYSIS
R
RAHUL KATHAD
5
****
J
Joy Dutta
4
sir course is awesome but the assignment not given
Share a personalized message with your friends.