Scribd
Upload
71 views2 pages

Wise Owl Travel Packages Overview

The summary analyzes travel package data from Wise Owl Travel Agents. Pivot Table 1 lists the number of resorts in each country in descending order. Pivot Table 2 lists the average price in each country in descending order, accompanied by a column chart. Table 2 contains functions answering questions about packages in specific countries/time periods/prices using the original data. The most and least expensive packages are highlighted.

Uploaded by

klirt carayo
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
71 views2 pages

Wise Owl Travel Packages Overview

The summary analyzes travel package data from Wise Owl Travel Agents. Pivot Table 1 lists the number of resorts in each country in descending order. Pivot Table 2 lists the average price in each country in descending order, accompanied by a column chart. Table 2 contains functions answering questions about packages in specific countries/time periods/prices using the original data. The most and least expensive packages are highlighted.

Uploaded by

klirt carayo
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Wise Owl Travel Agents

Country Resort Name No of Days Travel Method Price Holiday ID


Australia Great Barrier Reef 32 Plane £134 I990AUS
Australia Perth 28 Plane £985 AUS112J
Chile Santiago 21 Plane £1,259 CH266H
England Bognor 1 Coach £12 BG726H
England London 3 Train £69 I456UK
France Lyon 14 Plane £399 A7995FR
France Nice 7 Plane £289 I7897FR
France Nimes 7 Plane £287 FR5625J
France Paris - Euro Disney 3 Train £125 TH788FR
France Paris - Euro Disney 5 Train £269 TH789FR
France Toulouse 7 Train £256 SG7637L
Germany Berlin 7 Coach £289 BR6736G
Germany Black Forest 4 Coach £69 A111G
Peru Lima 21 Plane £975 PG7836G
Saudi Arabia Riyadh 14 Plane £995 KSA8987
Spain Barcelona 8 Plane £177 AJ9836L
Spain Barcelona 7 Coach £199 GG9836P
Spain Barcelona 4 Train £219 I6675SP
Spain Barcelona 4 Train £219 I6675SP
Spain Granada 10 Plane £345 GR7878G
Spain Madrid 8 Plane £277 WE6735L
Spain Malaga 16 Plane £234 A776ESP
Spain Malaga 14 Plane £301 PL8726P
Spain Nerja 6 Plane £198 TH990ESP
Spain Seville 14 Plane £288 NM9876Y
Spain Seville 14 Train £299 SV767HH
Spain Seville 10 Plane £199 TH8956SP
Trinidad Port of Spain 14 Plane £885 TT67624G

Note: Be consious of the correct data types/formats.

1. Pivot Table 1: Make a pivot table that will list down how many resorts there are in each country. Sort the list in
descending order based on the number of resorts. Place the table at H2.

2. Pivot Table and chart 2: Make a pivot table that lists down the average amount that tourists/vacationers would spend
in each country. Sort the list in descending order (based on the price). Place the table below Pivot Table 1. Place the chart
beside Pivot Table2.

3. Complete the table below (use functions in excel to get the required values):
Refer to the original table on the functions in Table 2.

Table 2
How many packages are there in
Spain and France?
How many packages does the
agency have where the
vactioners will not be spending
more than a week in their
vacation?

Some vactaioners are asking for


tours with less than £200 for
their spending spree. How many
tours are there with this spec?

How many packages do not use


coach for travelling?

4. Highlight (refer to column Price in the original table) the first 3 most expensive packages with light blue shade (or fill)
and the least 3 inexpensive packages with orange shade/fill .

You might also like