Question 3 The boss decides that using only 3 levels—small, medium, and large—does not give the shipping department enough information. She wants to use the 10 levels shown in Lookup Table 1 (A3:B12). Write a formula in the “Expanded Order Type” column to assign the correct type to each order by “Order Quantity.” Copy the formula down to all the rows. Based on the layout of Lookup Table 1, should you use a VLOOKUP function or an HLOOKUP function?

1 / 1 point

VLOOKUP

HLOOKUP

If your score on your next statistics test is converted to a z score, which of these z scores would you prefer: minus2.00, minus1.00, 0, 1.00, 2.00? why? a. the z score of 2.00 is most preferable because it is 2.00 standard deviations above the mean and would correspond to the highest of the five different possible test scores. b. the z score of 0 is most preferable because it corresponds to a test score equal to the mean. c. the z score of minus2.00 is most preferable because it is 2.00 standard deviations below the mean and would correspond to the highest of the five different possible test scores. d. the z score of minus1.00 is most preferable because it is 1.00 standard deviation below the mean and would correspond to an above average