ARTICLES

A "what if" analysis occurs when a Microsoft Excel user changes the values of cells to see alterations of formulaic outcomes elsewhere on the worksheet. As of November 2014, three different types of "what if" analysis to...

www.reference.com/article/analysis-a7f46f0a62297e2f

Variance analysis accounts for discrepancies between planned events and what actually takes place. It is generally performed at the end of each fiscal month and reported to management. Variance analysis is particularly u...

www.reference.com/article/variance-analysis-7ecbbd6aeb3dc8f

Pedigree analysis is the process of examining a pedigree to determine the pattern of inheritance for a trait. Pedigrees are often used to determine if a trait is dominant or recessive.

www.reference.com/science/pedigree-analysis-86ea9b8987c4302f

SIMILAR ARTICLES

While Microsoft Excel does not have a built-in function to find percentage increase between values, a user simply needs to enter the formula "=(B-A)/ABS(A)," where B is the baseline value, and A is the new value. The fun...

www.reference.com/article/percentage-increase-formula-excel-spreadsheet-3f0e5d5538e9081c

Find accounting worksheet templates for Microsoft Excel on Double-Entry-Bookkeeping.com and Vertex42.com as of 2015. Both websites allow visitors to download templates such as journals and budgets for free.

www.reference.com/article/can-accounting-worksheet-templates-excel-108b8c551807c84c

Completing statistical analysis in Microsoft Excel requires multiple steps, including getting the data into the program, activating the statistical analysis functions and determining the confidence interval. Excel includ...

www.reference.com/article/excel-used-critical-t-value-988703f0e4a6277a

To perform a linear regression in Microsoft Excel, input a set of values, for both the y-axis and the x-axis. A scatter plot will be produced, followed by a "Linear" trend-line to depict the regression.

www.reference.com/article/perform-linear-regression-excel-db0df7f50d9a4424