We can use two products at my work, which are mutual funds and see if there is a correlation between the two. The two different funds are: a domestic stock mutual fund, which only invests in large organizations (large cap companies) based here in the US and an international mutual fund, which only invests in large foreign-based companies. We can see the relationships between them and the magnitude of those relationships.
Date: USIFX Monthly 2006 USSPX Monthly 2006
Dec 1 27 21.24
Nov 1 28.91 21.05
Oct 2 28.1 20.66
Sept 1 27.54 20.01
Aug 1 27.49 19.59
Jul 3 26.57 19.14
Jun 1 26.01 19.03
May 1 25.84 19.09
Apr 3 26.79 19.65
Mar 1 25.63 19.40
Feb 1 24.90 19.24
Jan 3 24.95 19.19
Please see the attachments. Calculations are done in Excel.
The relationship between the two mutual funds can be illustrated in a scatter diagram
The scatter diagram suggests that there is a positive correlation between the two variables. The degree of relationship is measured by the correlation coefficient
Correlation = 0.753011296
The regression ...
The solution contains calculation of regression equation, coefficient of determination, confidence interval for regression coefficients and regression coefficients. Interpretation of the results are also given.
Regression Analysis: Random Selection
The expense ratio of a mutual fund measures the percentage of the fund's assets used to pay for annual administrative overhead. Funds with higher ratios spend more of the fund's return to operate the fund. A random selection of 16 stock mutual funds last year revealed the following data:
Expense Ratio, X
Total Return, Y
-Construct a scatter plot of the data. Clearly label each axis.
-Take the scatter plot created earlier and draw the least squares line on it.
-Find the equation for the least squares line of best fit.
-State the values of the regression coefficients (intercept and slope) and interpret what they mean. Does expense hurt or help the fund's return?
-Based on your regression analysis of the data, when is the average total return for a mutual fund with an expense ratio of 0.75%?