Contents
Their “shared variance” is the amount that the variations of the two variables tend to overlap. The percentage of shared variance is represented by the square of the correlation coefficient, r2.
Sample variance formula in Excel
- Find the mean by using the AVERAGE function: =AVERAGE(B2:B7)
- Subtract the average from each number in the sample:
- Square each difference and put the results to column D, beginning in D2:
- Add up the squared differences and divide the result by the number of items in the sample minus 1:
How to calculate the shared variance of two variables?
Because X1 and X2 are uncorrelated, we can calculate the shared variance between the two X variables and Y by summing the squared correlations. In our example, the shared variance would be .502+.602= .25+.36 = .61. This turns out to be 61 percent shared variance, and if we calculated a regression equation, we would find that R2was .61.
Shared variance is computed by subtracting the uniquely explained variance from the R square. F (4, 91) = 10.941, p = .0005. The semipartial correlation values are (significant predictors indicated by*, from the ‘Part’ column in SPSS output):
What is the squared correlation between two variables?
The size of the (squared) correlation between two variables is indicated by the overlap in circles. Recall that the squared correlation is the proportion of shared variance between two variables. In Figure 5.1, X1 and X2 are not correlated. This is indicated by the lack of overlap in the two variables.
How is variance accounted for in simple regression?
In simple regression, we have one IV that accounts for a proportion of variance in Y. The influence of this variable (how important it is in predicting or explaining Y) is described by r or by r2. If r2is 1.0, we know that the DV can be predicted perfectly from the IV; all of the variance in the DV is accounted for.