FAQ

Responses to frequently asked questions will be posted here as they arise. While technical support is not officially provided, you can contact me with questions and I'll do my best.

This FAQ also lists known bugs with EZAnalyze, and their fixes.

Installation

(Please be sure to read the installation instructions if you have not done so already)

I have a German or Portuguese installation of Excel. Why doesn't EZAnalyze work?

EZAnalyze Version 3.0 will very likely work, with the exception of Linear Regression, which will not work. People with Excel installations other than English should consider using Version 2.5.

Why is the "Add Ins" option on the Tools menu in Excel grayed out and not available?

You need to have a workbook open to 'manually' install EZAnalyze. To create a new blank workbook, go to the File menu and select New, then select Blank Workbook.

In Version 3.0, you can use the automated installer.

Why don't you have an automatic setup program for EZAnalyze?

Fixed in version 3.0. However, some may still choose to install 'manually'

Use

(Please look at online help and the User Manual and Tutorials - many questions can be answered there)

Every time I close Excel, I am prompted for an EZAnalyze Password - what is wrong?

This is a known problem with Google Desktop, and affects all Excel Add-Ins - not just EZAnalyze. You can uninstall the Google Desktop (recommended, particularly if you do not use it), or you can use the 'Password Prompt Fixer', which is a free download located at Add-Ins.com.

The EZAnalyze menu is there, but nothing seems to work - what can I do?

Try single-clicking on any cell in your data sheet, then try the EZAnalyze menu again. The EZAnalyze menu will not work if you have double clicked on a cell or a worksheet tab because Excel thinks you are trying to edit things, and will not let you do anything else until it knows you are done editing.

The EZAnalyze Menu disappeared, but Excel is still open - where did it go?

If you quit Excel and then change your mind, the EZAnalyze menu disappears. This is a 'feature' that prevents EZAnalyze menus from piling up. Close and reopen Excel, and the menu will reappear.

EZAnalyze works until I try to use the "new variable" function.

On some computers, you need to change the macro security setting to be lower. Go to the Tools menu, select Macro, then Security. Move the security setting to be one lower than it is, select OK, then restart Excel by closing and opening it. THIS WILL HAPPEN IF YOU DO NOT FOLLOW THE INSTALLATION INSTRUCTIONS EXPLICITLY. Double-clicking on ezanalyze.xla to install it is not recommended, and appears to be the cause of this error.

When I try to make a histogram, I get an "Update Values" box instead.

This indicates that your data sheet name has an unacceptable character in it. Rename the sheet so that it only contains letters and number with no spaces.

Added error message prompting for user to fix in version 2.5
Sheet is automatically renamed in version 3.0

When I try to get percentages for a list of variables, some of the results seem wrong.

There seems to be a problem currently when percentages are calculated for variables that do not vary much. When I have time I will investigate further...

Fixed in version 2.5

I get an error when I try to run an independent samples t-test

There is a problem with the independent samples t-test if your grouping variable has missing values. To run the t-test, simply replace the missing values with any character and run the test again. Again, when I have time, I will look into this issue.

Fixed in version 2.5

Chi Square doesn't seem to work properly

There is a known problem with the Chi Square function that appears occasionally when there is only one value in your rows variable. This issue is not fixed yet. As a work around, it is recommended that you try switching your rows and columns variables to validate results.

I don't see the Regression function in Version 3.0

This means that you do not have the needed add in, 'atpvbaen.xla' (Analysis Toolpak - VBA), on your computer. You may need to install this option from your Office CD. If your Excel installation is in a language other than English, Regression will not work, and you will not have the 'atpvbaen.xla' file.