determine if there is a relationship between the two variables
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
Please provide the step-by-step excel sheets as per requirement.