(All Steps) The Excel worksheet pr 4 presents the data concerning the percentage of conversion of n -heptane to acetylene and three exploratory variables
Question: The Excel worksheet pr 4 presents the data concerning the percentage of conversion of n -heptane to acetylene and three exploratory variables (Himmelbau et al. [1970]). These are typical chemical process data for which a full quadratic response surface in all three regressors is often considered to be an appropriate tentative model.
- Fit a regression model and perform a thorough analysis of the results. Analyze if the model is adequate.
- Analyze if a transformation is required to make the model adequate.
- Fit the transformed model. Is multicollinearity still an issue? Do all the variable significant?
- Determine a best fitted model that is adequate (normality and no-multicollinearity.
Price: $2.99
Solution: The downloadable solution consists of 8 pages
Deliverable: Word Document 