Share
Explore BrainMass

Beta calculation for a publicly traded company

A publicly traded construction company has had the following stock prices (in attached spreadsheet), the index prices are also available (second page of spreadsheet). calculate the beta using Linest.
The market beta is 1.20. If the calculated beta varies from published, explain why.

Stock Prices:
Date,Open,High,Low,Close,Volume,Adj Close
11/23/09,14.52,14.85,14.38,14.79,41146700,14.79
11/20/09,14.65,14.69,14.24,14.29,94469500,14.29
11/19/09,15.98,16,15.65,15.87,38639600,15.87
11/18/09,16.01,16.1,15.8,16.06,19711200,16.06
11/17/09,15.94,15.98,15.66,15.95,14824200,15.95
11/16/09,15.7,16,15.66,15.96,22625700,15.96
11/13/09,15.46,15.63,15.27,15.4,16060700,15.4
11/12/09,15.44,15.65,15.39,15.45,15121700,15.45
11/11/09,15.66,15.72,15.43,15.59,10533400,15.59
11/10/09,15.5,15.61,15.36,15.4,15235600,15.4
11/9/09,15.02,15.55,14.97,15.54,17284800,15.54
11/6/09,14.72,14.97,14.68,14.86,11775600,14.86
11/5/09,14.76,14.95,14.55,14.91,13916900,14.91
11/4/09,14.66,14.81,14.56,14.58,13757900,14.58
11/3/09,14.25,14.6,14.22,14.59,17490800,14.59
11/2/09,14.41,14.59,14.21,14.44,19657300,14.44
10/30/09,14.89,14.95,14.36,14.45,23677000,14.45
10/29/09,14.64,15.01,14.63,14.93,17237700,14.93
10/28/09,15.15,15.17,14.53,14.59,29331400,14.59
10/27/09,15.36,15.45,15.04,15.29,20182800,15.29
10/26/09,15.38,15.68,15.17,15.37,18388300,15.37
10/23/09,15.91,16.1,15.41,15.48,27610400,15.48
10/22/09,15.15,15.51,15.01,15.43,17517400,15.43
10/21/09,15.22,15.62,15.15,15.15,17843300,15.15
10/20/09,15.38,15.5,14.47,15.35,17311200,15.35
10/19/09,15.44,15.47,15.22,15.36,13847100,15.36
10/16/09,15.33,15.38,15.06,15.28,20056100,15.28
10/15/09,15.63,15.65,15.22,15.43,23062300,15.43
10/14/09,15.76,15.76,15.51,15.63,24476600,15.63
10/13/09,15.42,15.46,15.25,15.31,24044500,15.31
10/12/09,15.92,15.98,15.29,15.42,24731600,15.42
10/9/09,15.76,16.2,15.75,15.81,25307100,15.81
10/8/09,15.55,15.94,15.37,15.82,25441700,15.82
10/7/09,15.43,15.56,15.17,15.36,20967900,15.36
10/6/09,15.31,15.51,15.16,15.51,20800000,15.51
10/5/09,15.11,15.41,15.01,15.15,29005000,15.15
10/2/09,15.02,15.25,14.8,15.04,19031900,15.04
10/1/09,15.24,15.31,15.1,15.14,27095400,15.14
9/30/09,15.26,15.4,15.05,15.26,28666500,15.26
9/29/09,15.62,15.74,15.17,15.17,28660100,15.17
9/28/09,15.5,15.76,15.49,15.67,12088900,15.67
9/25/09,15.56,15.6,15.26,15.34,23630200,15.34
9/24/09,16,16.14,15.66,15.77,17415100,15.77
9/23/09,15.79,16.34,15.68,15.95,27381700,15.95
9/22/09,15.83,15.9,15.66,15.73,33781600,15.73
9/21/09,15.88,16.2,15.67,16.01,43019800,16.01
9/18/09,17.02,17.04,16.62,16.69,27699300,16.69
9/17/09,16.92,17.13,16.82,16.86,19315800,16.86
9/16/09,16.71,17.04,16.69,16.92,20658000,16.92
9/15/09,16.51,16.79,16.45,16.57,23684300,16.57
9/14/09,16.45,16.55,16.29,16.39,16560400,16.39
9/11/09,16.59,16.75,16.44,16.6,35575800,16.6
9/10/09,15.85,16.6,15.85,16.56,35128600,16.56
9/9/09,15.9,16.04,15.66,15.92,18973700,15.92
9/8/09,15.74,15.97,15.64,15.96,25309300,15.96
9/4/09,15.32,15.74,15.32,15.69,17791100,15.69
9/3/09,15.47,15.69,15.16,15.25,17406700,15.25
9/2/09,15.17,15.56,15.13,15.35,21218800,15.35
9/1/09,15.72,15.9,15.06,15.21,34719500,15.21
8/31/09,15.77,15.86,15.4,15.83,27604700,15.83
8/28/09,16.53,17.26,15.65,15.93,81516900,15.93
8/27/09,14.76,15.76,14.43,15.65,66389000,15.65
8/26/09,14.65,14.77,14.47,14.67,19175800,14.67
8/25/09,14.97,14.98,14.5,14.57,26190500,14.57
8/24/09,14.77,15.27,14.69,14.78,36583100,14.78
8/21/09,14.71,14.76,14.41,14.49,29185900,14.49
8/20/09,14.48,14.57,14.32,14.55,14367600,14.55
8/19/09,14.04,14.56,13.87,14.45,26053300,14.45
8/18/09,13.98,14.56,13.97,14.43,28804400,14.43
8/17/09,13.87,14,13.73,13.93,24798800,13.93
8/14/09,14.26,14.34,13.94,14.2,18915500,14.2
8/13/09,13.9,14.3,13.72,14.29,28901900,14.29
8/12/09,13.48,13.97,13.45,13.84,23389100,13.84
8/11/09,13.64,13.7,13.17,13.38,20502600,13.38
8/10/09,13.33,13.72,13.29,13.59,20696000,13.59
8/7/09,13.36,13.43,13.13,13.2,19408600,13.2
8/6/09,13.6,13.79,13.07,13.16,28736200,13.16
8/5/09,13.72,13.9,13.36,13.63,18387400,13.63
8/4/09,13.54,13.8,13.4,13.7,16793900,13.7
8/3/09,13.52,13.7,13.37,13.6,15479400,13.6
7/31/09,13.62,13.62,13.22,13.38,25733300,13.38
7/30/09,13.96,14,13.51,13.57,24907200,13.57
7/29/09,13.97,14.03,13.52,13.72,18739100,13.72
7/28/09,13.65,14.24,13.62,13.97,28191800,13.97
7/27/09,13.52,13.79,13.44,13.71,16808000,13.71
7/24/09,13.34,13.57,13.22,13.5,22202800,13.5
7/23/09,13.25,13.88,13.15,13.47,40158800,13.47
7/22/09,13.33,13.43,13,13.3,28448300,13.3
7/21/09,13,13.38,12.97,13.36,29924500,13.36
7/20/09,12.73,12.97,12.66,12.94,30649600,12.94
7/17/09,12.76,12.89,12.55,12.67,36514100,12.67
7/16/09,12.26,12.83,12.2,12.75,50496100,12.75
7/15/09,12.18,12.39,11.85,12.32,72009200,12.32
7/14/09,12.67,12.69,11.84,11.97,105281200,11.97
7/13/09,13.19,13.22,12.65,13.02,41315000,13.02
7/10/09,13.34,13.5,12.93,13.22,58538500,13.22
7/9/09,13.12,13.22,12.95,13.15,18371600,13.15
7/8/09,13.05,13.14,12.76,12.95,27373700,12.95
7/7/09,13.38,13.57,12.94,13,42582100,13
7/6/09,12.96,13.47,12.94,13.42,26079500,13.42
7/2/09,13.12,13.23,12.9,12.97,40195000,12.97
7/1/09,13.76,13.81,13.35,13.39,28254000,13.39
6/30/09,13.88,13.93,13.62,13.73,23035200,13.73
6/29/09,13.8,13.96,13.72,13.86,15840900,13.86
6/26/09,13.62,13.88,13.41,13.68,25841000,13.68
6/25/09,13.13,13.75,13.07,13.65,29898400,13.65
6/24/09,13.19,13.35,13.06,13.28,24074800,13.28
6/23/09,13,13.12,12.74,12.98,23517800,12.98
6/22/09,13.18,13.49,12.93,12.98,25788100,12.98
6/19/09,12.76,13.44,12.71,13.29,48554700,13.29
6/18/09,12.78,12.85,12.58,12.61,16898500,12.61
6/17/09,12.71,12.88,12.47,12.76,21150600,12.76
6/16/09,12.94,13.17,12.73,12.77,20363800,12.77
6/15/09,13.42,13.49,12.75,12.87,25525300,12.87
6/12/09,13.22,13.4,13.05,13.39,25270000,13.39
6/11/09,12.94,13.32,12.9,13.27,32442700,13.27
6/10/09,12.79,12.97,12.49,12.94,30403900,12.94
6/9/09,12.42,12.79,12.4,12.6,24097900,12.6
6/8/09,11.88,12.4,11.76,12.28,25608000,12.28
6/5/09,12.27,12.32,11.92,12.08,21311900,12.08
6/4/09,11.59,12.21,11.56,12.1,26017600,12.1
6/3/09,11.92,12.02,11.45,11.62,30094700,11.62
6/2/09,12.16,12.38,11.84,11.94,20335200,11.94
6/1/09,11.7,12.25,11.68,12.18,26118500,12.18
5/29/09,11.87,11.96,11.33,11.57,50194900,11.57
5/28/09,11.23,11.55,11.18,11.48,33756700,11.48
5/27/09,11.18,11.43,11.02,11.12,20388300,11.12
5/26/09,10.72,11.2,10.63,11.14,21195000,11.14
5/22/09,10.81,11.06,10.66,10.85,16613500,10.85
5/21/09,10.89,10.98,10.59,10.83,33930600,10.83
5/20/09,11.41,11.55,11.13,11.18,29223900,11.18
5/19/09,11.3,11.74,11.22,11.56,22829800,11.56
5/18/09,11.11,11.3,11,11.3,17898900,11.3
5/15/09,10.86,11.12,10.8,10.98,26947800,10.98
5/14/09,10.94,11.23,10.82,10.93,27409400,10.93
5/13/09,11.09,11.31,10.87,10.94,30556800,10.94
5/12/09,11.08,11.36,10.83,11.21,36541900,11.21
5/11/09,10.58,11.17,10.57,11.02,28436100,11.02
5/8/09,11.12,11.14,10.39,10.81,51963400,10.81
5/7/09,11.9,11.94,10.75,11.07,40730600,11.07
5/6/09,11.9,12,11.38,11.89,28599200,11.89
5/5/09,12.12,12.31,11.71,11.86,24861300,11.86
5/4/09,11.99,12.32,11.92,12.28,23570000,12.28
5/1/09,11.63,11.91,11.45,11.85,20219800,11.85
4/30/09,11.59,12.05,11.4,11.62,30856500,11.62
4/29/09,11.02,11.5,10.89,11.25,20718700,11.25
4/28/09,11.03,11.05,10.76,10.88,19876000,10.88
4/27/09,10.85,11.3,10.85,11.09,25808500,11.09
4/24/09,10.8,11.1,10.54,11.05,32657700,11.05
4/23/09,10.6,10.74,10.34,10.72,25404400,10.72
4/22/09,10.42,10.9,10.35,10.63,20216800,10.63
4/21/09,10.25,10.73,10.22,10.55,20913000,10.55
4/20/09,10.8,10.85,10.29,10.31,29581100,10.31
4/17/09,10.9,11.1,10.54,11.06,29706300,11.06
4/16/09,10.3,10.97,10.05,10.88,37828500,10.88
4/15/09,10.31,10.53,10.03,10.2,28267100,10.2
4/14/09,10.46,10.9,10.29,10.47,35490400,10.47
4/13/09,10.65,10.7,10.34,10.45,20889000,10.45
4/9/09,10.46,10.96,10.38,10.76,31234300,10.76
4/8/09,9.91,10.34,9.89,10.2,22645000,10.2
4/7/09,10.1,10.12,9.73,9.83,20271400,9.83
4/6/09,10.19,10.33,9.91,10.33,23838700,10.33
4/3/09,9.65,10.38,9.53,10.32,45654500,10.32
4/2/09,9.67,9.9,9.38,9.5,45233400,9.5
4/1/09,9.33,9.66,9.22,9.52,29268700,9.52
3/31/09,9.56,9.78,9.38,9.48,25212400,9.48
3/30/09,9.79,9.79,9.2,9.49,22116100,9.49
3/27/09,10.13,10.2,9.85,9.95,20403500,9.95
3/26/09,10.35,10.44,10.01,10.35,34336300,10.35
3/25/09,10.5,10.86,9.88,10.17,33551300,10.17
3/24/09,10.3,10.83,10.26,10.41,25271500,10.41
3/23/09,10.2,10.45,9.94,10.45,27322800,10.45
3/20/09,10.12,10.44,9.73,9.88,36524900,9.88
3/19/09,9.83,10.13,9.63,10.04,34706000,10.04
3/18/09,9.29,9.84,9.22,9.62,29597200,9.62
3/17/09,9.07,9.36,8.93,9.34,19900500,9.34
3/16/09,9.49,9.55,8.84,8.9,33321200,8.9
3/13/09,9.52,9.76,9.15,9.37,29912200,9.37
3/12/09,8.94,9.47,8.8,9.44,31065900,9.44
3/11/09,8.8,9.13,8.77,8.98,25749200,8.98
3/10/09,8.25,8.76,8.2,8.76,32491100,8.76
3/9/09,8.35,8.67,8,8.04,27890100,8.04
3/6/09,8.44,8.6,8.13,8.37,33112400,8.37
3/5/09,8.7,8.94,8.39,8.39,30939300,8.39
3/4/09,9.17,9.2,8.72,8.88,40413700,8.88
3/3/09,8.7,9.2,8.43,9.15,44630100,9.15
3/2/09,8.53,9.03,8.43,8.43,39288600,8.43
2/27/09,8.26,8.75,8.15,8.53,48695800,8.53
2/26/09,8.54,8.56,8.18,8.21,42127200,8.21
2/25/09,8.28,8.47,7.93,8.36,38264200,8.36
2/24/09,8.06,8.36,7.94,8.26,32811300,8.26
2/23/09,8.57,8.59,7.95,7.99,30907100,7.99
2/20/09,7.99,8.44,7.84,8.41,66913800,8.41
2/19/09,8.53,8.58,8.06,8.12,43818300,8.12
2/18/09,8.95,8.96,8.58,8.65,36315200,8.65
2/17/09,8.71,9.08,8.7,8.88,29355300,8.88
2/13/09,9.19,9.35,9.06,9.12,27340500,9.12
2/12/09,8.89,9.21,8.73,9.17,38542900,9.17
2/11/09,9.29,9.33,8.78,9.02,28148500,9.02
2/10/09,9.59,9.77,9.12,9.16,31016900,9.16
2/9/09,9.43,9.73,9.21,9.64,40629600,9.64
2/6/09,9.45,9.75,9.28,9.46,30804300,9.46
2/5/09,9.27,9.56,9.1,9.43,31966600,9.43
2/4/09,9.83,10.12,9.62,9.79,22667600,9.79
2/3/09,9.3,9.81,9.16,9.77,23597000,9.77
2/2/09,9.38,9.41,9.1,9.31,22668900,9.31
1/30/09,10.12,10.15,9.45,9.5,27143100,9.5
1/29/09,10.61,10.67,9.89,9.95,36682400,9.95
1/28/09,10.35,11,10.18,10.88,23179200,10.88
1/27/09,10.3,10.36,9.99,10.07,21751700,10.07
1/26/09,10.11,10.53,9.96,10.31,14293400,10.31
1/23/09,9.67,10.46,9.58,10.14,25993500,10.14
1/22/09,9.76,10.11,9.52,9.98,27704100,9.98
1/21/09,10,10.32,9.7,10.2,24124000,10.2
1/20/09,10.24,10.45,9.8,9.85,24487200,9.85
1/16/09,10.79,10.79,9.83,10.27,30075900,10.27
1/15/09,10.33,10.82,10.14,10.54,35029800,10.54
1/14/09,10.56,10.67,10.25,10.31,17384600,10.31
1/13/09,10.54,10.91,10.5,10.76,21757300,10.76
1/12/09,10.91,11.02,10.43,10.65,25815600,10.65
1/9/09,11.23,11.38,10.59,11.12,36529600,11.12
1/8/09,11.01,11.28,10.84,11.27,23691300,11.27
1/7/09,10.83,11.43,10.81,11.15,30495700,11.15
1/6/09,10.83,11.34,10.65,11.05,37184600,11.05
1/5/09,10.82,10.9,10.53,10.61,19574700,10.61
1/2/09,10.31,10.76,10.26,10.75,16262400,10.75
12/31/08,10.19,10.46,10.07,10.24,20523400,10.24
12/30/08,10.34,10.44,10.11,10.23,16856000,10.23
12/29/08,10.66,10.74,10.17,10.34,15976800,10.34
12/26/08,10.61,10.78,10.59,10.65,5616600,10.65
12/24/08,10.88,10.91,10.57,10.65,4557700,10.65
12/23/08,10.9,11.1,10.76,10.83,9239600,10.83
12/22/08,11.14,11.21,10.75,10.96,15790100,10.96
12/19/08,11.47,11.6,11.06,11.09,21149800,11.09
12/18/08,11.8,11.82,11.2,11.36,14867300,11.36
12/17/08,11.65,11.84,11.35,11.68,20385500,11.68
12/16/08,11.17,11.88,11.15,11.79,21711800,11.79
12/15/08,11.48,11.58,10.95,11.13,15491400,11.13
12/12/08,11.64,11.64,10.9,11.48,24216500,11.48
12/11/08,11.93,12.29,11.65,11.69,20657900,11.69
12/10/08,11.99,12.14,11.73,12.02,19006300,12.02
12/9/08,11.62,12.29,11.41,11.86,25036900,11.86
12/8/08,11.01,12.25,11.01,12,31647300,12
12/5/08,10.25,10.76,9.92,10.71,23010900,10.71
12/4/08,10.4,10.48,10.08,10.27,18678800,10.27
12/3/08,10.19,10.55,9.94,10.55,19428600,10.55
12/2/08,10.24,10.53,9.89,10.52,25073400,10.52
12/1/08,10.94,10.94,9.74,10.05,27924600,10.05
11/28/08,10.9,11.27,10.9,11.17,8811800,11.17
11/26/08,10.28,11.2,10.16,11.05,22780900,11.05
11/25/08,10.2,10.63,10,10.42,31213600,10.42
11/24/08,9.55,10.28,9,10.14,38730900,10.14
11/21/08,10.39,10.47,8.72,9.3,58468800,9.3
11/20/08,10.04,10.6,9.8,9.81,49332800,9.81
11/19/08,10.29,10.69,10.14,10.35,27339000,10.35
11/18/08,10.91,11.1,10.14,10.6,27841400,10.6
11/17/08,10.47,11.18,10.27,10.52,27682400,10.52
11/14/08,9.97,11.51,9.92,10.89,48097400,10.89
11/13/08,10.12,10.42,8.85,10.27,63091000,10.27
11/12/08,11.1,11.11,10.5,10.5,21280700,10.5
11/11/08,11.56,11.61,11.01,11.33,19213100,11.33
11/10/08,12.93,12.96,11.64,11.86,21573200,11.86
11/7/08,12.12,12.65,12.03,12.55,16453300,12.55
11/6/08,12.52,12.73,11.89,12.03,21684200,12.03
11/5/08,12.6,13.2,12.6,12.77,28688000,12.77
11/4/08,12.95,13.32,12.66,12.93,22166800,12.93
11/3/08,12.25,12.81,12.24,12.61,16953600,12.61
10/31/08,12.32,12.54,11.85,12.2,24700700,12.2
10/30/08,12.47,12.85,12.07,12.25,29832200,12.25
10/29/08,12.97,13.01,11.93,12.13,31029100,12.13
10/28/08,12.04,13.16,11.71,13.15,27621100,13.15
10/27/08,11.42,12.25,11.27,11.74,20808700,11.74
10/24/08,10.74,12.05,10.59,11.5,35715100,11.5
10/23/08,12,12.49,11.49,11.99,37257400,11.99
10/22/08,12.47,12.73,11.47,11.98,32951800,11.98
10/21/08,12.97,13.24,12.46,12.58,22636200,12.58
10/20/08,13.29,13.49,12.8,13.37,27919400,13.37
10/17/08,13.02,14.26,12.74,13.04,35916200,13.04
10/16/08,12.9,13.29,12.27,13.21,40325600,13.21
10/15/08,13.77,13.79,12.58,12.58,38014600,12.58
10/14/08,15.69,15.7,14,14.08,39564300,14.08
10/13/08,13.68,15.21,13.56,15.21,37377100,15.21
10/10/08,12.8,13.98,12.46,13.29,50443500,13.29
10/9/08,13.91,14.03,13.29,13.43,39695000,13.43
10/8/08,13.37,14.3,13.23,13.5,42730100,13.5
10/7/08,15.09,15.12,13.55,13.55,34937500,13.55
10/6/08,14.88,15.49,14.29,14.86,40941900,14.86
10/3/08,16.04,16.55,15.16,15.25,34720000,15.25
10/2/08,16.15,16.15,15.08,15.79,31514500,15.79
10/1/08,16.22,16.6,15.99,16.15,22008900,16.15
9/30/08,15.73,16.6,15.5,16.48,30033000,16.48
9/29/08,16.69,16.94,15.41,15.41,39250100,15.41
9/26/08,16.61,17.11,16.57,17,17031600,17
9/25/08,16.7,17.11,16.5,16.93,25008600,16.93
9/24/08,16.6,16.84,16.28,16.7,30059700,16.7
9/23/08,16.81,17.34,16.33,16.33,35083100,16.33
9/22/08,16.69,17.24,16.5,16.57,27414300,16.57

