Data For Regression Analysis Excel. When Excel displays the Data Analysis dialog box select the Regression tool from the Analysis Tools list and then click OK. Excel displays the Regression dialog box.
Select the Input Y Range which is your dependent variable. Mar 31 2015 Select Analysis ToolPak and click GO next to Manage. If you normally use Excels own Data Analysis Toolpak for regression you should stop right now and visit this link first.
The following argument window will open.
Hours of Television Age 1 45 3 30 4 22 3 25 6 5 a. Hours of Television Age 1 45 3 30 4 22 3 25 6 5 a. This video shows how to generate simple linear regression statistics using the Data Analysis Addin in Excel intercept slope regression equation SSR SSE. Check the residuals and click OK.
