Question
We wish to determine the impact of Specification Buying, X11, on Satisfaction Level, X10. To do...
We wish to determine the impact of Specification Buying, X11, on Satisfaction Level, X10. To do so we will split the Hatco data file into two separate data sets based on the Specification Buying, X11. This variable has two categories:
1=employs total value analysis approach, evaluating each purchase separately;
0 = use of specification buying.
Sort the entire Hatco data set based on Specification Buying. This will create two separate groups of records. Those records with X11 = 0 and those records with X11 = 1.Treat these as two distinct data sets.
For the 2 data sets, X11 = 0 and X11 = 1, perform regression analysis on Satisfaction Level X10 as a function of the first seven variables (Delivery Speed, Price Level, Price Flexibility, Manufacturer Image, Service, Salesforce Image, Product Quality). Use Alpha = .01 to determine variables to remove from model.
For X11 = 0 and X11 = 1:
Compare the two models and explain the differences between the two models. From a business perspective, why do they differ?
Please post showing formulas used
| Delivery Speed | Price Level | Price Flexibility | Manufacturer Image | Service | Salesforce Image | Product Quality | Firm Size | Usage Level | Satisfaction Level | Specification Buying | Structure of Procurement | Type of Industry (SIC) | Type of Buying Situation | |
| 1.0 | 4.1 | 0.6 | 6.9 | 4.7 | 2.4 | 2.3 | 5.2 | 0 | 32.0 | 4.2 | 1 | 0 | 1 | 1 |
| 2.0 | 1.8 | 3.0 | 6.3 | 6.6 | 2.5 | 4.0 | 8.4 | 1 | 43.0 | 4.3 | 0 | 1 | 0 | 1 |
| 3.0 | 3.4 | 5.2 | 5.7 | 6.0 | 4.3 | 2.7 | 8.2 | 1 | 48.0 | 5.2 | 0 | 1 | 1 | 2 |
| 4.0 | 2.7 | 1.0 | 7.1 | 5.9 | 1.8 | 2.3 | 7.8 | 1 | 32.0 | 3.9 | 0 | 1 | 1 | 1 |
| 5.0 | 6.0 | 0.9 | 9.6 | 7.8 | 3.4 | 4.6 | 4.5 | 0 | 58.0 | 6.8 | 1 | 0 | 1 | 3 |
| 6.0 | 1.9 | 3.3 | 7.9 | 4.8 | 2.6 | 1.9 | 9.7 | 1 | 45.0 | 4.4 | 0 | 1 | 1 | 2 |
| 7.0 | 4.6 | 2.4 | 9.5 | 6.6 | 3.5 | 4.5 | 7.6 | 0 | 46.0 | 5.8 | 1 | 0 | 1 | 1 |
| 8.0 | 1.3 | 4.2 | 6.2 | 5.1 | 2.8 | 2.2 | 6.9 | 1 | 44.0 | 4.3 | 0 | 1 | 0 | 2 |
| 9.0 | 5.5 | 1.6 | 9.4 | 4.7 | 3.5 | 3.0 | 7.6 | 0 | 63.0 | 5.4 | 1 | 0 | 1 | 3 |
| 10.0 | 4.0 | 3.5 | 6.5 | 6.0 | 3.7 | 3.2 | 8.7 | 1 | 54.0 | 5.4 | 0 | 1 | 0 | 2 |
| 11.0 | 2.4 | 1.6 | 8.8 | 4.8 | 2.0 | 2.8 | 5.8 | 0 | 32.0 | 4.3 | 1 | 0 | 0 | 1 |
| 12.0 | 3.9 | 2.2 | 9.1 | 4.6 | 3.0 | 2.5 | 8.3 | 0 | 47.0 | 5.0 | 1 | 0 | 1 | 2 |
| 13.0 | 2.8 | 1.4 | 8.1 | 3.8 | 2.1 | 1.4 | 6.6 | 1 | 39.0 | 4.4 | 0 | 1 | 0 | 1 |
| 14.0 | 3.7 | 1.5 | 8.6 | 5.7 | 2.7 | 3.7 | 6.7 | 0 | 38.0 | 5.0 | 1 | 0 | 1 | 1 |
| 15.0 | 4.7 | 1.3 | 9.9 | 6.7 | 3.0 | 2.6 | 6.8 | 0 | 54.0 | 5.9 | 1 | 0 | 0 | 3 |
| 16.0 | 3.4 | 2.0 | 9.7 | 4.7 | 2.7 | 1.7 | 4.8 | 0 | 49.0 | 4.7 | 1 | 0 | 0 | 3 |
| 17.0 | 3.2 | 4.1 | 5.7 | 5.1 | 3.6 | 2.9 | 6.2 | 0 | 38.0 | 4.4 | 1 | 1 | 1 | 2 |
| 18.0 | 4.9 | 1.8 | 7.7 | 4.3 | 3.4 | 1.5 | 5.9 | 0 | 40.0 | 5.6 | 1 | 0 | 0 | 2 |
| 19.0 | 5.3 | 1.4 | 9.7 | 6.1 | 3.3 | 3.9 | 6.8 | 0 | 54.0 | 5.9 | 1 | 0 | 1 | 3 |
| 20.0 | 4.7 | 1.3 | 9.9 | 6.7 | 3.0 | 2.6 | 6.8 | 0 | 55.0 | 6.0 | 1 | 0 | 0 | 3 |
| 21.0 | 3.3 | 0.9 | 8.6 | 4.0 | 2.1 | 1.8 | 6.3 | 0 | 41.0 | 4.5 | 1 | 0 | 0 | 2 |
| 22.0 | 3.4 | 0.4 | 8.3 | 2.5 | 1.2 | 1.7 | 5.2 | 0 | 35.0 | 3.3 | 1 | 0 | 0 | 1 |
| 23.0 | 3.0 | 4.0 | 9.1 | 7.1 | 3.5 | 3.4 | 8.4 | 0 | 55.0 | 5.2 | 1 | 1 | 0 | 3 |
| 24.0 | 2.4 | 1.5 | 6.7 | 4.8 | 1.9 | 2.5 | 7.2 | 1 | 36.0 | 3.7 | 0 | 1 | 0 | 1 |
| 25.0 | 5.1 | 1.4 | 8.7 | 4.8 | 3.3 | 2.6 | 3.8 | 0 | 49.0 | 4.9 | 1 | 0 | 0 | 2 |
| 26.0 | 4.6 | 2.1 | 7.9 | 5.8 | 3.4 | 2.8 | 4.7 | 0 | 49.0 | 5.9 | 1 | 0 | 1 | 3 |
| 27.0 | 2.4 | 1.5 | 6.6 | 4.8 | 1.9 | 2.5 | 7.2 | 1 | 36.0 | 3.7 | 0 | 1 | 0 | 1 |
| 28.0 | 5.2 | 1.3 | 9.7 | 6.1 | 3.2 | 3.9 | 6.7 | 0 | 54.0 | 5.8 | 1 | 0 | 1 | 3 |
| 29.0 | 3.5 | 2.8 | 9.9 | 3.5 | 3.1 | 1.7 | 5.4 | 0 | 49.0 | 5.4 | 1 | 0 | 1 | 3 |
| 30.0 | 4.1 | 3.7 | 5.9 | 5.5 | 3.9 | 3.0 | 8.4 | 1 | 46.0 | 5.1 | 0 | 1 | 0 | 2 |
| 31.0 | 3.0 | 3.2 | 6.0 | 5.3 | 3.1 | 3.0 | 8.0 | 1 | 43.0 | 3.3 | 0 | 1 | 0 | 1 |
| 32.0 | 2.8 | 3.8 | 8.9 | 6.9 | 3.3 | 3.2 | 8.2 | 0 | 53.0 | 5.0 | 1 | 1 | 0 | 3 |
| 33.0 | 5.2 | 2.0 | 9.3 | 5.9 | 3.7 | 2.4 | 4.6 | 0 | 60.0 | 6.1 | 1 | 0 | 0 | 3 |
| 34.0 | 3.4 | 3.7 | 6.4 | 5.7 | 3.5 | 3.4 | 8.4 | 1 | 47.0 | 3.8 | 0 | 1 | 0 | 1 |
| 35.0 | 2.4 | 1.0 | 7.7 | 3.4 | 1.7 | 1.1 | 6.2 | 1 | 35.0 | 4.1 | 0 | 1 | 0 | 1 |
| 36.0 | 1.8 | 3.3 | 7.5 | 4.5 | 2.5 | 2.4 | 7.6 | 1 | 39.0 | 3.6 | 0 | 1 | 1 | 1 |
| 37.0 | 3.6 | 4.0 | 5.8 | 5.8 | 3.7 | 2.5 | 9.3 | 1 | 44.0 | 4.8 | 0 | 1 | 1 | 2 |
| 38.0 | 4.0 | 0.9 | 9.1 | 5.4 | 2.4 | 2.6 | 7.3 | 0 | 46.0 | 5.1 | 1 | 0 | 1 | 3 |
| 39.0 | 0.0 | 2.1 | 6.9 | 5.4 | 1.1 | 2.6 | 8.9 | 1 | 29.0 | 3.9 | 0 | 1 | 1 | 1 |
| 40.0 | 2.4 | 2.0 | 6.4 | 4.5 | 2.1 | 2.2 | 8.8 | 1 | 28.0 | 3.3 | 0 | 1 | 1 | 1 |
| 41.0 | 1.9 | 3.4 | 7.6 | 4.6 | 2.6 | 2.5 | 7.7 | 1 | 40.0 | 3.7 | 0 | 1 | 1 | 1 |
| 42.0 | 5.9 | 0.9 | 9.6 | 7.8 | 3.4 | 4.6 | 4.5 | 0 | 58.0 | 6.7 | 1 | 0 | 1 | 3 |
| 43.0 | 4.9 | 2.3 | 9.3 | 4.5 | 3.6 | 1.3 | 6.2 | 0 | 53.0 | 5.9 | 1 | 0 | 0 | 3 |
| 44.0 | 5.0 | 1.3 | 8.6 | 4.7 | 3.1 | 2.5 | 3.7 | 0 | 48.0 | 4.8 | 1 | 0 | 0 | 2 |
| 45.0 | 2.0 | 2.6 | 6.5 | 3.7 | 2.4 | 1.7 | 8.5 | 1 | 38.0 | 3.2 | 0 | 1 | 1 | 1 |
| 46.0 | 5.0 | 2.5 | 9.4 | 4.6 | 3.7 | 1.4 | 6.3 | 0 | 54.0 | 6.0 | 1 | 0 | 0 | 3 |
| 47.0 | 3.1 | 1.9 | 10.0 | 4.5 | 2.6 | 3.2 | 3.8 | 0 | 55.0 | 4.9 | 1 | 0 | 1 | 3 |
| 48.0 | 3.4 | 3.9 | 5.6 | 5.6 | 3.6 | 2.3 | 9.1 | 1 | 43.0 | 4.7 | 0 | 1 | 1 | 2 |
| 49.0 | 5.8 | 0.2 | 8.8 | 4.5 | 3.0 | 2.4 | 6.7 | 0 | 57.0 | 4.9 | 1 | 0 | 1 | 3 |
| 50.0 | 5.4 | 2.1 | 8.0 | 3.0 | 3.8 | 1.4 | 5.2 | 0 | 53.0 | 3.8 | 1 | 0 | 1 | 3 |
| 51.0 | 3.7 | 0.7 | 8.2 | 6.0 | 2.1 | 2.5 | 5.2 | 0 | 41.0 | 5.0 | 1 | 0 | 0 | 2 |
| 52.0 | 2.6 | 4.8 | 8.2 | 5.0 | 3.6 | 2.5 | 9.0 | 1 | 53.0 | 5.2 | 0 | 1 | 1 | 2 |
| 53.0 | 4.5 | 4.1 | 6.3 | 5.9 | 4.3 | 3.4 | 8.8 | 1 | 50.0 | 5.5 | 0 | 1 | 0 | 2 |
| 54.0 | 2.8 | 2.4 | 6.7 | 4.9 | 2.5 | 2.6 | 9.2 | 1 | 32.0 | 3.7 | 0 | 1 | 1 | 1 |
| 55.0 | 3.8 | 0.8 | 8.7 | 2.9 | 1.6 | 2.1 | 5.6 | 0 | 39.0 | 3.7 | 1 | 0 | 0 | 1 |
| 56.0 | 2.9 | 2.6 | 7.7 | 7.0 | 2.8 | 3.6 | 7.7 | 0 | 47.0 | 4.2 | 1 | 1 | 1 | 2 |
| 57.0 | 4.9 | 4.4 | 7.4 | 6.9 | 4.6 | 4.0 | 9.6 | 1 | 62.0 | 6.2 | 0 | 1 | 0 | 2 |
| 58.0 | 5.4 | 2.5 | 9.6 | 5.5 | 4.0 | 3.0 | 7.7 | 0 | 65.0 | 6.0 | 1 | 0 | 0 | 3 |
| 59.0 | 4.3 | 1.8 | 7.6 | 5.4 | 3.1 | 2.5 | 4.4 | 0 | 46.0 | 5.6 | 1 | 0 | 1 | 3 |
| 60.0 | 2.3 | 4.5 | 8.0 | 4.7 | 3.3 | 2.2 | 8.7 | 1 | 50.0 | 5.0 | 0 | 1 | 1 | 2 |
| 61.0 | 3.1 | 1.9 | 9.9 | 4.5 | 2.6 | 3.1 | 3.8 | 0 | 54.0 | 4.8 | 1 | 0 | 1 | 3 |
| 62.0 | 5.1 | 1.9 | 9.2 | 5.8 | 3.6 | 2.3 | 4.5 | 0 | 60.0 | 6.1 | 1 | 0 | 0 | 3 |
| 63.0 | 4.1 | 1.1 | 9.3 | 5.5 | 2.5 | 2.7 | 7.4 | 0 | 47.0 | 5.3 | 1 | 0 | 1 | 3 |
| 64.0 | 3.0 | 3.8 | 5.5 | 4.9 | 3.4 | 2.6 | 6.0 | 0 | 36.0 | 4.2 | 1 | 1 | 1 | 2 |
| 65.0 | 1.1 | 2.0 | 7.2 | 4.7 | 1.6 | 3.2 | 10.0 | 1 | 40.0 | 3.4 | 0 | 1 | 1 | 1 |
| 66.0 | 3.7 | 1.4 | 9.0 | 4.5 | 2.6 | 2.3 | 6.8 | 0 | 45.0 | 4.9 | 1 | 0 | 0 | 2 |
| 67.0 | 4.2 | 2.5 | 9.2 | 6.2 | 3.3 | 3.9 | 7.3 | 0 | 59.0 | 6.0 | 1 | 0 | 0 | 3 |
| 68.0 | 1.6 | 4.5 | 6.4 | 5.3 | 3.0 | 2.5 | 7.1 | 1 | 46.0 | 4.5 | 0 | 1 | 0 | 2 |
| 69.0 | 5.3 | 1.7 | 8.5 | 3.7 | 3.5 | 1.9 | 4.8 | 0 | 58.0 | 4.3 | 1 | 0 | 0 | 3 |
| 70.0 | 2.3 | 3.7 | 8.3 | 5.2 | 3.0 | 2.3 | 9.1 | 1 | 49.0 | 4.8 | 0 | 1 | 1 | 2 |
| 71.0 | 3.6 | 5.4 | 5.9 | 6.2 | 4.5 | 2.9 | 8.4 | 1 | 50.0 | 5.4 | 0 | 1 | 1 | 2 |
| 72.0 | 5.6 | 2.2 | 8.2 | 3.1 | 4.0 | 1.6 | 5.3 | 0 | 55.0 | 3.9 | 1 | 0 | 1 | 3 |
| 73.0 | 3.6 | 2.2 | 9.9 | 4.8 | 2.9 | 1.9 | 4.9 | 0 | 51.0 | 4.9 | 1 | 0 | 0 | 3 |
| 74.0 | 5.2 | 1.3 | 9.1 | 4.5 | 3.3 | 2.7 | 7.3 | 0 | 60.0 | 5.1 | 1 | 0 | 1 | 3 |
| 75.0 | 3.0 | 2.0 | 6.6 | 6.6 | 2.4 | 2.7 | 8.2 | 1 | 41.0 | 4.1 | 0 | 1 | 0 | 1 |
| 76.0 | 4.2 | 2.4 | 9.4 | 4.9 | 3.2 | 2.7 | 8.5 | 0 | 49.0 | 5.2 | 1 | 0 | 1 | 2 |
| 77.0 | 3.8 | 0.8 | 8.3 | 6.1 | 2.2 | 2.6 | 5.3 | 0 | 42.0 | 5.1 | 1 | 0 | 0 | 2 |
| 78.0 | 3.3 | 2.6 | 9.7 | 3.3 | 2.9 | 1.5 | 5.2 | 0 | 47.0 | 5.1 | 1 | 0 | 1 | 3 |
| 79.0 | 1.0 | 1.9 | 7.1 | 4.5 | 1.5 | 3.1 | 9.9 | 1 | 39.0 | 3.3 | 0 | 1 | 1 | 1 |
| 80.0 | 4.5 | 1.6 | 8.7 | 4.6 | 3.1 | 2.1 | 6.8 | 0 | 56.0 | 5.1 | 1 | 0 | 0 | 3 |
| 81.0 | 5.5 | 1.8 | 8.7 | 3.8 | 3.6 | 2.1 | 4.9 | 0 | 59.0 | 4.5 | 1 | 0 | 0 | 3 |
| 82.0 | 3.4 | 4.6 | 5.5 | 8.2 | 4.0 | 4.4 | 6.3 | 0 | 47.0 | 5.6 | 1 | 1 | 1 | 2 |
| 83.0 | 1.6 | 2.8 | 6.1 | 6.4 | 2.3 | 3.8 | 8.2 | 1 | 41.0 | 4.1 | 0 | 1 | 0 | 1 |
| 84.0 | 2.3 | 3.7 | 7.6 | 5.0 | 3.0 | 2.5 | 7.4 | 0 | 37.0 | 4.4 | 1 | 1 | 0 | 1 |
| 85.0 | 2.6 | 3.0 | 8.5 | 6.0 | 2.8 | 2.8 | 6.8 | 1 | 53.0 | 5.6 | 0 | 1 | 0 | 2 |
| 86.0 | 2.5 | 3.1 | 7.0 | 4.2 | 2.8 | 2.2 | 9.0 | 1 | 43.0 | 3.7 | 0 | 1 | 1 | 1 |
| 87.0 | 2.4 | 2.9 | 8.4 | 5.9 | 2.7 | 2.7 | 6.7 | 1 | 51.0 | 5.5 | 0 | 1 | 0 | 2 |
| 88.0 | 2.1 | 3.5 | 7.4 | 4.8 | 2.8 | 2.3 | 7.2 | 0 | 36.0 | 4.3 | 1 | 1 | 0 | 1 |
| 89.0 | 2.9 | 1.2 | 7.3 | 6.1 | 2.0 | 2.5 | 8.0 | 1 | 34.0 | 4.0 | 0 | 1 | 1 | 1 |
| 90.0 | 4.3 | 2.5 | 9.3 | 6.3 | 3.4 | 4.0 | 7.4 | 0 | 60.0 | 6.1 | 1 | 0 | 0 | 3 |
| 91.0 | 3.0 | 2.8 | 7.8 | 7.1 | 3.0 | 3.8 | 7.9 | 0 | 49.0 | 4.4 | 1 | 1 | 1 | 2 |
| 92.0 | 4.8 | 1.7 | 7.6 | 4.2 | 3.3 | 1.4 | 5.8 | 0 | 39.0 | 5.5 | 1 | 0 | 0 | 2 |
| 93.0 | 3.1 | 4.2 | 5.1 | 7.8 | 3.6 | 4.0 | 5.9 | 0 | 43.0 | 5.2 | 1 | 1 | 1 | 2 |
| 94.0 | 1.9 | 2.7 | 5.0 | 4.9 | 2.2 | 2.5 | 8.2 | 1 | 36.0 | 3.6 | 0 | 1 | 0 | 1 |
| 95.0 | 4.0 | 0.5 | 6.7 | 4.5 | 2.2 | 2.1 | 5.0 | 0 | 31.0 | 4.0 | 1 | 0 | 1 | 1 |
| 96.0 | 0.6 | 1.6 | 6.4 | 5.0 | 0.7 | 2.1 | 8.4 | 1 | 25.0 | 3.4 | 0 | 1 | 1 | 1 |
| 97.0 | 6.1 | 0.5 | 9.2 | 4.8 | 3.3 | 2.8 | 7.1 | 0 | 60.0 | 5.2 | 1 | 0 | 1 | 3 |
| 98.0 | 2.0 | 2.8 | 5.2 | 5.0 | 2.4 | 2.7 | 8.4 | 1 | 38.0 | 3.7 | 0 | 1 | 0 | 1 |
| 99.0 | 3.1 | 2.2 | 6.7 | 6.8 | 2.6 | 2.9 | 8.4 | 1 | 42.0 | 4.3 | 0 | 1 | 0 | 1 |
| 100.0 | 2.5 | 1.8 | 9.0 | 5.0 | 2.2 | 3.0 | 6.0 | 0 | 33.0 | 4.4 | 1 | 0 | 0 | 1 |
Homework Answers
Answer #1
Using excel, first filter the data and copy the data with
Specification Buying, X11 with categories 1(employs total value analysis approach, evaluating each purchase separately) and 0 (use of specification buying) on 2 separate sheets.
The regression output for the model with specification buying = 1:
The regression output for the model with specification buying = 0:
Comparing the R square, for the two models, we find that in the model where, specification buying is employed, the predictors explain the variation in satisfaction level better than the other.
Not the answer you're looking for?
Similar Questions
Data shows the times for carrying out a blood test at Rivervalley Labs Using Excel Plot...
Data shows the times for carrying out a blood test at
Rivervalley Labs
Using Excel Plot a histogram of the data. What type of
distribution does the data appear to follow?
Construct and interpret the 95% confidence interval for the
population mean time for carrying out a blood test. Assume that the
population standard deviation is unknown.
Times for blood tests (minutes)
2.5
4.9
3.6
4.3
1.9
3.4
3.2
4.0
3.1
3.6
3.9
4.4
3.9
3.1
2.7
3.5
3.6
3.7...
Listed in the accompanying data table are student evaluation ratings of courses and professors, where a...
Listed in the accompanying data table are student evaluation
ratings of courses and professors, where a rating of 5 is for
"excellent." Assume that each sample is a simple random sample
obtained from a population with a normal distribution.
a. Use the 93 course evaluations to construct a 98%
confidence interval estimate of the standard deviation of the
population from which the sample was obtained.
b. Repeat part (a) using the 93 professor
evaluations.
c. Compare the results from part...
Build a stem-and-leaf plot for these measurements 3.1 4.9 2.8 3.6 2.5 4.5 3.5 3.7 4.1...
Build a stem-and-leaf plot for these measurements
3.1
4.9
2.8
3.6
2.5
4.5
3.5
3.7
4.1
4.9
2.9
2.1
3.5
4.0
3.7
2.7
4.0
4.4
3.7
4.2
3.8
6.2
2.5
2.9
2.8
5.1
1.8
5.6
2.2
3.4
2.5
3.6
5.1
4.8
1.6
3.6
6.1
4.7
3.9
3.9
4.3
5.7
3.7
4.6
4.0
5.6
4.9
4.2
3.1
3.9
A. Describe the form of data distribution. Do you notice any
unusual results?
B. Use the stem-and-leaf plot to find the minimum
observation....
Use the data in Bank Dataset to answer this question. Construct a 95% confidence interval for...
Use the data in Bank Dataset to answer this question.
Construct a 95% confidence interval for the mean increase in
deposits. Note that the population standard deviation σ is not
known in this case. Instead the sample standard deviation s should
be calculated from the sample and the t distribution should be
used.
2. What is the margin of error at the 95% confidence level?
Bank Dataset of Increase in deposits. Mean is 4. Sample size is
152 customers.
4.3...
–Construct a reasonable frequency distribution of High School GPA (HSGPA) –Construct a histogram –Present the frequency...
–Construct a reasonable frequency distribution of High School
GPA (HSGPA)
–Construct a histogram
–Present the frequency distribution and histogram
There are a total of 188 HS student GPAs.
1.6, 2, 2.1, 2.1, 2.2, 2.2, 2.2, 2.4, 2.4, 2.5, 2.5, 2.5, 2.5,
2.5, 2.6, 2.7, 2.75, 2.75, 2.75, 2.75, 2.75, 2.8, 2.8, 2.8, 2.9,
2.9, 2.9, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3,
3.1, 3.1, 3.1, 3.2, 3.2, 3.2,...
A researcher collects data showing average time spent (in minutes) at the grocery self-checkout lane at...
A researcher collects data showing average time spent (in
minutes) at the grocery self-checkout lane at a particular store.
Using a Excel, create a histogram and generate descriptive
statistics for the average time spent by the 30 individuals that is
shown below. Attach the printed output to your assignment.
2.3
2.4
2.5
2.9
3.0
3.0
3.1
3.1
3.1
3.1
3.4
3.6
3.8
4.1
4.1
4.1
4.2
4.3
4.5
4.9
5.0
5.1
5.2
5.2
5.2
6.0
6.3
6.6
6.7
7.5
6. A researcher collects data showing average time spent (in minutes) at the grocery self-checkout lane...
6. A researcher collects data showing average time spent (in
minutes) at the grocery self-checkout lane at a particular store.
Using a statistical software, create a histogram and generate
descriptive statistics for the average time spent by the 30
individuals that is shown below. Attach the printed output to your
assignment.
2.3
2.4
2.5
2.9
3.0
3.0
3.1
3.1
3.1
3.1
3.4
3.6
3.8
4.1
4.1
4.1
4.2
4.3
4.5
4.9
5.0
5.1
5.2
5.2
5.2
6.0
6.3
6.6
6.7...
SHOW ALL WORK. DO NOT USE SOFTWARE TO GENERATE ANSWERS. Calculate the R-chart and X-bar chart...
SHOW ALL WORK. DO NOT USE SOFTWARE TO GENERATE ANSWERS.
Calculate the R-chart and X-bar chart limits for the data given
below.
Day
A
B
C
D
1
7.2
8.4
7.9
4.9
2
5.6
8.7
3.3
4.2
3
5.5
7.3
3.2
6.0
4
4.4
8.0
5.4
7.4
5
9.7
4.6
4.8
5.8
6
8.3
8.9
9.1
6.2
7
4.7
6.6
5.3
5.8
8
8.8
5.5
8.4
6.9
9
5.7
4.7
4.1
4.6
10
3.7
4.0
3.0
5.2
11
2.6
3.9...
12. ANALYSIS OF VARIANCE The average of grade point averages (GPAs) of college courses in a...
12. ANALYSIS
OF VARIANCE
The average of grade
point averages (GPAs) of college courses in a specific major is a
measure of difficulty of the major. An educator wishes to conduct a
study to find out whether the difficulty levels of different majors
are the same. For such a study, a random sample of major grade
point averages (GPA) of 8 graduating seniors at a large university
is selected for each of the four majors mathematics, English,
Education, and Biology...
Provided in the date below a set of restoration times for 35 failed power transformers. The...
Provided in the date below a set of restoration times for 35
failed power transformers. The data were collected for recent
transformer failures by a fairly novice work crew. a. What is a 90%
confidence interval for mean restoration time? b. What is a 99%
confidence interval for mean restoration time? c. If the industry
standard for such a restoration is 2.7 hours, discuss how well the
work crew in this analysis performed.
2.2
1.7
2.4
2.5
2.9
4.4
5.1...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 21 minutes ago
asked 33 minutes ago
asked 53 minutes ago
asked 54 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 2 hours ago