Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Determine the average prices of holidays and average stay duration for entries where the Travel Method is Plane and the Station begins with the letter

Determine the average prices of holidays and average stay duration for entries where the Travel Method is Plane and the Station begins with the letter A. For this exercise, please use pivot tables.
State Station No of Days Travel Method Price Holiday ID
Andhra Pradesh Vijaywada 32 Plane 7,500 I990AUS
Andhra Pradesh Vishakhapatnam 28 Plane 9,850 AUS112J
Madhya Pradesh Indore 21 Plane 12,590 CH266H
Kerala Malappuram 3 Train 6,900 I456UK
Kerala Palakkad 1 Coach 1,200 BG726H
Uttar Pradesh Lucknow 14 Plane 3,990 A7995FR
Uttar Pradesh Meerut 5 Train 2,690 TH789FR
Uttar Pradesh Meerut 3 Train 1,250 TH788FR
Uttar Pradesh Pilibhit 7 Plane 2,890 I7897FR
Uttar Pradesh Unnao 7 Train 2,560 SG7637L
Uttar Pradesh Agra 7 Plane 2,870 FR5625J
Gujarat Mehsana 4 Coach 6,900 A111G
Gujarat Jamnagar 7 Coach 2,890 BR6736G
Punjab Amritsar 21 Plane 9,750 PG7836G
Haryana Ambala 14 Plane 9,950 KSA8987
Maharashtra Mumbai 4 Train 2,190 I6675SP
Maharashtra Nanded 6 Plane 1,980 TH990ESP
Maharashtra Aurangabad 16 Plane 2,340 A776ESP
Maharashtra Nagpur 14 Plane 2,880 NM9876Y
Maharashtra Nagpur 10 Plane 1,990 TH8956SP
Maharashtra Mumbai 8 Plane 1,770 AJ9836L
Maharashtra Mumbai 7 Coach 1,990 GG9836P
Maharashtra Aurangabad 14 Plane 3,010 PL8726P
Maharashtra Mumbai 4 Train 2,190 I6675SP
Maharashtra Nagpur 14 Train 2,990 SV767HH
Maharashtra Pune 8 Plane 2,770 WE6735L
Maharashtra Kolhapur 10 Plane 3,450 GR7878G
Tamil Nadu Madurai 14 Plane 8,850 TT67624G

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Economics Of Money Banking And Finance

Authors: Keith Bain, Peter Howells

1st Edition

0582278007, 9780582278004

More Books

Students also viewed these Finance questions

Question

Compare levels of resolution in conflict outcomes?

Answered: 1 week ago

Question

Strategies for Managing Conflict Conflict Outcomes?

Answered: 1 week ago