MegaStat® Download and Help Page
Downloading the Add-in
Click here to install the MegaStat® add-in for Excel® 2007/2010/2013 (.EXE, 2.5 Mb)
Click here to install the MegaStat® add-in for Excel® Mac®: 2011 (.ZIP, 1.8 Mb)
Click here to download the MegaStat® User’s Guide (PDF, 3.5 Mb)

System Requirements:
Operating system (32 or 64 bit): Windows® XP® / Vista® / 7® / 8® and Mac® OS-X®
Excel® 32 bit versions: 2007 / 2010 / 2013 and Excel® Mac®: 2011
You must use the version designed for your operating system. If you want more technical details regarding MegaStat® system requirements and the installation process, see the FAQ document posted at www.mhhe.com/megastat. MegaStat® Start-up Instructions
 How to Install the Windows® version:
After clicking on the link above, you will be prompted to run or save the file. Click ‘Run’ and the add-in will install to a default add-ins directory. You will also get a pop-up window for User Account Control.
Click Yes to proceed. It is recommended that you accept all default settings as the program prompts during the installation. You must exit Excel® before running the installation program.
The file you are running is an executable (.exe). Some firewalls may block .exe files for security purposes. If you receive warnings when you try to download/run this file, please follow the instructions of your firewall program to allow this download.
NOTE: You may need administrative rights to install this software on your computer.

To activate MegaStat:


After running the MegaStat® installer program, you need to get MegaStat® on the Excel Add-Ins ribbon by doing the following steps. You should only have to do this once.
1. Start Excel
2. Go to Excel Options



Excel® 2010 & 2013: File → Options
Excel® 2007: Office Button → Excel Options (at the bottom of the window)

3. Click Add-Ins on the left menu list. You will now see a list of Excel® Add-Ins. MegaStat® should be in the Inactive Application Add-ins list as shown below. If you do not see it, you will need to
Browse for it at the next step.

MegaStat is initially in the
Inactive Application Add-ins list

Click here to see the Add-Ins list

4. Click Go... for Manage Excel Add-Ins near the bottom of the screen and the Add-ins window will appear.
5. Click the check box next to MegaStat® in the Add-Ins list unless it is already checked.
Click OK when MegaStat® is checked. If more than one MegaStat® is listed you probably did not uninstall earlier version. Check only the latest version and after completing the next step go to
Control Panel and uninstall the previous version.

Note that some other add-ins are shown in the list and your screen may show different ones. The others are not required or relevant for MegaStat.

6. Click the Add-Ins ribbon. MegaStat® will be on the ribbon and ready to use as shown below.
Your computer may also show other installed add-ins. MegaStat® should remain on the Add-ins ribbon until you remove it. The MegaStat® User’s Guide has an appendix that shows how to access MegaStat® from the Excel Quick Access Toolbar.
Excel® 2010/2013:

Excel® 2007:

Uninstalling MegaStat
First remove MegaStat® from the Add-Ins list by MegaStat → Utilities → Remove MegaStat. Note that
MegaStat® will not be removed from the Add-ins list until you exit Excel®. (You can also remove
MegaStat® with Excel Options by unchecking MegaStat® in the Add-ins list.)
Then uninstall MegaStat® by going to Control Panel → Programs. Find the MegaStat® listing, and click on it to start the uninstall procedure. The appearance of the Control Panel, the terminology, and how you access it varies with different versions of Windows® but you should find an item relating to programs.

 How to Install the Mac® version:
MegaStat® for the Mac® has all of the features of the Windows® version and works the same way. The design and appearance of some of the dialog boxes will be slightly different from the Windows® version, but the functionality is the same and you can use the MegaStat® User's Guide and video tutorials.
Run the installation program (MegaStat.pkg). It should run automatically after downloading. Administrator privileges are required. The following screen will appear.

1. Click Continue to view the Read Me file. There are option buttons to print or save the file.
2. Click Continue to view the License Agreement. There are option buttons to print or save the file.
3. Click Continue and click Agree to accept the License Agreement.
4. Click Install to start the installation.
5. Click Close.

To activate MegaStat:
After running the installation program you need to get MegaStat® on Excel®'s main menu with the following steps:
1. Open Excel → File → New Workbook (or open an existing Excel® workbook)
2. Tools → Add-Ins...

You will then see a window similar to this:

Your add-in list may look different. Any add-ins other than MegaStat® are not required or relevant. Make sure MegaStat® is checked and click OK. MegaStat® will then be on the main Excel® menu whenever you open Excel®. Click on MegaStat® to open the main menu.

If you want to remove MegaStat® from the menu bar, go to Tools → Add-Ins... and uncheck MegaStat.

MegaStat® User’s Guide and Tutorials
Note that the video tutorials and the MegaStat® User’s Guide may appear somewhat different from your screen depending on your version of Excel®, operating system (Windows® or Mac®), and your themes and colors. Click here to download the MegaStat® User’s Guide (PDF, 3.5 Mb)
Click here to download the sample data referred to in the MegaStat® User’s Guide

Video Tutorials
The following video tutorials are available to help with the use of MegaStat. Some files are large and may take a few moments to run on a slow connection:


Introduction



Frequency distribution (quantitative)



Frequency distribution (qualitative)



Normal distribution



Hypothesis testing



Scatter plot and regression



Multiple regression