Excel offers statistical analysis functions which you can use to find and insert an array of values into a selected array of cells in an Excel worksheet. The following table tells you which function calculates the data array you want:
| Function | Calculates An Array Of … |
|---|---|
| FREQUENCY | Frequencies of values in a set of values |
| LINEST | Regression statistics based on linear regression through two or more sets of numbers |
| TREND | Numbers in a linear trend, based on known data points |
| LOGEST | Regression statistics based on curvilinear regression through two or more sets of numbers |
dummies
Source:http://www.dummies.com/how-to/content/excel-array-functions.html
No comments:
Post a Comment