This assignment focuses on standard Deviation, Range Rule of Thumb, and Percentage Error. Overview Standard deviation is a reliable (and commonly used) measure of variation. Standard deviation essentially describes the average distance that each data value is away from the mean.

Range Rule of Thumb

Project: Standard Deviation, Range Rule of Thumb, and Percentage Error.  Assignment Instructions Overview Standard deviation is a reliable (and commonly used) measure of variation. Standard deviation essentially describes the average distance that each data value is away from the mean. Computing standard deviation by hand can be complicated so you are asked to use Excel to calculate it for this project. You will also calculate the Range Rule of Thumb (RROT). The RROT is based on the insight that the range is often approximately four times as large as the standard deviation.

Range Rule of Thumb

This insight enables you to quickly estimate the standard deviation of a data set quickly. Lastly, you will calculate the percentage error of each data set. Percent error is the difference between estimated value (RROT) and the actual value (standard deviation) in comparison to the actual value and is expressed as a percentage. 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. https://youtu.be/txA8ASz657s

Range Rule of Thumb

Data Sets 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: use the Excel function “=stdev.s” (or technology) · Range Rule of Thumb (RROT) Estimate: 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): The formula used to find the percentage error of the estimate is:

Additional Files