Index prices:
Date,Open,High,Low,Close,Volume,Adj Close
11/23/09,1094.86,1112.38,1094.86,1106.24,3827920000,1106.24
11/20/09,1094.66,1094.66,1086.81,1091.38,3751230000,1091.38
11/19/09,1106.44,1106.44,1088.4,1094.9,4178030000,1094.9
11/18/09,1109.44,1111.1,1102.7,1109.8,4293340000,1109.8
11/17/09,1109.22,1110.52,1102.19,1110.32,3824070000,1110.32
11/16/09,1094.13,1113.69,1094.13,1109.3,4565850000,1109.3
11/13/09,1087.59,1097.79,1085.33,1093.48,3792610000,1093.48
11/12/09,1098.31,1101.97,1084.9,1087.24,4160250000,1087.24
11/11/09,1096.04,1105.37,1093.81,1098.51,4286700000,1098.51
11/10/09,1091.86,1096.42,1087.4,1093.01,4394770000,1093.01
11/9/09,1072.31,1093.19,1072.31,1093.08,4460030000,1093.08
11/6/09,1064.95,1071.48,1059.32,1069.3,4277130000,1069.3
11/5/09,1047.3,1066.65,1047.3,1066.63,4848350000,1066.63
11/4/09,1047.14,1061,1045.15,1046.5,5635510000,1046.5
11/3/09,1040.92,1046.36,1033.94,1045.41,5487500000,1045.41
11/2/09,1036.18,1052.18,1029.38,1042.88,6202640000,1042.88
10/30/09,1065.41,1065.41,1033.38,1036.19,6512420000,1036.19
10/29/09,1043.69,1066.83,1043.69,1066.11,5595040000,1066.11
10/28/09,1061.51,1063.26,1042.19,1042.63,6600350000,1042.63
10/27/09,1067.54,1072.48,1060.62,1063.41,5337380000,1063.41
10/26/09,1080.36,1091.75,1065.23,1066.95,6363380000,1066.95
10/23/09,1095.62,1095.83,1075.49,1079.6,4767460000,1079.6
10/22/09,1080.96,1095.21,1074.31,1092.91,5192410000,1092.91
10/21/09,1090.36,1101.36,1080.77,1081.4,5616290000,1081.4
10/20/09,1098.64,1098.64,1086.16,1091.06,5396930000,1091.06
10/19/09,1088.22,1100.17,1086.48,1097.91,4619240000,1097.91
10/16/09,1094.67,1094.67,1081.53,1087.68,4894740000,1087.68
10/15/09,1090.36,1096.56,1086.41,1096.56,5369780000,1096.56
10/14/09,1078.68,1093.17,1078.68,1092.02,5406420000,1092.02
10/13/09,1074.96,1075.3,1066.71,1073.19,4320480000,1073.19
10/12/09,1071.63,1079.46,1071.63,1076.19,3710430000,1076.19
10/9/09,1065.28,1071.51,1063,1071.49,3763780000,1071.49
10/8/09,1060.03,1070.67,1060.03,1065.48,4988400000,1065.48
10/7/09,1053.65,1058.02,1050.1,1057.58,4238220000,1057.58
10/6/09,1042.02,1060.55,1042.02,1054.72,5029840000,1054.72
10/5/09,1026.87,1042.58,1025.92,1040.46,4313310000,1040.46
10/2/09,1029.71,1030.6,1019.95,1025.21,5583240000,1025.21
10/1/09,1054.91,1054.91,1029.45,1029.85,5791450000,1029.85
9/30/09,1061.02,1063.4,1046.47,1057.08,5998860000,1057.08
9/29/09,1063.69,1069.62,1057.83,1060.61,4949900000,1060.61
9/28/09,1045.38,1065.13,1045.38,1062.98,3726950000,1062.98
9/25/09,1049.48,1053.47,1041.17,1044.38,4507090000,1044.38
9/24/09,1062.56,1066.29,1045.85,1050.78,5505610000,1050.78
9/23/09,1072.69,1080.15,1060.39,1060.87,5531930000,1060.87
9/22/09,1066.35,1073.81,1066.35,1071.66,5246600000,1071.66
9/21/09,1067.14,1067.28,1057.46,1064.66,4615280000,1064.66
9/18/09,1066.6,1071.52,1064.27,1068.3,5607970000,1068.3
9/17/09,1067.87,1074.77,1061.2,1065.49,6668110000,1065.49
9/16/09,1053.99,1068.76,1052.87,1068.76,6793529600,1068.76
9/15/09,1049.03,1056.04,1043.42,1052.63,6185620000,1052.63
9/14/09,1040.15,1049.74,1035,1049.34,4979610000,1049.34
9/11/09,1043.92,1048.18,1038.4,1042.73,4922600000,1042.73
9/10/09,1032.99,1044.14,1028.04,1044.14,5191380000,1044.14
9/9/09,1025.36,1036.34,1023.97,1033.37,5202550000,1033.37
9/8/09,1018.67,1026.07,1018.67,1025.39,5235160000,1025.39
9/4/09,1003.84,1016.48,1001.65,1016.4,4097370000,1016.4
9/3/09,996.12,1003.43,992.25,1003.24,4624280000,1003.24
9/2/09,996.07,1000.34,991.97,994.75,5842730000,994.75
9/1/09,1019.52,1028.45,996.28,998.04,6862360000,998.04
8/31/09,1025.21,1025.21,1014.62,1020.62,5004560000,1020.62
8/28/09,1031.62,1039.47,1023.13,1028.93,5785780000,1028.93
8/27/09,1027.81,1033.33,1016.2,1030.98,5785880000,1030.98
8/26/09,1027.35,1032.47,1021.57,1028.12,5080060000,1028.12
8/25/09,1026.63,1037.75,1026.21,1028,5768740000,1028
8/24/09,1026.59,1035.82,1022.48,1025.57,6302450000,1025.57
8/21/09,1009.06,1027.59,1009.06,1026.13,5885550000,1026.13
8/20/09,996.41,1008.92,996.39,1007.37,4893160000,1007.37
8/19/09,986.88,999.61,980.62,996.46,4257000000,996.46
8/18/09,980.62,991.2,980.62,989.67,4198970000,989.67
8/17/09,998.18,998.18,978.51,979.73,4088570000,979.73
8/14/09,1012.23,1012.6,994.6,1004.09,4940750000,1004.09
8/13/09,1005.86,1013.14,1000.82,1012.73,5250660000,1012.73
8/12/09,994,1012.78,993.36,1005.81,5498170000,1005.81
8/11/09,1005.77,1005.77,992.4,994.35,5773160000,994.35
8/10/09,1008.89,1010.12,1000.99,1007.1,5406080000,1007.1
8/7/09,999.83,1018,999.83,1010.48,6827089600,1010.48
8/6/09,1004.06,1008,992.49,997.08,6753380000,997.08
8/5/09,1005.41,1006.64,994.31,1002.72,7242120000,1002.72
8/4/09,1001.41,1007.12,996.68,1005.65,5713700000,1005.65
8/3/09,990.22,1003.61,990.22,1002.63,5603440000,1002.63
7/31/09,986.8,993.18,982.85,987.48,5139070000,987.48
7/30/09,976.01,996.68,976.01,986.75,6035180000,986.75
7/29/09,977.66,977.76,968.65,975.15,5178770000,975.15
7/28/09,981.48,982.35,969.35,979.62,5490350000,979.62
7/27/09,978.63,982.49,972.29,982.18,4631290000,982.18
7/24/09,972.16,979.79,965.95,979.26,4458300000,979.26
7/23/09,954.07,979.42,953.27,976.29,5761650000,976.29
7/22/09,953.4,959.83,947.75,954.07,4634100000,954.07
7/21/09,951.97,956.53,943.22,954.58,5309300000,954.58
7/20/09,942.07,951.62,940.99,951.13,4853150000,951.13
7/17/09,940.56,941.89,934.65,940.38,5141380000,940.38
7/16/09,930.17,943.96,927.45,940.74,4898640000,940.74
7/15/09,910.15,933.95,910.15,932.68,5238830000,932.68
7/14/09,900.77,905.84,896.5,905.84,4149030000,905.84
7/13/09,879.57,901.05,875.32,901.05,4499440000,901.05
7/10/09,880.03,883.57,872.81,879.13,3912080000,879.13
7/9/09,881.28,887.86,878.45,882.68,4347170000,882.68
7/8/09,881.9,886.8,869.32,879.56,5721780000,879.56
7/7/09,898.6,898.6,879.93,881.03,4673300000,881.03
7/6/09,894.27,898.72,886.36,898.72,4712580000,898.72
7/2/09,921.24,921.24,896.42,896.42,3931000000,896.42
7/1/09,920.82,931.92,920.82,923.33,3919400000,923.33
6/30/09,927.15,930.01,912.86,919.32,4627570000,919.32
6/29/09,919.86,927.99,916.18,927.23,4211760000,927.23
6/26/09,918.84,922,913.03,918.9,6076660000,918.9
6/25/09,899.45,921.42,896.27,920.26,4911240000,920.26
6/24/09,896.31,910.85,896.31,900.94,4636720000,900.94
6/23/09,893.46,898.69,888.86,895.1,5071020000,895.1
6/22/09,918.13,918.13,893.04,893.04,4903940000,893.04
6/19/09,919.96,927.09,915.8,921.23,5713390000,921.23
6/18/09,910.86,921.93,907.94,918.37,4684010000,918.37
6/17/09,911.89,918.44,903.78,910.71,5523650000,910.71
6/16/09,925.6,928,911.6,911.97,4951200000,911.97
6/15/09,942.45,942.45,919.65,923.72,4697880000,923.72
6/12/09,943.44,946.3,935.66,946.21,4528120000,946.21
6/11/09,939.04,956.23,939.04,944.89,5500840000,944.89
6/10/09,942.73,949.77,927.97,939.15,5379420000,939.15
6/9/09,940.35,946.92,936.15,942.43,4439950000,942.43
6/8/09,938.12,946.33,926.44,939.14,4483430000,939.14
6/5/09,945.67,951.69,934.13,940.09,5277910000,940.09
6/4/09,932.49,942.47,929.32,942.46,5352890000,942.46
6/3/09,942.51,942.51,923.85,931.76,5323770000,931.76
6/2/09,942.87,949.38,938.46,944.74,5987340000,944.74
6/1/09,923.26,947.77,923.26,942.87,6370440000,942.87
5/29/09,907.02,920.02,903.56,919.14,6050420000,919.14
5/28/09,892.96,909.45,887.6,906.83,5738980000,906.83
5/27/09,909.95,913.84,891.87,893.06,5698800000,893.06
5/26/09,887,911.76,881.46,910.33,5667050000,910.33
5/22/09,888.68,896.65,883.75,887,5155320000,887
5/21/09,900.42,900.42,879.61,888.33,6019840000,888.33
5/20/09,908.62,924.6,901.37,903.47,8205060000,903.47
5/19/09,909.67,916.39,905.22,908.13,6616270000,908.13
5/18/09,886.07,910,886.07,909.71,5702150000,909.71
5/15/09,892.76,896.97,878.94,882.88,5439720000,882.88
5/14/09,884.24,898.36,882.52,893.07,6134870000,893.07
5/13/09,905.4,905.4,882.8,883.92,7091820000,883.92
5/12/09,910.52,915.57,896.46,908.35,6871750400,908.35
5/11/09,922.99,922.99,908.68,909.24,6150600000,909.24
5/8/09,909.03,930.17,909.03,929.23,8163280000,929.23
5/7/09,919.58,929.58,901.36,907.39,9120100000,907.39
5/6/09,903.95,920.28,903.95,919.53,8555040000,919.53
5/5/09,906.1,907.7,897.34,903.8,6882860000,903.8
5/4/09,879.21,907.85,879.21,907.24,7038840000,907.24
5/1/09,872.74,880.48,866.1,877.52,5312170000,877.52
4/30/09,876.59,888.7,868.51,872.81,6862540000,872.81
4/29/09,856.85,882.06,856.85,873.64,6101620000,873.64
4/28/09,854.48,864.48,847.12,855.16,6328000000,855.16
4/27/09,862.82,868.83,854.65,857.51,5613460000,857.51
4/24/09,853.91,871.8,853.91,866.23,7114440000,866.23
4/23/09,844.62,852.87,835.45,851.92,6563100000,851.92
4/22/09,847.26,861.78,840.57,843.55,7327860000,843.55
4/21/09,831.25,850.09,826.83,850.08,7436489600,850.08
4/20/09,868.27,868.27,832.39,832.39,6973960000,832.39
4/17/09,865.18,875.63,860.87,869.6,7352009600,869.6
4/16/09,854.54,870.35,847.04,865.3,6598670000,865.3
4/15/09,839.44,852.93,835.58,852.06,6241100000,852.06
4/14/09,856.88,856.88,840.25,841.5,7569840000,841.5
4/13/09,855.33,864.31,845.35,858.73,6434890000,858.73
4/9/09,829.29,856.91,829.29,856.56,7600710400,856.56
4/8/09,816.76,828.42,814.84,825.16,5938460000,825.16
4/7/09,834.12,834.12,814.53,815.55,5155580000,815.55
4/6/09,839.75,839.75,822.79,835.48,6210000000,835.48
4/3/09,835.13,842.5,826.7,842.5,5855640000,842.5
4/2/09,814.53,845.61,814.53,834.38,7542809600,834.38
4/1/09,793.59,813.62,783.32,811.08,6034140000,811.08
3/31/09,790.88,810.48,790.88,797.87,6089100000,797.87
3/30/09,809.07,809.07,779.81,787.53,5912660000,787.53
3/27/09,828.68,828.68,813.43,815.94,5600210000,815.94
3/26/09,814.06,832.98,814.06,832.86,6992960000,832.86
3/25/09,806.81,826.78,791.37,813.88,7687180000,813.88
3/24/09,820.6,823.65,805.48,806.12,6767980000,806.12
3/23/09,772.31,823.37,772.31,822.92,7715769600,822.92
3/20/09,784.58,788.91,766.2,768.54,7643720000,768.54
3/19/09,797.92,803.24,781.82,784.04,9033870400,784.04
3/18/09,776.01,803.04,765.64,794.35,9098449600,794.35
3/17/09,753.88,778.12,749.93,778.12,6156800000,778.12
3/16/09,758.84,774.53,753.37,753.89,7883540000,753.89
3/13/09,751.97,758.29,742.46,756.55,6787089600,756.55
3/12/09,720.89,752.63,714.76,750.74,7326630400,750.74
3/11/09,719.59,731.92,713.85,721.36,7287809600,721.36
3/10/09,679.28,719.6,679.28,719.6,8618329600,719.6
3/9/09,680.76,695.27,672.88,676.53,7277320000,676.53
3/6/09,684.04,699.09,666.79,683.38,7331830400,683.38
3/5/09,708.27,708.27,677.93,682.55,7507249600,682.55
3/4/09,698.6,724.12,698.6,712.87,7673620000,712.87
3/3/09,704.44,711.67,692.3,696.33,7583230400,696.33
3/2/09,729.57,729.57,699.7,700.82,7868289600,700.82
2/27/09,749.93,751.27,734.52,735.09,8926480000,735.09
2/26/09,765.76,779.42,751.75,752.83,7599969600,752.83
2/25/09,770.64,780.12,752.89,764.9,7483640000,764.9
2/24/09,744.69,775.49,744.69,773.14,7234489600,773.14
2/23/09,773.25,777.85,742.37,743.33,6509300000,743.33
2/20/09,775.87,778.69,754.25,770.05,8210590400,770.05
2/19/09,787.91,797.58,777.03,778.94,5746940000,778.94
2/18/09,791.06,796.17,780.43,788.42,5740710000,788.42
2/17/09,818.61,818.61,789.17,789.17,5907820000,789.17
2/13/09,833.95,839.43,825.21,826.84,5296650000,826.84
2/12/09,829.91,835.48,808.06,835.19,6476460000,835.19
2/11/09,827.41,838.22,822.3,833.74,5926460000,833.74
2/10/09,866.87,868.05,822.99,827.16,6770169600,827.16
2/9/09,868.24,875.01,861.65,869.89,5574370000,869.89
2/6/09,846.09,870.75,845.42,868.6,6484100000,868.6
2/5/09,831.75,850.55,819.91,845.85,6624030000,845.85
2/4/09,837.77,851.85,829.18,832.23,6420450000,832.23
2/3/09,825.69,842.6,821.98,838.51,5886310000,838.51
2/2/09,823.09,830.78,812.87,825.44,5673270000,825.44
1/30/09,845.69,851.66,821.67,825.88,5350580000,825.88
1/29/09,868.89,868.89,844.15,845.14,5067060000,845.14
1/28/09,845.73,877.86,845.73,874.09,6199180000,874.09
1/27/09,837.3,850.45,835.4,845.71,5353260000,845.71
1/26/09,832.5,852.53,827.69,836.57,6039940000,836.57
1/23/09,822.16,838.61,806.07,831.95,5832160000,831.95
1/22/09,839.74,839.74,811.29,827.5,5843830000,827.5
1/21/09,806.77,841.72,804.3,840.24,6467830000,840.24
1/20/09,849.64,849.64,804.47,805.22,6375230000,805.22
1/16/09,844.45,858.13,830.66,850.12,6786040000,850.12
1/15/09,841.99,851.59,817.04,843.74,7807350400,843.74
1/14/09,867.28,867.28,836.93,842.62,5407880000,842.62
1/13/09,869.79,877.02,862.02,871.79,5017470000,871.79
1/12/09,890.4,890.4,864.32,870.26,4725050000,870.26
1/9/09,909.91,911.93,888.31,890.35,4716500000,890.35
1/8/09,905.73,910,896.81,909.73,4991550000,909.73
1/7/09,927.45,927.45,902.37,906.65,4704940000,906.65
1/6/09,931.17,943.85,927.28,934.7,5392620000,934.7
1/5/09,929.17,936.63,919.53,927.45,5413910000,927.45
1/2/09,902.99,934.73,899.35,931.8,4048270000,931.8
12/31/08,890.59,910.32,889.67,903.25,4172940000,903.25
12/30/08,870.58,891.12,870.58,890.64,3627800000,890.64
12/29/08,872.37,873.7,857.07,869.42,3323430000,869.42
12/26/08,869.51,873.74,866.52,872.8,1880050000,872.8
12/24/08,863.87,869.79,861.44,868.15,1546550000,868.15
12/23/08,874.31,880.44,860.1,863.16,4051970000,863.16
12/22/08,887.2,887.37,857.09,871.63,4869850000,871.63
12/19/08,886.96,905.47,883.02,887.88,6705310000,887.88
12/18/08,905.98,911.02,877.44,885.28,5675000000,885.28
12/17/08,908.16,918.85,895.94,904.42,5907380000,904.42
12/16/08,871.53,914.66,871.53,913.18,6009780000,913.18
12/15/08,881.07,884.63,857.72,868.57,4982390000,868.57
12/12/08,871.79,883.24,851.35,879.73,5959590000,879.73
12/11/08,898.35,904.63,868.73,873.59,5513840000,873.59
12/10/08,892.17,908.27,885.45,899.24,5942130000,899.24
12/9/08,906.48,916.26,885.38,888.67,5693110000,888.67
12/8/08,882.71,918.57,882.71,909.7,6553600000,909.7
12/5/08,844.43,879.42,818.41,876.07,6165370000,876.07
12/4/08,869.75,875.6,833.6,845.22,5860390000,845.22
12/3/08,843.6,873.12,827.6,870.74,6221880000,870.74
12/2/08,817.94,850.54,817.94,848.81,6170100000,848.81
12/1/08,888.61,888.61,815.69,816.21,6052010000,816.21
11/28/08,886.89,896.25,881.21,896.24,2740860000,896.24
11/26/08,852.9,887.68,841.37,887.68,5793260000,887.68
11/25/08,853.4,868.94,834.99,857.39,6952700000,857.39
11/24/08,801.2,865.6,801.2,851.81,7879440000,851.81
11/21/08,755.84,801.2,741.02,800.03,9495900000,800.03
11/20/08,805.87,820.52,747.78,752.44,9093740000,752.44
11/19/08,859.03,864.57,806.18,806.58,6548600000,806.58
11/18/08,852.34,865.9,826.84,859.12,6679470000,859.12
11/17/08,873.23,882.29,848.98,850.75,4927490000,850.75
11/14/08,904.36,916.88,869.88,873.29,5881030000,873.29
11/13/08,853.13,913.01,818.69,911.29,7849120000,911.29
11/12/08,893.39,893.39,850.48,852.3,5764180000,852.3
11/11/08,917.15,917.15,884.9,898.95,4998340000,898.95
11/10/08,936.75,951.95,907.47,919.21,4572000000,919.21
11/7/08,907.44,931.46,906.9,930.99,4931640000,930.99
11/6/08,952.4,952.4,899.73,904.88,6102230000,904.88
11/5/08,1001.84,1001.84,949.86,952.77,5426640000,952.77
11/4/08,971.31,1007.51,971.31,1005.75,5531290000,1005.75
11/3/08,968.67,975.57,958.82,966.3,4492280000,966.3
10/31/08,953.11,984.38,944.59,968.75,6394350000,968.75
10/30/08,939.38,963.23,928.5,954.09,6175830000,954.09
10/29/08,939.51,969.97,922.26,930.09,7077800000,930.09
10/28/08,848.92,940.51,845.27,940.51,7096950400,940.51
10/27/08,874.28,893.78,846.75,848.92,5558050000,848.92
10/24/08,895.22,896.3,852.85,876.77,6550050000,876.77
10/23/08,899.08,922.83,858.44,908.11,7184180000,908.11
10/22/08,951.67,951.67,875.81,896.78,6147980000,896.78
10/21/08,980.4,985.44,952.47,955.05,5121830000,955.05
10/20/08,943.51,985.4,943.51,985.4,5175640000,985.4
10/17/08,942.29,984.64,918.74,940.55,6581780000,940.55
10/16/08,909.53,947.71,865.83,946.43,7984500000,946.43
10/15/08,994.6,994.6,903.99,907.84,6542330000,907.84
10/14/08,1009.97,1044.31,972.07,998.01,8161990400,998.01
10/13/08,912.75,1006.93,912.75,1003.35,7263369600,1003.35
10/10/08,902.31,936.36,839.8,899.22,11456230400,899.22
10/9/08,988.42,1005.25,909.19,909.92,6819000000,909.92
10/8/08,988.91,1021.06,970.97,984.94,8716329600,984.94
10/7/08,1057.6,1072.91,996.23,996.23,7069209600,996.23
10/6/08,1097.56,1097.56,1007.97,1056.89,7956020000,1056.89
10/3/08,1115.16,1153.82,1098.14,1099.23,6716120000,1099.23
10/2/08,1160.64,1160.64,1111.43,1114.28,6285640000,1114.28
10/1/08,1164.17,1167.03,1140.77,1161.06,5782130000,1161.06
9/30/08,1113.78,1168.03,1113.78,1166.36,4937680000,1166.36
9/29/08,1209.07,1209.07,1106.42,1106.42,7305060000,1106.42
9/26/08,1204.47,1215.77,1187.54,1213.27,5383610000,1213.27
9/25/08,1187.87,1220.03,1187.87,1209.18,5877640000,1209.18
9/24/08,1188.79,1197.41,1179.79,1185.87,4820360000,1185.87
9/23/08,1207.61,1221.15,1187.06,1188.22,5185730000,1188.22
9/22/08,1255.37,1255.37,1205.61,1207.09,5332130000,1207.09

Attachments

Solution Summary

The solution explains how to calculate the beta using excel linest function

$2.19