Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A B C D E F G 1 Date Geography_Code Type Month Price per Gallon (in cents) Quarter Description 1/10/2021 US All US 292.9 1

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
A B C D E F G 1 Date Geography_Code Type Month Price per Gallon (in cents) Quarter Description 1/10/2021 US All US 292.9 1 Quarter1 : January 1-March 31 AWN 1/17/2021 US All US 294.4 1 Quarter1: January 1-March 31 1/24/2021 US All US 297.6 1 Quarter1 : January 1-March 31 1/31/2021 US All US 299.5 1 Quarter1: January 1-March 31 2/7/2021 US All US ONN- 307.1 1 Quarter1: January 1-March 31 2/14/2021 US All US 320.7 1 Quarter1 : January 1-March 31 2/21/2021 US All US 332.8 1 Quarter1: January 1-March 31 9 2/28/2021 US All US 336.4 1 Quarter1: January 1-March 31 10 3/6/2021 US All US 343.3 1 Quarter1: January 1-March 31 11 3/13/2021 US All US 349.4 1 Quarter1 : January 1-March 31 12 3/20/2021 US All US AAAWWWWNN 354.5 1 Quarter1: January 1-March 31 13 3/27/2021 US All US 351.3 1 Quarter1 : January 1-March 31 14 4/3/2021 US All US 347.0 2 Quarter2:April 1-June 30 15 4/10/2021 US All US 343.7 2 Quarter2: April 1-June 30 16 4/17/2021 US All US 338.1 2 Quarter2:April 1-June 30 17 4/24/2021 US All US 332.5 2 Quarter2:April 1-June 30 18 5/1/2021 US All US 329.4 2 Quarter2:April 1-June 30 19 5/8/2021 US All US 321.5 2 Quarter2:April 1-June 30 20 5/15/2021 US All US 314.4 2 Quarter2:April 1-June 30 21 5/22/2021 US All US 311.6 2 Quarter2:April 1-June 30 22 5/29/2021 US All US 307.2 2 Quarter2: April 1-June 30 23 6/5/2021 US All US 303.4 2 Quarter2: April 1-June 30 24 6/12/2021 US All US 302.5 2 Quarter2:April 1-June 30 25 6/19/2021 US All US 309.4 2 Quarter2: April 1-June 30 26 6/26/2021 US All US 308.3 2 Quarter2:April 1-June 30 27 7/3/2021 US All US 306.3 3 Quarter3: July 1-September 30 28 7/10/2021 US All US 305.6 3 Quarter3: July 1-September 30 29 7/17/2021 US All US 308.2 3 Quarter3: July 1-September 30 30 7/24/2021 US All US 307.2 3 Quarter3: July 1-September 30 31 7/31/2021 US All US 305.6 3 Quarter3: July 1-September 30 32 8/7/2021 UIS All US 306 3 3 Quarter3 July 1-Sentember 30 Data Geography code | Quarter code Month code | Region | State | City | Bubble Chart (+)A B C C 1 Code Description 2 NE New England Region 3 CE Central Atlantic Region 4 LA Lower Atlantic Region 5 B1 Boston (City) 6 C2 Chicago (City) 7 CA California (State) 8 CL Cleveland (City) 9 CO Colorado (State) 10 D4 Denver (City) 11 FL Florida (State) 12 H3 Houston (City) 13 L5 Los Angeles (City) 14 M1 Miami (City) 15 MA Massachusetts (State) 16 MN Minnesota (State) 17 N1 New York (City) 18 NY New York (State) 19 OH Ohio (State) 20 EC East Coast Region 21 MW Midwest Region 22 GC Gulf Coast Region 23 RM Rocky Mountain Region 24 WC West Coast Region 25 $5 San Francisco (City) 26 SE Seattle (City) 27 TX Texas (State) 28 US U.S. 29 WA Washington (State) 30 31 32 Data Geography codeA B C D E 1 Code Description 2 1 Quarter1: January 1-March 31 3 2 Quarter2:April 1-June 30 4 3 Quarter3: July 1-September 30 4 Quarter4:October 1-December 31 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Data | Geography code Quarter codeA B C D E F G Code Description 1 January 2 February 4 3 March 5 4 April 5 May 6 June 8 7 July 9 8 August 10 9 September 11 10 October 12 11 November 13 12 December 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Data | Geography code | Quarter code Month codeA C D E G H New England Region Central Atlantic Region Lower Atlantic Region East Coast Region Midwest Region Gulf Coast Region West Coast Region U.S. 2 1/10/2021 3 1/17/2021 4 1/24/2021 5 1/31/2021 6 2/7/2021 7 2/14/2021 8 2/21/2021 9 2/28/2021 10 3/6/2021 11 3/13/2021 12 3/20/2021 13 3/27/2021 14 4/3/2021 15 4/10/2021 16 4/17/2021 17 4/24/2021 18 5/1/2021 19 5/8/2021 20 5/15/2021 21 5/22/2021 22 5/29/2021 23 6/5/2021 24 6/12/2021 25 6/19/2021 26 6/26/2021 27 7/3/2021 28 7/10/2021 29 7/17/2021 30 7/24/2021 31 7/31/2021 32 8/7/2021 Data | Geography code | Quarter code | Month code Region State | City Bubble Chart +

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

Recommended Textbook for

The Legal Environment of Business A Critical Thinking Approach

Authors: Nancy K Kubasek, Bartley A Brennan, M Neil Browne

6th Edition

978-0132666688, 132666685, 132664844, 978-0132664844

Students also viewed these Accounting questions