Microsoft Excel Formulas
-
Beta Probability Density Calculations with Microsoft Excel
Microsoft Excel supplies two useful statistical functions for making beta probability calculations, BETADIST and BETAINV. Perhaps surprisingly, neither function is difficult to use as long as understand the inputs that supply data to the function. Understanding the beta probability density function, BETADIST The BETADIST function returns the cumulative beta probability density function. Statisticians often use the cumulative beta probability d Read More... -
Fisher Transformations and Frequency Distributions with Microsoft Excel
Want to work with fisher transformations or frequency distributions? Microsoft Excel supplies some useful functions, including FISHER, FISHERINV and FREQUENCY. Fisher Transformations using the FISHER and FISHERINV Functions The Fisher's z' transformation converts Pearson's r to the normally distributed variable z'. You use the Fisher's z' to compute confidence intervals on Pearson's correlation and on the difference between correlations. The Read More... -
Understanding How Microsoft Excel Organizes To-Be-Charted Data
How Excel Sees Chart Data To easily use Excel for charting, you need to learn three key terms: data points, data series, and data categories. Data Points are the Basic Building Blocks The individual values you plot in a chart are called data points. Because a chart visually represents one or more numeric values, data points are always values. Note, however, that most Excel formula results are also numeric, which means that you can also plot fo Read More...
RELATED ARTICLES