1. 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:

Place the data in the marked cells on each of the three chart sheets.

1. For each locationregion, state, and citydetermine 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.
2. 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. I need all answers in an Excel sheet with a formula please

\begin{tabular}{|l|l|l|l|} \hline 1 & \multicolumn{1}{|c|}{ A } & \multicolumn{1}{|c}{ B } \\ \hline 2 & Code & Description \\ \hline 3 & NE & New England Region \\ \hline 4 & LA & Central Atlantic Region \\ \hline 5 & B1 & Lower Atlantic Region \\ \hline 6 & C2 & Chicago (City) \\ \hline 7 & CA & California (State) \\ \hline 8 & CL & Cleveland (City) \\ \hline 9 & CO & Colorado (State) \\ \hline 10 & D4 & Denver (City) \\ \hline 11 & FL & Florida (State) \\ \hline 12 & H3 & Houston (City) \\ \hline 13 & L5 & Los Angeles (City) \\ \hline 14 & M1 & Miami (City) \\ \hline 15 & MA & Massachusetts (State) \\ \hline 16 & MN & Minnesota (State) \\ \hline 17 & N1 & New York (City) \\ \hline 18 & NY & New York (State) \\ \hline 19 & OH & Ohio (State) \\ \hline 20 & EC & East Coast Region \\ \hline 21 & MW & Midwest Region \\ \hline 22 & GC & Gulf Coast Region \\ \hline 23 & RM & Rocky Mountain Region \\ \hline 24 & WC & West Coast Region \\ \hline 25 & S5 & San Francisco (City) \\ \hline 26 & SE & Seattle (City) \\ \hline 27 & TX & Texas (State) \\ \hline 28 & US & U.S. \\ \hline 29 & WA & Washington (State) \\ \hline 30 & & \\ \hline 31 & & \\ \hline 32 & & \\ \hline & & Data Geography code \\ \hline \end{tabular} C D \begin{tabular}{l|l|l} E & F & G \end{tabular} H New England Region Central Atlantic Region Lower Atlantic Region East Coast Region Midwest Region Gulf Coast Region West Coast Region U.S. 1/10/2021 1/17/2021 1/24/2021 1/31/2021 2/7/2021 2/14/2021 2/21/2021 2/28/2021 3/6/2021 3/13/2021 3/20/2021 3/27/2021 4/3/2021 4/10/2021 4/17/2021 4/24/2021 5/1/2021 5/8/2021 5/15/2021 5/22/2021 5/29/2021 6/5/2021 6/12/2021 6/19/2021 6/26/2021 7/3/2021 7/10/2021 7/17/2021 7/24/2021 7/31/2021 8/7/2021 \begin{tabular}{|l|l|l|l|} \hline 1 & \multicolumn{1}{|c|}{ A } & \multicolumn{1}{|c}{ B } \\ \hline 2 & Code & Description \\ \hline 3 & NE & New England Region \\ \hline 4 & LA & Central Atlantic Region \\ \hline 5 & B1 & Lower Atlantic Region \\ \hline 6 & C2 & Chicago (City) \\ \hline 7 & CA & California (State) \\ \hline 8 & CL & Cleveland (City) \\ \hline 9 & CO & Colorado (State) \\ \hline 10 & D4 & Denver (City) \\ \hline 11 & FL & Florida (State) \\ \hline 12 & H3 & Houston (City) \\ \hline 13 & L5 & Los Angeles (City) \\ \hline 14 & M1 & Miami (City) \\ \hline 15 & MA & Massachusetts (State) \\ \hline 16 & MN & Minnesota (State) \\ \hline 17 & N1 & New York (City) \\ \hline 18 & NY & New York (State) \\ \hline 19 & OH & Ohio (State) \\ \hline 20 & EC & East Coast Region \\ \hline 21 & MW & Midwest Region \\ \hline 22 & GC & Gulf Coast Region \\ \hline 23 & RM & Rocky Mountain Region \\ \hline 24 & WC & West Coast Region \\ \hline 25 & S5 & San Francisco (City) \\ \hline 26 & SE & Seattle (City) \\ \hline 27 & TX & Texas (State) \\ \hline 28 & US & U.S. \\ \hline 29 & WA & Washington (State) \\ \hline 30 & & \\ \hline 31 & & \\ \hline 32 & & \\ \hline & & Data Geography code \\ \hline \end{tabular} C D \begin{tabular}{l|l|l} E & F & G \end{tabular} H New England Region Central Atlantic Region Lower Atlantic Region East Coast Region Midwest Region Gulf Coast Region West Coast Region U.S. 1/10/2021 1/17/2021 1/24/2021 1/31/2021 2/7/2021 2/14/2021 2/21/2021 2/28/2021 3/6/2021 3/13/2021 3/20/2021 3/27/2021 4/3/2021 4/10/2021 4/17/2021 4/24/2021 5/1/2021 5/8/2021 5/15/2021 5/22/2021 5/29/2021 6/5/2021 6/12/2021 6/19/2021 6/26/2021 7/3/2021 7/10/2021 7/17/2021 7/24/2021 7/31/2021 8/7/2021