Technology Training Center at SUNY Cortland

November 27, 2007

Activating the Anova Data Analysis Function in Excel 2007

Filed under: Microsoft Office 2007, Tech Questions & Answers — cortlandttc @ 4:21 pm

To add the Anova Data Analysis function to Excel 2007, start by opening Excel and clicking on the Office button at the top left of the screen. At the bottom of the drop down menu, click on the’ Excel Options’ button.

The Excel Options window will open. In the column on the left, click on the Add-Ins heading. On the right side of the window, scroll down to Inactive Application Add-Ins and click on ‘Analysis ToolPak’ to select it. Then click the Go Button.

An ‘Add-Ins’ window will open. Click in the checkbox next to ‘Analysis ToolPak’ and click the OK button. Another window may open that says Excel can’t run the add-in until you install the feature. Click Yes.

The Microsoft Office Configuration window will launch. This can take a minute or two to configure. When it is finished, click on the Data tab and the Anova Data Anaylsis function will appear in the Anaylsis group on the right side of the ribbon.

For more text tutorials, visit the Technology Training Center website at 



  1. This topic is quite hot in the net right now. What do you pay the most attention to while choosing what to write ?

    Comment by How to Get Six Pack Fast — April 15, 2009 @ 9:52 am


    Comment by Nadia — March 9, 2011 @ 11:29 am

  3. gosh,i’m still in high school but i’m already answering or doing some hypothesis testing on excel…=[

    Comment by ann — March 29, 2011 @ 6:31 am

  4. please i tried this so many times but it is not working.please i need help

    Comment by helen — May 13, 2011 @ 3:32 pm

  5. i just saw a video from you tube and it worked

    Comment by helen — May 13, 2011 @ 3:39 pm

  6. wow.. nice one!!! it helped me a lot! thank you so much… ^_^

    Comment by meriel — May 16, 2011 @ 9:27 pm

  7. Thanks. this helped

    Comment by Miti — July 27, 2011 @ 1:04 am

  8. thanks for the information. it helped me to install anova function in excell 2007

    Comment by prasad — July 31, 2011 @ 1:09 am

  9. great instructions….thanks!

    Comment by Leigh — March 23, 2012 @ 9:43 am

  10. Thanks for the instructructions. They worked.
    May the Lord bless you.

    Comment by Anthony Okuefuna — June 16, 2012 @ 2:15 pm

  11. It works, thank you so much

    Comment by Nkosi kaptein — July 5, 2012 @ 10:54 am

  12. Thank you so much!

    Comment by mar — August 28, 2012 @ 8:53 pm

  13. I tried this, but it did not work. I need extra help, please.

    Comment by Grace — November 5, 2012 @ 11:51 am

  14. I need more clarification please

    Comment by Ndiuno — November 15, 2012 @ 8:28 am

  15. NICE! really helped

    Comment by elvis — February 5, 2013 @ 11:39 am

  16. Or a property (like most other Forms are regarded as)?

    Comment by Socrates Theme Members Area — August 2, 2013 @ 2:54 pm

  17. This technique identifies triggers of early ejaculation.

    Comment by Ejaculation Trainer by Matt Gorden Pdf — August 5, 2013 @ 8:52 am

  18. simple and easy. worked well . thank you

    Comment by akxy — July 19, 2015 @ 8:09 am

  19. This website is completely gret. I’ve researched these informations a whole lot and I realised that is good written, fast to comprehend.
    I congratulate you because of this article that I am going to
    tell to people friends. I request you to visit the site where each college
    student or college student can calculate results grade point average marks.
    Thank you!

    Comment by Sebrina Vanhoff — March 31, 2018 @ 11:42 am

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Create a free website or blog at

%d bloggers like this: