To run this Analysis, you must ensure that Excel has a Data Analysis ToolPak add-in. To get this add-in, click on the File tab, options, click on the Add-Ins category, select Analysis ToolPak, and click Go. Check Analysis Toolpak and click Ok. You can go to the Data tab and into the Analysis group to find Data Analysis and click on it. Select Regression and click Ok. Select the X and Y ranges, check the residuals and click Ok. You will get your required output.