Any one statistical function
give the name of following
Answers
Answer:
this is statistical function
Explanation:
hope you help
Answer:
Explanation:
n 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.
Table 2.4 Commonly Used Statistical Functions
Function Output
ABS The absolute value of a number
AVERAGE The average or arithmetic mean for a group of numbers
COUNT The number of cell locations in a range that contain a numeric character
COUNTA The number of cell locations in a range that contain a text or numeric character
MAX The highest numeric value in a group of numbers
MEDIAN The middle number in a group of numbers (half the numbers in the group are higher than the median and half the numbers in the group are lower than the median)
MIN The lowest numeric value in a group of numbers
MODE The number that appears most frequently in a group of numbers
PRODUCT The result of multiplying all the values in a range of cell locations
SQRT The positive square root of a number
STDEV.S The standard deviation for a group of numbers based on a sample
SUM The total of all numeric values in a group
The SUM Function
Follow-along file: Continue with Excel Objective 2.00. (Use file Excel Objective 2.03 if starting here.)
Lesson Video: SUM Function
(click to see video)
The SUM function is used when you need to calculate totals for a range of cells or a group of selected cells on a worksheet. With regard to the Budget Detail worksheet, we will use the SUM function to calculate the totals in row 12. It is important to note that there are several methods for adding a function to a worksheet, which will be demonstrated throughout the remainder of this chapter. The following illustrates how a function can be added to a worksheet by typing it into a cell location:
Click the Budget Detail worksheet tab to open the worksheet.
Click cell C12.
Type an equal sign (=).
Type the function name SUM.
Type an open parenthesis (().
Click cell C3 and drag down to cell C11. This places the range C3:C11 into the function.
Type a closing parenthesis ()).
Press the ENTER key. The function calculates the total for the Monthly Spend column, which is $1,496.
Figure 2.11 "Adding the SUM Function to the Budget Detail Worksheet" shows the appearance of the SUM function added to the Budget Detail worksheet before pressing the ENTER key.
Figure 2.11 Adding the SUM Function to the Budget Detail Worksheet
As shown in Figure 2.11 "Adding the SUM Function to the Budget Detail Worksheet", the SUM function was added to cell C12. However, this function is also needed to calculate the totals in the Annual Spend and LY Spend columns. The function can be copied and pasted into these cell locations because of relative referencing. Relative referencing serves the same purpose for functions as it does for formulas. The following demonstrates how the total row is completed:
Click cell C12 in the Budget Detail worksheet.
Click the Copy button in the Home tab of the Ribbon.
Highlight cells D12 and E12.
Click the Paste button in the Home tab of the Ribbon. This pastes the SUM function into cells D12 and E12 and calculates the totals for these columns.
Click cell F11.
Click the Copy button in the Home tab of the Ribbon.
Click cell F12, then click the Paste button in the Home tab of the Ribbon. Since we now have totals in row 12, we can paste the percent change formula into this row.
Figure 2.12 "Results of the SUM Function in the Budget Detail Worksheet" shows the output of the SUM function that was added to cells C12, D12, and E12. In addition, the percent change formula was copied and pasted into cell F12.When you intend to use a statistical function on a range of cells in a worksheet, make sure there are two cell locations separated by a colon and not a comma. If you enter two cell locations separated by a comma, the function will produce an output but it will be applied to only two cell locations instead of a range of cells. For example, the SUM function shown in Figure 2.13 "SUM Function Adding Two Cell Locations" will add only the