Simon and pedro are working together on a science experiment. they collect and record their data in excel spreadsheets. they save their data as a web page and post it on their shared internet site. simon’s data is not updating. he followed the steps below when saving his excel spreadsheet. step 1: on the file menu, click save as step 2: select “web page” from the “save as type” box step 3: select publish step 4: select the “open published web page in browser” check box step 5: click publish which step was incorrect? step 1: simon should have selected print and printed the spreadsheet as an htm file. step 2: simon should have selected “excelworkbook” from the “save as type” box. step 3: simon should have selected save instead of publish. step 4: simon should have selected autorepublish.

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.