Solve this word problem using step by stepprocedure: The math department at a local university hascustomarily advised students to purchase Calculator A. Themanufacturer has recently released a new model, Calculator B, whichis reputed to be more user-friendly. The faculty decided todetermine if there is a difference in the time required to performa certain common statistical calculation. Twelve students chosen atrandom are given drills with both calculators so that they arefamiliar with the operation of each type. Then the time they taketo complete the test calculation on each device is measured inseconds (which calculator they are to use first is determined bysome random procedure to control for any additional learning duringthe first calculations). To be clear, each student worked through aparticular type of statistics problem with one calculator and thendid a similar problem on the other calculator. For each student,the amount of time in seconds that they spent on the problem witheach calculator was recorded. Is Calculator B likely to be a moreeffective device than Calculator A?
| Student | CalculatorA | Calculator B |
| 1 | 23 | 19 |
| 2 | 18 | 18 |
| 3 | 29 | 24 |
| 4 | 22 | 23 |
| 5 | 33 | 31 |
| 6 | 20 | 22 |
| 7 | 17 | 16 |
| 8 | 25 | 23 |
| 9 | 27 | 24 |
| 10 | 30 | 26 |
| 11 | 25 | 24 |
| 12 | 27 | 28 |
b) Please use step by step guidelines so I can follow inthis excel problem: In the sheet entitled “Part 2 Question7â€, you will find the death rate (per 1,000 resident population)for random samples of counties in Alaska and Texas. Is the averagedeath rate among Alaska counties likely to be lower than that amongTexas counties?
| Alaska | Texas |
| 1.4 | 7.2 |
| 4.2 | 5.8 |
| 7.3 | 10.5 |
| 4.8 | 6.6 |
| 3.2 | 6.9 |
| 3.4 | 9.5 |
| 5.1 | 8.6 |
| 5.4 | 5.9 |
| 6.7 | 9.1 |
| 3.3 | 5.4 |
| 1.9 | 8.8 |
| 8.3 | 6.1 |
| 3.1 | 9.5 |
| 6 | 9.6 |
| 4.5 | 7.8 |
| 2.5 | 10.2 |
| 5.6 |
| 8.6 |
