Log Scales
ROW/COL	B	C	D	E	F	G	H	I
4	Frequently data is hard to understand without using logs
5	Here is some Forecasted data for the next few years. Look at the graphs below
6
7
8	Year	Forecast	log of number	Alternative way to express the #	=LOG(C9)
9	2000	10	1	10 ^1
10	2001	100	2	10 ^2
11	2002	1,000	3	10 ^3
12	2003	10,000	4	10 ^4
13	2004	100,000	5	10 ^5
14	2005	1,000,000	6	10 ^6
15	2006	10,000,000	7	10 ^7
16	2007	100,000,000	8	10 ^8
17	2008	1,000,000,000	9	10 ^9
18	2009	10,000,000,000	10	10 ^10
19	2010	100,000,000,000	11	10 ^11
20	2011	1,000,000,000,000	12	10 ^12
21
22
23
24		Here is one picture of the data
25		Notice that it is hard to see what is going on.
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55	Here is a picture using the log scale
56	Notice that you can see the series is going straight up.
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88	Using the logs of the data rather than a log axis
89	You see the same effects
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115