1. Historical mean and standard deviation of returns:

	S&P 500	CAT	WMT	DUK	MSFT	PG
Historical Mean	0.000284	0.000406	-0.07571	0.00042	0.001002	0.000276
STD	0.008332	0.016115	0.036852	0.010038	0.014595	0.009287

2. Beta of all five stocks:

	S&P 500	CAT	WMT	DUK	MSFT	PG
Calculated Beta	1	1.276894	0.304614	0.298916	1.270082	0.550612
Beta from Yahoo Finance		1.52	0.41	0.07	1.23	0.40

3. Mean return, standard deviation of returns, and beta for each portfolio:

	Portfolio 1	Portfolio 2	Portfolio 3
Mean	-0.014721	-0.0299676	-0.0107901
STD	0.0105122	0.0160402	0.01034946
Beta	0.7402235	0.6313212	0.87268808

4. Compare the values calculated in Step 3, with the weighted average mean, standard deviation and beta of the individual stocks (results from Step 1 and Step 2), with the weights being equal to the weight of each stock in the portfolio. Point out which value (s) is (are) same and which value(s) is (are) different between Step 3 and Step 4.

Weight assigned to: Portfolio Caterpillar Wal-Mart Duke Energy Microsoft P&G 1 0.2 0.2 0.2 0.2 0.2 0.15 0.15 0.15 2 3 0.15 0.15 0.4 0.15 0.15 0.4 0.15