Statisctics
vikram8888
Week4ClassExerciseSolutions.xlsxP1_a
| Company Ticker | Years to Maturity (x) | Yield (y) |
Sharifzadeh Mamad: Sharifzadeh Mamad: A sample containing years to maturity and yield (%) for 40 corporate bonds is contained in the data file named CorporateBonds (Barron’s, April 2, 2012). a. Develop a scatter diagram of the data using x = years to maturity as the independent variable. Does a simple linear regression model appear to be appropriate? b. Develop an estimated regression equation with x = years to maturity and x square as the independent variables. c. As an alternative to fitting a second-order model, fit a model using the natural logarithm of years to maturity as the independent variable. Does the estimated regression using the natural logarithm of x provide a better fit than the estimated regression developed in part (b)? Explain. |
|||||||||||
| HSBC | 12.00 | 4.079 | ||||||||||||
| GS | 9.75 | 5.367 | ||||||||||||
| C | 4.75 | 3.332 | ||||||||||||
| MS | 9.25 | 5.798 | ||||||||||||
| C | 9.75 | 4.414 | ||||||||||||
| TOTAL | 5.00 | 2.069 | ||||||||||||
| MS | 5.00 | 4.739 | ||||||||||||
| WFC | 10.00 | 3.682 | ||||||||||||
| TOTAL | 10.00 | 3.270 | ||||||||||||
| TOTAL | 3.25 | 1.748 | ||||||||||||
| BAC | 9.75 | 4.949 | ||||||||||||
| RABOBK | 9.75 | 4.203 | ||||||||||||
| GS | 9.25 | 5.365 | ||||||||||||
| AXP | 5.00 | 2.181 | ||||||||||||
| MTNA | 5.00 | 4.366 | ||||||||||||
| MTNA | 10.00 | 6.046 | ||||||||||||
| JPM | 4.25 | 2.310 | ||||||||||||
| GE | 26.00 | 5.130 | SUMMARY OUTPUT | |||||||||||
| LNC | 10.00 | 4.163 | ||||||||||||
| BAC | 5.00 | 3.699 | Regression Statistics | |||||||||||
| FCX | 10.00 | 4.030 | Multiple R | 0.7257759016 | ||||||||||
| GS | 25.50 | 6.913 | R Square | 52.68% | ||||||||||
| RABOBK | 4.75 | 2.805 | Adjusted R Square | 0.5142967293 | ||||||||||
| GE | 26.75 | 5.138 | Standard Error | 1.128600817 | ||||||||||
| HCN | 7.00 | 4.184 | Observations | 40 | ||||||||||
| GE | 9.50 | 3.778 | ||||||||||||
| VOD | 5.00 | 1.855 | ANOVA | |||||||||||
| NEM | 10.00 | 3.866 | df | SS | MS | F | Significance F | |||||||
| GE | 1.00 | 0.767 | Regression | 1 | 53.8740205422 | 53.8740205422 | 42.2959385948 | 0.0000001164 | ||||||
| C | 25.75 | 8.204 | Residual | 38 | 48.4021125578 | 1.2737398042 | ||||||||
| SHBASS | 5.00 | 2.861 | Total | 39 | 102.2761331 | |||||||||
| PAA | 10.25 | 3.856 | ||||||||||||
| GS | 3.75 | 3.558 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | ||||
| TOTAL | 1.75 | 1.378 | Intercept | 2.4558718282 | 0.2831177278 | 8.6743837882 | 0.000% | 1.8827299523 | 3.0290137041 | 1.8827299523 | 3.0290137041 | |||
| MS | 4.00 | 4.413 | Years to Maturity | 0.1472739907 | 0.0226452292 | 6.503532778 | 0.000% | 0.1014311207 | 0.1931168606 | 0.1014311207 | 0.1931168606 | |||
| WFC | 1.25 | 0.797 | ||||||||||||
| AIG | 5.00 | 3.452 | ||||||||||||
| BAC | 29.75 | 5.903 | ||||||||||||
| MS | 1.00 | 1.816 | ||||||||||||
| T | 28.50 | 4.930 | ||||||||||||
Yield (y) 12 9.75 4.75 9.25 9.75 5 5 10 10 3.25 9.75 9.75 9.25 5 5 10 4.25 26 10 5 10 25.5 4.75 26.75 7 9.5 5 10 1 25.75 5 10.25 3.75 1.75 4 1.25 5 29.75 1 28.5 4.0789999999999997 5.367 3.3319999999999999 5.798 4.4139999999999997 2.069 4.7389999999999999 3.6819999999999999 3.27 1.748 4.9489999999999998 4.2030000000000003 5.3650000000000002 2.181 4.3659999999999997 6.0460000000000003 2.31 5.13 4.1630000000000003 3.6989999999999998 4.03 6.9130000000000003 2.8050000000000002 5.1379999999999999 4.1840000000000002 3.778 1.855 3.8660000000000001 0.76700000000000002 8.2040000000000006 2.8610000000000002 3.8559999999999999 3.5579999999999998 1.3779999999999999 4.4130000000000003 0.79700000000000004 3.452 5.9029999999999996 1.8160000000000001 4.93
P1-b
| Company Ticker | Years to Maturity (x) | X^2 | Yield (y) | |||||||||||
| HSBC | 12.00 | 144.00 | 4.079 | SUMMARY OUTPUT | ||||||||||
| GS | 9.75 | 95.06 | 5.367 | |||||||||||
| C | 4.75 | 22.56 | 3.332 | Regression Statistics | ||||||||||
| MS | 9.25 | 85.56 | 5.798 | Multiple R | 0.8171970933 | |||||||||
| C | 9.75 | 95.06 | 4.414 | R Square | 66.78% | |||||||||
| TOTAL | 5.00 | 25.00 | 2.069 | Adjusted R Square | 64.99% | |||||||||
| MS | 5.00 | 25.00 | 4.739 | Standard Error | 0.9582500554 | |||||||||
| WFC | 10.00 | 100.00 | 3.682 | Observations | 40 | |||||||||
| TOTAL | 10.00 | 100.00 | 3.270 | |||||||||||
| TOTAL | 3.25 | 10.56 | 1.748 | ANOVA | ||||||||||
| BAC | 9.75 | 95.06 | 4.949 | df | SS | MS | F | Significance F | ||||||
| RABOBK | 9.75 | 95.06 | 4.203 | Regression | 2 | 68.3011358617 | 34.1505679309 | 37.1912028301 | 0.0000000014 | |||||
| GS | 9.25 | 85.56 | 5.365 | Residual | 37 | 33.9749972383 | 0.9182431686 | |||||||
| AXP | 5.00 | 25.00 | 2.181 | Total | 39 | 102.2761331 | ||||||||
| MTNA | 5.00 | 25.00 | 4.366 | |||||||||||
| MTNA | 10.00 | 100.00 | 6.046 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |||
| JPM | 4.25 | 18.06 | 2.310 | Intercept | 1.0169520498 | 0.4353906669 | 2.3357231265 | 2.503% | 0.134766762 | 1.8991373375 | 0.134766762 | 1.8991373375 | ||
| GE | 26.00 | 676.00 | 5.130 | Years to Maturity (x) | 0.4606362043 | 0.0813606821 | 5.6616561244 | 0.000% | 0.2957838034 | 0.6254886052 | 0.2957838034 | 0.6254886052 | ||
| LNC | 10.00 | 100.00 | 4.163 | X^2 | -0.0102531805 | 0.0025867098 | -3.9637923814 | 0.032% | -0.0154943523 | -0.0050120086 | -0.0154943523 | -0.0050120086 | ||
| BAC | 5.00 | 25.00 | 3.699 | |||||||||||
| FCX | 10.00 | 100.00 | 4.030 | |||||||||||
| GS | 25.50 | 650.25 | 6.913 | SSE(a) | 48.4021125578 | |||||||||
| RABOBK | 4.75 | 22.56 | 2.805 | SSE(b) | 33.9749972383 | |||||||||
| GE | 26.75 | 715.56 | 5.138 | MSE(a) | 0.9182431686 | |||||||||
| HCN | 7.00 | 49.00 | 4.184 | F | 0.4246391904 | |||||||||
| GE | 9.50 | 90.25 | 3.778 | |||||||||||
| VOD | 5.00 | 25.00 | 1.855 | |||||||||||
| NEM | 10.00 | 100.00 | 3.866 | |||||||||||
| GE | 1.00 | 1.00 | 0.767 | |||||||||||
| C | 25.75 | 663.06 | 8.204 | |||||||||||
| SHBASS | 5.00 | 25.00 | 2.861 | |||||||||||
| PAA | 10.25 | 105.06 | 3.856 | |||||||||||
| GS | 3.75 | 14.06 | 3.558 | |||||||||||
| TOTAL | 1.75 | 3.06 | 1.378 | |||||||||||
| MS | 4.00 | 16.00 | 4.413 | |||||||||||
| WFC | 1.25 | 1.56 | 0.797 | |||||||||||
| AIG | 5.00 | 25.00 | 3.452 | |||||||||||
| BAC | 29.75 | 885.06 | 5.903 | |||||||||||
| MS | 1.00 | 1.00 | 1.816 | |||||||||||
| T | 28.50 | 812.25 | 4.930 |
Yield (y)
12 9.75 4.75 9.25 9.75 5 5 10 10 3.25 9.75 9.75 9.25 5 5 10 4.25 26 10 5 10 25.5 4.75 26.75 7 9.5 5 10 1 25.75 5 10.25 3.75 1.75 4 1.25 5 29.75 1 28.5 4.0789999999999997 5.367 3.3319999999999999 5.798 4.4139999999999997 2.069 4.7389999999999999 3.6819999999999999 3.27 1.748 4.9489999999999998 4.2030000000000003 5.3650000000000002 2.181 4.3659999999999997 6.0460000000000003 2.31 5.13 4.1630000000000003 3.6989999999999998 4.03 6.9130000000000003 2.8050000000000002 5.1379999999999999 4.1840000000000002 3.778 1.855 3.8660000000000001 0.76700000000000002 8.2040000000000006 2.8610000000000002 3.8559999999999999 3.5579999999999998 1.3779999999999999 4.4130000000000003 0.79700000000000004 3.452 5.9029999999999996 1.8160000000000001 4.93
P1_c
| Company Ticker | Years to Maturity (x) | LN(X) | Yield (y) | |||||||||||
| HSBC | 12.00 | 2.48 | 4.079 | SUMMARY OUTPUT | ||||||||||
| GS | 9.75 | 2.28 | 5.367 | |||||||||||
| C | 4.75 | 1.56 | 3.332 | Regression Statistics | ||||||||||
| MS | 9.25 | 2.22 | 5.798 | Multiple R | 0.8182427286 | |||||||||
| C | 9.75 | 2.28 | 4.414 | R Square | 66.95% | |||||||||
| TOTAL | 5.00 | 1.61 | 2.069 | Adjusted R Square | 66.08% | |||||||||
| MS | 5.00 | 1.61 | 4.739 | Standard Error | 0.9431204857 | |||||||||
| WFC | 10.00 | 2.30 | 3.682 | Observations | 40 | |||||||||
| TOTAL | 10.00 | 2.30 | 3.270 | |||||||||||
| TOTAL | 3.25 | 1.18 | 1.748 | ANOVA | ||||||||||
| BAC | 9.75 | 2.28 | 4.949 | df | SS | MS | F | Significance F | ||||||
| RABOBK | 9.75 | 2.28 | 4.203 | Regression | 1 | 68.4760355768 | 68.4760355768 | 76.9846699446 | 0.0000000001 | |||||
| GS | 9.25 | 2.22 | 5.365 | Residual | 38 | 33.8000975232 | 0.8894762506 | |||||||
| AXP | 5.00 | 1.61 | 2.181 | Total | 39 | 102.2761331 | ||||||||
| MTNA | 5.00 | 1.61 | 4.366 | |||||||||||
| MTNA | 10.00 | 2.30 | 6.046 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |||
| JPM | 4.25 | 1.45 | 2.310 | Intercept | 0.8278764322 | 0.379032396 | 2.1841838347 | 3.52% | 0.0605654618 | 1.5951874027 | 0.0605654618 | 1.5951874027 | ||
| GE | 26.00 | 3.26 | 5.130 | LN(X) | 1.5626089409 | 0.178093545 | 8.7740908329 | 0.00% | 1.2020774077 | 1.9231404741 | 1.2020774077 | 1.9231404741 | ||
| LNC | 10.00 | 2.30 | 4.163 | |||||||||||
| BAC | 5.00 | 1.61 | 3.699 | |||||||||||
| FCX | 10.00 | 2.30 | 4.030 | |||||||||||
| GS | 25.50 | 3.24 | 6.913 | |||||||||||
| RABOBK | 4.75 | 1.56 | 2.805 | |||||||||||
| GE | 26.75 | 3.29 | 5.138 | |||||||||||
| HCN | 7.00 | 1.95 | 4.184 | |||||||||||
| GE | 9.50 | 2.25 | 3.778 | |||||||||||
| VOD | 5.00 | 1.61 | 1.855 | |||||||||||
| NEM | 10.00 | 2.30 | 3.866 | |||||||||||
| GE | 1.00 | 0.00 | 0.767 | |||||||||||
| C | 25.75 | 3.25 | 8.204 | |||||||||||
| SHBASS | 5.00 | 1.61 | 2.861 | |||||||||||
| PAA | 10.25 | 2.33 | 3.856 | |||||||||||
| GS | 3.75 | 1.32 | 3.558 | |||||||||||
| TOTAL | 1.75 | 0.56 | 1.378 | |||||||||||
| MS | 4.00 | 1.39 | 4.413 | |||||||||||
| WFC | 1.25 | 0.22 | 0.797 | |||||||||||
| AIG | 5.00 | 1.61 | 3.452 | |||||||||||
| BAC | 29.75 | 3.39 | 5.903 | |||||||||||
| MS | 1.00 | 0.00 | 1.816 | |||||||||||
| T | 28.50 | 3.35 | 4.930 |
Yield (y)
12 9.75 4.75 9.25 9.75 5 5 10 10 3.25 9.75 9.75 9.25 5 5 10 4.25 26 10 5 10 25.5 4.75 26.75 7 9.5 5 10 1 25.75 5 10.25 3.75 1.75 4 1.25 5 29.75 1 28.5 4.0789999999999997 5.367 3.3319999999999999 5.798 4.4139999999999997 2.069 4.7389999999999999 3.6819999999999999 3.27 1.748 4.9489999999999998 4.2030000000000003 5.3650000000000002 2.181 4.3659999999999997 6.0460000000000003 2.31 5.13 4.1630000000000003 3.6989999999999998 4.03 6.9130000000000003 2.8050000000000002 5.1379999999999999 4.1840000000000002 3.778 1.855 3.8660000000000001 0.76700000000000002 8.2040000000000006 2.8610000000000002 3.8559999999999999 3.5579999999999998 1.3779999999999999 4.4130000000000003 0.79700000000000004 3.452 5.9029999999999996 1.8160000000000001 4.93
P 2-a-b
| Brand and Model | Type | Weight (x) | X^2 | Price |
Sharifzadeh Mamad: Sharifzadeh Mamad: 30. Consumer reports tested 19 different brands and models of road, fitness, and comfort bikes. Road bikes are designed for long road trips; fitness bikes are designed for regular workouts or daily commutes; and comfort bikes are designed for leisure rides on typically flat roads. The following data show the type, weight (lb.), and price ($) for the 19 bicycles tested (Consumer reports website, February 2009). a. Develop a scatter diagram with weight as the independent variable and price as the dependent variable. Does a simple linear regression model appear to be appropriate? b. Develop an estimated multiple regression equation with x = weight and x^2 as the two independent variables. c. Use the following dummy variables to develop an estimated regression equation that can be used to predict the price given the type of bike: Type_Fitness = 1 if the bike is a fitness bike, 0 otherwise; and Type_Comfort = 1 if the bike is a comfort bike; 0 otherwise. Compare the results obtained to the results obtained in part (b). d. To account for possible interaction between the type of bike and the weight of the bike, develop a new estimated regression equation that can be used to predict the price of the bike given the type, the weight of the bike, and any interaction between weight and each of the dummy variables defined in part (c). What estimated regression equation appears to be the best predictor of price? Explain. |
||||||
| Klein Rêve v | Road | 20 | 400 | 1800 | |||||||
| Giant OCR Composite 3 | Road | 22 | 484 | 1800 | |||||||
| Giant OCR 1 | Road | 22 | 484 | 1000 | |||||||
| Specialized Roubaix | Road | 21 | 441 | 1300 | |||||||
| Trek Pilot 2.1 | Road | 21 | 441 | 1320 | |||||||
| Cannondale Synapse 4 | Road | 21 | 441 | 1050 | |||||||
| LeMond Poprad | Road | 22 | 484 | 1350 | |||||||
| Raleigh Cadent 1.0 | Road | 24 | 576 | 650 | |||||||
| Giant FCR3 | Fitness | 23 | 529 | 630 | |||||||
| Schwinn Super Sport GS | Fitness | 23 | 529 | 700 | |||||||
| Fuji Absolute 2.0 | Fitness | 24 | 576 | 700 | |||||||
| Jamis Coda Comp | Fitness | 26 | 676 | 830 | |||||||
| Cannondale Road Warrior 400 | Fitness | 25 | 625 | 700 | |||||||
| Schwinn Sierra GS | Comfort | 31 | 961 | 340 | |||||||
| Mongoose Switchback SX | Comfort | 32 | 1024 | 280 | |||||||
| Giant Sedona DX | Comfort | 32 | 1024 | 360 | |||||||
| Jamis Explorer 4.0 | Comfort | 35 | 1225 | 600 | |||||||
| Diamondback Wildwood Deluxe | Comfort | 34 | 1156 | 350 | |||||||
| Specialized Crossroads Sport | Comfort | 31 | 961 | 330 | |||||||
| SUMMARY OUTPUT | |||||||||||
| Regression Statistics | |||||||||||
| Multiple R | 0.7783498779 | ||||||||||
| R Square | 0.6058285324 | ||||||||||
| Adjusted R Square | 58.26% | ||||||||||
| Standard Error | 308.5142787973 | ||||||||||
| Observations | 19 | ||||||||||
| ANOVA | |||||||||||
| df | SS | MS | F | Significance F | |||||||
| Regression | 1 | 2486932.50254511 | 2486932.50254511 | 26.128438754 | 0.0000868174 | ||||||
| Residual | 17 | 1618078.02377068 | 95181.0602218048 | ||||||||
| Total | 18 | 4105010.52631579 | |||||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | ||||
| Intercept | 2756.5625728269 | 380.2505463378 | 7.2493323136 | 0.000% | 1954.3040466838 | 3558.8210989699 | 1954.3040466838 | 3558.8210989699 | |||
| Weight (x) | -74.2018177581 | 14.5163628222 | -5.1115984539 | 0.009% | -104.8286661738 | -43.5749693424 | -104.8286661738 | -43.5749693424 | |||
| SUMMARY OUTPUT | |||||||||||
| Regression Statistics | |||||||||||
| Multiple R | 0.8776198548 | ||||||||||
| R Square | 0.7702166095 | ||||||||||
| Adjusted R Square | 74.15% | ||||||||||
| Standard Error | 242.8043498594 | ||||||||||
| Observations | 19 | ||||||||||
| ANOVA | |||||||||||
| df | SS | MS | F | Significance F | |||||||
| Regression | 2 | 3161747.28934567 | 1580873.64467283 | 26.8153971483 | 0.0000077723 | ||||||
| Residual | 16 | 943263.236970122 | 58953.9523106326 | ||||||||
| Total | 18 | 4105010.52631579 | |||||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | ||||
| Intercept | 11375.998839423 | 2565.1853129325 | 4.4347668693 | 0.04% | 5938.0489010529 | 16813.948777793 | 5938.0489010529 | 16813.948777793 | |||
| Weight (x) | -728.334547219 | 193.680949952 | -3.7604862399 | 0.17% | -1138.9198193804 | -317.7492750576 | -1138.9198193804 | -317.7492750576 | |||
| X^2 | 11.9737374888 | 3.539108687 | 3.3832635694 | 0.38% | 4.4711622287 | 19.4763127489 | 4.4711622287 | 19.4763127489 |
Price
20 22 22 21 21 21 22 24 23 23 24 26 25 31 32 32 35 34 31 1800 1800 1000 1300 1320 1050 1350 650 630 700 700 830 700 340 280 360 600 350 330
P 2-c
| Brand and Model | Type | Weight (X) | Comfort (D1) | Fitness (D2) | Price | ||||
| Klein Rêve v | Road | 20 | 0 | 0 | 1800 | Dummy Variable Assignment | |||
| Giant OCR Composite 3 | Road | 22 | 0 | 0 | 1800 | D1 | D 2 | ||
| Giant OCR 1 | Road | 22 | 0 | 0 | 1000 | Road | 0 | 0 | |
| Specialized Roubaix | Road | 21 | 0 | 0 | 1300 | Fitness | 0 | 1 | |
| Trek Pilot 2.1 | Road | 21 | 0 | 0 | 1320 | Comfort | 1 | 0 | |
| Cannondale Synapse 4 | Road | 21 | 0 | 0 | 1050 | ||||
| LeMond Poprad | Road | 22 | 0 | 0 | 1350 | ||||
| Raleigh Cadent 1.0 | Road | 24 | 0 | 0 | 650 | ||||
| Giant FCR3 | Fitness | 23 | 0 | 1 | 630 | ||||
| Schwinn Super Sport GS | Fitness | 23 | 0 | 1 | 700 | ||||
| Fuji Absolute 2.0 | Fitness | 24 | 0 | 1 | 700 | ||||
| Jamis Coda Comp | Fitness | 26 | 0 | 1 | 830 | ||||
| Cannondale Road Warrior 400 | Fitness | 25 | 0 | 1 | 700 | ||||
| Schwinn Sierra GS | Comfort | 31 | 1 | 0 | 340 | ||||
| Mongoose Switchback SX | Comfort | 32 | 1 | 0 | 280 | ||||
| Giant Sedona DX | Comfort | 32 | 1 | 0 | 360 | ||||
| Jamis Explorer 4.0 | Comfort | 35 | 1 | 0 | 600 | ||||
| Diamondback Wildwood Deluxe | Comfort | 34 | 1 | 0 | 350 | ||||
| Specialized Crossroads Sport | Comfort | 31 | 1 | 0 | 330 | ||||
| SUMMARY OUTPUT | |||||||||
| Regression Statistics | 1594.79 | ||||||||
| Multiple R | 0.8526745426 | ||||||||
| R Square | 72.71% | ||||||||
| Adjusted R Square | 67.25% | ||||||||
| Standard Error | 273.3065084742 | ||||||||
| Observations | 19 | ||||||||
| ANOVA | |||||||||
| df | SS | MS | F | Significance F | |||||
| Regression | 3 | 2984563.81270077 | 994854.604233589 | 13.3186334363 | 0.017% | ||||
| Residual | 15 | 1120446.71361502 | 74696.4475743348 | ||||||
| Total | 18 | 4105010.52631579 | |||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | ||
| Intercept | 2072.61 | 1080.2564838919 | 1.9186236461 | 7.4% | -229.9065578765 | 4375.1178254821 | -229.9065578765 | 4375.1178254821 | |
| Weight (X) | -36.48 | 49.7538090033 | -0.7331875483 | 47.5% | -142.5266068293 | 69.5688603505 | -142.5266068293 | 69.5688603505 | |
| Comfort (D1) | -510.38 | 560.8440970951 | -0.9100132987 | 37.7% | -1705.7864827378 | 685.0353090289 | -1705.7864827378 | 685.0353090289 | |
| Fitness (D2) | -477.82 | 201.7177974947 | -2.3687394337 | 3.2% | -907.7682092099 | -47.865593607 | -907.7682092099 | -47.865593607 | |
| Y = 2072.61 - 36.48X - 510.38D1 - 477.82D2 + Error | |||||||||
| Price Estimate (Road) = 2072.61 - 36.48xWeight | |||||||||
| Price Estimate (fitness) = 2072.61 - 36.48xWeight - 477.82x1 = 1594.79 - 36.48xWeight | |||||||||
| Price Estimate (comfort) = 2072.61 - 36.48xWeight - 510.38x1 = 1599.79 - 36.48xWeight | 1599.79 |
P 2-d
| Weight (x1) | Comfort (D1) | Fitness (D2) | X1D1 | X1D2 | Price | |||
| 20 | 0 | 0 | 0 | 0 | 1800 | |||
| 22 | 0 | 0 | 0 | 0 | 1800 | |||
| 22 | 0 | 0 | 0 | 0 | 1000 | |||
| 21 | 0 | 0 | 0 | 0 | 1300 | |||
| 21 | 0 | 0 | 0 | 0 | 1320 | |||
| 21 | 0 | 0 | 0 | 0 | 1050 | |||
| 22 | 0 | 0 | 0 | 0 | 1350 | |||
| 24 | 0 | 0 | 0 | 0 | 650 | |||
| 23 | 0 | 1 | 0 | 23 | 630 | |||
| 23 | 0 | 1 | 0 | 23 | 700 | |||
| 24 | 0 | 1 | 0 | 24 | 700 | |||
| 26 | 0 | 1 | 0 | 26 | 830 | |||
| 25 | 1 | 1 | 25 | 25 | 700 | |||
| 31 | 1 | 0 | 31 | 0 | 340 | |||
| 32 | 1 | 0 | 32 | 0 | 280 | |||
| 32 | 1 | 0 | 32 | 0 | 360 | |||
| 35 | 1 | 0 | 35 | 0 | 600 | |||
| 34 | 1 | 0 | 34 | 0 | 350 | |||
| 31 | 1 | 0 | 31 | 0 | 330 | |||
| SUMMARY OUTPUT | ||||||||
| Regression Statistics | ||||||||
| Multiple R | 0.9124644518 | |||||||
| R Square | 0.8325913759 | |||||||
| Adjusted R Square | 76.82% | |||||||
| Standard Error | 229.9187421977 | |||||||
| Observations | 19 | |||||||
| ANOVA | ||||||||
| df | SS | MS | F | Significance F | ||||
| Regression | 5 | 3417796.3621366 | 683559.27242732 | 12.9308605741 | 0.0001154182 | |||
| Residual | 13 | 687214.164179188 | 52862.6280137837 | |||||
| Total | 18 | 4105010.52631579 | ||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
| Intercept | 6442.3332833058 | 1453.5853725323 | 4.4320295217 | 0.07% | 3302.0530049943 | 9582.6135616173 | 3302.0530049943 | 9582.6135616173 |
| Weight (x1) | -238.9599279604 | 66.8927453587 | -3.5722846578 | 0.34% | -383.4729183781 | -94.4469375427 | -383.4729183781 | -94.4469375427 |
| Comfort (D1) | -6449.7619802002 | 2398.3176118997 | -2.6892860012 | 1.86% | -11631.0121771911 | -1268.5117832093 | -11631.0121771911 | -1268.5117832093 |
| Fitness (D2) | -7315.0880484266 | 2585.5973288531 | -2.8291675455 | 1.42% | -12900.9314759148 | -1729.2446209384 | -12900.9314759148 | -1729.2446209384 |
| X1D1 | 251.1444072017 | 94.4731900968 | 2.6583669605 | 1.97% | 47.0474884406 | 455.2413259629 | 47.0474884406 | 455.2413259629 |
| X1D2 | 305.8601397435 | 110.5409845124 | 2.7669388064 | 1.60% | 67.0508615483 | 544.6694179387 | 67.0508615483 | 544.6694179387 |
P 3
| Nonbrowser | Light Browser | Heavy Browser | Light Browser (X1) | Heavy Browser(X2) | Comfort Level (Y) |
Sharifzadeh Mamad: A study was conducted to investigate browsing activity by shoppers. Shoppers were classified as nonbrowsers, light browsers, and heavy browsers. For each shopper in the study, a measure was obtained to determine how comfortable the shopper was in the store. Higher scores indicated greater comfort. Assume that the following data are from this study. Use a .05 level of significance to test for differences in comfort levels among the three types of browsers |
|||||||||||
| 4 | 5 | 5 | 0 | 0 | 4 | ||||||||||||
| 5 | 6 | 7 | 0 | 0 | 5 | ||||||||||||
| 6 | 5 | 5 | 0 | 0 | 6 | ||||||||||||
| 3 | 4 | 7 | 0 | 0 | 3 | ||||||||||||
| 3 | 7 | 4 | 0 | 0 | 3 | ||||||||||||
| 4 | 4 | 6 | 0 | 0 | 4 | ||||||||||||
| 5 | 6 | 5 | 0 | 0 | 5 | ||||||||||||
| 4 | 5 | 7 | 0 | 0 | 4 | ||||||||||||
| 1 | 0 | 5 | |||||||||||||||
| 1 | 0 | 6 | |||||||||||||||
| 1 | 0 | 5 | |||||||||||||||
| Dummy Variable Assignment | 1 | 0 | 4 | ||||||||||||||
| X1 | X2 | 1 | 0 | 7 | |||||||||||||
| Nonbrowser | 0 | 0 | 1 | 0 | 4 | ||||||||||||
| Light browser | 1 | 0 | 1 | 0 | 6 | ||||||||||||
| Heavy browser | 0 | 1 | 1 | 0 | 5 | ||||||||||||
| 0 | 1 | 5 | |||||||||||||||
| 0 | 1 | 7 | |||||||||||||||
| 0 | 1 | 5 | |||||||||||||||
| 0 | 1 | 7 | |||||||||||||||
| 0 | 1 | 4 | |||||||||||||||
| 0 | 1 | 6 | |||||||||||||||
| 0 | 1 | 5 | |||||||||||||||
| 0 | 1 | 7 | |||||||||||||||
| Results from doing the ANOVA approach | |||||||||||||||||
| SUMMARY | |||||||||||||||||
| SUMMARY OUTPUT | Groups | Count | Sum | Average | Variance | ||||||||||||
| Nonbrowser | 8 | 34 | 4.25 | 1.0714285714 | |||||||||||||
| Regression Statistics | Light Browser | 8 | 42 | 5.25 | 1.0714285714 | ||||||||||||
| Multiple R | 0.5252257314 | Heavy Browser | 8 | 46 | 5.75 | 1.3571428571 | |||||||||||
| R Square | 27.59% | ||||||||||||||||
| Adjusted R Square | 0.2068965517 | ||||||||||||||||
| Standard Error | 1.0801234497 | ANOVA | |||||||||||||||
| Observations | 24 | Source of Variation | SS | df | MS | F | P-value | F crit | |||||||||
| Between Groups | 9.3333333333 | 2 | 4.6666666667 | 4 | 3.37% | 3.4668001115 | |||||||||||
| ANOVA | Within Groups | 24.5 | 21 | 1.1666666667 | |||||||||||||
| df | SS | MS | F | Significance F | |||||||||||||
| Regression | 2 | 9.3333333333 | 4.6666666667 | 4 | 3.37% | Reject H0, Browser scores are different | Total | 33.8333333333 | 23 | ||||||||
| Residual | 21 | 24.5 | 1.1666666667 | ||||||||||||||
| Total | 23 | 33.8333333333 | |||||||||||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | ||||||||||
| Intercept | 4.25 | 0.3818813079 | 11.129112402 | 0.00% | 3.455834345 | 5.044165655 | 3.455834345 | 5.044165655 | |||||||||
| Light Browser (X1) | 1 | 0.5400617249 | 1.8516401995 | 7.82% | -0.12311984 | 2.12311984 | -0.12311984 | 2.12311984 | |||||||||
| Heavy Browser(X2) | 1.5 | 0.5400617249 | 2.7774602993 | 1.13% | 0.37688016 | 2.62311984 | 0.37688016 | 2.62311984 | |||||||||
| Regression eQuation | |||||||||||||||||
| Y = | 4.25 + X1 + 0.56X2 + Error | ||||||||||||||||
| Y estimate for Nonbrowser = 4.25 + 0 + 0 = 4.25 | |||||||||||||||||
| Y estimate for lightbrowser = 4.25 + 1 + 0 = 5.25 | |||||||||||||||||
| Y estimate for heavybrowser = 4.25 + 0 + 1.5 = 5.75 |
P 4
| Delay | Industry | Public | Quality | Finished |
Sharifzadeh Mamad: Sharifzadeh Mamad: A study investigated the relationship between audit delay (Delay), the length of time from a company’s fiscal year-end to the date of the auditor’s report, and variables that describe the client and the auditor. Some of the independent variables that were included in this study follow. Industry: A dummy variable coded 1 if the firm was an industrial company or 0 if the firm was a bank, savings and loan, or insurance company. Public: A dummy variable coded 1 if the company was traded on an organized exchange or over the counter; otherwise coded 0. Quality: A measure of overall quality of internal controls, as judged by the auditor, on a five-point scale ranging from “virtually none” (1) to “excellent” (5). Finished: A measure ranging from 1 to 4, as judged by the auditor, where 1 indicates “all work performed subsequent to year-end” and 4 indicates “most work performed prior to year-end.” A sample of 40 companies provided the following data. a. Develop the estimated regression equation using all of the independent variables. b. Did the estimated regression equation developed in part (a) provide a good fit? Explain. c. Develop a scatter diagram showing Delay as a function of Finished. What does this scatter diagram indicate about the relationship between Delay and Finished? d. On the basis of your observations about the relationship between Delay and Finished, develop an alternative estimated regression equation to the one developed in (a) to explain as much of the variability in Delay as possible. |
||||||||
| 62 | 0 | 0 | 3 | 1 | |||||||||
| 45 | 0 | 1 | 3 | 3 | |||||||||
| 54 | 0 | 0 | 2 | 2 | |||||||||
| 71 | 0 | 1 | 1 | 2 | |||||||||
| 91 | 0 | 0 | 1 | 1 | |||||||||
| 62 | 0 | 0 | 4 | 4 | |||||||||
| 61 | 0 | 0 | 3 | 2 | |||||||||
| 69 | 0 | 1 | 5 | 2 | |||||||||
| 80 | 0 | 0 | 1 | 1 | |||||||||
| 52 | 0 | 0 | 5 | 3 | |||||||||
| 47 | 0 | 0 | 3 | 2 | |||||||||
| 65 | 0 | 1 | 2 | 3 | |||||||||
| 60 | 0 | 0 | 1 | 3 | |||||||||
| 81 | 1 | 0 | 1 | 2 | |||||||||
| 73 | 1 | 0 | 2 | 2 | |||||||||
| 89 | 1 | 0 | 2 | 1 | |||||||||
| 71 | 1 | 0 | 5 | 4 | |||||||||
| 76 | 1 | 0 | 2 | 2 | |||||||||
| 68 | 1 | 0 | 1 | 2 | |||||||||
| 68 | 1 | 0 | 5 | 2 | |||||||||
| 86 | 1 | 0 | 2 | 2 | |||||||||
| 76 | 1 | 1 | 3 | 1 | |||||||||
| 67 | 1 | 0 | 2 | 3 | |||||||||
| 57 | 1 | 0 | 4 | 2 | |||||||||
| 55 | 1 | 1 | 3 | 2 | |||||||||
| 54 | 1 | 0 | 5 | 2 | |||||||||
| 69 | 1 | 0 | 3 | 3 | |||||||||
| 82 | 1 | 0 | 5 | 1 | |||||||||
| 94 | 1 | 0 | 1 | 1 | |||||||||
| 74 | 1 | 1 | 5 | 2 | |||||||||
| 75 | 1 | 1 | 4 | 3 | |||||||||
| 69 | 1 | 0 | 2 | 2 | |||||||||
| 71 | 1 | 0 | 4 | 4 | |||||||||
| 79 | 1 | 0 | 5 | 2 | |||||||||
| 80 | 1 | 0 | 1 | 4 | |||||||||
| 91 | 1 | 0 | 4 | 1 | |||||||||
| 92 | 1 | 0 | 1 | 4 | |||||||||
| 46 | 1 | 1 | 4 | 3 | |||||||||
| 72 | 1 | 0 | 5 | 2 | |||||||||
| 85 | 1 | 0 | 5 | 1 | |||||||||
| SUMMARY OUTPUT | |||||||||||||
| Regression Statistics | |||||||||||||
| Multiple R | 0.6185185512 | ||||||||||||
| R Square | 38.26% | ||||||||||||
| Adjusted R Square | 0.3120012208 | ||||||||||||
| Standard Error | 10.9235179628 | ||||||||||||
| Observations | 40 | ||||||||||||
| ANOVA | |||||||||||||
| df | SS | MS | F | Significance F | |||||||||
| Regression | 4 | 2587.6614360457 | 646.9153590114 | 5.4215367737 | 0.17% | ||||||||
| Residual | 35 | 4176.3135639543 | 119.3232446844 | ||||||||||
| Total | 39 | 6763.975 | |||||||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | ||||||
| Intercept | 80.43 | 5.9158613499 | 13.5954118923 | 0.0% | 68.4187347205 | 92.438408778 | 68.4187347205 | 92.438408778 | |||||
| Industry | 11.94 | 3.7978007626 | 3.1450278655 | 0.3% | 4.2342437878 | 19.6541346637 | 4.2342437878 | 19.6541346637 | 87.55 | ||||
| Public | -4.82 | 4.2291813118 | -1.1388154753 | 26.3% | -13.4019516368 | 3.7694373853 | -13.4019516368 | 3.7694373853 | |||||
| Quality | -2.62 | 1.1835935566 | -2.2166689067 | 3.3% | -5.0264576983 | -0.220812372 | -5.0264576983 | -0.220812372 | |||||
| Finished | -4.07 | 1.8514307815 | -2.1996559824 | 3.5% | -7.8311151027 | -0.3139064865 | -7.8311151027 | -0.3139064865 | |||||
| Y estimate (not industrial not public) = 80.43 - 2.62Quality - 4.07Finished | |||||||||||||
| Y estimate (industrial not public) = 80.43 + 11.94- 2.62Quality - 4.07Finished = 92.37 - 2.62Quality - 4.07Finished | |||||||||||||
| Y estimate (not industrial public) = 80.43 - 4.82 - 2.62Quality - 4.07Finished = 75.61 - 2.62Quality - 4.07Finished | |||||||||||||
| Y estimate(industrial and public( =80.43+11.94 - 4.82 - 2.62Quality - 4.07Finished = 87.55 - 2.62Quality - 4.07Finished | |||||||||||||
| SUMMARY OUTPUT | |||||||||||||
| Regression Statistics | |||||||||||||
| Multiple R | 0.3151312458 | ||||||||||||
| R Square | 0.0993077021 | ||||||||||||
| Adjusted R Square | 7.56% | ||||||||||||
| Standard Error | 12.6618575442 | ||||||||||||
| Observations | 40 | ||||||||||||
| ANOVA | |||||||||||||
| df | SS | MS | F | Significance F | |||||||||
| Regression | 1 | 671.714814153 | 671.714814153 | 4.1897690117 | 0.0476301323 | ||||||||
| Residual | 38 | 6092.260185847 | 160.3226364697 | ||||||||||
| Total | 39 | 6763.975 | |||||||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | ||||||
| Intercept | 80.2258756254 | 5.1673339103 | 15.5255837958 | 0.0% | 69.7651550144 | 90.6865962365 | 69.7651550144 | 90.6865962365 | |||||
| Finished | -4.3824160114 | 2.141009338 | -2.0468925257 | 4.8% | -8.7166628202 | -0.0481692026 | -8.7166628202 | -0.0481692026 |
P 5
| Delay | Industry | Public | Quality | Finished |
Sharifzadeh Mamad: Sharifzadeh Mamad: Refer to the data in exercise P 4 a. Develop an estimated regression equation that can be used to predict Delay by using Industry and Quality. b. check for any outlier through standardized residual c. Check for assumption of independence of residual by plotting standardized residual against predicted values of Y d. Plot the residuals obtained from the estimated regression equation developed in part (a) as a function of the order in which the data are presented. Does any autocorrelation appear to be present in the data? Explain. e. At the .05 level of significance, test for any positive autocorrelation in the data. |
||||||||||
| 62 | 0 | 0 | 3 | 1 | |||||||||||
| 45 | 0 | 1 | 3 | 3 | |||||||||||
| 54 | 0 | 0 | 2 | 2 | |||||||||||
| 71 | 0 | 1 | 1 | 2 | |||||||||||
| 91 | 0 | 0 | 1 | 1 | |||||||||||
| 62 | 0 | 0 | 4 | 4 | |||||||||||
| 61 | 0 | 0 | 3 | 2 | |||||||||||
| 69 | 0 | 1 | 5 | 2 | |||||||||||
| 80 | 0 | 0 | 1 | 1 | |||||||||||
| 52 | 0 | 0 | 5 | 3 | |||||||||||
| 47 | 0 | 0 | 3 | 2 | |||||||||||
| 65 | 0 | 1 | 2 | 3 | |||||||||||
| 60 | 0 | 0 | 1 | 3 | |||||||||||
| 81 | 1 | 0 | 1 | 2 | |||||||||||
| 73 | 1 | 0 | 2 | 2 | |||||||||||
| 89 | 1 | 0 | 2 | 1 | |||||||||||
| 71 | 1 | 0 | 5 | 4 | SUMMARY OUTPUT | ||||||||||
| 76 | 1 | 0 | 2 | 2 | |||||||||||
| 68 | 1 | 0 | 1 | 2 | Regression Statistics | ||||||||||
| 68 | 1 | 0 | 5 | 2 | Multiple R | 0.6185185512 | |||||||||
| 86 | 1 | 0 | 2 | 2 | R Square | 0.3825651981 | |||||||||
| 76 | 1 | 1 | 3 | 1 | Adjusted R Square | 0.3120012208 | |||||||||
| 67 | 1 | 0 | 2 | 3 | Standard Error | 10.9235179628 | |||||||||
| 57 | 1 | 0 | 4 | 2 | Observations | 40 | |||||||||
| 55 | 1 | 1 | 3 | 2 | |||||||||||
| 54 | 1 | 0 | 5 | 2 | ANOVA | ||||||||||
| 69 | 1 | 0 | 3 | 3 | df | SS | MS | F | Significance F | ||||||
| 82 | 1 | 0 | 5 | 1 | Regression | 4 | 2587.6614360457 | 646.9153590114 | 5.4215367737 | 0.0016655083 | |||||
| 94 | 1 | 0 | 1 | 1 | Residual | 35 | 4176.3135639543 | 119.3232446844 | |||||||
| 74 | 1 | 1 | 5 | 2 | Total | 39 | 6763.975 | ||||||||
| 75 | 1 | 1 | 4 | 3 | |||||||||||
| 69 | 1 | 0 | 2 | 2 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |||
| 71 | 1 | 0 | 4 | 4 | Intercept | 80.4285717493 | 5.9158613499 | 13.5954118923 | 0 | 68.4187347205 | 92.438408778 | 68.4187347205 | 92.438408778 | ||
| 79 | 1 | 0 | 5 | 2 | Industry | 11.9441892257 | 3.7978007626 | 3.1450278655 | 0.0033795594 | 4.2342437878 | 19.6541346637 | 4.2342437878 | 19.6541346637 | ||
| 80 | 1 | 0 | 1 | 4 | Public | -4.8162571258 | 4.2291813118 | -1.1388154753 | 0.2625150356 | -13.4019516368 | 3.7694373853 | -13.4019516368 | 3.7694373853 | ||
| 91 | 1 | 0 | 4 | 1 | Quality | -2.6236350351 | 1.1835935566 | -2.2166689067 | 0.0332386432 | -5.0264576983 | -0.220812372 | -5.0264576983 | -0.220812372 | ||
| 92 | 1 | 0 | 1 | 4 | Finished | -4.0725107946 | 1.8514307815 | -2.1996559824 | 0.0345270543 | -7.8311151027 | -0.3139064865 | -7.8311151027 | -0.3139064865 | ||
| 46 | 1 | 1 | 4 | 3 | |||||||||||
| 72 | 1 | 0 | 5 | 2 | |||||||||||
| 85 | 1 | 0 | 5 | 1 | |||||||||||
| RESIDUAL OUTPUT | |||||||||||||||
| e | et^2 | et-e(t-1) | [et-e(t-1)]^2 | Observation | Predicted Delay | Residuals | |||||||||
| -6.4851558493 | 42.0572463893 | 1 | 68.4851558493 | -6.4851558493 | |||||||||||
| -10.5238771344 | 110.7519899392 | 4.0387212851 | 16.3112696186 | Sum(et^2) | 4176.3135639543 | 2 | 55.5238771344 | -10.5238771344 | |||||||
| -13.0362800898 | 169.9445985807 | 2.5124029555 | 6.3121686107 | Sun{[et-e(t-1)]^2} | 5895.3697834143 | 3 | 67.0362800898 | -13.0362800898 | |||||||
| 6.1563420008 | 37.9005468307 | -19.1926220906 | 368.3567427137 | DW | 1.4116204861 | 4 | 64.8436579992 | 6.1563420008 | |||||||
| 17.2675740805 | 298.169114624 | -11.1112320797 | 123.4594783281 | No evidence of autocorrelation | 5 | 73.7324259195 | 17.2675740805 | ||||||||
| 8.3560115696 | 69.822929351 | 8.9115625109 | 79.4159463852 | 6 | 53.6439884304 | 8.3560115696 | |||||||||
| -3.4126450547 | 11.6461462694 | 11.7686566243 | 138.5012787402 | 7 | 64.4126450547 | -3.4126450547 | |||||||||
| 14.6508821413 | 214.6483475194 | -18.063527196 | 326.291014762 | 8 | 54.3491178587 | 14.6508821413 | |||||||||
| 6.2675740805 | 39.282484854 | 8.3833080609 | 70.2798540437 | 9 | 73.7324259195 | 6.2675740805 | |||||||||
| -3.0928641899 | 9.5658088969 | 9.3604382703 | 87.6178046123 | 10 | 55.0928641899 | -3.0928641899 | |||||||||
| -17.4126450547 | 303.200207801 | 14.3197808648 | 205.0561240172 | 11 | 64.4126450547 | -17.4126450547 | |||||||||
| 6.8524878305 | 46.9565894672 | -24.2651328852 | 588.7966739365 | 12 | 58.1475121695 | 6.8524878305 | |||||||||
| -5.5874043304 | 31.2190871514 | 12.4398921609 | 154.7509169748 | 13 | 65.5874043304 | -5.5874043304 | |||||||||
| -0.6041043507 | 0.3649420666 | -4.9832999797 | 24.8332786875 | 14 | 81.6041043507 | -0.6041043507 | |||||||||
| -5.9804693156 | 35.7660132346 | 5.3763649649 | 28.9053002354 | 15 | 78.9804693156 | -5.9804693156 | |||||||||
| 5.9470198898 | 35.3670455703 | -11.9274892054 | 142.2649987456 | 16 | 83.0529801102 | 5.9470198898 | |||||||||
| 8.035457379 | 64.5685752893 | -2.0884374891 | 4.361571146 | 17 | 62.964542621 | 8.035457379 | |||||||||
| -2.9804693156 | 8.8831973411 | 11.0159266946 | 121.3506409398 | 18 | 78.9804693156 | -2.9804693156 | |||||||||
| -13.6041043507 | 185.0716551851 | 10.6236350351 | 112.8616213598 | 19 | 81.6041043507 | -13.6041043507 | |||||||||
| -3.1095642102 | 9.6693895772 | -10.4945401405 | 110.1353727615 | 20 | 71.1095642102 | -3.1095642102 | |||||||||
| 7.0195306844 | 49.2738110295 | -10.1290948946 | 102.5985633836 | 21 | 78.9804693156 | 7.0195306844 | |||||||||
| 0.3869120507 | 0.149700935 | 6.6326186337 | 43.9916299397 | 22 | 75.6130879493 | 0.3869120507 | |||||||||
| -7.907958521 | 62.53580797 | 8.2948705718 | 68.8048778022 | 23 | 74.907958521 | -7.907958521 | |||||||||
| -16.7331992453 | 279.9999569831 | 8.8252407243 | 77.8848738418 | 24 | 73.7331992453 | -16.7331992453 | |||||||||
| -16.5405771547 | 273.5906926098 | -0.1926220906 | 0.0371032698 | 25 | 71.5405771547 | -16.5405771547 | |||||||||
| -17.1095642102 | 292.7371874619 | 0.5689870555 | 0.3237462693 | 26 | 71.1095642102 | -17.1095642102 | |||||||||
| -3.2843234859 | 10.7867807598 | -13.8252407243 | 191.1372810848 | 27 | 72.2843234859 | -3.2843234859 | |||||||||
| 6.8179249953 | 46.484101241 | -10.1022484811 | 102.0554243744 | 28 | 75.1820750047 | 6.8179249953 | |||||||||
| 8.3233848547 | 69.2787354397 | -1.5054598595 | 2.2664093884 | 29 | 85.6766151453 | 8.3233848547 | |||||||||
| 7.7066929156 | 59.3931156953 | 0.6166919391 | 0.3803089478 | 30 | 66.2933070844 | 7.7066929156 | |||||||||
| 10.155568675 | 103.1355751133 | -2.4488757594 | 5.9969924852 | 31 | 64.844431325 | 10.155568675 | |||||||||
| -9.9804693156 | 99.6097677592 | 20.1360379906 | 405.4600259593 | 32 | 78.9804693156 | -9.9804693156 | |||||||||
| 5.4118223438 | 29.2878210813 | -15.3922916594 | 236.9226425286 | 33 | 65.5881776562 | 5.4118223438 | |||||||||
| 7.8904357898 | 62.2589769534 | -2.478613446 | 6.1435246146 | 34 | 71.1095642102 | 7.8904357898 | |||||||||
| 6.5409172384 | 42.78359832 | 1.3495185514 | 1.8212003206 | 35 | 73.4590827616 | 6.5409172384 | |||||||||
| 13.1942899601 | 174.0892875518 | -6.6533727217 | 44.2673685737 | 36 | 77.8057100399 | 13.1942899601 | |||||||||
| 18.5409172384 | 343.7656120423 | -5.3466272783 | 28.5864232532 | 37 | 73.4590827616 | 18.5409172384 | |||||||||
| -18.844431325 | 355.1125919615 | 37.3853485634 | 1397.6642872068 | 38 | 64.844431325 | -18.844431325 | |||||||||
| 0.8904357898 | 0.7928758958 | -19.7348671148 | 389.4649800388 | 39 | 71.1095642102 | 0.8904357898 | |||||||||
| 9.8179249953 | 96.3916512125 | -8.9274892054 | 79.700063513 | 40 | 75.1820750047 | 9.8179249953 | |||||||||
| S |
Residuals -6.485155849272175 -10.523877134362259 -13.036280089835984 6.1563420007924066 17.267574080455063 8.3560115695819306 -3.4126450546995954 14.650882141337917 6.2675740804550628 -3.092864189854275 -17.412645054699595 6.852487830501353 -5.587404330399778 -0.60410435071500501 -5.980469315578631 5.9470198898487894 8.0354573789756572 -2.980469315578631 -13.604104350715005 -3.1095642101694949 7.019530684421369 0.38691205074992752 -7.9079585210060515 -16.733199245305869 -16.540577154677493 -17.109564210169495 -3.2843234858696775 6.8179249952579255 8.3233848547124154 7.7066929155952693 10.155568675031475 -9.980469315578631 5.4118223438392761 7.8904357898305051 6.5409172384301542 13.194289960121552 18.54 0917238430154 -18.844431324968525 0.89043578983050509 9.8179249952579255
1
2
3
4
5
6
A
B
Weight (x1)
Comfort (D1)
20
0
22
0
22
0
21
0
21
0
