Fit Data Preparation
Good data preparation is the most important factor for stable fitting outcomes.
Preparation Checklist
- Ensure variable units are consistent.
- Remove obvious outliers before fitting.
- Keep enough samples to identify unknown coefficients.
- Keep variable ranges representative of the target operating region.
Table Preparation Patterns
- Forward calculation:
- Fill variable columns only.
- Coefficient fitting:
- Fill variable columns and actual-value column.
- Target inversion:
- Fill actual-value column; optionally provide variable initial guesses.
Quality Gates
- No empty required cells.
- No non-numeric values in numeric fields.
- No duplicated rows that add no information.
- No unit mismatch across rows.
Suggested Sampling Strategy
- Cover both low and high ends of operating ranges.
- Avoid all samples clustered in a narrow range.
- Add independent verification rows not used for fitting.