FREQUENCY(data_array,bins_array)
Where data_array is the population of values and bins_array is the set of
intervals into which the values in data_array
are grouped. Blank cells and text are ignored.
In the illustration, there are 29
observations in the frequency distribution but there are 33 values in the
population, the values greater than the top bin limit are not reported.
Dynamic
Transposition
You can use Edit,
Paste Special, Transpose to shift the vertical and horizontal orientation
of a range of cells on a worksheet but the results of the transposition are
static and you would have to repeat the transposition if the original values
were changed. To return the transposed results as a dynamic formula you
need to use the TRANSPOSE function:
The first row of array becomes the first column of the
returned array. Any changes made in
the range of cells A1:D4 are reflected in the array of cells, B6:E9.
For Further Course Details Visit Our Homepage
Microsoft Accredited IT Training Provider
Microsoft Certified Training Materials
IT Training Courses delivered by Microsoft Accredited Facilitators
Microsoft MOS Test Centre London
No comments:
Post a Comment