IET3403 NAME: _________________________
INDUSTRIAL EXPERIMENTATION
TEST 3
SIMPLE LINEAR REGRESSION
| y | x | xy | xx | yy |
| 11.4 | 0 | 0 | 0 | 129.96 |
| 11.9 | 1 | 11.9 | 1 | 141.61 |
| 7.1 | 2 | 14.2 | 4 | 50.41 |
| 14.2 | 3 | 42.6 | 9 | 201.64 |
| 5.9 | 4 | 23.6 | 16 | 34.81 |
| 6.1 | 5 | 30.5 | 25 | 37.21 |
| 5.4 | 6 | 32.4 | 36 | 29.16 |
| 3.1 | 7 | 21.7 | 49 | 9.61 |
| 5.7 | 8 | 45.6 | 64 | 32.49 |
| 4.4 | 9 | 39.6 | 81 | 19.36 |
| 4 | 10 | 40 | 100 | 16 |
| 2.8 | 11 | 30.8 | 121 | 7.84 |
| 2.6 | 12 | 31.2 | 144 | 6.76 |
| 2.4 | 13 | 31.2 | 169 | 5.76 |
| 5.2 | 14 | 72.8 | 196 | 27.04 |
| 2 | 15 | 30 | 225 | 4 |
| 94.2 | 120 | 498.1 | 1240 | 753.66 |
Based on the table on the front of the test, perform the following tasks:
- Graph and plot the 16 points (Use the blank graph on the next page of this test). (4 Points)
- Use the graph to estimate the Y intercept value Y Intercept = ___________ (4 Points)
- Use the graph to estimate Y if X = 3.5 Y Estimate = ___________ (4 Points)
- Calculate SSxy (4 Points)
- Calculate SSxx (4 Points)
- Calculate β1 (4 Points)
- Calculate β0 (4 Points)
- What is the Best Fit Line Equation for the 16 points based on Least Squares Linear Regression? (4 Points)
9. Use the Equation to estimate Y if X = 3.5 Y Estimate = ___________ (4 Points)
- What is the Correlation Coefficient and what does the value tell you about the correlation between X and Y?
(4 Points)
11. What is the Coefficient of Determination and what does the value tell you about the correlation between X and Y?
(4 Points)
12. Based on your graph, does the data appear to be linear? – give comments to support your answer. (4 Points)
SIMPLE LINEAR REGRESSION
| y | x | xy | xx | yy |
| Predicted Y | Residuals | Res. Squared |
| 11.4 | 0 | 0 | 0 | 129.96 |
| 10.48456 | 0.915441 | 0.838032554 |
| 11.9 | 1 | 11.9 | 1 | 141.61 |
| 9.871559 | 2.028441 | 4.114573621 |
| 7.1 | 2 | 14.2 | 4 | 50.41 |
| 9.258559 | -2.15856 | 4.659376179 |
| 14.2 | 3 | 42.6 | 9 | 201.64 |
| 8.645559 | 5.554441 | 30.85181682 |
| 5.9 | 4 | 23.6 | 16 | 34.81 |
| 8.032559 | -2.13256 | 4.547807121 |
| 6.1 | 5 | 30.5 | 25 | 37.21 |
| 7.419559 | -1.31956 | 1.741235479 |
| 5.4 | 6 | 32.4 | 36 | 29.16 |
| 6.806559 | -1.40656 | 1.978407714 |
| 3.1 | 7 | 21.7 | 49 | 9.61 |
| 6.193559 | -3.09356 | 9.570106173 |
| 5.7 | 8 | 45.6 | 64 | 32.49 |
| 5.580559 | 0.119441 | 0.014266195 |
| 4.4 | 9 | 39.6 | 81 | 19.36 |
| 4.967559 | -0.56756 | 0.322123014 |
| 4 | 10 | 40 | 100 | 16 |
| 4.354559 | -0.35456 | 0.125711957 |
| 2.8 | 11 | 30.8 | 121 | 7.84 |
| 3.741559 | -0.94156 | 0.886533012 |
| 2.6 | 12 | 31.2 | 144 | 6.76 |
| 3.128559 | -0.52856 | 0.279374426 |
| 2.4 | 13 | 31.2 | 169 | 5.76 |
| 2.515559 | -0.11556 | 0.013353841 |
| 5.2 | 14 | 72.8 | 196 | 27.04 |
| 1.902559 | 3.297441 | 10.87311834 |
| 2 | 15 | 30 | 225 | 4 |
| 1.289559 | 0.710441 | 0.50472667 |
| 94.2 | 120 | 498.1 | 1240 | 753.66 |
| 94.19294 | 0.007059 | 71.32056311 |
13. Use the table above to calculate the variancefor the error squared values. (4 Points)
14. What are the upper and lower limits for estimating a 95% confidence interval test on the error squared values? (4 Points)
15. What can you say about the best-fit estimating equation based on residual analysis? (4 Points)
|
MULTIPLE REGRESSION ANALYSIS: You believe there is a correlation between an individual’s Cholesterol and Body Mass Index in estimating their Pulse Rate and have collected data presented in the chart below. Use the information in this chart to answer the questions on this and the following page. |
|
|
|
|
| |||||||
|
| Chol | BMI | Pulse |
|
|
|
|
|
|
|
|
|
|
| X1 | X2 | Y | X1*Y | X2*Y | X1*X2 | X1*X1 | X2*X2 | Y*Y | Ycalc | Residual |
Residual Squared |
|
| 522 | 23.8 | 68 | 35496 | 1618.4 | 12423.6 | 272484 | 566.44 | 4624 | 69.88872 | -1.88872 | 3.567271 |
|
| 127 | 23.2 | 64 | 8128 | 1484.8 | 2946.4 | 16129 | 538.24 | 4096 | 62.37142 | 1.628583 | 2.652283 |
|
| 740 | 24.6 | 88 | 65120 | 2164.8 | 18204 | 547600 | 605.16 | 7744 | 75.371 | 12.629 | 159.4916 |
|
| 49 | 26.2 | 72 | 3528 | 1886.4 | 1283.8 | 2401 | 686.44 | 5184 | 69.75626 | 2.243741 | 5.034374 |
|
| 230 | 23.5 | 64 | 14720 | 1504 | 5405 | 52900 | 552.25 | 4096 | 64.73988 | -0.73988 | 0.547422 |
|
| 316 | 24.5 | 72 | 22752 | 1764 | 7742 | 99856 | 600.25 | 5184 | 68.84913 | 3.150874 | 9.928007 |
|
| 590 | 21.5 | 60 | 35400 | 1290 | 12685 | 348100 | 462.25 | 3600 | 64.34764 | -4.34764 | 18.90197 |
|
| 466 | 31.4 | 88 | 41008 | 2763.2 | 14632.4 | 217156 | 985.96 | 7744 | 90.68007 | -2.68007 | 7.182754 |
|
| 121 | 26.4 | 76 | 9196 | 2006.4 | 3194.4 | 14641 | 696.96 | 5776 | 71.38427 | 4.615729 | 21.30495 |
|
| 578 | 22.7 | 60 | 34680 | 1362 | 13120.6 | 334084 | 515.29 | 3600 | 67.58403 | -7.58403 | 57.51748 |
|
| 265 | 28.1 | 72 | 19080 | 2023.2 | 7446.5 | 70225 | 789.61 | 5184 | 78.33763 | -6.33763 | 40.16549 |
|
| 265 | 23.3 | 64 | 16960 | 1491.2 | 6174.5 | 70225 | 542.89 | 4096 | 64.68595 | -0.68595 | 0.470521 |
| SUMS | 4269 | 299.2 | 848 | 306068 | 21358.4 | 105258.2 | 2045801 | 7541.74 | 60928 | 847.996 | 0.004021 | 326.7642 |
- What are the three equations that would be solved simultaneously to get the 3 coefficients to make up the best-fit equation? (4 Points)
- The equation for this data model is Y = – 5.48 + 0.014711 (b1) + 2.8441 (b2)
A current patient has a cholesterol level of 740, a BMI of 24.6, and his pulse is 88 bpm. What would be his estimated pulse if he lowered his cholesterol to 200 and his BMI to 22? (4 Points)
- What is the Mean Square of the Errors? (4 Points)
- What is the standard deviation of the residuals? (4 Points)
- What is the 95% CI for the residuals? (4 Points)
- Perform the Residual Analysis. (4 Points)
- What is the Coefficient of Determination and what does the coefficient of determination tell you? (4 Points)
- What is the Calculated F value (for this model) to be used in an ANOVA test? (4 Points)
- What is the critical F value for the ANOVA Test? (4 Points)
- What is your conclusion of this test model based on the ANOVA test? (4 Points)
The post IET3403 INDUSTRIAL EXPERIMENTATION appeared first on My Assignment Online.