3f8c_5f5a
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 3.84 | 4.63 |
| Busse Lake | 3.92 | 4.26 |
| Elk Pasture | 3.10 | 3.97 |
| Forest North Grove | 3.67 | 3.94 |
| Lake Boating Center | 3.78 | 3.80 |
| Large Event Area | 3.75 | 4.77 |
| Main Pool | 4.39 | 3.81 |
| Marshall Park | 4.50 | 3.67 |
| Model Airplane Field | 4.23 | 3.76 |
| Ned Brown Meadow | 4.41 | 3.29 |
| North Pool | 3.88 | 3.78 |
| Salt Creek Trail | 4.32 | 3.70 |
| Woodland Meadow | 4.70 | 3.55 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.84,4.63
Busse Lake,3.92,4.26
Elk Pasture,3.10,3.97
Forest North Grove,3.67,3.94
Lake Boating Center,3.78,3.80
Large Event Area,3.75,4.77
Main Pool,4.39,3.81
Marshall Park,4.50,3.67
Model Airplane Field,4.23,3.76
Ned Brown Meadow,4.41,3.29
North Pool,3.88,3.78
Salt Creek Trail,4.32,3.70
Woodland Meadow,4.70,3.55
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.43412700 0.00430000 NUM4c23_515d
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 4.31 | 3.89 |
| Boat Launch Area | 3.41 | 4.51 |
| Busse Lake | 4.47 | 3.46 |
| Debra Park | 4.04 | 4.31 |
| Elk Pasture | 4.57 | 3.77 |
| Forest North Grove | 4.33 | 4.00 |
| Forest West Grove | 3.62 | 3.61 |
| Lake Boating Center | 3.57 | 4.31 |
| Main Pool | 3.45 | 4.14 |
| Marshall Park | 3.85 | 4.32 |
| Model Airplane Field | 3.76 | 4.17 |
| North Pool | 3.95 | 4.46 |
| Salt Creek Trail | 4.08 | 3.57 |
| Woodland Meadow | 4.26 | 4.13 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.31,3.89
Boat Launch Area,3.41,4.51
Busse Lake,4.47,3.46
Debra Park,4.04,4.31
Elk Pasture,4.57,3.77
Forest North Grove,4.33,4.00
Forest West Grove,3.62,3.61
Lake Boating Center,3.57,4.31
Main Pool,3.45,4.14
Marshall Park,3.85,4.32
Model Airplane Field,3.76,4.17
North Pool,3.95,4.46
Salt Creek Trail,4.08,3.57
Woodland Meadow,4.26,4.13
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.34247703 0.00340000 NUMa06b_0f2a
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 4.74 | 4.54 |
| Busse Lake | 3.28 | 4.02 |
| Debra Park | 3.88 | 3.44 |
| Elk Pasture | 4.63 | 3.88 |
| Forest West Grove | 4.35 | 3.86 |
| Lake Boating Center | 3.21 | 4.18 |
| Main Dam | 3.03 | 3.88 |
| Nature Preserve | 4.63 | 4.03 |
| Ned Brown Meadow | 4.39 | 3.84 |
| Osborn Park | 3.93 | 3.40 |
| Salt Creek Trail | 4.10 | 5.09 |
| South Pool | 3.73 | 3.58 |
| Woodland Meadow | 4.63 | 4.83 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.74,4.54
Busse Lake,3.28,4.02
Debra Park,3.88,3.44
Elk Pasture,4.63,3.88
Forest West Grove,4.35,3.86
Lake Boating Center,3.21,4.18
Main Dam,3.03,3.88
Nature Preserve,4.63,4.03
Ned Brown Meadow,4.39,3.84
Osborn Park,3.93,3.40
Salt Creek Trail,4.10,5.09
South Pool,3.73,3.58
Woodland Meadow,4.63,4.83
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.30706804 0.00310000 NUM6501_adb4
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Beisner Road Entrance | 1.92 | 4.09 |
| Boat Launch Area | 3.95 | 2.82 |
| Busse Lake | 3.92 | 4.29 |
| Debra Park | 4.91 | 4.13 |
| Elk Pasture | 4.22 | 4.15 |
| Forest Central Grove | 4.01 | 3.68 |
| Forest South Grove | 3.60 | 4.26 |
| Forest West Grove | 3.67 | 4.30 |
| Lake Boating Center | 2.93 | 3.81 |
| Large Event Area | 2.29 | 4.24 |
| Main Dam | 3.46 | 4.69 |
| Main Pool | 4.27 | 4.76 |
| Marshall Park | 3.46 | 4.32 |
| Model Airplane Field | 3.55 | 3.46 |
| Nature Preserve | 4.09 | 3.82 |
| Ned Brown Meadow | 3.11 | 4.05 |
| North Pool | 3.59 | 4.24 |
| Osborn Park | 2.87 | 2.97 |
| South Pool | 3.47 | 3.16 |
| Wildlife Refuge | 4.48 | 3.53 |
| Woodland Meadow | 4.81 | 3.89 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Beisner Road Entrance,1.92,4.09
Boat Launch Area,3.95,2.82
Busse Lake,3.92,4.29
Debra Park,4.91,4.13
Elk Pasture,4.22,4.15
Forest Central Grove,4.01,3.68
Forest South Grove,3.60,4.26
Forest West Grove,3.67,4.30
Lake Boating Center,2.93,3.81
Large Event Area,2.29,4.24
Main Dam,3.46,4.69
Main Pool,4.27,4.76
Marshall Park,3.46,4.32
Model Airplane Field,3.55,3.46
Nature Preserve,4.09,3.82
Ned Brown Meadow,3.11,4.05
North Pool,3.59,4.24
Osborn Park,2.87,2.97
South Pool,3.47,3.16
Wildlife Refuge,4.48,3.53
Woodland Meadow,4.81,3.89
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.05252363 0.00100000 NUM010a_62b3
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 4.80 | 4.68 |
| Beisner Road Entrance | 4.64 | 3.23 |
| Busse Lake | 4.79 | 4.20 |
| Elk Pasture | 4.47 | 4.05 |
| Forest Central Grove | 3.44 | 3.60 |
| Forest South Grove | 4.49 | 4.14 |
| Lake Boating Center | 3.21 | 4.15 |
| Main Dam | 3.44 | 4.03 |
| Main Pool | 4.54 | 4.25 |
| North Pool | 5.50 | 4.20 |
| Osborn Park | 4.10 | 3.92 |
| South Pool | 4.41 | 4.84 |
| Wildlife Refuge | 3.72 | 4.38 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.80,4.68
Beisner Road Entrance,4.64,3.23
Busse Lake,4.79,4.20
Elk Pasture,4.47,4.05
Forest Central Grove,3.44,3.60
Forest South Grove,4.49,4.14
Lake Boating Center,3.21,4.15
Main Dam,3.44,4.03
Main Pool,4.54,4.25
North Pool,5.50,4.20
Osborn Park,4.10,3.92
South Pool,4.41,4.84
Wildlife Refuge,3.72,4.38
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.05928937 0.00100000 NUM66e3_a810
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 3.54 | 4.01 |
| Beisner Road Entrance | 3.39 | 4.51 |
| Boat Launch Area | 3.93 | 3.73 |
| Busse Lake | 4.28 | 4.13 |
| Elk Pasture | 3.66 | 3.75 |
| Forest North Grove | 4.20 | 3.92 |
| Forest South Grove | 4.42 | 2.76 |
| Lake Boating Center | 3.15 | 3.59 |
| Large Event Area | 4.62 | 4.16 |
| Main Dam | 3.94 | 3.46 |
| Marshall Park | 3.17 | 4.33 |
| Model Airplane Field | 4.34 | 3.92 |
| Ned Brown Meadow | 2.80 | 4.22 |
| North Pool | 4.17 | 3.81 |
| Salt Creek Trail | 3.39 | 3.53 |
| South Pool | 4.18 | 4.44 |
| Wildlife Refuge | 4.27 | 3.77 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.54,4.01
Beisner Road Entrance,3.39,4.51
Boat Launch Area,3.93,3.73
Busse Lake,4.28,4.13
Elk Pasture,3.66,3.75
Forest North Grove,4.20,3.92
Forest South Grove,4.42,2.76
Lake Boating Center,3.15,3.59
Large Event Area,4.62,4.16
Main Dam,3.94,3.46
Marshall Park,3.17,4.33
Model Airplane Field,4.34,3.92
Ned Brown Meadow,2.80,4.22
North Pool,4.17,3.81
Salt Creek Trail,3.39,3.53
South Pool,4.18,4.44
Wildlife Refuge,4.27,3.77
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.19392220 0.00190000 NUMb2b7_3e49
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 4.20 | 4.25 |
| Beisner Road Entrance | 3.92 | 4.03 |
| Boat Launch Area | 3.33 | 3.94 |
| Debra Park | 4.38 | 3.93 |
| Elk Pasture | 3.97 | 3.96 |
| Forest Central Grove | 3.51 | 3.99 |
| Forest North Grove | 4.48 | 3.75 |
| Forest West Grove | 4.30 | 4.05 |
| Lake Boating Center | 4.33 | 4.77 |
| Large Event Area | 4.55 | 3.87 |
| Main Dam | 3.88 | 3.94 |
| Main Pool | 4.83 | 4.25 |
| Marshall Park | 3.33 | 3.91 |
| North Pool | 3.87 | 3.71 |
| Salt Creek Trail | 4.38 | 3.17 |
| South Pool | 4.31 | 4.61 |
| Wildlife Refuge | 4.67 | 4.33 |
| Woodland Meadow | 4.06 | 3.86 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.20,4.25
Beisner Road Entrance,3.92,4.03
Boat Launch Area,3.33,3.94
Debra Park,4.38,3.93
Elk Pasture,3.97,3.96
Forest Central Grove,3.51,3.99
Forest North Grove,4.48,3.75
Forest West Grove,4.30,4.05
Lake Boating Center,4.33,4.77
Large Event Area,4.55,3.87
Main Dam,3.88,3.94
Main Pool,4.83,4.25
Marshall Park,3.33,3.91
North Pool,3.87,3.71
Salt Creek Trail,4.38,3.17
South Pool,4.31,4.61
Wildlife Refuge,4.67,4.33
Woodland Meadow,4.06,3.86
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.19778741 0.00200000 NUM1c10_4810
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 4.90 | 4.35 |
| Beisner Road Entrance | 3.41 | 4.43 |
| Boat Launch Area | 4.50 | 3.54 |
| Busse Lake | 4.41 | 3.48 |
| Debra Park | 4.31 | 3.97 |
| Elk Pasture | 4.95 | 3.91 |
| Forest Central Grove | 4.00 | 3.35 |
| Forest North Grove | 4.32 | 4.21 |
| Forest South Grove | 3.88 | 3.99 |
| Lake Boating Center | 4.54 | 4.15 |
| Large Event Area | 4.48 | 4.33 |
| Main Dam | 5.07 | 3.80 |
| Main Pool | 4.36 | 4.59 |
| Model Airplane Field | 3.82 | 4.06 |
| Nature Preserve | 3.55 | 4.76 |
| Ned Brown Meadow | 3.89 | 3.68 |
| North Pool | 5.27 | 4.52 |
| Osborn Park | 4.15 | 3.67 |
| Salt Creek Trail | 3.66 | 4.16 |
| South Pool | 4.53 | 4.16 |
| Wildlife Refuge | 3.60 | 3.77 |
| Woodland Meadow | 4.57 | 3.85 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.90,4.35
Beisner Road Entrance,3.41,4.43
Boat Launch Area,4.50,3.54
Busse Lake,4.41,3.48
Debra Park,4.31,3.97
Elk Pasture,4.95,3.91
Forest Central Grove,4.00,3.35
Forest North Grove,4.32,4.21
Forest South Grove,3.88,3.99
Lake Boating Center,4.54,4.15
Large Event Area,4.48,4.33
Main Dam,5.07,3.80
Main Pool,4.36,4.59
Model Airplane Field,3.82,4.06
Nature Preserve,3.55,4.76
Ned Brown Meadow,3.89,3.68
North Pool,5.27,4.52
Osborn Park,4.15,3.67
Salt Creek Trail,3.66,4.16
South Pool,4.53,4.16
Wildlife Refuge,3.60,3.77
Woodland Meadow,4.57,3.85
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.07954335 0.00100000 NUM8eb0_434c
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 3.49 | 4.12 |
| Boat Launch Area | 4.01 | 3.98 |
| Busse Lake | 3.61 | 4.19 |
| Debra Park | 3.93 | 3.89 |
| Elk Pasture | 4.59 | 4.23 |
| Forest North Grove | 3.10 | 3.78 |
| Forest South Grove | 3.17 | 4.25 |
| Forest West Grove | 3.88 | 4.07 |
| Lake Boating Center | 3.44 | 4.76 |
| Main Dam | 4.11 | 4.08 |
| Main Pool | 3.89 | 3.63 |
| Marshall Park | 3.81 | 3.40 |
| Model Airplane Field | 2.93 | 3.66 |
| Nature Preserve | 2.91 | 3.95 |
| Ned Brown Meadow | 3.75 | 4.13 |
| North Pool | 3.91 | 4.50 |
| Osborn Park | 4.56 | 3.59 |
| South Pool | 3.67 | 4.87 |
| Woodland Meadow | 3.47 | 3.85 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.49,4.12
Boat Launch Area,4.01,3.98
Busse Lake,3.61,4.19
Debra Park,3.93,3.89
Elk Pasture,4.59,4.23
Forest North Grove,3.10,3.78
Forest South Grove,3.17,4.25
Forest West Grove,3.88,4.07
Lake Boating Center,3.44,4.76
Main Dam,4.11,4.08
Main Pool,3.89,3.63
Marshall Park,3.81,3.40
Model Airplane Field,2.93,3.66
Nature Preserve,2.91,3.95
Ned Brown Meadow,3.75,4.13
North Pool,3.91,4.50
Osborn Park,4.56,3.59
South Pool,3.67,4.87
Woodland Meadow,3.47,3.85
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.18355287 0.00180000 NUMe89e_afd2
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 3.37 | 4.15 |
| Busse Lake | 4.11 | 3.54 |
| Debra Park | 4.70 | 4.35 |
| Elk Pasture | 3.31 | 4.02 |
| Forest Central Grove | 3.31 | 4.10 |
| Forest North Grove | 4.18 | 3.23 |
| Forest South Grove | 4.16 | 3.38 |
| Forest West Grove | 3.13 | 4.55 |
| Lake Boating Center | 4.50 | 4.37 |
| Main Dam | 4.99 | 4.58 |
| Marshall Park | 4.60 | 4.51 |
| Ned Brown Meadow | 3.78 | 4.26 |
| North Pool | 4.53 | 4.09 |
| Osborn Park | 4.87 | 3.68 |
| Salt Creek Trail | 4.69 | 3.13 |
| South Pool | 3.63 | 3.69 |
| Woodland Meadow | 3.37 | 3.72 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.37,4.15
Busse Lake,4.11,3.54
Debra Park,4.70,4.35
Elk Pasture,3.31,4.02
Forest Central Grove,3.31,4.10
Forest North Grove,4.18,3.23
Forest South Grove,4.16,3.38
Forest West Grove,3.13,4.55
Lake Boating Center,4.50,4.37
Main Dam,4.99,4.58
Marshall Park,4.60,4.51
Ned Brown Meadow,3.78,4.26
North Pool,4.53,4.09
Osborn Park,4.87,3.68
Salt Creek Trail,4.69,3.13
South Pool,3.63,3.69
Woodland Meadow,3.37,3.72
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.12353020 0.00120000 NUMb5c2_ba35
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 4.57 | 3.87 |
| Beisner Road Entrance | 5.55 | 3.29 |
| Elk Pasture | 3.45 | 4.73 |
| Forest South Grove | 3.08 | 3.57 |
| Forest West Grove | 4.66 | 3.61 |
| Lake Boating Center | 4.15 | 4.21 |
| Large Event Area | 3.26 | 5.05 |
| Model Airplane Field | 3.75 | 4.13 |
| Ned Brown Meadow | 3.43 | 3.74 |
| North Pool | 4.50 | 4.54 |
| Osborn Park | 4.00 | 4.41 |
| Salt Creek Trail | 3.29 | 3.86 |
| South Pool | 3.94 | 3.94 |
| Woodland Meadow | 3.93 | 4.00 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.57,3.87
Beisner Road Entrance,5.55,3.29
Elk Pasture,3.45,4.73
Forest South Grove,3.08,3.57
Forest West Grove,4.66,3.61
Lake Boating Center,4.15,4.21
Large Event Area,3.26,5.05
Model Airplane Field,3.75,4.13
Ned Brown Meadow,3.43,3.74
North Pool,4.50,4.54
Osborn Park,4.00,4.41
Salt Creek Trail,3.29,3.86
South Pool,3.94,3.94
Woodland Meadow,3.93,4.00
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.11579384 0.00120000 NUMfc28_9210
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 3.74 | 4.21 |
| Boat Launch Area | 3.72 | 4.31 |
| Busse Lake | 4.73 | 3.86 |
| Debra Park | 3.30 | 3.38 |
| Elk Pasture | 3.84 | 4.09 |
| Forest Central Grove | 4.79 | 4.15 |
| Forest North Grove | 4.79 | 3.90 |
| Forest South Grove | 3.49 | 3.98 |
| Lake Boating Center | 4.63 | 4.37 |
| Marshall Park | 3.81 | 4.47 |
| Nature Preserve | 3.97 | 4.32 |
| North Pool | 3.71 | 2.97 |
| Osborn Park | 3.54 | 4.63 |
| Wildlife Refuge | 4.77 | 3.37 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.74,4.21
Boat Launch Area,3.72,4.31
Busse Lake,4.73,3.86
Debra Park,3.30,3.38
Elk Pasture,3.84,4.09
Forest Central Grove,4.79,4.15
Forest North Grove,4.79,3.90
Forest South Grove,3.49,3.98
Lake Boating Center,4.63,4.37
Marshall Park,3.81,4.47
Nature Preserve,3.97,4.32
North Pool,3.71,2.97
Osborn Park,3.54,4.63
Wildlife Refuge,4.77,3.37
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.28878933 0.00290000 NUM0b16_aa85
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 4.20 | 4.53 |
| Beisner Road Entrance | 3.48 | 4.04 |
| Busse Lake | 4.24 | 4.07 |
| Debra Park | 3.83 | 4.28 |
| Lake Boating Center | 3.44 | 4.93 |
| Main Pool | 3.95 | 4.17 |
| Model Airplane Field | 4.97 | 4.04 |
| Nature Preserve | 4.33 | 3.49 |
| Ned Brown Meadow | 3.18 | 4.32 |
| South Pool | 3.18 | 4.53 |
| Wildlife Refuge | 3.87 | 4.28 |
| Woodland Meadow | 4.21 | 3.67 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.20,4.53
Beisner Road Entrance,3.48,4.04
Busse Lake,4.24,4.07
Debra Park,3.83,4.28
Lake Boating Center,3.44,4.93
Main Pool,3.95,4.17
Model Airplane Field,4.97,4.04
Nature Preserve,4.33,3.49
Ned Brown Meadow,3.18,4.32
South Pool,3.18,4.53
Wildlife Refuge,3.87,4.28
Woodland Meadow,4.21,3.67
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.15542859 0.00160000 NUM8138_473a
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 4.14 | 4.31 |
| Beisner Road Entrance | 3.83 | 4.50 |
| Boat Launch Area | 4.97 | 3.27 |
| Busse Lake | 3.58 | 4.04 |
| Debra Park | 4.50 | 3.45 |
| Elk Pasture | 4.76 | 4.28 |
| Forest Central Grove | 5.39 | 3.89 |
| Forest North Grove | 3.90 | 4.04 |
| Forest West Grove | 3.81 | 3.36 |
| Lake Boating Center | 3.76 | 4.49 |
| Large Event Area | 3.83 | 3.37 |
| Main Dam | 4.65 | 3.56 |
| Main Pool | 4.34 | 3.80 |
| Marshall Park | 3.67 | 4.20 |
| Model Airplane Field | 4.75 | 4.22 |
| Nature Preserve | 3.22 | 4.11 |
| Ned Brown Meadow | 2.75 | 3.65 |
| North Pool | 4.31 | 3.64 |
| Osborn Park | 4.64 | 2.65 |
| Salt Creek Trail | 4.54 | 2.89 |
| South Pool | 4.31 | 4.73 |
| Wildlife Refuge | 2.54 | 3.91 |
| Woodland Meadow | 2.87 | 2.58 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.14,4.31
Beisner Road Entrance,3.83,4.50
Boat Launch Area,4.97,3.27
Busse Lake,3.58,4.04
Debra Park,4.50,3.45
Elk Pasture,4.76,4.28
Forest Central Grove,5.39,3.89
Forest North Grove,3.90,4.04
Forest West Grove,3.81,3.36
Lake Boating Center,3.76,4.49
Large Event Area,3.83,3.37
Main Dam,4.65,3.56
Main Pool,4.34,3.80
Marshall Park,3.67,4.20
Model Airplane Field,4.75,4.22
Nature Preserve,3.22,4.11
Ned Brown Meadow,2.75,3.65
North Pool,4.31,3.64
Osborn Park,4.64,2.65
Salt Creek Trail,4.54,2.89
South Pool,4.31,4.73
Wildlife Refuge,2.54,3.91
Woodland Meadow,2.87,2.58
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.14595727 0.00150000 NUMe6f6_04d3
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 3.50 | 4.15 |
| Beisner Road Entrance | 3.86 | 3.45 |
| Boat Launch Area | 3.57 | 3.40 |
| Busse Lake | 3.85 | 4.48 |
| Debra Park | 4.00 | 4.09 |
| Forest Central Grove | 4.35 | 4.01 |
| Forest North Grove | 4.29 | 3.89 |
| Forest South Grove | 3.69 | 4.23 |
| Forest West Grove | 4.16 | 3.85 |
| Lake Boating Center | 4.39 | 4.42 |
| Large Event Area | 4.32 | 3.71 |
| Main Dam | 5.01 | 3.63 |
| Main Pool | 3.32 | 4.58 |
| Marshall Park | 4.07 | 3.88 |
| Nature Preserve | 4.31 | 3.49 |
| Ned Brown Meadow | 3.57 | 4.24 |
| Osborn Park | 4.02 | 4.15 |
| Salt Creek Trail | 2.93 | 4.02 |
| South Pool | 4.19 | 3.45 |
| Wildlife Refuge | 4.02 | 3.87 |
| Woodland Meadow | 4.35 | 3.98 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.50,4.15
Beisner Road Entrance,3.86,3.45
Boat Launch Area,3.57,3.40
Busse Lake,3.85,4.48
Debra Park,4.00,4.09
Forest Central Grove,4.35,4.01
Forest North Grove,4.29,3.89
Forest South Grove,3.69,4.23
Forest West Grove,4.16,3.85
Lake Boating Center,4.39,4.42
Large Event Area,4.32,3.71
Main Dam,5.01,3.63
Main Pool,3.32,4.58
Marshall Park,4.07,3.88
Nature Preserve,4.31,3.49
Ned Brown Meadow,3.57,4.24
Osborn Park,4.02,4.15
Salt Creek Trail,2.93,4.02
South Pool,4.19,3.45
Wildlife Refuge,4.02,3.87
Woodland Meadow,4.35,3.98
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.11131697 0.00110000 NUMa119_6f55
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 3.33 | 3.85 |
| Beisner Road Entrance | 3.55 | 3.75 |
| Boat Launch Area | 3.59 | 3.43 |
| Busse Lake | 2.89 | 4.06 |
| Debra Park | 4.24 | 3.89 |
| Elk Pasture | 3.28 | 3.39 |
| Forest Central Grove | 4.46 | 4.88 |
| Forest North Grove | 4.77 | 4.72 |
| Forest South Grove | 3.84 | 3.09 |
| Forest West Grove | 3.99 | 3.93 |
| Lake Boating Center | 4.18 | 3.69 |
| Large Event Area | 4.07 | 4.24 |
| Main Dam | 2.87 | 3.42 |
| Main Pool | 4.28 | 4.16 |
| Marshall Park | 3.29 | 4.06 |
| Model Airplane Field | 4.10 | 3.81 |
| Nature Preserve | 4.76 | 4.75 |
| Ned Brown Meadow | 3.84 | 3.65 |
| North Pool | 4.79 | 3.69 |
| Osborn Park | 3.95 | 4.04 |
| Salt Creek Trail | 3.44 | 3.97 |
| South Pool | 4.60 | 4.34 |
| Wildlife Refuge | 3.97 | 4.57 |
| Woodland Meadow | 5.36 | 4.43 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.33,3.85
Beisner Road Entrance,3.55,3.75
Boat Launch Area,3.59,3.43
Busse Lake,2.89,4.06
Debra Park,4.24,3.89
Elk Pasture,3.28,3.39
Forest Central Grove,4.46,4.88
Forest North Grove,4.77,4.72
Forest South Grove,3.84,3.09
Forest West Grove,3.99,3.93
Lake Boating Center,4.18,3.69
Large Event Area,4.07,4.24
Main Dam,2.87,3.42
Main Pool,4.28,4.16
Marshall Park,3.29,4.06
Model Airplane Field,4.10,3.81
Nature Preserve,4.76,4.75
Ned Brown Meadow,3.84,3.65
North Pool,4.79,3.69
Osborn Park,3.95,4.04
Salt Creek Trail,3.44,3.97
South Pool,4.60,4.34
Wildlife Refuge,3.97,4.57
Woodland Meadow,5.36,4.43
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.07148599 0.00100000 NUM52fe_5898
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Beisner Road Entrance | 4.44 | 3.07 |
| Boat Launch Area | 4.16 | 4.18 |
| Busse Lake | 4.56 | 4.37 |
| Elk Pasture | 4.15 | 4.47 |
| Forest Central Grove | 3.70 | 4.28 |
| Forest North Grove | 4.58 | 3.80 |
| Forest South Grove | 4.47 | 3.74 |
| Forest West Grove | 4.27 | 4.37 |
| Lake Boating Center | 2.78 | 3.08 |
| Large Event Area | 3.17 | 3.59 |
| Main Dam | 4.75 | 3.42 |
| Marshall Park | 4.01 | 4.85 |
| Model Airplane Field | 3.48 | 3.48 |
| North Pool | 4.06 | 4.35 |
| Osborn Park | 3.91 | 4.44 |
| South Pool | 3.77 | 3.96 |
| Wildlife Refuge | 3.96 | 3.97 |
| Woodland Meadow | 4.42 | 3.51 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Beisner Road Entrance,4.44,3.07
Boat Launch Area,4.16,4.18
Busse Lake,4.56,4.37
Elk Pasture,4.15,4.47
Forest Central Grove,3.70,4.28
Forest North Grove,4.58,3.80
Forest South Grove,4.47,3.74
Forest West Grove,4.27,4.37
Lake Boating Center,2.78,3.08
Large Event Area,3.17,3.59
Main Dam,4.75,3.42
Marshall Park,4.01,4.85
Model Airplane Field,3.48,3.48
North Pool,4.06,4.35
Osborn Park,3.91,4.44
South Pool,3.77,3.96
Wildlife Refuge,3.96,3.97
Woodland Meadow,4.42,3.51
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.48388152 0.00480000 NUMb598_9e82
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Beisner Road Entrance | 3.25 | 3.71 |
| Boat Launch Area | 4.22 | 3.90 |
| Busse Lake | 3.92 | 4.68 |
| Elk Pasture | 3.63 | 3.60 |
| Forest North Grove | 3.93 | 3.68 |
| Forest West Grove | 3.90 | 4.30 |
| Lake Boating Center | 4.21 | 4.36 |
| Large Event Area | 3.83 | 4.22 |
| Main Dam | 4.09 | 3.23 |
| Marshall Park | 3.91 | 3.43 |
| Model Airplane Field | 3.58 | 3.90 |
| Ned Brown Meadow | 3.93 | 3.94 |
| Osborn Park | 5.30 | 3.62 |
| Salt Creek Trail | 3.23 | 3.49 |
| South Pool | 4.74 | 3.70 |
| Woodland Meadow | 3.61 | 4.59 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Beisner Road Entrance,3.25,3.71
Boat Launch Area,4.22,3.90
Busse Lake,3.92,4.68
Elk Pasture,3.63,3.60
Forest North Grove,3.93,3.68
Forest West Grove,3.90,4.30
Lake Boating Center,4.21,4.36
Large Event Area,3.83,4.22
Main Dam,4.09,3.23
Marshall Park,3.91,3.43
Model Airplane Field,3.58,3.90
Ned Brown Meadow,3.93,3.94
Osborn Park,5.30,3.62
Salt Creek Trail,3.23,3.49
South Pool,4.74,3.70
Woodland Meadow,3.61,4.59
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.22727015 0.00230000 NUMab85_1022
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Beisner Road Entrance | 4.64 | 3.73 |
| Debra Park | 3.94 | 4.27 |
| Elk Pasture | 3.57 | 4.14 |
| Forest Central Grove | 3.74 | 3.32 |
| Forest North Grove | 3.91 | 3.60 |
| Lake Boating Center | 4.57 | 3.54 |
| Large Event Area | 4.25 | 3.62 |
| Main Dam | 4.38 | 4.23 |
| Main Pool | 3.81 | 3.91 |
| Marshall Park | 3.00 | 4.37 |
| Model Airplane Field | 4.50 | 4.53 |
| Nature Preserve | 3.94 | 4.13 |
| North Pool | 4.31 | 3.79 |
| Osborn Park | 4.76 | 4.41 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Beisner Road Entrance,4.64,3.73
Debra Park,3.94,4.27
Elk Pasture,3.57,4.14
Forest Central Grove,3.74,3.32
Forest North Grove,3.91,3.60
Lake Boating Center,4.57,3.54
Large Event Area,4.25,3.62
Main Dam,4.38,4.23
Main Pool,3.81,3.91
Marshall Park,3.00,4.37
Model Airplane Field,4.50,4.53
Nature Preserve,3.94,4.13
North Pool,4.31,3.79
Osborn Park,4.76,4.41
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.18772261 0.00190000 NUMe501_729c
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 4.42 | 4.19 |
| Beisner Road Entrance | 4.81 | 3.02 |
| Boat Launch Area | 3.57 | 4.02 |
| Busse Lake | 3.21 | 4.42 |
| Debra Park | 4.14 | 4.29 |
| Elk Pasture | 4.27 | 4.11 |
| Forest Central Grove | 4.17 | 3.69 |
| Forest North Grove | 2.26 | 3.51 |
| Lake Boating Center | 3.41 | 4.31 |
| Main Pool | 4.11 | 4.74 |
| Marshall Park | 4.63 | 4.17 |
| Model Airplane Field | 3.21 | 4.73 |
| Nature Preserve | 4.41 | 4.00 |
| North Pool | 4.77 | 4.47 |
| Osborn Park | 3.87 | 3.79 |
| Salt Creek Trail | 3.86 | 4.20 |
| South Pool | 3.51 | 4.39 |
| Wildlife Refuge | 4.19 | 3.00 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.42,4.19
Beisner Road Entrance,4.81,3.02
Boat Launch Area,3.57,4.02
Busse Lake,3.21,4.42
Debra Park,4.14,4.29
Elk Pasture,4.27,4.11
Forest Central Grove,4.17,3.69
Forest North Grove,2.26,3.51
Lake Boating Center,3.41,4.31
Main Pool,4.11,4.74
Marshall Park,4.63,4.17
Model Airplane Field,3.21,4.73
Nature Preserve,4.41,4.00
North Pool,4.77,4.47
Osborn Park,3.87,3.79
Salt Creek Trail,3.86,4.20
South Pool,3.51,4.39
Wildlife Refuge,4.19,3.00
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.14089520 0.00140000 NUMe73c_b2d2
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 3.90 | 3.83 |
| Busse Lake | 4.60 | 4.40 |
| Debra Park | 4.32 | 4.26 |
| Elk Pasture | 4.72 | 3.48 |
| Forest Central Grove | 4.65 | 4.33 |
| Forest North Grove | 3.89 | 3.52 |
| Forest South Grove | 2.63 | 3.98 |
| Large Event Area | 3.86 | 3.67 |
| Main Dam | 4.00 | 4.79 |
| Marshall Park | 3.89 | 3.40 |
| Nature Preserve | 4.63 | 4.84 |
| Ned Brown Meadow | 4.07 | 3.96 |
| Salt Creek Trail | 3.87 | 4.71 |
| Woodland Meadow | 3.51 | 4.20 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.90,3.83
Busse Lake,4.60,4.40
Debra Park,4.32,4.26
Elk Pasture,4.72,3.48
Forest Central Grove,4.65,4.33
Forest North Grove,3.89,3.52
Forest South Grove,2.63,3.98
Large Event Area,3.86,3.67
Main Dam,4.00,4.79
Marshall Park,3.89,3.40
Nature Preserve,4.63,4.84
Ned Brown Meadow,4.07,3.96
Salt Creek Trail,3.87,4.71
Woodland Meadow,3.51,4.20
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.32599504 0.00330000 NUM105d_a524
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 4.11 | 4.71 |
| Boat Launch Area | 4.04 | 4.06 |
| Busse Lake | 3.31 | 4.71 |
| Debra Park | 4.06 | 4.10 |
| Forest Central Grove | 4.10 | 4.19 |
| Forest North Grove | 3.95 | 3.65 |
| Forest South Grove | 4.54 | 5.00 |
| Lake Boating Center | 3.63 | 4.09 |
| Large Event Area | 3.52 | 4.09 |
| Main Pool | 4.02 | 5.24 |
| Marshall Park | 3.14 | 4.18 |
| Model Airplane Field | 4.53 | 4.11 |
| Ned Brown Meadow | 3.66 | 4.33 |
| North Pool | 3.58 | 3.56 |
| Salt Creek Trail | 4.62 | 4.04 |
| South Pool | 2.89 | 3.86 |
| Wildlife Refuge | 5.01 | 3.64 |
| Woodland Meadow | 4.64 | 4.57 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.11,4.71
Boat Launch Area,4.04,4.06
Busse Lake,3.31,4.71
Debra Park,4.06,4.10
Forest Central Grove,4.10,4.19
Forest North Grove,3.95,3.65
Forest South Grove,4.54,5.00
Lake Boating Center,3.63,4.09
Large Event Area,3.52,4.09
Main Pool,4.02,5.24
Marshall Park,3.14,4.18
Model Airplane Field,4.53,4.11
Ned Brown Meadow,3.66,4.33
North Pool,3.58,3.56
Salt Creek Trail,4.62,4.04
South Pool,2.89,3.86
Wildlife Refuge,5.01,3.64
Woodland Meadow,4.64,4.57
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.19688474 0.00200000 NUMf8b1_3fef
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 2.31 | 4.14 |
| Busse Lake | 4.23 | 4.60 |
| Debra Park | 4.20 | 4.95 |
| Forest North Grove | 3.93 | 3.81 |
| Forest South Grove | 3.68 | 3.81 |
| Large Event Area | 4.29 | 3.47 |
| Main Dam | 3.87 | 3.81 |
| Main Pool | 3.22 | 3.48 |
| Nature Preserve | 3.55 | 3.57 |
| North Pool | 3.66 | 4.01 |
| South Pool | 2.87 | 4.33 |
| Wildlife Refuge | 4.84 | 3.43 |
| Woodland Meadow | 3.80 | 4.33 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,2.31,4.14
Busse Lake,4.23,4.60
Debra Park,4.20,4.95
Forest North Grove,3.93,3.81
Forest South Grove,3.68,3.81
Large Event Area,4.29,3.47
Main Dam,3.87,3.81
Main Pool,3.22,3.48
Nature Preserve,3.55,3.57
North Pool,3.66,4.01
South Pool,2.87,4.33
Wildlife Refuge,4.84,3.43
Woodland Meadow,3.80,4.33
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.13475566 0.00130000 NUMd1b3_4fe9
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Beisner Road Entrance | 3.25 | 3.22 |
| Boat Launch Area | 3.59 | 4.05 |
| Busse Lake | 3.13 | 3.98 |
| Elk Pasture | 3.57 | 2.95 |
| Forest Central Grove | 2.56 | 4.18 |
| Forest South Grove | 3.43 | 4.04 |
| Forest West Grove | 3.98 | 3.55 |
| Lake Boating Center | 3.64 | 3.97 |
| Large Event Area | 4.69 | 4.21 |
| Main Pool | 2.86 | 4.45 |
| Model Airplane Field | 4.15 | 4.12 |
| Ned Brown Meadow | 3.40 | 4.31 |
| North Pool | 4.13 | 4.18 |
| Osborn Park | 3.02 | 4.35 |
| Salt Creek Trail | 4.44 | 3.47 |
| South Pool | 3.71 | 4.05 |
| Wildlife Refuge | 3.04 | 4.51 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Beisner Road Entrance,3.25,3.22
Boat Launch Area,3.59,4.05
Busse Lake,3.13,3.98
Elk Pasture,3.57,2.95
Forest Central Grove,2.56,4.18
Forest South Grove,3.43,4.04
Forest West Grove,3.98,3.55
Lake Boating Center,3.64,3.97
Large Event Area,4.69,4.21
Main Pool,2.86,4.45
Model Airplane Field,4.15,4.12
Ned Brown Meadow,3.40,4.31
North Pool,4.13,4.18
Osborn Park,3.02,4.35
Salt Creek Trail,4.44,3.47
South Pool,3.71,4.05
Wildlife Refuge,3.04,4.51
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.13190807 0.00130000 NUM1faf_e0c0
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 3.83 | 4.14 |
| Beisner Road Entrance | 4.55 | 4.05 |
| Boat Launch Area | 2.76 | 4.20 |
| Busse Lake | 5.23 | 4.63 |
| Debra Park | 3.18 | 3.07 |
| Forest Central Grove | 4.01 | 4.01 |
| Forest North Grove | 3.86 | 4.15 |
| Forest South Grove | 3.36 | 3.75 |
| Forest West Grove | 4.68 | 3.71 |
| Lake Boating Center | 3.71 | 4.52 |
| Large Event Area | 4.39 | 5.25 |
| Main Dam | 3.81 | 3.58 |
| Main Pool | 4.54 | 4.40 |
| Marshall Park | 3.10 | 3.93 |
| Model Airplane Field | 4.11 | 3.89 |
| Nature Preserve | 4.64 | 3.97 |
| Ned Brown Meadow | 4.00 | 4.54 |
| North Pool | 3.60 | 4.15 |
| Osborn Park | 3.88 | 3.76 |
| Salt Creek Trail | 2.99 | 4.85 |
| South Pool | 4.64 | 4.27 |
| Wildlife Refuge | 3.99 | 4.20 |
| Woodland Meadow | 3.44 | 4.09 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.83,4.14
Beisner Road Entrance,4.55,4.05
Boat Launch Area,2.76,4.20
Busse Lake,5.23,4.63
Debra Park,3.18,3.07
Forest Central Grove,4.01,4.01
Forest North Grove,3.86,4.15
Forest South Grove,3.36,3.75
Forest West Grove,4.68,3.71
Lake Boating Center,3.71,4.52
Large Event Area,4.39,5.25
Main Dam,3.81,3.58
Main Pool,4.54,4.40
Marshall Park,3.10,3.93
Model Airplane Field,4.11,3.89
Nature Preserve,4.64,3.97
Ned Brown Meadow,4.00,4.54
North Pool,3.60,4.15
Osborn Park,3.88,3.76
Salt Creek Trail,2.99,4.85
South Pool,4.64,4.27
Wildlife Refuge,3.99,4.20
Woodland Meadow,3.44,4.09
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.06887180 0.00100000 NUMe1cf_1457
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 4.44 | 2.88 |
| Beisner Road Entrance | 3.95 | 2.82 |
| Boat Launch Area | 5.26 | 3.27 |
| Busse Lake | 3.34 | 2.94 |
| Elk Pasture | 4.28 | 4.64 |
| Forest North Grove | 4.80 | 4.54 |
| Forest South Grove | 3.41 | 4.00 |
| Forest West Grove | 3.39 | 5.00 |
| Lake Boating Center | 4.86 | 3.71 |
| Large Event Area | 3.74 | 4.09 |
| Main Dam | 3.64 | 3.73 |
| Marshall Park | 4.35 | 3.62 |
| Model Airplane Field | 4.91 | 3.96 |
| Nature Preserve | 4.47 | 3.62 |
| Ned Brown Meadow | 3.11 | 3.63 |
| Osborn Park | 4.97 | 5.17 |
| Salt Creek Trail | 3.51 | 4.84 |
| South Pool | 3.48 | 4.06 |
| Wildlife Refuge | 4.00 | 4.07 |
| Woodland Meadow | 5.93 | 3.44 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.44,2.88
Beisner Road Entrance,3.95,2.82
Boat Launch Area,5.26,3.27
Busse Lake,3.34,2.94
Elk Pasture,4.28,4.64
Forest North Grove,4.80,4.54
Forest South Grove,3.41,4.00
Forest West Grove,3.39,5.00
Lake Boating Center,4.86,3.71
Large Event Area,3.74,4.09
Main Dam,3.64,3.73
Marshall Park,4.35,3.62
Model Airplane Field,4.91,3.96
Nature Preserve,4.47,3.62
Ned Brown Meadow,3.11,3.63
Osborn Park,4.97,5.17
Salt Creek Trail,3.51,4.84
South Pool,3.48,4.06
Wildlife Refuge,4.00,4.07
Woodland Meadow,5.93,3.44
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.31593506 0.00320000 NUM3d1a_991d
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 3.49 | 3.61 |
| Beisner Road Entrance | 3.58 | 3.69 |
| Busse Lake | 4.34 | 3.44 |
| Debra Park | 4.25 | 4.24 |
| Elk Pasture | 3.84 | 3.55 |
| Forest Central Grove | 5.50 | 3.94 |
| Forest North Grove | 4.33 | 4.61 |
| Forest South Grove | 4.63 | 5.03 |
| Lake Boating Center | 5.18 | 4.74 |
| Large Event Area | 5.63 | 4.20 |
| Main Dam | 3.94 | 4.64 |
| Main Pool | 3.45 | 5.13 |
| Marshall Park | 3.96 | 3.67 |
| Model Airplane Field | 4.33 | 3.68 |
| Ned Brown Meadow | 4.43 | 3.96 |
| Osborn Park | 4.35 | 3.71 |
| Salt Creek Trail | 3.63 | 3.93 |
| South Pool | 5.67 | 4.32 |
| Wildlife Refuge | 3.86 | 3.94 |
| Woodland Meadow | 4.59 | 3.90 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.49,3.61
Beisner Road Entrance,3.58,3.69
Busse Lake,4.34,3.44
Debra Park,4.25,4.24
Elk Pasture,3.84,3.55
Forest Central Grove,5.50,3.94
Forest North Grove,4.33,4.61
Forest South Grove,4.63,5.03
Lake Boating Center,5.18,4.74
Large Event Area,5.63,4.20
Main Dam,3.94,4.64
Main Pool,3.45,5.13
Marshall Park,3.96,3.67
Model Airplane Field,4.33,3.68
Ned Brown Meadow,4.43,3.96
Osborn Park,4.35,3.71
Salt Creek Trail,3.63,3.93
South Pool,5.67,4.32
Wildlife Refuge,3.86,3.94
Woodland Meadow,4.59,3.90
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.08639254 0.00100000 NUM596a_a36a
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Busse Lake | 4.74 | 3.75 |
| Debra Park | 4.78 | 4.77 |
| Forest North Grove | 5.06 | 3.57 |
| Forest South Grove | 3.93 | 4.24 |
| Lake Boating Center | 3.57 | 4.12 |
| Main Pool | 4.65 | 3.47 |
| Marshall Park | 3.77 | 4.59 |
| Model Airplane Field | 3.38 | 4.56 |
| Ned Brown Meadow | 3.98 | 4.83 |
| Osborn Park | 3.63 | 3.44 |
| Salt Creek Trail | 4.21 | 3.85 |
| South Pool | 2.98 | 4.30 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Busse Lake,4.74,3.75
Debra Park,4.78,4.77
Forest North Grove,5.06,3.57
Forest South Grove,3.93,4.24
Lake Boating Center,3.57,4.12
Main Pool,4.65,3.47
Marshall Park,3.77,4.59
Model Airplane Field,3.38,4.56
Ned Brown Meadow,3.98,4.83
Osborn Park,3.63,3.44
Salt Creek Trail,4.21,3.85
South Pool,2.98,4.30
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.21806654 0.00220000 NUM4b46_5967
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 4.38 | 4.73 |
| Beisner Road Entrance | 4.05 | 4.02 |
| Boat Launch Area | 4.01 | 3.82 |
| Busse Lake | 4.79 | 3.70 |
| Debra Park | 3.35 | 4.56 |
| Elk Pasture | 4.85 | 3.96 |
| Forest Central Grove | 4.07 | 4.07 |
| Forest North Grove | 3.25 | 4.77 |
| Forest South Grove | 4.94 | 4.60 |
| Forest West Grove | 3.21 | 4.39 |
| Lake Boating Center | 4.36 | 4.53 |
| Large Event Area | 2.45 | 3.11 |
| Main Dam | 4.70 | 4.52 |
| Main Pool | 4.18 | 3.77 |
| Marshall Park | 3.62 | 3.76 |
| Model Airplane Field | 5.01 | 4.00 |
| Nature Preserve | 3.95 | 3.13 |
| Ned Brown Meadow | 4.31 | 3.17 |
| North Pool | 3.69 | 4.19 |
| Osborn Park | 5.13 | 3.80 |
| Salt Creek Trail | 3.92 | 3.87 |
| Wildlife Refuge | 4.57 | 3.57 |
| Woodland Meadow | 4.14 | 4.25 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.38,4.73
Beisner Road Entrance,4.05,4.02
Boat Launch Area,4.01,3.82
Busse Lake,4.79,3.70
Debra Park,3.35,4.56
Elk Pasture,4.85,3.96
Forest Central Grove,4.07,4.07
Forest North Grove,3.25,4.77
Forest South Grove,4.94,4.60
Forest West Grove,3.21,4.39
Lake Boating Center,4.36,4.53
Large Event Area,2.45,3.11
Main Dam,4.70,4.52
Main Pool,4.18,3.77
Marshall Park,3.62,3.76
Model Airplane Field,5.01,4.00
Nature Preserve,3.95,3.13
Ned Brown Meadow,4.31,3.17
North Pool,3.69,4.19
Osborn Park,5.13,3.80
Salt Creek Trail,3.92,3.87
Wildlife Refuge,4.57,3.57
Woodland Meadow,4.14,4.25
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.08467882 0.00100000 NUM0473_05ef
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 4.08 | 3.01 |
| Beisner Road Entrance | 4.18 | 4.25 |
| Boat Launch Area | 4.46 | 4.34 |
| Busse Lake | 3.51 | 3.98 |
| Debra Park | 4.85 | 3.36 |
| Forest Central Grove | 3.83 | 4.62 |
| Forest North Grove | 4.26 | 3.41 |
| Forest South Grove | 4.15 | 4.05 |
| Forest West Grove | 4.17 | 4.63 |
| Lake Boating Center | 4.42 | 3.68 |
| Large Event Area | 3.12 | 4.61 |
| Main Dam | 5.18 | 4.17 |
| Main Pool | 4.16 | 3.82 |
| Marshall Park | 4.15 | 3.40 |
| Model Airplane Field | 3.29 | 3.11 |
| Nature Preserve | 3.70 | 4.19 |
| Ned Brown Meadow | 2.48 | 4.34 |
| North Pool | 3.67 | 3.40 |
| Wildlife Refuge | 3.71 | 4.30 |
| Woodland Meadow | 4.37 | 3.74 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.08,3.01
Beisner Road Entrance,4.18,4.25
Boat Launch Area,4.46,4.34
Busse Lake,3.51,3.98
Debra Park,4.85,3.36
Forest Central Grove,3.83,4.62
Forest North Grove,4.26,3.41
Forest South Grove,4.15,4.05
Forest West Grove,4.17,4.63
Lake Boating Center,4.42,3.68
Large Event Area,3.12,4.61
Main Dam,5.18,4.17
Main Pool,4.16,3.82
Marshall Park,4.15,3.40
Model Airplane Field,3.29,3.11
Nature Preserve,3.70,4.19
Ned Brown Meadow,2.48,4.34
North Pool,3.67,3.40
Wildlife Refuge,3.71,4.30
Woodland Meadow,4.37,3.74
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.22763259 0.00230000 NUM5a1f_5681
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 3.60 | 3.16 |
| Beisner Road Entrance | 2.45 | 4.25 |
| Boat Launch Area | 4.24 | 3.61 |
| Busse Lake | 4.55 | 3.89 |
| Debra Park | 2.42 | 5.26 |
| Elk Pasture | 3.82 | 4.25 |
| Forest Central Grove | 5.12 | 4.25 |
| Forest North Grove | 2.97 | 4.81 |
| Forest South Grove | 4.63 | 4.79 |
| Forest West Grove | 3.86 | 2.67 |
| Main Dam | 4.16 | 4.62 |
| Main Pool | 5.08 | 3.40 |
| Marshall Park | 3.73 | 3.96 |
| Nature Preserve | 3.05 | 3.50 |
| Ned Brown Meadow | 3.90 | 4.24 |
| Osborn Park | 4.31 | 4.62 |
| Salt Creek Trail | 4.37 | 4.10 |
| South Pool | 4.48 | 3.73 |
| Woodland Meadow | 3.31 | 3.29 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.60,3.16
Beisner Road Entrance,2.45,4.25
Boat Launch Area,4.24,3.61
Busse Lake,4.55,3.89
Debra Park,2.42,5.26
Elk Pasture,3.82,4.25
Forest Central Grove,5.12,4.25
Forest North Grove,2.97,4.81
Forest South Grove,4.63,4.79
Forest West Grove,3.86,2.67
Main Dam,4.16,4.62
Main Pool,5.08,3.40
Marshall Park,3.73,3.96
Nature Preserve,3.05,3.50
Ned Brown Meadow,3.90,4.24
Osborn Park,4.31,4.62
Salt Creek Trail,4.37,4.10
South Pool,4.48,3.73
Woodland Meadow,3.31,3.29
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.22357256 0.00220000 NUM7e4d_b406
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 3.44 | 4.11 |
| Beisner Road Entrance | 3.26 | 4.78 |
| Boat Launch Area | 4.53 | 3.48 |
| Busse Lake | 3.18 | 4.92 |
| Debra Park | 3.31 | 4.01 |
| Elk Pasture | 3.75 | 3.98 |
| Forest Central Grove | 4.70 | 4.25 |
| Forest North Grove | 3.98 | 4.92 |
| Forest South Grove | 3.67 | 3.49 |
| Forest West Grove | 3.23 | 3.79 |
| Lake Boating Center | 4.03 | 4.21 |
| Large Event Area | 3.79 | 3.82 |
| Main Dam | 4.12 | 3.97 |
| Main Pool | 3.36 | 4.72 |
| Marshall Park | 4.20 | 4.23 |
| Model Airplane Field | 3.07 | 4.27 |
| Nature Preserve | 3.37 | 4.48 |
| Ned Brown Meadow | 3.53 | 4.26 |
| North Pool | 4.01 | 3.78 |
| Osborn Park | 3.15 | 4.04 |
| Salt Creek Trail | 3.12 | 4.74 |
| South Pool | 3.56 | 4.11 |
| Wildlife Refuge | 3.33 | 3.69 |
| Woodland Meadow | 3.82 | 3.55 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.44,4.11
Beisner Road Entrance,3.26,4.78
Boat Launch Area,4.53,3.48
Busse Lake,3.18,4.92
Debra Park,3.31,4.01
Elk Pasture,3.75,3.98
Forest Central Grove,4.70,4.25
Forest North Grove,3.98,4.92
Forest South Grove,3.67,3.49
Forest West Grove,3.23,3.79
Lake Boating Center,4.03,4.21
Large Event Area,3.79,3.82
Main Dam,4.12,3.97
Main Pool,3.36,4.72
Marshall Park,4.20,4.23
Model Airplane Field,3.07,4.27
Nature Preserve,3.37,4.48
Ned Brown Meadow,3.53,4.26
North Pool,4.01,3.78
Osborn Park,3.15,4.04
Salt Creek Trail,3.12,4.74
South Pool,3.56,4.11
Wildlife Refuge,3.33,3.69
Woodland Meadow,3.82,3.55
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.42369258 0.00420000 NUM02bb_5e65
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 3.49 | 3.93 |
| Boat Launch Area | 4.36 | 4.46 |
| Busse Lake | 2.91 | 4.16 |
| Debra Park | 3.96 | 3.82 |
| Elk Pasture | 3.87 | 3.61 |
| Forest Central Grove | 2.92 | 3.60 |
| Forest North Grove | 4.41 | 4.18 |
| Forest South Grove | 3.50 | 4.32 |
| Forest West Grove | 3.66 | 3.67 |
| Lake Boating Center | 4.03 | 4.98 |
| Large Event Area | 3.77 | 3.50 |
| Main Dam | 5.09 | 3.07 |
| Main Pool | 3.22 | 3.95 |
| Marshall Park | 3.62 | 3.69 |
| Ned Brown Meadow | 3.66 | 3.86 |
| Osborn Park | 3.68 | 4.28 |
| Salt Creek Trail | 4.33 | 3.96 |
| South Pool | 3.66 | 3.24 |
| Wildlife Refuge | 3.79 | 4.06 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.49,3.93
Boat Launch Area,4.36,4.46
Busse Lake,2.91,4.16
Debra Park,3.96,3.82
Elk Pasture,3.87,3.61
Forest Central Grove,2.92,3.60
Forest North Grove,4.41,4.18
Forest South Grove,3.50,4.32
Forest West Grove,3.66,3.67
Lake Boating Center,4.03,4.98
Large Event Area,3.77,3.50
Main Dam,5.09,3.07
Main Pool,3.22,3.95
Marshall Park,3.62,3.69
Ned Brown Meadow,3.66,3.86
Osborn Park,3.68,4.28
Salt Creek Trail,4.33,3.96
South Pool,3.66,3.24
Wildlife Refuge,3.79,4.06
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.24787621 0.00250000 NUMf6f9_55b5
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 5.56 | 3.78 |
| Boat Launch Area | 4.93 | 4.39 |
| Busse Lake | 4.72 | 3.59 |
| Debra Park | 3.18 | 3.77 |
| Elk Pasture | 2.64 | 4.15 |
| Forest Central Grove | 4.13 | 4.49 |
| Forest North Grove | 3.66 | 4.06 |
| Forest South Grove | 4.27 | 4.32 |
| Forest West Grove | 3.60 | 5.14 |
| Lake Boating Center | 3.12 | 2.92 |
| Large Event Area | 3.04 | 4.43 |
| Main Dam | 4.02 | 2.62 |
| Main Pool | 4.57 | 3.91 |
| Nature Preserve | 3.51 | 3.91 |
| Osborn Park | 3.42 | 3.26 |
| South Pool | 3.53 | 3.80 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,5.56,3.78
Boat Launch Area,4.93,4.39
Busse Lake,4.72,3.59
Debra Park,3.18,3.77
Elk Pasture,2.64,4.15
Forest Central Grove,4.13,4.49
Forest North Grove,3.66,4.06
Forest South Grove,4.27,4.32
Forest West Grove,3.60,5.14
Lake Boating Center,3.12,2.92
Large Event Area,3.04,4.43
Main Dam,4.02,2.62
Main Pool,4.57,3.91
Nature Preserve,3.51,3.91
Osborn Park,3.42,3.26
South Pool,3.53,3.80
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.18960921 0.00190000 NUM9b37_5ce8
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 3.65 | 4.07 |
| Beisner Road Entrance | 3.65 | 4.00 |
| Boat Launch Area | 3.43 | 3.46 |
| Busse Lake | 4.77 | 4.60 |
| Debra Park | 3.56 | 3.30 |
| Elk Pasture | 3.70 | 3.38 |
| Forest Central Grove | 3.29 | 3.82 |
| Forest North Grove | 3.60 | 3.63 |
| Forest South Grove | 4.72 | 3.42 |
| Forest West Grove | 3.97 | 4.51 |
| Lake Boating Center | 3.30 | 3.92 |
| Large Event Area | 3.97 | 4.05 |
| Main Dam | 4.45 | 3.70 |
| Main Pool | 4.31 | 4.37 |
| Marshall Park | 3.13 | 4.04 |
| Model Airplane Field | 3.63 | 3.62 |
| Nature Preserve | 4.11 | 3.64 |
| Ned Brown Meadow | 3.61 | 4.36 |
| North Pool | 4.56 | 3.57 |
| Osborn Park | 3.19 | 3.94 |
| Salt Creek Trail | 4.19 | 3.92 |
| South Pool | 3.59 | 3.48 |
| Wildlife Refuge | 4.57 | 3.60 |
| Woodland Meadow | 4.53 | 3.52 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.65,4.07
Beisner Road Entrance,3.65,4.00
Boat Launch Area,3.43,3.46
Busse Lake,4.77,4.60
Debra Park,3.56,3.30
Elk Pasture,3.70,3.38
Forest Central Grove,3.29,3.82
Forest North Grove,3.60,3.63
Forest South Grove,4.72,3.42
Forest West Grove,3.97,4.51
Lake Boating Center,3.30,3.92
Large Event Area,3.97,4.05
Main Dam,4.45,3.70
Main Pool,4.31,4.37
Marshall Park,3.13,4.04
Model Airplane Field,3.63,3.62
Nature Preserve,4.11,3.64
Ned Brown Meadow,3.61,4.36
North Pool,4.56,3.57
Osborn Park,3.19,3.94
Salt Creek Trail,4.19,3.92
South Pool,3.59,3.48
Wildlife Refuge,4.57,3.60
Woodland Meadow,4.53,3.52
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.06058866 0.00100000 NUM5787_845e
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 4.30 | 3.64 |
| Boat Launch Area | 4.80 | 4.72 |
| Debra Park | 4.31 | 2.60 |
| Elk Pasture | 4.43 | 4.00 |
| Forest Central Grove | 3.45 | 3.53 |
| Forest North Grove | 3.80 | 3.61 |
| Forest South Grove | 3.81 | 2.88 |
| Forest West Grove | 3.50 | 4.92 |
| Lake Boating Center | 5.04 | 3.87 |
| Large Event Area | 2.48 | 3.83 |
| Main Dam | 4.17 | 3.73 |
| Main Pool | 5.01 | 3.79 |
| Marshall Park | 3.18 | 4.15 |
| Nature Preserve | 3.57 | 3.70 |
| Ned Brown Meadow | 3.62 | 3.82 |
| Osborn Park | 4.28 | 4.11 |
| Salt Creek Trail | 4.12 | 4.49 |
| South Pool | 5.33 | 4.04 |
| Woodland Meadow | 3.70 | 4.19 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.30,3.64
Boat Launch Area,4.80,4.72
Debra Park,4.31,2.60
Elk Pasture,4.43,4.00
Forest Central Grove,3.45,3.53
Forest North Grove,3.80,3.61
Forest South Grove,3.81,2.88
Forest West Grove,3.50,4.92
Lake Boating Center,5.04,3.87
Large Event Area,2.48,3.83
Main Dam,4.17,3.73
Main Pool,5.01,3.79
Marshall Park,3.18,4.15
Nature Preserve,3.57,3.70
Ned Brown Meadow,3.62,3.82
Osborn Park,4.28,4.11
Salt Creek Trail,4.12,4.49
South Pool,5.33,4.04
Woodland Meadow,3.70,4.19
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.14271089 0.00140000 NUM3f1f_2687
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 4.19 | 3.90 |
| Boat Launch Area | 4.45 | 3.59 |
| Busse Lake | 4.71 | 4.29 |
| Debra Park | 3.22 | 3.47 |
| Elk Pasture | 4.49 | 4.02 |
| Forest North Grove | 3.36 | 3.65 |
| Forest West Grove | 5.13 | 4.22 |
| Lake Boating Center | 3.92 | 4.19 |
| Large Event Area | 3.38 | 3.32 |
| Main Dam | 4.49 | 3.88 |
| Model Airplane Field | 4.16 | 4.64 |
| North Pool | 3.79 | 4.77 |
| South Pool | 3.45 | 4.03 |
| Wildlife Refuge | 4.00 | 4.24 |
| Woodland Meadow | 4.53 | 3.18 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.19,3.90
Boat Launch Area,4.45,3.59
Busse Lake,4.71,4.29
Debra Park,3.22,3.47
Elk Pasture,4.49,4.02
Forest North Grove,3.36,3.65
Forest West Grove,5.13,4.22
Lake Boating Center,3.92,4.19
Large Event Area,3.38,3.32
Main Dam,4.49,3.88
Model Airplane Field,4.16,4.64
North Pool,3.79,4.77
South Pool,3.45,4.03
Wildlife Refuge,4.00,4.24
Woodland Meadow,4.53,3.18
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.22263288 0.00220000 NUM3bdf_1461
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 4.76 | 3.66 |
| Beisner Road Entrance | 5.49 | 2.92 |
| Boat Launch Area | 4.15 | 4.09 |
| Busse Lake | 4.59 | 2.84 |
| Debra Park | 3.76 | 4.18 |
| Elk Pasture | 3.29 | 4.14 |
| Forest Central Grove | 4.65 | 3.84 |
| Forest North Grove | 3.79 | 3.34 |
| Forest South Grove | 3.59 | 3.88 |
| Forest West Grove | 3.66 | 4.29 |
| Lake Boating Center | 3.94 | 4.03 |
| Large Event Area | 3.94 | 4.40 |
| Main Dam | 4.25 | 3.88 |
| Nature Preserve | 3.07 | 3.67 |
| Ned Brown Meadow | 3.82 | 3.79 |
| North Pool | 3.95 | 4.34 |
| Osborn Park | 4.17 | 3.85 |
| South Pool | 3.99 | 4.13 |
| Wildlife Refuge | 4.27 | 3.53 |
| Woodland Meadow | 2.90 | 3.48 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.76,3.66
Beisner Road Entrance,5.49,2.92
Boat Launch Area,4.15,4.09
Busse Lake,4.59,2.84
Debra Park,3.76,4.18
Elk Pasture,3.29,4.14
Forest Central Grove,4.65,3.84
Forest North Grove,3.79,3.34
Forest South Grove,3.59,3.88
Forest West Grove,3.66,4.29
Lake Boating Center,3.94,4.03
Large Event Area,3.94,4.40
Main Dam,4.25,3.88
Nature Preserve,3.07,3.67
Ned Brown Meadow,3.82,3.79
North Pool,3.95,4.34
Osborn Park,4.17,3.85
South Pool,3.99,4.13
Wildlife Refuge,4.27,3.53
Woodland Meadow,2.90,3.48
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.08284883 0.00100000 NUMaec7_b2d3
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 4.86 | 3.99 |
| Beisner Road Entrance | 3.91 | 4.50 |
| Boat Launch Area | 4.31 | 3.16 |
| Busse Lake | 4.37 | 3.31 |
| Debra Park | 4.01 | 3.79 |
| Elk Pasture | 5.18 | 3.84 |
| Forest Central Grove | 3.53 | 3.77 |
| Forest North Grove | 3.75 | 3.86 |
| Forest South Grove | 4.79 | 3.74 |
| Lake Boating Center | 3.97 | 3.80 |
| Large Event Area | 3.43 | 3.29 |
| Main Dam | 2.65 | 3.49 |
| Main Pool | 4.01 | 4.30 |
| Marshall Park | 3.59 | 4.47 |
| Model Airplane Field | 4.56 | 3.84 |
| Nature Preserve | 3.55 | 4.46 |
| North Pool | 4.29 | 4.31 |
| Osborn Park | 4.62 | 4.11 |
| Salt Creek Trail | 3.69 | 3.73 |
| South Pool | 3.68 | 3.74 |
| Wildlife Refuge | 4.41 | 3.01 |
| Woodland Meadow | 4.09 | 4.04 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.86,3.99
Beisner Road Entrance,3.91,4.50
Boat Launch Area,4.31,3.16
Busse Lake,4.37,3.31
Debra Park,4.01,3.79
Elk Pasture,5.18,3.84
Forest Central Grove,3.53,3.77
Forest North Grove,3.75,3.86
Forest South Grove,4.79,3.74
Lake Boating Center,3.97,3.80
Large Event Area,3.43,3.29
Main Dam,2.65,3.49
Main Pool,4.01,4.30
Marshall Park,3.59,4.47
Model Airplane Field,4.56,3.84
Nature Preserve,3.55,4.46
North Pool,4.29,4.31
Osborn Park,4.62,4.11
Salt Creek Trail,3.69,3.73
South Pool,3.68,3.74
Wildlife Refuge,4.41,3.01
Woodland Meadow,4.09,4.04
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.07996107 0.00100000 NUM5e5d_59ed
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 3.61 | 3.76 |
| Beisner Road Entrance | 3.68 | 4.24 |
| Boat Launch Area | 4.42 | 4.20 |
| Busse Lake | 4.59 | 4.15 |
| Debra Park | 4.36 | 3.90 |
| Elk Pasture | 4.70 | 4.62 |
| Forest Central Grove | 2.78 | 4.66 |
| Forest North Grove | 2.68 | 5.34 |
| Forest South Grove | 4.87 | 4.55 |
| Forest West Grove | 3.81 | 4.11 |
| Lake Boating Center | 3.80 | 3.76 |
| Large Event Area | 4.61 | 4.54 |
| Main Dam | 3.10 | 4.48 |
| Marshall Park | 3.85 | 3.95 |
| Model Airplane Field | 3.94 | 3.68 |
| Ned Brown Meadow | 4.65 | 3.02 |
| North Pool | 3.25 | 3.61 |
| Osborn Park | 5.98 | 3.61 |
| Salt Creek Trail | 5.03 | 3.47 |
| South Pool | 3.99 | 5.03 |
| Wildlife Refuge | 3.78 | 3.54 |
| Woodland Meadow | 4.10 | 3.64 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.61,3.76
Beisner Road Entrance,3.68,4.24
Boat Launch Area,4.42,4.20
Busse Lake,4.59,4.15
Debra Park,4.36,3.90
Elk Pasture,4.70,4.62
Forest Central Grove,2.78,4.66
Forest North Grove,2.68,5.34
Forest South Grove,4.87,4.55
Forest West Grove,3.81,4.11
Lake Boating Center,3.80,3.76
Large Event Area,4.61,4.54
Main Dam,3.10,4.48
Marshall Park,3.85,3.95
Model Airplane Field,3.94,3.68
Ned Brown Meadow,4.65,3.02
North Pool,3.25,3.61
Osborn Park,5.98,3.61
Salt Creek Trail,5.03,3.47
South Pool,3.99,5.03
Wildlife Refuge,3.78,3.54
Woodland Meadow,4.10,3.64
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.07338572 0.00100000 NUM1624_cddb
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Boat Launch Area | 4.24 | 4.79 |
| Busse Lake | 3.46 | 4.06 |
| Debra Park | 4.22 | 3.45 |
| Elk Pasture | 4.34 | 4.11 |
| Forest Central Grove | 4.46 | 4.21 |
| Forest North Grove | 4.26 | 3.90 |
| Forest West Grove | 3.99 | 3.89 |
| Main Dam | 3.49 | 3.96 |
| Main Pool | 4.69 | 4.29 |
| Marshall Park | 3.09 | 4.01 |
| North Pool | 4.58 | 3.48 |
| Salt Creek Trail | 3.34 | 4.64 |
| South Pool | 3.58 | 3.67 |
| Wildlife Refuge | 3.92 | 3.98 |
| Woodland Meadow | 3.68 | 4.69 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Boat Launch Area,4.24,4.79
Busse Lake,3.46,4.06
Debra Park,4.22,3.45
Elk Pasture,4.34,4.11
Forest Central Grove,4.46,4.21
Forest North Grove,4.26,3.90
Forest West Grove,3.99,3.89
Main Dam,3.49,3.96
Main Pool,4.69,4.29
Marshall Park,3.09,4.01
North Pool,4.58,3.48
Salt Creek Trail,3.34,4.64
South Pool,3.58,3.67
Wildlife Refuge,3.92,3.98
Woodland Meadow,3.68,4.69
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.23322892 0.00230000 NUM9eb5_f45b
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 3.64 | 3.54 |
| Beisner Road Entrance | 5.01 | 4.73 |
| Boat Launch Area | 3.74 | 4.37 |
| Busse Lake | 4.69 | 4.52 |
| Debra Park | 3.98 | 3.69 |
| Elk Pasture | 3.87 | 3.36 |
| Forest Central Grove | 4.24 | 3.73 |
| Forest North Grove | 4.26 | 3.23 |
| Forest South Grove | 3.86 | 4.33 |
| Forest West Grove | 4.01 | 3.90 |
| Lake Boating Center | 4.13 | 3.33 |
| Large Event Area | 4.42 | 3.61 |
| Main Dam | 2.70 | 3.48 |
| Main Pool | 3.45 | 3.83 |
| Marshall Park | 3.62 | 3.75 |
| Model Airplane Field | 3.02 | 5.03 |
| Nature Preserve | 4.38 | 3.40 |
| Ned Brown Meadow | 5.51 | 5.06 |
| North Pool | 3.98 | 4.11 |
| Osborn Park | 4.02 | 4.14 |
| Salt Creek Trail | 3.97 | 3.95 |
| South Pool | 4.57 | 4.91 |
| Wildlife Refuge | 4.17 | 4.65 |
| Woodland Meadow | 4.48 | 3.92 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.64,3.54
Beisner Road Entrance,5.01,4.73
Boat Launch Area,3.74,4.37
Busse Lake,4.69,4.52
Debra Park,3.98,3.69
Elk Pasture,3.87,3.36
Forest Central Grove,4.24,3.73
Forest North Grove,4.26,3.23
Forest South Grove,3.86,4.33
Forest West Grove,4.01,3.90
Lake Boating Center,4.13,3.33
Large Event Area,4.42,3.61
Main Dam,2.70,3.48
Main Pool,3.45,3.83
Marshall Park,3.62,3.75
Model Airplane Field,3.02,5.03
Nature Preserve,4.38,3.40
Ned Brown Meadow,5.51,5.06
North Pool,3.98,4.11
Osborn Park,4.02,4.14
Salt Creek Trail,3.97,3.95
South Pool,4.57,4.91
Wildlife Refuge,4.17,4.65
Woodland Meadow,4.48,3.92
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.40098879 0.00400000 NUM67a6_5de6
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 3.78 | 3.00 |
| Beisner Road Entrance | 4.00 | 3.49 |
| Boat Launch Area | 4.66 | 3.82 |
| Elk Pasture | 3.58 | 4.62 |
| Forest Central Grove | 3.74 | 4.17 |
| Forest North Grove | 4.98 | 4.27 |
| Forest West Grove | 4.44 | 4.92 |
| Lake Boating Center | 4.18 | 3.60 |
| Main Dam | 3.25 | 4.52 |
| Main Pool | 3.70 | 4.19 |
| Marshall Park | 4.73 | 3.49 |
| Model Airplane Field | 2.79 | 4.12 |
| Nature Preserve | 4.05 | 3.74 |
| Ned Brown Meadow | 4.49 | 3.72 |
| North Pool | 3.65 | 4.01 |
| Salt Creek Trail | 4.29 | 3.62 |
| South Pool | 4.67 | 3.54 |
| Wildlife Refuge | 3.31 | 3.74 |
| Woodland Meadow | 4.30 | 4.52 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,3.78,3.00
Beisner Road Entrance,4.00,3.49
Boat Launch Area,4.66,3.82
Elk Pasture,3.58,4.62
Forest Central Grove,3.74,4.17
Forest North Grove,4.98,4.27
Forest West Grove,4.44,4.92
Lake Boating Center,4.18,3.60
Main Dam,3.25,4.52
Main Pool,3.70,4.19
Marshall Park,4.73,3.49
Model Airplane Field,2.79,4.12
Nature Preserve,4.05,3.74
Ned Brown Meadow,4.49,3.72
North Pool,3.65,4.01
Salt Creek Trail,4.29,3.62
South Pool,4.67,3.54
Wildlife Refuge,3.31,3.74
Woodland Meadow,4.30,4.52
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.22192259 0.00220000 NUMa1bc_86e1
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Boat Launch Area | 4.78 | 3.69 |
| Busse Lake | 4.46 | 4.47 |
| Debra Park | 3.89 | 4.27 |
| Elk Pasture | 3.26 | 4.83 |
| Forest Central Grove | 4.50 | 4.34 |
| Forest North Grove | 4.11 | 4.02 |
| Forest South Grove | 4.09 | 4.05 |
| Forest West Grove | 5.05 | 5.27 |
| Main Dam | 3.79 | 4.28 |
| Main Pool | 3.32 | 3.79 |
| Marshall Park | 5.02 | 3.64 |
| Model Airplane Field | 3.29 | 3.15 |
| Nature Preserve | 3.15 | 3.92 |
| Ned Brown Meadow | 3.61 | 3.96 |
| North Pool | 4.57 | 3.51 |
| Osborn Park | 3.14 | 3.86 |
| Salt Creek Trail | 3.90 | 3.53 |
| South Pool | 3.73 | 3.45 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Boat Launch Area,4.78,3.69
Busse Lake,4.46,4.47
Debra Park,3.89,4.27
Elk Pasture,3.26,4.83
Forest Central Grove,4.50,4.34
Forest North Grove,4.11,4.02
Forest South Grove,4.09,4.05
Forest West Grove,5.05,5.27
Main Dam,3.79,4.28
Main Pool,3.32,3.79
Marshall Park,5.02,3.64
Model Airplane Field,3.29,3.15
Nature Preserve,3.15,3.92
Ned Brown Meadow,3.61,3.96
North Pool,4.57,3.51
Osborn Park,3.14,3.86
Salt Creek Trail,3.90,3.53
South Pool,3.73,3.45
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.20961226 0.00210000 NUMd9c0_8bcf
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 4.05 | 3.84 |
| Boat Launch Area | 4.59 | 4.35 |
| Busse Lake | 4.52 | 4.43 |
| Debra Park | 2.94 | 4.95 |
| Elk Pasture | 3.57 | 4.62 |
| Forest North Grove | 3.61 | 3.67 |
| Forest South Grove | 3.75 | 4.07 |
| Lake Boating Center | 4.91 | 5.03 |
| Large Event Area | 2.87 | 3.62 |
| Main Dam | 5.15 | 4.12 |
| Main Pool | 3.55 | 3.85 |
| North Pool | 4.87 | 2.64 |
| Osborn Park | 4.19 | 4.59 |
| Salt Creek Trail | 3.33 | 4.02 |
| South Pool | 3.46 | 3.81 |
| Wildlife Refuge | 3.70 | 4.41 |
| Woodland Meadow | 4.03 | 4.02 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.05,3.84
Boat Launch Area,4.59,4.35
Busse Lake,4.52,4.43
Debra Park,2.94,4.95
Elk Pasture,3.57,4.62
Forest North Grove,3.61,3.67
Forest South Grove,3.75,4.07
Lake Boating Center,4.91,5.03
Large Event Area,2.87,3.62
Main Dam,5.15,4.12
Main Pool,3.55,3.85
North Pool,4.87,2.64
Osborn Park,4.19,4.59
Salt Creek Trail,3.33,4.02
South Pool,3.46,3.81
Wildlife Refuge,3.70,4.41
Woodland Meadow,4.03,4.02
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.24050457 0.00240000 NUM50e7_3e97
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 4.24 | 3.95 |
| Beisner Road Entrance | 3.31 | 3.69 |
| Boat Launch Area | 3.59 | 4.03 |
| Busse Lake | 3.69 | 4.03 |
| Debra Park | 2.84 | 3.76 |
| Forest Central Grove | 4.18 | 5.26 |
| Forest South Grove | 4.05 | 3.31 |
| Forest West Grove | 3.11 | 3.74 |
| Large Event Area | 3.18 | 3.69 |
| Main Dam | 3.75 | 3.93 |
| Main Pool | 4.29 | 4.27 |
| Marshall Park | 3.79 | 4.20 |
| Nature Preserve | 3.89 | 3.98 |
| Ned Brown Meadow | 4.90 | 4.92 |
| North Pool | 5.21 | 4.09 |
| Osborn Park | 3.27 | 4.48 |
| Salt Creek Trail | 4.70 | 4.19 |
| South Pool | 4.37 | 4.46 |
| Wildlife Refuge | 3.95 | 4.04 |
| Woodland Meadow | 3.06 | 4.17 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.24,3.95
Beisner Road Entrance,3.31,3.69
Boat Launch Area,3.59,4.03
Busse Lake,3.69,4.03
Debra Park,2.84,3.76
Forest Central Grove,4.18,5.26
Forest South Grove,4.05,3.31
Forest West Grove,3.11,3.74
Large Event Area,3.18,3.69
Main Dam,3.75,3.93
Main Pool,4.29,4.27
Marshall Park,3.79,4.20
Nature Preserve,3.89,3.98
Ned Brown Meadow,4.90,4.92
North Pool,5.21,4.09
Osborn Park,3.27,4.48
Salt Creek Trail,4.70,4.19
South Pool,4.37,4.46
Wildlife Refuge,3.95,4.04
Woodland Meadow,3.06,4.17
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.05121767 0.00100000 NUM1b67_e160
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Boat Launch Area | 2.56 | 4.46 |
| Debra Park | 4.78 | 4.48 |
| Elk Pasture | 4.24 | 3.03 |
| Forest Central Grove | 4.47 | 3.33 |
| Forest North Grove | 4.72 | 4.69 |
| Forest South Grove | 4.23 | 3.92 |
| Forest West Grove | 4.58 | 4.05 |
| Lake Boating Center | 4.28 | 4.08 |
| Large Event Area | 4.28 | 3.88 |
| Main Dam | 3.02 | 4.59 |
| Main Pool | 3.92 | 4.75 |
| Marshall Park | 4.28 | 4.50 |
| Nature Preserve | 4.32 | 3.64 |
| Ned Brown Meadow | 4.17 | 3.41 |
| North Pool | 2.65 | 4.28 |
| Osborn Park | 4.91 | 3.64 |
| Salt Creek Trail | 4.04 | 3.44 |
| Wildlife Refuge | 4.27 | 4.36 |
| Woodland Meadow | 4.21 | 3.99 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Boat Launch Area,2.56,4.46
Debra Park,4.78,4.48
Elk Pasture,4.24,3.03
Forest Central Grove,4.47,3.33
Forest North Grove,4.72,4.69
Forest South Grove,4.23,3.92
Forest West Grove,4.58,4.05
Lake Boating Center,4.28,4.08
Large Event Area,4.28,3.88
Main Dam,3.02,4.59
Main Pool,3.92,4.75
Marshall Park,4.28,4.50
Nature Preserve,4.32,3.64
Ned Brown Meadow,4.17,3.41
North Pool,2.65,4.28
Osborn Park,4.91,3.64
Salt Creek Trail,4.04,3.44
Wildlife Refuge,4.27,4.36
Woodland Meadow,4.21,3.99
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.13873091 0.00140000 NUMeab9_81e4
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Boat Launch Area | 5.06 | 4.27 |
| Busse Lake | 4.01 | 3.88 |
| Elk Pasture | 4.54 | 3.77 |
| Forest Central Grove | 3.63 | 4.73 |
| Forest North Grove | 3.71 | 4.56 |
| Forest South Grove | 4.81 | 3.20 |
| Forest West Grove | 3.99 | 4.13 |
| Lake Boating Center | 3.31 | 3.49 |
| Main Dam | 4.62 | 3.39 |
| Model Airplane Field | 3.50 | 4.23 |
| Nature Preserve | 4.48 | 4.01 |
| Ned Brown Meadow | 3.42 | 3.56 |
| North Pool | 5.39 | 3.68 |
| Osborn Park | 3.32 | 4.26 |
| Wildlife Refuge | 4.70 | 3.45 |
| Woodland Meadow | 3.84 | 4.18 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Boat Launch Area,5.06,4.27
Busse Lake,4.01,3.88
Elk Pasture,4.54,3.77
Forest Central Grove,3.63,4.73
Forest North Grove,3.71,4.56
Forest South Grove,4.81,3.20
Forest West Grove,3.99,4.13
Lake Boating Center,3.31,3.49
Main Dam,4.62,3.39
Model Airplane Field,3.50,4.23
Nature Preserve,4.48,4.01
Ned Brown Meadow,3.42,3.56
North Pool,5.39,3.68
Osborn Park,3.32,4.26
Wildlife Refuge,4.70,3.45
Woodland Meadow,3.84,4.18
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.06600110 0.00100000 NUMf311_de45
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Boat Launch Area | 5.56 | 3.29 |
| Busse Lake | 4.48 | 3.96 |
| Debra Park | 3.60 | 4.13 |
| Elk Pasture | 3.47 | 4.45 |
| Forest Central Grove | 4.27 | 4.81 |
| Forest North Grove | 4.13 | 4.23 |
| Forest South Grove | 4.32 | 3.93 |
| Forest West Grove | 3.85 | 4.65 |
| Main Pool | 5.12 | 3.39 |
| Marshall Park | 5.10 | 4.15 |
| Model Airplane Field | 4.34 | 3.57 |
| Nature Preserve | 4.12 | 4.67 |
| Ned Brown Meadow | 4.45 | 4.33 |
| Salt Creek Trail | 3.84 | 3.98 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Boat Launch Area,5.56,3.29
Busse Lake,4.48,3.96
Debra Park,3.60,4.13
Elk Pasture,3.47,4.45
Forest Central Grove,4.27,4.81
Forest North Grove,4.13,4.23
Forest South Grove,4.32,3.93
Forest West Grove,3.85,4.65
Main Pool,5.12,3.39
Marshall Park,5.10,4.15
Model Airplane Field,4.34,3.57
Nature Preserve,4.12,4.67
Ned Brown Meadow,4.45,4.33
Salt Creek Trail,3.84,3.98
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.19648912 0.00200000 NUM1696_33dd
F-Test of Variances: 2014 vs 2024
Use a one tailed F test for H1: variance_2024 < variance_2014.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2014 Shannon Index | 2024 Shannon Index |
|---|---|---|
| Andrews Park | 4.09 | 4.45 |
| Busse Lake | 3.27 | 3.94 |
| Elk Pasture | 4.41 | 4.10 |
| Forest Central Grove | 4.56 | 3.92 |
| Lake Boating Center | 4.15 | 4.14 |
| Large Event Area | 3.59 | 4.41 |
| Main Dam | 3.91 | 3.85 |
| Model Airplane Field | 4.24 | 3.98 |
| Nature Preserve | 4.30 | 4.33 |
| North Pool | 4.55 | 4.04 |
| Osborn Park | 3.98 | 3.34 |
| Wildlife Refuge | 3.96 | 4.12 |
| Woodland Meadow | 3.87 | 3.55 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location,2014 Shannon Index,2024 Shannon Index
Andrews Park,4.09,4.45
Busse Lake,3.27,3.94
Elk Pasture,4.41,4.10
Forest Central Grove,4.56,3.92
Lake Boating Center,4.15,4.14
Large Event Area,3.59,4.41
Main Dam,3.91,3.85
Model Airplane Field,4.24,3.98
Nature Preserve,4.30,4.33
North Pool,4.55,4.04
Osborn Park,3.98,3.34
Wildlife Refuge,3.96,4.12
Woodland Meadow,3.87,3.55
Enter the p value as a decimal between 0 and 1.
Workflow: link here.
0.29873927 0.00300000