I need help answering these questions.
Project_1_Instructions(2) - Microsoft Word X Home Insert Page Layout References Mailings Review View Cut Copy Times New Roman Bolc - 14 - A A 4 := =1 2 q AaBbCcDc AaBbCcDc AaBbCc AaBbCc AB| AaBbCc! AaBbCCD AaBbCCD AaBbCCD AaBbCcD( AaBbCCDt AA Find paste BI U ~ abe X x Aa 3 . A- 1 Normal 1 No Spaci... Heading 1 Heading 2 Title Subtle Em... Intense E... Quote Change Gac Replace Format Painter Subtitle Emphasis Strong Styles Select Clipboard Font Paragraph Styles Editing 1. Each of the following 5data sets has a mean close to 100, and a standard deviation in the 20s. Assume that each of these are sample data sets. For each of the 5data sets given below, use the Excel function "=stdev.s"(or technology) to find the actual sample standard deviation (10 points), compute the estimate given by the Range Rule of Thumb (RROT) Estimate (10 points), and compute the percentage error of the 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. The formula used to find the percentage error of the estimate is: % Error = \\RROT Estimate - Standard deviation | / Standard Deviation x 100%. a. Data Set 1: No outliers 77 |77 |77 77 77 123 123 123 123 123 Actual Standard deviation = RROT Estimate = % Error = b. Data Set 2: 1outlier 88 91 91 91 91 92 92 92 92 170 Actual Standard deviation = RROT Estimate = % Error = c. Data Set 3: 2outliers |48 96 36 99 100 100 101 102 104 152 Actual Standard deviation = RROT Estimate = % Error = d. Data Set 4: Normal (Bell-Shaped) Distribution 61 77 84 91 97 103 109 116 125 138 Actual Standard deviation = RROT Estimate = % Error = e. Data Set 5: Uniform Distribution (evenly-spaced values) 65 73 81 89 97 105 113 121 129 137 Actual Standard deviation = RROT Estimate = % Error = Page: 1 of 2 Words: 443 1 3 100% + O O emac 9 Links ? 4:20 PM 2/3/2020