This is a project where you will make up the data, but the analysis will be genuine.

You are the expert. You have been asked to develop a spreadsheet to automatically calculate

daily and weekly statistics about $5$ products that are sold online. The information you will need

to include is listed below, however you will have to determine which mathematical formulas to

include in order to get the appropriate statistical results. Hints will be provided on where to

enter the data in your chart in order to get the best overall layout for your spreadsheet.

Remember to use appropriate formatting tools in order to make your spreadsheets look

attractive $($merge and center, borders, bold, highlighting, etc.$).$

Go to any online store $($like Walmart, Target, or Hayneedle$)$ and select a department you are

interested in$.$ Choose $5$ items for sale from that one department. $($Example: $5$ different kinds of

Dog Food from the Pet Department$).$ Note the Product Name and Price information about that

product.

Section $1$:

$$ Set up an Excel Spreadsheet to show the Product information.

$$ Include the following information at the top of your spreadsheet $($format appropriately$).$

$$ Your name, with your title $($Mr$.,$ Ms$.,$ or professional title$).$

$$ Title of your spreadsheet $($make it appropriate for the products you chose $-$ Example:

Dry Dog Food Sales$).$