Question
2. Create a series of charts that compare gas prices by time of the year and by location. The time can be in quarters,
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/6686e92005ce0_5356686e91fd9593.jpg)
2. Create a series of charts that compare gas prices by time of the year and by location. The time can be in quarters, 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 the chart type that provides ease of visual interpretation. HINT: to do this, you will need to 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 Atlantic Region Lower Atlantic Region East Coast Region Midwest Region Gulf Coast Region West Coast Region All US 1/10/2020 325 310.6 301.9 325.8 326.5 309.9 3. For each location-region, state, and city-determine if a particular location has higher gas prices than the others. Add a comment near each chart to explain your findings. 4. For each chart, determine if a particular time of year has higher gas prices than the other times of the year. Add a comment near each chart to explain your findings. 5. On a new sheet named "bubble chart", 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; the number of weeks that it is below the gas price for the entire united states; 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: 339.5 325.4
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
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](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started