I know the answers, however, I need to show my work on the anova tables. How do I in excel? Which data analysis tab do I use and what do I input? Thats it! Thank you! (I am referring to Q2!)

In an alternate reality, a temporal anomaly transports Luke Skywalker, Rey and Anikin Skywalker to Yoda's home planet as 8 year olds. Yoda's people decide to train them all in the ways of the Force. As they begin their Jedi training, their progress is tracked weekly. One of the items tracked is weight of object they are able to make hover. The results of the rst 12 weeks of training are shown in Table 1. All answers go in the Analysis tab!!! (11. Examine the data in Table 1. Without doing any calculations, ofthe three Jedi trainees, for which kidls} would be Simple Linear Regression be a good tool to model their progress? Why? Explain in 50 words or less. Q2. Perform a simple linear regression on all three kid's progress. Hint: time is the xvariable and weight of stone suspended is the y variable. Perform a simple linear regression on all three kid's progress. Show your work in the analysis tab, putting the output in the designated spaces. What is the regression equation for Luke? For Rey? For Anikin? Put your reSults in the indicated space What is the r2 for each kid? According to the p-value, which of the regression lines is statistically signicant at an alpha of 0.05? (13. Using Luke and Anikin's regression equations, make a prediction during which week Luke will catch up with Anikin