Home / Statistical Tools / Analysis Tools
Analysis Tools¶
QXL Stat Tools > Analysis Tools. Fifteen tool page sets, covering every command on that menu. Every one of them opens the same Data Selection window first, so the Source Data Formats page is worth reading once before any of them.
Capability¶
- Cpk/Histogram, the histogram with capability indices against your specification limits. Capability Analysis and Histogram on the ribbon both open it
- Capability Scorecard, one row per characteristic across a whole product or process
Distributions and shape¶
- Summary Statistics
- Box Plot
- Dot Plot
- Johnson Transformation, for making non-normal data normal enough to use
- Tolerance Interval, normal and non-parametric
Counting and ranking¶
Relationships and order¶
- Scatter Plot
- Run Chart
- Correlation and Covariance, Pearson, Spearman and covariance
- Time Series, trend analysis, moving average, double exponential smoothing, autocorrelation, partial autocorrelation and cross correlation
Intervals¶
- Confidence Interval, for a mean, a standard deviation, a proportion and a rate of occurrence
What the sheet records about your settings¶
The User input box in the top left of the worksheet does not only echo the columns you picked. Under a Settings heading it also states the options that produced the chart below it, so a sheet opened a year later says what it was built from rather than leaving you to guess which boxes were ticked.
This matters most where the choice leaves no other trace. Two Pareto charts drawn from the same data, one grouping the small categories into an "Others" bar and one dropping them, look like two different data sets unless the sheet says which was done.
Two rules decide what appears:
- Every selector and checkbox is printed on every run, whether or not you changed it from the default. A reader who sees nothing cannot tell a default from a setting the product does not report, so the box states all of them.
- A value you had to type is printed only when you typed it, and so is a setting that only means something once another box is ticked. Its absence is the answer.
The worksheet is protected¶
Under the last block in column A, in small italic text, the sheet carries one note:
This worksheet is protected to prevent accidental changes. To unprotect it, select the Review tab and then Unprotect Sheet.
Every analysis worksheet Quantum XL writes is protected, and every one carries this note. The wording is the same on all of them. Protection is there so that a click or a stray keystroke cannot overwrite a number the chart is drawn from, or move a chart off its anchor.
Three things are still allowed while the sheet is protected: formatting cells, formatting columns, and formatting rows. So you can widen a column, change a number format, or restyle a heading without unprotecting anything. Editing a value, editing a chart, and everything else are blocked.
For those, unprotect the sheet from Excel's Review tab, exactly as the note says. The protection carries no password, so Unprotect Sheet takes it straight off without asking for one.
Which rows appear is per tool, and each tool's own page lists them. Not every tool has the block:
| Tool | What its sheet records |
|---|---|
| Pareto, Pie Chart, Box Plot, Bar Chart, Dot Plot, Scatter Plot | a Settings block in the User input box |
| Cpk/Histogram | the same idea, with its rows written straight into the box rather than under their own heading, so its labels end in a colon where the others' do not |
| Time Series | a Settings block naming only the parameters the smoothing method you chose actually used |
| Johnson Transformation | no settings block. It prints a sentence saying whether the transform was applied, declined or failed |
| Tolerance Interval | its confidence, coverage and interval side, echoed in its own results table rather than the User input box |
| Confidence Interval | the level, in its results heading, which reads 95% Confidence Interval Results |
Every tool has the same set of pages¶
| Page | What it holds |
|---|---|
| index | what the tool does, what it needs, and what lands on the worksheet |
| Preparing Your Data | which data layouts the tool accepts, with an example per layout |
| Options | every control in its dialog |
| How-To | a walkthrough with data you can copy into Excel and numbers to check against |
| Math Details | the equations, for the tools that compute something |