Question

A chemical plant wants to predict the percentage purity of oxygen produced in a distillation process from the percentage of hydrocarbons that are present in the main condenser of the distillation unit. The plant manager has collected the following observations: (this data is available on Canvas on the "Homework 6 Data.xlsx" workbook) Observation Hydrocarbon Prity ( level (%) 0.99 1.02 1.15 1.29 1.46 1.36 0.87 1.23 1.55 number 90.01 89.05 91.43 93.74 96.73 94.45 87.59 91.77 99.42 93.65 93.54 92.52 90.56 89.54 89.85 90.39 93.25 93.41 94.98 87.33 10 12 13 14 15 16 17 18 19 20 1.19 1.15 0.98 1.01 1.11 1.2 1.26 1.32 1.43 0.95 (a) Fit a linear regression model to describe the relationship between the percentage purity of oxygen and percentage of hydrocarbons in the main condenser of the distillation unit. Report the regression statistics and the point the coefficients. estimates, standard error, and confidence intervals of (b) Imagine that the next hydrocarbon level observation is 1.04%. what would be your best estimate of the oxygen purity percentage?

Please show all work, I will give a positive rating. Thank you!

Answer 1

File Review View Tell me what you want to do Home Insert Draw Page Layout Formulas From Text/CSV L Recent Sources From Web Data Queries & Connections AL ZIA Properties Clear Reapply AdvancedComns Existing Connections Get 幽From Table/Range Refresh AllEdit Links Sort Filter Text to Data · Get & Transform Data Queries & Connections Sort & Filter Data Tool Hydrocarbon 1 Obs no. level (%) Purity (%) 0.9990.01 1.02 89.05 1.1591.43 1.2993.74 96.73 94.45 0.8787.59 1.2391.77 1.55 99.42 93.65 93.54 92.52 0.9890.56 1.01 89.54 1.1189.85 90.39 93.25 93.41 1.4394.98 0.95 87.33 Data Analysis Analysis Tools OK Exponential Smoothing F-Test Two-Sample for Variances Fourier Analysis Histogram Moving Average Random Number Generation Rank and Percentile Regression Sampling t-Test: Paired Two Sample for Means 4 Cancel 6 1.46 Help 1.36 10 1.4 1.19 1.15 13 12 13 15 15 16 17 18 19 1.2 1.26 1.32 17 20

File Home Insert Draw Page Layout Formulas Tell me what you want to do RevieW View From Text/CSV 「(Recent Sources Queries &Connections AZA ear A Z From Web Existing Connections Properties SortFilter Reapply Text to Get Refresh From Table/Range All La Edit Links Advanced Columns Ar Get & Transform Data Queries & Connections Sort & Filter Data Tools Regression D2 Input OK Input Y Range: Input X Range: Labels $C$1:$C$21 $B$1:$B$21 Constant is Zero Hydrocarbon Cancel 1 Obs no. level (%) Purity (%) 90.011 .02 89.05 91.43 1.29 93.74 96.73 1.3694.45 87.59 1.23 91.77 1.55 99.42 93.65 1.19 93.54 92.52 0.98 90.56 1.01 89.54 89.85 1.2 90.39 93.25 1.32 93.41 94.98 0.95 87.33 0.99 Help 4 1.15 Confidence Level: 95 4 Output options 6 1.46 OOutput Range: SD$2 0.87 New Worksheet Ply: New Workbook Residuals 10 Residuals Standardized Residuals Residual Plots Line Fit Plots 12 1.15 Normal Probability Normal Probability Plots 15 1.11 17 1.26 20 21 19 1.43

Hydrocarbon 1 Obs no. level (%) Purity (%) 0.9990.01 SUMMARY OUTPUT 1.0289.05 1.1591.43 1.29 93.74 Multiple R 1.46 96.73 R Square 1.36 94.45 Adjusted R Square 0.87 87.59 Standard Error 1.23 91.77 Observations 1.55 99.42 Independent variable Hydrocarbon level (%) is significant as P-value < 0.05 The model is a good fit as around 88% of the variability of response variable around its mean is explained by the model Regression equation: Purity (%)-74.28331424 + 14.94747973*Hydrocarbon level (%) When hydrocarbon level observation-1.04% Oxygen Purity Percentage (%)-74.28331424 + 14.94747973*1.04 Oxygen Purity Percentage(%) Rearession Statistics 4 0.936715381 0.877435705 0.870626578 1.086529053 20 89.83 10 10 1.4 93.65 ANOVA 1.19 93.54 1.15 92.52 Regressio 0.98 90.56 Residual 1.01 89.54 Total 1.11 89.85 12 13 MS Significance F 12 13 1 152.1270781 152.1270781 128.8616943 1.22731E-09 1821.24981688 1.180545382 19 173.376895 15 15 16 17 18 19 Coefficients Standard Errort Stat 17 18 19 20 1.2 1.2693.25 Intercept 1.32 1.43 Lower 95% Upper 95% Lower 95.0% Upper 95.0% 74.28331424 1.593473376 46.61722961 3.17148E-20 70.9355509 77.63107758 70.9355509 77.63107758 93.41 Hydrocarbon level (%) 14.94747973 1.31675827 11.35172649 1.22731E-09 12.18107326 17.7138862 12.18107326 17.7138862 90.39 P-value 94.98