Online HW 2: Measures of Variability Page 1 Question 1 (1 point) 1 2 3 ol Calculate the range for the following data set: 4 5 4 Number | Data el e e 1 19 2 18 ! 8 3 25 T 4 31 5 27 Quiz Information Your Answer: Answer Question 2 (1 point) Download the data in the following hyperlink: click here to download. Use Excel's =max(} and =min(} call to calculate the range of the 2,000 incomes given in the data set. Your Answer: e Answer Question 3 (1 point) Find the population standard deviation for the data set given in the table below. Round your answer to 2 decimal places. Difference | Diff Squared -5 25 -& 34 1 1 7 49 3 9 Your Answer: L] Answer Question 4 (1 point) Find the sample standard deviation for the data set given in the table below. Round your answer to 2 decimal places. Number | Data | Mean | Difference | Diff Squared -34 11.56 0.6 0.36 -24 5.76 6.6 43.56 -34 11.56 0.6 0.36 -0.4 0.16 1.6 2.56 -24 5.76 26 676 Your Answer: Answer Question 5 (1 point) Download the data in the following hyperlink: click here to download. Use Excel's stdev.s() call to calculate the sample standard deviation of the 2000 incomes given in the data set. Round your answer to 2 decimal places. Your Answer: L] Answer Question 6 (1 point) The following times were recorded by the 400 metre and 1600 metre runners of a college track team (times are in minutes): 1600 metre 4,52 4.35 4.4 47 4.5 Which race has more consistent times? Calculate the coefficient of variation for each race and return the coefficient of variation for the race with the more consistent times. Round your answer to 2 decimal places and in percentage but do not enter the "%" sign. Mote: The 400 metre mean and standard deviation are 0.946 and 0.05463%. The 1600 metre mean and standard deviation are 4.534 and 0.12954. Your Answer: L] Answer Question 7 (1 point) The spending scores were recorded for mall shoppers. They were aggregated by gender. The results are given in the table below: D] Gender | Count | Mean [ 5tDev | Cv 34 [49.06 | 26.28 | 53.57% 62 2 Cisgender 51.74% 3 Female 1930 55.06% 4 | Gender neutral 54 53.69% 5 Genderfluid 79 56.24% 4 Male 54.29% 7 MNonbinary 48.49 | 29.07 | 59.95% 80 8 Pangender 57 | 51.63 | 27.32 | 52.91% 9 Transgender 113 | 5047 | 28.33 | 56.13% - Grand Total 4000 | 50.96 | 27.93 | 54.81% If we want to target the gender that has the highest average spending and the lowest variability, which gender would that be? What is the 'ID" number for that gender from the first column in the table above? Input the number value for the |D value below. Your Answer: Question 8 (12 points) A realtor is looking at the list prices of detached houses in two neighbourhoods: Clayton and Dunbar-Southlands. The statistics on list prices of detached homes for sale on Jan 6, 2022 are: Clayton Dunbar-Southlands Smallest (Min) $975,000 $2,400,000 Largest (Max) $21,200,000 $10,250,000 Mean $3,350,000 $4,695,000 Median $1,975,000 $4,325,000 Standard Deviation $3,4992,750 $1,643,250 Number of Houses (a) Calculate the range in the list prices for Clayton neighborhood. [1 marks] (b) Calculate the range in the list prices for Dunbar-Southlands neighborhood. [1 mark] (c) Why is the mean list price in Clayton higher than its median? [2 marks] A. There are one or more outliers on the high side of the list prices B. There are one or more outliers on the low side of the list prices C. The standard deviation in the list prices is so large D. There was a significant increase in the mean list price this year compared to last year Enter either A, B, C or D. (d) Which is the better measure to represent the list price of houses for sale in the Clayton neighbourhood? [2 marks] A, Mean B. Median Enter either A or B (e) Calculate the coefficient of variation for Clayton neighbourhood (in percentage and round to 2 decimal places). [2 marks] (f) Calculate the coefficient of variation for Dunbar-Southland neighbourhood (in percentage and round to 2 decimal places). [2 marks] (g) Which neighbourhood has more variation in list prices? [2 marks] A. Clayton B. Dunbar-Southlands Enter either A or B