Task 4

Tourists seeking a luxury tour on the ‘Palace on rail’ in India can opt for either the ‘Luxury service’ or the ‘Maharajah service’. The manager of the ‘Palace on rail’ has produced the following table to show the bookings she received last season:

The data is also provided in the “MBF Summative data.xlsx” file under the “Task 4 – Data” tab.

Required;

a) Produce a stacked bar chart to show the number of bookings by home country and type of booking.

b) Produce a pie chart to show the number of bookings as a whole by home country. Ensure the data labels on the pie chart are expressed in percentage form to 2 decimal places

c) Interpret your results

Final-MBF-Summative-data-for-students