Attaching the excel file with the required data in this link:

https://gofile.io/d/6T2evl

Questions

a. Run a simple linear regression using the Revenue data as the dependent variable and Price Index data (not seasonally adjusted) as the independent variable. Report the estimated regression line and predict the Revenue if price index is 0.7

b. Test at the 5% significance level if revenue and price index are positively and significantly related. State the hypothesis, criteria used and conclusion.

thank you