Microsoft Office Tutorials and References
In Depth Information
■ The result range must be selected before you begin the function.
■ The function must be array entered by using Ctrl+Shift+Enter, instead of just pressing
The data_array is the list of student scores. The bins_array is the list of max scores
(G5:G9). Because this function always returns one more element than the number of
elements in the bins_array , the range selected for the frequencies is H5:H10.
Is the array of values for which you want to count frequencies
(the test scores in Figure 11.17).
Is the array of inter vals into which you want to group the values
in the data_array .
The range name Scores
is used here to identify
the data_array .
Selected cells to return
FTEST returns the result of an F-test.
This function is used to compare the variances in two data sets. Specifically, it returns the
onetailed probability that the variances are not significantly different. Figure 11.18 shows an
example of this function.
Is the first data set.
Is the second data set.
Data sets that contain text, logical values, or empty cells are ignored. However, if the data set
contains a zero, that value is included in the calculation.