Calibri 11 AA =E de Wrap Text General Insert B I UV 295 2 2 Merge & Center v $ % 9 Conditional Format as Cell Delete Formatting Table Styles v Format board Font Alignment Number Styles Cells X V fx Q2 A B D E F G H K The context marks You are the newly appointed general manager for Four Seasons hotel in Sydney. pic: To maintain a competitive edge over the other hotel chains, hotels are doing their best to entice and satisfy customers post COVID-19 lockdown. ek 4 One area where you can do this is here: what you put in your hotel mini-bar (fridge). Can you read your customers minds and impress them? A recent survey of 2,000 random hotel guests by the AHA, the Australian Hotels Association (aha.org.au), reveals some interesting statistics. It focuses on the type of drinks customers picked from their mini-bars in Australian hotels as they returned to hotels after COVID-19 restrictions were removed in 2021-2022. Data was collected and published for a set of commonly stocked mini-bar drinks. The paragraph from the report: "We randomly sampled 2,000 hotel guests across different hotel chains that are members of the AHA post-COVID-19 lockdown. We observed the following: Domestic guests (Australians) consumed 100 units of Australian fruit juices and cordials, 300 units of soft drinks, 200 units of chilled coffees, and 50 units of mineral water. International guests from Asia consumed 200 units of Australian fruit juices and cordials, 250 units of soft drinks, 100 units of chilled coffees, and 150 units of mineral water. Other international guests from elsewhere consumed 150 units of Australian fruit juices and cordials, 200 units of soft drinks, 200 units of chilled coffees, and 100 units of mineral water Does drink choice depend on or is related to type of guest? Yes, not really? Are consumptions patterns similar between types of guests, or different? Could you cleverly exploit this in Solve this puzzle and report to your company. Fill out the yellow boxes. Follow the instructions in the 'task and marks box' at the bottom. Null hypothesis (Ho): There is [choose: no relationship/a relationship] between... write out the sentence fully Alternative hypothesis (Ha): There is [choose: no relationship/a relationship] between... write out the sentence fully The data: Observed values, O montin International International Introduction Q1 - Chart + interpretation Q2 - Chi-squared test Q3 - Hypothesis testing II + 15 . C OL O W Clearlipboard Font Alignment Number IN Styles 16 X V A P C D E F G H Domestic International International Flavour types/age group (Australian) Asia) (elsewhere) Australian fruit juices and cordials 100 200 150 Soft drinks 300 250 200 Chilled coffees 200 100 200 Mineral water 50 150 100 Expected values, E --> Using the O values above to get column and row totals. Then enter the E values here: Domestic International International (Australian) (Asia (elsewhere) Row totals Australian fruit juices and cordials 100 200 150 450 Soft drinks 300 250 200 750 Chilled coffees 200 100 200 500 Mineral water 50 150 100 300 Column totals 650 700 650 2000 Use the O and E values to fill these out: Domestic International International (Australian) (Asia) (elsewhere) Australian fruit juices and cordials Soft drinks Chilled coffees Mineral water Introduction Q1 - Chart + interpretation Q2 - Chi-squared test Q3 - Hypothesis testing II + dy 15. C O W ClearAutoSave Off STA101A - Individual report - Excel data - May 2022 (1)[232] - Read-Only - Excel AspectsPlus@outlook.com A le Home Insert Page Layout Formulas Data Review View Help Share Calibri - 11 ~ A A E 207 29 Wrap Text General Insert " E - AP O Delete ~ to BIU - A- E Merge & Center v $ ~ % 9 108 20 Conditional Format as Cell Sort & Find & Analy Formatting Table Styles Format Filter . Select Dat board Font Alignment Number Styles Cells Editing Anal X V A B D H K M N Total chi-squared value (total X?): Critical chi-squared value (crit. X'): -- for the critical value, use =CHIINV(0.05, df). What number should be used for df? Will you choose Ho or Ha? Based on what rule? - Decide, by assessing the total chi-squared value against the critical chi-squared value Now, restate what your chosen hypothesis says (findings): If you found that there is a relationship (if not, say 'not applicable'), then compare the O and E values and describe what type of relationship you see: Based on your findings, what advice would you give this business? Task and marks box [10 marks] 1. State the hypotheses correctly (2 marks). 2. Include a screenshot of your three completed chi-squared tables above (O, E and X ) in your report's Word document (3 marks). 3. State how you used the total and critical chi-squared values to choose between the two hypotheses. State your chosen hypothesis (your findings). Next: compare the O and E values. Do you observe any patterns? If yes, what are they? If you see no patterns, say there is none (3 marks). 4. Based on your findings above (if any), recommend strategies for your company to make it more successful (2 marks), Q1 - Chart + interpretation Q2 - Chi-squared test Q3 - Hypothesis testing Il + Introduction ENG OLD -2 W US 5 .C Clear