- You've been hired as a financial analyst for an investment company. - A new client has walked into your office with a \$1million investment. You're required to advise them on the best stocks to invest in. - Go to Yahoo Finance and create a closing price excel sheet for the past 90 business days for any 20 stocks in the Toronto Stock Exchange, determine the mean, the standard deviation and the coefficient of variation for each of them. - Which 4 stocks would you advice your client to invest in? Your decision should come from your data analysis above. - Upload Source Files and Excel File to moodle for grading - You are required to present your conclusions in an excel dashboard to your client. - You've been hired as a financial analyst for an investment company. - A new client has walked into your office with a \$1million investment. You're required to advise them on the best stocks to invest in. - Go to Yahoo Finance and create a closing price excel sheet for the past 90 business days for any 20 stocks in the Toronto Stock Exchange, determine the mean, the standard deviation and the coefficient of variation for each of them. - Which 4 stocks would you advice your client to invest in? Your decision should come from your data analysis above. - Upload Source Files and Excel File to moodle for grading - You are required to present your conclusions in an excel dashboard to your client