Link: https://support.microsoft.com/en-us/office/load-the-analysis-toolpak-in-excel-6a63e598-cd6d-42e3-9317-6b40ba1a66b4?ui=en-us&rs=en-us&ad=us#OfficeVersion=Windows

This Assignment requires the use of the Analysis Toolpak in Microsoft Excel. This is not available in Excel Online. To obtain a copy of Microsoft Excel, please go to http://www.office. com, and click Install Office. To load the Analysis Toolpak, please see the Microsoft support page by clicking here.3. Armspan and height measurements (in centimetres) were collected for eight people, with the following results: Armspan, x (cm) Height, y (cm) 172.7 158.1 165.1 176.5 172.7 175.3 157.5 153.0 175.3 157.5 165.1 177.8 170.2 170.2 160.0 157.5 (a) Use the Regression tool from the Analysis Toolpak in Microsoft Excel to perform a regression analysis on the above data. Type the data above into a blank worksheet and follow the procedure described in Example 3 from Unit 7.5 (using a condence level of 95%). Include the Excel output (as well as the Line Fit Plot) in your assignment submission. (b) What is the sample regression line for this data? (c) Test whether the slope of the line is signicantly different from zero at the 5% level. (d) If a person has an armspan of 158.3 cm, what would you predict the person's height to be