Please see the screenshots attached. I have already done a few questions but I am very confused on how to do questions 8-10.

1 Q2 - Saved to my Mac Q AutoSave . OFF Share Comments Home Insert Draw Page Layout Formulas Data Review View Developer Tell me ap Wrap Text v IX V V Ex AY - O. 12 AA General Arial [B Conditional Format Cell Insert Delete Format Sort & Find & Analyze Paste BIUVE OvAv EE Merge & Center v $ ~ % " Formatting as Table Styles Filter Select Data Check for Updates Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. H23 M N 0 P Q R S T U A B C D E G H You are a statistician contracted to sample and analyze weights of the 5 lb bags of coffee. You collect the following data: 5.84 4.33 5.52 4.56 5.82 5.84 5.00 4.48 5.14 5.78 3.98 6.16 6.02 5.43 5.78 4.57 5.03 4.60 5.00 5.05 4.33 5.63 5.27 4.25 5.82 4.23 5.86 5.22 4.89 5.33 5.53 4.72 5.07 5.60 4.79 5.78 5.03 5.05 5.35 4.28 5.64 5.13 5.56 5.52 6.07 4.30 4.79 4.89 4.52 4.53 4.52 5.31 5.27 5.22 5.14 5.20 1.32 5.03 5.39 5.18 5.19 4.45 5.53 4.96 5.44 5.59 4.60 6.09 4.32 4.45 4.91 5.55 5.22 5.65 4.76 5.31 4.39 5.50 5.00 4.51 5.63 10 4.52 4.63 5.22 4.51 4.79 5.50 4.98 4.79 6.09 4.23 11 5.35 For all questions, write your answers in the yellow cells. 4.89 13 Compute the following statistics using Excel functions so that Excel calculates for you: 5.39 14 4.45 15 1) Mean 5.084 4.52 16 Median 5.134 4.48 17 5.27 18 2) using QUARTILE.EXC |4.602 5.86 19 Third quartile using QUARTILE.EXC|5.514 4.28 20 Interquartile range (IQR) 0.912 4.52 21 Maximum 6.157 6.160 5.18 3 4.91 23 Minimum 3.981 24 Range 2.175 2.180 4.63 5.14 25 4.25 26 4) Variance 0.259 5.22 27 Standard deviation 0.509 5.64 28 Coeficient of Variation (CV)| 10.0% 4.53 29 5.19 30 5 For the standard deviation, when do you use STDEV.S and when do you use STDEV.P? 5.55 31 STDEV.S is used when using a sample size 5.22 32 and STDEV.P is used when using population 5.78 33 size. 5.43 34 35 6 Explain why the standard deviation is a better measure to use than the variance. 4.89 5.13 36 Standard Deviation is a better measure to use as it helps provide clarity 4.52 37 n regards to the deviation from a mean's point of view. 4.45 38 5.22 39 Sheet1 + - + 100%1 Q2 - Saved to my Mac Q AutoSave . OFF Home Insert Draw Page Layout Formulas Data Review View Developer Tell me Share Comments Arial 12 AA ap Wrap Text v General Ex AY - O. [B Delete Format Paste EE Merge & Center v $ ~ % " Conditional Format Cell Insert Sort & Find & Analyze BIUVE OvAv Formatting as Table Styles Filter Select Data Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates H23 + X V fx H K L M N 0 P Q R S T U A C 4.51 40 41 7) The coefficient of variation (CV) is a measure of relative variability equal to the ratio between the standard 3.98 42 deviation divided by the mean, and formatted to %. It is regularly used to compare risk (volatility) in 5.78 43 investing, and is especially useful in to compare data on different scales or with different units of measure. 5.33 44 Consider weights of 10 oz, 13.4 oz, 15.1 oz with SD of 2.597 oz. The corresponding weights in pounds 5.56 45 0.625 lb, 0.838 lb, 0.944 lb have SD 0.162 lb. The SDs are not equal, yet the sample and its variability are 5.31 46 the same. How can we compare variabilities? The CV, unlike other measures of variability, does not 5.53 depend on the units of measure. The units are divided out in dividing the standard deviation by the mean. 5.65 48 For a "rule of thumb", a CV of greater than 5% is considered significant. So, the CV is also used to assess 4.79 6.16 When is the Coefficient of Variation (CV) especially useful? 4.57 5.53 CV is especially useful when comparing a data 5.52 set between distinct series sets of data. 5.27 4.96 55 4.76 56 8 ) Copy all of the data into cells M1:M80 in order to use Data Analysis Descriptive Statistics. 5.50 57 6.02 58 What happens if you don't and instead use B3:K10 for the Input Range? 5.03 59 4.72 60 5.07 61 5.22 62 5.44 63 5.31 64 Use the Data Analysis, Descriptive Statistics. Click the Summary Statistics box and put the output at B65. 4.98 65 5.52 66 4.60 67 5.07 4.30 5.14 70 5.59 4.39 4.79 4.56 5.00 5.60 5.78 77 5.20 78 4.60 Sheet1 + - + 100% ITAutoSave . OFF 1 Q2 - Saved to my Mac Q Share Comments Home Insert Draw Page Layout Formulas Data Review View Developer Tell me Arial 12 AA ab Wrap Text v General Ex AY - O. [B Cell Insert Delete Format Sort & Find & Analyze Paste BIU E vAv E E Merge & Center v $ ~ % " Conditional Format Formatting as Table Styles Filter Select Data Check for Updates Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. H23 + X V fx Q R S T U A B C D E F G H K L M N 0 P 5.59 70 4.39 71 72 4.79 4.56 73 74 5.00 75 5.60 76 5.78 5.20 4.60 78 79 5.50 4.51 80 81 Highlight the mean, median, Standard deviation, Range, Minimum, and Maximum. 82 83 9 As a contracted statistician, you have no prior experience with the company's product. 84 The company has no prior process history and data with which to compare the sample to evaluate any trends. 85 The mode is not especially useful for this data, but explain why there is or is not 86 a concern with bag weight in terms of the other measures of central tendency. 87 88 89 90 10) What statistic should you use to assess variability of the product? 91 92 93 Explain why there is or is not a concern with the variability of the product. 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 Sheet1 + + 100% IT