Question: Build a table for your data by entering dates in cells in column A for each of the last 7 days. In column B, enter

Build a table for your data by entering dates in
Build a table for your data by entering dates in cells in column A for each of the last 7 days. In column B, enter a recorded gasoline price in dollars and cents for each date collected at convenience store one (identify store name) (try to record your data around the same time each day). Use data you collected or an online reference (Gas Buddy), if possible. In column C, enter a recorded gasoline price in dollars and cents for each date collected at convenience store two (identify store name) (try to record your data around the same time each day). Use data you collected or an online reference (Gas Buddy), if possible. In column D, enter a recorded gasoline price in dollars and cents for each date collected at convenience store three (identify store name) (try to record your data around the same time each day). Use data you collected or an online reference (Gas Buddy), if possible. All convenience stores should be within a 10 mile radius of one another. Add a row to calculate the total prices over the 7 day period for each store and a column to calculate the total prices by day for all stores. Add a row to calculate the average price per store and a column to calculate the average price per day. Type a main title for the data as well as column labels

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!