The coefficient of variation and the standard deviation are two measures of variability or dispersion among data values. Provide two different sets of ten data points each as examples.Read both samples and explain what your take away for each examples. Please add information if you can. Your document should be minimum 300 words. Please have credible references. Example 1:The data I collected represents the heights of tallest buildings – data set #1 is for the 10 tallest building heights in the U.S. and data set #2 is for the 10 tallest building heights in the world. Included are Excel calculations for the mean, standard deviation, coefficient of variation (CV), Q1 and Q3.The standard deviation for set 1 is 165.37 versus 308.95 for set 2. The CV for set 1 is 11.7% versus 16.1% for set 2. The standard variation gives one version of variability, that is easy to understand and visualize - data set #2 is almost twice as far from its mean as data set #1 is from its mean (308.95 vs 165.37). The CV, however, shows that the relative variability is relatively small, with set #1 at 11.7% and set #2 at 16.1%, a difference of only 4.4 percentage points and a relatively low CV. In this example, the CV gives a truer understanding of the variability of the data.Interesting information: Only one U.S. building is in the world’s top 10 in height -One World Trade Center at 1776 feet (coming in at #6). Of the remaining 9, 5 are in China, and one each in UAE, Saudi Arabia, South Korea, and Taiwan. While most of the technology used for creating these engineering marvels still comes from the U.S., rising construction costs ($375/ft in New York vs $75/ft in Beijing), expansive building codes, and changes in corporate priorities are the reasons for fewer of them being built domestically (Petras, Padille, & Sergent, 2019).The QUARTILE.EXC function in Excel provides a calculation function that quickly determines the first and third quartiles of an identified data set. On Excel, the calculation can be done in one step, using the formula =QUARTILE.EXC(A1:A10,1), an example for Q1 for 10 data points. Performing this calculation manually, as in the text, is a multi-step calculation. The data needs to be ordered, the median determined, then the medians of the bottom half of the data (Q1) and top half of the data (Q3) calculated, resulting in 4 equal divisions of the data points. This data can then also be used to determine the interquartile range (IQR), which is the difference between Q1 and Q3 and measures and identifies any outliers in the data.Microsoft, QUARTILE.EXC function. Microsoft Support. Retrieved from https://support.microsoft.com/en-us/office/quartile-exc-function-5a355b7a-840b-4a01-b0f1-f538c2864cad (Links to an external site.)Petras, G, Padilla, R. & Sergent, J. (2019, April 8). The world’s tallest buildings aren’t being built in the USA anymore. USA Today. Retrieved from https://www.usatoday.com/in-depth/news/2019/04/08/worlds-tallest-buildings-why-america-isnt-building-them/3160931002/Example 2:Data SetsMeanSDCV%Data Set 16567697175757882899176.28.89194411.66922Data Set 27273757777848789929682.28.52186710.36724Provided above is the excel sheet that I used to calculate my work for each data set. To calculate the standard deviation for each data set I used the formula: =STDEV proceeded by the cells in which the data sets were located, for example:=STDEV(B2:K2) . In order to calculate the coefficient of variation for each data set, I first had to have the values for both the standard deviation and the mean. To calculate the coefficient of variation I divided the standard deviation by the mean and multiplied that by 100. I did this for each data set. Data set 2 has a lower standard deviation and coefficient of variation meaning that the data represented are all closely concentrated to the mean and have less variation between the data within the set (OpenStax, 2019). When comparing the two data sets, due to data set 1 having a higher standard deviation and higher CV, there is more variability of the given data. Of the two mentioned measures the coefficient of variation more accurately specifies the variability of the data sets because in order to calculate CV, the user must have all the represented data (mean/SD). This gives the user a more accurate representation of the variability due to having more information available, rather than just finding the standard deviation alone.The Excel function “QUARTILE.EXC” for calculating quartiles for a given data set seems to be an exclusive or greater than way to calculate the 25th percentile or Q1, the 50th percentile or the median, and the 75th percentile or Q3 of a data set (Bruns, 2020). Unlike the textbook and lecture methods, this method of calculation is limited to the values of the first, second, ad third quartiles only. This means that the 0 and the 4 quartile or minimum and maximum quartile when listed will give the user a #NUM! error. The QUARTILE.INC function is inclusive or greater than or equal to which allows for all of the quartiles to be calculated.References:Burns, D. (2020). Excel QUARTILE.EXC function. Exceljet. Retrieved from https://exceljet.net/excel-functions/excel-quartil... function#:~:text=EXC%20function%20to%20get%20the,the%20in%20the%20table%20below.OpenStax. (2019). Introductory statistics. Houston, TX: OpenStax College. CC BY-SA. Retrieved from https://cnx.org/contents/MBiUQmmY@23.21:kcV4GRqc@1...

