d466_c2d5
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.51 | 4.58 |
| Boat Launch Area | 3.72 | 3.53 |
| Busse Lake | 5.46 | 4.06 |
| Debra Park | 4.04 | 4.05 |
| Forest Central Grove | 3.17 | 4.66 |
| Forest South Grove | 4.42 | 3.92 |
| Forest West Grove | 4.87 | 3.82 |
| Large Event Area | 4.81 | 3.46 |
| Main Dam | 4.03 | 4.82 |
| North Pool | 4.22 | 3.62 |
| Osborn Park | 4.03 | 3.15 |
| Salt Creek Trail | 3.63 | 3.88 |
| Wildlife Refuge | 4.43 | 3.66 |
| Woodland Meadow | 4.59 | 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
Beisner Road Entrance,4.51,4.58
Boat Launch Area,3.72,3.53
Busse Lake,5.46,4.06
Debra Park,4.04,4.05
Forest Central Grove,3.17,4.66
Forest South Grove,4.42,3.92
Forest West Grove,4.87,3.82
Large Event Area,4.81,3.46
Main Dam,4.03,4.82
North Pool,4.22,3.62
Osborn Park,4.03,3.15
Salt Creek Trail,3.63,3.88
Wildlife Refuge,4.43,3.66
Woodland Meadow,4.59,4.57
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.08067842 0.00100000 NUM51d4_1fd9
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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 | 4.38 |
| Beisner Road Entrance | 3.52 | 4.32 |
| Boat Launch Area | 3.97 | 3.38 |
| Busse Lake | 4.05 | 3.86 |
| Debra Park | 4.83 | 3.95 |
| Elk Pasture | 4.39 | 4.37 |
| Forest Central Grove | 4.30 | 4.62 |
| Forest North Grove | 3.81 | 3.57 |
| Forest South Grove | 4.43 | 3.90 |
| Forest West Grove | 4.37 | 4.64 |
| Lake Boating Center | 4.20 | 2.90 |
| Large Event Area | 3.57 | 4.08 |
| Main Pool | 4.28 | 3.93 |
| Marshall Park | 4.15 | 3.63 |
| Model Airplane Field | 4.80 | 4.29 |
| Nature Preserve | 4.27 | 3.93 |
| Ned Brown Meadow | 3.70 | 3.56 |
| North Pool | 4.16 | 3.86 |
| Osborn Park | 3.43 | 3.14 |
| Salt Creek Trail | 4.62 | 3.92 |
| South Pool | 3.29 | 3.88 |
| Wildlife Refuge | 4.71 | 4.55 |
| Woodland Meadow | 4.13 | 4.73 |
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,4.38
Beisner Road Entrance,3.52,4.32
Boat Launch Area,3.97,3.38
Busse Lake,4.05,3.86
Debra Park,4.83,3.95
Elk Pasture,4.39,4.37
Forest Central Grove,4.30,4.62
Forest North Grove,3.81,3.57
Forest South Grove,4.43,3.90
Forest West Grove,4.37,4.64
Lake Boating Center,4.20,2.90
Large Event Area,3.57,4.08
Main Pool,4.28,3.93
Marshall Park,4.15,3.63
Model Airplane Field,4.80,4.29
Nature Preserve,4.27,3.93
Ned Brown Meadow,3.70,3.56
North Pool,4.16,3.86
Osborn Park,3.43,3.14
Salt Creek Trail,4.62,3.92
South Pool,3.29,3.88
Wildlife Refuge,4.71,4.55
Woodland Meadow,4.13,4.73
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.08613489 0.00100000 NUMa795_a60a
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.57 |
| Beisner Road Entrance | 3.96 | 3.84 |
| Boat Launch Area | 2.81 | 4.11 |
| Busse Lake | 4.72 | 4.29 |
| Forest Central Grove | 3.76 | 3.98 |
| Forest North Grove | 5.10 | 4.44 |
| Forest South Grove | 4.26 | 3.09 |
| Forest West Grove | 3.68 | 3.55 |
| Lake Boating Center | 4.59 | 3.25 |
| Large Event Area | 4.48 | 3.56 |
| Main Dam | 2.97 | 4.42 |
| Marshall Park | 4.05 | 4.49 |
| Model Airplane Field | 4.91 | 3.60 |
| Ned Brown Meadow | 4.14 | 4.49 |
| North Pool | 4.71 | 4.23 |
| Osborn Park | 4.43 | 3.55 |
| Salt Creek Trail | 4.41 | 4.72 |
| South Pool | 3.81 | 4.77 |
| Wildlife Refuge | 3.59 | 2.93 |
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.57
Beisner Road Entrance,3.96,3.84
Boat Launch Area,2.81,4.11
Busse Lake,4.72,4.29
Forest Central Grove,3.76,3.98
Forest North Grove,5.10,4.44
Forest South Grove,4.26,3.09
Forest West Grove,3.68,3.55
Lake Boating Center,4.59,3.25
Large Event Area,4.48,3.56
Main Dam,2.97,4.42
Marshall Park,4.05,4.49
Model Airplane Field,4.91,3.60
Ned Brown Meadow,4.14,4.49
North Pool,4.71,4.23
Osborn Park,4.43,3.55
Salt Creek Trail,4.41,4.72
South Pool,3.81,4.77
Wildlife Refuge,3.59,2.93
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.27076335 0.00270000 NUMcb2c_5a90
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.55 | 3.30 |
| Beisner Road Entrance | 3.03 | 3.46 |
| Boat Launch Area | 3.09 | 3.61 |
| Busse Lake | 4.82 | 2.87 |
| Debra Park | 4.61 | 4.34 |
| Elk Pasture | 3.90 | 3.59 |
| Forest Central Grove | 3.56 | 4.04 |
| Forest North Grove | 3.37 | 4.23 |
| Forest South Grove | 4.39 | 4.23 |
| Forest West Grove | 4.69 | 3.76 |
| Lake Boating Center | 4.35 | 3.74 |
| Large Event Area | 4.51 | 4.50 |
| Main Dam | 3.73 | 2.63 |
| Main Pool | 4.59 | 4.28 |
| Marshall Park | 4.13 | 3.98 |
| Model Airplane Field | 4.25 | 4.45 |
| Nature Preserve | 3.89 | 4.69 |
| Ned Brown Meadow | 4.25 | 5.06 |
| North Pool | 4.01 | 4.70 |
| Salt Creek Trail | 4.25 | 3.64 |
| Wildlife Refuge | 3.05 | 4.38 |
| Woodland Meadow | 4.84 | 4.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,3.55,3.30
Beisner Road Entrance,3.03,3.46
Boat Launch Area,3.09,3.61
Busse Lake,4.82,2.87
Debra Park,4.61,4.34
Elk Pasture,3.90,3.59
Forest Central Grove,3.56,4.04
Forest North Grove,3.37,4.23
Forest South Grove,4.39,4.23
Forest West Grove,4.69,3.76
Lake Boating Center,4.35,3.74
Large Event Area,4.51,4.50
Main Dam,3.73,2.63
Main Pool,4.59,4.28
Marshall Park,4.13,3.98
Model Airplane Field,4.25,4.45
Nature Preserve,3.89,4.69
Ned Brown Meadow,4.25,5.06
North Pool,4.01,4.70
Salt Creek Trail,4.25,3.64
Wildlife Refuge,3.05,4.38
Woodland Meadow,4.84,4.48
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.40946192 0.00410000 NUM42a0_543d
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.10 | 3.78 |
| Beisner Road Entrance | 4.63 | 3.56 |
| Boat Launch Area | 4.68 | 4.48 |
| Busse Lake | 3.56 | 4.70 |
| Debra Park | 3.14 | 3.74 |
| Elk Pasture | 3.31 | 3.66 |
| Forest North Grove | 3.94 | 3.30 |
| Large Event Area | 3.55 | 4.03 |
| Marshall Park | 4.12 | 4.17 |
| North Pool | 3.90 | 3.05 |
| South Pool | 4.29 | 4.56 |
| Woodland Meadow | 4.58 | 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,4.10,3.78
Beisner Road Entrance,4.63,3.56
Boat Launch Area,4.68,4.48
Busse Lake,3.56,4.70
Debra Park,3.14,3.74
Elk Pasture,3.31,3.66
Forest North Grove,3.94,3.30
Large Event Area,3.55,4.03
Marshall Park,4.12,4.17
North Pool,3.90,3.05
South Pool,4.29,4.56
Woodland Meadow,4.58,4.33
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.43184849 0.00430000 NUM5381_f58a
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.23 | 2.93 |
| Busse Lake | 4.33 | 5.07 |
| Debra Park | 4.22 | 3.25 |
| Forest Central Grove | 3.23 | 3.05 |
| Forest North Grove | 4.44 | 4.42 |
| Forest South Grove | 4.74 | 4.23 |
| Forest West Grove | 3.93 | 4.05 |
| Lake Boating Center | 3.89 | 3.52 |
| Large Event Area | 4.54 | 4.08 |
| Main Dam | 4.60 | 3.90 |
| Main Pool | 3.44 | 4.31 |
| Marshall Park | 3.74 | 3.89 |
| Model Airplane Field | 4.17 | 3.36 |
| Ned Brown Meadow | 4.59 | 4.25 |
| North Pool | 4.09 | 3.96 |
| Osborn Park | 3.57 | 3.92 |
| Salt Creek Trail | 3.65 | 3.40 |
| South Pool | 4.70 | 4.91 |
| Wildlife Refuge | 4.12 | 4.13 |
| Woodland Meadow | 5.12 | 3.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
Beisner Road Entrance,4.23,2.93
Busse Lake,4.33,5.07
Debra Park,4.22,3.25
Forest Central Grove,3.23,3.05
Forest North Grove,4.44,4.42
Forest South Grove,4.74,4.23
Forest West Grove,3.93,4.05
Lake Boating Center,3.89,3.52
Large Event Area,4.54,4.08
Main Dam,4.60,3.90
Main Pool,3.44,4.31
Marshall Park,3.74,3.89
Model Airplane Field,4.17,3.36
Ned Brown Meadow,4.59,4.25
North Pool,4.09,3.96
Osborn Park,3.57,3.92
Salt Creek Trail,3.65,3.40
South Pool,4.70,4.91
Wildlife Refuge,4.12,4.13
Woodland Meadow,5.12,3.06
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.05368585 0.00100000 NUM0e16_6465
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.38 |
| Beisner Road Entrance | 4.09 | 4.39 |
| Debra Park | 5.14 | 4.03 |
| Elk Pasture | 3.68 | 3.74 |
| Forest Central Grove | 4.60 | 3.31 |
| Lake Boating Center | 4.94 | 3.52 |
| Large Event Area | 4.27 | 4.14 |
| Main Pool | 3.18 | 3.92 |
| Marshall Park | 5.41 | 3.89 |
| Ned Brown Meadow | 3.51 | 4.79 |
| North Pool | 3.98 | 4.28 |
| Osborn Park | 3.16 | 3.56 |
| South Pool | 4.44 | 3.73 |
| Wildlife Refuge | 4.38 | 3.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.54,4.38
Beisner Road Entrance,4.09,4.39
Debra Park,5.14,4.03
Elk Pasture,3.68,3.74
Forest Central Grove,4.60,3.31
Lake Boating Center,4.94,3.52
Large Event Area,4.27,4.14
Main Pool,3.18,3.92
Marshall Park,5.41,3.89
Ned Brown Meadow,3.51,4.79
North Pool,3.98,4.28
Osborn Park,3.16,3.56
South Pool,4.44,3.73
Wildlife Refuge,4.38,3.43
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.15498617 0.00150000 NUM5d24_6948
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.59 | 3.34 |
| Boat Launch Area | 3.56 | 5.31 |
| Busse Lake | 3.79 | 4.38 |
| Elk Pasture | 4.31 | 3.79 |
| Forest North Grove | 3.61 | 4.68 |
| Forest South Grove | 4.13 | 4.53 |
| Forest West Grove | 4.66 | 4.14 |
| Lake Boating Center | 4.61 | 3.87 |
| Main Dam | 4.53 | 3.73 |
| Main Pool | 2.77 | 3.60 |
| Marshall Park | 3.64 | 4.23 |
| Nature Preserve | 4.59 | 4.19 |
| Ned Brown Meadow | 4.61 | 4.63 |
| Osborn Park | 4.32 | 3.53 |
| South Pool | 4.67 | 3.99 |
| Wildlife Refuge | 3.16 | 4.67 |
| Woodland Meadow | 4.79 | 3.22 |
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.59,3.34
Boat Launch Area,3.56,5.31
Busse Lake,3.79,4.38
Elk Pasture,4.31,3.79
Forest North Grove,3.61,4.68
Forest South Grove,4.13,4.53
Forest West Grove,4.66,4.14
Lake Boating Center,4.61,3.87
Main Dam,4.53,3.73
Main Pool,2.77,3.60
Marshall Park,3.64,4.23
Nature Preserve,4.59,4.19
Ned Brown Meadow,4.61,4.63
Osborn Park,4.32,3.53
South Pool,4.67,3.99
Wildlife Refuge,3.16,4.67
Woodland Meadow,4.79,3.22
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.44058837 0.00440000 NUM3473_62c1
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.63 | 5.26 |
| Beisner Road Entrance | 4.08 | 4.36 |
| Boat Launch Area | 3.96 | 3.40 |
| Busse Lake | 4.06 | 3.19 |
| Debra Park | 3.95 | 3.92 |
| Elk Pasture | 2.94 | 2.84 |
| Forest Central Grove | 3.62 | 3.47 |
| Forest North Grove | 4.80 | 2.69 |
| Forest South Grove | 4.48 | 3.90 |
| Forest West Grove | 4.23 | 3.33 |
| Lake Boating Center | 4.37 | 4.49 |
| Large Event Area | 4.13 | 4.67 |
| Main Dam | 4.59 | 3.73 |
| Main Pool | 3.87 | 2.94 |
| Marshall Park | 3.77 | 4.22 |
| Model Airplane Field | 4.18 | 3.94 |
| Nature Preserve | 4.75 | 3.11 |
| Ned Brown Meadow | 3.40 | 3.34 |
| North Pool | 3.52 | 2.44 |
| Osborn Park | 3.90 | 5.14 |
| Salt Creek Trail | 5.02 | 4.09 |
| South Pool | 3.56 | 4.91 |
| Wildlife Refuge | 4.51 | 3.53 |
| Woodland Meadow | 4.13 | 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,3.63,5.26
Beisner Road Entrance,4.08,4.36
Boat Launch Area,3.96,3.40
Busse Lake,4.06,3.19
Debra Park,3.95,3.92
Elk Pasture,2.94,2.84
Forest Central Grove,3.62,3.47
Forest North Grove,4.80,2.69
Forest South Grove,4.48,3.90
Forest West Grove,4.23,3.33
Lake Boating Center,4.37,4.49
Large Event Area,4.13,4.67
Main Dam,4.59,3.73
Main Pool,3.87,2.94
Marshall Park,3.77,4.22
Model Airplane Field,4.18,3.94
Nature Preserve,4.75,3.11
Ned Brown Meadow,3.40,3.34
North Pool,3.52,2.44
Osborn Park,3.90,5.14
Salt Creek Trail,5.02,4.09
South Pool,3.56,4.91
Wildlife Refuge,4.51,3.53
Woodland Meadow,4.13,3.67
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.06501844 0.00100000 NUM5c29_9c09
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.73 | 3.87 |
| Beisner Road Entrance | 4.23 | 4.90 |
| Boat Launch Area | 3.84 | 4.07 |
| Busse Lake | 4.98 | 4.03 |
| Debra Park | 3.50 | 4.05 |
| Elk Pasture | 4.29 | 4.59 |
| Forest Central Grove | 3.16 | 3.12 |
| Forest North Grove | 3.56 | 3.80 |
| Forest West Grove | 3.78 | 4.50 |
| Lake Boating Center | 3.90 | 4.46 |
| Large Event Area | 2.83 | 4.73 |
| Main Dam | 4.04 | 3.45 |
| Main Pool | 4.86 | 2.99 |
| Marshall Park | 4.34 | 3.15 |
| Model Airplane Field | 3.25 | 4.05 |
| Nature Preserve | 4.02 | 3.25 |
| Ned Brown Meadow | 3.65 | 3.79 |
| North Pool | 4.22 | 3.31 |
| Osborn Park | 3.96 | 3.43 |
| Salt Creek Trail | 3.61 | 3.73 |
| South Pool | 2.61 | 4.20 |
| Wildlife Refuge | 4.67 | 4.09 |
| Woodland Meadow | 3.89 | 3.66 |
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.73,3.87
Beisner Road Entrance,4.23,4.90
Boat Launch Area,3.84,4.07
Busse Lake,4.98,4.03
Debra Park,3.50,4.05
Elk Pasture,4.29,4.59
Forest Central Grove,3.16,3.12
Forest North Grove,3.56,3.80
Forest West Grove,3.78,4.50
Lake Boating Center,3.90,4.46
Large Event Area,2.83,4.73
Main Dam,4.04,3.45
Main Pool,4.86,2.99
Marshall Park,4.34,3.15
Model Airplane Field,3.25,4.05
Nature Preserve,4.02,3.25
Ned Brown Meadow,3.65,3.79
North Pool,4.22,3.31
Osborn Park,3.96,3.43
Salt Creek Trail,3.61,3.73
South Pool,2.61,4.20
Wildlife Refuge,4.67,4.09
Woodland Meadow,3.89,3.66
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.42915033 0.00430000 NUM40e6_99f4
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.16 | 4.53 |
| Debra Park | 3.41 | 3.94 |
| Forest North Grove | 4.10 | 5.15 |
| Forest South Grove | 4.16 | 3.31 |
| Forest West Grove | 5.16 | 3.63 |
| Lake Boating Center | 4.39 | 4.44 |
| Large Event Area | 4.19 | 2.75 |
| Model Airplane Field | 3.79 | 3.60 |
| Nature Preserve | 4.69 | 4.40 |
| Ned Brown Meadow | 4.12 | 4.10 |
| North Pool | 3.47 | 4.31 |
| South Pool | 3.72 | 4.46 |
| Wildlife Refuge | 3.35 | 3.57 |
| Woodland Meadow | 4.36 | 3.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
Andrews Park,4.16,4.53
Debra Park,3.41,3.94
Forest North Grove,4.10,5.15
Forest South Grove,4.16,3.31
Forest West Grove,5.16,3.63
Lake Boating Center,4.39,4.44
Large Event Area,4.19,2.75
Model Airplane Field,3.79,3.60
Nature Preserve,4.69,4.40
Ned Brown Meadow,4.12,4.10
North Pool,3.47,4.31
South Pool,3.72,4.46
Wildlife Refuge,3.35,3.57
Woodland Meadow,4.36,3.41
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.31508597 0.00320000 NUMcf4d_d732
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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 |
|---|---|---|
| Debra Park | 4.47 | 4.47 |
| Elk Pasture | 3.52 | 3.94 |
| Forest North Grove | 4.21 | 3.79 |
| Forest South Grove | 3.65 | 3.91 |
| Forest West Grove | 4.03 | 3.31 |
| Lake Boating Center | 4.48 | 3.87 |
| Large Event Area | 4.67 | 4.07 |
| Main Dam | 3.54 | 3.86 |
| Main Pool | 4.06 | 4.06 |
| Marshall Park | 4.52 | 4.71 |
| Ned Brown Meadow | 3.10 | 3.13 |
| North Pool | 4.38 | 2.88 |
| Wildlife Refuge | 4.04 | 3.37 |
| Woodland Meadow | 3.93 | 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
Debra Park,4.47,4.47
Elk Pasture,3.52,3.94
Forest North Grove,4.21,3.79
Forest South Grove,3.65,3.91
Forest West Grove,4.03,3.31
Lake Boating Center,4.48,3.87
Large Event Area,4.67,4.07
Main Dam,3.54,3.86
Main Pool,4.06,4.06
Marshall Park,4.52,4.71
Ned Brown Meadow,3.10,3.13
North Pool,4.38,2.88
Wildlife Refuge,4.04,3.37
Woodland Meadow,3.93,3.64
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.08352285 0.00100000 NUMb27c_bb94
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.35 | 2.49 |
| Beisner Road Entrance | 4.12 | 4.41 |
| Boat Launch Area | 4.42 | 4.87 |
| Busse Lake | 4.18 | 3.83 |
| Debra Park | 3.78 | 4.19 |
| Forest Central Grove | 3.04 | 3.28 |
| Forest North Grove | 3.41 | 3.58 |
| Forest West Grove | 3.61 | 3.31 |
| Large Event Area | 4.06 | 4.62 |
| Main Dam | 3.88 | 3.08 |
| Main Pool | 3.96 | 3.45 |
| Marshall Park | 3.64 | 3.69 |
| Model Airplane Field | 3.83 | 3.61 |
| Nature Preserve | 4.31 | 2.78 |
| Ned Brown Meadow | 3.19 | 4.01 |
| North Pool | 4.65 | 5.02 |
| Osborn Park | 4.96 | 4.11 |
| South Pool | 3.85 | 4.44 |
| Wildlife Refuge | 4.37 | 4.46 |
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.35,2.49
Beisner Road Entrance,4.12,4.41
Boat Launch Area,4.42,4.87
Busse Lake,4.18,3.83
Debra Park,3.78,4.19
Forest Central Grove,3.04,3.28
Forest North Grove,3.41,3.58
Forest West Grove,3.61,3.31
Large Event Area,4.06,4.62
Main Dam,3.88,3.08
Main Pool,3.96,3.45
Marshall Park,3.64,3.69
Model Airplane Field,3.83,3.61
Nature Preserve,4.31,2.78
Ned Brown Meadow,3.19,4.01
North Pool,4.65,5.02
Osborn Park,4.96,4.11
South Pool,3.85,4.44
Wildlife Refuge,4.37,4.46
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.26261043 0.00260000 NUM3d8a_ab24
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.97 | 4.01 |
| Beisner Road Entrance | 4.38 | 4.76 |
| Boat Launch Area | 4.24 | 4.21 |
| Busse Lake | 4.34 | 3.69 |
| Debra Park | 4.46 | 3.43 |
| Elk Pasture | 3.84 | 3.85 |
| Forest Central Grove | 4.97 | 3.61 |
| Forest South Grove | 4.04 | 4.18 |
| Forest West Grove | 3.75 | 3.73 |
| Lake Boating Center | 4.41 | 3.37 |
| Large Event Area | 3.81 | 3.83 |
| Main Pool | 2.70 | 4.25 |
| Nature Preserve | 3.63 | 4.04 |
| North Pool | 3.88 | 4.25 |
| South Pool | 2.95 | 3.99 |
| Wildlife Refuge | 4.32 | 3.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.97,4.01
Beisner Road Entrance,4.38,4.76
Boat Launch Area,4.24,4.21
Busse Lake,4.34,3.69
Debra Park,4.46,3.43
Elk Pasture,3.84,3.85
Forest Central Grove,4.97,3.61
Forest South Grove,4.04,4.18
Forest West Grove,3.75,3.73
Lake Boating Center,4.41,3.37
Large Event Area,3.81,3.83
Main Pool,2.70,4.25
Nature Preserve,3.63,4.04
North Pool,3.88,4.25
South Pool,2.95,3.99
Wildlife Refuge,4.32,3.19
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.22042540 0.00220000 NUMbfdb_686e
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.52 | 3.63 |
| Boat Launch Area | 3.80 | 3.53 |
| Elk Pasture | 3.65 | 3.43 |
| Forest North Grove | 4.93 | 4.41 |
| Forest South Grove | 3.69 | 3.77 |
| Forest West Grove | 4.46 | 4.58 |
| Lake Boating Center | 4.08 | 4.34 |
| Large Event Area | 3.35 | 4.32 |
| Main Dam | 4.41 | 2.79 |
| Main Pool | 3.83 | 5.08 |
| Marshall Park | 4.26 | 4.72 |
| Model Airplane Field | 4.13 | 3.07 |
| North Pool | 5.46 | 4.73 |
| Salt Creek Trail | 4.51 | 5.03 |
| South Pool | 3.77 | 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
Beisner Road Entrance,4.52,3.63
Boat Launch Area,3.80,3.53
Elk Pasture,3.65,3.43
Forest North Grove,4.93,4.41
Forest South Grove,3.69,3.77
Forest West Grove,4.46,4.58
Lake Boating Center,4.08,4.34
Large Event Area,3.35,4.32
Main Dam,4.41,2.79
Main Pool,3.83,5.08
Marshall Park,4.26,4.72
Model Airplane Field,4.13,3.07
North Pool,5.46,4.73
Salt Creek Trail,4.51,5.03
South Pool,3.77,3.29
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.27678870 0.00280000 NUM289b_9aeb
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.68 | 4.33 |
| Beisner Road Entrance | 3.13 | 4.04 |
| Boat Launch Area | 4.70 | 3.99 |
| Busse Lake | 3.49 | 3.97 |
| Debra Park | 4.92 | 3.94 |
| Elk Pasture | 3.76 | 3.53 |
| Forest Central Grove | 4.41 | 3.12 |
| Forest North Grove | 3.71 | 4.42 |
| Forest South Grove | 4.02 | 3.60 |
| Forest West Grove | 4.66 | 3.18 |
| Lake Boating Center | 3.49 | 4.02 |
| Large Event Area | 4.11 | 3.69 |
| Main Dam | 3.73 | 3.65 |
| Main Pool | 3.02 | 4.18 |
| Marshall Park | 4.72 | 3.99 |
| Model Airplane Field | 3.79 | 4.22 |
| Nature Preserve | 3.66 | 3.81 |
| Ned Brown Meadow | 4.55 | 3.39 |
| North Pool | 4.55 | 3.67 |
| Osborn Park | 4.09 | 4.08 |
| Salt Creek Trail | 3.58 | 3.74 |
| Wildlife Refuge | 4.18 | 4.38 |
| Woodland Meadow | 4.27 | 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
Andrews Park,4.68,4.33
Beisner Road Entrance,3.13,4.04
Boat Launch Area,4.70,3.99
Busse Lake,3.49,3.97
Debra Park,4.92,3.94
Elk Pasture,3.76,3.53
Forest Central Grove,4.41,3.12
Forest North Grove,3.71,4.42
Forest South Grove,4.02,3.60
Forest West Grove,4.66,3.18
Lake Boating Center,3.49,4.02
Large Event Area,4.11,3.69
Main Dam,3.73,3.65
Main Pool,3.02,4.18
Marshall Park,4.72,3.99
Model Airplane Field,3.79,4.22
Nature Preserve,3.66,3.81
Ned Brown Meadow,4.55,3.39
North Pool,4.55,3.67
Osborn Park,4.09,4.08
Salt Creek Trail,3.58,3.74
Wildlife Refuge,4.18,4.38
Woodland Meadow,4.27,3.89
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.08147214 0.00100000 NUMe278_98fc
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.87 | 3.69 |
| Boat Launch Area | 4.02 | 3.87 |
| Busse Lake | 4.43 | 3.30 |
| Debra Park | 3.72 | 2.60 |
| Elk Pasture | 4.14 | 3.89 |
| Forest Central Grove | 3.50 | 3.87 |
| Forest North Grove | 3.69 | 4.59 |
| Forest South Grove | 4.53 | 4.55 |
| Lake Boating Center | 4.87 | 3.76 |
| Large Event Area | 4.08 | 4.08 |
| Main Dam | 3.92 | 3.38 |
| Model Airplane Field | 3.63 | 4.95 |
| Nature Preserve | 4.04 | 3.56 |
| Ned Brown Meadow | 4.75 | 4.84 |
| Osborn Park | 4.22 | 3.66 |
| South Pool | 4.26 | 4.76 |
| Wildlife Refuge | 2.86 | 4.17 |
| Woodland Meadow | 3.96 | 3.87 |
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.87,3.69
Boat Launch Area,4.02,3.87
Busse Lake,4.43,3.30
Debra Park,3.72,2.60
Elk Pasture,4.14,3.89
Forest Central Grove,3.50,3.87
Forest North Grove,3.69,4.59
Forest South Grove,4.53,4.55
Lake Boating Center,4.87,3.76
Large Event Area,4.08,4.08
Main Dam,3.92,3.38
Model Airplane Field,3.63,4.95
Nature Preserve,4.04,3.56
Ned Brown Meadow,4.75,4.84
Osborn Park,4.22,3.66
South Pool,4.26,4.76
Wildlife Refuge,2.86,4.17
Woodland Meadow,3.96,3.87
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.26794317 0.00270000 NUMdc5d_ed30
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.14 | 4.04 |
| Beisner Road Entrance | 4.76 | 4.33 |
| Boat Launch Area | 5.22 | 4.03 |
| Busse Lake | 3.94 | 4.24 |
| Debra Park | 3.38 | 3.64 |
| Elk Pasture | 3.64 | 4.37 |
| Forest Central Grove | 4.25 | 4.22 |
| Forest North Grove | 3.42 | 3.14 |
| Forest South Grove | 4.12 | 3.64 |
| Forest West Grove | 4.11 | 3.41 |
| Lake Boating Center | 3.47 | 3.67 |
| Large Event Area | 4.33 | 4.37 |
| Main Dam | 3.77 | 5.02 |
| Main Pool | 5.17 | 4.66 |
| Marshall Park | 3.51 | 2.97 |
| Model Airplane Field | 3.57 | 3.04 |
| Nature Preserve | 4.25 | 4.80 |
| Ned Brown Meadow | 3.77 | 2.85 |
| North Pool | 3.93 | 3.79 |
| Osborn Park | 4.24 | 4.36 |
| Salt Creek Trail | 4.10 | 4.40 |
| South Pool | 4.43 | 4.37 |
| Wildlife Refuge | 4.82 | 4.20 |
| Woodland Meadow | 3.82 | 4.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,5.14,4.04
Beisner Road Entrance,4.76,4.33
Boat Launch Area,5.22,4.03
Busse Lake,3.94,4.24
Debra Park,3.38,3.64
Elk Pasture,3.64,4.37
Forest Central Grove,4.25,4.22
Forest North Grove,3.42,3.14
Forest South Grove,4.12,3.64
Forest West Grove,4.11,3.41
Lake Boating Center,3.47,3.67
Large Event Area,4.33,4.37
Main Dam,3.77,5.02
Main Pool,5.17,4.66
Marshall Park,3.51,2.97
Model Airplane Field,3.57,3.04
Nature Preserve,4.25,4.80
Ned Brown Meadow,3.77,2.85
North Pool,3.93,3.79
Osborn Park,4.24,4.36
Salt Creek Trail,4.10,4.40
South Pool,4.43,4.37
Wildlife Refuge,4.82,4.20
Woodland Meadow,3.82,4.86
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.25171906 0.00250000 NUM5cd3_d80b
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.52 | 3.26 |
| Boat Launch Area | 4.01 | 4.28 |
| Busse Lake | 4.33 | 3.47 |
| Elk Pasture | 3.32 | 3.18 |
| Forest Central Grove | 4.10 | 3.89 |
| Forest South Grove | 3.15 | 4.94 |
| Main Dam | 3.75 | 3.29 |
| Main Pool | 3.90 | 3.98 |
| Marshall Park | 4.72 | 3.72 |
| Model Airplane Field | 3.83 | 3.47 |
| Nature Preserve | 4.23 | 3.64 |
| Ned Brown Meadow | 4.77 | 3.45 |
| Osborn Park | 3.11 | 4.65 |
| South Pool | 4.16 | 4.69 |
| Wildlife Refuge | 4.39 | 4.05 |
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.52,3.26
Boat Launch Area,4.01,4.28
Busse Lake,4.33,3.47
Elk Pasture,3.32,3.18
Forest Central Grove,4.10,3.89
Forest South Grove,3.15,4.94
Main Dam,3.75,3.29
Main Pool,3.90,3.98
Marshall Park,4.72,3.72
Model Airplane Field,3.83,3.47
Nature Preserve,4.23,3.64
Ned Brown Meadow,4.77,3.45
Osborn Park,3.11,4.65
South Pool,4.16,4.69
Wildlife Refuge,4.39,4.05
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.21920949 0.00220000 NUM86cd_04d3
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.59 | 3.90 |
| Beisner Road Entrance | 3.97 | 3.94 |
| Boat Launch Area | 3.96 | 4.91 |
| Busse Lake | 4.15 | 2.94 |
| Debra Park | 3.52 | 3.98 |
| Elk Pasture | 4.00 | 3.16 |
| Forest Central Grove | 4.27 | 3.79 |
| Forest North Grove | 4.35 | 3.04 |
| Forest South Grove | 3.08 | 3.79 |
| Forest West Grove | 4.16 | 3.83 |
| Main Dam | 3.78 | 3.19 |
| Main Pool | 4.17 | 4.67 |
| Marshall Park | 3.71 | 4.07 |
| Model Airplane Field | 3.19 | 3.62 |
| North Pool | 4.80 | 3.81 |
| Salt Creek Trail | 4.25 | 2.63 |
| South Pool | 3.66 | 3.89 |
| Woodland Meadow | 4.56 | 4.15 |
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.59,3.90
Beisner Road Entrance,3.97,3.94
Boat Launch Area,3.96,4.91
Busse Lake,4.15,2.94
Debra Park,3.52,3.98
Elk Pasture,4.00,3.16
Forest Central Grove,4.27,3.79
Forest North Grove,4.35,3.04
Forest South Grove,3.08,3.79
Forest West Grove,4.16,3.83
Main Dam,3.78,3.19
Main Pool,4.17,4.67
Marshall Park,3.71,4.07
Model Airplane Field,3.19,3.62
North Pool,4.80,3.81
Salt Creek Trail,4.25,2.63
South Pool,3.66,3.89
Woodland Meadow,4.56,4.15
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.11125449 0.00110000 NUMba2a_122a
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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 | 4.02 |
| Beisner Road Entrance | 4.35 | 3.91 |
| Boat Launch Area | 4.47 | 3.93 |
| Busse Lake | 5.53 | 4.04 |
| Debra Park | 3.14 | 3.90 |
| Elk Pasture | 4.08 | 4.56 |
| Forest Central Grove | 3.56 | 3.98 |
| Forest North Grove | 4.04 | 3.37 |
| Forest South Grove | 3.95 | 4.36 |
| Forest West Grove | 3.40 | 4.30 |
| Lake Boating Center | 4.16 | 3.24 |
| Large Event Area | 5.30 | 3.08 |
| Main Dam | 4.50 | 3.92 |
| Main Pool | 3.91 | 4.00 |
| Marshall Park | 3.90 | 3.78 |
| Model Airplane Field | 4.91 | 4.35 |
| Nature Preserve | 4.60 | 4.64 |
| Ned Brown Meadow | 4.04 | 4.80 |
| North Pool | 3.26 | 4.32 |
| Osborn Park | 4.59 | 3.47 |
| Salt Creek Trail | 4.67 | 4.08 |
| South Pool | 3.30 | 3.56 |
| Wildlife Refuge | 3.09 | 3.54 |
| Woodland Meadow | 4.52 | 3.66 |
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,4.02
Beisner Road Entrance,4.35,3.91
Boat Launch Area,4.47,3.93
Busse Lake,5.53,4.04
Debra Park,3.14,3.90
Elk Pasture,4.08,4.56
Forest Central Grove,3.56,3.98
Forest North Grove,4.04,3.37
Forest South Grove,3.95,4.36
Forest West Grove,3.40,4.30
Lake Boating Center,4.16,3.24
Large Event Area,5.30,3.08
Main Dam,4.50,3.92
Main Pool,3.91,4.00
Marshall Park,3.90,3.78
Model Airplane Field,4.91,4.35
Nature Preserve,4.60,4.64
Ned Brown Meadow,4.04,4.80
North Pool,3.26,4.32
Osborn Park,4.59,3.47
Salt Creek Trail,4.67,4.08
South Pool,3.30,3.56
Wildlife Refuge,3.09,3.54
Woodland Meadow,4.52,3.66
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.10493679 0.00100000 NUM8d6e_6c28
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.50 | 4.21 |
| Boat Launch Area | 4.39 | 3.35 |
| Elk Pasture | 3.91 | 4.28 |
| Forest Central Grove | 3.62 | 3.15 |
| Lake Boating Center | 3.19 | 4.29 |
| Large Event Area | 4.46 | 4.37 |
| Main Dam | 3.96 | 5.18 |
| Marshall Park | 4.66 | 3.47 |
| Model Airplane Field | 3.70 | 2.89 |
| Ned Brown Meadow | 4.30 | 3.97 |
| North Pool | 3.89 | 4.24 |
| Salt Creek Trail | 4.47 | 3.98 |
| South Pool | 3.33 | 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
Beisner Road Entrance,4.50,4.21
Boat Launch Area,4.39,3.35
Elk Pasture,3.91,4.28
Forest Central Grove,3.62,3.15
Lake Boating Center,3.19,4.29
Large Event Area,4.46,4.37
Main Dam,3.96,5.18
Marshall Park,4.66,3.47
Model Airplane Field,3.70,2.89
Ned Brown Meadow,4.30,3.97
North Pool,3.89,4.24
Salt Creek Trail,4.47,3.98
South Pool,3.33,3.77
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.33147246 0.00330000 NUM0705_bc49
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.54 | 2.91 |
| Beisner Road Entrance | 4.01 | 4.28 |
| Boat Launch Area | 3.36 | 4.25 |
| Busse Lake | 4.35 | 3.53 |
| Debra Park | 3.80 | 3.40 |
| Elk Pasture | 4.01 | 3.32 |
| Forest Central Grove | 3.49 | 2.78 |
| Forest North Grove | 5.29 | 3.59 |
| Forest South Grove | 4.07 | 3.20 |
| Forest West Grove | 3.70 | 3.98 |
| Lake Boating Center | 2.72 | 4.63 |
| Large Event Area | 4.81 | 4.41 |
| Main Dam | 3.75 | 3.80 |
| Main Pool | 5.12 | 4.11 |
| Marshall Park | 3.80 | 4.04 |
| Model Airplane Field | 4.29 | 4.02 |
| Ned Brown Meadow | 3.29 | 3.85 |
| North Pool | 4.21 | 2.77 |
| Osborn Park | 3.80 | 3.24 |
| Salt Creek Trail | 4.04 | 3.54 |
| South Pool | 4.13 | 4.13 |
| Wildlife Refuge | 4.09 | 3.25 |
| Woodland Meadow | 3.28 | 4.66 |
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.54,2.91
Beisner Road Entrance,4.01,4.28
Boat Launch Area,3.36,4.25
Busse Lake,4.35,3.53
Debra Park,3.80,3.40
Elk Pasture,4.01,3.32
Forest Central Grove,3.49,2.78
Forest North Grove,5.29,3.59
Forest South Grove,4.07,3.20
Forest West Grove,3.70,3.98
Lake Boating Center,2.72,4.63
Large Event Area,4.81,4.41
Main Dam,3.75,3.80
Main Pool,5.12,4.11
Marshall Park,3.80,4.04
Model Airplane Field,4.29,4.02
Ned Brown Meadow,3.29,3.85
North Pool,4.21,2.77
Osborn Park,3.80,3.24
Salt Creek Trail,4.04,3.54
South Pool,4.13,4.13
Wildlife Refuge,4.09,3.25
Woodland Meadow,3.28,4.66
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.05842778 0.00100000 NUM2521_a148
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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 | 3.14 |
| Beisner Road Entrance | 4.51 | 3.33 |
| Boat Launch Area | 3.57 | 3.92 |
| Debra Park | 4.23 | 3.61 |
| Elk Pasture | 4.29 | 2.75 |
| Forest Central Grove | 3.70 | 4.21 |
| Forest North Grove | 3.41 | 2.51 |
| Forest South Grove | 3.96 | 3.01 |
| Forest West Grove | 2.98 | 3.72 |
| Lake Boating Center | 5.47 | 3.89 |
| Large Event Area | 3.71 | 4.68 |
| Main Dam | 4.81 | 3.49 |
| Main Pool | 4.34 | 4.45 |
| Marshall Park | 3.93 | 4.01 |
| Model Airplane Field | 3.38 | 4.56 |
| Nature Preserve | 3.48 | 4.06 |
| Ned Brown Meadow | 4.40 | 3.53 |
| North Pool | 4.09 | 3.54 |
| Osborn Park | 4.29 | 3.86 |
| Salt Creek Trail | 4.10 | 4.45 |
| South Pool | 4.82 | 4.06 |
| Wildlife Refuge | 3.24 | 4.62 |
| Woodland Meadow | 4.05 | 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.54,3.14
Beisner Road Entrance,4.51,3.33
Boat Launch Area,3.57,3.92
Debra Park,4.23,3.61
Elk Pasture,4.29,2.75
Forest Central Grove,3.70,4.21
Forest North Grove,3.41,2.51
Forest South Grove,3.96,3.01
Forest West Grove,2.98,3.72
Lake Boating Center,5.47,3.89
Large Event Area,3.71,4.68
Main Dam,4.81,3.49
Main Pool,4.34,4.45
Marshall Park,3.93,4.01
Model Airplane Field,3.38,4.56
Nature Preserve,3.48,4.06
Ned Brown Meadow,4.40,3.53
North Pool,4.09,3.54
Osborn Park,4.29,3.86
Salt Creek Trail,4.10,4.45
South Pool,4.82,4.06
Wildlife Refuge,3.24,4.62
Woodland Meadow,4.05,3.90
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.10698592 0.00110000 NUMafe0_4366
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.46 | 5.09 |
| Beisner Road Entrance | 3.66 | 3.42 |
| Busse Lake | 2.75 | 2.60 |
| Debra Park | 4.37 | 3.25 |
| Elk Pasture | 3.21 | 3.87 |
| Forest Central Grove | 5.02 | 3.78 |
| Forest North Grove | 3.94 | 4.05 |
| Forest South Grove | 5.22 | 4.17 |
| Forest West Grove | 3.55 | 4.09 |
| Lake Boating Center | 5.19 | 4.20 |
| Large Event Area | 4.84 | 3.81 |
| Main Dam | 4.75 | 3.96 |
| Main Pool | 3.31 | 4.88 |
| Model Airplane Field | 3.95 | 4.16 |
| Nature Preserve | 4.15 | 4.68 |
| North Pool | 4.69 | 4.55 |
| South Pool | 3.35 | 3.84 |
| Wildlife Refuge | 4.77 | 4.34 |
| Woodland Meadow | 4.88 | 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,4.46,5.09
Beisner Road Entrance,3.66,3.42
Busse Lake,2.75,2.60
Debra Park,4.37,3.25
Elk Pasture,3.21,3.87
Forest Central Grove,5.02,3.78
Forest North Grove,3.94,4.05
Forest South Grove,5.22,4.17
Forest West Grove,3.55,4.09
Lake Boating Center,5.19,4.20
Large Event Area,4.84,3.81
Main Dam,4.75,3.96
Main Pool,3.31,4.88
Model Airplane Field,3.95,4.16
Nature Preserve,4.15,4.68
North Pool,4.69,4.55
South Pool,3.35,3.84
Wildlife Refuge,4.77,4.34
Woodland Meadow,4.88,4.06
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.21568424 0.00220000 NUM2c3c_918d
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.58 | 4.06 |
| Boat Launch Area | 3.55 | 4.34 |
| Debra Park | 4.43 | 3.87 |
| Forest North Grove | 3.38 | 3.62 |
| Forest South Grove | 3.80 | 4.10 |
| Forest West Grove | 4.69 | 4.55 |
| Lake Boating Center | 4.13 | 4.41 |
| Main Dam | 3.50 | 3.87 |
| Main Pool | 4.53 | 4.16 |
| Marshall Park | 3.70 | 3.56 |
| Model Airplane Field | 2.93 | 3.12 |
| North Pool | 3.30 | 3.79 |
| Osborn Park | 4.10 | 2.35 |
| Salt Creek Trail | 4.11 | 3.16 |
| South Pool | 3.87 | 4.96 |
| Wildlife Refuge | 3.66 | 3.17 |
| Woodland Meadow | 3.96 | 3.71 |
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.58,4.06
Boat Launch Area,3.55,4.34
Debra Park,4.43,3.87
Forest North Grove,3.38,3.62
Forest South Grove,3.80,4.10
Forest West Grove,4.69,4.55
Lake Boating Center,4.13,4.41
Main Dam,3.50,3.87
Main Pool,4.53,4.16
Marshall Park,3.70,3.56
Model Airplane Field,2.93,3.12
North Pool,3.30,3.79
Osborn Park,4.10,2.35
Salt Creek Trail,4.11,3.16
South Pool,3.87,4.96
Wildlife Refuge,3.66,3.17
Woodland Meadow,3.96,3.71
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.33466126 0.00330000 NUMf848_7235
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.25 | 4.17 |
| Beisner Road Entrance | 5.17 | 3.88 |
| Boat Launch Area | 3.74 | 4.12 |
| Debra Park | 3.61 | 3.56 |
| Elk Pasture | 4.15 | 4.62 |
| Forest North Grove | 3.81 | 3.61 |
| Forest South Grove | 4.16 | 3.62 |
| Forest West Grove | 3.99 | 3.54 |
| Lake Boating Center | 2.64 | 3.23 |
| Large Event Area | 3.48 | 3.74 |
| Main Dam | 3.87 | 4.54 |
| Main Pool | 3.82 | 4.51 |
| Model Airplane Field | 4.81 | 4.49 |
| Nature Preserve | 3.90 | 3.91 |
| Ned Brown Meadow | 4.03 | 3.91 |
| North Pool | 4.39 | 4.66 |
| Osborn Park | 4.33 | 4.34 |
| Salt Creek Trail | 3.41 | 3.46 |
| South Pool | 4.87 | 3.47 |
| Wildlife Refuge | 3.82 | 3.82 |
| Woodland Meadow | 4.79 | 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
Andrews Park,3.25,4.17
Beisner Road Entrance,5.17,3.88
Boat Launch Area,3.74,4.12
Debra Park,3.61,3.56
Elk Pasture,4.15,4.62
Forest North Grove,3.81,3.61
Forest South Grove,4.16,3.62
Forest West Grove,3.99,3.54
Lake Boating Center,2.64,3.23
Large Event Area,3.48,3.74
Main Dam,3.87,4.54
Main Pool,3.82,4.51
Model Airplane Field,4.81,4.49
Nature Preserve,3.90,3.91
Ned Brown Meadow,4.03,3.91
North Pool,4.39,4.66
Osborn Park,4.33,4.34
Salt Creek Trail,3.41,3.46
South Pool,4.87,3.47
Wildlife Refuge,3.82,3.82
Woodland Meadow,4.79,3.51
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.34904672 0.00350000 NUM6ba9_5277
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.85 | 3.68 |
| Beisner Road Entrance | 4.57 | 4.67 |
| Boat Launch Area | 4.53 | 3.19 |
| Busse Lake | 4.15 | 4.08 |
| Debra Park | 2.68 | 4.03 |
| Elk Pasture | 4.11 | 3.79 |
| Forest Central Grove | 4.42 | 3.34 |
| Forest North Grove | 4.50 | 3.94 |
| Forest South Grove | 4.14 | 2.98 |
| Forest West Grove | 4.23 | 3.81 |
| Lake Boating Center | 4.08 | 3.28 |
| Large Event Area | 4.39 | 4.26 |
| Main Pool | 4.62 | 4.83 |
| Marshall Park | 3.69 | 4.35 |
| Model Airplane Field | 4.65 | 3.99 |
| Ned Brown Meadow | 3.66 | 4.82 |
| North Pool | 3.39 | 4.06 |
| Osborn Park | 4.41 | 3.83 |
| South Pool | 4.75 | 4.38 |
| Wildlife Refuge | 3.20 | 3.51 |
| Woodland Meadow | 4.69 | 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,3.85,3.68
Beisner Road Entrance,4.57,4.67
Boat Launch Area,4.53,3.19
Busse Lake,4.15,4.08
Debra Park,2.68,4.03
Elk Pasture,4.11,3.79
Forest Central Grove,4.42,3.34
Forest North Grove,4.50,3.94
Forest South Grove,4.14,2.98
Forest West Grove,4.23,3.81
Lake Boating Center,4.08,3.28
Large Event Area,4.39,4.26
Main Pool,4.62,4.83
Marshall Park,3.69,4.35
Model Airplane Field,4.65,3.99
Ned Brown Meadow,3.66,4.82
North Pool,3.39,4.06
Osborn Park,4.41,3.83
South Pool,4.75,4.38
Wildlife Refuge,3.20,3.51
Woodland Meadow,4.69,3.80
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.11962680 0.00120000 NUM1919_694b
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.50 | 4.19 |
| Busse Lake | 3.36 | 3.97 |
| Debra Park | 3.55 | 2.98 |
| Elk Pasture | 3.84 | 3.92 |
| Forest Central Grove | 4.10 | 4.04 |
| Forest North Grove | 3.67 | 3.36 |
| Forest South Grove | 4.94 | 4.17 |
| Forest West Grove | 4.66 | 2.67 |
| Lake Boating Center | 4.59 | 4.58 |
| Large Event Area | 3.61 | 3.92 |
| Main Dam | 4.08 | 5.11 |
| Main Pool | 4.75 | 3.65 |
| Marshall Park | 3.22 | 3.99 |
| Model Airplane Field | 3.40 | 3.22 |
| Nature Preserve | 3.68 | 2.56 |
| Ned Brown Meadow | 3.24 | 4.01 |
| North Pool | 3.84 | 3.61 |
| Osborn Park | 3.98 | 3.65 |
| Salt Creek Trail | 4.42 | 3.88 |
| South Pool | 3.70 | 4.50 |
| Wildlife Refuge | 4.83 | 3.26 |
| Woodland Meadow | 4.11 | 2.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
Beisner Road Entrance,3.50,4.19
Busse Lake,3.36,3.97
Debra Park,3.55,2.98
Elk Pasture,3.84,3.92
Forest Central Grove,4.10,4.04
Forest North Grove,3.67,3.36
Forest South Grove,4.94,4.17
Forest West Grove,4.66,2.67
Lake Boating Center,4.59,4.58
Large Event Area,3.61,3.92
Main Dam,4.08,5.11
Main Pool,4.75,3.65
Marshall Park,3.22,3.99
Model Airplane Field,3.40,3.22
Nature Preserve,3.68,2.56
Ned Brown Meadow,3.24,4.01
North Pool,3.84,3.61
Osborn Park,3.98,3.65
Salt Creek Trail,4.42,3.88
South Pool,3.70,4.50
Wildlife Refuge,4.83,3.26
Woodland Meadow,4.11,2.85
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.10421477 0.00100000 NUM3eb5_5681
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.27 | 2.96 |
| Beisner Road Entrance | 3.43 | 4.00 |
| Busse Lake | 3.46 | 4.38 |
| Debra Park | 3.61 | 4.56 |
| Elk Pasture | 4.23 | 3.80 |
| Forest Central Grove | 3.86 | 3.94 |
| Forest North Grove | 3.49 | 4.18 |
| Forest South Grove | 3.97 | 3.36 |
| Forest West Grove | 3.47 | 4.63 |
| Lake Boating Center | 4.30 | 4.34 |
| Main Dam | 4.57 | 4.16 |
| Main Pool | 3.88 | 4.10 |
| Marshall Park | 3.15 | 4.41 |
| Model Airplane Field | 3.99 | 3.33 |
| Nature Preserve | 4.29 | 3.95 |
| Ned Brown Meadow | 4.02 | 3.56 |
| North Pool | 5.17 | 3.52 |
| Osborn Park | 4.73 | 3.47 |
| Salt Creek Trail | 4.63 | 3.98 |
| South Pool | 4.23 | 4.28 |
| Wildlife Refuge | 4.21 | 4.03 |
| Woodland Meadow | 4.43 | 4.08 |
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.27,2.96
Beisner Road Entrance,3.43,4.00
Busse Lake,3.46,4.38
Debra Park,3.61,4.56
Elk Pasture,4.23,3.80
Forest Central Grove,3.86,3.94
Forest North Grove,3.49,4.18
Forest South Grove,3.97,3.36
Forest West Grove,3.47,4.63
Lake Boating Center,4.30,4.34
Main Dam,4.57,4.16
Main Pool,3.88,4.10
Marshall Park,3.15,4.41
Model Airplane Field,3.99,3.33
Nature Preserve,4.29,3.95
Ned Brown Meadow,4.02,3.56
North Pool,5.17,3.52
Osborn Park,4.73,3.47
Salt Creek Trail,4.63,3.98
South Pool,4.23,4.28
Wildlife Refuge,4.21,4.03
Woodland Meadow,4.43,4.08
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.22386601 0.00220000 NUM008f_a99b
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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 | 3.56 | 3.95 |
| Busse Lake | 4.39 | 4.57 |
| Debra Park | 4.94 | 3.46 |
| Elk Pasture | 4.08 | 4.70 |
| Forest Central Grove | 4.38 | 3.38 |
| Forest North Grove | 3.70 | 4.08 |
| Forest South Grove | 3.45 | 4.08 |
| Forest West Grove | 4.06 | 4.88 |
| Large Event Area | 4.05 | 4.32 |
| Main Dam | 4.53 | 3.90 |
| Main Pool | 3.75 | 3.91 |
| Marshall Park | 4.57 | 4.00 |
| Model Airplane Field | 4.04 | 4.18 |
| Nature Preserve | 4.10 | 4.08 |
| Ned Brown Meadow | 4.49 | 4.72 |
| North Pool | 4.23 | 4.10 |
| Salt Creek Trail | 4.69 | 2.38 |
| Wildlife Refuge | 4.76 | 3.46 |
| Woodland Meadow | 3.84 | 4.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
Boat Launch Area,3.56,3.95
Busse Lake,4.39,4.57
Debra Park,4.94,3.46
Elk Pasture,4.08,4.70
Forest Central Grove,4.38,3.38
Forest North Grove,3.70,4.08
Forest South Grove,3.45,4.08
Forest West Grove,4.06,4.88
Large Event Area,4.05,4.32
Main Dam,4.53,3.90
Main Pool,3.75,3.91
Marshall Park,4.57,4.00
Model Airplane Field,4.04,4.18
Nature Preserve,4.10,4.08
Ned Brown Meadow,4.49,4.72
North Pool,4.23,4.10
Salt Creek Trail,4.69,2.38
Wildlife Refuge,4.76,3.46
Woodland Meadow,3.84,4.48
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.17347925 0.00170000 NUM4112_1463
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.34 | 4.71 |
| Beisner Road Entrance | 4.06 | 4.03 |
| Boat Launch Area | 3.66 | 3.75 |
| Busse Lake | 4.09 | 3.80 |
| Debra Park | 4.72 | 3.36 |
| Elk Pasture | 5.54 | 3.39 |
| Forest Central Grove | 4.07 | 4.28 |
| Forest North Grove | 3.46 | 3.38 |
| Forest South Grove | 3.54 | 3.96 |
| Forest West Grove | 3.87 | 2.91 |
| Lake Boating Center | 3.85 | 3.94 |
| Large Event Area | 4.34 | 3.41 |
| Main Dam | 3.70 | 3.56 |
| Main Pool | 3.60 | 3.86 |
| Marshall Park | 3.69 | 4.93 |
| Model Airplane Field | 4.14 | 3.87 |
| Nature Preserve | 3.32 | 2.96 |
| Ned Brown Meadow | 4.31 | 3.60 |
| North Pool | 3.93 | 3.63 |
| Osborn Park | 4.79 | 5.01 |
| Salt Creek Trail | 3.42 | 4.36 |
| South Pool | 2.97 | 3.73 |
| Wildlife Refuge | 4.45 | 3.81 |
| Woodland Meadow | 4.10 | 2.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,3.34,4.71
Beisner Road Entrance,4.06,4.03
Boat Launch Area,3.66,3.75
Busse Lake,4.09,3.80
Debra Park,4.72,3.36
Elk Pasture,5.54,3.39
Forest Central Grove,4.07,4.28
Forest North Grove,3.46,3.38
Forest South Grove,3.54,3.96
Forest West Grove,3.87,2.91
Lake Boating Center,3.85,3.94
Large Event Area,4.34,3.41
Main Dam,3.70,3.56
Main Pool,3.60,3.86
Marshall Park,3.69,4.93
Model Airplane Field,4.14,3.87
Nature Preserve,3.32,2.96
Ned Brown Meadow,4.31,3.60
North Pool,3.93,3.63
Osborn Park,4.79,5.01
Salt Creek Trail,3.42,4.36
South Pool,2.97,3.73
Wildlife Refuge,4.45,3.81
Woodland Meadow,4.10,2.57
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.15207068 0.00150000 NUM49c9_c154
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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 | 3.47 |
| Beisner Road Entrance | 3.45 | 4.48 |
| Boat Launch Area | 4.20 | 4.35 |
| Busse Lake | 4.65 | 4.08 |
| Debra Park | 4.24 | 3.83 |
| Elk Pasture | 4.60 | 4.49 |
| Forest Central Grove | 4.59 | 4.19 |
| Forest North Grove | 2.87 | 4.17 |
| Forest South Grove | 3.66 | 3.09 |
| Lake Boating Center | 4.36 | 4.14 |
| Large Event Area | 3.74 | 3.75 |
| Main Dam | 5.16 | 3.56 |
| Main Pool | 4.33 | 3.40 |
| Marshall Park | 3.69 | 3.95 |
| Model Airplane Field | 3.72 | 3.70 |
| Ned Brown Meadow | 4.34 | 4.36 |
| North Pool | 4.71 | 3.52 |
| Osborn Park | 3.40 | 3.11 |
| Salt Creek Trail | 3.52 | 3.04 |
| South Pool | 3.33 | 4.06 |
| Woodland Meadow | 4.83 | 3.96 |
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,3.47
Beisner Road Entrance,3.45,4.48
Boat Launch Area,4.20,4.35
Busse Lake,4.65,4.08
Debra Park,4.24,3.83
Elk Pasture,4.60,4.49
Forest Central Grove,4.59,4.19
Forest North Grove,2.87,4.17
Forest South Grove,3.66,3.09
Lake Boating Center,4.36,4.14
Large Event Area,3.74,3.75
Main Dam,5.16,3.56
Main Pool,4.33,3.40
Marshall Park,3.69,3.95
Model Airplane Field,3.72,3.70
Ned Brown Meadow,4.34,4.36
North Pool,4.71,3.52
Osborn Park,3.40,3.11
Salt Creek Trail,3.52,3.04
South Pool,3.33,4.06
Woodland Meadow,4.83,3.96
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.11677423 0.00120000 NUMdb57_913d
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.76 | 4.32 |
| Beisner Road Entrance | 4.78 | 4.16 |
| Boat Launch Area | 5.11 | 4.17 |
| Debra Park | 3.78 | 4.10 |
| Elk Pasture | 4.27 | 3.37 |
| Forest Central Grove | 4.44 | 3.38 |
| Forest North Grove | 4.23 | 3.99 |
| Forest South Grove | 4.37 | 5.58 |
| Forest West Grove | 3.91 | 3.82 |
| Lake Boating Center | 3.22 | 3.55 |
| Large Event Area | 3.75 | 4.79 |
| Main Dam | 4.08 | 4.07 |
| Main Pool | 3.42 | 3.99 |
| Marshall Park | 4.80 | 3.12 |
| Model Airplane Field | 3.69 | 3.30 |
| Ned Brown Meadow | 3.68 | 3.79 |
| Osborn Park | 4.19 | 2.78 |
| Salt Creek Trail | 3.12 | 4.58 |
| South Pool | 4.24 | 4.26 |
| Wildlife Refuge | 4.82 | 3.61 |
| Woodland Meadow | 4.19 | 3.60 |
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.76,4.32
Beisner Road Entrance,4.78,4.16
Boat Launch Area,5.11,4.17
Debra Park,3.78,4.10
Elk Pasture,4.27,3.37
Forest Central Grove,4.44,3.38
Forest North Grove,4.23,3.99
Forest South Grove,4.37,5.58
Forest West Grove,3.91,3.82
Lake Boating Center,3.22,3.55
Large Event Area,3.75,4.79
Main Dam,4.08,4.07
Main Pool,3.42,3.99
Marshall Park,4.80,3.12
Model Airplane Field,3.69,3.30
Ned Brown Meadow,3.68,3.79
Osborn Park,4.19,2.78
Salt Creek Trail,3.12,4.58
South Pool,4.24,4.26
Wildlife Refuge,4.82,3.61
Woodland Meadow,4.19,3.60
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.17658899 0.00180000 NUM02f9_237a
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.21 |
| Busse Lake | 3.86 | 3.31 |
| Debra Park | 5.03 | 4.11 |
| Elk Pasture | 3.93 | 3.68 |
| Forest Central Grove | 4.30 | 2.73 |
| Forest North Grove | 3.36 | 4.91 |
| Forest South Grove | 3.94 | 4.22 |
| Forest West Grove | 4.22 | 3.30 |
| Main Dam | 4.25 | 3.44 |
| Main Pool | 4.74 | 3.65 |
| Marshall Park | 3.24 | 3.74 |
| Model Airplane Field | 3.34 | 3.36 |
| Nature Preserve | 3.50 | 2.83 |
| Ned Brown Meadow | 4.73 | 4.60 |
| North Pool | 4.48 | 3.81 |
| Salt Creek Trail | 3.86 | 4.44 |
| Wildlife Refuge | 4.14 | 5.07 |
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.21
Busse Lake,3.86,3.31
Debra Park,5.03,4.11
Elk Pasture,3.93,3.68
Forest Central Grove,4.30,2.73
Forest North Grove,3.36,4.91
Forest South Grove,3.94,4.22
Forest West Grove,4.22,3.30
Main Dam,4.25,3.44
Main Pool,4.74,3.65
Marshall Park,3.24,3.74
Model Airplane Field,3.34,3.36
Nature Preserve,3.50,2.83
Ned Brown Meadow,4.73,4.60
North Pool,4.48,3.81
Salt Creek Trail,3.86,4.44
Wildlife Refuge,4.14,5.07
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.20615922 0.00210000 NUM3174_50c8
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.86 | 4.31 |
| Beisner Road Entrance | 3.35 | 3.80 |
| Boat Launch Area | 3.97 | 3.98 |
| Busse Lake | 3.77 | 4.73 |
| Debra Park | 3.72 | 3.72 |
| Elk Pasture | 4.90 | 3.26 |
| Forest Central Grove | 4.44 | 4.68 |
| Forest North Grove | 4.26 | 3.83 |
| Forest South Grove | 3.48 | 3.52 |
| Forest West Grove | 4.12 | 4.04 |
| Lake Boating Center | 4.83 | 3.29 |
| Large Event Area | 4.44 | 3.94 |
| Main Dam | 4.55 | 3.61 |
| Main Pool | 3.19 | 4.47 |
| Marshall Park | 4.41 | 3.90 |
| Model Airplane Field | 4.54 | 3.45 |
| Nature Preserve | 3.54 | 4.29 |
| Ned Brown Meadow | 3.41 | 3.83 |
| North Pool | 3.51 | 2.90 |
| Osborn Park | 4.22 | 3.72 |
| Salt Creek Trail | 4.57 | 4.59 |
| Wildlife Refuge | 4.17 | 3.88 |
| Woodland Meadow | 3.35 | 4.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.86,4.31
Beisner Road Entrance,3.35,3.80
Boat Launch Area,3.97,3.98
Busse Lake,3.77,4.73
Debra Park,3.72,3.72
Elk Pasture,4.90,3.26
Forest Central Grove,4.44,4.68
Forest North Grove,4.26,3.83
Forest South Grove,3.48,3.52
Forest West Grove,4.12,4.04
Lake Boating Center,4.83,3.29
Large Event Area,4.44,3.94
Main Dam,4.55,3.61
Main Pool,3.19,4.47
Marshall Park,4.41,3.90
Model Airplane Field,4.54,3.45
Nature Preserve,3.54,4.29
Ned Brown Meadow,3.41,3.83
North Pool,3.51,2.90
Osborn Park,4.22,3.72
Salt Creek Trail,4.57,4.59
Wildlife Refuge,4.17,3.88
Woodland Meadow,3.35,4.77
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.27324191 0.00270000 NUM9cfd_e9c5
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.20 | 4.77 |
| Forest Central Grove | 4.52 | 4.23 |
| Forest North Grove | 4.75 | 3.70 |
| Forest South Grove | 3.85 | 4.91 |
| Forest West Grove | 4.01 | 3.97 |
| Lake Boating Center | 5.13 | 4.14 |
| Large Event Area | 4.75 | 3.67 |
| Main Dam | 4.26 | 3.55 |
| Model Airplane Field | 3.88 | 4.27 |
| Nature Preserve | 4.40 | 4.16 |
| Ned Brown Meadow | 3.79 | 4.18 |
| North Pool | 3.98 | 4.44 |
| South Pool | 3.99 | 5.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
Busse Lake,4.20,4.77
Forest Central Grove,4.52,4.23
Forest North Grove,4.75,3.70
Forest South Grove,3.85,4.91
Forest West Grove,4.01,3.97
Lake Boating Center,5.13,4.14
Large Event Area,4.75,3.67
Main Dam,4.26,3.55
Model Airplane Field,3.88,4.27
Nature Preserve,4.40,4.16
Ned Brown Meadow,3.79,4.18
North Pool,3.98,4.44
South Pool,3.99,5.02
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.41269432 0.00410000 NUM0a2e_f458
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.74 | 4.40 |
| Boat Launch Area | 2.92 | 3.83 |
| Busse Lake | 3.95 | 4.36 |
| Elk Pasture | 4.00 | 3.87 |
| Forest Central Grove | 3.98 | 4.38 |
| Forest North Grove | 5.00 | 3.55 |
| Forest South Grove | 4.46 | 4.37 |
| Lake Boating Center | 4.10 | 3.80 |
| Large Event Area | 4.54 | 3.21 |
| Main Dam | 4.61 | 3.66 |
| Main Pool | 3.35 | 4.16 |
| Marshall Park | 4.61 | 3.73 |
| Model Airplane Field | 4.92 | 3.75 |
| Nature Preserve | 4.75 | 3.71 |
| Ned Brown Meadow | 4.04 | 4.00 |
| North Pool | 3.42 | 3.35 |
| Salt Creek Trail | 3.83 | 3.80 |
| Woodland Meadow | 3.91 | 4.94 |
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.74,4.40
Boat Launch Area,2.92,3.83
Busse Lake,3.95,4.36
Elk Pasture,4.00,3.87
Forest Central Grove,3.98,4.38
Forest North Grove,5.00,3.55
Forest South Grove,4.46,4.37
Lake Boating Center,4.10,3.80
Large Event Area,4.54,3.21
Main Dam,4.61,3.66
Main Pool,3.35,4.16
Marshall Park,4.61,3.73
Model Airplane Field,4.92,3.75
Nature Preserve,4.75,3.71
Ned Brown Meadow,4.04,4.00
North Pool,3.42,3.35
Salt Creek Trail,3.83,3.80
Woodland Meadow,3.91,4.94
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.14363438 0.00140000 NUMa108_64b8
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.96 | 3.93 |
| Debra Park | 4.11 | 4.10 |
| Elk Pasture | 4.44 | 3.70 |
| Forest Central Grove | 3.85 | 3.73 |
| Forest South Grove | 4.64 | 4.13 |
| Forest West Grove | 3.80 | 3.47 |
| Lake Boating Center | 4.23 | 4.53 |
| Main Pool | 3.94 | 3.70 |
| Marshall Park | 4.39 | 4.43 |
| Osborn Park | 4.27 | 4.42 |
| Salt Creek Trail | 3.88 | 4.60 |
| Woodland Meadow | 4.09 | 2.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
Boat Launch Area,4.96,3.93
Debra Park,4.11,4.10
Elk Pasture,4.44,3.70
Forest Central Grove,3.85,3.73
Forest South Grove,4.64,4.13
Forest West Grove,3.80,3.47
Lake Boating Center,4.23,4.53
Main Pool,3.94,3.70
Marshall Park,4.39,4.43
Osborn Park,4.27,4.42
Salt Creek Trail,3.88,4.60
Woodland Meadow,4.09,2.52
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.08595893 0.00100000 NUM3c55_61af
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.48 | 5.00 |
| Boat Launch Area | 4.28 | 3.94 |
| Busse Lake | 4.35 | 3.70 |
| Debra Park | 4.04 | 4.45 |
| Forest North Grove | 4.46 | 3.54 |
| Forest South Grove | 5.03 | 3.76 |
| Main Dam | 4.56 | 3.25 |
| Main Pool | 3.80 | 4.43 |
| Marshall Park | 4.30 | 3.40 |
| North Pool | 3.15 | 3.83 |
| Wildlife Refuge | 3.85 | 4.50 |
| Woodland Meadow | 4.77 | 4.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,4.48,5.00
Boat Launch Area,4.28,3.94
Busse Lake,4.35,3.70
Debra Park,4.04,4.45
Forest North Grove,4.46,3.54
Forest South Grove,5.03,3.76
Main Dam,4.56,3.25
Main Pool,3.80,4.43
Marshall Park,4.30,3.40
North Pool,3.15,3.83
Wildlife Refuge,3.85,4.50
Woodland Meadow,4.77,4.72
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.16784880 0.00170000 NUM52e8_7a7b
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.49 | 4.48 |
| Boat Launch Area | 3.55 | 4.69 |
| Elk Pasture | 3.86 | 4.36 |
| Forest Central Grove | 4.04 | 4.23 |
| Forest North Grove | 4.53 | 4.69 |
| Forest South Grove | 4.36 | 3.59 |
| Forest West Grove | 3.28 | 3.74 |
| Lake Boating Center | 4.15 | 3.74 |
| Large Event Area | 3.50 | 3.94 |
| Main Dam | 4.38 | 3.72 |
| Main Pool | 4.12 | 4.16 |
| Marshall Park | 4.74 | 3.77 |
| Model Airplane Field | 2.94 | 3.92 |
| Nature Preserve | 3.91 | 2.97 |
| North Pool | 4.78 | 3.12 |
| Salt Creek Trail | 3.73 | 4.30 |
| Woodland Meadow | 3.86 | 3.56 |
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.49,4.48
Boat Launch Area,3.55,4.69
Elk Pasture,3.86,4.36
Forest Central Grove,4.04,4.23
Forest North Grove,4.53,4.69
Forest South Grove,4.36,3.59
Forest West Grove,3.28,3.74
Lake Boating Center,4.15,3.74
Large Event Area,3.50,3.94
Main Dam,4.38,3.72
Main Pool,4.12,4.16
Marshall Park,4.74,3.77
Model Airplane Field,2.94,3.92
Nature Preserve,3.91,2.97
North Pool,4.78,3.12
Salt Creek Trail,3.73,4.30
Woodland Meadow,3.86,3.56
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.46761709 0.00470000 NUM0fc0_b178
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.88 | 3.80 |
| Boat Launch Area | 3.18 | 3.30 |
| Busse Lake | 4.11 | 3.28 |
| Debra Park | 3.54 | 4.04 |
| Elk Pasture | 4.83 | 3.35 |
| Forest Central Grove | 4.42 | 4.18 |
| Forest North Grove | 3.96 | 4.66 |
| Forest South Grove | 3.81 | 3.99 |
| Forest West Grove | 5.03 | 4.97 |
| Large Event Area | 4.35 | 3.87 |
| Main Dam | 3.58 | 4.74 |
| Main Pool | 4.04 | 3.86 |
| Marshall Park | 3.49 | 4.22 |
| Model Airplane Field | 3.39 | 3.91 |
| Nature Preserve | 4.24 | 4.00 |
| Ned Brown Meadow | 3.38 | 3.44 |
| North Pool | 4.06 | 4.55 |
| Osborn Park | 4.11 | 4.67 |
| Salt Creek Trail | 3.98 | 2.48 |
| South Pool | 3.81 | 4.38 |
| Wildlife Refuge | 4.28 | 2.47 |
| Woodland Meadow | 4.17 | 4.22 |
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.88,3.80
Boat Launch Area,3.18,3.30
Busse Lake,4.11,3.28
Debra Park,3.54,4.04
Elk Pasture,4.83,3.35
Forest Central Grove,4.42,4.18
Forest North Grove,3.96,4.66
Forest South Grove,3.81,3.99
Forest West Grove,5.03,4.97
Large Event Area,4.35,3.87
Main Dam,3.58,4.74
Main Pool,4.04,3.86
Marshall Park,3.49,4.22
Model Airplane Field,3.39,3.91
Nature Preserve,4.24,4.00
Ned Brown Meadow,3.38,3.44
North Pool,4.06,4.55
Osborn Park,4.11,4.67
Salt Creek Trail,3.98,2.48
South Pool,3.81,4.38
Wildlife Refuge,4.28,2.47
Woodland Meadow,4.17,4.22
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.28242652 0.00280000 NUMa1c7_585f
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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 | 3.27 | 4.12 |
| Busse Lake | 4.24 | 3.87 |
| Debra Park | 3.93 | 4.03 |
| Elk Pasture | 4.00 | 4.47 |
| Forest South Grove | 3.75 | 4.22 |
| Lake Boating Center | 5.32 | 3.06 |
| Main Dam | 4.92 | 4.10 |
| Main Pool | 4.28 | 3.36 |
| Model Airplane Field | 4.91 | 2.59 |
| Osborn Park | 4.01 | 3.41 |
| South Pool | 3.74 | 3.84 |
| Wildlife Refuge | 3.60 | 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
Boat Launch Area,3.27,4.12
Busse Lake,4.24,3.87
Debra Park,3.93,4.03
Elk Pasture,4.00,4.47
Forest South Grove,3.75,4.22
Lake Boating Center,5.32,3.06
Main Dam,4.92,4.10
Main Pool,4.28,3.36
Model Airplane Field,4.91,2.59
Osborn Park,4.01,3.41
South Pool,3.74,3.84
Wildlife Refuge,3.60,4.09
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.05192534 0.00100000 NUM152b_1022
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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 | 2.75 | 3.87 |
| Boat Launch Area | 4.26 | 4.32 |
| Debra Park | 3.65 | 4.15 |
| Elk Pasture | 4.13 | 3.92 |
| Forest North Grove | 4.34 | 3.13 |
| Forest South Grove | 4.31 | 3.65 |
| Forest West Grove | 4.01 | 3.81 |
| Lake Boating Center | 4.38 | 3.93 |
| Model Airplane Field | 5.00 | 3.61 |
| Ned Brown Meadow | 4.94 | 3.74 |
| North Pool | 3.78 | 5.00 |
| Osborn Park | 4.28 | 4.25 |
| Salt Creek Trail | 3.03 | 4.09 |
| Wildlife Refuge | 3.99 | 3.89 |
| Woodland Meadow | 4.63 | 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,2.75,3.87
Boat Launch Area,4.26,4.32
Debra Park,3.65,4.15
Elk Pasture,4.13,3.92
Forest North Grove,4.34,3.13
Forest South Grove,4.31,3.65
Forest West Grove,4.01,3.81
Lake Boating Center,4.38,3.93
Model Airplane Field,5.00,3.61
Ned Brown Meadow,4.94,3.74
North Pool,3.78,5.00
Osborn Park,4.28,4.25
Salt Creek Trail,3.03,4.09
Wildlife Refuge,3.99,3.89
Woodland Meadow,4.63,3.51
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.18845077 0.00190000 NUMf90e_ac06
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.75 | 2.47 |
| Beisner Road Entrance | 4.57 | 4.71 |
| Busse Lake | 3.77 | 3.91 |
| Debra Park | 4.41 | 3.59 |
| Elk Pasture | 3.72 | 3.72 |
| Forest Central Grove | 4.72 | 5.22 |
| Lake Boating Center | 4.47 | 4.45 |
| Large Event Area | 4.08 | 3.38 |
| Main Pool | 5.27 | 3.74 |
| Nature Preserve | 4.50 | 3.50 |
| Ned Brown Meadow | 3.02 | 3.63 |
| Osborn Park | 4.15 | 4.13 |
| South Pool | 4.02 | 4.15 |
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.75,2.47
Beisner Road Entrance,4.57,4.71
Busse Lake,3.77,3.91
Debra Park,4.41,3.59
Elk Pasture,3.72,3.72
Forest Central Grove,4.72,5.22
Lake Boating Center,4.47,4.45
Large Event Area,4.08,3.38
Main Pool,5.27,3.74
Nature Preserve,4.50,3.50
Ned Brown Meadow,3.02,3.63
Osborn Park,4.15,4.13
South Pool,4.02,4.15
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.07081969 0.00100000 NUM9f9a_7d0d
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.43 | 4.42 |
| Busse Lake | 3.32 | 2.84 |
| Elk Pasture | 3.87 | 2.85 |
| Forest North Grove | 2.57 | 3.67 |
| Forest West Grove | 3.99 | 3.61 |
| Main Dam | 3.39 | 3.59 |
| Main Pool | 4.71 | 3.08 |
| Model Airplane Field | 4.47 | 3.79 |
| Nature Preserve | 3.43 | 4.07 |
| Ned Brown Meadow | 3.19 | 2.79 |
| North Pool | 4.29 | 3.41 |
| Osborn Park | 3.28 | 4.12 |
| Wildlife Refuge | 3.55 | 3.42 |
| Woodland Meadow | 3.75 | 4.42 |
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.43,4.42
Busse Lake,3.32,2.84
Elk Pasture,3.87,2.85
Forest North Grove,2.57,3.67
Forest West Grove,3.99,3.61
Main Dam,3.39,3.59
Main Pool,4.71,3.08
Model Airplane Field,4.47,3.79
Nature Preserve,3.43,4.07
Ned Brown Meadow,3.19,2.79
North Pool,4.29,3.41
Osborn Park,3.28,4.12
Wildlife Refuge,3.55,3.42
Woodland Meadow,3.75,4.42
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.24272956 0.00240000 NUM31e6_bb7a
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.68 | 4.22 |
| Beisner Road Entrance | 3.79 | 4.35 |
| Boat Launch Area | 4.11 | 4.07 |
| Elk Pasture | 3.76 | 4.39 |
| Forest South Grove | 4.15 | 4.00 |
| Lake Boating Center | 3.96 | 3.43 |
| Large Event Area | 4.01 | 4.74 |
| Main Dam | 4.74 | 3.74 |
| Marshall Park | 4.60 | 3.43 |
| Model Airplane Field | 4.33 | 3.59 |
| North Pool | 4.18 | 3.42 |
| Osborn Park | 3.98 | 3.93 |
| Salt Creek Trail | 4.11 | 3.64 |
| South Pool | 3.56 | 4.55 |
| Wildlife Refuge | 3.86 | 3.74 |
| Woodland Meadow | 4.25 | 2.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,4.68,4.22
Beisner Road Entrance,3.79,4.35
Boat Launch Area,4.11,4.07
Elk Pasture,3.76,4.39
Forest South Grove,4.15,4.00
Lake Boating Center,3.96,3.43
Large Event Area,4.01,4.74
Main Dam,4.74,3.74
Marshall Park,4.60,3.43
Model Airplane Field,4.33,3.59
North Pool,4.18,3.42
Osborn Park,3.98,3.93
Salt Creek Trail,4.11,3.64
South Pool,3.56,4.55
Wildlife Refuge,3.86,3.74
Woodland Meadow,4.25,2.20
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.05290900 0.00100000 NUMd122_e100
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.46 | 3.58 |
| Busse Lake | 4.12 | 3.53 |
| Debra Park | 4.02 | 3.93 |
| Elk Pasture | 4.34 | 3.66 |
| Forest Central Grove | 4.55 | 4.09 |
| Forest North Grove | 4.10 | 4.15 |
| Forest South Grove | 4.35 | 3.39 |
| Forest West Grove | 4.69 | 3.40 |
| Lake Boating Center | 3.47 | 5.15 |
| Large Event Area | 3.82 | 3.61 |
| Main Dam | 4.21 | 3.32 |
| Main Pool | 4.38 | 4.91 |
| Marshall Park | 4.58 | 4.88 |
| Model Airplane Field | 4.28 | 3.06 |
| Nature Preserve | 4.11 | 3.36 |
| Ned Brown Meadow | 4.02 | 4.07 |
| North Pool | 4.18 | 3.59 |
| Osborn Park | 4.04 | 3.86 |
| Salt Creek Trail | 3.26 | 4.36 |
| South Pool | 3.69 | 3.96 |
| Wildlife Refuge | 4.43 | 4.23 |
| Woodland Meadow | 3.95 | 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
Boat Launch Area,4.46,3.58
Busse Lake,4.12,3.53
Debra Park,4.02,3.93
Elk Pasture,4.34,3.66
Forest Central Grove,4.55,4.09
Forest North Grove,4.10,4.15
Forest South Grove,4.35,3.39
Forest West Grove,4.69,3.40
Lake Boating Center,3.47,5.15
Large Event Area,3.82,3.61
Main Dam,4.21,3.32
Main Pool,4.38,4.91
Marshall Park,4.58,4.88
Model Airplane Field,4.28,3.06
Nature Preserve,4.11,3.36
Ned Brown Meadow,4.02,4.07
North Pool,4.18,3.59
Osborn Park,4.04,3.86
Salt Creek Trail,3.26,4.36
South Pool,3.69,3.96
Wildlife Refuge,4.43,4.23
Woodland Meadow,3.95,4.43
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.07665853 0.00100000 NUM73b8_5c37
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.62 | 2.92 |
| Beisner Road Entrance | 3.22 | 4.06 |
| Boat Launch Area | 4.92 | 3.98 |
| Busse Lake | 4.68 | 3.73 |
| Debra Park | 3.83 | 2.18 |
| Forest Central Grove | 3.87 | 3.01 |
| Forest North Grove | 5.05 | 3.75 |
| Forest South Grove | 3.86 | 3.61 |
| Forest West Grove | 4.53 | 4.34 |
| Lake Boating Center | 3.63 | 4.10 |
| Large Event Area | 4.23 | 4.48 |
| Main Dam | 3.72 | 5.03 |
| Marshall Park | 4.54 | 3.71 |
| Model Airplane Field | 3.73 | 3.81 |
| Nature Preserve | 3.64 | 4.37 |
| Ned Brown Meadow | 3.65 | 4.56 |
| North Pool | 3.10 | 3.53 |
| Osborn Park | 4.22 | 3.24 |
| Salt Creek Trail | 4.36 | 3.68 |
| South Pool | 4.43 | 4.07 |
| Wildlife Refuge | 4.46 | 4.23 |
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.62,2.92
Beisner Road Entrance,3.22,4.06
Boat Launch Area,4.92,3.98
Busse Lake,4.68,3.73
Debra Park,3.83,2.18
Forest Central Grove,3.87,3.01
Forest North Grove,5.05,3.75
Forest South Grove,3.86,3.61
Forest West Grove,4.53,4.34
Lake Boating Center,3.63,4.10
Large Event Area,4.23,4.48
Main Dam,3.72,5.03
Marshall Park,4.54,3.71
Model Airplane Field,3.73,3.81
Nature Preserve,3.64,4.37
Ned Brown Meadow,3.65,4.56
North Pool,3.10,3.53
Osborn Park,4.22,3.24
Salt Creek Trail,4.36,3.68
South Pool,4.43,4.07
Wildlife Refuge,4.46,4.23
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.06493417 0.00100000 NUM3c9a_3a25
Two-Sample Test of Shannon Diversity: 2014 vs 2024
Use a one tailed Welch two sample t test for H1: mean_2024 < mean_2014.
Assume unequal variances.
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.27 | 3.65 |
| Debra Park | 4.17 | 4.25 |
| Elk Pasture | 4.61 | 3.03 |
| Forest Central Grove | 3.38 | 4.39 |
| Forest South Grove | 5.12 | 4.99 |
| Forest West Grove | 4.72 | 4.08 |
| Lake Boating Center | 3.93 | 3.59 |
| Large Event Area | 3.01 | 4.33 |
| Main Dam | 4.10 | 2.86 |
| Main Pool | 4.05 | 3.40 |
| Nature Preserve | 3.84 | 4.53 |
| Ned Brown Meadow | 3.80 | 3.91 |
| North Pool | 3.43 | 3.85 |
| Osborn Park | 5.15 | 3.96 |
| Wildlife Refuge | 5.33 | 3.75 |
| Woodland Meadow | 4.26 | 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
Busse Lake,4.27,3.65
Debra Park,4.17,4.25
Elk Pasture,4.61,3.03
Forest Central Grove,3.38,4.39
Forest South Grove,5.12,4.99
Forest West Grove,4.72,4.08
Lake Boating Center,3.93,3.59
Large Event Area,3.01,4.33
Main Dam,4.10,2.86
Main Pool,4.05,3.40
Nature Preserve,3.84,4.53
Ned Brown Meadow,3.80,3.91
North Pool,3.43,3.85
Osborn Park,5.15,3.96
Wildlife Refuge,5.33,3.75
Woodland Meadow,4.26,4.25
Compute the p value in Google Sheets using the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.10812604 0.00110000