determine if there is a relationship between the two variables and write a brief for the results for recommending buy, sell and hold
Using simple regression analysis, with share prices of the royal bank (RY.TO) being dependent variable and Inflation (Canada consumer price index ) being independent variable… 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
1. 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
2. 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.