solved: 3. Run a simple linear regression using EXCEL Use Time period and…
3. Run a simple linear regression using EXCEL Use Time period and…3. Run a simple linear regression using EXCEL Use Time period and Stock 1 prices. Show the output from Excel ( note the weeks must be changed to time periods 1,2,3…) Set up the linear regression equation Stock 1 Test the significance using p-value with a =0.05. Stock 1 Use Linear regression equation (from b) forecast the stock price for end of May 2022. Stock 1. Draw Time-series plot for Stock 1 Do you notice any trends in e)? How would you adjust your forecast above in Q d)?Image transcription textDescriptive statistics Question 3 WRT(ILU.AX) WRT (BLD.AX) Mean0.874635732 Mean -0.23… Show more… Show moreImage transcription textStock 1 hypothesis testing:Hypothesised Population Mean () =0.15 Sample Standard De… Show more… Show more MathStatistics and Probability ACCOUNTING 4000