explain the simple statistical function
long answer type question
Answers
Answered by
2
LEARNING OBJECTIVES
Use the SUM function to calculate totals.
Use absolute references to calculate percent of totals.
Use the COUNT function to count cell locations with numerical values.
Use the AVERAGE function to calculate the arithmetic mean.
Use the MAX and MIN functions to find the highest and lowest values in a range of cells.
Learn how to copy and paste formulas without formats applied to a cell location.
Learn how to set a multiple level sort sequence for data sets that have duplicate values or outputs.
In addition to formulas, another way to conduct mathematical computations in Excel is through functions. Statistical functions apply a mathematical process to a group of cells in a worksheet. For example, the SUM function is used to add the values contained in a range of cells. A list of commonly used statistical functions is shown in Table 2.4 "Commonly Used Statistical Functions". Functions are more efficient than formulas when you are applying a mathematical process to a group of cells. If you use a formula to add the values in a range of cells, you would have to add each cell location to the formula one at a time. This can be very time-consuming if you have to add the values in a few hundred cell locations. However, when you use a function, you can highlight all the cells that contain values you wish to sum in just one step. This section demonstrates a variety of statistical functions that we will add to the Personal Budget workbook. In addition to demonstrating functions, this section also reviews percent of total calculations and the use of absolute references.
Use the SUM function to calculate totals.
Use absolute references to calculate percent of totals.
Use the COUNT function to count cell locations with numerical values.
Use the AVERAGE function to calculate the arithmetic mean.
Use the MAX and MIN functions to find the highest and lowest values in a range of cells.
Learn how to copy and paste formulas without formats applied to a cell location.
Learn how to set a multiple level sort sequence for data sets that have duplicate values or outputs.
In addition to formulas, another way to conduct mathematical computations in Excel is through functions. Statistical functions apply a mathematical process to a group of cells in a worksheet. For example, the SUM function is used to add the values contained in a range of cells. A list of commonly used statistical functions is shown in Table 2.4 "Commonly Used Statistical Functions". Functions are more efficient than formulas when you are applying a mathematical process to a group of cells. If you use a formula to add the values in a range of cells, you would have to add each cell location to the formula one at a time. This can be very time-consuming if you have to add the values in a few hundred cell locations. However, when you use a function, you can highlight all the cells that contain values you wish to sum in just one step. This section demonstrates a variety of statistical functions that we will add to the Personal Budget workbook. In addition to demonstrating functions, this section also reviews percent of total calculations and the use of absolute references.
FuturePoet:
super
Similar questions