(1 point) The Capital Asset Price Model (CAPM) is a financial model that attempts to predict the rate of return on a financial instrument, such as a common stock, in such a way that it is linearly related to the rate of return on the overal market. Specifically, You are to study the relationship between the two variables and estimate the above model: RStockAi-rate of return on Stock A for month 1, 1-1, 2, , 59 RMarketi - market rate of return for month i, i - 1,2, ,59. 1 represent's the stocksbeta' value, or its systematic risk. It measure's the stocks volatility related to the market volatility. represents the risk-free interest rate. The data in the Download.csv file contains the data on the rate of return of a large energy company which will be referred to as Acme Oil and Gas and the corresponding rate of return on the Toronto Composite Index (TSE) for 59 randomly selected months. Therefore RAcme j represents the monthly rate of return for a common share of Acme Oil and Gas stock; RTSE.i represents the monthly rate of return (increase or decrease) of the TSE Index for the same month, month i. The first column in this data file contains the monthly rate of return on Acme Oil and gas stock; the second column contains the monthly rate of return on the TSE index for the same month. (a) Using MINITAB, create a scatter-plot of the data. What can you conclude from this scatter-plot? A. There is a positive linear relationship between the monthly rate of return of Acme Oil and Gas stock and the monthly rate of return of the TSE Index. B. There is not a linear relationship between the monthly rate of return of Acme stock and the monthly rate of return of the TSE Index C. There is a negative linear relationship between the monthly rate of return of Acme stock and the monthly rate of return of the TSE Index (b) Find the value of the correlation coefficient. Enter your answer using four decimals. (1 point) The Capital Asset Price Model (CAPM) is a financial model that attempts to predict the rate of return on a financial instrument, such as a common stock, in such a way that it is linearly related to the rate of return on the overal market. Specifically, You are to study the relationship between the two variables and estimate the above model: RStockAi-rate of return on Stock A for month 1, 1-1, 2, , 59 RMarketi - market rate of return for month i, i - 1,2, ,59. 1 represent's the stocksbeta' value, or its systematic risk. It measure's the stocks volatility related to the market volatility. represents the risk-free interest rate. The data in the Download.csv file contains the data on the rate of return of a large energy company which will be referred to as Acme Oil and Gas and the corresponding rate of return on the Toronto Composite Index (TSE) for 59 randomly selected months. Therefore RAcme j represents the monthly rate of return for a common share of Acme Oil and Gas stock; RTSE.i represents the monthly rate of return (increase or decrease) of the TSE Index for the same month, month i. The first column in this data file contains the monthly rate of return on Acme Oil and gas stock; the second column contains the monthly rate of return on the TSE index for the same month. (a) Using MINITAB, create a scatter-plot of the data. What can you conclude from this scatter-plot? A. There is a positive linear relationship between the monthly rate of return of Acme Oil and Gas stock and the monthly rate of return of the TSE Index. B. There is not a linear relationship between the monthly rate of return of Acme stock and the monthly rate of return of the TSE Index C. There is a negative linear relationship between the monthly rate of return of Acme stock and the monthly rate of return of the TSE Index (b) Find the value of the correlation coefficient. Enter your answer using four decimals
