REGRESSION ANALYSIS
FRED FINKELSTEIN SAP, CRM, CSM, ERP, PM, BA
PARTNER at IRONDESIGNER CONSULTING CO.
LINEAR REGRESSION
Analysis
by
Iron Designer LLC
Engineering Services Co.
Feb 11th 2021
ABSTRACT:
Linear Regression is a mathematical method that is used by engineers frequently to reverse engineer data from which comes from an unknown source. Such data collection from an engineering system, machine, function, prototype signal or vibrational mechanism for example requires that through engineering the data be analyzed for system level predictive analysis to within a tolerance band. An example is shown in Figure A of such a set of data that an engineer would collect and use linear regression to determine a predictive model within a tolerance band to assist the engineer in understanding and designing the system response elements, i.e. a damper, spring, sensing unit, communications module, etc. Though many other forms of regression exist, the introductory example is the linear example. This paper will provide the derivation of the equations and an example of how a spread sheet, such as Microsoft Excel can assist the engineer in developing the model equation (red line) to provide the engineer with the useful equation of the predictive model and compute the tolerance band (upper and lower) parallel band lines to determine the envelope of design for the engineer’s final result.??
https://drive.google.com/file/d/1_dZjSOv2wPKJMX5ZJlavj7tce0M3lymk/view?usp=drivesdk
PARTNER at IRONDESIGNER CONSULTING CO.
2 年Uses Basic & C/C++ and validates data in Excel.