Potter Industries is estimating its beta using the following data:

Date Stock

Index Potter

Closing

Price

$($CAD$)$

$12/11430\mathrm{.}22213\mathrm{.}00$

$1/12443\mathrm{.}93226\mathrm{.}75$

$2/12467\mathrm{.}07228\mathrm{.}75$

$3/12475\mathrm{.}35213\mathrm{.}88$

$4/12475\mathrm{.}35203\mathrm{.}00$

$5/12489\mathrm{.}83206\mathrm{.}13$

$6/12471\mathrm{.}16197\mathrm{.}13$

$7/12487\mathrm{.}81201\mathrm{.}25$

$8/12495\mathrm{.}43196\mathrm{.}88$

$9/12487\mathrm{.}86203\mathrm{.}63$

$10/12492\mathrm{.}46198\mathrm{.}25$

$11/12475\mathrm{.}22192\mathrm{.}25$

$12/12517\mathrm{.}09189\mathrm{.}00$

REQUIRED:

$1.$ Calculate the beta for Potter using the Slope function in Excel.