How to Report the Results of ANOVA Regression

Written by steve brunolli
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Report the Results of ANOVA Regression
Analysis of variance is a useful tool to measure the significance of a multiple linear regression. (NA/ Images)

Statisticians can easily find the significance of a single independent variable in a linear regression by using a t-test. When multiple independent variables are involved, however, a t-test is no longer viable. In this case, statisticians use analysis of variance (ANOVA) to measure the variance between and within variable groups. From that data, they obtain a p-value for the entire model. If the p-value is greater than the previously chosen critical probability, none of the independent variables are correlated with the dependent variable; if the p-value is less than the critical probability, at least one of the independent variables is correlated with the dependent variable, and the statistician must continue testing.While the process of generating ANOVA statistics may be tedious by hand, Microsoft Excel 2007s Data Analysis add-in can generate it with ease.

Skill level:
Moderately Easy

Things you need

  • Microsoft Excel 2007

Show MoreHide



  1. 1

    Look under the Data tab at the top of the window. If Data Analysis appears under the Analysis section, skip to step 5. Otherwise, continue.

  2. 2

    Click the Microsoft Office button in the upper left corner. Select Excel Options.

  3. 3

    Select Add-Ins from the menu on left. In the subsequent window, select "Analysis Toolpak." Click Go.

  4. 4

    Select "Analysis ToolPak" from the prompt. Click OK. This will install the Data Analysis add-in to Excel.

  5. 5

    Enter the dependent variable values, y, into column A of the spreadsheet. Enter the independent variable values, x, into column B. If you are using multiple independent variables, assign a new column to each variable.

  6. 6

    Highlight an empty cell. Select "Data Analysis" from the Data tab at the top of the screen.

  7. 7

    Select "Regression" from the prompt. Click OK. The Regression Properties window will appear.

  8. 8

    Click "Input Y Range." Highlight the y values in column A.

  9. 9

    Click "Input X Range." Highlight all columns that contain x values.

  10. 10

    Click OK. Excel will generate an ANOVA report of the regression in a new worksheet.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.