Complete the following: 1. Open the workbook named Raider.xlsx and save the file as Raider Analysis...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Complete the following: 1. Open the workbook named Raider.xlsx and save the file as Raider Analysis (Last Name).xlsx. 2. Create a series of charts that compare gas prices by time of the year and by location. The time can be in months or week of the month, as you deem appropriate. The location should be charted separately by region, by state, and by city. Each chart should be created on an individual sheet (named Region, State, and City, respectively). Select a chart type that provides ease of visual interpretation. Include readability features such as providing the actual names of locations instead of the codes (use a formula to populate these values in the marked cells in column G of the Data worksheet), answering which area is the highest priced location in your chart, and giving proper axes labels and chart titles. HINT: To do this, create a data series or table that summarizes and displays the gas price data by the location for each individual date. For example: New England Region Central Adantic Region Lower Adantic Region East Coast Region Midwest Region Gulf Coast Region West Coast Region All US 1/10/2020 309.9 325 325.8 326.5 Place the data in the marked cells on each of the three chart sheets. 310.6 301.9 3. For each location-region, state, and city-determine if a particular location has higher gas prices than the others. Selected the correct value from the drop-down list in the marked cell to explain your findings. 4. For each chart, determine if a particular season has higher gas prices than the other times of the year. Add a comment near each chart to explain your findings. 5. On the Bubble Chart sheet, create a bubble chart to illustrate the number of weeks that each city's gas price is above the gas price for the entire United States each week; the number of weeks that it is below the gas price for the entire United States each week; and the average gas price in dollars per gallon for the year. Add appropriate titles, labels, and a legend to the chart. The final chart could look like this: 3395 3254 J13 × ✓ fx A B C D E F G H K L M N O P О R S T U V W 1 Date Geography Type Month Price per (Quarter Description 2 1/10/2021 US All_US 1 292.9 1 3 1/17/2021 US All_US 1 294.4 1 4 1/24/2021 US All_US 1 297.6 1 5 1/31/2021 US All_US 1 299.5 1 6 2/7/2021 US All_US 2 307.1 1 7 2/14/2021 US All_US 2 320.7 1 8 2/21/2021 US All_US 2 332.8 1 9 2/28/2021 US All_US 2 336.4 1 10 3/6/2021 US All_US 3 343.3 1 11 3/13/2021 US All_US 3 349.4 1 12 3/20/2021 US All_US 3 354.5 1 13 3/27/2021 US All_US 3 351.3 1 14 4/3/2021 US All_US 4 347.0 2 15 4/10/2021 US All_US 4 343.7 2 16 4/17/2021 US All_US 4 338.1 2 17 4/24/2021 US All_US 4 332.5 2 18 5/1/2021 US All_US 5 329.4 2 19 5/8/2021 US All_US 5 321.5 2 20 5/15/2021 US All_US 5 314.4 2 21 5/22/2021 US All_US 5 311.6 2 22 5/29/2021 US All_US 5 307.2 2 23 6/5/2021 US All_US 6 303.4 2 24 6/12/2021 US All_US 6 302.5 2 25 6/19/2021 US All_US 6 309.4 2 26 6/26/2021 US All_US 6 308.3 2 27 7/3/2021 US All_US 7 306.3 3 28 7/10/2021 US All_US 7 305.6 3 29 7/17/2021 US All_US 7 308.2 3 30 7/24/2021 US All_US 7 307.2 3 31 7/31/2021 US All_US 8 305.6 3 32 8/7/2021 US All_US 8 306.3 3 33 1/10/2021 NE 34 1/17/2021 NE 35 1/24/2021 NE 36 1/31/2021 NE 37 2/7/2021 NE Region 1 293.2 1 Region 1 294.0 1 Region 1 294.0 1 Region 1 294.7 1 Region 2 301.1 1 Data Georgraphy code Quarter code Month code Region State City Bubble Chart + 55°F Q Search H 10:14 PM 4/9/2023 Clear Complete the following: 1. Open the workbook named Raider.xlsx and save the file as Raider Analysis (Last Name).xlsx. 2. Create a series of charts that compare gas prices by time of the year and by location. The time can be in months or week of the month, as you deem appropriate. The location should be charted separately by region, by state, and by city. Each chart should be created on an individual sheet (named Region, State, and City, respectively). Select a chart type that provides ease of visual interpretation. Include readability features such as providing the actual names of locations instead of the codes (use a formula to populate these values in the marked cells in column G of the Data worksheet), answering which area is the highest priced location in your chart, and giving proper axes labels and chart titles. HINT: To do this, create a data series or table that summarizes and displays the gas price data by the location for each individual date. For example: New England Region Central Adantic Region Lower Adantic Region East Coast Region Midwest Region Gulf Coast Region West Coast Region All US 1/10/2020 309.9 325 325.8 326.5 Place the data in the marked cells on each of the three chart sheets. 310.6 301.9 3. For each location-region, state, and city-determine if a particular location has higher gas prices than the others. Selected the correct value from the drop-down list in the marked cell to explain your findings. 4. For each chart, determine if a particular season has higher gas prices than the other times of the year. Add a comment near each chart to explain your findings. 5. On the Bubble Chart sheet, create a bubble chart to illustrate the number of weeks that each city's gas price is above the gas price for the entire United States each week; the number of weeks that it is below the gas price for the entire United States each week; and the average gas price in dollars per gallon for the year. Add appropriate titles, labels, and a legend to the chart. The final chart could look like this: 3395 3254 J13 × ✓ fx A B C D E F G H K L M N O P О R S T U V W 1 Date Geography Type Month Price per (Quarter Description 2 1/10/2021 US All_US 1 292.9 1 3 1/17/2021 US All_US 1 294.4 1 4 1/24/2021 US All_US 1 297.6 1 5 1/31/2021 US All_US 1 299.5 1 6 2/7/2021 US All_US 2 307.1 1 7 2/14/2021 US All_US 2 320.7 1 8 2/21/2021 US All_US 2 332.8 1 9 2/28/2021 US All_US 2 336.4 1 10 3/6/2021 US All_US 3 343.3 1 11 3/13/2021 US All_US 3 349.4 1 12 3/20/2021 US All_US 3 354.5 1 13 3/27/2021 US All_US 3 351.3 1 14 4/3/2021 US All_US 4 347.0 2 15 4/10/2021 US All_US 4 343.7 2 16 4/17/2021 US All_US 4 338.1 2 17 4/24/2021 US All_US 4 332.5 2 18 5/1/2021 US All_US 5 329.4 2 19 5/8/2021 US All_US 5 321.5 2 20 5/15/2021 US All_US 5 314.4 2 21 5/22/2021 US All_US 5 311.6 2 22 5/29/2021 US All_US 5 307.2 2 23 6/5/2021 US All_US 6 303.4 2 24 6/12/2021 US All_US 6 302.5 2 25 6/19/2021 US All_US 6 309.4 2 26 6/26/2021 US All_US 6 308.3 2 27 7/3/2021 US All_US 7 306.3 3 28 7/10/2021 US All_US 7 305.6 3 29 7/17/2021 US All_US 7 308.2 3 30 7/24/2021 US All_US 7 307.2 3 31 7/31/2021 US All_US 8 305.6 3 32 8/7/2021 US All_US 8 306.3 3 33 1/10/2021 NE 34 1/17/2021 NE 35 1/24/2021 NE 36 1/31/2021 NE 37 2/7/2021 NE Region 1 293.2 1 Region 1 294.0 1 Region 1 294.0 1 Region 1 294.7 1 Region 2 301.1 1 Data Georgraphy code Quarter code Month code Region State City Bubble Chart + 55°F Q Search H 10:14 PM 4/9/2023 Clear
Expert Answer:
Answer rating: 100% (QA)
Sure here are the steps to complete the tasks 1 Open the workbook named Raiderxlsx and save the file as Raider Analysis Last Namexlsx 2 Create a series of charts Create a new worksheet named Region an... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
What are the three shapes of periodic signals a function generator can produce?
-
When would prefer a savings plan with high liquidity over one with a high rate of return?
-
For f(x) = x 3 18x 2 10x + 6, find the inflection point algebraically. Graph the function with a calculator or computer and confirm your answer.
-
A company is considering two alternatives, one of which must be implemented. Of the two projects, A has the higher maintenance cost, but B has the higher investment cost. The appropriate (and...
-
At Dot Corn, a large retailer of popular books demand is constant at 32.000 books per year. The cost of placing an order to replenish stock is $10 and the annual cost of holding is $4 per book. Stock...
-
A uniform plane wave (free space wave number ko = 2/o = /c) impinges on a boundary between two media at an incident angle 1 as shown below. Wave vectors are in black, wave fronts are in red. Given...
-
FlyHigh Tech, an early-stage startup, reports to its investors using a balanced scorecard that is prepared at the end of each quarter. During the first and second quarters of the current year, the...
-
A rainstorm in Portland, Oregon, wiped out the electricity in of the households in the city. Suppose thata random sampleof Portland households is taken after therainstorm. a. Estimate the number of...
-
The workplace is changing, maybe even more profoundly than since its greatest change, which took place during the Industrial Revolution. During the Industrial Revolution, millions of individuals...
-
calculate the : Expected return of Mikasa Inc stock Standard deviation of Mikasa Inc stock State of the Eren Mikasa economy Corp Inc Expansion 30% -20% Normal 10% 10% Recession -20% 11%
-
create a Java program that will be used to calculate ROI on three different pieces of equipment and sort it from best to least ROI. The program must prompt the user to enter the brand name of the...
-
Given below are the dollar-pound spot rate and the 1-year interest rates on the two currencies. a) What is the implied 1-year forward rate? Spot rate ($/) 1.59 $ interest rate 0.0142 interest rate...
-
On November 1, 20x1 Smarty Pants Company, a U.S. corporation, purchased diamonds from a Ukrainian company for 3,000,000 rubles, payable in 3 months. The relevant exchange rates between the U.S. and...
-
MASTERING MASSIVE DATABASES AT MASTERCARD INTERNATIONAL Many organizations are working hard to address the opportunities and storage challenges associated with big data. Industry experts estimate...
-
After Theorem 1.5 we note that multiplying a row by 0 is not allowed because that could change a solution set. Give an example of a system with solution set S0 where after multiplying a row by 0 the...
-
Frank Willingham has the following transactions during the year: Sale of office equipment on March 15 that cost $20,000 when purchased on July 1, 2010. Frank has claimed $5,000 in depreciation and...
-
Jim is fired from his job as a waiter and decides to take an extended trip to Europe. After touring Europe for 3 months, Jim returns to look for a new job as a waiter. Are his job-hunting expenses...
-
During 2012, Tom sold Sears stock for $10,000. The stock was purchased 4 years ago for $13,000. Tom also sold Ford Motor Company bonds for $35,000. The bonds were purchased 2 months ago for $30,000....
-
Read the following extract from an article about a business venture of the Bob Jane company. Is prudence still a virtue? The concept of prudence and its use, or non-use, in financial reporting has...
-
Your friend Ninette Nobis was a tourism management student when you were at university together and is now a manager of an upmarket hotel in the Exquisite Hotels chain. Because of the impact of an...
-
Transactions affecting Bradford Ltds accounts receivable for the year ended 30 June are presented below. On 1 July of the previous year, the opening balance of the Allowance for Doubtful Debts...
Study smarter with the SolutionInn App