Description
- Compute the sample statistics and determine whether there is evidence that the population mean upload speed is less than 0.97.
- Write a memo to management that summarizes your conclusion.
*These are eText page numbers.
*Please note the data are stored in AMS9 (attached). Also, please note you need to submit two identical files:
1. The original Excel file for all work, including your calculations, decision, and memo, and
2. The PDF copy of the Excel file.
TEXT:
CUSTOM EDITION of Statistics for Managers Using Microsoft Excel, 8th Edition; Levine,
Stephan, and Szabat; Pearson; ISBN of custom edition: 9781323516881; © 2016.
Explanation & Answer
It has been great working with you right from the start to the end. I wish you all the best in your academics. Feel free to ask me any question in the future.
Upload Speed
0.854
1.023
1.005
1.030
1.219
0.977
1.044
0.778
1.122
1.114
1.091
1.086
1.141
0.931
0.723
0.934
1.060
1.047
0.800
0.889
1.012
0.695
0.869
0.734
1.131
0.993
0.762
0.814
1.108
0.805
1.223
1.024
0.884
0.799
0.870
0.898
0.621
0.818
1.113
1.286
1.052
0.678
1.162
Hypothesis Test
Upload Speed
Mean
Standard Error
Median
Mode
Standard Deviation
Sample Variance
Kurtosis
Skewness
Range
Minimum
Maximum
Sum
Count
0.95872
0.02206
0.98500
1.01200
0.15597
0.0...