tables_for_questions_1-15.xlsx
Sheet1
| Question 1 | | Response | 1 | 2 | 3 |
| | | Yes | 150 | 150 | 96 |
| | | No | 100 | 150 | 104 |
| | | | | Airline |
| Question 2 | | Flight | Delta | United | US Airways |
| | | Late | 39 | 51 | 56 |
| | | On Time | 261 | 249 | 344 |
| Question 3 | | Row Variable | A | B | C |
| | | P | 20 | 30 | 20 |
| | | Q | 30 | 60 | 25 |
| | | R | 10 | 15 | 30 |
| Question 4 | | Chevy Cruze | 108 |
| | | Ford Focus | 92 |
| | | Hyundai Elantra | 64 |
| | | Honda Civic | 84 |
| | | Toyota Corolla | 52 |
| | | | | Reputation of Company |
| Question 5 | | Quality of Management | Excellent | Good | Fair |
| | | Excellent | 40 | 25 | 5 |
| | | Goood | 35 | 35 | 10 |
| | | Fair | 25 | 10 | 15 |
| | | | | Production Shift |
| Question 6 | | Quality | First | Second | Third |
| | | Good | 285 | 368 | 176 |
| | | Defective | 15 | 32 | 24 |
| | | | | City |
| Question 7 | | In Workforce | Anchorage | Atlanta | Minneapolis |
| | | Both Work | 57 | 70 | 63 |
| | | Only One | 33 | 50 | 27 |
| Question 8 | | | Treatment |
| | | A | B | C |
| | | 136 | 107 | 92 |
| | | 120 | 114 | 82 |
| | | 113 | 125 | 85 |
| | | 107 | 104 | 101 |
| | | 131 | 107 | 89 |
| | | 114 | 109 | 117 |
| | | 129 | 97 | 110 |
| | | 102 | 114 | 120 |
| | | | 104 | 98 |
| | | | 89 | 106 |
| | x̄ | 119 | 107 | 100 |
| | s^2 | 146.86 | 96.44 | 173.78 |
| Question 9 | | | Manufacturer |
| | | 1 | 2 | 3 |
| | | 20 | 28 | 20 |
| | | 26 | 26 | 19 |
| | | 24 | 31 | 23 |
| | | 22 | 27 | 22 |
| Question 10 | | Source of Variation | Source of Squares | Degrees of Freedom | Mean Square | F |
| | | Treatments | 900 |
| | | Blocks | 400 |
| | | Error |
| | | Total | 1800 |
| Question 11 | | Subject | Treadmill | Ergometer | Shovel | Snow Thrower |
| | | 1 | 177 | 205 | 180 | 98 |
| | | 2 | 151 | 177 | 164 | 120 |
| | | 3 | 184 | 166 | 167 | 111 |
| | | 4 | 161 | 152 | 173 | 122 |
| | | 5 | 192 | 142 | 179 | 151 |
| | | 6 | 193 | 172 | 205 | 158 |
| | | 7 | 164 | 191 | 156 | 117 |
| | | 8 | 207 | 170 | 160 | 123 |
| | | 9 | 177 | 181 | 175 | 127 |
| | | 10 | 174 | 154 | 191 | 109 |
| Question 12 | | Marketing Managers | Marketing Research | Advertising |
| | | 6 | 5 | 6 |
| | | 5 | 5 | 7 |
| | | 4 | 4 | 6 |
| | | 5 | 4 | 5 |
| | | 6 | 5 | 6 |
| | | 4 | 4 | 6 |
| Question 13 | | | Size of Advertisement |
| | | | Small | Large |
| | | A | 8 | 12 |
| | | | 12 | 8 |
| | Design | B | 22 | 26 |
| | | | 14 | 30 |
| | | C | 10 | 18 |
| | | | 18 | 14 |
| Question 14 | | Lawyer | Physical Therapist | Cabinetmaker | Systems Analyst |
| | | 44 | 55 | 54 | 44 |
| | | 42 | 78 | 65 | 73 |
| | | 74 | 80 | 79 | 71 |
| | | 42 | 86 | 69 | 60 |
| | | 53 | 60 | 79 | 64 |
| | | 50 | 59 | 64 | 66 |
| | | 45 | 62 | 59 | 41 |
| | | 48 | 52 | 78 | 55 |
| | | 64 | 55 | 84 | 76 |
| | | 38 | 50 | 60 | 62 |
| Question 15 | | | System |
| | | | Manual | Automatic |
| | | Machine 1 | 30 | 30 |
| | | | 34 | 26 |
| | | Machine 2 | 20 | 24 |
| | | | 22 | 28 |