Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
Note that if you create a line chart from A1:B23, you can right-click the line,
choose Add Trendline. In the Options tab of the dialog, ask for Excel to add the
equation to the chart. This will describe the slope and y-intercept.
FREQUENCY(data_array,bins_array) [Category: Statistical]]
Calculates how often values occur within a range of values, and then returns a
vertical array of numbers. For example, use FREQUENCY to count the number
of test scores that fall within ranges of scores. Because FREQUENCY returns
an array, it must be entered as an array formula. Guru Tip: This is a tough
function to set up. In my example, I have 1000 test results in A2:A1001. In D2:
D11, I enter a series of bin values. To see scores less than 10, I enter 10 in D2.
To see scores between 10 and 20, I enter 20 in D3, and so on down to 100 in
D11. Then, to compute the frequency distribution, select E2:E12 (one more row
than you have in the bins range). Type =FREQUENCY($A$2:$A$1001,$D$2:$