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...
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...
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.
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...
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.
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...
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.