# Regression Residuals Analysis in Excel

## You Don't Have to be a Statistician to Run Residuals Analysis

### Regression Analysis Calculations in QI Macros

When you run regression analysis using QI Macros Excel Add in, the output is displayed in two sections of your Excel Workbook.

### Regression Summary Output

.See our regression analysis page for more detail on how to interpret and use these results

### Regression Residuals Output and Probability Output

**Draw a Residuals Plot in Excel**

To draw a plot of the residuals data in Excel, click and drag over the residuals data in column F and then Insert a Scatter Chart using Excels Chart Tools:

### **To Draw a Residuals Line Fit Using QI Macros:**

Select the data in A24:A44 then press the Ctrl key and select the data in E24:E44. Next click on QI Macros Menu and select the "Box, Dot & Scatter Plot" drop-down menu and choose "Scatter":

QI Macros will Create a Scatter Plot with the slope equation and the R square value to indicate goodness of fit:

### **To Draw a Normal Probability Plot Using QI Macros**

Click and drag over the data from I24 to J44 to select it and then select Scatter Chart from QI Macros Menu:

### Why Choose QI Macros Statistical Software for Excel?

### Affordable

- Only
**$299 USD**- less with quantity discounts - No annual fees
- Free Technical Support

### Easy to Use

- Works Right in Excel
- Interprets Results for You
- Accurate Results Without Worry

### Proven and Trusted

- 100,000 Users in 80 Countries
- Celebrating 20th Anniversary
- Five Star CNET Rating - Virus Free