To create a normal distribution in Excel, we can use the RAND function to create a standard deviate. RAND generates an evenly distributed random number greater than or equal to 0 and less than 1.
The average value of =RAND() is 0.5, but, for our purposes, we need a standard deviate centered on 0 instead.
The primary reason for generating the standard deviate using a macro is that you can write it, test it carefully, and then use the CALL function any time you need a standard normal deviate.
The variables you need to generate a symmetrical triangle distribution in Excel are the minimum, maximum, mode, and standard deviate. For example, a triangle distribution with a minimum value of $13,000, a maximum of $15,000, and a mode of $14,000 would have the following formula: =13000 + (ABS(A1) * (15000-13000) * (14000-13000))^0.5, where A1 is again the cell reference to the standard normal deviate.
The IRS requested comments about how the new standard deviates
from the tax revenue recognition rules, how taxpayers will be affected by the change, and what types of method changes, if any, would arise for tax purposes.