The following table shows rates of return for a mutual fund and the market portfolio (S&P 500).

	A	B	C
1	Year	Fund	Market
2	1	14%	13%
3	2	-16%	-14%
4	3	-6%	-4%
5	4	5%	28%
6	5	14%	8%
7	6	6%	8%

Regress the returns on the stock on the returns on the S&P 500. What is the beta of the fund, using the industry model (not subtracting the risk-free rate), i.e., the slope coefficient of the regression?

You can estimate beta using regression in Excel; however, it's also possible to get the slope via Excel's LINEST function or SLOPE function. Just copy and paste the table of returns into Excel.