Q1. [4 marks] A first-year Langara student wanted to know the weekly expenses of typical Langara students. To investigate this, she did a quick survey in her Marketing class of 27 students this term (Spring 2024). The average amount Langara students spend was found to be $25.49 per week. a) Provide a description of the objective. [1] b) Describe the sample. [1] c) Identify the variable of interest, the type of variable and the scale of measurement. [1+0.5+0.5] Q2. [4 marks] In each of the following objective, (i) (ii) (iii) provide a description of the variable that would fulfill the objective. identify the possible responses (or some of them). determine if the variable of interest is a categorical variable or a numerical variable. a) Objective: A researcher wants to find out what percentage of SFU students are taking public transit to school in Summer 2022. [1+0.5+0.5] b) Objective: A researcher wants to find out what percentage of SFU students' income (or allowance) is allocated to tuition and textbooks expenses in Summer 2022. [1+0.5+0.5] Q3. [10 marks] The Dow Jones Travel Index reported what business travelers pay for hotel rooms per night in major U.S. cities. The average hotel room rates for 20 cities are recorded. 192 163 125 177 167 166 126 123 120 144 172 162 245 146 139 134 168 160 145 207 a) Calculate the mean hotel room rate manually, show all your steps. [1] b) Find the median hotel room rate manually, show all your steps. [1] c) Find the first quartile, third quartile and the interquartile range manually, show all your steps. [1+1+1] d) Calculate the standard deviation in Excel. Report its value. [1] e) Which measure of the spread (interquartile range or standard deviation) is better to be used here? Briefly justify your answer. 0 mark if no justification. [2] Hint: Use Excel to make a graph to support your answer. f) Draw a stem plot for this variable. Do NOT use Excel. [2] Q4. [9 marks] Use the variable Dodgers in the data set "MLBSalary.xlsx" (available on BrightSpace) and answer the following questions. a) Use Excel to produce a histogram. Use 5000, 10000, 15000, and 20000 as the upper class limits. Label the x-axis with "Salary ($)" and the chart title with "Histogram of Dodgers Salary". Attach a screenshot of the histogram. (Don't know how to set the upper class limits? Check out the Excel Manual available on BrightSpace.) [2.5] b) Use Excel to produce a box-and-whisker plot. Label the x-axis with "Salary ($)" and the chart title with "Boxplot of Dodgers Salary". Attach a screenshot of the boxplot. [1.5] c) Use Excel to calculate the mean, median, first quartile, third quartile, and standard deviation. Report their values. [1.5] d) Write out the five-number summary. [1.5] e) Determine if there is any outlier in the data. Make sure show all your calculation steps. [2]