A] Calculating Weighted Average when the weights add up to 100%. The above image shows the data set where the weights add up to 100%. To calculate the weighted average of this data set in Excel ...

To calculate this weighted average, first input the two values for the number of shares outstanding into adjacent cells. In our example, during January, there were 150,000 shares, so this value is ...

The article How to Calculate an Average Percentage Difference Between Two Dollar Amounts originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .

In calculating a weighted average, each number in the data set is multiplied by a predetermined weight before the final calculation is made. A weighted average is most often computed to equalize ...

With Excel and data from your broker, however, calculating the average return is fairly easy using the XIRR function. How to calculate average stock returns in Excel.

Plotting the frequency of data falling within numeric ranges illustrates the diversity of your data. As an example, a teacher might wish to calculate and display her students' grades by tabulating ...

A moving average can be used to provide support in an uptrend, the average can act as a base ground or 'support'. In a downtrend, a moving average can act as resistance, or a 'ceiling'. How to ...

Calculate annual % change by dividing start by end value, raising to inverse years, minus one, times 100. Ex: a drop from $15M to $10M over 2 years is a 18.4% average annual decline. This ...