How to run multiple regression in Excel Activate the Data Analysis ToolPak. After you open Excel, the first step is to ensure the Data Analysis ToolPak is active. ... Enter your basic data. The next step is to enter your basic data manually. ... Input your dependent data. ... Input your independent data. ... Execute your analysis. Jun 24, 2022