Due to their cause and effect on the insights drawn from data, outliers should a$.$ be replaced with incorrect data b$.$ never be removed c$.$ immediately be removed for accurate analysis d$.$ only be removed after careful considerationWhich of the following is a form of Simpson's paradox, where a sample is chosen that does not represent the population a$.$ Selection bias b$.$ Missing data c$.$ Data error d$.$ Survivor biasb. By removing any data errors c$.$ By estimating the value of missing data cells d$.$ By counting the number of blank cells in a columno help limit data errors from manual entries in Excel, what tool can be used to control what a user can enter into a cell? a$.$ Data Validation tool b$.$ Conditional Formatting tool c$.$ COUNTBLANK formula d$.$ None of these choicesWhich of the following is the best value to use when creating choropleth maps? a$.$ A value that is categorical b$.$ Values relative to the entire population of the data c$.$ Values relative to the population of the region d$.$ None of these choices