FREE Trial
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 with AI-Powered 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

Students also viewed these Finance questions

Question

Describe current views of long-term memory, particularly the contents and types of long-term memory, individual differences, and the processes of retrieving information from long-term memory.

Answered: 1 week ago

Question

★★★★★
Hatch Manufacturing produces multiple machine parts. The theoretical cycle time for one of its products is 65 minutes per unit. The budgeted conversion costs for the manufacturing cell dedicated to...

Answered: 1 week ago

Question

★★★★★
anyone to help me solve this please (50 min) L01,2 9A-2. The following transactions of Jeff's Auto Supply occurred in February (Balances as of February 1 are given for general ledger and accounts...

Answered: 1 week ago

Question

★★★★★
You are the VP of Marketing for a mid-sized financial planning company specializing in full-service financial planning for high net-worth clients. Which forms of advertising do you believe would be...

Answered: 1 week ago

Question

★★★★★
As shown in Fig. 4.60, a horizontal beam is hinged to the wall at point A. The length of the beam is 1 = 2 m and it weighs W = 150 N. Point C is the center of gravity of the beam and it is...

Answered: 1 week ago

Question

★★★★★
GL0202 (Algo) - Based on Exercise 2-13 Prepare journal entries for each transaction and identify the financial statement impact of each entry. The financial statements are automatically generated...

Answered: 1 week ago

Question

★★★★★
Create a function bookend_list that consumes a list of integers as a parameter and returns the first and last elements as a new list. If the original list is empty, return an empty list instead. Unit...

Answered: 1 week ago

Question

★★★★★
RST, Inc. 2018 Statement of comprehensive income Net sales Cost of goods sold Depreciation Earnings before interest and taxes Interest paid Taxable income Taxes Net income Dividends paid Addition to...

Answered: 1 week ago

Question

★★★★★
The equity section of Benton Corporation's statement of financial position as of December 31, 2018 is as follows: Equity Share capital-ordinary 5 par value; authorized, 2,000,000 shares; issued,...

Answered: 1 week ago

Previous Question Next Question