Instruction mention in file below.
>Instructions
-May
-May
8 102 -May
8 5 2.1 -May
8 7 17 2.1 8 0
18 8 8 8 8 102 12 8 1 8 17 8.5 1.1 8 57 6 8 8.3 1 8 22 8 19 1.2 8 8 4 25 1939 8 2 86 4 7 0 .3
0 1 0 38
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
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
8
Kansas River
102
7
6
17
2.1
Blue River
18
5
12
83
16.6
Ft. Kearney
30
4
19
119
Chimney Rock
554
6-Jun
25
13.9
1.7
Ft. Laramie
640
14-Jun
86
10.8
1.3
Independence Rock
830
18-Jul
190
34
5.6
0.7
South Pass
932
30-Jul
8.5
1.1
Green River
10
57
14-Aug
125
15
8.3
Soda Springs
1201
31-Aug
144
Ft. Hall
1258
6-Sep
9.5
1.2
Snake River
1440
28-Sep
182
22
Ft. Boise
1554
20-Oct
114
5.2
0.6
Grande Ronde
1741
8-Nov
187
9.8
The Dalles
1839
1-Dec
98
23
4.3
0.5
Willamette Valley
1939
5-Dec
100
3.1
TOTALS
218
AVERAGES
11.2
1.4
Create graph from these data
Low
High
Average
Monday
42.3
Tuesday
84
42.8
Wednesday
85
40.6
Thursday
104
38
Friday
78
30.6
Saturday
29
11.9
Sunday
15.2