Assignment Content

1. Complete the descriptive statistics assignment. You may use:
   1. the MS Excel Std Dev Template file , ora statistical calculator
   Follow the instructions carefully for each question. You have one attempt.
2. QUESTION 126 PointsUsing the data set and sample size shown below, calculate the descriptive statistics. Round all requested values up or down to one decimal place. Note: each column is one sample.242528302839272729292629282629282631322530272729282727MeanBlank 1Blank 2Blank 3Blank 4Blank 5Blank 6Blank 7Blank 8Blank 9RangeBlank 10Blank 11Blank 12Blank 13Blank 14Blank 15Blank 16Blank 17Blank 18Sample mean (Xbar) or average of the mean = Blank 19Sample average of the ranges (Rbar) = Blank 20Sample standard deviation (s) = Blank 21Shewhart standard deviation (Rbar/d2 ) = Blank 22Sample variance (s2) = Blank 23
   • BLANK 1
   • BLANK 2
   • BLANK 3
   • BLANK 4
   • BLANK 5
   • BLANK 6
   • BLANK 7
   • BLANK 8
   • BLANK 9
   • BLANK 10
   • BLANK 11
   • BLANK 12
   • BLANK 13
   • BLANK 14
   • BLANK 15
   • BLANK 16
   • BLANK 17
   • BLANK 18
   • BLANK 19
   • BLANK 20
   • BLANK 21
   • BLANK 22
   • BLANK 23
3. QUESTION 23 PointsCompare and contrast sample standard deviation with Shewhart standard deviation. Which formula produces the least amount of standard deviation and which formula produces the most? Can you explain why?
4. QUESTION 33 PointsHow does variance relate to standard deviation?
5. QUESTION 43 PointsThe weight of navel oranges is normally distributed with mean = 8 ounces and standard deviation = 1.5 ounces. What percentage of oranges weighs between 6.8 and 8.9 ounces? Express the answer as a percentage to two decimal places.Integer, decimal, or E notation allowed
6. QUESTION 53 PointsSuppose that the weight of navel oranges is normally distributed with mean = 8 ounces and standard deviation = 1.5 ounces. What percentage of oranges weigh more than 11.5 ounces? Express the answer as a percentage to two decimal places.Integer, decimal, or E notation allowed
7. QUESTION 63 PointsThe weight of navel oranges is normally distributed with mean = 8 ounces and standard deviation = 1.5 ounces. What percentage of oranges weigh less than 5 ounces? Express the answer as a percentage to two decimal places.Integer, decimal, or E notation allowed
8. QUESTION 73 PointsFind the z-score for the 5th percentile of the distribution of X. Express the answer using two decimal places. Use a negative sign if needed.Integer, decimal, or E notation allowed

Requirements: As long as necessary