Calculate and do excel, the question 2 part (a) (8 marks) Based upon groupings of 1 minute intervals, with zero being the lowest interval cutoff, use EXCEL to obtain a correctly prepared histogram for each central office location. pls A survey was conducted recently at a local large shopping centre. A sample, of 500 respondents, was selected to determine information concerning consumer behaviour. From that data the following contingency table was prepared: Gender Male Female Total Enjoys shopping for clothing Yes 140 220 360 No 100 40 140 Total 240 260 500 (i) Knowing that the survey consisted of a combination of multiple choice and open ended questions, explain (a) (4 marks) The advantages of using such questions in a survey (b) (4 marks) The disadvantages of using such questions (c) (4 marks) What would need to be done with the questions to make certain that the results of the survey are meaningful (ii) Assume a respondent is chosen at random. (a) (8 marks) What is the probability that the respondent: (i) is male; (ii) does not enjoy shopping for clothing; (iii) is male and does not enjoy shopping for clothing; (iv) is female or enjoys shopping for clothing. (b) (4 marks) Assume the respondent chosen enjoys shopping for clothing. What, then, is the probability that the individual is a male? (c) (4 marks) Are enjoying shopping for clothing and gender of the individual statistically independent? Explain your answer carefully. Note: In order to achieve full marks for this question it is essential that you fully explain what you are doing, why you are doing it and the steps involved in providing a final solution. Ensure your answer is not just a set of calculations. Question 2 (Total of 40 marks) Problems with the internet have prevented client service personnel from receiving or sending emails. These problems can be of two types: those that are located inside the office and those located on lines between the office and the Internet Service Provider. The following data represent samples of the problems reported by two different offices of the company and the time taken to clear those problems (in minutes). Northern Office Time to resolve problems (minutes) 2.52 0.78 0.93 1.02 1.48 1.60 1.75 2.97 3.93 5.45 3.20 2.34 0.53 0.80 0.97 1.05 1.48 1.60 2.85 3.10 4.15 6.32 Southern Office Time to resolve problems (minutes) 0.08 0.52 0.60 0.65 1.10 1.53 1.92 3.30 3.75 2.23 4.15 1.27 0.10 0.58 0.60 0.72 1.48 1.65 2.10 3.75 4.02 7.55 (a) (8 marks) Based upon groupings of 1 minute intervals, with zero being the lowest interval cutoff, use EXCEL to obtain a correctly prepared histogram for each central office location. (b) (16 marks) Adhering to the general instructions for the assignment calculate the following: Mean, Median, Mode, Standard Deviation, Range, Quartile 1, Quartile 3 and Inter-Quartile Range for each central office location. (c) (6 marks) Based on the histograms in (a), briefly describe the shape (symmetry, modality and outliers) of the data for each central office location. (d) (6 marks) Which measures of location and dispersion should you use to describe the data for each central office location? What are their values? Give a brief explanation for your choice. (e) (4 marks) On the basis of your results of (a)-(d), are there any differences between the two data sets for the offices? Justify your answer carefully. Note: In order to achieve full marks for this question it is essential that you fully explain what you are doing, why you are doing it and the steps involved in providing a final solution. Ensure your answer is not just a set of calculations. Question 3 (Total of 32 marks) During an orientation event at a large university, incoming students are advised about the weekly cost of living during the typical study period. A sample of 100 students currently enrolled at this university indicates a sample mean cost of $314.50. A population standard deviation is known to be $42.30. (a) (6 marks) Construct a 95% confidence interval for the true population mean cost of textbooks. (b) (5 marks) What is the probability of a student being able to contain their living costs to $290.00 per week? (c) (4 marks) Draw a Normal Distribution curve indicating all of the areas of interest in part (b) of this question. (d) (4 marks) Does the population cost of textbooks have to be normally distributed in this situation? Explain. (e) (9 marks) Suppose that the campus newspaper previously claimed that the average cost of living was $300 per week per study period. If the campus newspaper's claim were still true, what would be the probability, in a sample of 100 students, of a mean cost of living above $310? (f) (4 marks) Draw a Normal Distribution curve indicating all of the areas of interest in part (e) of this question. Note: In order to achieve full marks for this question it is essential that you fully explain what you are doing, why you are doing it and the steps involved in providing a final solution. Ensure your answer is not just a set of calculations. do excel and histogram. last time i had order 1 QMB but u did not do the excel.