Question: Please help in below R programming. Quarter Region State Purpose Trips 1998-01-01 Adelaide South Australia Business 135.07769 1998-04-01 Adelaide South Australia Business 109.987316 1998-07-01 Adelaide

Please help in below R programming.

Quarter Region State Purpose Trips
1998-01-01 Adelaide South Australia Business 135.07769
1998-04-01 Adelaide South Australia Business 109.987316
1998-07-01 Adelaide South Australia Business 166.034687
1998-10-01 Adelaide South Australia Business 127.160464
1999-01-01 Adelaide South Australia Business 137.448533
1999-04-01 Adelaide South Australia Business 199.912586
1999-07-01 Adelaide South Australia Business 169.35509
1999-10-01 Adelaide South Australia Business 134.357937
2000-01-01 Adelaide South Australia Business 154.034398
2000-04-01 Adelaide South Australia Business 168.776364
2000-07-01 Adelaide South Australia Business 223.065116
2000-10-01 Adelaide South Australia Business 241.220689
2001-01-01 Adelaide South Australia Business 132.500038
2001-04-01 Adelaide South Australia Business 178.398095
2001-07-01 Adelaide South Australia Business 195.996326
2001-10-01 Adelaide South Australia Business 101.174693
2002-01-01 Adelaide South Australia Business 237.832791
2002-04-01 Adelaide South Australia Business 150.726633
2002-07-01 Adelaide South Australia Business 167.712842
2002-10-01 Adelaide South Australia Business 140.339513

Save the above data in an excel and Read it into R using readxl::read_excel()

1. Create a tsibble which is identical to the tourism tsibble from the tsibble package.What would be good keys to include? Should we include Region, State or Region State and Purpose?

2. Find what combination of Region and Purpose had the maximum number of overnight trips on average.

3. What are the top 2 purposes and regions with the most trips and what year based on the table above?

4. Create a new tsibble named purpose which groups trips by Purpose, and find total trips.

5. Create autoplot for purpose subseries.

6. Which type of purpose has more trips, What else do you notice interesting from the plot?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!