Statistics Technology assignment

ORDER A PLAGIARISM FREE PAPER NOW

WEEK 6:

Hypothesis Test – Download the data set “Airport Speeds” in your preferred technology format (StatCrunch, Statdisk, Excel).  Column 2 denotes the data speeds (Mbps), taken from 50 different airports, for the carrier Verizon.  Column 4 denotes the data speeds (Mbps) for the carrier AT&T from the same 50 airports.

Using technology (StatCrunch, Statdisk, or Excel) compute the mean data speed for each of the two carriers, Verizon and AT&T.  Provide a printout of your technology output using the Insert/Edit Image feature (no attachments!)    Based on this, which carrier do you think has the faster speed?

Next, using technology (StatCrunch, Statdisk, or Excel) conduct a hypothesis test to test your claim about which carrier has the faster speed.  Explain which test you conducted and why that is the appropriate test for this example.  Provide a printout of your technology output using the Insert/Edit Image feature (no attachments!)   Explain your conclusion in statistical and non-statistical terms and how you arrived at that conclusion.  Be sure to follow the 8-step procedure on page 360, using technology to do your calculations.  You should include your null and alternative hypothesis (in English and in symbolic form), your significance level, whether you are conducting a right tailed, left tailed, or two tailed test, p-value, and conclusions.

USE EXCEL SHET BELOW