Lighthouse to Coastline Ratios

	A	B	C	D	E
1	State	Number of Lighthouses	Coastline in Miles	Coastline in Hundreds of Miles	Ratio

2	Indiana	4	45	0.45	8.889
3	Illinois	3	63	0.63	4.762
4	Rhode Island	15	384	3.84	3.906
5	Ohio	12	312	3.12	3.846
6	Delaware	14	381	3.81	3.675
7	Massachusets	47	1519	15.19	3.094
8	Michigan	94	3224	32.24	2.916
9	Pennsylvania	4	140	1.4	2.857
10	Minnesota	5	189	1.89	2.646
11	Connecticut	15	618	6.18	2.427
12	Maine	57	3478	34.78	1.639
13	New York	41	2625	26.25	1.562
14	New Hampshire	2	131	1.31	1.527
15	California	30	3427	34.27	0.875
16	Hawaii	8	1052	10.52	0.76
17	Washington	22	3026	30.26	0.727
18	New Jersey	13	1792	17.92	0.725
19	Oregon	8	1410	14.1	0.567
20	Maryland	14	3190	31.9	0.439
21	Florida	25	8436	84.36	0.296
22	Mississippi	1	359	3.59	0.279
23	Virginia	9	3315	33.15	0.271
24	Georgia	5	2344	23.44	0.213
25	South Carolina	6	2876	28.76	0.209
26	North Carolina	7	3375	33.75	0.207
27	Alabama	1	607	6.07	0.165
28	Texas	3	3359	33.59	0.089
29	Louisiana	5	7721	77.21	0.065
30	Alaska	12	33904	339.04	0.035
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
56
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
89
90
91
92
93
94
95
96
97
98
99
100