Hypothesis Test Calculations Exploratory Analysis Excel Task

I’m working on a statistics multi-part question and need an explanation to help me understand better.

Managing Ashland MultiComm Services Continuing its monitoring of the upload speed first described in the Chapter 6 Managing Ashland MultiComm Services case on page 221, the technical operations department wants to ensure that the mean target upload speed for all Internet service sub-scribers is at least 0.97 on a standard scale in which the target value is 1.0. Each day, upload speed was measured 50 times, with the following results (stored in AMS9 ). 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 0.808 1.012 0.859 0.951 1.112 1.003 0.972

1. Compute the sample statistics and determine whether there is evidence that the population mean upload speed is less than 0.97.

2. Write a memo to management that summarizes your conclusion.