y = 0.9588x + 0.0026
R² = 0.3615
6.00%
8.00%
10.00%
FIGURE 16.8: Stock-price Beta Estimation for Google, Inc. (GOOG)
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.60122173
ANOVA
df SS MS F Significance F
Regression 1 0.019778188 0.01977819 28.3045589 2.43845E-06
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
TABLE 16.5 Weekly Return Data for Google, Inc., (GOOG) and the Nasdaq Index
Date
GOOG
Close
GOOG
Weekly
Return
Nasdaq
Close
29-May-07 497.91 2.98% 2,604.52 1.85%
12-Mar-07 440.85 -2.67% 2,372.66 -0.62%
5-Mar-07 452.96 3.26% 2,387.55 0.83%
26-Feb-07 438.68 -6.79% 2,368.00 -5.85%
20-Feb-07 470.62 0.14% 2,515.10 0.75%
12-Feb-07 469.94 1.74% 2,496.31 1.48%
27-Nov-06 480.80 -4.79% 2,413.21 -1.91%
20-Nov-06 505.00 1.25% 2,460.26 0.59%
13-Nov-06 498.79 5.33% 2,445.86 2.35%
6-Nov-06 473.55 0.37% 2,389.72 2.53%
30-Oct-06 471.80 -0.72% 2,330.79 -0.84%
14-Aug-06 383.36 4.03% 2,163.95 5.16%
7-Aug-06 368.50 -1.43% 2,057.71 -1.31%
31-Jul-06 373.85 -3.68% 2,085.05 -0.43%
24-Jul-06 388.12 -0.51% 2,094.14 3.65%
17-Jul-06 390.11 -3.32% 2,020.39 -0.83%
10-Jul-06 403.50 -4.03% 2,037.35 -4.35%