5. Market betas are typically computed with five years of monthly data or two years of weekly data. For computational simplicity, we present only 12 data points in Exhibit 13.13 for ConglomCo, a large conglomerate firm. Using a spreadsheet regression package or other software tool, compute a regression beta for ConglomCo.

EXHIBIT 13.13 ConglomCo and Market Returns %
ConglomCo Market Month 1 1.3 1.0 Month 2 2.0 1.2 Month 3 5.0 3.4 Month 4 (1.0) 0.3 Month 5 (1.4) (0.6)
Month 6 2.2 3.7 Month 7 6.1 4.8 Month 8 0.3 (2.3)
Month 9 (4.0) (4.5)
Month 10 3.8 3.9 Month 11 (1.2) (1.3)
Month 12 0.0 1.8