Home / Statistical Tools / Update Analysis
Update Analysis¶
QXL Stat Tools > Update. Re-runs the analysis on the active worksheet against its data as that data now stands, keeping every setting exactly as it was.
There is no dialog. Press it and the sheet is rebuilt.
What it picks up¶
A logical extension of the original data range. Quantum XL looks at the cells beyond the range the analysis was built from and takes in what it finds there:
| Your data is arranged in | It looks for new |
|---|---|
| columns | rows |
| rows | columns |
It also picks up removals and edits. Rows taken out are dropped from the analysis, and values changed in place are re-read. Update is a refresh, not an append.
What it does not do is change any setting. The chart type, the options, the grouping and the orientation are all the ones the analysis already had. To change any of those, use Modify Analysis.
Where to stand¶
Anywhere on the worksheet the analysis wrote. Click a cell on that sheet and press Update.
On a sheet with no Quantum XL analysis the command says No Quantum XL analysis was detected on this worksheet. and stops.
Two kinds of analysis sheet, and Update handles both¶
Quantum XL works out which tool built the sheet before it does anything.
| The sheet was built by | What Update does |
|---|---|
| a v18 tool: any control chart, any analysis tool, the MSA studies | re-runs it through the current engine |
| a tool from the previous version: hypothesis tests, distribution fitting, reliability, QFD, FMEA, Pugh and the rest | runs that version's own update instead |
You do not choose between them and there is no setting for it. The one Update button serves both, which is why it works on an old workbook without your having to know which tool made which sheet.
Update Workbook¶
QXL Stat Tools > Update Workbook does the same thing to every analysis in the workbook, of both kinds, in one press. Use it when the source data has changed and several sheets read from it.
If an analysis is still running¶
A Quantum XL analysis is still running. Wait for it to finish, then try again.
Update, Modify and every analysis command share that guard, so two analyses cannot overlap on the same workbook.
See Also¶
- Modify Analysis, for changing settings rather than refreshing data
- Data Selection, how the original range was interpreted
- Updating and Modifying Control Charts, the same two commands as they apply to a control chart