Q3 (d) identify the most appropriate set of statistics to use to summarise.the variable of interest .provide an excel output for the corresponding statistics.briefly justify your answer.

2. The Dow Jones Travel Index reported what business travelers pay for hotel rooms per night in major US cities. The hotel room rates of the 20 randomly selected cities are recorded. 185 195 190 150 145 175 165 195 180 225 145 190 265 165 160 155 190 185 165 225 a) Identify the subjects of interest. [1 mark] b) Calculate the mean hotel room rate manually. Please show all work. [2 marks] c) Provide a description of the answer in part (b). 12 marks] d) Find the median hotel room rate manually. Please show all work. [2 marks] e) Use the method in our notes to find the first quartile and the third quartile. Then find the interquartile range. [1+1+1 marks] f) Determine if there is/are any outlier(s), using IQR. [3 marks] 3. A first-year Langara student wanted to know the weekly expenses of typical Langara students. To investigate this, she got a random sample of 20 students this term. The data set "S1123_HW2_Q3_Data.xIsx" is available on BrightSpace. a) Use Excel to produce a Summary Statistics table that contains Mean, Median, Standard Deviation, Minimum, Maximum, First Quartile, and Third Quartile. [2 marks] Note: Leave all values in one decimal place. b) Use Excel to produce the most appropriate graph. Provide a description of it. [2+2 marks] Note: Make sure you label your graph and axes appropriately. c) Determine if there are outliers in the data set. Make sure you show all calculations. [2 marks] Note. You