A researcher wants to analyse the relationship between beer price (in $/ per litre) and percapita beer quantity consumed (in litres) in Australia between 1978-2020. To analyse the relationship between beer price and per capita beer quantity consumed, the researcher carried out a regression analysis and the excel output is given below. Required: Using the Regression summary output table, answer the following: I. Comment on the strength and the direction of the relationship between beer price and per-capita quantity of beer consumed rates. II. Write down the estimated regression line. III. What do the estimated regression coefficients reveal about the relationship between per-capita beer quantity consumed and price of beer? IV. Comment on the fitness of the estimated model. V. Test whether a linear relationship exists between beer price and per capita beer quantity consumed at the 5% significance level using the following template. (Use the Excel output) Step 1. Statement of the hypotheses Step 2. Test statistic and the standardised test statistic Step 3. Level of significance Step 4. Decision rule Step 5. Computation of the value of the test statistic: Step 6. Conclusion