Microsoft Office Tutorials and References
In Depth Information
FTEST
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
Enter.
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).
DATA_ARRAY
Is the array of inter vals into which you want to group the values
in the data_array .
BINS_ARRAY
Figure 11.17
The range name Scores
is used here to identify
the data_array .
B
bins_array
1
data_array
3
Selected cells to return
the frequency_array
FTEST
FTEST returns the result of an F-test.
=FTEST(array1,array2)
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.
ARRAY1
Is the second data set.
ARRAY2
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.
Search JabSto ::




Custom Search