Using multiple simple regression analysis, with share prices of the royal bank (RY.TO) being dependent variable and Inflation and GDP being independent variables… Data can be converted to percentages. using the guideline determine if there is a relationship between the two variables and write a brief for the results for recommending buy, sell and hold. Data points are monthly
- https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1810000401&pickMembers%5B0%5D=1.2&cubeTimeFrame.startMonth=12&cubeTimeFrame.startYear=2000&cubeTimeFrame.endMonth=12&cubeTimeFrame.endYear=2021&referencePeriods=20001201%2C20211201
- https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3610043401&pickMembers%5B0%5D=2.1&pickMembers%5B1%5D=3.1&cubeTimeFrame.startMonth=12&cubeTimeFrame.startYear=2000&cubeTimeFrame.endMonth=12&cubeTimeFrame.endYear=2021&referencePeriods=20001201%2C20211201
- https://ca.finance.yahoo.com/quote/RY.TO/history?period1=978220800&period2=1640908800&interval=1d&filter=history&frequency=1d&includeAdjustedClose=true Please provide the step-by-step excel sheets as per requirement.