Portfolio Correlations — The Answer
Back to Portfolio Correlations
AI Query
This is a chart of three ETFs performance compared to a mutual fund. My objective is to find the correlation between the fund and the ETFs. So I'm hoping you can approximate the values for the daily chart, build it into a table, detrend the four series, and do a multiple regression report on the data.
Fund and ETF correlation
Approximate daily chart reconstruction. About January to October 9. Year not visible.
196 inferred trading-day samples. Values represent plotted cumulative performance, not quoted prices.
| Fund correlation | XCG | XCV | XIC |
|---|---|---|---|
| Linear detrended | 0.69 | -0.02 | 0.59 |
| Daily returns | 0.78 | 0.49 | 0.83 |
| Cumulative levels | 0.67 | 0.27 | 0.52 |
| Detrended regression | Value | Daily return model | Value |
| Observations | 196 | Observations | 195 |
| R squared | 50.5% | R squared | 69.9% |
| Adjusted R squared | 49.7% | Adjusted R squared | 69.5% |
| Residual std. error | 1.62% | Residual std. error | 0.39% |
| Durbin-Watson | 0.09 | Durbin-Watson | 2.01 |
| Residual lag-1 corr. | 0.95 | Residual lag-1 corr. | -0.01 |
| Residual df | 191 | Residual df | 191 |
| Detrended predictor | Beta | OLS std. error | OLS p |
| XCG | 0.720 | 0.233 | 0.002 |
| XCV | 0.322 | 0.208 | 0.122 |
| XIC | -0.400 | 0.429 | 0.352 |
Results supplied for this presentation; the reconstruction and regression have not been rerun here. The supplied description says the year is not visible; the attached chart displays 2026.