The accompanying data sets represent the annual rate of return (in percent) of eight randomly sampled bond mutual funds, and the annual rate of return (in percent) of eight randomly sampled stockmutual funds. Use the information in the table below to complete parts (a) through (d). Then complete part (e).Click the icon to view the data.(Type an integer or decimal rounded to three decimal places as needed.)What is the standard deviation of the data set for height in centimeters?(Type an integer or decimal rounded to three decimal places as needed.)Based on the standard deviation, the data set for height inWhat is the CV of the data set for height in inches?has more spread.(Type an integer or decimal rounded to three decimal places as needed.)What is the CV of the data set for height in centimeters?(Type an integer or decimal rounded to three decimal places as needed.)What is true of the coefficient of variation?OA. When converting units of measure, the coefficient of variation is unchanged.OB. The coefficient of variation does not give as accurate a measurement as the standard deviation.OC. The coefficient of variation is always more meaningful than the standard deviation.OD. The coefficient of variation is best used when comparing two data sets that use the same units of measure.-&PrtScnF8OHomeF9EndF10Data tableLBond mutualfunds3.42.12.61.82.03.62.92.2PrintPgUpStock mutual Cfunds9.6 7.89.37.68.67.48.3 7.1DonePgOn 120- XNext4001:47 PM11/12/2022EinsDelBackspace The accompanying data sets represent the annual rate of return (in percent) of eight randomly sampled bond mutual funds, and the annual rate of return (in percent) of eight randomly sampled stockmutual funds. Use the information in the table below to complete parts (a) through (d). Then complete part (e).Click the icon to view the data.Based on the coefficient of variation,have more spread.(e) In the table below, the data set on the left has the heights of students measured in inches, while the data set on the right has the same students' heights measured in centimeters. For each dataset, determine the mean and the standard deviation. Draw a conclusion about the spread using the standard deviation, then find the coefficient of variation for both data sets.Height ininches68757168746772180.34 182.88187.96 177.8What is the mean of the data set for height in inches?70Height incentimeters172.72 172.72190.5 170.18D(Type an integer or decimal rounded to three decimal places as needed.)What is the standard deviation of the data set for height in inches?$(Type an integer or decimal rounded to three decimal places as needed.)What is the mean of the data set for height in centimeters?(Type an integer or decimal rounded to three decimal places as needed.)What is the standard deviation of the data set for height in centimeters?HOL DCLPrtScnTFBJOHomeF9EndData tableBond mutualfundsF103.42.02.13.62.6 2.91.8 2.2PrintPgUpStock mutual Cfunds9.69.37.87.68.67.48.3 7.1DonePgDn3F124- XNext30%1:47 PM11/12/2022InsDel

(e) Find the mean, standard deviation, and coefficient of variation for the both variables by using Excel. Excel add-in (PHStat) procedure: Step 1: In EXCEL, Select Add-Ins > PHStat > Descriptive Statistics > Descriptive Summary. Step 2: In Data, select the cell range Height in inches and Height in centimeters under First cell contains label. Step 3: In Input Options, choose Multiple Groups Unstacked. Step 4: In Output Options, enter a Title and click OK.Excel add-in (PHStat) output: From the output, The mean of the data for height in inches is 70.625. The standard deviation of the data for height in inches is 2.925. The mean of the data for height in centimeters is 179.387. The standard deviation of the data for height in centimeters is 7.429. From the information, the standard deviation of the data for height in centimeters is larger when compared to the standard deviation of the data for height in inches. Hence, the data for height in centimeters have more spread. Based on the standard deviation, the data set for height in centimeters has more spread. The coefficient of variation of the data for height in inches is 4.14%. The coefficient of variation of the data for height in centimeters is 4.14%. Here, both the coefficient of variation are equal. That is, when converting units of measure the coefficient of variation is unchanged. Correct Answer: Option (A)