Spread Sheet/ graph. Business 220
Alan7
ExcelAssignment1.xlsxInstructions
| On the following sheet, create a nice looking spreadsheet out of the data on the page. Included in this would be good column headers, spacing, gridlines, and anything |
| else you think adds to the readability of the data. |
| On the third sheet, create a graph from the data. You may choose any type of graph that makes sense for the data on the page. Create a new sheet and place the |
| graph on that page. |
Fix Spreadsheet
| LANDMARK | TRAVELED | DATE | PACE | MILES | DAYS | MILES/DAY | MILES/HR |
| Independence | 0 | 1-May | 8 | ||||
| Kansas River | 102 | 7-May | 8 | 102 | 6 | 17 | 2.1 |
| Blue River | 185 | 12-May | 8 | 83 | 5 | 16.6 | 2.1 |
| Ft. Kearney | 304 | 19-May | 8 | 119 | 7 | 17 | 2.1 |
| Chimney Rock | 554 | 6-Jun | 8 | 250 | 18 | 13.9 | 1.7 |
| Ft. Laramie | 640 | 14-Jun | 8 | 86 | 8 | 10.8 | 1.3 |
| Independence Rock | 830 | 18-Jul | 8 | 190 | 34 | 5.6 | 0.7 |
| South Pass | 932 | 30-Jul | 8 | 102 | 12 | 8.5 | 1.1 |
| Green River | 1057 | 14-Aug | 8 | 125 | 15 | 8.3 | 1 |
| Soda Springs | 1201 | 31-Aug | 8 | 144 | 17 | 8.5 | 1.1 |
| Ft. Hall | 1258 | 6-Sep | 8 | 57 | 6 | 9.5 | 1.2 |
| Snake River | 1440 | 28-Sep | 8 | 182 | 22 | 8.3 | 1 |
| Ft. Boise | 1554 | 20-Oct | 8 | 114 | 22 | 5.2 | 0.6 |
| Grande Ronde | 1741 | 8-Nov | 8 | 187 | 19 | 9.8 | 1.2 |
| The Dalles | 1839 | 1-Dec | 8 | 98 | 23 | 4.3 | 0.5 |
| Willamette Valley | 1939 | 5-Dec | 8 | 100 | 4 | 25 | 3.1 |
| TOTALS | 1939 | 218 | |||||
| AVERAGES | 8 | 11.2 | 1.4 |
Create graph from these data
| Low | High | Average | |
| Monday | 2 | 86 | 42.3 |
| Tuesday | 4 | 84 | 42.8 |
| Wednesday | 7 | 85 | 40.6 |
| Thursday | 0 | 104 | 38.3 |
| Friday | 0 | 78 | 30.6 |
| Saturday | 1 | 29 | 11.9 |
| Sunday | 0 | 38 | 15.2 |
Low
Monday Tuesday Wednesday Thursday Friday Saturday Sunday 2 4 7 0 0 1 0 High
Monday Tuesday Wednesday Thursday Friday Saturday Sunday 86 84 85 104 78 29 38 Average
Monday Tuesday Wednesday Thursday Friday Saturday Sunday 42.323529411764703 42.826086956521742 40.623188405797102 38.260869565217391 30.608695652173914 11.855072463768115 15.173913043478262
