A computer operations department decided to study the effect ofthe connection media used (either cable or fiber). The teamdesigned a study in which a total of 30 subscribers were chosen.The subscribers were randomly assigned to one of the 3 messagingsystems and measurements were taken on the updated time (inseconds). The data are shown below.
(With excel functions can you help in solving thesequestions)
a. State the null and alternate hypotheses that would be used totest whether there is a significant difference in the averageupdate times for the three different messaging systems. Expresssymbolically if possible.
b. What type of study is this and what type of hypothesis testwould be used to conduct the hypothesis test?
c. What is the p-value corresponding to this hypothesis test?(use cell reference to show answer and where it is found).
d. Conduct a hypothesis test to test whether there is asignificant differencewhether there is a significant difference inthe average update times for the three different messaging systems.Give a complete summary.
e. State the null and alternate hypotheses that would be used totest whether there is a significant difference in the mean updatetimes of the messaging systems using the 2 different connectionmedia. Express symbolically if possible.
f. What is the p-value corresponding to this hypothesis test?(use cell reference to show answer and where it is found).
g. Conduct a hypothesis test to test whether there is asignificant effect due to messaging system used. Give a completesummary.
h. State the null and alternate hypotheses that would be used totest whether there is an interaction between the connection mediaand the messaging system. Express symbolically if possible.
i. What is the p-value corresponding to this hypothesis test?(use cell reference to show answer and where it is found).
j. Conduct a hypothesis test to determine whether there is aninteraction between interaction between the connection media andthe messaging system. State complete conclusions.
| | | |
| Technology | System1 | System2 | System3 |
| Cable | 4.56 | 4.17 | 3.53 |
| Cable | 4.90 | 4.28 | 3.77 |
| Cable | 4.18 | 4.00 | 4.10 |
| Cable | 3.56 | 3.96 | 2.87 |
| Cable | 4.34 | 3.60 | 3.18 |
| Fiber | 4.41 | 3.79 | 4.33 |
| Fiber | 4.08 | 4.11 | 4.00 |
| Fiber | 4.69 | 3.58 | 4.31 |
| Fiber | 5.18 | 4.53 | 3.96 |
| Fiber | 4.85 | 4.02 | 3.32 |
