Using the mean and standard deviation from the Descriptive Statistics, calculate the interval in which about 95% of the data should lie according to the Empirical Rule.
Using the Excel file STAT Assignment Data in the Stat Assignment folder in Blackboard, you will see a list of 200 values in column A. You will want to sort the values in column A by choosing the Data tab at the top and then sort the data in increasing order. These values were randomly generated from a Normal distribution with a mean of 100 and a standard deviation of 20. You will also see the Descriptive Statistics from this data starting in cell C1.
1) Using the mean and standard deviation from the Descriptive Statistics, calculate the interval in which about 68% of the data should lie according to the Empirical Rule.
2) From the sorted column A, find the percentage of data that actually lie in your interval calculated in 1) by counting the number of values that fit in your interval and dividing by 200.
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper Now3) Using the mean and standard deviation from the Descriptive Statistics, calculate the interval in which about 95% of the data should lie according to the Empirical Rule.
4) From the sorted column A, find the percentage of data that actually lie (without rounding) in your interval calculated in 3) by counting the number of values that fit in your interval and dividing by 200.
5) Using the mean and standard deviation from the Descriptive Statistics, calculate the interval in which about 99.7% of the data should lie according to the EmpiricalRule
The post Using the mean and standard deviation from the Descriptive Statistics, calculate the interval in which about 95% of the data should lie according to the Empirical Rule. appeared first on Essay Hotline.
