2085_3b19
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.88 | 3.62 | 4.19 | 3.56 | 4.53 |
| Beisner Road Entrance | 4.42 | 3.56 | 4.46 | 3.71 | 3.39 |
| Boat Launch Area | 3.90 | 2.59 | 4.35 | ||
| Busse Lake | 4.82 | 4.06 | 5.15 | 4.60 | 4.07 |
| Debra Park | 4.30 | 4.25 | 4.15 | 4.75 | 4.57 |
| Elk Pasture | 3.56 | 3.75 | 4.60 | 3.50 | 3.83 |
| Forest Central Grove | 4.37 | ||||
| Forest North Grove | 4.92 | 4.67 | 2.93 | 4.15 | 3.65 |
| Forest South Grove | 4.87 | 3.71 | 4.45 | 3.86 | |
| Forest West Grove | 3.25 | 3.68 | 4.05 | ||
| Lake Boating Center | 4.24 | 4.50 | 4.21 | 4.88 | 3.89 |
| Large Event Area | 4.27 | 4.34 | 3.82 | ||
| Main Dam | 4.24 | 4.57 | 5.16 | 3.90 | 3.67 |
| Main Pool | 3.78 | ||||
| Marshall Park | 4.24 | 4.16 | 4.54 | 4.38 | 3.81 |
| Model Airplane Field | 4.76 | 4.95 | 4.27 | 4.03 | 3.09 |
| Nature Preserve | 2.88 | 4.75 | 4.24 | ||
| Ned Brown Meadow | 4.04 | 3.78 | 4.47 | 3.27 | |
| North Pool | 5.06 | 3.68 | |||
| Osborn Park | 4.03 | 4.62 | 4.35 | 4.17 | |
| Salt Creek Trail | 3.78 | 4.09 | |||
| South Pool | 3.97 | 3.95 | |||
| Wildlife Refuge | 3.32 | 4.01 | 3.35 | 3.60 | |
| Woodland Meadow | 3.70 | 4.23 | 3.49 | 3.86 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.88,3.62,4.19,3.56,4.53
Beisner Road Entrance,4.42,3.56,4.46,3.71,3.39
Boat Launch Area,,,3.90,2.59,4.35
Busse Lake,4.82,4.06,5.15,4.60,4.07
Debra Park,4.30,4.25,4.15,4.75,4.57
Elk Pasture,3.56,3.75,4.60,3.50,3.83
Forest Central Grove,,,,,4.37
Forest North Grove,4.92,4.67,2.93,4.15,3.65
Forest South Grove,,4.87,3.71,4.45,3.86
Forest West Grove,,,3.25,3.68,4.05
Lake Boating Center,4.24,4.50,4.21,4.88,3.89
Large Event Area,,,4.27,4.34,3.82
Main Dam,4.24,4.57,5.16,3.90,3.67
Main Pool,,,,,3.78
Marshall Park,4.24,4.16,4.54,4.38,3.81
Model Airplane Field,4.76,4.95,4.27,4.03,3.09
Nature Preserve,,,2.88,4.75,4.24
Ned Brown Meadow,,4.04,3.78,4.47,3.27
North Pool,,,,5.06,3.68
Osborn Park,,4.03,4.62,4.35,4.17
Salt Creek Trail,,,,3.78,4.09
South Pool,,,,3.97,3.95
Wildlife Refuge,,3.32,4.01,3.35,3.60
Woodland Meadow,,3.70,4.23,3.49,3.86
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.23059255 0.00230000 NUM78cf_9d28
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.37 | 4.03 | 3.86 | 4.35 | 3.35 |
| Beisner Road Entrance | 3.82 | 3.88 | 4.08 | 3.74 | 2.79 |
| Boat Launch Area | 4.56 | 4.33 | 3.78 | 3.98 | 3.10 |
| Busse Lake | 4.54 | 4.59 | 3.85 | 3.27 | |
| Debra Park | 2.64 | 4.48 | 3.47 | 4.12 | |
| Elk Pasture | 3.94 | 4.07 | |||
| Forest Central Grove | 2.93 | 3.78 | 3.19 | 3.89 | 4.31 |
| Forest North Grove | 4.07 | 4.04 | |||
| Forest South Grove | 4.84 | 4.44 | 4.77 | ||
| Forest West Grove | 4.22 | 4.12 | 4.93 | 3.71 | |
| Lake Boating Center | 3.76 | 3.43 | 4.79 | 4.16 | 4.45 |
| Large Event Area | 2.87 | 3.86 | 4.24 | ||
| Main Dam | 4.61 | 4.61 | 4.13 | 4.36 | 3.92 |
| Main Pool | 3.78 | ||||
| Marshall Park | 4.01 | 4.47 | 4.19 | 3.95 | 4.34 |
| Model Airplane Field | 4.16 | ||||
| Nature Preserve | 4.08 | 4.11 | 3.61 | 3.33 | |
| Ned Brown Meadow | 3.19 | 4.77 | 4.37 | 4.03 | 3.74 |
| North Pool | 3.07 | 4.15 | 3.54 | 3.71 | 4.40 |
| Osborn Park | 3.48 | ||||
| Salt Creek Trail | 4.51 | 3.90 | 4.42 | ||
| South Pool | 3.55 | ||||
| Wildlife Refuge | 3.83 | 3.32 | 3.35 | 4.25 | 3.42 |
| Woodland Meadow | 3.87 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.37,4.03,3.86,4.35,3.35
Beisner Road Entrance,3.82,3.88,4.08,3.74,2.79
Boat Launch Area,4.56,4.33,3.78,3.98,3.10
Busse Lake,,4.54,4.59,3.85,3.27
Debra Park,,2.64,4.48,3.47,4.12
Elk Pasture,,,,3.94,4.07
Forest Central Grove,2.93,3.78,3.19,3.89,4.31
Forest North Grove,,,,4.07,4.04
Forest South Grove,,,4.84,4.44,4.77
Forest West Grove,,4.22,4.12,4.93,3.71
Lake Boating Center,3.76,3.43,4.79,4.16,4.45
Large Event Area,,,2.87,3.86,4.24
Main Dam,4.61,4.61,4.13,4.36,3.92
Main Pool,,,,,3.78
Marshall Park,4.01,4.47,4.19,3.95,4.34
Model Airplane Field,,,,,4.16
Nature Preserve,,4.08,4.11,3.61,3.33
Ned Brown Meadow,3.19,4.77,4.37,4.03,3.74
North Pool,3.07,4.15,3.54,3.71,4.40
Osborn Park,,,,,3.48
Salt Creek Trail,,,4.51,3.90,4.42
South Pool,,,,,3.55
Wildlife Refuge,3.83,3.32,3.35,4.25,3.42
Woodland Meadow,,,,,3.87
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.38257645 0.00380000 NUM74b2_2017
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.93 | 4.48 | 4.25 | 4.31 | |
| Beisner Road Entrance | 4.07 | 4.41 | 3.34 | ||
| Boat Launch Area | 3.33 | 2.91 | 4.72 | 3.99 | |
| Busse Lake | 4.05 | ||||
| Debra Park | 5.94 | 4.23 | 4.20 | 3.35 | 4.36 |
| Elk Pasture | 3.74 | 4.18 | |||
| Forest Central Grove | 4.27 | 4.65 | 4.36 | 3.76 | |
| Forest North Grove | 4.78 | 4.76 | 3.76 | 4.15 | 4.17 |
| Forest South Grove | 4.74 | 4.24 | |||
| Forest West Grove | 3.77 | 3.73 | 4.05 | ||
| Lake Boating Center | 4.46 | 3.72 | 4.26 | 3.32 | 4.54 |
| Large Event Area | 4.59 | 4.16 | 3.67 | ||
| Main Dam | 3.81 | 4.77 | 4.88 | 4.44 | 3.30 |
| Main Pool | 4.16 | 3.84 | 3.62 | 3.90 | |
| Marshall Park | 3.52 | 3.68 | 3.63 | 3.23 | 3.25 |
| Model Airplane Field | 4.34 | ||||
| Nature Preserve | 4.49 | 3.50 | 4.08 | ||
| Ned Brown Meadow | 3.86 | 4.88 | 3.57 | 3.44 | 3.98 |
| North Pool | 4.95 | 4.96 | 4.59 | 3.35 | 4.24 |
| Osborn Park | 4.18 | 3.81 | |||
| Salt Creek Trail | 3.50 | ||||
| South Pool | 4.28 | 4.29 | 4.80 | 4.16 | 3.87 |
| Wildlife Refuge | 4.10 | 3.85 | 2.79 | 3.92 | |
| Woodland Meadow | 4.01 | 4.33 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,3.93,4.48,4.25,4.31
Beisner Road Entrance,,,4.07,4.41,3.34
Boat Launch Area,,3.33,2.91,4.72,3.99
Busse Lake,,,,,4.05
Debra Park,5.94,4.23,4.20,3.35,4.36
Elk Pasture,,,,3.74,4.18
Forest Central Grove,,4.27,4.65,4.36,3.76
Forest North Grove,4.78,4.76,3.76,4.15,4.17
Forest South Grove,,,,4.74,4.24
Forest West Grove,,,3.77,3.73,4.05
Lake Boating Center,4.46,3.72,4.26,3.32,4.54
Large Event Area,,,4.59,4.16,3.67
Main Dam,3.81,4.77,4.88,4.44,3.30
Main Pool,,4.16,3.84,3.62,3.90
Marshall Park,3.52,3.68,3.63,3.23,3.25
Model Airplane Field,,,,,4.34
Nature Preserve,,,4.49,3.50,4.08
Ned Brown Meadow,3.86,4.88,3.57,3.44,3.98
North Pool,4.95,4.96,4.59,3.35,4.24
Osborn Park,,,,4.18,3.81
Salt Creek Trail,,,,,3.50
South Pool,4.28,4.29,4.80,4.16,3.87
Wildlife Refuge,,4.10,3.85,2.79,3.92
Woodland Meadow,,,,4.01,4.33
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.05261022 0.00100000 NUM4680_5886
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.72 | 3.59 | 3.46 | ||
| Beisner Road Entrance | 3.41 | 4.37 | 4.66 | 4.11 | 3.61 |
| Boat Launch Area | 3.93 | 4.55 | |||
| Busse Lake | 4.68 | 3.85 | 4.41 | 3.36 | 3.58 |
| Debra Park | 4.18 | ||||
| Elk Pasture | 4.07 | ||||
| Forest Central Grove | 3.98 | 4.11 | 4.08 | 3.77 | |
| Forest North Grove | 3.93 | 3.51 | |||
| Forest South Grove | 3.21 | 4.69 | 4.28 | 4.49 | 4.65 |
| Forest West Grove | 4.78 | 4.22 | 4.54 | ||
| Lake Boating Center | 4.45 | 4.07 | 5.17 | 4.53 | 4.24 |
| Large Event Area | 4.11 | 3.85 | 5.07 | 3.77 | |
| Main Dam | 4.97 | 4.45 | 3.27 | 3.69 | 4.00 |
| Main Pool | 4.39 | ||||
| Marshall Park | 4.23 | 4.12 | |||
| Model Airplane Field | 3.66 | 3.52 | |||
| Nature Preserve | 3.43 | ||||
| Ned Brown Meadow | 3.88 | 4.76 | 3.72 | 3.42 | 3.79 |
| North Pool | 4.54 | 3.59 | 4.80 | 4.01 | 4.84 |
| Osborn Park | 3.65 | 4.10 | |||
| Salt Creek Trail | 3.56 | 4.51 | 3.60 | ||
| South Pool | 4.36 | 4.36 | 3.77 | 4.29 | 3.84 |
| Wildlife Refuge | 4.45 | 3.85 | 3.88 | ||
| Woodland Meadow | 3.43 | 4.30 | 3.57 | 4.03 | 3.71 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,3.72,3.59,3.46
Beisner Road Entrance,3.41,4.37,4.66,4.11,3.61
Boat Launch Area,,,,3.93,4.55
Busse Lake,4.68,3.85,4.41,3.36,3.58
Debra Park,,,,,4.18
Elk Pasture,,,,,4.07
Forest Central Grove,,3.98,4.11,4.08,3.77
Forest North Grove,,,,3.93,3.51
Forest South Grove,3.21,4.69,4.28,4.49,4.65
Forest West Grove,,,4.78,4.22,4.54
Lake Boating Center,4.45,4.07,5.17,4.53,4.24
Large Event Area,,4.11,3.85,5.07,3.77
Main Dam,4.97,4.45,3.27,3.69,4.00
Main Pool,,,,,4.39
Marshall Park,,,,4.23,4.12
Model Airplane Field,,,,3.66,3.52
Nature Preserve,,,,,3.43
Ned Brown Meadow,3.88,4.76,3.72,3.42,3.79
North Pool,4.54,3.59,4.80,4.01,4.84
Osborn Park,,,,3.65,4.10
Salt Creek Trail,,,3.56,4.51,3.60
South Pool,4.36,4.36,3.77,4.29,3.84
Wildlife Refuge,,,4.45,3.85,3.88
Woodland Meadow,3.43,4.30,3.57,4.03,3.71
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.55207652 0.00550000 NUMbd88_25ad
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.26 | ||||
| Beisner Road Entrance | 3.56 | 4.64 | |||
| Boat Launch Area | 4.40 | 3.80 | |||
| Busse Lake | 3.32 | 4.42 | 4.06 | 3.69 | 4.09 |
| Debra Park | 4.21 | 2.95 | 3.01 | ||
| Elk Pasture | 4.76 | 4.55 | 3.63 | 4.40 | 4.64 |
| Forest Central Grove | 4.81 | ||||
| Forest North Grove | 4.10 | ||||
| Forest South Grove | 4.43 | 4.55 | 4.57 | 3.60 | |
| Forest West Grove | 4.18 | 4.00 | 3.49 | 4.27 | 4.53 |
| Lake Boating Center | 4.24 | 4.01 | 4.79 | ||
| Large Event Area | 3.79 | 3.42 | 4.25 | 3.37 | |
| Main Dam | 4.60 | 4.19 | 4.70 | 4.03 | 4.50 |
| Main Pool | 3.64 | 4.22 | 4.70 | 3.26 | |
| Marshall Park | 4.03 | 3.82 | 4.73 | ||
| Model Airplane Field | 4.74 | 4.38 | 4.79 | 3.41 | 3.62 |
| Nature Preserve | 4.72 | 3.15 | 4.26 | 3.35 | 4.37 |
| Ned Brown Meadow | 4.25 | 4.14 | 3.85 | 4.53 | 3.21 |
| North Pool | 5.51 | 4.01 | 4.95 | 2.93 | |
| Osborn Park | 4.49 | 3.75 | 3.14 | 5.26 | 4.49 |
| Salt Creek Trail | 4.60 | 4.08 | 3.91 | ||
| South Pool | 3.27 | 3.34 | 4.55 | 3.24 | 4.62 |
| Wildlife Refuge | 3.87 | 4.03 | 4.26 | 2.80 | 4.13 |
| Woodland Meadow | 4.39 | 4.31 | 5.06 | 4.23 | 3.48 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,,,3.26
Beisner Road Entrance,,,,3.56,4.64
Boat Launch Area,,,,4.40,3.80
Busse Lake,3.32,4.42,4.06,3.69,4.09
Debra Park,,,4.21,2.95,3.01
Elk Pasture,4.76,4.55,3.63,4.40,4.64
Forest Central Grove,,,,,4.81
Forest North Grove,,,,,4.10
Forest South Grove,,4.43,4.55,4.57,3.60
Forest West Grove,4.18,4.00,3.49,4.27,4.53
Lake Boating Center,,,4.24,4.01,4.79
Large Event Area,,3.79,3.42,4.25,3.37
Main Dam,4.60,4.19,4.70,4.03,4.50
Main Pool,,3.64,4.22,4.70,3.26
Marshall Park,,,4.03,3.82,4.73
Model Airplane Field,4.74,4.38,4.79,3.41,3.62
Nature Preserve,4.72,3.15,4.26,3.35,4.37
Ned Brown Meadow,4.25,4.14,3.85,4.53,3.21
North Pool,,5.51,4.01,4.95,2.93
Osborn Park,4.49,3.75,3.14,5.26,4.49
Salt Creek Trail,,,4.60,4.08,3.91
South Pool,3.27,3.34,4.55,3.24,4.62
Wildlife Refuge,3.87,4.03,4.26,2.80,4.13
Woodland Meadow,4.39,4.31,5.06,4.23,3.48
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.75795417 0.00760000 NUM6d0b_70be
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.36 | ||||
| Beisner Road Entrance | 4.16 | 3.72 | 4.18 | 3.77 | 3.75 |
| Boat Launch Area | 4.10 | 4.04 | 3.14 | 4.23 | 3.90 |
| Busse Lake | 3.29 | 2.88 | 3.48 | 3.99 | 3.73 |
| Debra Park | 3.55 | ||||
| Elk Pasture | 3.30 | ||||
| Forest Central Grove | 4.32 | 4.05 | 3.62 | 3.34 | 4.30 |
| Forest North Grove | 4.00 | 4.30 | 3.99 | 3.40 | 4.10 |
| Forest South Grove | 4.14 | 3.93 | 4.60 | 4.06 | 4.02 |
| Forest West Grove | 4.53 | 3.30 | 4.08 | ||
| Lake Boating Center | 4.33 | 4.65 | 3.97 | 4.78 | |
| Large Event Area | 3.15 | ||||
| Main Dam | 4.02 | 3.90 | 4.75 | ||
| Main Pool | 3.75 | 3.81 | 4.06 | 3.17 | 4.27 |
| Marshall Park | 4.34 | 4.38 | 4.73 | 3.45 | |
| Model Airplane Field | 4.16 | 4.10 | 4.05 | 3.98 | 3.68 |
| Nature Preserve | 3.49 | 4.64 | 3.22 | ||
| Ned Brown Meadow | 4.23 | 3.70 | 4.78 | 3.90 | 3.75 |
| North Pool | 3.48 | 2.99 | |||
| Osborn Park | 4.26 | 3.67 | 3.89 | 3.99 | 4.35 |
| Salt Creek Trail | 4.44 | ||||
| South Pool | 4.01 | 4.31 | |||
| Wildlife Refuge | 3.40 | 4.26 | 4.07 | 4.00 | |
| Woodland Meadow | 4.22 | 4.78 | 4.16 | 4.21 | 3.58 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,,,3.36
Beisner Road Entrance,4.16,3.72,4.18,3.77,3.75
Boat Launch Area,4.10,4.04,3.14,4.23,3.90
Busse Lake,3.29,2.88,3.48,3.99,3.73
Debra Park,,,,,3.55
Elk Pasture,,,,,3.30
Forest Central Grove,4.32,4.05,3.62,3.34,4.30
Forest North Grove,4.00,4.30,3.99,3.40,4.10
Forest South Grove,4.14,3.93,4.60,4.06,4.02
Forest West Grove,,,4.53,3.30,4.08
Lake Boating Center,,4.33,4.65,3.97,4.78
Large Event Area,,,,,3.15
Main Dam,,,4.02,3.90,4.75
Main Pool,3.75,3.81,4.06,3.17,4.27
Marshall Park,,4.34,4.38,4.73,3.45
Model Airplane Field,4.16,4.10,4.05,3.98,3.68
Nature Preserve,,,3.49,4.64,3.22
Ned Brown Meadow,4.23,3.70,4.78,3.90,3.75
North Pool,,,,3.48,2.99
Osborn Park,4.26,3.67,3.89,3.99,4.35
Salt Creek Trail,,,,,4.44
South Pool,,,,4.01,4.31
Wildlife Refuge,,3.40,4.26,4.07,4.00
Woodland Meadow,4.22,4.78,4.16,4.21,3.58
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.54749393 0.00550000 NUMda70_dcfe
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 4.66 | 4.67 | 3.95 | 4.43 | 4.19 |
| Beisner Road Entrance | 3.58 | 4.65 | 4.04 | 4.48 | 4.64 |
| Boat Launch Area | 3.71 | 3.44 | 4.76 | ||
| Busse Lake | 4.52 | ||||
| Debra Park | 3.44 | 4.98 | 4.90 | 3.82 | |
| Elk Pasture | 3.75 | 3.29 | 3.51 | ||
| Forest Central Grove | 2.89 | 3.50 | |||
| Forest North Grove | 3.51 | ||||
| Forest South Grove | 3.78 | 4.44 | 4.69 | 4.59 | 4.32 |
| Forest West Grove | 4.59 | 3.72 | 4.02 | 3.78 | |
| Lake Boating Center | 3.95 | 4.38 | 4.32 | 3.43 | 3.88 |
| Large Event Area | 5.02 | 4.09 | |||
| Main Dam | 3.62 | 4.43 | 4.18 | 4.10 | 4.10 |
| Main Pool | 4.19 | 4.06 | 4.55 | 4.34 | 4.56 |
| Marshall Park | 3.98 | 4.29 | 3.49 | 4.65 | 4.13 |
| Model Airplane Field | 4.15 | 4.31 | 4.13 | 3.04 | 3.25 |
| Nature Preserve | 5.01 | 4.35 | 3.31 | 4.04 | 4.50 |
| Ned Brown Meadow | 3.33 | 3.33 | 5.10 | 3.78 | 4.49 |
| North Pool | 4.49 | 4.71 | 3.65 | 3.64 | 4.77 |
| Osborn Park | 3.31 | 5.05 | 4.59 | 3.92 | 4.00 |
| Salt Creek Trail | 4.34 | ||||
| South Pool | 3.77 | ||||
| Wildlife Refuge | 3.44 | ||||
| Woodland Meadow | 3.92 | 4.12 | 3.96 | 4.89 | 3.11 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.66,4.67,3.95,4.43,4.19
Beisner Road Entrance,3.58,4.65,4.04,4.48,4.64
Boat Launch Area,,,3.71,3.44,4.76
Busse Lake,,,,,4.52
Debra Park,,3.44,4.98,4.90,3.82
Elk Pasture,,,3.75,3.29,3.51
Forest Central Grove,,,,2.89,3.50
Forest North Grove,,,,,3.51
Forest South Grove,3.78,4.44,4.69,4.59,4.32
Forest West Grove,,4.59,3.72,4.02,3.78
Lake Boating Center,3.95,4.38,4.32,3.43,3.88
Large Event Area,,,,5.02,4.09
Main Dam,3.62,4.43,4.18,4.10,4.10
Main Pool,4.19,4.06,4.55,4.34,4.56
Marshall Park,3.98,4.29,3.49,4.65,4.13
Model Airplane Field,4.15,4.31,4.13,3.04,3.25
Nature Preserve,5.01,4.35,3.31,4.04,4.50
Ned Brown Meadow,3.33,3.33,5.10,3.78,4.49
North Pool,4.49,4.71,3.65,3.64,4.77
Osborn Park,3.31,5.05,4.59,3.92,4.00
Salt Creek Trail,,,,,4.34
South Pool,,,,,3.77
Wildlife Refuge,,,,,3.44
Woodland Meadow,3.92,4.12,3.96,4.89,3.11
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.45813283 0.00460000 NUM1deb_1103
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 4.60 | ||||
| Beisner Road Entrance | 4.46 | 3.74 | 3.65 | 4.09 | 4.23 |
| Boat Launch Area | 3.83 | 3.62 | 5.25 | 3.54 | 3.41 |
| Busse Lake | 3.73 | 3.90 | 4.46 | 4.13 | 4.27 |
| Debra Park | 3.56 | ||||
| Elk Pasture | 4.22 | 3.47 | 3.98 | 3.92 | 3.11 |
| Forest Central Grove | 3.55 | 4.29 | 4.18 | ||
| Forest North Grove | 3.67 | 3.85 | |||
| Forest South Grove | 3.87 | 4.37 | 3.43 | 3.90 | 4.37 |
| Forest West Grove | 3.24 | ||||
| Lake Boating Center | 4.29 | 4.93 | 4.32 | 3.65 | |
| Large Event Area | 4.52 | ||||
| Main Dam | 4.04 | 4.29 | |||
| Main Pool | 3.65 | 3.99 | 3.79 | ||
| Marshall Park | 4.83 | 3.58 | 4.89 | 3.59 | 3.40 |
| Model Airplane Field | 4.43 | 4.06 | 3.49 | 3.42 | |
| Nature Preserve | 4.21 | 4.39 | 3.16 | 4.31 | 3.92 |
| Ned Brown Meadow | 3.94 | 3.80 | 4.08 | 4.35 | 4.41 |
| North Pool | 4.62 | 4.12 | 4.57 | 4.28 | |
| Osborn Park | 4.81 | 4.66 | 3.93 | ||
| Salt Creek Trail | 4.42 | 4.08 | |||
| South Pool | 4.68 | ||||
| Wildlife Refuge | 3.79 | 3.89 | 3.85 | ||
| Woodland Meadow | 4.67 | 4.22 | 3.52 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,,,4.60
Beisner Road Entrance,4.46,3.74,3.65,4.09,4.23
Boat Launch Area,3.83,3.62,5.25,3.54,3.41
Busse Lake,3.73,3.90,4.46,4.13,4.27
Debra Park,,,,,3.56
Elk Pasture,4.22,3.47,3.98,3.92,3.11
Forest Central Grove,,,3.55,4.29,4.18
Forest North Grove,,,,3.67,3.85
Forest South Grove,3.87,4.37,3.43,3.90,4.37
Forest West Grove,,,,,3.24
Lake Boating Center,,4.29,4.93,4.32,3.65
Large Event Area,,,,,4.52
Main Dam,,,,4.04,4.29
Main Pool,,,3.65,3.99,3.79
Marshall Park,4.83,3.58,4.89,3.59,3.40
Model Airplane Field,,4.43,4.06,3.49,3.42
Nature Preserve,4.21,4.39,3.16,4.31,3.92
Ned Brown Meadow,3.94,3.80,4.08,4.35,4.41
North Pool,,4.62,4.12,4.57,4.28
Osborn Park,,,4.81,4.66,3.93
Salt Creek Trail,,,,4.42,4.08
South Pool,,,,,4.68
Wildlife Refuge,,,3.79,3.89,3.85
Woodland Meadow,,,4.67,4.22,3.52
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.62176699 0.00620000 NUMe070_5a39
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 4.34 | 3.75 | |||
| Beisner Road Entrance | 3.22 | ||||
| Boat Launch Area | 3.24 | 4.23 | 4.54 | 3.95 | 4.08 |
| Busse Lake | 4.14 | 3.88 | 4.07 | 3.84 | 3.59 |
| Debra Park | 3.99 | 4.02 | 3.58 | ||
| Elk Pasture | 4.00 | 3.43 | 3.49 | ||
| Forest Central Grove | 3.66 | 4.17 | 4.53 | 4.03 | 3.81 |
| Forest North Grove | 5.09 | 4.54 | 3.43 | 4.21 | 4.33 |
| Forest South Grove | 2.70 | 4.49 | 4.26 | 4.03 | 4.21 |
| Forest West Grove | 4.56 | 4.95 | 3.64 | 4.03 | 4.34 |
| Lake Boating Center | 5.28 | 4.63 | 4.12 | 4.26 | 4.01 |
| Large Event Area | 3.82 | 3.84 | 4.40 | 3.49 | |
| Main Dam | 4.74 | 4.99 | 3.10 | 4.37 | 4.38 |
| Main Pool | 4.40 | 4.25 | 3.91 | 4.13 | |
| Marshall Park | 4.03 | 4.10 | 4.20 | ||
| Model Airplane Field | 4.75 | ||||
| Nature Preserve | 4.53 | 3.40 | 4.19 | 4.60 | 4.10 |
| Ned Brown Meadow | 3.87 | 3.91 | |||
| North Pool | 4.84 | 3.08 | 3.68 | 3.55 | |
| Osborn Park | 5.45 | 4.37 | 3.55 | 3.74 | 3.86 |
| Salt Creek Trail | 4.07 | 3.80 | 3.61 | 5.01 | 4.38 |
| South Pool | 4.31 | 4.44 | 4.43 | 3.80 | 3.81 |
| Wildlife Refuge | 4.18 | 4.33 | 4.42 | 4.06 | |
| Woodland Meadow | 3.66 | 3.22 | 3.73 | 4.20 | 4.00 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,,4.34,3.75
Beisner Road Entrance,,,,,3.22
Boat Launch Area,3.24,4.23,4.54,3.95,4.08
Busse Lake,4.14,3.88,4.07,3.84,3.59
Debra Park,,,3.99,4.02,3.58
Elk Pasture,,,4.00,3.43,3.49
Forest Central Grove,3.66,4.17,4.53,4.03,3.81
Forest North Grove,5.09,4.54,3.43,4.21,4.33
Forest South Grove,2.70,4.49,4.26,4.03,4.21
Forest West Grove,4.56,4.95,3.64,4.03,4.34
Lake Boating Center,5.28,4.63,4.12,4.26,4.01
Large Event Area,,3.82,3.84,4.40,3.49
Main Dam,4.74,4.99,3.10,4.37,4.38
Main Pool,,4.40,4.25,3.91,4.13
Marshall Park,,,4.03,4.10,4.20
Model Airplane Field,,,,,4.75
Nature Preserve,4.53,3.40,4.19,4.60,4.10
Ned Brown Meadow,,,,3.87,3.91
North Pool,,4.84,3.08,3.68,3.55
Osborn Park,5.45,4.37,3.55,3.74,3.86
Salt Creek Trail,4.07,3.80,3.61,5.01,4.38
South Pool,4.31,4.44,4.43,3.80,3.81
Wildlife Refuge,,4.18,4.33,4.42,4.06
Woodland Meadow,3.66,3.22,3.73,4.20,4.00
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.11810604 0.00120000 NUM4c4a_5a39
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 4.07 | 4.69 | 3.47 | ||
| Beisner Road Entrance | 3.25 | 4.44 | 3.53 | 3.77 | |
| Boat Launch Area | 3.42 | 3.81 | 4.29 | 4.10 | 4.37 |
| Busse Lake | 3.93 | 4.45 | 3.11 | 4.42 | |
| Debra Park | 3.06 | 4.08 | 4.67 | 4.06 | 3.65 |
| Elk Pasture | 3.52 | 4.01 | 4.52 | ||
| Forest Central Grove | 3.56 | 4.89 | |||
| Forest North Grove | 4.24 | 4.03 | 4.19 | 4.74 | |
| Forest South Grove | 3.66 | 4.38 | 4.19 | 4.37 | 4.17 |
| Forest West Grove | 3.75 | ||||
| Lake Boating Center | 3.73 | ||||
| Large Event Area | 4.12 | ||||
| Main Dam | 3.82 | 4.52 | 3.92 | 3.17 | 3.89 |
| Main Pool | 4.08 | 4.23 | |||
| Marshall Park | 3.97 | 4.38 | 4.28 | 3.23 | 3.90 |
| Model Airplane Field | 4.37 | 3.91 | 4.31 | ||
| Nature Preserve | 4.55 | ||||
| Ned Brown Meadow | 3.54 | 3.90 | 4.21 | 2.98 | |
| North Pool | 4.38 | 4.42 | 3.76 | 4.64 | |
| Osborn Park | 4.10 | 4.15 | 3.92 | 4.68 | 4.03 |
| Salt Creek Trail | 3.77 | ||||
| South Pool | 4.90 | 3.41 | 4.55 | 4.44 | 4.01 |
| Wildlife Refuge | 4.03 | 4.01 | 4.82 | ||
| Woodland Meadow | 4.59 | 4.36 | 3.93 | 4.20 | 3.50 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,4.07,4.69,3.47
Beisner Road Entrance,,3.25,4.44,3.53,3.77
Boat Launch Area,3.42,3.81,4.29,4.10,4.37
Busse Lake,,3.93,4.45,3.11,4.42
Debra Park,3.06,4.08,4.67,4.06,3.65
Elk Pasture,,,3.52,4.01,4.52
Forest Central Grove,,,,3.56,4.89
Forest North Grove,,4.24,4.03,4.19,4.74
Forest South Grove,3.66,4.38,4.19,4.37,4.17
Forest West Grove,,,,,3.75
Lake Boating Center,,,,,3.73
Large Event Area,,,,,4.12
Main Dam,3.82,4.52,3.92,3.17,3.89
Main Pool,,,,4.08,4.23
Marshall Park,3.97,4.38,4.28,3.23,3.90
Model Airplane Field,,,4.37,3.91,4.31
Nature Preserve,,,,,4.55
Ned Brown Meadow,,3.54,3.90,4.21,2.98
North Pool,,4.38,4.42,3.76,4.64
Osborn Park,4.10,4.15,3.92,4.68,4.03
Salt Creek Trail,,,,,3.77
South Pool,4.90,3.41,4.55,4.44,4.01
Wildlife Refuge,,,4.03,4.01,4.82
Woodland Meadow,4.59,4.36,3.93,4.20,3.50
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.60100311 0.00600000 NUMb940_a1c7
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.58 | 4.43 | |||
| Beisner Road Entrance | 4.34 | 4.87 | 4.45 | 4.58 | 3.39 |
| Boat Launch Area | 4.31 | 3.92 | 4.77 | 4.59 | 3.28 |
| Busse Lake | 4.26 | 4.41 | 3.83 | 4.99 | 4.10 |
| Debra Park | 4.12 | ||||
| Elk Pasture | 4.11 | 3.96 | 4.46 | 4.13 | |
| Forest Central Grove | 3.96 | 4.27 | |||
| Forest North Grove | 3.33 | ||||
| Forest South Grove | 3.69 | 4.15 | 4.77 | 4.23 | 4.11 |
| Forest West Grove | 2.69 | ||||
| Lake Boating Center | 4.90 | 4.80 | 3.16 | 3.61 | 4.39 |
| Large Event Area | 4.64 | 3.60 | 4.93 | 4.27 | 3.99 |
| Main Dam | 3.09 | ||||
| Main Pool | 4.38 | 3.88 | 3.85 | 4.62 | 3.84 |
| Marshall Park | 3.55 | 4.41 | 4.24 | 3.45 | |
| Model Airplane Field | 4.25 | 4.06 | 4.83 | ||
| Nature Preserve | 4.94 | 4.44 | 4.56 | 4.49 | 4.43 |
| Ned Brown Meadow | 4.20 | 4.18 | 4.73 | ||
| North Pool | 3.96 | 4.23 | 4.89 | 4.34 | 4.10 |
| Osborn Park | 4.17 | 4.58 | |||
| Salt Creek Trail | 3.83 | 4.58 | 2.90 | 3.58 | 3.75 |
| South Pool | 3.54 | 3.16 | |||
| Wildlife Refuge | 4.47 | 3.92 | 3.99 | 4.68 | 3.66 |
| Woodland Meadow | 4.90 | 4.19 | 3.99 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,,3.58,4.43
Beisner Road Entrance,4.34,4.87,4.45,4.58,3.39
Boat Launch Area,4.31,3.92,4.77,4.59,3.28
Busse Lake,4.26,4.41,3.83,4.99,4.10
Debra Park,,,,,4.12
Elk Pasture,,4.11,3.96,4.46,4.13
Forest Central Grove,,,,3.96,4.27
Forest North Grove,,,,,3.33
Forest South Grove,3.69,4.15,4.77,4.23,4.11
Forest West Grove,,,,,2.69
Lake Boating Center,4.90,4.80,3.16,3.61,4.39
Large Event Area,4.64,3.60,4.93,4.27,3.99
Main Dam,,,,,3.09
Main Pool,4.38,3.88,3.85,4.62,3.84
Marshall Park,,3.55,4.41,4.24,3.45
Model Airplane Field,,,4.25,4.06,4.83
Nature Preserve,4.94,4.44,4.56,4.49,4.43
Ned Brown Meadow,,,4.20,4.18,4.73
North Pool,3.96,4.23,4.89,4.34,4.10
Osborn Park,,,,4.17,4.58
Salt Creek Trail,3.83,4.58,2.90,3.58,3.75
South Pool,,,,3.54,3.16
Wildlife Refuge,4.47,3.92,3.99,4.68,3.66
Woodland Meadow,,,4.90,4.19,3.99
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.09707910 0.00100000 NUM4b27_f976
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 4.00 | 3.01 | 4.11 | ||
| Beisner Road Entrance | 4.43 | 4.49 | 4.04 | ||
| Boat Launch Area | 3.88 | ||||
| Busse Lake | 4.03 | 4.61 | 3.69 | 3.57 | 4.39 |
| Debra Park | 4.80 | ||||
| Elk Pasture | 4.07 | 3.59 | 4.72 | 3.71 | |
| Forest Central Grove | 4.18 | 4.09 | |||
| Forest North Grove | 5.13 | 3.25 | |||
| Forest South Grove | 3.45 | 3.70 | 3.94 | 3.55 | |
| Forest West Grove | 4.16 | 4.72 | 4.15 | 3.74 | |
| Lake Boating Center | 4.70 | ||||
| Large Event Area | 4.84 | 4.25 | 3.49 | 4.41 | 4.40 |
| Main Dam | 4.06 | 4.41 | 4.51 | 4.15 | 3.44 |
| Main Pool | 4.12 | 4.16 | 4.46 | 4.14 | 3.76 |
| Marshall Park | 2.72 | 4.80 | 4.23 | 4.33 | 4.33 |
| Model Airplane Field | 4.74 | 3.82 | 4.89 | 3.13 | |
| Nature Preserve | 3.87 | ||||
| Ned Brown Meadow | 3.02 | 4.44 | 3.74 | ||
| North Pool | 4.48 | 3.93 | |||
| Osborn Park | 3.53 | 4.14 | |||
| Salt Creek Trail | 5.31 | 5.06 | 2.99 | 3.86 | 3.03 |
| South Pool | 4.05 | 3.95 | 4.28 | 3.60 | |
| Wildlife Refuge | 3.78 | 4.93 | 4.39 | 4.22 | 4.43 |
| Woodland Meadow | 4.35 | 4.01 | 4.57 | 4.10 | 4.32 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,4.00,3.01,4.11
Beisner Road Entrance,,,4.43,4.49,4.04
Boat Launch Area,,,,,3.88
Busse Lake,4.03,4.61,3.69,3.57,4.39
Debra Park,,,,,4.80
Elk Pasture,,4.07,3.59,4.72,3.71
Forest Central Grove,,,,4.18,4.09
Forest North Grove,,,,5.13,3.25
Forest South Grove,,3.45,3.70,3.94,3.55
Forest West Grove,,4.16,4.72,4.15,3.74
Lake Boating Center,,,,,4.70
Large Event Area,4.84,4.25,3.49,4.41,4.40
Main Dam,4.06,4.41,4.51,4.15,3.44
Main Pool,4.12,4.16,4.46,4.14,3.76
Marshall Park,2.72,4.80,4.23,4.33,4.33
Model Airplane Field,,4.74,3.82,4.89,3.13
Nature Preserve,,,,,3.87
Ned Brown Meadow,,,3.02,4.44,3.74
North Pool,,,,4.48,3.93
Osborn Park,,,,3.53,4.14
Salt Creek Trail,5.31,5.06,2.99,3.86,3.03
South Pool,,4.05,3.95,4.28,3.60
Wildlife Refuge,3.78,4.93,4.39,4.22,4.43
Woodland Meadow,4.35,4.01,4.57,4.10,4.32
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.11499410 0.00110000 NUM86b5_bf61
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.06 | 3.83 | 3.93 | 4.75 | |
| Beisner Road Entrance | 3.78 | 4.16 | |||
| Boat Launch Area | 4.13 | 3.31 | 3.02 | ||
| Busse Lake | 4.61 | 4.47 | 3.23 | 3.75 | |
| Debra Park | 4.78 | 3.49 | 4.83 | 3.86 | 4.23 |
| Elk Pasture | 3.62 | 3.64 | |||
| Forest Central Grove | 3.84 | 4.56 | 3.91 | 4.67 | 3.71 |
| Forest North Grove | 5.53 | 5.10 | 4.58 | ||
| Forest South Grove | 4.01 | 3.90 | 3.83 | ||
| Forest West Grove | 3.56 | 3.74 | 3.43 | 3.92 | |
| Lake Boating Center | 3.77 | 4.48 | 3.30 | ||
| Large Event Area | 3.37 | ||||
| Main Dam | 4.58 | 3.02 | 4.27 | 4.21 | 4.13 |
| Main Pool | 4.74 | 3.41 | |||
| Marshall Park | 2.81 | 4.02 | |||
| Model Airplane Field | 4.20 | 5.67 | 3.38 | 4.05 | 3.84 |
| Nature Preserve | 4.09 | ||||
| Ned Brown Meadow | 4.43 | 3.14 | 3.61 | 3.08 | |
| North Pool | 3.44 | 3.56 | 4.45 | 4.52 | 3.40 |
| Osborn Park | 4.15 | 5.13 | 4.16 | 4.06 | |
| Salt Creek Trail | 3.77 | ||||
| South Pool | 4.27 | 2.97 | 3.64 | 3.78 | 4.02 |
| Wildlife Refuge | 3.35 | ||||
| Woodland Meadow | 3.89 | 4.37 | 3.98 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,3.06,3.83,3.93,4.75
Beisner Road Entrance,,,,3.78,4.16
Boat Launch Area,,,4.13,3.31,3.02
Busse Lake,,4.61,4.47,3.23,3.75
Debra Park,4.78,3.49,4.83,3.86,4.23
Elk Pasture,,,,3.62,3.64
Forest Central Grove,3.84,4.56,3.91,4.67,3.71
Forest North Grove,,,5.53,5.10,4.58
Forest South Grove,,,4.01,3.90,3.83
Forest West Grove,,3.56,3.74,3.43,3.92
Lake Boating Center,,,3.77,4.48,3.30
Large Event Area,,,,,3.37
Main Dam,4.58,3.02,4.27,4.21,4.13
Main Pool,,,,4.74,3.41
Marshall Park,,,,2.81,4.02
Model Airplane Field,4.20,5.67,3.38,4.05,3.84
Nature Preserve,,,,,4.09
Ned Brown Meadow,,4.43,3.14,3.61,3.08
North Pool,3.44,3.56,4.45,4.52,3.40
Osborn Park,,4.15,5.13,4.16,4.06
Salt Creek Trail,,,,,3.77
South Pool,4.27,2.97,3.64,3.78,4.02
Wildlife Refuge,,,,,3.35
Woodland Meadow,,,3.89,4.37,3.98
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.42223369 0.00420000 NUMd2e8_bce2
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 4.14 | 4.60 | |||
| Beisner Road Entrance | 3.70 | ||||
| Boat Launch Area | 4.99 | 4.88 | 3.24 | ||
| Busse Lake | 4.31 | 4.48 | 3.61 | 3.25 | 4.43 |
| Debra Park | 4.23 | 4.36 | 3.66 | 3.94 | 3.30 |
| Elk Pasture | 3.84 | 3.32 | 4.12 | 4.82 | 3.70 |
| Forest Central Grove | 4.04 | ||||
| Forest North Grove | 4.27 | 3.03 | 5.32 | ||
| Forest South Grove | 4.36 | 3.99 | 4.10 | 3.33 | 3.92 |
| Forest West Grove | 4.89 | 4.35 | 4.36 | 3.48 | 4.58 |
| Lake Boating Center | 3.85 | 3.59 | 3.69 | 3.98 | 4.53 |
| Large Event Area | 4.14 | 4.48 | |||
| Main Dam | 4.54 | 4.00 | 3.03 | 4.69 | |
| Main Pool | 4.02 | 3.76 | |||
| Marshall Park | 3.56 | 4.70 | 3.03 | 4.19 | 4.42 |
| Model Airplane Field | 4.12 | ||||
| Nature Preserve | 4.16 | 3.18 | 4.08 | 3.98 | |
| Ned Brown Meadow | 3.79 | 4.13 | 4.50 | 4.31 | 3.43 |
| North Pool | 4.42 | ||||
| Osborn Park | 4.07 | 3.66 | 3.41 | 3.60 | 3.78 |
| Salt Creek Trail | 4.38 | 3.79 | |||
| South Pool | 3.87 | ||||
| Wildlife Refuge | 4.40 | 5.07 | 3.95 | 4.37 | 3.88 |
| Woodland Meadow | 3.48 | 4.54 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,,4.14,4.60
Beisner Road Entrance,,,,,3.70
Boat Launch Area,,,4.99,4.88,3.24
Busse Lake,4.31,4.48,3.61,3.25,4.43
Debra Park,4.23,4.36,3.66,3.94,3.30
Elk Pasture,3.84,3.32,4.12,4.82,3.70
Forest Central Grove,,,,,4.04
Forest North Grove,,,4.27,3.03,5.32
Forest South Grove,4.36,3.99,4.10,3.33,3.92
Forest West Grove,4.89,4.35,4.36,3.48,4.58
Lake Boating Center,3.85,3.59,3.69,3.98,4.53
Large Event Area,,,,4.14,4.48
Main Dam,,4.54,4.00,3.03,4.69
Main Pool,,,,4.02,3.76
Marshall Park,3.56,4.70,3.03,4.19,4.42
Model Airplane Field,,,,,4.12
Nature Preserve,,4.16,3.18,4.08,3.98
Ned Brown Meadow,3.79,4.13,4.50,4.31,3.43
North Pool,,,,,4.42
Osborn Park,4.07,3.66,3.41,3.60,3.78
Salt Creek Trail,,,,4.38,3.79
South Pool,,,,,3.87
Wildlife Refuge,4.40,5.07,3.95,4.37,3.88
Woodland Meadow,,,,3.48,4.54
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.44817916 0.00450000 NUMb2cc_67d1
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 4.05 | 3.77 | |||
| Beisner Road Entrance | 4.13 | 3.38 | 3.46 | ||
| Boat Launch Area | 4.25 | ||||
| Busse Lake | 3.45 | ||||
| Debra Park | 4.61 | 4.63 | 3.93 | 3.79 | |
| Elk Pasture | 5.35 | 3.97 | 4.14 | 4.25 | 3.91 |
| Forest Central Grove | 4.37 | 3.86 | 3.67 | 3.87 | 4.43 |
| Forest North Grove | 4.85 | 4.78 | 4.40 | ||
| Forest South Grove | 3.17 | 4.24 | 4.35 | ||
| Forest West Grove | 3.80 | 4.06 | 4.23 | 3.56 | 4.25 |
| Lake Boating Center | 3.79 | 3.17 | |||
| Large Event Area | 4.35 | 3.78 | 4.54 | 4.09 | 3.52 |
| Main Dam | 3.81 | 3.77 | 3.68 | ||
| Main Pool | 5.22 | 4.13 | 4.11 | 3.76 | 4.46 |
| Marshall Park | 4.24 | 3.78 | |||
| Model Airplane Field | 4.42 | 3.90 | 4.62 | 4.16 | |
| Nature Preserve | 4.14 | 3.19 | 4.02 | 3.71 | |
| Ned Brown Meadow | 2.70 | 5.11 | 4.89 | 4.22 | 3.22 |
| North Pool | 4.39 | 4.25 | 3.90 | 3.72 | 4.26 |
| Osborn Park | 4.74 | 3.59 | |||
| Salt Creek Trail | 4.24 | 3.97 | 3.54 | ||
| South Pool | 4.50 | ||||
| Wildlife Refuge | 4.47 | 4.35 | 3.22 | 3.80 | 4.04 |
| Woodland Meadow | 4.71 | 4.53 | 3.70 | 4.27 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,,4.05,3.77
Beisner Road Entrance,,,4.13,3.38,3.46
Boat Launch Area,,,,,4.25
Busse Lake,,,,,3.45
Debra Park,,4.61,4.63,3.93,3.79
Elk Pasture,5.35,3.97,4.14,4.25,3.91
Forest Central Grove,4.37,3.86,3.67,3.87,4.43
Forest North Grove,,,4.85,4.78,4.40
Forest South Grove,,,3.17,4.24,4.35
Forest West Grove,3.80,4.06,4.23,3.56,4.25
Lake Boating Center,,,,3.79,3.17
Large Event Area,4.35,3.78,4.54,4.09,3.52
Main Dam,,,3.81,3.77,3.68
Main Pool,5.22,4.13,4.11,3.76,4.46
Marshall Park,,,,4.24,3.78
Model Airplane Field,,4.42,3.90,4.62,4.16
Nature Preserve,,4.14,3.19,4.02,3.71
Ned Brown Meadow,2.70,5.11,4.89,4.22,3.22
North Pool,4.39,4.25,3.90,3.72,4.26
Osborn Park,,,,4.74,3.59
Salt Creek Trail,,,4.24,3.97,3.54
South Pool,,,,,4.50
Wildlife Refuge,4.47,4.35,3.22,3.80,4.04
Woodland Meadow,,4.71,4.53,3.70,4.27
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.12658691 0.00130000 NUM45f8_c706
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 4.86 | 3.63 | 4.31 | 3.67 | |
| Beisner Road Entrance | 3.49 | 4.31 | 3.69 | ||
| Boat Launch Area | 4.21 | 4.36 | 3.43 | 3.92 | 4.01 |
| Busse Lake | 3.87 | 3.32 | 3.22 | 4.16 | 4.03 |
| Debra Park | 4.39 | 3.85 | |||
| Elk Pasture | 4.32 | 4.10 | 4.91 | 4.61 | 4.17 |
| Forest Central Grove | 3.99 | 4.56 | 4.05 | 3.37 | 4.92 |
| Forest North Grove | 3.41 | 3.06 | 5.27 | 3.58 | 4.11 |
| Forest South Grove | 4.59 | ||||
| Forest West Grove | 3.83 | 3.85 | 4.10 | 3.67 | 4.20 |
| Lake Boating Center | 3.66 | 4.14 | |||
| Large Event Area | 5.30 | 3.41 | 3.51 | ||
| Main Dam | 4.04 | 4.18 | 4.42 | 3.63 | 3.83 |
| Main Pool | 3.99 | 4.17 | 4.41 | 3.67 | 3.85 |
| Marshall Park | 4.15 | 4.04 | 4.02 | 4.58 | 3.43 |
| Model Airplane Field | 3.06 | 3.67 | 5.00 | 3.60 | 4.60 |
| Nature Preserve | 4.74 | 3.92 | 4.03 | 4.19 | 4.25 |
| Ned Brown Meadow | 4.11 | ||||
| North Pool | 3.61 | 3.96 | 3.82 | 4.41 | |
| Osborn Park | 4.64 | 4.77 | 2.95 | 4.45 | 3.50 |
| Salt Creek Trail | 4.21 | 4.76 | 3.40 | 4.45 | |
| South Pool | 4.41 | 3.22 | 3.82 | 4.19 | 3.92 |
| Wildlife Refuge | 4.51 | 4.47 | |||
| Woodland Meadow | 3.25 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,4.86,3.63,4.31,3.67
Beisner Road Entrance,,,3.49,4.31,3.69
Boat Launch Area,4.21,4.36,3.43,3.92,4.01
Busse Lake,3.87,3.32,3.22,4.16,4.03
Debra Park,,,,4.39,3.85
Elk Pasture,4.32,4.10,4.91,4.61,4.17
Forest Central Grove,3.99,4.56,4.05,3.37,4.92
Forest North Grove,3.41,3.06,5.27,3.58,4.11
Forest South Grove,,,,,4.59
Forest West Grove,3.83,3.85,4.10,3.67,4.20
Lake Boating Center,,,,3.66,4.14
Large Event Area,,,5.30,3.41,3.51
Main Dam,4.04,4.18,4.42,3.63,3.83
Main Pool,3.99,4.17,4.41,3.67,3.85
Marshall Park,4.15,4.04,4.02,4.58,3.43
Model Airplane Field,3.06,3.67,5.00,3.60,4.60
Nature Preserve,4.74,3.92,4.03,4.19,4.25
Ned Brown Meadow,,,,,4.11
North Pool,,3.61,3.96,3.82,4.41
Osborn Park,4.64,4.77,2.95,4.45,3.50
Salt Creek Trail,,4.21,4.76,3.40,4.45
South Pool,4.41,3.22,3.82,4.19,3.92
Wildlife Refuge,,,,4.51,4.47
Woodland Meadow,,,,,3.25
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.83975057 0.00840000 NUMeecc_97c4
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.55 | ||||
| Beisner Road Entrance | 4.29 | 3.37 | 4.23 | 3.67 | |
| Boat Launch Area | 3.95 | 3.83 | 3.53 | ||
| Busse Lake | 4.25 | ||||
| Debra Park | 4.08 | 4.16 | 3.52 | 3.64 | |
| Elk Pasture | 3.98 | ||||
| Forest Central Grove | 4.25 | 5.15 | 3.88 | 3.62 | 4.21 |
| Forest North Grove | 3.63 | 4.19 | 4.94 | 3.83 | 4.18 |
| Forest South Grove | 4.39 | 3.67 | 3.52 | 3.40 | 3.81 |
| Forest West Grove | 5.12 | 4.01 | 4.02 | ||
| Lake Boating Center | 3.66 | 5.14 | 4.08 | 4.32 | 3.78 |
| Large Event Area | 5.22 | 3.58 | 4.62 | 4.04 | 4.09 |
| Main Dam | 4.45 | 4.41 | 4.01 | 3.96 | 4.44 |
| Main Pool | 4.24 | 3.25 | 3.80 | 4.49 | 4.19 |
| Marshall Park | 3.73 | 3.68 | 4.27 | 3.57 | 3.82 |
| Model Airplane Field | 3.06 | ||||
| Nature Preserve | 4.61 | 3.28 | 3.30 | 4.23 | 4.62 |
| Ned Brown Meadow | 3.41 | 4.43 | 4.70 | ||
| North Pool | 3.29 | 3.38 | |||
| Osborn Park | 4.16 | 2.85 | 4.05 | 3.71 | 3.85 |
| Salt Creek Trail | 3.69 | ||||
| South Pool | 4.52 | 3.64 | 5.03 | 3.85 | 3.59 |
| Wildlife Refuge | 4.02 | 4.72 | 4.03 | 4.20 | 3.96 |
| Woodland Meadow | 4.28 | 4.00 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,,,3.55
Beisner Road Entrance,,4.29,3.37,4.23,3.67
Boat Launch Area,,,3.95,3.83,3.53
Busse Lake,,,,,4.25
Debra Park,,4.08,4.16,3.52,3.64
Elk Pasture,,,,,3.98
Forest Central Grove,4.25,5.15,3.88,3.62,4.21
Forest North Grove,3.63,4.19,4.94,3.83,4.18
Forest South Grove,4.39,3.67,3.52,3.40,3.81
Forest West Grove,,,5.12,4.01,4.02
Lake Boating Center,3.66,5.14,4.08,4.32,3.78
Large Event Area,5.22,3.58,4.62,4.04,4.09
Main Dam,4.45,4.41,4.01,3.96,4.44
Main Pool,4.24,3.25,3.80,4.49,4.19
Marshall Park,3.73,3.68,4.27,3.57,3.82
Model Airplane Field,,,,,3.06
Nature Preserve,4.61,3.28,3.30,4.23,4.62
Ned Brown Meadow,,,3.41,4.43,4.70
North Pool,,,,3.29,3.38
Osborn Park,4.16,2.85,4.05,3.71,3.85
Salt Creek Trail,,,,,3.69
South Pool,4.52,3.64,5.03,3.85,3.59
Wildlife Refuge,4.02,4.72,4.03,4.20,3.96
Woodland Meadow,,,,4.28,4.00
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.36153061 0.00360000 NUM4c19_3cc6
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 4.44 | ||||
| Beisner Road Entrance | 3.29 | 4.47 | 3.52 | 3.69 | 3.64 |
| Boat Launch Area | 4.29 | 3.64 | 3.52 | ||
| Busse Lake | 4.09 | 4.27 | 4.82 | 4.33 | 4.18 |
| Debra Park | 3.74 | 3.37 | 3.70 | ||
| Elk Pasture | 4.53 | 3.86 | |||
| Forest Central Grove | 3.85 | 3.58 | |||
| Forest North Grove | 4.26 | 4.31 | 4.24 | 3.46 | 4.58 |
| Forest South Grove | 5.00 | 3.59 | 3.52 | 3.17 | 3.55 |
| Forest West Grove | 4.43 | 4.16 | 4.39 | 4.32 | |
| Lake Boating Center | 4.13 | ||||
| Large Event Area | 4.89 | 3.84 | 3.75 | 3.80 | 4.45 |
| Main Dam | 4.40 | 3.79 | 3.16 | 3.98 | |
| Main Pool | 4.38 | 2.75 | 4.82 | 4.08 | 3.59 |
| Marshall Park | 4.09 | 4.25 | 4.66 | 3.07 | 3.62 |
| Model Airplane Field | 3.64 | 3.55 | 3.77 | 3.61 | |
| Nature Preserve | 3.24 | 4.58 | 4.40 | 4.23 | 4.16 |
| Ned Brown Meadow | 4.18 | 4.31 | 3.98 | 4.84 | 3.43 |
| North Pool | 4.14 | ||||
| Osborn Park | 3.71 | 4.58 | 3.76 | 3.67 | 4.06 |
| Salt Creek Trail | 3.87 | 4.07 | 3.81 | 3.80 | 3.95 |
| South Pool | 3.97 | 4.19 | 3.57 | 3.86 | 3.88 |
| Wildlife Refuge | 4.06 | 4.58 | 4.28 | 4.57 | 3.94 |
| Woodland Meadow | 2.30 | 3.91 | 4.62 | 5.33 | 3.51 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,,,4.44
Beisner Road Entrance,3.29,4.47,3.52,3.69,3.64
Boat Launch Area,,,4.29,3.64,3.52
Busse Lake,4.09,4.27,4.82,4.33,4.18
Debra Park,,,3.74,3.37,3.70
Elk Pasture,,,,4.53,3.86
Forest Central Grove,,,,3.85,3.58
Forest North Grove,4.26,4.31,4.24,3.46,4.58
Forest South Grove,5.00,3.59,3.52,3.17,3.55
Forest West Grove,,4.43,4.16,4.39,4.32
Lake Boating Center,,,,,4.13
Large Event Area,4.89,3.84,3.75,3.80,4.45
Main Dam,,4.40,3.79,3.16,3.98
Main Pool,4.38,2.75,4.82,4.08,3.59
Marshall Park,4.09,4.25,4.66,3.07,3.62
Model Airplane Field,,3.64,3.55,3.77,3.61
Nature Preserve,3.24,4.58,4.40,4.23,4.16
Ned Brown Meadow,4.18,4.31,3.98,4.84,3.43
North Pool,,,,,4.14
Osborn Park,3.71,4.58,3.76,3.67,4.06
Salt Creek Trail,3.87,4.07,3.81,3.80,3.95
South Pool,3.97,4.19,3.57,3.86,3.88
Wildlife Refuge,4.06,4.58,4.28,4.57,3.94
Woodland Meadow,2.30,3.91,4.62,5.33,3.51
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.61173929 0.00610000 NUMbc86_9a77
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.46 | 4.23 | |||
| Beisner Road Entrance | 2.85 | 3.12 | 4.09 | 4.19 | |
| Boat Launch Area | 3.55 | 3.55 | 3.61 | 4.32 | 3.71 |
| Busse Lake | 4.18 | ||||
| Debra Park | 3.19 | 3.86 | 3.71 | ||
| Elk Pasture | 4.04 | 3.84 | 3.84 | 3.95 | 3.73 |
| Forest Central Grove | 3.89 | 4.63 | 4.01 | 4.37 | 4.10 |
| Forest North Grove | 3.54 | 3.28 | 4.26 | 3.25 | |
| Forest South Grove | 4.37 | 3.55 | 4.25 | 2.75 | 4.50 |
| Forest West Grove | 4.08 | ||||
| Lake Boating Center | 3.53 | 3.31 | 4.12 | 3.24 | 3.77 |
| Large Event Area | 5.02 | 4.00 | 4.65 | 3.50 | 3.92 |
| Main Dam | 4.00 | 3.46 | 4.65 | 4.23 | |
| Main Pool | 4.38 | ||||
| Marshall Park | 4.35 | 4.28 | 4.35 | 5.09 | 3.59 |
| Model Airplane Field | 3.52 | 4.15 | 3.71 | ||
| Nature Preserve | 4.60 | 3.25 | |||
| Ned Brown Meadow | 5.03 | 3.83 | 3.40 | ||
| North Pool | 4.34 | 3.28 | |||
| Osborn Park | 3.39 | 3.84 | 4.59 | 3.84 | 4.03 |
| Salt Creek Trail | 4.56 | 3.31 | 4.19 | 4.36 | 3.50 |
| South Pool | 3.76 | 4.11 | 4.48 | 4.09 | 3.29 |
| Wildlife Refuge | 4.63 | ||||
| Woodland Meadow | 4.12 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,,3.46,4.23
Beisner Road Entrance,,2.85,3.12,4.09,4.19
Boat Launch Area,3.55,3.55,3.61,4.32,3.71
Busse Lake,,,,,4.18
Debra Park,,,3.19,3.86,3.71
Elk Pasture,4.04,3.84,3.84,3.95,3.73
Forest Central Grove,3.89,4.63,4.01,4.37,4.10
Forest North Grove,,3.54,3.28,4.26,3.25
Forest South Grove,4.37,3.55,4.25,2.75,4.50
Forest West Grove,,,,,4.08
Lake Boating Center,3.53,3.31,4.12,3.24,3.77
Large Event Area,5.02,4.00,4.65,3.50,3.92
Main Dam,,4.00,3.46,4.65,4.23
Main Pool,,,,,4.38
Marshall Park,4.35,4.28,4.35,5.09,3.59
Model Airplane Field,,,3.52,4.15,3.71
Nature Preserve,,,,4.60,3.25
Ned Brown Meadow,,,5.03,3.83,3.40
North Pool,,,,4.34,3.28
Osborn Park,3.39,3.84,4.59,3.84,4.03
Salt Creek Trail,4.56,3.31,4.19,4.36,3.50
South Pool,3.76,4.11,4.48,4.09,3.29
Wildlife Refuge,,,,,4.63
Woodland Meadow,,,,,4.12
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.46646762 0.00470000 NUMdebb_066c
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 4.04 | 4.76 | |||
| Beisner Road Entrance | 4.16 | 4.37 | 4.21 | ||
| Boat Launch Area | 4.55 | 3.93 | |||
| Busse Lake | 3.84 | 4.09 | 4.44 | 3.36 | |
| Debra Park | 3.78 | 3.89 | 3.31 | 4.03 | 4.10 |
| Elk Pasture | 3.83 | 3.32 | 4.04 | 3.67 | 3.47 |
| Forest Central Grove | 4.72 | 3.96 | 4.37 | 3.31 | 3.77 |
| Forest North Grove | 3.46 | 4.23 | 4.54 | 4.16 | 4.49 |
| Forest South Grove | 4.49 | 4.36 | 4.27 | 4.17 | 4.11 |
| Forest West Grove | 4.30 | 3.42 | 3.34 | ||
| Lake Boating Center | 4.46 | 3.39 | |||
| Large Event Area | 4.37 | ||||
| Main Dam | 4.46 | 3.51 | 4.45 | 4.14 | 3.89 |
| Main Pool | 3.57 | 4.41 | 3.84 | 4.29 | 3.78 |
| Marshall Park | 3.98 | ||||
| Model Airplane Field | 3.90 | ||||
| Nature Preserve | 4.34 | ||||
| Ned Brown Meadow | 3.34 | 4.01 | 3.18 | 4.05 | 3.06 |
| North Pool | 3.86 | 3.93 | 4.17 | 4.41 | 4.48 |
| Osborn Park | 3.84 | 4.62 | 3.67 | 4.97 | 3.63 |
| Salt Creek Trail | 4.86 | 3.09 | 4.65 | 4.24 | 4.19 |
| South Pool | 4.33 | 4.11 | 4.10 | 4.20 | 3.59 |
| Wildlife Refuge | 3.57 | 4.76 | 4.36 | 4.00 | |
| Woodland Meadow | 3.63 | 4.30 | 3.65 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,,4.04,4.76
Beisner Road Entrance,,,4.16,4.37,4.21
Boat Launch Area,,,,4.55,3.93
Busse Lake,,3.84,4.09,4.44,3.36
Debra Park,3.78,3.89,3.31,4.03,4.10
Elk Pasture,3.83,3.32,4.04,3.67,3.47
Forest Central Grove,4.72,3.96,4.37,3.31,3.77
Forest North Grove,3.46,4.23,4.54,4.16,4.49
Forest South Grove,4.49,4.36,4.27,4.17,4.11
Forest West Grove,,,4.30,3.42,3.34
Lake Boating Center,,,,4.46,3.39
Large Event Area,,,,,4.37
Main Dam,4.46,3.51,4.45,4.14,3.89
Main Pool,3.57,4.41,3.84,4.29,3.78
Marshall Park,,,,,3.98
Model Airplane Field,,,,,3.90
Nature Preserve,,,,,4.34
Ned Brown Meadow,3.34,4.01,3.18,4.05,3.06
North Pool,3.86,3.93,4.17,4.41,4.48
Osborn Park,3.84,4.62,3.67,4.97,3.63
Salt Creek Trail,4.86,3.09,4.65,4.24,4.19
South Pool,4.33,4.11,4.10,4.20,3.59
Wildlife Refuge,,3.57,4.76,4.36,4.00
Woodland Meadow,,,3.63,4.30,3.65
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.24151955 0.00240000 NUM01e9_4926
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.66 | 4.01 | |||
| Beisner Road Entrance | 3.62 | ||||
| Boat Launch Area | 3.75 | 5.14 | 3.62 | 3.77 | 4.26 |
| Busse Lake | 4.26 | 3.61 | 4.09 | 4.02 | |
| Debra Park | 4.25 | ||||
| Elk Pasture | 4.38 | 4.73 | |||
| Forest Central Grove | 4.01 | ||||
| Forest North Grove | 2.82 | 4.27 | 4.62 | 3.54 | |
| Forest South Grove | 3.89 | ||||
| Forest West Grove | 3.66 | 2.78 | 4.10 | 3.46 | 3.97 |
| Lake Boating Center | 4.21 | 4.77 | 4.26 | 3.88 | 4.63 |
| Large Event Area | 3.45 | 4.04 | 3.32 | 4.11 | |
| Main Dam | 4.12 | 3.75 | 4.30 | 3.69 | 4.62 |
| Main Pool | 3.50 | 4.64 | 3.88 | 3.66 | 3.37 |
| Marshall Park | 3.76 | 4.56 | 4.00 | ||
| Model Airplane Field | 3.86 | 4.31 | 4.05 | 3.80 | |
| Nature Preserve | 4.77 | ||||
| Ned Brown Meadow | 3.57 | 4.16 | 4.48 | ||
| North Pool | 3.53 | 3.77 | |||
| Osborn Park | 4.34 | 3.72 | 4.39 | ||
| Salt Creek Trail | 3.39 | 3.39 | |||
| South Pool | 4.64 | 3.28 | 4.25 | 4.24 | 4.28 |
| Wildlife Refuge | 5.00 | 3.29 | |||
| Woodland Meadow | 4.01 | 3.48 | 4.36 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,,3.66,4.01
Beisner Road Entrance,,,,,3.62
Boat Launch Area,3.75,5.14,3.62,3.77,4.26
Busse Lake,,4.26,3.61,4.09,4.02
Debra Park,,,,,4.25
Elk Pasture,,,,4.38,4.73
Forest Central Grove,,,,,4.01
Forest North Grove,,2.82,4.27,4.62,3.54
Forest South Grove,,,,,3.89
Forest West Grove,3.66,2.78,4.10,3.46,3.97
Lake Boating Center,4.21,4.77,4.26,3.88,4.63
Large Event Area,,3.45,4.04,3.32,4.11
Main Dam,4.12,3.75,4.30,3.69,4.62
Main Pool,3.50,4.64,3.88,3.66,3.37
Marshall Park,,,3.76,4.56,4.00
Model Airplane Field,,3.86,4.31,4.05,3.80
Nature Preserve,,,,,4.77
Ned Brown Meadow,,,3.57,4.16,4.48
North Pool,,,,3.53,3.77
Osborn Park,,,4.34,3.72,4.39
Salt Creek Trail,,,,3.39,3.39
South Pool,4.64,3.28,4.25,4.24,4.28
Wildlife Refuge,,,,5.00,3.29
Woodland Meadow,,,4.01,3.48,4.36
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.82867988 0.00830000 NUMda8a_c728
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 4.74 | 4.17 | 4.48 | 3.79 | 4.11 |
| Beisner Road Entrance | 3.98 | ||||
| Boat Launch Area | 4.04 | 4.05 | |||
| Busse Lake | 3.44 | 4.40 | 3.53 | 3.10 | 3.55 |
| Debra Park | 4.60 | 4.37 | 3.81 | 3.72 | 3.44 |
| Elk Pasture | 5.07 | 4.62 | 4.82 | 3.66 | 4.62 |
| Forest Central Grove | 5.65 | 3.66 | 3.53 | 3.91 | |
| Forest North Grove | 3.70 | ||||
| Forest South Grove | 4.55 | 3.89 | 3.99 | 4.14 | 3.70 |
| Forest West Grove | 4.47 | 4.88 | 4.39 | 3.87 | |
| Lake Boating Center | 4.94 | ||||
| Large Event Area | 4.78 | 4.39 | 3.89 | 3.68 | 4.83 |
| Main Dam | 4.23 | ||||
| Main Pool | 4.32 | 4.18 | |||
| Marshall Park | 4.05 | 4.37 | 4.02 | ||
| Model Airplane Field | 3.18 | ||||
| Nature Preserve | 3.80 | 4.29 | 4.05 | 4.25 | |
| Ned Brown Meadow | 4.19 | 3.57 | 4.19 | 3.57 | |
| North Pool | 4.64 | 4.22 | 3.93 | ||
| Osborn Park | 3.67 | 4.87 | 3.93 | 4.03 | 3.57 |
| Salt Creek Trail | 3.37 | 4.30 | 3.88 | 4.37 | 3.25 |
| South Pool | 3.40 | 4.01 | 4.11 | 4.02 | |
| Wildlife Refuge | 4.19 | 4.12 | 3.54 | ||
| Woodland Meadow | 3.65 | 3.76 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.74,4.17,4.48,3.79,4.11
Beisner Road Entrance,,,,,3.98
Boat Launch Area,,,,4.04,4.05
Busse Lake,3.44,4.40,3.53,3.10,3.55
Debra Park,4.60,4.37,3.81,3.72,3.44
Elk Pasture,5.07,4.62,4.82,3.66,4.62
Forest Central Grove,,5.65,3.66,3.53,3.91
Forest North Grove,,,,,3.70
Forest South Grove,4.55,3.89,3.99,4.14,3.70
Forest West Grove,,4.47,4.88,4.39,3.87
Lake Boating Center,,,,,4.94
Large Event Area,4.78,4.39,3.89,3.68,4.83
Main Dam,,,,,4.23
Main Pool,,,,4.32,4.18
Marshall Park,,,4.05,4.37,4.02
Model Airplane Field,,,,,3.18
Nature Preserve,,3.80,4.29,4.05,4.25
Ned Brown Meadow,,4.19,3.57,4.19,3.57
North Pool,,,4.64,4.22,3.93
Osborn Park,3.67,4.87,3.93,4.03,3.57
Salt Creek Trail,3.37,4.30,3.88,4.37,3.25
South Pool,,3.40,4.01,4.11,4.02
Wildlife Refuge,,,4.19,4.12,3.54
Woodland Meadow,,,,3.65,3.76
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.05848586 0.00100000 NUMa082_a594
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 4.92 | 4.04 | 4.64 | ||
| Beisner Road Entrance | 4.23 | 4.90 | 3.86 | 3.38 | 4.79 |
| Boat Launch Area | 4.13 | 3.34 | |||
| Busse Lake | 3.46 | 4.29 | |||
| Debra Park | 4.08 | 3.59 | 3.74 | 4.30 | |
| Elk Pasture | 3.46 | 4.20 | 3.57 | 4.56 | |
| Forest Central Grove | 3.43 | 3.86 | |||
| Forest North Grove | 3.80 | 4.09 | 5.20 | 4.50 | 4.08 |
| Forest South Grove | 4.16 | ||||
| Forest West Grove | 4.81 | 3.94 | 4.18 | 3.27 | 4.19 |
| Lake Boating Center | 3.81 | ||||
| Large Event Area | 3.91 | 3.95 | 4.58 | 4.10 | 4.78 |
| Main Dam | 4.23 | 4.22 | |||
| Main Pool | 4.28 | 3.71 | 3.72 | 4.69 | 3.86 |
| Marshall Park | 4.11 | 3.90 | 4.38 | 3.55 | |
| Model Airplane Field | 3.78 | ||||
| Nature Preserve | 3.66 | 4.28 | 4.52 | 4.20 | |
| Ned Brown Meadow | 4.93 | 3.47 | 4.58 | 4.15 | |
| North Pool | 4.05 | ||||
| Osborn Park | 4.91 | 3.86 | |||
| Salt Creek Trail | 3.94 | 3.54 | 4.39 | 3.78 | 3.67 |
| South Pool | 2.70 | 4.18 | 4.04 | ||
| Wildlife Refuge | 5.54 | 4.13 | 4.28 | 4.18 | 4.08 |
| Woodland Meadow | 4.43 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,4.92,4.04,4.64
Beisner Road Entrance,4.23,4.90,3.86,3.38,4.79
Boat Launch Area,,,,4.13,3.34
Busse Lake,,,,3.46,4.29
Debra Park,,4.08,3.59,3.74,4.30
Elk Pasture,,3.46,4.20,3.57,4.56
Forest Central Grove,,,,3.43,3.86
Forest North Grove,3.80,4.09,5.20,4.50,4.08
Forest South Grove,,,,,4.16
Forest West Grove,4.81,3.94,4.18,3.27,4.19
Lake Boating Center,,,,,3.81
Large Event Area,3.91,3.95,4.58,4.10,4.78
Main Dam,,,,4.23,4.22
Main Pool,4.28,3.71,3.72,4.69,3.86
Marshall Park,,4.11,3.90,4.38,3.55
Model Airplane Field,,,,,3.78
Nature Preserve,,3.66,4.28,4.52,4.20
Ned Brown Meadow,,4.93,3.47,4.58,4.15
North Pool,,,,,4.05
Osborn Park,,,,4.91,3.86
Salt Creek Trail,3.94,3.54,4.39,3.78,3.67
South Pool,,,2.70,4.18,4.04
Wildlife Refuge,5.54,4.13,4.28,4.18,4.08
Woodland Meadow,,,,,4.43
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.68833440 0.00690000 NUM83d0_08d7
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 4.55 | 3.72 | 5.01 | 3.63 | 4.40 |
| Beisner Road Entrance | 3.98 | 4.18 | |||
| Boat Launch Area | 3.75 | 4.48 | 4.52 | 4.51 | |
| Busse Lake | 4.49 | 4.85 | 4.65 | 4.32 | 3.81 |
| Debra Park | 4.55 | 4.31 | 3.97 | 5.06 | 3.48 |
| Elk Pasture | 4.76 | 4.86 | 3.50 | 4.17 | |
| Forest Central Grove | 4.45 | 5.08 | 4.34 | 4.12 | 3.08 |
| Forest North Grove | 3.92 | ||||
| Forest South Grove | 4.64 | 3.97 | 3.25 | 4.01 | 2.80 |
| Forest West Grove | 3.89 | 4.09 | 4.29 | 4.29 | 4.06 |
| Lake Boating Center | 4.52 | 3.46 | 4.35 | 4.37 | |
| Large Event Area | 3.66 | 5.10 | 3.74 | ||
| Main Dam | 4.01 | 4.61 | |||
| Main Pool | 3.25 | 4.16 | 3.58 | ||
| Marshall Park | 4.46 | 3.93 | 4.08 | 3.97 | 4.77 |
| Model Airplane Field | 3.79 | 3.44 | 4.47 | ||
| Nature Preserve | 3.78 | 3.77 | |||
| Ned Brown Meadow | 4.45 | 4.72 | 4.90 | 4.45 | 4.41 |
| North Pool | 3.65 | 3.76 | |||
| Osborn Park | 3.96 | ||||
| Salt Creek Trail | 4.25 | 3.22 | 4.34 | ||
| South Pool | 4.14 | 5.03 | 4.12 | 3.32 | 4.12 |
| Wildlife Refuge | 3.93 | 4.09 | 4.14 | 3.78 | 4.21 |
| Woodland Meadow | 3.34 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.55,3.72,5.01,3.63,4.40
Beisner Road Entrance,,,,3.98,4.18
Boat Launch Area,,3.75,4.48,4.52,4.51
Busse Lake,4.49,4.85,4.65,4.32,3.81
Debra Park,4.55,4.31,3.97,5.06,3.48
Elk Pasture,,4.76,4.86,3.50,4.17
Forest Central Grove,4.45,5.08,4.34,4.12,3.08
Forest North Grove,,,,,3.92
Forest South Grove,4.64,3.97,3.25,4.01,2.80
Forest West Grove,3.89,4.09,4.29,4.29,4.06
Lake Boating Center,,4.52,3.46,4.35,4.37
Large Event Area,,,3.66,5.10,3.74
Main Dam,,,,4.01,4.61
Main Pool,,,3.25,4.16,3.58
Marshall Park,4.46,3.93,4.08,3.97,4.77
Model Airplane Field,,,3.79,3.44,4.47
Nature Preserve,,,,3.78,3.77
Ned Brown Meadow,4.45,4.72,4.90,4.45,4.41
North Pool,,,,3.65,3.76
Osborn Park,,,,,3.96
Salt Creek Trail,,,4.25,3.22,4.34
South Pool,4.14,5.03,4.12,3.32,4.12
Wildlife Refuge,3.93,4.09,4.14,3.78,4.21
Woodland Meadow,,,,,3.34
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.09830206 0.00100000 NUMd4e8_1f07
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 4.30 | 4.79 | 3.77 | ||
| Beisner Road Entrance | 4.87 | 4.20 | 4.08 | 3.87 | 4.58 |
| Boat Launch Area | 3.45 | 4.11 | |||
| Busse Lake | 4.75 | 4.55 | 3.77 | ||
| Debra Park | 4.44 | 3.15 | |||
| Elk Pasture | 2.82 | 4.53 | 4.14 | 3.95 | 3.77 |
| Forest Central Grove | 3.47 | ||||
| Forest North Grove | 3.89 | 4.41 | 3.51 | 3.53 | 3.56 |
| Forest South Grove | 3.87 | 4.42 | 3.79 | 4.75 | 3.58 |
| Forest West Grove | 3.81 | 3.84 | 3.96 | 4.80 | 3.26 |
| Lake Boating Center | 3.88 | 3.49 | 3.96 | 3.71 | 3.91 |
| Large Event Area | 3.05 | 4.38 | 3.77 | 3.72 | |
| Main Dam | 4.28 | 3.80 | 3.61 | ||
| Main Pool | 4.40 | ||||
| Marshall Park | 4.50 | 4.57 | |||
| Model Airplane Field | 4.36 | 3.91 | |||
| Nature Preserve | 4.18 | 4.13 | 4.04 | 4.44 | |
| Ned Brown Meadow | 4.10 | 3.68 | 4.16 | 4.48 | 3.88 |
| North Pool | 4.19 | 4.93 | 4.02 | 3.60 | 3.59 |
| Osborn Park | 4.07 | 3.76 | |||
| Salt Creek Trail | 4.20 | ||||
| South Pool | 4.08 | 3.43 | 3.88 | 2.44 | 3.44 |
| Wildlife Refuge | 3.91 | 4.37 | 3.69 | 4.29 | 4.27 |
| Woodland Meadow | 4.44 | 4.40 | 3.60 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,4.30,4.79,3.77
Beisner Road Entrance,4.87,4.20,4.08,3.87,4.58
Boat Launch Area,,,,3.45,4.11
Busse Lake,,,4.75,4.55,3.77
Debra Park,,,,4.44,3.15
Elk Pasture,2.82,4.53,4.14,3.95,3.77
Forest Central Grove,,,,,3.47
Forest North Grove,3.89,4.41,3.51,3.53,3.56
Forest South Grove,3.87,4.42,3.79,4.75,3.58
Forest West Grove,3.81,3.84,3.96,4.80,3.26
Lake Boating Center,3.88,3.49,3.96,3.71,3.91
Large Event Area,,3.05,4.38,3.77,3.72
Main Dam,,,4.28,3.80,3.61
Main Pool,,,,,4.40
Marshall Park,,,,4.50,4.57
Model Airplane Field,,,,4.36,3.91
Nature Preserve,,4.18,4.13,4.04,4.44
Ned Brown Meadow,4.10,3.68,4.16,4.48,3.88
North Pool,4.19,4.93,4.02,3.60,3.59
Osborn Park,,,,4.07,3.76
Salt Creek Trail,,,,,4.20
South Pool,4.08,3.43,3.88,2.44,3.44
Wildlife Refuge,3.91,4.37,3.69,4.29,4.27
Woodland Meadow,,,4.44,4.40,3.60
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.41118231 0.00410000 NUM1ab6_8f93
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.82 | 4.26 | 4.08 | ||
| Beisner Road Entrance | 4.14 | 4.51 | 3.24 | 3.66 | |
| Boat Launch Area | 3.76 | 4.36 | 4.62 | 3.59 | 3.83 |
| Busse Lake | 5.53 | 3.35 | 4.31 | 3.11 | |
| Debra Park | 3.72 | 3.66 | 3.97 | 4.04 | 4.37 |
| Elk Pasture | 4.41 | 4.49 | 3.28 | ||
| Forest Central Grove | 4.16 | 3.23 | 3.96 | ||
| Forest North Grove | 5.14 | 5.20 | 3.81 | 4.67 | 3.35 |
| Forest South Grove | 4.51 | 3.87 | 3.79 | 3.51 | 3.83 |
| Forest West Grove | 3.78 | 4.64 | 3.92 | 4.04 | |
| Lake Boating Center | 3.82 | 2.98 | 4.34 | 4.17 | 3.60 |
| Large Event Area | 5.24 | 3.45 | |||
| Main Dam | 4.12 | 3.75 | 4.16 | ||
| Main Pool | 4.51 | 4.64 | 4.32 | ||
| Marshall Park | 3.12 | ||||
| Model Airplane Field | 4.63 | ||||
| Nature Preserve | 4.41 | 3.82 | 4.00 | 3.47 | 4.14 |
| Ned Brown Meadow | 4.19 | 3.84 | |||
| North Pool | 3.59 | 2.86 | 3.67 | 3.99 | |
| Osborn Park | 3.62 | 3.85 | 5.28 | 4.10 | 3.25 |
| Salt Creek Trail | 4.84 | ||||
| South Pool | 4.47 | 3.81 | 3.79 | 4.39 | 4.42 |
| Wildlife Refuge | 3.28 | 4.46 | 4.35 | 4.76 | 3.54 |
| Woodland Meadow | 4.52 | 3.49 | 3.79 | 3.61 | 4.19 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,3.82,4.26,4.08
Beisner Road Entrance,,4.14,4.51,3.24,3.66
Boat Launch Area,3.76,4.36,4.62,3.59,3.83
Busse Lake,,5.53,3.35,4.31,3.11
Debra Park,3.72,3.66,3.97,4.04,4.37
Elk Pasture,,,4.41,4.49,3.28
Forest Central Grove,,,4.16,3.23,3.96
Forest North Grove,5.14,5.20,3.81,4.67,3.35
Forest South Grove,4.51,3.87,3.79,3.51,3.83
Forest West Grove,,3.78,4.64,3.92,4.04
Lake Boating Center,3.82,2.98,4.34,4.17,3.60
Large Event Area,,,,5.24,3.45
Main Dam,,,4.12,3.75,4.16
Main Pool,,,4.51,4.64,4.32
Marshall Park,,,,,3.12
Model Airplane Field,,,,,4.63
Nature Preserve,4.41,3.82,4.00,3.47,4.14
Ned Brown Meadow,,,,4.19,3.84
North Pool,,3.59,2.86,3.67,3.99
Osborn Park,3.62,3.85,5.28,4.10,3.25
Salt Creek Trail,,,,,4.84
South Pool,4.47,3.81,3.79,4.39,4.42
Wildlife Refuge,3.28,4.46,4.35,4.76,3.54
Woodland Meadow,4.52,3.49,3.79,3.61,4.19
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.60818154 0.00610000 NUM4150_3f5f
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 4.94 | 4.42 | 4.25 | ||
| Beisner Road Entrance | 4.11 | ||||
| Boat Launch Area | 4.03 | 4.11 | 3.61 | 3.04 | 4.68 |
| Busse Lake | 4.64 | 5.43 | 3.90 | 4.10 | 3.02 |
| Debra Park | 4.48 | 4.39 | 3.19 | 3.57 | 3.31 |
| Elk Pasture | 3.88 | ||||
| Forest Central Grove | 4.21 | 3.89 | 4.32 | 4.46 | |
| Forest North Grove | 4.29 | 5.40 | 3.77 | 3.79 | 4.01 |
| Forest South Grove | 3.67 | 3.30 | |||
| Forest West Grove | 2.81 | ||||
| Lake Boating Center | 4.12 | ||||
| Large Event Area | 3.54 | 4.64 | 4.24 | 4.00 | |
| Main Dam | 4.65 | 4.29 | 3.68 | 3.88 | 4.63 |
| Main Pool | 3.73 | 4.55 | 3.44 | 3.76 | |
| Marshall Park | 4.72 | 3.96 | 3.87 | ||
| Model Airplane Field | 4.50 | 4.24 | 4.02 | ||
| Nature Preserve | 4.56 | 4.05 | |||
| Ned Brown Meadow | 3.81 | ||||
| North Pool | 4.57 | 4.53 | |||
| Osborn Park | 4.01 | 3.84 | 3.81 | ||
| Salt Creek Trail | 3.53 | 3.44 | 4.67 | 3.37 | 4.01 |
| South Pool | 3.71 | 4.26 | 4.33 | 3.60 | |
| Wildlife Refuge | 4.06 | 4.62 | |||
| Woodland Meadow | 3.30 | 4.77 | 4.02 | 4.00 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,4.94,4.42,4.25
Beisner Road Entrance,,,,,4.11
Boat Launch Area,4.03,4.11,3.61,3.04,4.68
Busse Lake,4.64,5.43,3.90,4.10,3.02
Debra Park,4.48,4.39,3.19,3.57,3.31
Elk Pasture,,,,,3.88
Forest Central Grove,,4.21,3.89,4.32,4.46
Forest North Grove,4.29,5.40,3.77,3.79,4.01
Forest South Grove,,,,3.67,3.30
Forest West Grove,,,,,2.81
Lake Boating Center,,,,,4.12
Large Event Area,,3.54,4.64,4.24,4.00
Main Dam,4.65,4.29,3.68,3.88,4.63
Main Pool,,3.73,4.55,3.44,3.76
Marshall Park,,,4.72,3.96,3.87
Model Airplane Field,,,4.50,4.24,4.02
Nature Preserve,,,,4.56,4.05
Ned Brown Meadow,,,,,3.81
North Pool,,,,4.57,4.53
Osborn Park,,,4.01,3.84,3.81
Salt Creek Trail,3.53,3.44,4.67,3.37,4.01
South Pool,,3.71,4.26,4.33,3.60
Wildlife Refuge,,,,4.06,4.62
Woodland Meadow,,3.30,4.77,4.02,4.00
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.37729050 0.00380000 NUMb1d8_6da0
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 4.12 | 4.55 | 3.68 | 4.11 | 4.11 |
| Beisner Road Entrance | 4.33 | ||||
| Boat Launch Area | 4.22 | 3.52 | 3.37 | 3.79 | 3.71 |
| Busse Lake | 3.35 | 4.15 | 3.27 | 4.16 | |
| Debra Park | 4.42 | 2.68 | 3.72 | ||
| Elk Pasture | 4.50 | 4.09 | 2.42 | ||
| Forest Central Grove | 3.25 | ||||
| Forest North Grove | 3.52 | 4.47 | |||
| Forest South Grove | 5.23 | 4.13 | |||
| Forest West Grove | 4.29 | 3.17 | 3.58 | 3.84 | 3.45 |
| Lake Boating Center | 4.08 | 3.94 | 5.45 | 3.95 | |
| Large Event Area | 4.23 | ||||
| Main Dam | 4.02 | 3.67 | 4.70 | 4.41 | 4.45 |
| Main Pool | 3.80 | 4.23 | 2.85 | 3.77 | 3.61 |
| Marshall Park | 4.98 | 4.53 | 3.95 | 3.77 | 3.88 |
| Model Airplane Field | 3.95 | 3.66 | 3.84 | 3.28 | |
| Nature Preserve | 4.01 | ||||
| Ned Brown Meadow | 3.80 | 4.00 | |||
| North Pool | 3.55 | 3.02 | 3.72 | 3.97 | 4.02 |
| Osborn Park | 4.93 | 4.06 | |||
| Salt Creek Trail | 4.05 | 4.20 | 4.74 | 4.63 | 4.44 |
| South Pool | 3.57 | 3.85 | 4.94 | 3.89 | 3.89 |
| Wildlife Refuge | 3.63 | 3.24 | 3.97 | 4.27 | |
| Woodland Meadow | 4.79 | 4.56 | 4.15 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.12,4.55,3.68,4.11,4.11
Beisner Road Entrance,,,,,4.33
Boat Launch Area,4.22,3.52,3.37,3.79,3.71
Busse Lake,,3.35,4.15,3.27,4.16
Debra Park,,,4.42,2.68,3.72
Elk Pasture,,,4.50,4.09,2.42
Forest Central Grove,,,,,3.25
Forest North Grove,,,,3.52,4.47
Forest South Grove,,,,5.23,4.13
Forest West Grove,4.29,3.17,3.58,3.84,3.45
Lake Boating Center,,4.08,3.94,5.45,3.95
Large Event Area,,,,,4.23
Main Dam,4.02,3.67,4.70,4.41,4.45
Main Pool,3.80,4.23,2.85,3.77,3.61
Marshall Park,4.98,4.53,3.95,3.77,3.88
Model Airplane Field,,3.95,3.66,3.84,3.28
Nature Preserve,,,,,4.01
Ned Brown Meadow,,,,3.80,4.00
North Pool,3.55,3.02,3.72,3.97,4.02
Osborn Park,,,,4.93,4.06
Salt Creek Trail,4.05,4.20,4.74,4.63,4.44
South Pool,3.57,3.85,4.94,3.89,3.89
Wildlife Refuge,,3.63,3.24,3.97,4.27
Woodland Meadow,,,4.79,4.56,4.15
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.69304867 0.00690000 NUMc125_9fee
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.73 | 2.83 | 4.08 | 3.13 | 3.84 |
| Beisner Road Entrance | 4.26 | 3.82 | |||
| Boat Launch Area | 3.45 | 3.78 | 3.87 | 4.08 | 2.88 |
| Busse Lake | 5.48 | 3.89 | 4.43 | 4.61 | |
| Debra Park | 3.77 | ||||
| Elk Pasture | 3.94 | 4.32 | 4.42 | 3.00 | 3.79 |
| Forest Central Grove | 3.67 | 4.16 | |||
| Forest North Grove | 4.35 | 4.12 | 4.48 | ||
| Forest South Grove | 3.46 | 3.80 | |||
| Forest West Grove | 5.06 | 3.53 | 2.45 | 3.60 | 4.37 |
| Lake Boating Center | 4.47 | 3.65 | 3.68 | 3.81 | 3.77 |
| Large Event Area | 3.33 | 3.49 | 3.67 | 3.96 | 3.78 |
| Main Dam | 5.39 | 4.28 | 3.61 | 4.02 | 4.63 |
| Main Pool | 4.63 | 5.46 | 3.83 | 3.06 | 4.07 |
| Marshall Park | 4.50 | 3.49 | 4.30 | 3.87 | 4.50 |
| Model Airplane Field | 4.50 | 4.51 | 4.12 | 4.50 | 4.14 |
| Nature Preserve | 3.73 | 3.15 | 3.49 | ||
| Ned Brown Meadow | 4.25 | 3.69 | |||
| North Pool | 4.50 | 3.62 | 3.73 | 4.13 | 4.08 |
| Osborn Park | 3.96 | 4.21 | 3.65 | ||
| Salt Creek Trail | 3.96 | 3.82 | 4.39 | 4.22 | |
| South Pool | 4.66 | 4.79 | 4.35 | 3.85 | 3.81 |
| Wildlife Refuge | 3.17 | ||||
| Woodland Meadow | 3.53 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.73,2.83,4.08,3.13,3.84
Beisner Road Entrance,,,,4.26,3.82
Boat Launch Area,3.45,3.78,3.87,4.08,2.88
Busse Lake,,5.48,3.89,4.43,4.61
Debra Park,,,,,3.77
Elk Pasture,3.94,4.32,4.42,3.00,3.79
Forest Central Grove,,,,3.67,4.16
Forest North Grove,,,4.35,4.12,4.48
Forest South Grove,,,,3.46,3.80
Forest West Grove,5.06,3.53,2.45,3.60,4.37
Lake Boating Center,4.47,3.65,3.68,3.81,3.77
Large Event Area,3.33,3.49,3.67,3.96,3.78
Main Dam,5.39,4.28,3.61,4.02,4.63
Main Pool,4.63,5.46,3.83,3.06,4.07
Marshall Park,4.50,3.49,4.30,3.87,4.50
Model Airplane Field,4.50,4.51,4.12,4.50,4.14
Nature Preserve,,,3.73,3.15,3.49
Ned Brown Meadow,,,,4.25,3.69
North Pool,4.50,3.62,3.73,4.13,4.08
Osborn Park,,,3.96,4.21,3.65
Salt Creek Trail,,3.96,3.82,4.39,4.22
South Pool,4.66,4.79,4.35,3.85,3.81
Wildlife Refuge,,,,,3.17
Woodland Meadow,,,,,3.53
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.09272609 0.00100000 NUM3b31_4e61
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 5.44 | 3.03 | 4.62 | 4.47 | 4.49 |
| Beisner Road Entrance | 4.31 | 4.33 | 4.50 | ||
| Boat Launch Area | 4.16 | 4.50 | 4.16 | 4.49 | 4.22 |
| Busse Lake | 3.94 | 4.28 | 3.84 | 4.51 | 5.15 |
| Debra Park | 3.92 | 3.72 | 3.14 | 4.53 | |
| Elk Pasture | 3.48 | 4.37 | |||
| Forest Central Grove | 3.03 | 3.42 | 4.36 | ||
| Forest North Grove | 4.73 | 3.51 | 4.00 | 4.65 | 4.42 |
| Forest South Grove | 4.54 | 3.99 | |||
| Forest West Grove | 3.43 | ||||
| Lake Boating Center | 3.90 | 3.94 | 4.03 | 4.30 | 4.33 |
| Large Event Area | 3.56 | 4.44 | 4.37 | 4.29 | |
| Main Dam | 3.79 | 3.45 | 5.03 | 3.66 | |
| Main Pool | 3.62 | ||||
| Marshall Park | 4.39 | ||||
| Model Airplane Field | 4.54 | 3.56 | |||
| Nature Preserve | 4.28 | 4.61 | 3.62 | 3.99 | 3.25 |
| Ned Brown Meadow | 5.33 | 4.18 | 3.84 | 3.93 | |
| North Pool | 4.36 | 3.70 | 2.72 | ||
| Osborn Park | 3.77 | 4.04 | |||
| Salt Creek Trail | 4.55 | ||||
| South Pool | 4.05 | 3.75 | 4.41 | 3.22 | |
| Wildlife Refuge | 3.81 | 4.72 | |||
| Woodland Meadow | 3.94 | 4.18 | 3.55 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,5.44,3.03,4.62,4.47,4.49
Beisner Road Entrance,,,4.31,4.33,4.50
Boat Launch Area,4.16,4.50,4.16,4.49,4.22
Busse Lake,3.94,4.28,3.84,4.51,5.15
Debra Park,,3.92,3.72,3.14,4.53
Elk Pasture,,,,3.48,4.37
Forest Central Grove,,,3.03,3.42,4.36
Forest North Grove,4.73,3.51,4.00,4.65,4.42
Forest South Grove,,,,4.54,3.99
Forest West Grove,,,,,3.43
Lake Boating Center,3.90,3.94,4.03,4.30,4.33
Large Event Area,,3.56,4.44,4.37,4.29
Main Dam,,3.79,3.45,5.03,3.66
Main Pool,,,,,3.62
Marshall Park,,,,,4.39
Model Airplane Field,,,,4.54,3.56
Nature Preserve,4.28,4.61,3.62,3.99,3.25
Ned Brown Meadow,,5.33,4.18,3.84,3.93
North Pool,,,4.36,3.70,2.72
Osborn Park,,,,3.77,4.04
Salt Creek Trail,,,,,4.55
South Pool,,4.05,3.75,4.41,3.22
Wildlife Refuge,,,,3.81,4.72
Woodland Meadow,,,3.94,4.18,3.55
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.49036201 0.00490000 NUMcf35_9b7f
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 4.82 | 3.94 | 3.83 | ||
| Beisner Road Entrance | 4.22 | 4.09 | |||
| Boat Launch Area | 5.19 | 4.73 | 4.44 | 3.47 | |
| Busse Lake | 4.09 | 3.08 | 3.45 | 4.97 | 4.67 |
| Debra Park | 3.79 | 3.59 | |||
| Elk Pasture | 4.07 | 4.25 | 4.01 | 4.21 | 3.51 |
| Forest Central Grove | 3.28 | 3.87 | 3.94 | 3.46 | 3.75 |
| Forest North Grove | 4.29 | 4.94 | 4.88 | 4.43 | 3.82 |
| Forest South Grove | 3.99 | 3.70 | 3.43 | 3.26 | 3.65 |
| Forest West Grove | 3.50 | 4.18 | 3.62 | 4.33 | 3.61 |
| Lake Boating Center | 3.69 | 3.29 | 4.55 | 3.59 | 4.11 |
| Large Event Area | 3.77 | 4.14 | 3.87 | 4.68 | 3.90 |
| Main Dam | 4.05 | 4.41 | |||
| Main Pool | 3.39 | 3.79 | 3.83 | 4.08 | |
| Marshall Park | 4.61 | 4.32 | 3.83 | 3.64 | 4.14 |
| Model Airplane Field | 5.30 | 3.82 | 4.51 | 3.91 | 3.18 |
| Nature Preserve | 4.24 | 4.01 | 4.34 | 3.75 | 3.53 |
| Ned Brown Meadow | 3.90 | ||||
| North Pool | 4.84 | 3.85 | 3.69 | ||
| Osborn Park | 4.05 | ||||
| Salt Creek Trail | 2.95 | 4.60 | 4.57 | 4.02 | 3.35 |
| South Pool | 3.32 | 3.93 | 3.59 | 3.76 | 3.82 |
| Wildlife Refuge | 4.80 | 3.89 | 4.09 | 4.09 | 4.05 |
| Woodland Meadow | 5.01 | 4.93 | 3.67 | 4.89 | 2.89 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,4.82,3.94,3.83
Beisner Road Entrance,,,,4.22,4.09
Boat Launch Area,,5.19,4.73,4.44,3.47
Busse Lake,4.09,3.08,3.45,4.97,4.67
Debra Park,,,,3.79,3.59
Elk Pasture,4.07,4.25,4.01,4.21,3.51
Forest Central Grove,3.28,3.87,3.94,3.46,3.75
Forest North Grove,4.29,4.94,4.88,4.43,3.82
Forest South Grove,3.99,3.70,3.43,3.26,3.65
Forest West Grove,3.50,4.18,3.62,4.33,3.61
Lake Boating Center,3.69,3.29,4.55,3.59,4.11
Large Event Area,3.77,4.14,3.87,4.68,3.90
Main Dam,,,,4.05,4.41
Main Pool,,3.39,3.79,3.83,4.08
Marshall Park,4.61,4.32,3.83,3.64,4.14
Model Airplane Field,5.30,3.82,4.51,3.91,3.18
Nature Preserve,4.24,4.01,4.34,3.75,3.53
Ned Brown Meadow,,,,,3.90
North Pool,,,4.84,3.85,3.69
Osborn Park,,,,,4.05
Salt Creek Trail,2.95,4.60,4.57,4.02,3.35
South Pool,3.32,3.93,3.59,3.76,3.82
Wildlife Refuge,4.80,3.89,4.09,4.09,4.05
Woodland Meadow,5.01,4.93,3.67,4.89,2.89
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.20249595 0.00200000 NUM0783_f849
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.47 | 5.80 | 4.29 | 3.93 | 3.91 |
| Beisner Road Entrance | 3.53 | 4.50 | 4.06 | 4.63 | 3.91 |
| Boat Launch Area | 3.35 | ||||
| Busse Lake | 3.82 | 3.60 | |||
| Debra Park | 4.13 | 4.16 | 3.83 | 3.93 | |
| Elk Pasture | 3.60 | 3.66 | 3.85 | ||
| Forest Central Grove | 4.06 | 4.73 | 4.09 | ||
| Forest North Grove | 4.86 | ||||
| Forest South Grove | 3.41 | 4.19 | 4.41 | 4.47 | |
| Forest West Grove | 5.12 | 4.38 | 4.49 | 4.25 | 3.98 |
| Lake Boating Center | 4.31 | 3.67 | 4.42 | 3.85 | 4.20 |
| Large Event Area | 4.48 | 3.68 | 3.93 | 2.99 | |
| Main Dam | 3.17 | 3.39 | 3.96 | 4.07 | 3.82 |
| Main Pool | 3.27 | 3.27 | |||
| Marshall Park | 3.95 | 3.55 | |||
| Model Airplane Field | 4.38 | 4.49 | 5.00 | ||
| Nature Preserve | 3.51 | 3.19 | 3.45 | 3.29 | 4.08 |
| Ned Brown Meadow | 4.63 | 4.21 | 4.08 | 4.24 | |
| North Pool | 4.51 | 3.71 | 3.09 | 4.00 | 4.44 |
| Osborn Park | 4.55 | 4.00 | |||
| Salt Creek Trail | 3.32 | 3.74 | 3.92 | ||
| South Pool | 4.45 | 3.73 | 4.49 | 3.65 | |
| Wildlife Refuge | 3.61 | 4.32 | 3.57 | 2.98 | 3.79 |
| Woodland Meadow | 4.52 | 4.01 | 4.38 | 4.36 | 3.42 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.47,5.80,4.29,3.93,3.91
Beisner Road Entrance,3.53,4.50,4.06,4.63,3.91
Boat Launch Area,,,,,3.35
Busse Lake,,,,3.82,3.60
Debra Park,,4.13,4.16,3.83,3.93
Elk Pasture,,,3.60,3.66,3.85
Forest Central Grove,,,4.06,4.73,4.09
Forest North Grove,,,,,4.86
Forest South Grove,,3.41,4.19,4.41,4.47
Forest West Grove,5.12,4.38,4.49,4.25,3.98
Lake Boating Center,4.31,3.67,4.42,3.85,4.20
Large Event Area,,4.48,3.68,3.93,2.99
Main Dam,3.17,3.39,3.96,4.07,3.82
Main Pool,,,,3.27,3.27
Marshall Park,,,,3.95,3.55
Model Airplane Field,,,4.38,4.49,5.00
Nature Preserve,3.51,3.19,3.45,3.29,4.08
Ned Brown Meadow,,4.63,4.21,4.08,4.24
North Pool,4.51,3.71,3.09,4.00,4.44
Osborn Park,,,,4.55,4.00
Salt Creek Trail,,,3.32,3.74,3.92
South Pool,,4.45,3.73,4.49,3.65
Wildlife Refuge,3.61,4.32,3.57,2.98,3.79
Woodland Meadow,4.52,4.01,4.38,4.36,3.42
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.76860714 0.00770000 NUMc4d3_ef8c
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.53 | 3.82 | 3.68 | 3.05 | |
| Beisner Road Entrance | 3.23 | ||||
| Boat Launch Area | 3.98 | 3.86 | 3.91 | 3.72 | 3.71 |
| Busse Lake | 4.01 | 3.63 | 3.79 | 4.53 | 3.56 |
| Debra Park | 3.39 | ||||
| Elk Pasture | 4.07 | 4.35 | 4.35 | 4.24 | 4.38 |
| Forest Central Grove | 3.52 | 3.16 | 3.14 | ||
| Forest North Grove | 4.61 | 4.43 | 4.89 | 3.61 | 3.50 |
| Forest South Grove | 3.24 | 4.48 | |||
| Forest West Grove | 4.32 | 3.57 | 3.15 | 3.99 | |
| Lake Boating Center | 4.01 | 4.68 | 3.61 | ||
| Large Event Area | 4.29 | 3.98 | 3.51 | 4.10 | 4.53 |
| Main Dam | 4.20 | 4.44 | |||
| Main Pool | 4.23 | 3.81 | 4.47 | 4.02 | 4.15 |
| Marshall Park | 5.41 | 4.43 | 3.66 | 3.78 | |
| Model Airplane Field | 5.26 | 3.88 | |||
| Nature Preserve | 3.55 | 3.99 | |||
| Ned Brown Meadow | 3.93 | 4.73 | 4.32 | 4.64 | |
| North Pool | 4.62 | 3.53 | 3.35 | 3.86 | 3.63 |
| Osborn Park | 3.84 | 3.69 | 3.94 | 3.55 | 3.92 |
| Salt Creek Trail | 4.40 | 4.00 | 4.35 | 3.67 | |
| South Pool | 3.61 | 3.82 | 3.45 | 3.89 | 4.66 |
| Wildlife Refuge | 4.17 | 4.50 | 4.48 | 5.12 | 3.42 |
| Woodland Meadow | 3.32 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,3.53,3.82,3.68,3.05
Beisner Road Entrance,,,,,3.23
Boat Launch Area,3.98,3.86,3.91,3.72,3.71
Busse Lake,4.01,3.63,3.79,4.53,3.56
Debra Park,,,,,3.39
Elk Pasture,4.07,4.35,4.35,4.24,4.38
Forest Central Grove,,,3.52,3.16,3.14
Forest North Grove,4.61,4.43,4.89,3.61,3.50
Forest South Grove,,,,3.24,4.48
Forest West Grove,,4.32,3.57,3.15,3.99
Lake Boating Center,,,4.01,4.68,3.61
Large Event Area,4.29,3.98,3.51,4.10,4.53
Main Dam,,,,4.20,4.44
Main Pool,4.23,3.81,4.47,4.02,4.15
Marshall Park,,5.41,4.43,3.66,3.78
Model Airplane Field,,,,5.26,3.88
Nature Preserve,,,,3.55,3.99
Ned Brown Meadow,,3.93,4.73,4.32,4.64
North Pool,4.62,3.53,3.35,3.86,3.63
Osborn Park,3.84,3.69,3.94,3.55,3.92
Salt Creek Trail,,4.40,4.00,4.35,3.67
South Pool,3.61,3.82,3.45,3.89,4.66
Wildlife Refuge,4.17,4.50,4.48,5.12,3.42
Woodland Meadow,,,,,3.32
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.44377318 0.00440000 NUMe0a7_bc4b
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 4.16 | ||||
| Beisner Road Entrance | 5.00 | 4.57 | 3.92 | ||
| Boat Launch Area | 3.70 | 3.76 | |||
| Busse Lake | 4.30 | 4.52 | 3.62 | 3.56 | |
| Debra Park | 4.16 | 4.15 | |||
| Elk Pasture | 4.37 | 3.80 | 3.87 | ||
| Forest Central Grove | 3.37 | 4.19 | |||
| Forest North Grove | 3.77 | ||||
| Forest South Grove | 3.52 | 4.08 | 4.64 | 3.73 | 3.46 |
| Forest West Grove | 4.54 | 3.99 | 3.78 | ||
| Lake Boating Center | 4.71 | 3.55 | 4.80 | ||
| Large Event Area | 4.25 | 4.33 | 4.54 | 3.36 | 3.70 |
| Main Dam | 3.68 | ||||
| Main Pool | 4.04 | 3.74 | 3.38 | 3.65 | |
| Marshall Park | 3.54 | 4.11 | 4.15 | 4.53 | 4.00 |
| Model Airplane Field | 3.11 | 3.89 | 3.43 | 4.36 | 3.72 |
| Nature Preserve | 4.08 | 4.57 | |||
| Ned Brown Meadow | 4.44 | 4.29 | |||
| North Pool | 5.07 | 5.23 | 3.92 | 3.79 | 3.79 |
| Osborn Park | 4.17 | 3.72 | 3.80 | 4.18 | 4.05 |
| Salt Creek Trail | 4.52 | ||||
| South Pool | 3.90 | 3.29 | 3.79 | ||
| Wildlife Refuge | 4.10 | 3.52 | 3.61 | 4.02 | |
| Woodland Meadow | 3.84 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,,,4.16
Beisner Road Entrance,,,5.00,4.57,3.92
Boat Launch Area,,,,3.70,3.76
Busse Lake,,4.30,4.52,3.62,3.56
Debra Park,,,,4.16,4.15
Elk Pasture,,,4.37,3.80,3.87
Forest Central Grove,,,,3.37,4.19
Forest North Grove,,,,,3.77
Forest South Grove,3.52,4.08,4.64,3.73,3.46
Forest West Grove,,,4.54,3.99,3.78
Lake Boating Center,,,4.71,3.55,4.80
Large Event Area,4.25,4.33,4.54,3.36,3.70
Main Dam,,,,,3.68
Main Pool,,4.04,3.74,3.38,3.65
Marshall Park,3.54,4.11,4.15,4.53,4.00
Model Airplane Field,3.11,3.89,3.43,4.36,3.72
Nature Preserve,,,,4.08,4.57
Ned Brown Meadow,,,,4.44,4.29
North Pool,5.07,5.23,3.92,3.79,3.79
Osborn Park,4.17,3.72,3.80,4.18,4.05
Salt Creek Trail,,,,,4.52
South Pool,,,3.90,3.29,3.79
Wildlife Refuge,,4.10,3.52,3.61,4.02
Woodland Meadow,,,,,3.84
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.15862698 0.00160000 NUMb001_8214
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.67 | 3.48 | 4.23 | 4.18 | 3.54 |
| Beisner Road Entrance | 4.21 | 3.41 | |||
| Boat Launch Area | 3.48 | 3.96 | 3.91 | 4.51 | 4.19 |
| Busse Lake | 3.81 | 4.40 | 3.93 | 3.74 | 3.84 |
| Debra Park | 4.59 | 4.14 | 3.84 | 4.25 | |
| Elk Pasture | 3.96 | 3.39 | |||
| Forest Central Grove | 3.23 | 4.12 | 4.42 | 4.25 | 3.52 |
| Forest North Grove | 4.50 | 3.95 | 3.52 | 3.46 | 4.33 |
| Forest South Grove | 4.89 | 4.25 | 4.16 | 3.73 | 4.39 |
| Forest West Grove | 4.89 | 4.80 | 4.30 | 3.71 | 4.99 |
| Lake Boating Center | 3.87 | 4.78 | 3.82 | 4.14 | |
| Large Event Area | 4.21 | 3.61 | 4.71 | 4.16 | 4.07 |
| Main Dam | 3.95 | 4.10 | 4.33 | ||
| Main Pool | 4.69 | 4.13 | 3.90 | 4.39 | 3.24 |
| Marshall Park | 4.17 | 3.74 | 3.51 | 4.12 | 3.97 |
| Model Airplane Field | 3.73 | 4.30 | 4.24 | ||
| Nature Preserve | 3.76 | 3.92 | 4.51 | ||
| Ned Brown Meadow | 3.52 | ||||
| North Pool | 2.63 | 4.48 | 4.63 | 4.02 | |
| Osborn Park | 3.89 | 5.25 | 4.02 | 3.00 | 4.06 |
| Salt Creek Trail | 3.93 | 3.88 | 4.28 | 3.82 | 4.28 |
| South Pool | 3.59 | 4.96 | 3.44 | 2.91 | |
| Wildlife Refuge | 4.79 | 4.74 | 4.00 | 4.44 | 3.31 |
| Woodland Meadow | 3.28 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.67,3.48,4.23,4.18,3.54
Beisner Road Entrance,,,,4.21,3.41
Boat Launch Area,3.48,3.96,3.91,4.51,4.19
Busse Lake,3.81,4.40,3.93,3.74,3.84
Debra Park,,4.59,4.14,3.84,4.25
Elk Pasture,,,,3.96,3.39
Forest Central Grove,3.23,4.12,4.42,4.25,3.52
Forest North Grove,4.50,3.95,3.52,3.46,4.33
Forest South Grove,4.89,4.25,4.16,3.73,4.39
Forest West Grove,4.89,4.80,4.30,3.71,4.99
Lake Boating Center,,3.87,4.78,3.82,4.14
Large Event Area,4.21,3.61,4.71,4.16,4.07
Main Dam,,,3.95,4.10,4.33
Main Pool,4.69,4.13,3.90,4.39,3.24
Marshall Park,4.17,3.74,3.51,4.12,3.97
Model Airplane Field,,,3.73,4.30,4.24
Nature Preserve,,,3.76,3.92,4.51
Ned Brown Meadow,,,,,3.52
North Pool,,2.63,4.48,4.63,4.02
Osborn Park,3.89,5.25,4.02,3.00,4.06
Salt Creek Trail,3.93,3.88,4.28,3.82,4.28
South Pool,,3.59,4.96,3.44,2.91
Wildlife Refuge,4.79,4.74,4.00,4.44,3.31
Woodland Meadow,,,,,3.28
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.45081223 0.00450000 NUM4cc4_04d3
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.64 | ||||
| Beisner Road Entrance | 3.54 | ||||
| Boat Launch Area | 4.42 | 3.56 | |||
| Busse Lake | 4.60 | 2.91 | 3.90 | 4.42 | 4.21 |
| Debra Park | 3.52 | 3.45 | 3.58 | 4.31 | 3.96 |
| Elk Pasture | 4.17 | 4.37 | |||
| Forest Central Grove | 4.07 | ||||
| Forest North Grove | 4.28 | 3.87 | |||
| Forest South Grove | 3.19 | 4.02 | 4.21 | 3.59 | |
| Forest West Grove | 3.89 | 3.95 | 4.27 | ||
| Lake Boating Center | 3.33 | 3.88 | 4.80 | 3.63 | |
| Large Event Area | 3.20 | 3.66 | 3.67 | ||
| Main Dam | 4.26 | 4.42 | |||
| Main Pool | 4.72 | 3.77 | 4.31 | 4.02 | |
| Marshall Park | 4.82 | 4.61 | 3.51 | ||
| Model Airplane Field | 3.63 | 3.46 | 3.63 | 3.70 | 3.43 |
| Nature Preserve | 2.36 | ||||
| Ned Brown Meadow | 4.63 | 4.08 | 3.56 | 5.10 | 4.04 |
| North Pool | 3.98 | 3.67 | 4.57 | 4.22 | 3.81 |
| Osborn Park | 2.97 | 4.55 | 3.83 | 3.63 | 4.60 |
| Salt Creek Trail | 4.00 | 4.06 | |||
| South Pool | 4.49 | 2.93 | 4.22 | ||
| Wildlife Refuge | 4.78 | 4.56 | 3.40 | 4.43 | 3.38 |
| Woodland Meadow | 3.72 | 5.03 | 4.03 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,,,3.64
Beisner Road Entrance,,,,,3.54
Boat Launch Area,,,,4.42,3.56
Busse Lake,4.60,2.91,3.90,4.42,4.21
Debra Park,3.52,3.45,3.58,4.31,3.96
Elk Pasture,,,,4.17,4.37
Forest Central Grove,,,,,4.07
Forest North Grove,,,,4.28,3.87
Forest South Grove,,3.19,4.02,4.21,3.59
Forest West Grove,,,3.89,3.95,4.27
Lake Boating Center,,3.33,3.88,4.80,3.63
Large Event Area,,,3.20,3.66,3.67
Main Dam,,,,4.26,4.42
Main Pool,,4.72,3.77,4.31,4.02
Marshall Park,,,4.82,4.61,3.51
Model Airplane Field,3.63,3.46,3.63,3.70,3.43
Nature Preserve,,,,,2.36
Ned Brown Meadow,4.63,4.08,3.56,5.10,4.04
North Pool,3.98,3.67,4.57,4.22,3.81
Osborn Park,2.97,4.55,3.83,3.63,4.60
Salt Creek Trail,,,,4.00,4.06
South Pool,,,4.49,2.93,4.22
Wildlife Refuge,4.78,4.56,3.40,4.43,3.38
Woodland Meadow,,,3.72,5.03,4.03
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.11069265 0.00110000 NUMa37e_fbca
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 4.46 | 3.74 | 3.48 | 3.37 | 3.84 |
| Beisner Road Entrance | 4.29 | 4.03 | 4.18 | 4.05 | 4.48 |
| Boat Launch Area | 4.22 | 4.67 | 4.01 | 4.49 | 4.08 |
| Busse Lake | 4.89 | 4.20 | 2.84 | 4.16 | |
| Debra Park | 4.78 | 3.89 | 4.17 | 4.34 | 4.00 |
| Elk Pasture | 4.11 | 4.32 | 4.39 | ||
| Forest Central Grove | 3.96 | 3.65 | 4.01 | 3.91 | |
| Forest North Grove | 3.61 | ||||
| Forest South Grove | 4.36 | 4.64 | 3.93 | 4.31 | 4.72 |
| Forest West Grove | 3.62 | 3.57 | 5.14 | 4.75 | 4.19 |
| Lake Boating Center | 4.02 | ||||
| Large Event Area | 4.11 | 3.72 | 4.30 | ||
| Main Dam | 3.90 | ||||
| Main Pool | 4.17 | ||||
| Marshall Park | 4.39 | 3.98 | 3.20 | ||
| Model Airplane Field | 4.05 | 4.05 | 3.79 | 3.84 | 4.51 |
| Nature Preserve | 3.84 | 4.32 | |||
| Ned Brown Meadow | 3.48 | 3.80 | 4.13 | 2.82 | |
| North Pool | 5.91 | 3.75 | 3.39 | ||
| Osborn Park | 3.80 | 4.87 | 3.79 | ||
| Salt Creek Trail | 4.21 | 3.39 | 4.00 | 4.61 | 4.60 |
| South Pool | 3.80 | 4.40 | 4.05 | 4.33 | 3.60 |
| Wildlife Refuge | 4.22 | 3.92 | 3.75 | 3.53 | 4.00 |
| Woodland Meadow | 4.26 | 3.20 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.46,3.74,3.48,3.37,3.84
Beisner Road Entrance,4.29,4.03,4.18,4.05,4.48
Boat Launch Area,4.22,4.67,4.01,4.49,4.08
Busse Lake,,4.89,4.20,2.84,4.16
Debra Park,4.78,3.89,4.17,4.34,4.00
Elk Pasture,,,4.11,4.32,4.39
Forest Central Grove,,3.96,3.65,4.01,3.91
Forest North Grove,,,,,3.61
Forest South Grove,4.36,4.64,3.93,4.31,4.72
Forest West Grove,3.62,3.57,5.14,4.75,4.19
Lake Boating Center,,,,,4.02
Large Event Area,,,4.11,3.72,4.30
Main Dam,,,,,3.90
Main Pool,,,,,4.17
Marshall Park,,,4.39,3.98,3.20
Model Airplane Field,4.05,4.05,3.79,3.84,4.51
Nature Preserve,,,,3.84,4.32
Ned Brown Meadow,,3.48,3.80,4.13,2.82
North Pool,,,5.91,3.75,3.39
Osborn Park,,,3.80,4.87,3.79
Salt Creek Trail,4.21,3.39,4.00,4.61,4.60
South Pool,3.80,4.40,4.05,4.33,3.60
Wildlife Refuge,4.22,3.92,3.75,3.53,4.00
Woodland Meadow,,,,4.26,3.20
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.70294253 0.00700000 NUMeb22_89c1
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 4.05 | ||||
| Beisner Road Entrance | 4.14 | ||||
| Boat Launch Area | 4.32 | 3.71 | 3.94 | 3.96 | |
| Busse Lake | 4.50 | 4.14 | |||
| Debra Park | 4.25 | 4.38 | |||
| Elk Pasture | 4.72 | 4.48 | 3.43 | 3.79 | 4.26 |
| Forest Central Grove | 4.69 | ||||
| Forest North Grove | 4.28 | 3.00 | 4.42 | ||
| Forest South Grove | 4.29 | 4.19 | 4.03 | 4.00 | |
| Forest West Grove | 4.69 | 5.38 | 3.91 | 4.09 | 4.83 |
| Lake Boating Center | 4.47 | ||||
| Large Event Area | 4.35 | 3.94 | 4.49 | 3.57 | 3.88 |
| Main Dam | 4.97 | 4.59 | 3.46 | ||
| Main Pool | 3.86 | 3.95 | 3.15 | 4.45 | 3.63 |
| Marshall Park | 2.85 | 4.09 | 4.18 | 3.92 | 3.18 |
| Model Airplane Field | 4.94 | 3.90 | 4.17 | 4.36 | 4.13 |
| Nature Preserve | 4.07 | 3.68 | 4.48 | 4.31 | 3.37 |
| Ned Brown Meadow | 3.64 | 4.10 | 4.87 | ||
| North Pool | 3.74 | 3.22 | 3.23 | ||
| Osborn Park | 3.33 | 3.87 | 4.53 | 3.92 | 4.46 |
| Salt Creek Trail | 3.76 | 3.46 | |||
| South Pool | 4.06 | 4.26 | |||
| Wildlife Refuge | 3.80 | 3.49 | |||
| Woodland Meadow | 4.22 | 4.20 | 3.23 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,,,4.05
Beisner Road Entrance,,,,,4.14
Boat Launch Area,,4.32,3.71,3.94,3.96
Busse Lake,,,,4.50,4.14
Debra Park,,,,4.25,4.38
Elk Pasture,4.72,4.48,3.43,3.79,4.26
Forest Central Grove,,,,,4.69
Forest North Grove,,,4.28,3.00,4.42
Forest South Grove,,4.29,4.19,4.03,4.00
Forest West Grove,4.69,5.38,3.91,4.09,4.83
Lake Boating Center,,,,,4.47
Large Event Area,4.35,3.94,4.49,3.57,3.88
Main Dam,,,4.97,4.59,3.46
Main Pool,3.86,3.95,3.15,4.45,3.63
Marshall Park,2.85,4.09,4.18,3.92,3.18
Model Airplane Field,4.94,3.90,4.17,4.36,4.13
Nature Preserve,4.07,3.68,4.48,4.31,3.37
Ned Brown Meadow,,,3.64,4.10,4.87
North Pool,,,3.74,3.22,3.23
Osborn Park,3.33,3.87,4.53,3.92,4.46
Salt Creek Trail,,,,3.76,3.46
South Pool,,,,4.06,4.26
Wildlife Refuge,,,,3.80,3.49
Woodland Meadow,,,4.22,4.20,3.23
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.84593391 0.00850000 NUM0084_16df
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.86 | 3.84 | 3.70 | 3.36 | 3.78 |
| Beisner Road Entrance | 3.83 | 3.70 | 4.02 | 3.26 | 3.72 |
| Boat Launch Area | 4.37 | 4.47 | 3.93 | 3.85 | 3.23 |
| Busse Lake | 3.32 | 4.37 | 4.24 | 3.70 | 4.04 |
| Debra Park | 4.45 | 3.31 | 3.94 | 4.01 | 3.57 |
| Elk Pasture | 4.16 | 4.27 | 4.03 | 4.18 | |
| Forest Central Grove | 3.75 | 4.65 | |||
| Forest North Grove | 3.97 | ||||
| Forest South Grove | 4.25 | 4.85 | 3.41 | 3.94 | 3.63 |
| Forest West Grove | 3.97 | 4.46 | 4.41 | ||
| Lake Boating Center | 4.33 | 3.55 | 3.76 | 3.81 | 3.90 |
| Large Event Area | 4.45 | 4.84 | |||
| Main Dam | 4.87 | 4.36 | 4.90 | 3.95 | 5.00 |
| Main Pool | 3.73 | 4.74 | 4.47 | ||
| Marshall Park | 4.21 | 4.10 | 4.53 | 3.97 | |
| Model Airplane Field | 3.67 | 3.78 | 4.14 | 3.92 | |
| Nature Preserve | 3.73 | 5.29 | 4.05 | 4.41 | 3.25 |
| Ned Brown Meadow | 4.24 | 3.84 | 4.55 | 4.03 | 5.06 |
| North Pool | 3.58 | 3.89 | 3.37 | ||
| Osborn Park | 3.92 | 4.15 | |||
| Salt Creek Trail | 4.31 | 4.12 | 4.39 | 3.90 | |
| South Pool | 4.51 | 3.89 | 4.28 | 4.63 | 3.90 |
| Wildlife Refuge | 4.94 | 3.93 | 4.76 | 3.85 | 4.04 |
| Woodland Meadow | 3.33 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.86,3.84,3.70,3.36,3.78
Beisner Road Entrance,3.83,3.70,4.02,3.26,3.72
Boat Launch Area,4.37,4.47,3.93,3.85,3.23
Busse Lake,3.32,4.37,4.24,3.70,4.04
Debra Park,4.45,3.31,3.94,4.01,3.57
Elk Pasture,,4.16,4.27,4.03,4.18
Forest Central Grove,,,,3.75,4.65
Forest North Grove,,,,,3.97
Forest South Grove,4.25,4.85,3.41,3.94,3.63
Forest West Grove,,,3.97,4.46,4.41
Lake Boating Center,4.33,3.55,3.76,3.81,3.90
Large Event Area,,,,4.45,4.84
Main Dam,4.87,4.36,4.90,3.95,5.00
Main Pool,,,3.73,4.74,4.47
Marshall Park,,4.21,4.10,4.53,3.97
Model Airplane Field,,3.67,3.78,4.14,3.92
Nature Preserve,3.73,5.29,4.05,4.41,3.25
Ned Brown Meadow,4.24,3.84,4.55,4.03,5.06
North Pool,,,3.58,3.89,3.37
Osborn Park,,,,3.92,4.15
Salt Creek Trail,,4.31,4.12,4.39,3.90
South Pool,4.51,3.89,4.28,4.63,3.90
Wildlife Refuge,4.94,3.93,4.76,3.85,4.04
Woodland Meadow,,,,,3.33
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.74415635 0.00740000 NUM23ef_5ecc
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 4.64 | 4.39 | 4.00 | ||
| Beisner Road Entrance | 3.72 | 3.77 | |||
| Boat Launch Area | 4.90 | 4.10 | |||
| Busse Lake | 4.27 | 4.11 | 4.55 | 4.33 | 3.93 |
| Debra Park | 3.91 | 3.36 | 4.28 | ||
| Elk Pasture | 4.05 | 4.50 | 3.92 | 4.30 | |
| Forest Central Grove | 3.69 | ||||
| Forest North Grove | 4.46 | 3.72 | 4.11 | 4.33 | 3.23 |
| Forest South Grove | 4.13 | 3.02 | 3.93 | 3.43 | |
| Forest West Grove | 4.45 | 4.03 | |||
| Lake Boating Center | 4.55 | ||||
| Large Event Area | 3.69 | 3.78 | 3.81 | 4.83 | 4.12 |
| Main Dam | 4.84 | 4.91 | 3.93 | 4.27 | |
| Main Pool | 3.60 | 4.51 | 3.97 | 4.49 | 4.11 |
| Marshall Park | 3.92 | 3.87 | 2.99 | ||
| Model Airplane Field | 4.81 | 3.89 | 4.53 | 3.99 | 4.45 |
| Nature Preserve | 3.65 | 3.43 | 3.64 | 3.41 | 4.16 |
| Ned Brown Meadow | 4.77 | 5.12 | 4.42 | 4.24 | 3.57 |
| North Pool | 4.66 | 3.98 | 4.14 | 3.87 | 4.53 |
| Osborn Park | 4.29 | 5.03 | 3.47 | 4.99 | 4.01 |
| Salt Creek Trail | 4.40 | 3.57 | 4.33 | ||
| South Pool | 3.77 | 3.27 | |||
| Wildlife Refuge | 4.09 | ||||
| Woodland Meadow | 3.76 | 3.69 | 3.33 | 3.69 | 4.63 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,4.64,4.39,4.00
Beisner Road Entrance,,,,3.72,3.77
Boat Launch Area,,,,4.90,4.10
Busse Lake,4.27,4.11,4.55,4.33,3.93
Debra Park,,,3.91,3.36,4.28
Elk Pasture,,4.05,4.50,3.92,4.30
Forest Central Grove,,,,,3.69
Forest North Grove,4.46,3.72,4.11,4.33,3.23
Forest South Grove,,4.13,3.02,3.93,3.43
Forest West Grove,,,,4.45,4.03
Lake Boating Center,,,,,4.55
Large Event Area,3.69,3.78,3.81,4.83,4.12
Main Dam,,4.84,4.91,3.93,4.27
Main Pool,3.60,4.51,3.97,4.49,4.11
Marshall Park,,,3.92,3.87,2.99
Model Airplane Field,4.81,3.89,4.53,3.99,4.45
Nature Preserve,3.65,3.43,3.64,3.41,4.16
Ned Brown Meadow,4.77,5.12,4.42,4.24,3.57
North Pool,4.66,3.98,4.14,3.87,4.53
Osborn Park,4.29,5.03,3.47,4.99,4.01
Salt Creek Trail,,,4.40,3.57,4.33
South Pool,,,,3.77,3.27
Wildlife Refuge,,,,,4.09
Woodland Meadow,3.76,3.69,3.33,3.69,4.63
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.75936394 0.00760000 NUM40c2_482b
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 4.37 | ||||
| Beisner Road Entrance | 3.60 | 4.10 | 4.14 | 4.22 | |
| Boat Launch Area | 3.91 | 3.40 | 4.13 | 3.82 | |
| Busse Lake | 3.79 | 4.24 | 3.88 | 3.34 | |
| Debra Park | 4.66 | ||||
| Elk Pasture | 3.77 | ||||
| Forest Central Grove | 3.89 | 3.92 | 3.34 | ||
| Forest North Grove | 4.35 | 3.17 | |||
| Forest South Grove | 4.30 | 3.76 | 3.62 | 3.70 | 3.23 |
| Forest West Grove | 4.08 | 3.91 | |||
| Lake Boating Center | 3.45 | ||||
| Large Event Area | 3.91 | 4.53 | 3.55 | ||
| Main Dam | 4.11 | 3.40 | 4.38 | ||
| Main Pool | 3.40 | 3.85 | |||
| Marshall Park | 3.41 | 3.27 | |||
| Model Airplane Field | 4.48 | 4.36 | 4.89 | 4.71 | 4.07 |
| Nature Preserve | 3.88 | 3.39 | 4.18 | 3.55 | 4.84 |
| Ned Brown Meadow | 3.76 | 4.39 | 4.40 | 3.53 | 3.31 |
| North Pool | 4.23 | 3.34 | |||
| Osborn Park | 4.23 | 4.57 | 4.38 | 3.70 | 4.50 |
| Salt Creek Trail | 3.44 | 4.31 | 4.05 | 3.67 | |
| South Pool | 4.47 | ||||
| Wildlife Refuge | 4.51 | 3.94 | 3.87 | 4.50 | 3.67 |
| Woodland Meadow | 3.85 | 4.28 | 4.90 | 4.25 | 3.56 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,,,4.37
Beisner Road Entrance,,3.60,4.10,4.14,4.22
Boat Launch Area,,3.91,3.40,4.13,3.82
Busse Lake,,3.79,4.24,3.88,3.34
Debra Park,,,,,4.66
Elk Pasture,,,,,3.77
Forest Central Grove,,,3.89,3.92,3.34
Forest North Grove,,,,4.35,3.17
Forest South Grove,4.30,3.76,3.62,3.70,3.23
Forest West Grove,,,,4.08,3.91
Lake Boating Center,,,,,3.45
Large Event Area,,,3.91,4.53,3.55
Main Dam,,,4.11,3.40,4.38
Main Pool,,,,3.40,3.85
Marshall Park,,,,3.41,3.27
Model Airplane Field,4.48,4.36,4.89,4.71,4.07
Nature Preserve,3.88,3.39,4.18,3.55,4.84
Ned Brown Meadow,3.76,4.39,4.40,3.53,3.31
North Pool,,,,4.23,3.34
Osborn Park,4.23,4.57,4.38,3.70,4.50
Salt Creek Trail,,3.44,4.31,4.05,3.67
South Pool,,,,,4.47
Wildlife Refuge,4.51,3.94,3.87,4.50,3.67
Woodland Meadow,3.85,4.28,4.90,4.25,3.56
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.18209194 0.00180000 NUM1631_acd7
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.80 | 3.91 | 3.70 | 4.39 | 4.39 |
| Beisner Road Entrance | 4.52 | ||||
| Boat Launch Area | 4.14 | 3.48 | 3.92 | 3.89 | 3.05 |
| Busse Lake | 5.24 | 3.62 | 4.08 | 4.13 | |
| Debra Park | 4.79 | 5.45 | 3.83 | ||
| Elk Pasture | 4.08 | 4.12 | 3.84 | 3.55 | |
| Forest Central Grove | 4.26 | 4.71 | 4.80 | ||
| Forest North Grove | 3.97 | 3.78 | 3.55 | 3.45 | 3.37 |
| Forest South Grove | 3.38 | 3.91 | 4.21 | 4.54 | 3.96 |
| Forest West Grove | 3.51 | ||||
| Lake Boating Center | 4.53 | 2.93 | 3.79 | 3.78 | 4.08 |
| Large Event Area | 3.19 | 3.75 | 4.02 | 3.97 | 3.77 |
| Main Dam | 4.46 | 4.34 | 3.96 | 3.90 | 4.40 |
| Main Pool | 3.78 | 2.79 | 4.40 | 4.24 | |
| Marshall Park | 3.86 | 4.06 | |||
| Model Airplane Field | 4.24 | 4.76 | 4.78 | 4.25 | 4.01 |
| Nature Preserve | 3.04 | ||||
| Ned Brown Meadow | 4.02 | 3.83 | 4.19 | ||
| North Pool | 4.22 | 4.45 | |||
| Osborn Park | 3.80 | 4.18 | |||
| Salt Creek Trail | 3.28 | ||||
| South Pool | 3.97 | 4.35 | 3.97 | 3.29 | 3.98 |
| Wildlife Refuge | 3.38 | 4.56 | 3.87 | 3.84 | |
| Woodland Meadow | 4.32 | 5.20 | 4.32 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.80,3.91,3.70,4.39,4.39
Beisner Road Entrance,,,,,4.52
Boat Launch Area,4.14,3.48,3.92,3.89,3.05
Busse Lake,,5.24,3.62,4.08,4.13
Debra Park,,,4.79,5.45,3.83
Elk Pasture,,4.08,4.12,3.84,3.55
Forest Central Grove,,,4.26,4.71,4.80
Forest North Grove,3.97,3.78,3.55,3.45,3.37
Forest South Grove,3.38,3.91,4.21,4.54,3.96
Forest West Grove,,,,,3.51
Lake Boating Center,4.53,2.93,3.79,3.78,4.08
Large Event Area,3.19,3.75,4.02,3.97,3.77
Main Dam,4.46,4.34,3.96,3.90,4.40
Main Pool,,3.78,2.79,4.40,4.24
Marshall Park,,,,3.86,4.06
Model Airplane Field,4.24,4.76,4.78,4.25,4.01
Nature Preserve,,,,,3.04
Ned Brown Meadow,,,4.02,3.83,4.19
North Pool,,,,4.22,4.45
Osborn Park,,,,3.80,4.18
Salt Creek Trail,,,,,3.28
South Pool,3.97,4.35,3.97,3.29,3.98
Wildlife Refuge,,3.38,4.56,3.87,3.84
Woodland Meadow,,,4.32,5.20,4.32
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.80242256 0.00800000 NUM722e_a591
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.98 | 4.32 | |||
| Beisner Road Entrance | 4.94 | 4.15 | 4.72 | 3.18 | 3.86 |
| Boat Launch Area | 4.72 | 4.42 | 4.61 | 3.87 | 3.23 |
| Busse Lake | 4.23 | 4.74 | 4.11 | 3.84 | 3.93 |
| Debra Park | 3.56 | ||||
| Elk Pasture | 2.69 | 4.86 | 4.60 | 3.93 | 4.68 |
| Forest Central Grove | 3.61 | 4.93 | 3.34 | 3.82 | 3.49 |
| Forest North Grove | 4.10 | ||||
| Forest South Grove | 3.37 | 4.78 | |||
| Forest West Grove | 3.61 | 3.90 | 4.42 | 3.66 | 3.61 |
| Lake Boating Center | 2.92 | 4.35 | 4.15 | ||
| Large Event Area | 4.93 | 3.90 | 3.25 | 4.33 | 3.25 |
| Main Dam | 4.29 | 3.60 | 4.66 | 4.20 | 3.86 |
| Main Pool | 4.06 | 4.58 | 3.39 | ||
| Marshall Park | 3.69 | 4.20 | 3.76 | 3.35 | 4.16 |
| Model Airplane Field | 4.39 | 4.16 | 4.00 | ||
| Nature Preserve | 3.93 | 3.25 | 4.14 | ||
| Ned Brown Meadow | 4.67 | 3.74 | |||
| North Pool | 4.28 | 4.76 | |||
| Osborn Park | 3.34 | 3.67 | 4.44 | 4.18 | 4.41 |
| Salt Creek Trail | 2.84 | 4.38 | 5.38 | 4.13 | |
| South Pool | 4.77 | ||||
| Wildlife Refuge | 4.59 | 4.15 | 4.45 | 4.30 | |
| Woodland Meadow | 3.82 | 3.26 | 4.26 | 4.37 | 3.01 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,,3.98,4.32
Beisner Road Entrance,4.94,4.15,4.72,3.18,3.86
Boat Launch Area,4.72,4.42,4.61,3.87,3.23
Busse Lake,4.23,4.74,4.11,3.84,3.93
Debra Park,,,,,3.56
Elk Pasture,2.69,4.86,4.60,3.93,4.68
Forest Central Grove,3.61,4.93,3.34,3.82,3.49
Forest North Grove,,,,,4.10
Forest South Grove,,,,3.37,4.78
Forest West Grove,3.61,3.90,4.42,3.66,3.61
Lake Boating Center,,,2.92,4.35,4.15
Large Event Area,4.93,3.90,3.25,4.33,3.25
Main Dam,4.29,3.60,4.66,4.20,3.86
Main Pool,,,4.06,4.58,3.39
Marshall Park,3.69,4.20,3.76,3.35,4.16
Model Airplane Field,,,4.39,4.16,4.00
Nature Preserve,,,3.93,3.25,4.14
Ned Brown Meadow,,,,4.67,3.74
North Pool,,,,4.28,4.76
Osborn Park,3.34,3.67,4.44,4.18,4.41
Salt Creek Trail,,2.84,4.38,5.38,4.13
South Pool,,,,,4.77
Wildlife Refuge,,4.59,4.15,4.45,4.30
Woodland Meadow,3.82,3.26,4.26,4.37,3.01
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.94663145 0.00950000 NUM9452_ca99
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 4.63 | 3.39 | 3.61 | 4.30 | |
| Beisner Road Entrance | 5.01 | 3.94 | 3.97 | 3.80 | 3.79 |
| Boat Launch Area | 4.01 | 3.68 | 4.00 | 3.83 | 4.08 |
| Busse Lake | 2.67 | ||||
| Debra Park | 3.87 | ||||
| Elk Pasture | 4.14 | ||||
| Forest Central Grove | 3.75 | 3.70 | 3.53 | 4.92 | 3.93 |
| Forest North Grove | 3.93 | 4.23 | 3.35 | 4.69 | 3.68 |
| Forest South Grove | 4.30 | 3.63 | 3.49 | 3.32 | 4.13 |
| Forest West Grove | 3.63 | 3.57 | 4.33 | 3.80 | 4.09 |
| Lake Boating Center | 3.58 | 4.53 | |||
| Large Event Area | 3.83 | 3.66 | |||
| Main Dam | 4.49 | 4.56 | 4.51 | ||
| Main Pool | 3.90 | 4.25 | 4.20 | 4.21 | |
| Marshall Park | 3.58 | 4.40 | 3.41 | 4.14 | 4.34 |
| Model Airplane Field | 3.17 | 3.62 | 3.99 | ||
| Nature Preserve | 5.38 | 4.97 | 3.52 | 3.97 | 4.11 |
| Ned Brown Meadow | 3.07 | 5.78 | 3.52 | 3.72 | 4.79 |
| North Pool | 3.83 | 4.29 | |||
| Osborn Park | 4.81 | 4.45 | 4.34 | 3.82 | |
| Salt Creek Trail | 3.46 | 4.40 | 3.49 | ||
| South Pool | 3.64 | 3.69 | 3.90 | ||
| Wildlife Refuge | 5.27 | 3.62 | 3.64 | 4.20 | 3.99 |
| Woodland Meadow | 3.89 | 3.99 | 4.24 | 4.18 | 3.32 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,4.63,3.39,3.61,4.30
Beisner Road Entrance,5.01,3.94,3.97,3.80,3.79
Boat Launch Area,4.01,3.68,4.00,3.83,4.08
Busse Lake,,,,,2.67
Debra Park,,,,,3.87
Elk Pasture,,,,,4.14
Forest Central Grove,3.75,3.70,3.53,4.92,3.93
Forest North Grove,3.93,4.23,3.35,4.69,3.68
Forest South Grove,4.30,3.63,3.49,3.32,4.13
Forest West Grove,3.63,3.57,4.33,3.80,4.09
Lake Boating Center,,,,3.58,4.53
Large Event Area,,,,3.83,3.66
Main Dam,,,4.49,4.56,4.51
Main Pool,,3.90,4.25,4.20,4.21
Marshall Park,3.58,4.40,3.41,4.14,4.34
Model Airplane Field,,,3.17,3.62,3.99
Nature Preserve,5.38,4.97,3.52,3.97,4.11
Ned Brown Meadow,3.07,5.78,3.52,3.72,4.79
North Pool,,,,3.83,4.29
Osborn Park,,4.81,4.45,4.34,3.82
Salt Creek Trail,,,3.46,4.40,3.49
South Pool,,,3.64,3.69,3.90
Wildlife Refuge,5.27,3.62,3.64,4.20,3.99
Woodland Meadow,3.89,3.99,4.24,4.18,3.32
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.14531927 0.00150000 NUM3953_1766
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 2.87 | 3.71 | 4.21 | 3.84 | 4.14 |
| Beisner Road Entrance | 3.22 | 4.25 | 3.75 | 3.62 | 4.26 |
| Boat Launch Area | 5.28 | 3.31 | 4.19 | 4.16 | 3.38 |
| Busse Lake | 4.86 | 4.30 | 3.34 | ||
| Debra Park | 3.25 | 4.51 | 3.98 | 4.74 | 4.06 |
| Elk Pasture | 3.75 | 3.97 | 4.17 | 3.95 | 4.50 |
| Forest Central Grove | 3.92 | 3.75 | 2.80 | 4.17 | 3.80 |
| Forest North Grove | 3.88 | 4.30 | |||
| Forest South Grove | 4.80 | ||||
| Forest West Grove | 3.71 | ||||
| Lake Boating Center | 3.70 | 3.74 | 4.21 | 3.32 | 4.18 |
| Large Event Area | 4.88 | 4.59 | 4.40 | 4.07 | 4.19 |
| Main Dam | 4.23 | 4.29 | 4.37 | 4.48 | 2.21 |
| Main Pool | 4.32 | 4.07 | |||
| Marshall Park | 4.10 | 3.70 | 3.77 | ||
| Model Airplane Field | 4.46 | 4.03 | 2.86 | 4.08 | 3.94 |
| Nature Preserve | 3.49 | 3.75 | 4.62 | 3.04 | |
| Ned Brown Meadow | 4.99 | 3.75 | 3.87 | 3.78 | 4.35 |
| North Pool | 3.84 | 4.29 | 3.83 | 3.90 | 3.54 |
| Osborn Park | 3.96 | 4.04 | |||
| Salt Creek Trail | 3.99 | 3.52 | 4.33 | 4.89 | |
| South Pool | 3.50 | 3.49 | 3.96 | 4.38 | 3.46 |
| Wildlife Refuge | 4.27 | 3.83 | 4.43 | 3.34 | 3.79 |
| Woodland Meadow | 3.98 | 3.54 | 4.53 | 4.34 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,2.87,3.71,4.21,3.84,4.14
Beisner Road Entrance,3.22,4.25,3.75,3.62,4.26
Boat Launch Area,5.28,3.31,4.19,4.16,3.38
Busse Lake,,,4.86,4.30,3.34
Debra Park,3.25,4.51,3.98,4.74,4.06
Elk Pasture,3.75,3.97,4.17,3.95,4.50
Forest Central Grove,3.92,3.75,2.80,4.17,3.80
Forest North Grove,,,,3.88,4.30
Forest South Grove,,,,,4.80
Forest West Grove,,,,,3.71
Lake Boating Center,3.70,3.74,4.21,3.32,4.18
Large Event Area,4.88,4.59,4.40,4.07,4.19
Main Dam,4.23,4.29,4.37,4.48,2.21
Main Pool,,,,4.32,4.07
Marshall Park,,,4.10,3.70,3.77
Model Airplane Field,4.46,4.03,2.86,4.08,3.94
Nature Preserve,,3.49,3.75,4.62,3.04
Ned Brown Meadow,4.99,3.75,3.87,3.78,4.35
North Pool,3.84,4.29,3.83,3.90,3.54
Osborn Park,,,,3.96,4.04
Salt Creek Trail,,3.99,3.52,4.33,4.89
South Pool,3.50,3.49,3.96,4.38,3.46
Wildlife Refuge,4.27,3.83,4.43,3.34,3.79
Woodland Meadow,,3.98,3.54,4.53,4.34
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.87403700 0.00870000 NUM3ca3_d2fa
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.84 | 4.48 | 4.79 | 4.00 | 3.45 |
| Beisner Road Entrance | 4.06 | 4.07 | 4.37 | 3.84 | |
| Boat Launch Area | 4.20 | 3.34 | 4.32 | 3.28 | 3.87 |
| Busse Lake | 4.78 | 5.55 | 3.34 | 4.14 | 3.83 |
| Debra Park | 3.64 | 4.18 | |||
| Elk Pasture | 3.94 | 4.31 | 4.39 | 3.69 | 3.78 |
| Forest Central Grove | 4.90 | 3.60 | 3.48 | 3.75 | 4.00 |
| Forest North Grove | 3.49 | ||||
| Forest South Grove | 4.11 | ||||
| Forest West Grove | 3.70 | 4.41 | 3.77 | 4.12 | 3.76 |
| Lake Boating Center | 3.82 | ||||
| Large Event Area | 4.72 | 3.14 | 4.50 | 4.20 | 3.93 |
| Main Dam | 4.02 | ||||
| Main Pool | 2.82 | 4.04 | 3.88 | 3.58 | |
| Marshall Park | 3.91 | 4.74 | 4.08 | 3.13 | 4.00 |
| Model Airplane Field | 4.31 | 4.57 | |||
| Nature Preserve | 4.07 | 4.39 | 3.82 | 3.49 | 4.12 |
| Ned Brown Meadow | 4.28 | 3.80 | 4.11 | 3.59 | |
| North Pool | 4.31 | 3.63 | 4.14 | ||
| Osborn Park | 3.73 | 4.13 | |||
| Salt Creek Trail | 4.15 | 4.53 | 4.17 | 3.94 | 3.46 |
| South Pool | 4.70 | 3.69 | |||
| Wildlife Refuge | 3.60 | 3.43 | 4.11 | ||
| Woodland Meadow | 4.02 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.84,4.48,4.79,4.00,3.45
Beisner Road Entrance,,4.06,4.07,4.37,3.84
Boat Launch Area,4.20,3.34,4.32,3.28,3.87
Busse Lake,4.78,5.55,3.34,4.14,3.83
Debra Park,,,,3.64,4.18
Elk Pasture,3.94,4.31,4.39,3.69,3.78
Forest Central Grove,4.90,3.60,3.48,3.75,4.00
Forest North Grove,,,,,3.49
Forest South Grove,,,,,4.11
Forest West Grove,3.70,4.41,3.77,4.12,3.76
Lake Boating Center,,,,,3.82
Large Event Area,4.72,3.14,4.50,4.20,3.93
Main Dam,,,,,4.02
Main Pool,,2.82,4.04,3.88,3.58
Marshall Park,3.91,4.74,4.08,3.13,4.00
Model Airplane Field,,,,4.31,4.57
Nature Preserve,4.07,4.39,3.82,3.49,4.12
Ned Brown Meadow,,4.28,3.80,4.11,3.59
North Pool,,,4.31,3.63,4.14
Osborn Park,,,,3.73,4.13
Salt Creek Trail,4.15,4.53,4.17,3.94,3.46
South Pool,,,,4.70,3.69
Wildlife Refuge,,,3.60,3.43,4.11
Woodland Meadow,,,,,4.02
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.17219779 0.00170000 NUM43f7_da2c
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 5.08 | 3.65 | |||
| Beisner Road Entrance | 3.93 | 4.03 | 4.75 | 3.98 | 4.72 |
| Boat Launch Area | 4.46 | 3.46 | |||
| Busse Lake | 3.83 | 4.19 | 4.79 | ||
| Debra Park | 3.31 | ||||
| Elk Pasture | 4.98 | 3.79 | 4.14 | 3.85 | 4.21 |
| Forest Central Grove | 4.41 | 3.70 | 3.90 | 4.32 | |
| Forest North Grove | 3.64 | 4.08 | 3.87 | 4.36 | 3.60 |
| Forest South Grove | 3.68 | ||||
| Forest West Grove | 3.78 | ||||
| Lake Boating Center | 4.02 | ||||
| Large Event Area | 4.07 | 3.60 | 4.08 | 4.26 | |
| Main Dam | 3.67 | 4.43 | 3.82 | 4.24 | 3.89 |
| Main Pool | 3.87 | 4.40 | 3.32 | 4.17 | 3.55 |
| Marshall Park | 3.54 | 4.44 | 4.18 | ||
| Model Airplane Field | 5.28 | 3.84 | 4.11 | 4.07 | |
| Nature Preserve | 3.74 | 3.66 | 3.49 | ||
| Ned Brown Meadow | 4.64 | 4.63 | 3.32 | 4.28 | 4.12 |
| North Pool | 4.28 | 4.13 | 4.79 | 4.35 | 3.69 |
| Osborn Park | 3.43 | 3.49 | 3.74 | 3.79 | |
| Salt Creek Trail | 4.35 | 3.61 | 3.57 | ||
| South Pool | 4.61 | 4.20 | 4.00 | 4.78 | 4.26 |
| Wildlife Refuge | 3.98 | ||||
| Woodland Meadow | 4.23 | 4.37 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,,5.08,3.65
Beisner Road Entrance,3.93,4.03,4.75,3.98,4.72
Boat Launch Area,,,,4.46,3.46
Busse Lake,,,3.83,4.19,4.79
Debra Park,,,,,3.31
Elk Pasture,4.98,3.79,4.14,3.85,4.21
Forest Central Grove,,4.41,3.70,3.90,4.32
Forest North Grove,3.64,4.08,3.87,4.36,3.60
Forest South Grove,,,,,3.68
Forest West Grove,,,,,3.78
Lake Boating Center,,,,,4.02
Large Event Area,,4.07,3.60,4.08,4.26
Main Dam,3.67,4.43,3.82,4.24,3.89
Main Pool,3.87,4.40,3.32,4.17,3.55
Marshall Park,,,3.54,4.44,4.18
Model Airplane Field,,5.28,3.84,4.11,4.07
Nature Preserve,,,3.74,3.66,3.49
Ned Brown Meadow,4.64,4.63,3.32,4.28,4.12
North Pool,4.28,4.13,4.79,4.35,3.69
Osborn Park,,3.43,3.49,3.74,3.79
Salt Creek Trail,,,4.35,3.61,3.57
South Pool,4.61,4.20,4.00,4.78,4.26
Wildlife Refuge,,,,,3.98
Woodland Meadow,,,,4.23,4.37
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.06026976 0.00100000 NUM2800_7f4a
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.81 | 3.95 | 4.25 | ||
| Beisner Road Entrance | 3.19 | ||||
| Boat Launch Area | 4.33 | 4.03 | 4.28 | 4.16 | 4.68 |
| Busse Lake | 4.18 | 3.32 | |||
| Debra Park | 4.15 | 4.55 | 3.39 | 4.06 | 4.31 |
| Elk Pasture | 3.67 | 3.70 | |||
| Forest Central Grove | 3.57 | 4.53 | 4.45 | 4.12 | 4.12 |
| Forest North Grove | 4.54 | ||||
| Forest South Grove | 4.20 | 3.51 | 3.89 | 4.19 | 4.02 |
| Forest West Grove | 4.51 | 3.10 | 4.07 | ||
| Lake Boating Center | 3.73 | 3.94 | |||
| Large Event Area | 4.60 | 4.16 | 4.02 | ||
| Main Dam | 4.21 | 3.97 | 3.95 | 4.26 | 3.74 |
| Main Pool | 4.34 | 4.36 | 4.24 | ||
| Marshall Park | 4.45 | 3.74 | 4.57 | ||
| Model Airplane Field | 4.40 | 4.73 | |||
| Nature Preserve | 4.51 | 3.57 | 4.50 | 3.68 | 3.96 |
| Ned Brown Meadow | 3.32 | 4.14 | 3.73 | 4.16 | 3.27 |
| North Pool | 3.85 | 3.97 | 4.64 | 3.92 | |
| Osborn Park | 4.21 | 4.88 | 3.47 | 4.29 | |
| Salt Creek Trail | 4.10 | 3.57 | 3.80 | 4.02 | |
| South Pool | 3.81 | 4.62 | 4.97 | 4.51 | 4.21 |
| Wildlife Refuge | 3.36 | 4.70 | 4.49 | 3.74 | |
| Woodland Meadow | 4.14 | 4.06 | 4.54 | 4.13 | 3.74 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,3.81,3.95,4.25
Beisner Road Entrance,,,,,3.19
Boat Launch Area,4.33,4.03,4.28,4.16,4.68
Busse Lake,,,,4.18,3.32
Debra Park,4.15,4.55,3.39,4.06,4.31
Elk Pasture,,,,3.67,3.70
Forest Central Grove,3.57,4.53,4.45,4.12,4.12
Forest North Grove,,,,,4.54
Forest South Grove,4.20,3.51,3.89,4.19,4.02
Forest West Grove,,,4.51,3.10,4.07
Lake Boating Center,,,,3.73,3.94
Large Event Area,,,4.60,4.16,4.02
Main Dam,4.21,3.97,3.95,4.26,3.74
Main Pool,,,4.34,4.36,4.24
Marshall Park,,,4.45,3.74,4.57
Model Airplane Field,,,,4.40,4.73
Nature Preserve,4.51,3.57,4.50,3.68,3.96
Ned Brown Meadow,3.32,4.14,3.73,4.16,3.27
North Pool,,3.85,3.97,4.64,3.92
Osborn Park,,4.21,4.88,3.47,4.29
Salt Creek Trail,,4.10,3.57,3.80,4.02
South Pool,3.81,4.62,4.97,4.51,4.21
Wildlife Refuge,,3.36,4.70,4.49,3.74
Woodland Meadow,4.14,4.06,4.54,4.13,3.74
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.39611528 0.00400000 NUM2824_53e1
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.73 | 3.87 | 4.43 | ||
| Beisner Road Entrance | 3.52 | 3.40 | |||
| Boat Launch Area | 4.88 | 4.10 | 4.04 | ||
| Busse Lake | 4.00 | 4.42 | 3.30 | 4.14 | 4.39 |
| Debra Park | 3.99 | 3.98 | 4.50 | 3.68 | 4.03 |
| Elk Pasture | 3.71 | 4.32 | 3.72 | ||
| Forest Central Grove | 4.47 | 4.32 | 4.70 | 4.16 | 3.95 |
| Forest North Grove | 3.98 | 4.10 | |||
| Forest South Grove | 4.42 | 3.74 | 4.68 | ||
| Forest West Grove | 4.75 | 4.52 | 3.76 | 4.42 | 4.80 |
| Lake Boating Center | 3.65 | ||||
| Large Event Area | 4.70 | ||||
| Main Dam | 2.85 | 4.44 | 4.59 | 4.82 | 3.51 |
| Main Pool | 4.58 | 4.04 | 3.81 | 3.32 | 3.82 |
| Marshall Park | 3.96 | ||||
| Model Airplane Field | 3.91 | 2.99 | 4.80 | 4.30 | 4.63 |
| Nature Preserve | 3.65 | 3.07 | 4.00 | 4.14 | |
| Ned Brown Meadow | 4.07 | 3.51 | 4.83 | ||
| North Pool | 3.63 | 3.38 | 3.33 | 4.01 | 3.20 |
| Osborn Park | 4.68 | 3.04 | 4.11 | 3.93 | |
| Salt Creek Trail | 3.13 | 4.06 | 4.39 | 3.91 | 4.34 |
| South Pool | 3.25 | 4.59 | 3.74 | 3.61 | 3.84 |
| Wildlife Refuge | 3.29 | 3.39 | |||
| Woodland Meadow | 3.69 | 4.73 | 4.39 | 3.60 | 4.31 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,,,3.73,3.87,4.43
Beisner Road Entrance,,,,3.52,3.40
Boat Launch Area,,,4.88,4.10,4.04
Busse Lake,4.00,4.42,3.30,4.14,4.39
Debra Park,3.99,3.98,4.50,3.68,4.03
Elk Pasture,,,3.71,4.32,3.72
Forest Central Grove,4.47,4.32,4.70,4.16,3.95
Forest North Grove,,,,3.98,4.10
Forest South Grove,,,4.42,3.74,4.68
Forest West Grove,4.75,4.52,3.76,4.42,4.80
Lake Boating Center,,,,,3.65
Large Event Area,,,,,4.70
Main Dam,2.85,4.44,4.59,4.82,3.51
Main Pool,4.58,4.04,3.81,3.32,3.82
Marshall Park,,,,,3.96
Model Airplane Field,3.91,2.99,4.80,4.30,4.63
Nature Preserve,,3.65,3.07,4.00,4.14
Ned Brown Meadow,,,4.07,3.51,4.83
North Pool,3.63,3.38,3.33,4.01,3.20
Osborn Park,,4.68,3.04,4.11,3.93
Salt Creek Trail,3.13,4.06,4.39,3.91,4.34
South Pool,3.25,4.59,3.74,3.61,3.84
Wildlife Refuge,,,,3.29,3.39
Woodland Meadow,3.69,4.73,4.39,3.60,4.31
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.55366008 0.00550000 NUMc9f5_7097
ANOVA of Shannon Diversity: 1994, 2004, 2009, 2014, 2024
Compare microbial diversity across five years using one way ANOVA.
Sample Data Table:
Copy table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 1994 Shannon Index | 2004 Shannon Index | 2009 Shannon Index | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|---|---|---|
| Andrews Park | 3.79 | 2.93 | 4.45 | 3.79 | 3.90 |
| Beisner Road Entrance | 3.87 | 4.29 | 3.82 | 4.16 | 3.83 |
| Boat Launch Area | 3.25 | ||||
| Busse Lake | 3.52 | 3.57 | |||
| Debra Park | 4.22 | 4.44 | 3.59 | 4.54 | |
| Elk Pasture | 4.61 | 4.16 | 5.11 | 3.96 | 4.26 |
| Forest Central Grove | 3.20 | 4.73 | 4.74 | 3.49 | 4.47 |
| Forest North Grove | 4.16 | ||||
| Forest South Grove | 3.96 | ||||
| Forest West Grove | 4.13 | 4.08 | 4.56 | ||
| Lake Boating Center | 4.49 | 3.48 | |||
| Large Event Area | 4.22 | 4.11 | |||
| Main Dam | 4.00 | 3.44 | |||
| Main Pool | 4.23 | 4.60 | 3.73 | ||
| Marshall Park | 3.85 | 4.37 | 3.90 | ||
| Model Airplane Field | 3.60 | 3.99 | 4.56 | ||
| Nature Preserve | 3.78 | 4.06 | 3.85 | ||
| Ned Brown Meadow | 3.79 | ||||
| North Pool | 3.46 | 3.49 | 3.90 | 4.01 | |
| Osborn Park | 3.72 | 2.77 | 3.53 | 4.14 | 3.83 |
| Salt Creek Trail | 4.29 | ||||
| South Pool | 3.33 | 3.75 | 3.79 | 3.27 | 3.57 |
| Wildlife Refuge | 4.67 | 4.12 | 4.42 | 3.91 | 3.88 |
| Woodland Meadow | 3.82 | 3.93 | 4.67 | 4.43 | 3.86 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,1994 Shannon Index,2004 Shannon Index,2009 Shannon Index,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.79,2.93,4.45,3.79,3.90
Beisner Road Entrance,3.87,4.29,3.82,4.16,3.83
Boat Launch Area,,,,,3.25
Busse Lake,,,,3.52,3.57
Debra Park,,4.22,4.44,3.59,4.54
Elk Pasture,4.61,4.16,5.11,3.96,4.26
Forest Central Grove,3.20,4.73,4.74,3.49,4.47
Forest North Grove,,,,,4.16
Forest South Grove,,,,,3.96
Forest West Grove,,,4.13,4.08,4.56
Lake Boating Center,,,,4.49,3.48
Large Event Area,,,,4.22,4.11
Main Dam,,,,4.00,3.44
Main Pool,,,4.23,4.60,3.73
Marshall Park,,,3.85,4.37,3.90
Model Airplane Field,,,3.60,3.99,4.56
Nature Preserve,,,3.78,4.06,3.85
Ned Brown Meadow,,,,,3.79
North Pool,,3.46,3.49,3.90,4.01
Osborn Park,3.72,2.77,3.53,4.14,3.83
Salt Creek Trail,,,,,4.29
South Pool,3.33,3.75,3.79,3.27,3.57
Wildlife Refuge,4.67,4.12,4.42,3.91,3.88
Woodland Meadow,3.82,3.93,4.67,4.43,3.86
Enter the ANOVA p value as a decimal between 0 and 1.
Workflow: link here.
0.48861631 0.00490000