spreadsheet
typeScript/javascript spreadsheet parser, with formulas.
git clone https://git.vogt.world/spreadsheet.git
Log | Files | README.md
← All files
name: dist/Formulas/Range.d.ts
-rw-r--r--
1502
 1/**
 2 * Calculates the frequency distribution of a range into specified classes or "bins".
 3 * @param range - to get frequency for.
 4 * @param bins - or classes.
 5 * @returns {Array<number>}
 6 * @constructor
 7 * TODO: Returns ColumnArray (values stacked in Y-direction)
 8 */
 9declare let FREQUENCY: (range: any, bins: any) => number[];
10/**
11 * Given partial data with exponential growth, fits and ideal exponential growth trend, and predicts future values. For
12 * more information see: https://xkcd.com/1102/
13 * @param knownY - The range or array containing the dependent, y, values that are known, and will be used to fit an
14 * ideal exponential growth curve.
15 * @param knownX - OPTIONAL - The range or values of the independent variables that correspond to knownY.
16 * @param newX - OPTIONAL - The range, values, or data-points to return the y-values on the ideal curve fit.
17 * @param shouldUseConstant - OPTIONAL - True by default. Given an exponential function y = b*m^x, should this function
18 * calculate b?
19 * @returns {Array}
20 * @constructor
21 * TODO: Returns RowArray (values stacked in X-direction)
22 */
23declare let GROWTH: (knownY: any, knownX?: any, newX?: any, shouldUseConstant?: any) => any[];
24/**
25 * Returns the parameters of a linear trend.
26 * @param dataY - The range of data representing Y values.
27 * @param dataX - The range of data representing X values.
28 * @returns {number[]}
29 * @constructor
30 */
31declare let LINEST: (dataY: any, dataX: any) => number[];
32export { FREQUENCY, GROWTH, LINEST };