XL Data Analyst Frequently Asked Questions
What is the XL Data Analyst?
It is a Microsoft Excel-based data analysis system. Users set up their data in a "Data" worksheet, and use the XL Data Analysis menu to select various data analyses. Each analysis result appears on a separate worksheet.
What analyses does it perform?
 |
|
Averages & Percents
|
 |
|
95% Confidence Intervals and Hypothesis Tests
|
 |
|
Differences tests: 2 Percents; 2 Group Averages; ANOVA; Paired
Samples Differences Test
|
 |
|
Crosstabulations, Correlations; Multiple Regression
|
 |
| Table of Random Numbers; Sample Size (Percentage) |
Version has utilities for: cleaning up your Data and Define Variables worksheets , importing data, filtering your data, and unfiltering your filtered data (returning to your original, unfiltered dataset).
How is it different from statistical programs?
| Difference | Benefits |
| Runs in Excel | Users are familiar with Excel; no need
to learn a new program Can use Excel features such as graphs, format, etc. |
| Output as professional tables (See Screenshots) | Can copy and paste tables into reports
|
| Interpreted analyses @95% level of confidence (See Screenshots) | No need to wrestle with statistical values and figure out what they mean
|
| Integrated in Basic Marketing Research by Burns & Bush | Analyses explained step-by-step in this textbook
|
Excel 2007 or higher. Version 3.0 runs on Excel 2010.
Enable macro content on Excel 2007 and 2010.
How do I install it?
There is no installation for the Basic Version 3.0.
Just download XL Data Analyst files from this website. Open a file with Excel and enable the macro content. Use the XL Data Analyst menu in the Add-ins tab.
What is the Pro Version all about?
The Professional Version is under development.
It will have features and options to satisfy individual user's needs as to data analyses and output.
