$**$Please compute and give table data for each month in Deliverable $2,$ creating a graph that can be exported to Excel$**$

Use Microsoft Copilot to look up historical monthly gas prices in $NJ,$ OPEC projections for oil output, and projected miles driven. Document your various

Copilot prompts $($the questions ask$)$ in a Word document named "Copilot prompts" which you can attach to this assignment in Canvas $($deliverable $1)$

Load data into Excel and analyze your data. Make a projection on the future price of a gallon of gas for the rest of $2024,2025,2026,$ and $2027.$ Note:

There is no right answer for this projection, although linking it to an Excel function like the linear or other growth trend method you learned in BITM

supported by the current Consumer Price Index or your opinoin on gas prices and demand to make your projection. Make at least one Excel chart stating

your projection based on these factors. Name this document "Gas Price Analysis$)$ and attach it to this assignment in Canvas $($deliverable $2).$

Use the data about and Excel financial functions to make a determination and recommendation about what type of car to buy to minimize overall

transportation costs $($e$.$g$.$ purchase price, cost of driving the stated number of miles$)$ using the following assumptions. Do this in a second Excel file named

"Vehicle Analysis" $($deliverable $3)$

Assumption: Miles driven per year: $25000$

Option $1$

Traditional gas car. $$30000.$ Miles per gallon for this car: $25$ MPG

Option $2.$

Hybrid car. $$50000.$ MPG: Miles per gallon for this car: $45$ MPG

Option $3$

Electric Car. $$75000.$ Cost per mile to operate: $$0\mathrm{.}06$ per gallon.

Identify seven entities one might include in a data model if one was going to build a database application to store data on this business question. Attach

this to the task as a Word document named "Project Data Entities" $($deliverable $4)$