Context: (a) In the table below, y is the purity of oxygen produced in a chemical distillation process, and x is the percentage of hydrocarbons present in the main condenser of the distillation unit. Hydrocarbon Level x(%) Purity y(%) 0.99 90.01 1.02 89.05 1.15 91.43 1.29 93.74 1.46 96.73 1.36 94.45 0.87 87.59 1.23 91.77 1.55 99.42 1.40 93.65 1.19 93.54 1.15 92.52 0.98 90.56 1.01 89.54 1.11 89.85 1.20 90.39 1.26 93.25 1.32 93.41 1.43 94.98 0.95 87.33 using excel: i. Create a scatter plot and find a regression equation between the purity of oxygen produced in a chemical distillation process, and the percentage of hydrocarbons present in the main condenser of the distillation unit. ii. Use the regression equation to find the the purity of oxygen produced in a chemical distillation process when the percentage of hydrocarbons present in the main condenser of the distillation unit is 0.94 percent and 1.45 percent. pounds. iii. Which purity of oxygen produced in a chemical distillation process that you calculated do you think is closer to the true percentage of hydrocarbons present in the main condenser of the distillation unit? Why? iv. Find the correlation coefficient and coefficient of determination and then interpret both. v. Test at the 5 percent level for a negative correlation between the purity of oxygen produced in a chemical distillation process, and the percentage of hydrocarbons present in the main condenser of the distillation unit. vi. Find the standard error of the estimate. vii. Compute a 95 percent prediction interval for the purity of oxygen produced in a chemical distillation process that has 1.45 percentage of hydrocarbons present in the main condenser of the distillation unit. viii. Construct an ANOVA table. ix. Test whether or not there is linearity at 5 percent level of significance. [object Object]