please answer all questions or leave it for someone else

Which numerical value would the function =COUNTBLANK(A2:A8) return in this abstract data set in Excel? A B C 1 X Y 2 1 1 3 3 4 2 5 6 4 5 5 6 7 8 9 10 O a. 1 b. 0 O c. 6 O d. 7 23 2 3 345 7 In most cases, when creating choropleth maps, it is best to use a value O a. relative to the entire population of the data O b. that is categorical O c. relative to the population of the region d. None of these choices Why is this graph showing the results of a survey to determine customers' favorite products misleading? Percentage of Customers Who Prefer Product 8% 15% 60% Product B Product A O a. The slices are the wrong color. O b. None of these choices Oc. The percentages do not add up to 100. Od. The slices are not the correct size. 15% Product C Product D Simpson's paradox occurs when a specific trend that appears in subsets of data aggregated. O a. is strengthened O b. has no effect O c. disappears or reverses Od. None of these choices when the subsets are The following graph makes it look as if Region A had double the sales that Region B had. Is this a valid conclusion Number of Sales by Region Region E Region D Region C Region B Region A 400 420 440 460 480 500 520 540 560 O a. Yes, because Region A had about twice as many sales as Region B O b. No, because the sales are recorded at two different times in history O c. No, because the x-axis doesn't start at 0, the scale is misleading Od. Yes, because the bar for Region A is twice the length of the bar for Region B