# Statistical Analysis in Finance

## Probability Distributions

By the end of this section, you will be able to:
1. Calculate portfolio weights in an investment.
2. Calculate and interpret the expected values.
3. Apply the normal distribution to characterize average and standard deviation in financial contexts.

### Calculate Portfolio Weights

In many financial analyses, the weightings by asset category in a portfolio are a key index used to assess if the portfolio is meeting allocation metrics. For example, an investor approaching retirement age may wish to shift assets in a portfolio to more conservative and lower-volatility investments. Weightings can be calculated in several different ways—for example, based on individual stocks in a portfolio or on various sectors in a portfolio. Weightings can also be calculated based on number of shares or the value of shares of a stock.
To calculate a weighting in a portfolio based on value, take the value of the particular investment and divide it by the total value of the overall portfolio. As an example, consider an individual’s retirement account for which the desired portfolio weighting is determined to be 40% stocks, 50% bonds, and 10% cash equivalents.  shows the current assets in the individual’s portfolio, broken out according to stocks, bonds, and cash equivalents.
To determine the weighting in this portfolio for stocks, bonds, and cash, take the total value for each category and divide it by the total value of the entire portfolio. These results are summarized in . Notice that the portfolio weightings shown in the table do not match the target, or desired, allocation weightings of 40% stocks, 50% bonds, and 10% cash equivalents.
Portfolio rebalancing is a process whereby the investor buys or sells assets to achieve the desired portfolio weightings. In this example, the investor could sell approximately 10% of the stock assets and purchase bonds with the proceeds to align the asset categories to the desired portfolio weightings.

### Calculate and Interpret Expected Values

A probability distribution is a mathematical function that assigns probabilities to various outcomes. For example, we can assign a probability to the outcome of a certain stock increasing in value or decreasing in value. One application of a probability distribution function is determining expected value.
In many financial situations, we are interested in determining the expected value of the return on a particular investment or the expected return on a portfolio of multiple investments. To calculate expected returns, we formulate a probability distribution and then use the following formula to calculate expected value:
where P1, P2, P3, ⋯ P are the probabilities of the various returns and R1, R2, R3, ⋯ R are the various rates of return.
In essence, expected value is a weighted mean where the probabilities form the weights. Typically, these values for P and R are derived from historical data. As an example, consider a probability distribution for potential returns for United Airlines common stock. Assume that from historical data gathered over a certain time period, there is a 15% probability of generating a 12% return on investment for this stock, a 35% probability of generating a 5% return, a 25% probability of generating a 2% return, a 14% probability of generating a 5% loss, and an 11% probability of resulting in a 10% loss. This data can be organized into a probability distribution table as seen in .
Using the expected value formula, the expected return of United Airlines stock over an extended period of time 
       follows:
Based on the probability distribution, the expected value of the rate of return for United Airlines common stock over an extended period of time is 2.25%.
We can extend this analysis to evaluate the expected return for an investment portfolio consisting of various asset categories, such as stocks, bonds, and cash equivalents, where the probabilities are associated with the weighting of each category relative to the total value of the portfolio. Using historical return data for each of the asset categories, the expected return of the overall portfolio can be calculated using the expected value formula.
Assume an investor has assets in stocks, bonds, and cash equivalents as shown in .
Based on the probability distribution, the expected value of the rate of return for this portfolio over an extended period of time is 8.44%.

### Apply the Normal Distribution in Financial Contexts

The normal, or bell-shaped, distribution can be utilized in many applications, including financial contexts. Remember that the normal distribution has two parameters: the mean, which is the center of the distribution, and the standard deviation, which measures the spread of the distribution. Here are several examples of applications of the normal distribution:
1. IQ scores follow a normal distribution, with a mean IQ score of 100 and a standard deviation of 15.
2. Salaries at a certain company follow a normal distribution, with a mean salary of $52,000 and a standard deviation of $4,800.
3. Grade point averages (GPAs) at a certain college follow a normal distribution, with a mean GPA of 3.27 and a standard deviation of 0.24.
4. The average annual gain of the Dow Jones Industrial Average (DJIA) over a 40-year time period follows a normal distribution, with a mean gain of 485 points and a standard deviation of 1,065 points.
5. The average annual return on the S&P 500 over a 50-year time period follows a normal distribution, with a mean rate of return of 10.5% and a standard deviation of 14.3%.
6. The average annual return on mid-cap stock funds over the five-year period from 2010 to 2015 follows a normal distribution, with a mean rate of return of 8.9% and a standard deviation of 3.7%.
When analyzing data sets that follow a normal distribution, probabilities can be calculated by finding areas under the normal curve. To find the probability that a measurement is within a specific interval, we can compute the area under the normal curve corresponding to the interval of interest.
Areas under the normal curve are available in tables, and Excel also provides a method to find these areas. The empirical rule is one method for determining areas under the normal curve that fall within a certain number of standard deviations of the mean (see ).
If x is a random variable and has a normal distribution with mean µ and standard deviation , then the empirical rule states the following:
1. About 68% of the x-values lie between  and  units from the mean   (within one standard deviation of the mean).
2. About 95% of the x-values lie between  and  units from the mean  (within two standard deviations of the mean).
3. About 99.7% of the x-values lie between  and  units from the mean  (within three standard deviations of the mean). Notice that almost all the x-values lie within three standard deviations of the mean.
4. The z-scores for  and  are  and , respectively.
5. The z-scores for  and  are  and , respectively.
6. The z-scores for  and  are  and , respectively.
As an example of using the empirical rule, suppose we know that the average annual return for mid-cap stock funds over the five-year period from 2010 to 2015 follows a normal distribution, with a mean rate of return of 8.9% and a standard deviation of 3.7%. We are interested in knowing the likelihood that a randomly selected mid-cap stock fund provides a rate of return that falls within one standard deviation of the mean, which implies a rate of return between 5.2% and 12.6%. Using the empirical rule, the area under the normal curve within one standard deviation of the mean is 68%. Thus, there is a probability, or likelihood, of 0.68 that a mid-cap stock fund will provide a rate of return between 5.2% and 12.6%.
If the interval of interest is extended to two standard deviations from the mean (a rate of return between 1.5% and 16.3%), using the empirical rule, we can determine that the area under the normal curve within two standard deviations of the mean is 95%. Thus, there is a probability, or likelihood, of 0.95 that a mid-cap stock fund will provide a rate of return between 1.5% and 16.3%.

### 

A probability distribution is a mathematical function that assigns probabilities to various outcomes. In many financial situations, we are interested in determining the expected value of the return on a particular investment or the expected return on a portfolio of multiple investments. When analyzing distributions that follow a normal distribution, probabilities can be calculated by finding the area under the graph of the normal curve.

### 


### 


### 


### Portfolio Weights
