Question: s need to include all required steps and answer(s) for full credit. All answers need to be reduced to lowest terms where possible. If the
s need to include all required steps and answer(s) for full credit. All answers need to be reduced to lowest terms where possible. If the answer is in %, show two decimal places. Answer the following problems showing your work and explaining (or analyzing) your results. Find the mean, median, mode. (2 pts) Which measure of central tendency best represent the data? Why? (2 pts) Are there any outliers? If so, name the outlier. (2 pts)
Measures of Central Tendency Suppose data are in cells A1 to A10 Mean =AVERAGE(A1:A10) Median =MEDIAN(A1:A10) Mode =MODE(A1:A10) Measures of Variability Suppose data are in cells A1 to A10 Range =MAX(A1:A10)-MIN(A1:A10) IQR =QUARTILE.EXC(Array,3)-QUARTILE.EXC(Array, 1) Population Variance o2 =VAR.P(A1:A10) Sample Variance s2 =VAR(A1:A10) or VAR.S(A1:A10) Population Standard Deviation o =STDEV.P(A1:A10) Sample Standard Deviation s =STDEV(A1:A10) or STDEV.S(A1:A10) 1. Joe and Mary would like to buy their first home in a new city. Below is the list of prices of 20 homes for sale. Prices in 140 190 265 115 270 240 250 180 160 201 U.S. Dollars 240 280 175 200 310 195 320 105 385 264 a. Find the mean, median, mode. (2 pts) b. Which measure of central tendency best represent the data? Why? (2 pts) c. Are there any outliers? If so, name the outlier. (2 pts)Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
