Please answer BOTH parts! Thank you!

INSTRUCTIONS This assignment will be completed in two parts: Data Sets and Summary. After completing the computations for the Data Sets, you will summarize what you have learned by answering the questions after the data sets. See both sections below to find more information. Each of the following 5 data sets has a mean close to 100, and a standard deviation in the 20s. Assume that each of these are sample data sets. Excel can be used to do the calculations. For each of the 5 data sets given below to find the following: Sample Standard Deviation (10 points): use the Excel function "=stdev.s" (or technology) Range Rule of Thumb (RROT) Estimate (10 points): the formula for the RROT estimate is RROT estimate = Range/4 (where the range = maximum value - minimum value), on the assumption that the Standard Deviation & RROT estimate. Percentage Error (% Error) (10 points): The formula used to find the percentage error of the estimate is: % Error = | RROT Estimate - Standard deviation | / Standard Deviation x 100= %. Round answers to two decimal places as needed. 1. Data Set 1: No outliers 77 77 77 77 77 132 132 132 |132 132 Actual Standard deviation - RROT Estimate % Error = 2. Data Set 2: 1 outlier 63 76 76 76 76 77 77 77 77 155 Actual Standard deviation = RROT Estimate = % Error = 3. Data Set 3: 2 outliers 48 96 98 99 100 100 101 102 114 162 Actual Standard deviation = RROT Estimate = % Error = 4. Data Set 4: Normal (Bell-Shaped) Distribution 55 71 78 85 91 97 103 110 1 19 132 Actual Standard deviation = RROT Estimate = Error = 5. Data Set 5: Uniform Distribution (evenly-spaced values) 61 69 77 85 93 101 109 117 125 133 Actual Standard deviation = RROT Estimate = % Error MATH 114 Summarize what you learned: a) Does the Range Rule of Thumb estimate more often underestimate or overestimate the actual standard deviation? (3 points) b) What is the largest percentage error? (3 points) c) Each of the data sets given above is artificially contrived. If you were to apply the RROT estimate to a typical real-world data set, about how accurate would you expect it to be (your answer here should be a numerical estimate of the percentage error, based on your previous results)? (4 points)