Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

bytes each character uses, from the ﬁ rst character of within_text. This function

is for use with double-byte characters. You can also use SEARCHB to ﬁ nd one

text string within another.

FINV(probability,degrees_freedom1,degrees_freedom2) [Category:

Statistical]]

Returns the inverse of the F probability distribution. If p = FDIST(x,...), then

FINV(p,...) = x.

FISHER(x) [Category: Statistical]]

Returns the Fisher transformation at x. This transformation produces a function

that is approximately normally distributed rather than skewed. Use this function

to perform hypothesis testing on the correlation coefﬁ cient.

FISHERINV(y) [Category: Statistical]]

Returns the inverse of the Fisher transformation. Use this transformation when

analyzing correlations between ranges or arrays of data. If y = FISHER(x), then

FISHERINV(y) = x.

FIXED(number,decimals,no_commas) [Category: Text]

Rounds a number to the speciﬁ ed number of decimals, formats the number in

decimal format using a period and commas, and returns the result as text. Guru

Tip: =TEXT(number,"0.00") would do the same thing, with additional ﬂ exibility.

FLOOR(number,signiﬁ cance) [Category: Math]

Rounds number down, toward zero, to the nearest multiple of signiﬁ cance. Guru

Tip: CEILING will round up to the nearest nickel, which seems a more likely

scenario.

FORECAST(x,known_y’s,known_x’s) [Category: Statistical]]

Calculates, or predicts, a future value by using existing values. The predicted

value is a y-value for a given x-value. The known values are existing x-values

and y-values, and the new value is predicted by using linear regression. You can

use this function to predict future sales, inventory requirements, or consumer

trends. Guru Tip: FORECAST is used with linear progression. Cells B25:B29 of

this image use FORECAST to predict future sales. This is theoretically easier

than calculating =INTERCEPT()+SLOPE()*A25. Also see LINEST, INTERCEPT,

SLOPE.