Dr Teacher,

Could you please help me resolve this case study and compare your explanation and results with mine?

Thank you so much for your help!

Appendix 1 (22 marks) Offering an incentive for early m Highlight and delete the question text below before submission, but retain the questions labels, e.g. {a}, {b} Include full details of your working out in this appendix. Bookings for The Treetop Retreat are made anywhere from a couple of days to several weeks in advance. To reduce the uncertainty, George and Jane are considering offering an incentive (for example, a lower nightly tariff or a complimentary breakfast) to guests who book well in advance of their stay. George and Jane want you to analyse the impact on the number of days in advance that bookings are made if an incentive is offered. You have been able to obtain two sets of data from a similar accommodation venture that introduced an incentive scheme. The first set of data describes the number of days in advance that bookings were made before the introduction of the incentive scheme. The second set of data describes bookings information after the introduction of the incentive scheme. The data is stored in an EXCEL sheet called 'Appendix l'within the le TheTreetopRetreat.xisx. (a) (6 marks) Make a histogram and obtain Descriptive Statistics, including Quartile 1 and Quartile 3, for variables Without incentive and Mth incentive. Include histograms and Descriptive Statistics in this Appendix. Do not include printout of the data! EXCEL Instructions: Add your network ID to the column names (% With incentive bioggsjl). Refer to Activity 5C for instructions on how to obtain and format a histogram. Use bins provided in the data le. Make sure that the title of each histogram ends with your network ID (g Advance days without eari y booking incentive bioggsjl). Refer to Activity GB for instructions on how to obtain Descriptive Statistics and the two quartiies. Use QUARTILE.EXC function to obtain the quartiles. (b) (6 marks) Describe the shape (symmetry, modaiity and outiiers) of each distribution. Instructions for identifying outliers: Whether an observation is an outlier is a matter ofjudgement. One rule commonly used for identifying outliers is the so-called 1.5 x IQR rule. An observation is suspected to be an outlier if it is more than 1.5 x IQR below the first quartile C11 or above the third quartile C13. Apply this rule to both Mthincentive and Without incentive variables. (c) (4 marks) Consider the side-by-side boxplot shown below in Figure 1. What does it tell you about the distributions of advance days? Comment briey on the shape (symmetry and outiiers) and spread of the two distributions. Does the boxplot confirm your conclusions from part (b)? Distribution of advance days with and without booking incentive 300 250 200 00 Number of advance days 150 100 50 0 Without incentive With incentive Figure 1. Side-by-side boxplot showing the distribution of advance days (d) (6 marks) Nominate appropriate summary measures of centrality and dispersion for the two distributions. Give reason(s) for your choice. For each distribution, give and interpret the values of the summary measures you have chosen