Working with Analyses & ReportsStatistical analyses describe the observed data, make inferences about a population based on a sample of data, fit models that describe the relationship between variables, reduce the dimensionality of large datasets, and much more.

• Analysis reports
  An analysis report is a standard Excel worksheet containing statistics and plots calculated by a statistical analysis. You can print, send, move, copy, and save analysis reports like any other worksheet.
• Numerical accuracy
  All calculations are performed using double-precision IEEE 754 standard, highly reliable numerical methods, and then tested rigorously.
• Presentation of numerical data
  Although all results are computed to high precision, they are presented only to a practical number of decimal places based on the numerical precision of the data.

Create a statistical analysis and present the results.

1. Click a cell in the dataset.
2. On the Analyse-it ribbon tab, in the Statistical Analyses group, click the analysis command, and then click a specific task command.

   The analysis task pane opens.

3. Select the variables to analyze.
4. Add any additional plots, tests or statistics.
5. Set any options for analysis.
6. Click Calculate.

   The analysis report opens.

An analysis report is a standard Excel worksheet containing statistics and plots calculated by a statistical analysis. You can print, send, move, copy, and save analysis reports like any other worksheet.

Along with the results of the analysis, the report includes a header that describes the analysis, the dataset and variables analyzed, who performed the analysis and when, and the version of Analyse-it used.

Analysis reports are static. If the underlying data changes, the statistics and plots do not update automatically. You must recalculate an analysis to update it. For example, if you exclude or change the value of an observation, add or remove a case, or change the active filter, you must recalculate the analysis to see the effect of the changes.

You can also edit an analysis to make changes such as adding or removing a plot, performing a statistical test, or estimating a parameter.

Change an analysis and update the report.

1. Activate the report worksheet.
2. On the Analyse-it ribbon tab, in the Report group, click Edit.

   The analysis task pane opens.

3. Change the variables, set the analysis options, or add/remove tasks.
4. Click Recalculate.

   The analysis report updates.

Recalculate an analysis when the data has changed, and you want to update the report to reflect those changes.

1. Activate the report worksheet.
2. On the Analyse-it ribbon tab, in the Report group, click Recalculate.
   Note: Prior to version 5.10 the active filter is not saved with the analysis. When you recalculate an analysis the rows currently visible are analyzed, regardless of the filter you used when creating the analysis. From version 5.10 onwards, by default the filter criteria are saved with the analysis and re-applied when you recalculate or make other changes to the analysis. The drop-down arrow next to the Filter command on the ribbon of the active analysis lets you change between Use active filter which always uses the currently active filter when recalculating (pre version 5.10 behavior) and Save Filter & Re-apply (version 5.10 or later behavior) which saves the filter when the analysis is calculated and re-applies it on subsequent recalculation.

   The analysis recalculates and the report updates.

Exclude observations, such as outliers or influential observations, from analysis to see their effect on the results.

1. Activate the dataset worksheet.
2. Select the cells containing the observations to exclude/include.
3. On the Analyse-it ribbon tab, in the Dataset group, click Include / Exclude.

   The observations will be excluded (or re-included) in future analyses.

Change an analysis and output the results to a new report.

1. Activate the report worksheet.
2. On the Analyse-it ribbon tab, in the Report group, click Clone.

   The analysis task pane opens with the existing analysis options.

3. Change the variables, set the analysis options, or add/remove tasks.
4. Click Calculate.

   A new analysis report opens. The original analysis report is left unchanged.

Print a publication-quality report of the analysis.

1. Activate the report worksheet.
2. On the Analyse-it ribbon tab, in the Report group, click Print.
   The Print Preview window opens.
3. Choose the printer options.
4. Click Print.

Set whether to print reports in color or black and white.

1. Activate the report worksheet.
2. On the Analyse-it ribbon tab, in the Report group, click the Print drop-down button, and then click Color or Black and White.
   Your choice is saved as the default. In future, you can just click Print to print using the new default.
3. Choose the printer options.
4. Click Print.

Print a single high-resolution chart scaled to fill a single page.

1. Activate the report worksheet.
2. Click on the plot to select it.

   The plot shows a thick border around it to indicate that it is selected.

3. On the Analyse-it ribbon tab, in the Report group, click Print.
   The Print Preview window opens.
4. Choose the printer options.
5. Click Print.

View the data analyzed and exclude observations, filter, or make other changes to it.

1. Activate the report worksheet.
2. On the Analyse-it ribbon tab, in the Report group, click Go to Dataset.

   The workbook containing the dataset opens.

Set the Excel user name to show on analysis reports.

1. Open the Options window:
   • In Excel 2007, click the Office button, and then click Excel Options.
   • In Excel 2010, click File, and then click Options.
2. Change the User name.
3. Click OK.
   The changes are saved and will be used in future analyses.

All calculations are performed using double-precision IEEE 754 standard, highly reliable numerical methods, and then tested rigorously.

To ensure that Analyse-it produces accurate results it does not use any Excel mathematical, statistical or distribution functions. Many of these functions in early versions of Microsoft Excel used poor algorithms that often produced inaccurate results. Functions like STDEV and LINEST were affected, as were add-ins that used those functions. Microsoft has now addressed most of the problems, though you may still hear warnings against using Microsoft Excel for statistical analysis.

To avoid any of these problems Analyse-it uses reliable numerical algorithms and all calculations are performed using double-precision (IEEE 754 standard, effectively 15 significant digits). We then verify the statistics are correct, and remain so, throughout the development and release process using an in-house library of thousands of validation unit-tests.

Although all results are computed to high precision, they are presented only to a practical number of decimal places based on the numerical precision of the data.

To decide how many decimal places to present the results to Analyse-it uses the Excel number format you apply to the data. From the format, the precision you are working with is inferred, and therefore the precision you likely expect in the presentation of the statistics. Statistics such as the mean, median, and standard deviation are presented to one more decimal place than the source data.

Although the statistics are presented to only a few decimal places, the Excel cell contains the full precision value. You should use the full precision value to minimize error when using it in another calculation.

If you are preparing an analysis for presentation you can set the Excel number format applied to a cell containing a statistic on the analysis report. Do not format results if you intend to edit or recalculate the analysis as your formatting changes will be lost when you update the report.

Use the full precision of a statistic when you want to use it in further calculations.

1. If the Excel formula bar is not visible, on the View ribbon tab, in the Show group, select the Formula bar check box.
2. Click in the cell containing the statistic.

   The Excel formula bar shows the value with up to 15 significant digits.