Create a scalar function called PriceOfGivenRank, which takes an input of integertype. PriceOfGivenRank will first sort products in the descending order of unit prices exactly like RankOfGivenPrice in Q3. Then, PriceOfGivenRank will find the unit price of product(s) whose rank equalsto the input integer and return the unit price. If the input integer does not match any rank in the sorted Products table, it returns -2. For example, because there are four products with a unit price of $18 and they are all ranked to be 40, PriceOfGivenRank(40) should return 18. Because no products is ranked to be 90,PriceOfGivenRank(90) returns -2.In addition to 'create function' statement, your script must also contain threestatements to test PriceOfGivenRank. The first test should display a return ofa valid price, the second should display a return of -0.99, and the last is a special test, which uses a valid output of RankOfGivenPrice that you completed in Q3 as its input and this test displays the output of PriceOfGivenRank.

Explain the circumstances for which the interquartile range is the preferred measure of dispersion. what is an advantage that the standard deviation has over the interquartile range? choose the correct answer below. a. the interquartile range is preferred when the distribution is symmetric. an advantage of the standard deviation is that it increases as the dispersion of the data increases. b. the interquartile range is preferred when the data are not skewed or no have outliers. an advantage of the standard deviation is that it uses all the observations in its computation. c. the interquartile range is preferred when the distribution is symmetric. an advantage of the standard deviation is that it is resistant to extreme values. d. the interquartile range is preferred when the data are bell shaped. an advantage of the standard deviation is that it is resistant to extreme values. e. the interquartile range is preferred when the data are skewed or have outliers. an advantage of the standard deviation is that it uses all the observations in its computation. f. the interquartile range is preferred when the data are bell shaped. an advantage of the standard deviation is that it increases as the dispersion of the data increases.