Nov. 17th-Dec. 6th
The word has spread around town about your coffee shop business. Some local investors are interested in expanding the size and location of your coffee shop. They would like to see some charts detailing your success throughout the time you have been open.
You will start today by analyzing the results that you have saved in Excel. First you will need to find some averages.
Create a new line on your spreadsheet and find the average for the following:
Price Per Cup
You will then need to create a few graphs. Create the following graphs, each as a new sheet:
1. Column Graph with Temperature/Cups Sold
2. Bar Graph with Price Per Cup
3. Line Graph with your Reputation
4. Line Graph with your Cash
Be sure to title and label each graph.
LT: I know how to use the function tool to find the average in Excel. I am also able to create a graph in excel.