Problem $12-22$ Calculating Beta $($LO$4,$ CFA$1)$

You are given the following information concerning a stock and the market:

$\backslash$table$[[,$Returns$],[$Year$,$Market,Stock,$],[2017,14\%,26\%,],[2018,13,29,],[2019,14,5,],[2020,-14,-23,],[2021,37,16,],[2022,15,24,]]$

a$.$ Calculate the average return and standard deviation for the market and the stock.

Note: Use Excel to complete the problem. Do not round intermediate calculations. Enter your answers as a percent rounded to $2$ decimal places.

$\backslash$table$[[,$Market,Stock,$],[$Average return,,$\%,\%$