Question 1 (5 points) For each situation, make a tree diagram or table to show the sample space. Then give the total number of outcomes.picking a number from 1 to 4 and choosing the color red, green, or yellow Question 1 options:691224Question 2 (5 points) List all of the possible outcomes using the table below. SkirtColorskirt 1whiteskirt 2black Question 2 options:skirt 1, whiteskirt 2, blackskirt 2, whiteskirt 2, black skirt 1, whiteskirt 1, blackskirt 2, whiteskirt 2, black skirt 1, whiteskirt 1, blackskirt 2, whiteskirt 2, white skirt 1, whiteskirt 1, blackskirt 1, whiteskirt 2, black Question 3 (5 points) Find the mode of each set of data.33, 19, 15, 39, 39, 34, 24, 29Question 3 options:31293239Question 4 (5 points) Find the interquartile range of the data.68, 82, 44, 79, 94, 60, 78, 70, 59 Question 4 options:70205021Question 5 (5 points) Winona’s bowling scores for the past nine weeks are 195, 180, 195, 212, 208, 231, 179, 246, and 195. Find the mean, median, and mode. Round to the nearest tenth, if necessary.Question 5 options:204, 195, 195204.6, 195, 195204.6, 208, 195205, 195, no modeQuestion 6 (5 points) The frequency table shows Sam’s record in swimming. YearNumber of medals2008620094201012012720134Based on this record, what is the probability of picking up a medal won by him in the years 2009 or 2012. Question 6 options:2Question 7 (5 points) The table shows the price of admission at eight theaters. Theater Admission Prices ($)5.007.508.258.009.7510.2511.0010.75Find the mean absolute deviation of admission prices. Round to the nearest hundredth if necessary. Question 7 options:$13.00$8.81$6.00$1.63Question 8 (5 points) Identify the sample as biased or unbiased and describe its type.John wanted to know about the popularity of a particular movie. He surveyed 20% of the people in 5 different theaters.Question 8 options:biased, voluntary response samplebiased, convenience sampleunbiased, simple random sampleunbiased, systematic random sampleQuestion 9 (5 points) The table shows the high temperatures for two different cities over the past 10 days. High Temperatures (°F)Lewistown64656566686970717374Hamersville55636567676868687071Compare the ranges in temperature for the cities. Question 9 options:The range for Lewistown is 6 more than the range for Hamersville.The range for Lewistown is 3 more than the range for Hamersville.The range for Hamersville is 5 more than the range for Lewistown.The range for Hamersville is 6 more than the range for Lewistown.Question 10 (5 points) Nina’s quiz scores for the quarter are 90, 79, 5, 84, 95, 81, 87, and 94. Which measure of central tendency best represents the data shown in the table and why? Question 10 options:Since the data have many repeated values, the mode best represents the data.Since there is an extreme value (5) and there are no big gaps in the middle of the data, the median best represents the data.Since there are no extreme values, the mean best represents the data.Since there are no extreme values and few repeated numbers, the median best represents the data.Question 11 (5 points) Lionel is apartment hunting. He makes a table of prospective apartment choices. Apartment Rental PricesApartment ChoicePrice per Month ($)1630275536754765569066807675Which measure of central tendency best represents the data shown in the table and why? Question 11 options:Since the data is grouped close together, the mode best represents the data.Since there are no extreme values, the median best represents the data.Since there are no extreme values and few repeated numbers, the mean best represents the data.Since the value 675 occurs more than once, the mode best represents the data.Question 12 (5 points) How Often We Check EmailAccording to the graph, out of 2500 people, how many would you expect check email daily?Question 12 options:575 people1900 people190 people25 peopleQuestion 13 (5 points) Identify the sample as biased or unbiased and describe its type.To determine whether students would choose engineering as their profession, equal number of boys and girls were surveyed in a school.Question 13 options:unbiased, stratified random sampleunbiased, systematic random samplebiased, convenience samplebiased, voluntary response sampleQuestion 14 (5 points) The table shows the number of points scored by each team in a tournament. Number of Points Scored1225162031161922Find the mean absolute deviation of the number of points scored. Round to the nearest hundredth if necessary. Question 14 options:4.411620.1335.26Question 15 (5 points) Find the probability.A bag of sweets contains 20 gummy bears and 35 orange slices. One sweet is taken at random from the bag. Find P(gummy bear).Question 15 options:Question 16 (5 points) Find the range for the set of data.101, 72, 115, 114, 117, 56, 101, 68, 111, 58, 51, 51, 90Question 16 options:64856690Question 17 (5 points) Find the probability.A marble is randomly selected from a bag containing 15 black, 12 white, and 6 clear marbles. Find P(not clear). Round to the nearest percent if necessary. Question 17 options:18%82%64%55%Question 18 (5 points) Find the median, first quartile, third quartile, interquartile range, and any outliers for each set of data.111, 68, 93, 88, 74, 152, 119, 87, 88, 105, 84, 102, 151, 115, 112 Question 18 options:median: 102, Q1: 87, Q3: 113, IR: 28, outliers: nonemedian: 102, Q1: 87, Q3: 115, IR: 28, outliers: 68median: 102, Q1: 87, Q2: 115, IR: 28, outliers: nonemedian: 102, Q1: 87, Q3: 115, IR: 27, outliers: noneQuestion 19 (5 points) For the following exercises, use the chart below. It shows the percent of consumers who prefer each brand of paper towel. Paper TowelNumber of ResponsesThirsty49Clean24Strong Ones15PowerWash12Predict how many consumers prefer PowerWash paper towels from a group of 195? Question 19 options:23 consumers24 consumers29 consumers30 consumersQuestion 20 (5 points) Find the median, first quartile, third quartile, interquartile range, and any outliers for each set of data.14.6, 28.1, 3.9, 7.1, 5.3, 30.9, 2.8, 6.5, 20.8, 16.4, 16.4, 27.1, 53.5, 12.5, 6.1 Question 20 options:median: 14.6, Q1: 6.1, Q3: 27.1, IR: 21, outliers: nonemedian: 14.6, Q1: 6.1, Q3: 27.1, IR: 20, outliers: nonemedian: 14.6, Q1: 6.1, Q3: 27.1, IR: 21, outliers: 2.8median: 14.6, Q1: 6.1, Q3: 25.1, IR: 21, outliers: none Submit Quiz0 of 20 questions saved