Co working space provides an atmosphere and environment that allows for collaboration with members able to expand their business networks and find new job opportunities These organic conversations also enhance creativity and spark ideas to increase the productivity of an individual With the award winning architectural design and competitive membership packages, you are confident that Cluster will be the market leader of coworking space in Australia As a point of market differentiation, you would like to include extra amenities at Cluster Adelaide Taking inspiration from the legendary Google Offices around the world, you conducted a survey targeting office workers in CBDs in major cities around the country As part of the survey, you asked these participants to request one extra office inclusion (amenities) that would increase productivity at their workplace The data in Table 2 are the summary of results from the survey you conducted At first glance, all amenities appear popular and you are unsure if they should all be introduced across at Cluster Adelaide You will find Table 2 helpful to answer the following questions Amenities Location SYD MEL ADL BNE Total Wellness Room 13 41 28 18 100 Standing Desk 36 36 32 29 133 Curated Beverage 25 17 22 26 90 Games Room 45 26 25 25 121 Total 119 120 107 98 444 Table 2 Most requested amenities at coworking space (a) (b) (2 marks) Use EXCEL to obtain a 100 stacked column chart for the data from Table 2, with Amenities labels shown on the horizontal axis EXCEL INSTRUCTIONS How do produce a 100 stacked column chart 1 Highlight the table in Excel Insert 100 Stacked Column Chart Design Switch Row Column as below J Ensure all probabilities include both the calculation and the appropriate probability statement Present your answer to 4 significant digits You do not need to write a sentence summarising the results (c) (3 marks) What proportion of participants work from ADL or request a Wellness Room Now calculate the probability of participants requesting a Wellness Room and work from ADL (d) (5 marks) Is the preference for Standing Desk statistically independent across Location Quote and or calculate all relevant probabilities For all calculations include both the calculation and the appropriate probability statement You do not need to write sentence summarising the results Present your answer to 4 significant digits

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 21, 2024

Co-working space provides an atmosphere and environment that allows for collaboration with members able to expand their business networks and find new job opportunities.These organic

Co-working space provides an atmosphere and environment that allows for collaboration with members able to expand their business networks and find new job opportunities.These organic conversations also enhance creativity and spark ideas to increase the productivity of an individual. With the award-winning architectural design and competitive membership packages, you are confident that Cluster will be the market leader of coworking space in Australia. As a point of market differentiation, you would like to include extra amenities at Cluster Adelaide.

Taking inspiration from the legendary Google Offices around the world, you conducted a survey targeting office workers in CBDs in major cities around the country.As part of the survey, you asked these participants to request one extra office inclusion (amenities) that would increase productivity at their workplace.

The data in Table 2 are the summary of results from the survey you conducted. At first glance, all amenities appear popular and you are unsure if they should all be introduced across at Cluster Adelaide.You will find Table 2 helpful to answer the following questions.

Amenities

Location

SYD

MEL

ADL

BNE

Total

Wellness Room

100

Standing Desk

133

Curated Beverage

Games Room

121

Total

119

120

107

444

Table 2: Most requested amenities at coworking space

(a)

(b)(2 marks) Use EXCEL to obtain a 100% stacked column chart for the data from Table 2, with Amenities labels shown on the horizontal axis.

EXCEL INSTRUCTIONS: How do produce a 100% stacked column chart?

1.Highlight the table in Excel > Insert > 100% Stacked Column > Chart Design > Switch Row/Column as below J

Ensure all probabilities include both the calculation and the appropriate probability statement.Present your answer to 4 significant digits.You do not need to write a sentence summarising the results.

(c)(3 marks) What proportion of participants work from ADL or request a Wellness Room?Now calculate the probability of participants requesting a Wellness Room and work from ADL.

(d)(5 marks) Is the preference for Standing Desk statistically independent across Location?Quote and/or calculate all relevant probabilities.

For all calculations include both the calculation and the appropriate probability statement. You do not need to write sentence summarising the results.Present your answer to 4 significant digits.