Question: Data in the table below summarize results from a series of experiments designed to explore how the factors XI (10, 15, or 20), X2 (1.5

 Data in the table below summarize results from a series of

Data in the table below summarize results from a series of experiments designed to explore how the factors XI (10, 15, or 20), X2 (1.5 or 2.0), and X3 (350, 500, or 600) influence the yield (95.6 SYS 100.9) from a process X2 = 1.5 X2 = 2.0 X3 X3 XI 350 500 600 350 500 600 96.6 97.7 99.4 98.4 99.6 100.6 10 96 96 99.8 98.6 100.4 100.9 98.5 96 98.4 97.5 98.7 99.6 15 97.2 96.9 97.6 98.1 96 99 97.5 95.6 97.4 97.6 97 98.5 20 96.2 98.1 98.4 97.8 99.8 96.6 Rearrange the data to create a dataframe comprised of four columns: X1, X2, X3. and Y. Use that dataframe to create a multiple linear regression model showing Y as a function of the six independent variables: XI + x2 + x3 + XI*X2 + X1*X3 + X2*X3. Use the output from that model to address the following questions: 1. What is the p-value associated with the overall F-statistic for the model? 2. What is the value of the adjusted R-squared for the model? Create a new multiple linear regression model with the intercept set to O using the code Y = 0 + X1 + X2 + X3 + X1*X2 + X1*X3 + X2*X3. Use the output from that model to address the following questions: 3. What is the p-value associated with the overall F-statistic for the model? 4. What is the value of the adjusted R-squared for the model? Data in the table below summarize results from a series of experiments designed to explore how the factors XI (10, 15, or 20), X2 (1.5 or 2.0), and X3 (350, 500, or 600) influence the yield (95.6 SYS 100.9) from a process X2 = 1.5 X2 = 2.0 X3 X3 XI 350 500 600 350 500 600 96.6 97.7 99.4 98.4 99.6 100.6 10 96 96 99.8 98.6 100.4 100.9 98.5 96 98.4 97.5 98.7 99.6 15 97.2 96.9 97.6 98.1 96 99 97.5 95.6 97.4 97.6 97 98.5 20 96.2 98.1 98.4 97.8 99.8 96.6 Rearrange the data to create a dataframe comprised of four columns: X1, X2, X3. and Y. Use that dataframe to create a multiple linear regression model showing Y as a function of the six independent variables: XI + x2 + x3 + XI*X2 + X1*X3 + X2*X3. Use the output from that model to address the following questions: 1. What is the p-value associated with the overall F-statistic for the model? 2. What is the value of the adjusted R-squared for the model? Create a new multiple linear regression model with the intercept set to O using the code Y = 0 + X1 + X2 + X3 + X1*X2 + X1*X3 + X2*X3. Use the output from that model to address the following questions: 3. What is the p-value associated with the overall F-statistic for the model? 4. What is the value of the adjusted R-squared for the model

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Chemical Engineering Questions!