7a7f_65f3
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Beisner Road Entrance | 3.53 |
| Boat Launch Area | 4.63 |
| Elk Pasture | 4.17 |
| Forest Central Grove | 2.68 |
| Forest North Grove | 3.84 |
| Forest West Grove | 4.04 |
| Lake Boating Center | 3.99 |
| Main Dam | 3.92 |
| Main Pool | 3.75 |
| Model Airplane Field | 3.52 |
| Nature Preserve | 3.98 |
| Osborn Park | 4.55 |
| South Pool | 3.85 |
| Wildlife Refuge | 3.72 |
| Woodland Meadow | 4.34 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Beisner Road Entrance,3.53
Boat Launch Area,4.63
Elk Pasture,4.17
Forest Central Grove,2.68
Forest North Grove,3.84
Forest West Grove,4.04
Lake Boating Center,3.99
Main Dam,3.92
Main Pool,3.75
Model Airplane Field,3.52
Nature Preserve,3.98
Osborn Park,4.55
South Pool,3.85
Wildlife Refuge,3.72
Woodland Meadow,4.34
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.52139671 0.00520000 NUM0b5c_58f2
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 3.90 |
| Boat Launch Area | 3.56 |
| Busse Lake | 3.35 |
| Elk Pasture | 3.29 |
| Forest Central Grove | 3.97 |
| Forest South Grove | 3.74 |
| Forest West Grove | 4.02 |
| Lake Boating Center | 4.18 |
| Large Event Area | 3.48 |
| Main Dam | 3.56 |
| Main Pool | 3.94 |
| Marshall Park | 3.60 |
| Model Airplane Field | 3.94 |
| Nature Preserve | 3.31 |
| Ned Brown Meadow | 4.59 |
| North Pool | 3.88 |
| Salt Creek Trail | 3.34 |
| South Pool | 3.56 |
| Wildlife Refuge | 3.54 |
| Woodland Meadow | 4.38 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,3.90
Boat Launch Area,3.56
Busse Lake,3.35
Elk Pasture,3.29
Forest Central Grove,3.97
Forest South Grove,3.74
Forest West Grove,4.02
Lake Boating Center,4.18
Large Event Area,3.48
Main Dam,3.56
Main Pool,3.94
Marshall Park,3.60
Model Airplane Field,3.94
Nature Preserve,3.31
Ned Brown Meadow,4.59
North Pool,3.88
Salt Creek Trail,3.34
South Pool,3.56
Wildlife Refuge,3.54
Woodland Meadow,4.38
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.06953285 0.00100000 NUM5a14_1184
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 4.24 |
| Beisner Road Entrance | 3.87 |
| Boat Launch Area | 3.20 |
| Busse Lake | 3.90 |
| Debra Park | 3.24 |
| Forest Central Grove | 4.12 |
| Forest North Grove | 2.39 |
| Forest West Grove | 4.50 |
| Lake Boating Center | 3.13 |
| Main Dam | 4.05 |
| Marshall Park | 5.36 |
| Nature Preserve | 4.29 |
| Osborn Park | 3.77 |
| Salt Creek Trail | 3.53 |
| Woodland Meadow | 4.76 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,4.24
Beisner Road Entrance,3.87
Boat Launch Area,3.20
Busse Lake,3.90
Debra Park,3.24
Forest Central Grove,4.12
Forest North Grove,2.39
Forest West Grove,4.50
Lake Boating Center,3.13
Main Dam,4.05
Marshall Park,5.36
Nature Preserve,4.29
Osborn Park,3.77
Salt Creek Trail,3.53
Woodland Meadow,4.76
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.47767502 0.00480000 NUM896e_729c
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Boat Launch Area | 3.52 |
| Busse Lake | 3.45 |
| Debra Park | 3.99 |
| Forest West Grove | 3.88 |
| Large Event Area | 3.96 |
| Main Dam | 4.10 |
| Main Pool | 3.63 |
| Marshall Park | 4.14 |
| Model Airplane Field | 4.70 |
| Nature Preserve | 5.21 |
| North Pool | 4.03 |
| Salt Creek Trail | 5.32 |
| South Pool | 4.63 |
| Wildlife Refuge | 4.78 |
| Woodland Meadow | 4.08 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Boat Launch Area,3.52
Busse Lake,3.45
Debra Park,3.99
Forest West Grove,3.88
Large Event Area,3.96
Main Dam,4.10
Main Pool,3.63
Marshall Park,4.14
Model Airplane Field,4.70
Nature Preserve,5.21
North Pool,4.03
Salt Creek Trail,5.32
South Pool,4.63
Wildlife Refuge,4.78
Woodland Meadow,4.08
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.14109281 0.00140000 NUM66e2_3f5f
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 4.61 |
| Beisner Road Entrance | 3.97 |
| Boat Launch Area | 4.51 |
| Forest North Grove | 4.34 |
| Forest West Grove | 3.71 |
| Main Dam | 3.05 |
| Marshall Park | 3.85 |
| Model Airplane Field | 4.79 |
| Nature Preserve | 4.17 |
| Ned Brown Meadow | 3.30 |
| Osborn Park | 3.60 |
| South Pool | 3.25 |
| Woodland Meadow | 2.94 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,4.61
Beisner Road Entrance,3.97
Boat Launch Area,4.51
Forest North Grove,4.34
Forest West Grove,3.71
Main Dam,3.05
Marshall Park,3.85
Model Airplane Field,4.79
Nature Preserve,4.17
Ned Brown Meadow,3.30
Osborn Park,3.60
South Pool,3.25
Woodland Meadow,2.94
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.37729149 0.00380000 NUMaced_2726
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Beisner Road Entrance | 4.31 |
| Busse Lake | 3.66 |
| Debra Park | 3.02 |
| Elk Pasture | 2.20 |
| Forest South Grove | 4.01 |
| Lake Boating Center | 3.95 |
| Large Event Area | 4.19 |
| Main Dam | 4.47 |
| Marshall Park | 4.35 |
| Ned Brown Meadow | 4.05 |
| North Pool | 3.24 |
| Salt Creek Trail | 3.08 |
| Wildlife Refuge | 4.40 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Beisner Road Entrance,4.31
Busse Lake,3.66
Debra Park,3.02
Elk Pasture,2.20
Forest South Grove,4.01
Lake Boating Center,3.95
Large Event Area,4.19
Main Dam,4.47
Marshall Park,4.35
Ned Brown Meadow,4.05
North Pool,3.24
Salt Creek Trail,3.08
Wildlife Refuge,4.40
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.15586753 0.00160000 NUMec8b_7023
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Boat Launch Area | 4.68 |
| Busse Lake | 3.05 |
| Elk Pasture | 4.28 |
| Forest Central Grove | 4.60 |
| Forest North Grove | 4.14 |
| Lake Boating Center | 3.71 |
| Large Event Area | 3.00 |
| Main Dam | 3.51 |
| Main Pool | 3.17 |
| Model Airplane Field | 3.95 |
| North Pool | 2.98 |
| Osborn Park | 4.66 |
| South Pool | 4.48 |
| Wildlife Refuge | 2.99 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Boat Launch Area,4.68
Busse Lake,3.05
Elk Pasture,4.28
Forest Central Grove,4.60
Forest North Grove,4.14
Lake Boating Center,3.71
Large Event Area,3.00
Main Dam,3.51
Main Pool,3.17
Model Airplane Field,3.95
North Pool,2.98
Osborn Park,4.66
South Pool,4.48
Wildlife Refuge,2.99
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.21231716 0.00210000 NUM4724_6d11
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Boat Launch Area | 3.92 |
| Debra Park | 4.28 |
| Elk Pasture | 4.91 |
| Forest North Grove | 4.14 |
| Forest South Grove | 5.01 |
| Forest West Grove | 4.94 |
| Large Event Area | 4.15 |
| Main Pool | 5.00 |
| Marshall Park | 3.61 |
| Ned Brown Meadow | 3.84 |
| North Pool | 3.48 |
| Osborn Park | 3.86 |
| Salt Creek Trail | 4.89 |
| South Pool | 4.04 |
| Woodland Meadow | 4.39 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Boat Launch Area,3.92
Debra Park,4.28
Elk Pasture,4.91
Forest North Grove,4.14
Forest South Grove,5.01
Forest West Grove,4.94
Large Event Area,4.15
Main Pool,5.00
Marshall Park,3.61
Ned Brown Meadow,3.84
North Pool,3.48
Osborn Park,3.86
Salt Creek Trail,4.89
South Pool,4.04
Woodland Meadow,4.39
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.05494911 0.00100000 NUM20f4_d267
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 4.58 |
| Beisner Road Entrance | 3.53 |
| Boat Launch Area | 3.14 |
| Busse Lake | 4.31 |
| Debra Park | 3.29 |
| Forest Central Grove | 4.25 |
| Forest West Grove | 4.48 |
| Lake Boating Center | 3.16 |
| Large Event Area | 4.16 |
| Main Dam | 4.77 |
| Main Pool | 4.36 |
| Ned Brown Meadow | 4.65 |
| North Pool | 3.85 |
| Salt Creek Trail | 3.91 |
| South Pool | 4.69 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,4.58
Beisner Road Entrance,3.53
Boat Launch Area,3.14
Busse Lake,4.31
Debra Park,3.29
Forest Central Grove,4.25
Forest West Grove,4.48
Lake Boating Center,3.16
Large Event Area,4.16
Main Dam,4.77
Main Pool,4.36
Ned Brown Meadow,4.65
North Pool,3.85
Salt Creek Trail,3.91
South Pool,4.69
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.62677250 0.00630000 NUM5b6c_2fb7
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 4.41 |
| Beisner Road Entrance | 3.09 |
| Debra Park | 4.01 |
| Elk Pasture | 4.43 |
| Forest Central Grove | 3.50 |
| Forest North Grove | 3.36 |
| Forest West Grove | 4.94 |
| Main Dam | 3.85 |
| Main Pool | 4.50 |
| Marshall Park | 4.35 |
| Model Airplane Field | 3.55 |
| Ned Brown Meadow | 4.03 |
| North Pool | 3.33 |
| Osborn Park | 4.23 |
| Salt Creek Trail | 3.78 |
| Woodland Meadow | 3.51 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,4.41
Beisner Road Entrance,3.09
Debra Park,4.01
Elk Pasture,4.43
Forest Central Grove,3.50
Forest North Grove,3.36
Forest West Grove,4.94
Main Dam,3.85
Main Pool,4.50
Marshall Park,4.35
Model Airplane Field,3.55
Ned Brown Meadow,4.03
North Pool,3.33
Osborn Park,4.23
Salt Creek Trail,3.78
Woodland Meadow,3.51
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.63775976 0.00640000 NUM8058_c332
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Boat Launch Area | 4.01 |
| Elk Pasture | 3.04 |
| Forest Central Grove | 3.42 |
| Forest North Grove | 3.47 |
| Forest South Grove | 3.66 |
| Forest West Grove | 2.94 |
| Lake Boating Center | 3.79 |
| Main Dam | 4.47 |
| Main Pool | 3.54 |
| Marshall Park | 4.03 |
| Model Airplane Field | 2.74 |
| Osborn Park | 4.34 |
| Woodland Meadow | 4.34 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Boat Launch Area,4.01
Elk Pasture,3.04
Forest Central Grove,3.42
Forest North Grove,3.47
Forest South Grove,3.66
Forest West Grove,2.94
Lake Boating Center,3.79
Main Dam,4.47
Main Pool,3.54
Marshall Park,4.03
Model Airplane Field,2.74
Osborn Park,4.34
Woodland Meadow,4.34
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.05164595 0.00100000 NUMaf55_2a22
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 4.32 |
| Beisner Road Entrance | 4.28 |
| Busse Lake | 5.72 |
| Elk Pasture | 4.18 |
| Forest North Grove | 3.86 |
| Forest South Grove | 3.14 |
| Forest West Grove | 3.48 |
| Lake Boating Center | 3.49 |
| Large Event Area | 3.49 |
| Main Dam | 3.97 |
| Marshall Park | 3.86 |
| Model Airplane Field | 4.09 |
| Nature Preserve | 2.88 |
| Ned Brown Meadow | 3.70 |
| North Pool | 3.86 |
| Salt Creek Trail | 2.89 |
| South Pool | 3.76 |
| Wildlife Refuge | 4.76 |
| Woodland Meadow | 3.53 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,4.32
Beisner Road Entrance,4.28
Busse Lake,5.72
Elk Pasture,4.18
Forest North Grove,3.86
Forest South Grove,3.14
Forest West Grove,3.48
Lake Boating Center,3.49
Large Event Area,3.49
Main Dam,3.97
Marshall Park,3.86
Model Airplane Field,4.09
Nature Preserve,2.88
Ned Brown Meadow,3.70
North Pool,3.86
Salt Creek Trail,2.89
South Pool,3.76
Wildlife Refuge,4.76
Woodland Meadow,3.53
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.29479289 0.00290000 NUMca05_f975
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 4.59 |
| Beisner Road Entrance | 4.27 |
| Boat Launch Area | 3.42 |
| Debra Park | 3.12 |
| Elk Pasture | 3.36 |
| Forest Central Grove | 3.53 |
| Forest South Grove | 3.88 |
| Forest West Grove | 5.00 |
| Lake Boating Center | 4.84 |
| Large Event Area | 3.89 |
| Main Pool | 3.61 |
| Marshall Park | 3.35 |
| North Pool | 4.64 |
| Osborn Park | 3.32 |
| Salt Creek Trail | 4.63 |
| South Pool | 3.73 |
| Wildlife Refuge | 2.95 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,4.59
Beisner Road Entrance,4.27
Boat Launch Area,3.42
Debra Park,3.12
Elk Pasture,3.36
Forest Central Grove,3.53
Forest South Grove,3.88
Forest West Grove,5.00
Lake Boating Center,4.84
Large Event Area,3.89
Main Pool,3.61
Marshall Park,3.35
North Pool,4.64
Osborn Park,3.32
Salt Creek Trail,4.63
South Pool,3.73
Wildlife Refuge,2.95
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.44970754 0.00450000 NUM8491_71b6
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 3.34 |
| Busse Lake | 4.50 |
| Debra Park | 4.66 |
| Elk Pasture | 4.66 |
| Forest Central Grove | 4.55 |
| Forest West Grove | 3.34 |
| Large Event Area | 2.95 |
| Main Dam | 4.70 |
| Main Pool | 3.98 |
| Marshall Park | 4.59 |
| Model Airplane Field | 4.65 |
| Nature Preserve | 3.82 |
| Ned Brown Meadow | 4.20 |
| Osborn Park | 4.38 |
| Salt Creek Trail | 4.75 |
| Woodland Meadow | 3.30 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,3.34
Busse Lake,4.50
Debra Park,4.66
Elk Pasture,4.66
Forest Central Grove,4.55
Forest West Grove,3.34
Large Event Area,2.95
Main Dam,4.70
Main Pool,3.98
Marshall Park,4.59
Model Airplane Field,4.65
Nature Preserve,3.82
Ned Brown Meadow,4.20
Osborn Park,4.38
Salt Creek Trail,4.75
Woodland Meadow,3.30
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.32339758 0.00320000 NUM9fd0_7fb2
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 3.61 |
| Beisner Road Entrance | 3.20 |
| Busse Lake | 4.07 |
| Debra Park | 3.97 |
| Elk Pasture | 5.11 |
| Forest Central Grove | 3.81 |
| Forest North Grove | 3.78 |
| Forest West Grove | 3.23 |
| Large Event Area | 4.17 |
| Main Dam | 4.18 |
| Model Airplane Field | 3.24 |
| Ned Brown Meadow | 3.75 |
| Salt Creek Trail | 3.18 |
| South Pool | 3.57 |
| Wildlife Refuge | 2.77 |
| Woodland Meadow | 4.52 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,3.61
Beisner Road Entrance,3.20
Busse Lake,4.07
Debra Park,3.97
Elk Pasture,5.11
Forest Central Grove,3.81
Forest North Grove,3.78
Forest West Grove,3.23
Large Event Area,4.17
Main Dam,4.18
Model Airplane Field,3.24
Ned Brown Meadow,3.75
Salt Creek Trail,3.18
South Pool,3.57
Wildlife Refuge,2.77
Woodland Meadow,4.52
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.10959858 0.00110000 NUM3697_70b8
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 4.55 |
| Busse Lake | 3.90 |
| Debra Park | 3.42 |
| Forest South Grove | 4.29 |
| Lake Boating Center | 4.97 |
| Large Event Area | 3.45 |
| Main Pool | 5.09 |
| Nature Preserve | 3.29 |
| Ned Brown Meadow | 4.46 |
| North Pool | 5.30 |
| Salt Creek Trail | 3.88 |
| South Pool | 4.47 |
| Wildlife Refuge | 4.27 |
| Woodland Meadow | 4.98 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,4.55
Busse Lake,3.90
Debra Park,3.42
Forest South Grove,4.29
Lake Boating Center,4.97
Large Event Area,3.45
Main Pool,5.09
Nature Preserve,3.29
Ned Brown Meadow,4.46
North Pool,5.30
Salt Creek Trail,3.88
South Pool,4.47
Wildlife Refuge,4.27
Woodland Meadow,4.98
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.05431938 0.00100000 NUM83d6_194d
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 4.29 |
| Beisner Road Entrance | 3.17 |
| Boat Launch Area | 2.81 |
| Debra Park | 4.78 |
| Elk Pasture | 2.82 |
| Forest Central Grove | 3.98 |
| Forest South Grove | 4.21 |
| Lake Boating Center | 4.66 |
| Main Dam | 3.93 |
| Main Pool | 3.84 |
| Marshall Park | 3.77 |
| Model Airplane Field | 3.99 |
| Nature Preserve | 3.73 |
| Salt Creek Trail | 3.20 |
| South Pool | 4.11 |
| Wildlife Refuge | 3.77 |
| Woodland Meadow | 2.91 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,4.29
Beisner Road Entrance,3.17
Boat Launch Area,2.81
Debra Park,4.78
Elk Pasture,2.82
Forest Central Grove,3.98
Forest South Grove,4.21
Lake Boating Center,4.66
Main Dam,3.93
Main Pool,3.84
Marshall Park,3.77
Model Airplane Field,3.99
Nature Preserve,3.73
Salt Creek Trail,3.20
South Pool,4.11
Wildlife Refuge,3.77
Woodland Meadow,2.91
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.10330647 0.00100000 NUMcb87_097d
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 4.20 |
| Boat Launch Area | 4.18 |
| Elk Pasture | 3.20 |
| Forest South Grove | 5.28 |
| Lake Boating Center | 4.39 |
| Large Event Area | 4.64 |
| Main Dam | 4.17 |
| Marshall Park | 4.31 |
| Model Airplane Field | 4.04 |
| Nature Preserve | 4.54 |
| Ned Brown Meadow | 4.24 |
| North Pool | 4.28 |
| Salt Creek Trail | 4.01 |
| South Pool | 3.75 |
| Wildlife Refuge | 3.69 |
| Woodland Meadow | 3.64 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,4.20
Boat Launch Area,4.18
Elk Pasture,3.20
Forest South Grove,5.28
Lake Boating Center,4.39
Large Event Area,4.64
Main Dam,4.17
Marshall Park,4.31
Model Airplane Field,4.04
Nature Preserve,4.54
Ned Brown Meadow,4.24
North Pool,4.28
Salt Creek Trail,4.01
South Pool,3.75
Wildlife Refuge,3.69
Woodland Meadow,3.64
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.28612238 0.00290000 NUM53e9_2b34
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 4.46 |
| Boat Launch Area | 2.15 |
| Busse Lake | 4.72 |
| Forest North Grove | 4.49 |
| Forest South Grove | 4.14 |
| Forest West Grove | 3.75 |
| Lake Boating Center | 4.66 |
| Main Dam | 3.16 |
| Marshall Park | 3.63 |
| Model Airplane Field | 3.39 |
| Ned Brown Meadow | 4.03 |
| North Pool | 4.17 |
| Osborn Park | 3.47 |
| Salt Creek Trail | 4.07 |
| South Pool | 3.42 |
| Wildlife Refuge | 4.77 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,4.46
Boat Launch Area,2.15
Busse Lake,4.72
Forest North Grove,4.49
Forest South Grove,4.14
Forest West Grove,3.75
Lake Boating Center,4.66
Main Dam,3.16
Marshall Park,3.63
Model Airplane Field,3.39
Ned Brown Meadow,4.03
North Pool,4.17
Osborn Park,3.47
Salt Creek Trail,4.07
South Pool,3.42
Wildlife Refuge,4.77
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.52651599 0.00530000 NUMa8f9_3442
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 4.06 |
| Beisner Road Entrance | 4.01 |
| Busse Lake | 3.38 |
| Debra Park | 3.06 |
| Elk Pasture | 2.28 |
| Forest Central Grove | 3.74 |
| Forest South Grove | 4.37 |
| Forest West Grove | 3.16 |
| Lake Boating Center | 4.02 |
| Large Event Area | 3.95 |
| Main Dam | 3.40 |
| Marshall Park | 3.68 |
| Model Airplane Field | 3.74 |
| Nature Preserve | 2.76 |
| Ned Brown Meadow | 4.34 |
| Osborn Park | 4.09 |
| Salt Creek Trail | 4.78 |
| Wildlife Refuge | 4.63 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,4.06
Beisner Road Entrance,4.01
Busse Lake,3.38
Debra Park,3.06
Elk Pasture,2.28
Forest Central Grove,3.74
Forest South Grove,4.37
Forest West Grove,3.16
Lake Boating Center,4.02
Large Event Area,3.95
Main Dam,3.40
Marshall Park,3.68
Model Airplane Field,3.74
Nature Preserve,2.76
Ned Brown Meadow,4.34
Osborn Park,4.09
Salt Creek Trail,4.78
Wildlife Refuge,4.63
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.07387144 0.00100000 NUM9abc_449b
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 3.85 |
| Boat Launch Area | 3.78 |
| Busse Lake | 5.05 |
| Debra Park | 4.67 |
| Forest North Grove | 4.72 |
| Forest South Grove | 3.98 |
| Forest West Grove | 4.61 |
| Large Event Area | 4.07 |
| Main Dam | 4.08 |
| Main Pool | 3.88 |
| Marshall Park | 4.45 |
| Model Airplane Field | 3.46 |
| North Pool | 4.56 |
| Osborn Park | 4.85 |
| Salt Creek Trail | 3.58 |
| South Pool | 5.08 |
| Wildlife Refuge | 4.39 |
| Woodland Meadow | 3.44 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,3.85
Boat Launch Area,3.78
Busse Lake,5.05
Debra Park,4.67
Forest North Grove,4.72
Forest South Grove,3.98
Forest West Grove,4.61
Large Event Area,4.07
Main Dam,4.08
Main Pool,3.88
Marshall Park,4.45
Model Airplane Field,3.46
North Pool,4.56
Osborn Park,4.85
Salt Creek Trail,3.58
South Pool,5.08
Wildlife Refuge,4.39
Woodland Meadow,3.44
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.07709987 0.00100000 NUM537f_3f5f
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 4.19 |
| Beisner Road Entrance | 3.87 |
| Boat Launch Area | 5.08 |
| Debra Park | 3.72 |
| Forest Central Grove | 4.30 |
| Forest North Grove | 3.62 |
| Forest South Grove | 4.66 |
| Forest West Grove | 3.04 |
| Lake Boating Center | 2.59 |
| Large Event Area | 3.25 |
| Main Pool | 3.57 |
| Marshall Park | 3.90 |
| Model Airplane Field | 4.07 |
| Ned Brown Meadow | 4.48 |
| Wildlife Refuge | 4.34 |
| Woodland Meadow | 3.20 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,4.19
Beisner Road Entrance,3.87
Boat Launch Area,5.08
Debra Park,3.72
Forest Central Grove,4.30
Forest North Grove,3.62
Forest South Grove,4.66
Forest West Grove,3.04
Lake Boating Center,2.59
Large Event Area,3.25
Main Pool,3.57
Marshall Park,3.90
Model Airplane Field,4.07
Ned Brown Meadow,4.48
Wildlife Refuge,4.34
Woodland Meadow,3.20
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.37705620 0.00380000 NUM2d86_da2c
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 3.77 |
| Beisner Road Entrance | 4.42 |
| Busse Lake | 3.99 |
| Debra Park | 5.26 |
| Elk Pasture | 4.60 |
| Forest Central Grove | 4.13 |
| Forest North Grove | 3.51 |
| Forest West Grove | 4.24 |
| Lake Boating Center | 2.97 |
| Large Event Area | 4.24 |
| Main Dam | 5.89 |
| Main Pool | 4.06 |
| Marshall Park | 3.65 |
| Model Airplane Field | 4.09 |
| Ned Brown Meadow | 4.56 |
| North Pool | 4.34 |
| Osborn Park | 4.15 |
| South Pool | 4.71 |
| Wildlife Refuge | 3.92 |
| Woodland Meadow | 4.54 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,3.77
Beisner Road Entrance,4.42
Busse Lake,3.99
Debra Park,5.26
Elk Pasture,4.60
Forest Central Grove,4.13
Forest North Grove,3.51
Forest West Grove,4.24
Lake Boating Center,2.97
Large Event Area,4.24
Main Dam,5.89
Main Pool,4.06
Marshall Park,3.65
Model Airplane Field,4.09
Ned Brown Meadow,4.56
North Pool,4.34
Osborn Park,4.15
South Pool,4.71
Wildlife Refuge,3.92
Woodland Meadow,4.54
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.06034053 0.00100000 NUM37a8_ec7a
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 5.07 |
| Boat Launch Area | 4.13 |
| Busse Lake | 3.81 |
| Elk Pasture | 4.23 |
| Forest Central Grove | 4.49 |
| Forest North Grove | 4.13 |
| Forest South Grove | 5.21 |
| Lake Boating Center | 3.63 |
| Large Event Area | 4.67 |
| Main Dam | 4.07 |
| Main Pool | 3.59 |
| Model Airplane Field | 2.02 |
| Ned Brown Meadow | 4.69 |
| North Pool | 4.29 |
| Osborn Park | 4.53 |
| Salt Creek Trail | 3.15 |
| South Pool | 4.24 |
| Wildlife Refuge | 3.98 |
| Woodland Meadow | 4.11 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,5.07
Boat Launch Area,4.13
Busse Lake,3.81
Elk Pasture,4.23
Forest Central Grove,4.49
Forest North Grove,4.13
Forest South Grove,5.21
Lake Boating Center,3.63
Large Event Area,4.67
Main Dam,4.07
Main Pool,3.59
Model Airplane Field,2.02
Ned Brown Meadow,4.69
North Pool,4.29
Osborn Park,4.53
Salt Creek Trail,3.15
South Pool,4.24
Wildlife Refuge,3.98
Woodland Meadow,4.11
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.43538293 0.00440000 NUM9562_03e7
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 3.02 |
| Beisner Road Entrance | 3.95 |
| Boat Launch Area | 4.03 |
| Busse Lake | 4.92 |
| Debra Park | 3.57 |
| Forest South Grove | 4.16 |
| Forest West Grove | 4.30 |
| Lake Boating Center | 3.87 |
| Marshall Park | 3.88 |
| Model Airplane Field | 4.99 |
| Nature Preserve | 3.36 |
| Ned Brown Meadow | 4.86 |
| Osborn Park | 3.86 |
| Salt Creek Trail | 3.50 |
| South Pool | 4.75 |
| Woodland Meadow | 3.78 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,3.02
Beisner Road Entrance,3.95
Boat Launch Area,4.03
Busse Lake,4.92
Debra Park,3.57
Forest South Grove,4.16
Forest West Grove,4.30
Lake Boating Center,3.87
Marshall Park,3.88
Model Airplane Field,4.99
Nature Preserve,3.36
Ned Brown Meadow,4.86
Osborn Park,3.86
Salt Creek Trail,3.50
South Pool,4.75
Woodland Meadow,3.78
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.73888268 0.00740000 NUM1411_0d15
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Beisner Road Entrance | 3.78 |
| Boat Launch Area | 3.53 |
| Busse Lake | 3.43 |
| Elk Pasture | 3.37 |
| Forest North Grove | 3.91 |
| Forest South Grove | 3.65 |
| Forest West Grove | 4.07 |
| Lake Boating Center | 4.28 |
| Large Event Area | 3.91 |
| Main Dam | 3.14 |
| Marshall Park | 4.67 |
| Model Airplane Field | 3.61 |
| Nature Preserve | 4.71 |
| North Pool | 4.17 |
| Osborn Park | 3.68 |
| Salt Creek Trail | 4.16 |
| South Pool | 4.20 |
| Wildlife Refuge | 3.96 |
| Woodland Meadow | 3.53 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Beisner Road Entrance,3.78
Boat Launch Area,3.53
Busse Lake,3.43
Elk Pasture,3.37
Forest North Grove,3.91
Forest South Grove,3.65
Forest West Grove,4.07
Lake Boating Center,4.28
Large Event Area,3.91
Main Dam,3.14
Marshall Park,4.67
Model Airplane Field,3.61
Nature Preserve,4.71
North Pool,4.17
Osborn Park,3.68
Salt Creek Trail,4.16
South Pool,4.20
Wildlife Refuge,3.96
Woodland Meadow,3.53
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.39172934 0.00390000 NUMab3f_39a6
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Boat Launch Area | 3.57 |
| Busse Lake | 4.14 |
| Forest Central Grove | 4.10 |
| Forest North Grove | 5.53 |
| Forest South Grove | 3.73 |
| Forest West Grove | 4.73 |
| Lake Boating Center | 3.69 |
| Large Event Area | 4.67 |
| Main Dam | 3.96 |
| Main Pool | 5.16 |
| Model Airplane Field | 5.05 |
| Nature Preserve | 4.46 |
| Ned Brown Meadow | 4.38 |
| Salt Creek Trail | 3.64 |
| Wildlife Refuge | 3.10 |
| Woodland Meadow | 3.45 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Boat Launch Area,3.57
Busse Lake,4.14
Forest Central Grove,4.10
Forest North Grove,5.53
Forest South Grove,3.73
Forest West Grove,4.73
Lake Boating Center,3.69
Large Event Area,4.67
Main Dam,3.96
Main Pool,5.16
Model Airplane Field,5.05
Nature Preserve,4.46
Ned Brown Meadow,4.38
Salt Creek Trail,3.64
Wildlife Refuge,3.10
Woodland Meadow,3.45
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.16151332 0.00160000 NUM25c7_473a
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 3.14 |
| Boat Launch Area | 4.59 |
| Busse Lake | 3.75 |
| Debra Park | 4.24 |
| Elk Pasture | 2.63 |
| Forest Central Grove | 2.67 |
| Forest North Grove | 4.13 |
| Forest South Grove | 4.34 |
| Forest West Grove | 3.72 |
| Lake Boating Center | 3.76 |
| Large Event Area | 3.48 |
| Main Dam | 4.34 |
| Main Pool | 3.59 |
| Model Airplane Field | 4.40 |
| Nature Preserve | 3.61 |
| Ned Brown Meadow | 3.90 |
| North Pool | 3.09 |
| Salt Creek Trail | 3.99 |
| Woodland Meadow | 4.83 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,3.14
Boat Launch Area,4.59
Busse Lake,3.75
Debra Park,4.24
Elk Pasture,2.63
Forest Central Grove,2.67
Forest North Grove,4.13
Forest South Grove,4.34
Forest West Grove,3.72
Lake Boating Center,3.76
Large Event Area,3.48
Main Dam,4.34
Main Pool,3.59
Model Airplane Field,4.40
Nature Preserve,3.61
Ned Brown Meadow,3.90
North Pool,3.09
Salt Creek Trail,3.99
Woodland Meadow,4.83
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.14623311 0.00150000 NUM8c3f_8a75
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Beisner Road Entrance | 2.76 |
| Boat Launch Area | 4.35 |
| Debra Park | 3.79 |
| Elk Pasture | 4.10 |
| Forest Central Grove | 3.76 |
| Forest North Grove | 3.13 |
| Forest West Grove | 3.56 |
| Large Event Area | 4.69 |
| Main Pool | 5.46 |
| Model Airplane Field | 3.09 |
| Nature Preserve | 6.00 |
| Ned Brown Meadow | 4.07 |
| South Pool | 4.30 |
| Woodland Meadow | 3.41 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Beisner Road Entrance,2.76
Boat Launch Area,4.35
Debra Park,3.79
Elk Pasture,4.10
Forest Central Grove,3.76
Forest North Grove,3.13
Forest West Grove,3.56
Large Event Area,4.69
Main Pool,5.46
Model Airplane Field,3.09
Nature Preserve,6.00
Ned Brown Meadow,4.07
South Pool,4.30
Woodland Meadow,3.41
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.83417140 0.00830000 NUM6799_4cec
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 4.36 |
| Busse Lake | 3.29 |
| Debra Park | 4.25 |
| Forest Central Grove | 4.95 |
| Forest North Grove | 3.19 |
| Forest South Grove | 3.33 |
| Forest West Grove | 2.95 |
| Lake Boating Center | 3.70 |
| Large Event Area | 4.63 |
| Main Dam | 3.83 |
| Main Pool | 3.31 |
| Marshall Park | 5.18 |
| Model Airplane Field | 3.70 |
| Ned Brown Meadow | 3.86 |
| North Pool | 4.03 |
| Salt Creek Trail | 4.24 |
| South Pool | 3.90 |
| Wildlife Refuge | 4.70 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,4.36
Busse Lake,3.29
Debra Park,4.25
Forest Central Grove,4.95
Forest North Grove,3.19
Forest South Grove,3.33
Forest West Grove,2.95
Lake Boating Center,3.70
Large Event Area,4.63
Main Dam,3.83
Main Pool,3.31
Marshall Park,5.18
Model Airplane Field,3.70
Ned Brown Meadow,3.86
North Pool,4.03
Salt Creek Trail,4.24
South Pool,3.90
Wildlife Refuge,4.70
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.81366372 0.00810000 NUM8690_b8be
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 3.87 |
| Beisner Road Entrance | 3.76 |
| Busse Lake | 4.57 |
| Elk Pasture | 4.11 |
| Forest Central Grove | 3.46 |
| Forest North Grove | 4.09 |
| Forest West Grove | 3.58 |
| Main Dam | 3.62 |
| Nature Preserve | 3.67 |
| North Pool | 3.72 |
| Osborn Park | 4.35 |
| Salt Creek Trail | 4.45 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,3.87
Beisner Road Entrance,3.76
Busse Lake,4.57
Elk Pasture,4.11
Forest Central Grove,3.46
Forest North Grove,4.09
Forest West Grove,3.58
Main Dam,3.62
Nature Preserve,3.67
North Pool,3.72
Osborn Park,4.35
Salt Creek Trail,4.45
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.71821613 0.00720000 NUM61af_92a4
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Beisner Road Entrance | 3.77 |
| Boat Launch Area | 3.20 |
| Elk Pasture | 3.58 |
| Forest Central Grove | 4.83 |
| Forest North Grove | 3.76 |
| Forest South Grove | 4.34 |
| Forest West Grove | 5.15 |
| Large Event Area | 3.36 |
| Main Dam | 3.71 |
| Main Pool | 3.88 |
| Model Airplane Field | 3.43 |
| Nature Preserve | 3.60 |
| Ned Brown Meadow | 4.40 |
| Osborn Park | 3.84 |
| Salt Creek Trail | 5.03 |
| South Pool | 3.06 |
| Wildlife Refuge | 3.34 |
| Woodland Meadow | 3.63 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Beisner Road Entrance,3.77
Boat Launch Area,3.20
Elk Pasture,3.58
Forest Central Grove,4.83
Forest North Grove,3.76
Forest South Grove,4.34
Forest West Grove,5.15
Large Event Area,3.36
Main Dam,3.71
Main Pool,3.88
Model Airplane Field,3.43
Nature Preserve,3.60
Ned Brown Meadow,4.40
Osborn Park,3.84
Salt Creek Trail,5.03
South Pool,3.06
Wildlife Refuge,3.34
Woodland Meadow,3.63
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.41162944 0.00410000 NUM3b99_b4da
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 3.92 |
| Beisner Road Entrance | 3.23 |
| Busse Lake | 4.86 |
| Forest Central Grove | 4.08 |
| Forest North Grove | 3.93 |
| Forest South Grove | 4.50 |
| Forest West Grove | 3.81 |
| Lake Boating Center | 3.82 |
| Large Event Area | 3.71 |
| Main Pool | 4.14 |
| Nature Preserve | 4.43 |
| North Pool | 4.77 |
| Wildlife Refuge | 3.99 |
| Woodland Meadow | 3.87 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,3.92
Beisner Road Entrance,3.23
Busse Lake,4.86
Forest Central Grove,4.08
Forest North Grove,3.93
Forest South Grove,4.50
Forest West Grove,3.81
Lake Boating Center,3.82
Large Event Area,3.71
Main Pool,4.14
Nature Preserve,4.43
North Pool,4.77
Wildlife Refuge,3.99
Woodland Meadow,3.87
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.63681150 0.00640000 NUM13b0_cc4e
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 3.81 |
| Beisner Road Entrance | 3.55 |
| Boat Launch Area | 4.39 |
| Busse Lake | 4.21 |
| Elk Pasture | 2.39 |
| Forest Central Grove | 3.71 |
| Forest North Grove | 4.34 |
| Forest South Grove | 4.22 |
| Forest West Grove | 2.39 |
| Lake Boating Center | 4.06 |
| Main Pool | 4.16 |
| Marshall Park | 5.23 |
| Model Airplane Field | 3.63 |
| Nature Preserve | 4.24 |
| North Pool | 4.20 |
| Osborn Park | 4.27 |
| Salt Creek Trail | 3.44 |
| South Pool | 3.59 |
| Wildlife Refuge | 3.47 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,3.81
Beisner Road Entrance,3.55
Boat Launch Area,4.39
Busse Lake,4.21
Elk Pasture,2.39
Forest Central Grove,3.71
Forest North Grove,4.34
Forest South Grove,4.22
Forest West Grove,2.39
Lake Boating Center,4.06
Main Pool,4.16
Marshall Park,5.23
Model Airplane Field,3.63
Nature Preserve,4.24
North Pool,4.20
Osborn Park,4.27
Salt Creek Trail,3.44
South Pool,3.59
Wildlife Refuge,3.47
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.30189844 0.00300000 NUM15e2_eac3
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 4.05 |
| Debra Park | 3.88 |
| Forest Central Grove | 3.37 |
| Forest North Grove | 3.82 |
| Forest South Grove | 3.00 |
| Large Event Area | 4.62 |
| Main Pool | 4.43 |
| Marshall Park | 4.02 |
| North Pool | 4.91 |
| Salt Creek Trail | 3.63 |
| Wildlife Refuge | 3.99 |
| Woodland Meadow | 3.94 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,4.05
Debra Park,3.88
Forest Central Grove,3.37
Forest North Grove,3.82
Forest South Grove,3.00
Large Event Area,4.62
Main Pool,4.43
Marshall Park,4.02
North Pool,4.91
Salt Creek Trail,3.63
Wildlife Refuge,3.99
Woodland Meadow,3.94
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.87005976 0.00870000 NUMed24_74c8
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 4.95 |
| Beisner Road Entrance | 4.02 |
| Boat Launch Area | 4.76 |
| Busse Lake | 3.51 |
| Debra Park | 3.12 |
| Elk Pasture | 3.46 |
| Forest Central Grove | 4.03 |
| Forest North Grove | 4.17 |
| Forest South Grove | 4.16 |
| Lake Boating Center | 3.57 |
| Main Pool | 5.00 |
| Ned Brown Meadow | 4.30 |
| Salt Creek Trail | 2.99 |
| South Pool | 3.44 |
| Wildlife Refuge | 3.25 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,4.95
Beisner Road Entrance,4.02
Boat Launch Area,4.76
Busse Lake,3.51
Debra Park,3.12
Elk Pasture,3.46
Forest Central Grove,4.03
Forest North Grove,4.17
Forest South Grove,4.16
Lake Boating Center,3.57
Main Pool,5.00
Ned Brown Meadow,4.30
Salt Creek Trail,2.99
South Pool,3.44
Wildlife Refuge,3.25
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.58470787 0.00580000 NUM5aed_b4f6
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 4.17 |
| Beisner Road Entrance | 3.88 |
| Debra Park | 3.36 |
| Forest South Grove | 3.64 |
| Forest West Grove | 4.02 |
| Large Event Area | 4.20 |
| Main Dam | 5.14 |
| Main Pool | 3.72 |
| Marshall Park | 4.00 |
| Model Airplane Field | 3.97 |
| Nature Preserve | 4.04 |
| Osborn Park | 3.14 |
| Salt Creek Trail | 3.49 |
| South Pool | 3.96 |
| Woodland Meadow | 4.79 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,4.17
Beisner Road Entrance,3.88
Debra Park,3.36
Forest South Grove,3.64
Forest West Grove,4.02
Large Event Area,4.20
Main Dam,5.14
Main Pool,3.72
Marshall Park,4.00
Model Airplane Field,3.97
Nature Preserve,4.04
Osborn Park,3.14
Salt Creek Trail,3.49
South Pool,3.96
Woodland Meadow,4.79
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.83635420 0.00840000 NUMedc0_0d24
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Beisner Road Entrance | 4.57 |
| Boat Launch Area | 4.21 |
| Busse Lake | 4.25 |
| Debra Park | 5.41 |
| Elk Pasture | 3.46 |
| Forest Central Grove | 4.03 |
| Forest North Grove | 4.43 |
| Forest South Grove | 4.89 |
| Forest West Grove | 3.14 |
| Main Pool | 3.67 |
| Marshall Park | 3.91 |
| Model Airplane Field | 3.46 |
| Nature Preserve | 3.53 |
| North Pool | 4.01 |
| Salt Creek Trail | 3.49 |
| South Pool | 4.96 |
| Woodland Meadow | 2.89 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Beisner Road Entrance,4.57
Boat Launch Area,4.21
Busse Lake,4.25
Debra Park,5.41
Elk Pasture,3.46
Forest Central Grove,4.03
Forest North Grove,4.43
Forest South Grove,4.89
Forest West Grove,3.14
Main Pool,3.67
Marshall Park,3.91
Model Airplane Field,3.46
Nature Preserve,3.53
North Pool,4.01
Salt Creek Trail,3.49
South Pool,4.96
Woodland Meadow,2.89
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.90027808 0.00900000 NUMbb8f_e23c
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 4.76 |
| Boat Launch Area | 3.86 |
| Busse Lake | 4.16 |
| Debra Park | 3.94 |
| Elk Pasture | 2.95 |
| Forest Central Grove | 3.60 |
| Forest West Grove | 4.09 |
| Lake Boating Center | 3.19 |
| Main Dam | 3.65 |
| Main Pool | 5.01 |
| Marshall Park | 2.58 |
| Nature Preserve | 3.92 |
| Ned Brown Meadow | 3.92 |
| Osborn Park | 4.10 |
| South Pool | 3.77 |
| Wildlife Refuge | 5.26 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,4.76
Boat Launch Area,3.86
Busse Lake,4.16
Debra Park,3.94
Elk Pasture,2.95
Forest Central Grove,3.60
Forest West Grove,4.09
Lake Boating Center,3.19
Main Dam,3.65
Main Pool,5.01
Marshall Park,2.58
Nature Preserve,3.92
Ned Brown Meadow,3.92
Osborn Park,4.10
South Pool,3.77
Wildlife Refuge,5.26
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.60538887 0.00610000 NUM1daf_dd44
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Boat Launch Area | 4.81 |
| Busse Lake | 3.36 |
| Debra Park | 2.88 |
| Elk Pasture | 3.58 |
| Forest North Grove | 4.51 |
| Forest South Grove | 4.07 |
| Forest West Grove | 4.32 |
| Lake Boating Center | 3.94 |
| Large Event Area | 4.23 |
| Model Airplane Field | 4.03 |
| Ned Brown Meadow | 4.11 |
| Osborn Park | 3.78 |
| Woodland Meadow | 4.20 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Boat Launch Area,4.81
Busse Lake,3.36
Debra Park,2.88
Elk Pasture,3.58
Forest North Grove,4.51
Forest South Grove,4.07
Forest West Grove,4.32
Lake Boating Center,3.94
Large Event Area,4.23
Model Airplane Field,4.03
Ned Brown Meadow,4.11
Osborn Park,3.78
Woodland Meadow,4.20
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.93368851 0.00930000 NUMf0e6_afd1
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 4.67 |
| Beisner Road Entrance | 3.19 |
| Boat Launch Area | 4.59 |
| Busse Lake | 3.19 |
| Debra Park | 4.71 |
| Elk Pasture | 3.65 |
| Forest South Grove | 4.16 |
| Forest West Grove | 3.49 |
| Lake Boating Center | 4.08 |
| Large Event Area | 3.93 |
| Marshall Park | 3.91 |
| Model Airplane Field | 3.40 |
| Nature Preserve | 4.08 |
| Ned Brown Meadow | 3.52 |
| North Pool | 4.51 |
| Osborn Park | 3.61 |
| Salt Creek Trail | 4.13 |
| South Pool | 5.33 |
| Wildlife Refuge | 5.76 |
| Woodland Meadow | 4.07 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,4.67
Beisner Road Entrance,3.19
Boat Launch Area,4.59
Busse Lake,3.19
Debra Park,4.71
Elk Pasture,3.65
Forest South Grove,4.16
Forest West Grove,3.49
Lake Boating Center,4.08
Large Event Area,3.93
Marshall Park,3.91
Model Airplane Field,3.40
Nature Preserve,4.08
Ned Brown Meadow,3.52
North Pool,4.51
Osborn Park,3.61
Salt Creek Trail,4.13
South Pool,5.33
Wildlife Refuge,5.76
Woodland Meadow,4.07
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.46057374 0.00460000 NUMacb6_29bf
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 3.45 |
| Busse Lake | 4.60 |
| Elk Pasture | 4.37 |
| Forest Central Grove | 4.66 |
| Forest South Grove | 5.22 |
| Forest West Grove | 4.49 |
| Large Event Area | 3.78 |
| Nature Preserve | 3.79 |
| Ned Brown Meadow | 3.23 |
| North Pool | 3.32 |
| Osborn Park | 2.13 |
| Salt Creek Trail | 3.43 |
| South Pool | 3.61 |
| Woodland Meadow | 3.73 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,3.45
Busse Lake,4.60
Elk Pasture,4.37
Forest Central Grove,4.66
Forest South Grove,5.22
Forest West Grove,4.49
Large Event Area,3.78
Nature Preserve,3.79
Ned Brown Meadow,3.23
North Pool,3.32
Osborn Park,2.13
Salt Creek Trail,3.43
South Pool,3.61
Woodland Meadow,3.73
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.32931055 0.00330000 NUMc2aa_e9f1
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Boat Launch Area | 3.93 |
| Debra Park | 3.92 |
| Elk Pasture | 3.25 |
| Forest Central Grove | 4.43 |
| Forest North Grove | 4.45 |
| Forest South Grove | 3.66 |
| Lake Boating Center | 3.29 |
| Large Event Area | 4.45 |
| Main Dam | 4.02 |
| Main Pool | 4.02 |
| Marshall Park | 4.16 |
| Nature Preserve | 4.13 |
| Ned Brown Meadow | 4.11 |
| North Pool | 4.09 |
| Osborn Park | 3.88 |
| Salt Creek Trail | 4.07 |
| South Pool | 4.74 |
| Wildlife Refuge | 4.53 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Boat Launch Area,3.93
Debra Park,3.92
Elk Pasture,3.25
Forest Central Grove,4.43
Forest North Grove,4.45
Forest South Grove,3.66
Lake Boating Center,3.29
Large Event Area,4.45
Main Dam,4.02
Main Pool,4.02
Marshall Park,4.16
Nature Preserve,4.13
Ned Brown Meadow,4.11
North Pool,4.09
Osborn Park,3.88
Salt Creek Trail,4.07
South Pool,4.74
Wildlife Refuge,4.53
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.65711060 0.00660000 NUM6723_b178
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Beisner Road Entrance | 3.73 |
| Boat Launch Area | 3.62 |
| Busse Lake | 3.79 |
| Debra Park | 4.49 |
| Elk Pasture | 3.38 |
| Forest Central Grove | 4.56 |
| Forest North Grove | 4.84 |
| Forest South Grove | 3.90 |
| Forest West Grove | 5.07 |
| Large Event Area | 4.79 |
| Main Dam | 3.61 |
| Model Airplane Field | 5.18 |
| Nature Preserve | 3.92 |
| North Pool | 3.21 |
| Osborn Park | 5.06 |
| Salt Creek Trail | 3.60 |
| Woodland Meadow | 3.91 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Beisner Road Entrance,3.73
Boat Launch Area,3.62
Busse Lake,3.79
Debra Park,4.49
Elk Pasture,3.38
Forest Central Grove,4.56
Forest North Grove,4.84
Forest South Grove,3.90
Forest West Grove,5.07
Large Event Area,4.79
Main Dam,3.61
Model Airplane Field,5.18
Nature Preserve,3.92
North Pool,3.21
Osborn Park,5.06
Salt Creek Trail,3.60
Woodland Meadow,3.91
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.28226672 0.00280000 NUM5ffb_4926
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 3.30 |
| Debra Park | 3.53 |
| Forest West Grove | 4.59 |
| Large Event Area | 3.66 |
| Main Dam | 3.98 |
| Marshall Park | 4.54 |
| Model Airplane Field | 3.58 |
| Ned Brown Meadow | 3.57 |
| North Pool | 4.41 |
| Salt Creek Trail | 4.57 |
| South Pool | 3.70 |
| Wildlife Refuge | 4.12 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,3.30
Debra Park,3.53
Forest West Grove,4.59
Large Event Area,3.66
Main Dam,3.98
Marshall Park,4.54
Model Airplane Field,3.58
Ned Brown Meadow,3.57
North Pool,4.41
Salt Creek Trail,4.57
South Pool,3.70
Wildlife Refuge,4.12
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.82859308 0.00830000 NUMc3ac_a904
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Beisner Road Entrance | 4.53 |
| Boat Launch Area | 3.41 |
| Busse Lake | 3.28 |
| Forest Central Grove | 3.25 |
| Forest North Grove | 3.99 |
| Forest South Grove | 5.00 |
| Forest West Grove | 4.13 |
| Lake Boating Center | 3.51 |
| Large Event Area | 4.30 |
| Main Dam | 3.65 |
| Main Pool | 3.34 |
| Marshall Park | 4.56 |
| Model Airplane Field | 4.00 |
| Nature Preserve | 3.90 |
| Ned Brown Meadow | 3.29 |
| Osborn Park | 4.46 |
| South Pool | 3.18 |
| Wildlife Refuge | 4.93 |
| Woodland Meadow | 5.70 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Beisner Road Entrance,4.53
Boat Launch Area,3.41
Busse Lake,3.28
Forest Central Grove,3.25
Forest North Grove,3.99
Forest South Grove,5.00
Forest West Grove,4.13
Lake Boating Center,3.51
Large Event Area,4.30
Main Dam,3.65
Main Pool,3.34
Marshall Park,4.56
Model Airplane Field,4.00
Nature Preserve,3.90
Ned Brown Meadow,3.29
Osborn Park,4.46
South Pool,3.18
Wildlife Refuge,4.93
Woodland Meadow,5.70
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.87542815 0.00880000 NUM5881_9d8d
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 4.06 |
| Boat Launch Area | 3.86 |
| Busse Lake | 4.19 |
| Debra Park | 2.33 |
| Forest Central Grove | 3.80 |
| Forest North Grove | 4.28 |
| Forest West Grove | 4.26 |
| Lake Boating Center | 3.46 |
| Main Dam | 3.55 |
| Marshall Park | 3.97 |
| Model Airplane Field | 3.21 |
| Nature Preserve | 4.56 |
| Ned Brown Meadow | 3.59 |
| North Pool | 3.93 |
| Osborn Park | 4.54 |
| Salt Creek Trail | 3.72 |
| Wildlife Refuge | 3.45 |
| Woodland Meadow | 2.76 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,4.06
Boat Launch Area,3.86
Busse Lake,4.19
Debra Park,2.33
Forest Central Grove,3.80
Forest North Grove,4.28
Forest West Grove,4.26
Lake Boating Center,3.46
Main Dam,3.55
Marshall Park,3.97
Model Airplane Field,3.21
Nature Preserve,4.56
Ned Brown Meadow,3.59
North Pool,3.93
Osborn Park,4.54
Salt Creek Trail,3.72
Wildlife Refuge,3.45
Woodland Meadow,2.76
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.07842303 0.00100000 NUM2ede_97c4
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Boat Launch Area | 3.76 |
| Busse Lake | 4.72 |
| Forest Central Grove | 5.04 |
| Forest North Grove | 3.97 |
| Lake Boating Center | 4.52 |
| Main Dam | 4.14 |
| Main Pool | 4.63 |
| Model Airplane Field | 2.85 |
| Nature Preserve | 3.84 |
| Ned Brown Meadow | 4.30 |
| North Pool | 5.38 |
| Osborn Park | 3.02 |
| Salt Creek Trail | 4.83 |
| South Pool | 4.01 |
| Wildlife Refuge | 3.11 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Boat Launch Area,3.76
Busse Lake,4.72
Forest Central Grove,5.04
Forest North Grove,3.97
Lake Boating Center,4.52
Main Dam,4.14
Main Pool,4.63
Model Airplane Field,2.85
Nature Preserve,3.84
Ned Brown Meadow,4.30
North Pool,5.38
Osborn Park,3.02
Salt Creek Trail,4.83
South Pool,4.01
Wildlife Refuge,3.11
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.36160937 0.00360000 NUM8990_686e
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Beisner Road Entrance | 3.57 |
| Boat Launch Area | 2.71 |
| Debra Park | 3.88 |
| Elk Pasture | 3.49 |
| Forest Central Grove | 3.95 |
| Forest North Grove | 4.61 |
| Forest South Grove | 4.63 |
| Forest West Grove | 4.45 |
| Lake Boating Center | 2.65 |
| Large Event Area | 4.26 |
| Model Airplane Field | 4.70 |
| Osborn Park | 2.84 |
| Salt Creek Trail | 4.15 |
| Wildlife Refuge | 3.67 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Beisner Road Entrance,3.57
Boat Launch Area,2.71
Debra Park,3.88
Elk Pasture,3.49
Forest Central Grove,3.95
Forest North Grove,4.61
Forest South Grove,4.63
Forest West Grove,4.45
Lake Boating Center,2.65
Large Event Area,4.26
Model Airplane Field,4.70
Osborn Park,2.84
Salt Creek Trail,4.15
Wildlife Refuge,3.67
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.27709763 0.00280000 NUMa85f_b166
Busse Woods Microbial Diversity vs Benchmark
Z-Test Scenario
Use a Z test. Population sd is known.
Fixed values: mu = 4.00, sigma = 0.60.
Alternative H1: diversity is different from the benchmark.
Use a two tailed test.
Sample Data Table:
Copy the table rows and use regular paste (Ctrl-V or ⌘-V) into Google Sheets.
| Sample Location | 2024 Shannon Index |
|---|---|
| Andrews Park | 4.00 |
| Beisner Road Entrance | 5.00 |
| Busse Lake | 4.52 |
| Elk Pasture | 4.06 |
| Forest North Grove | 3.54 |
| Lake Boating Center | 4.77 |
| Large Event Area | 4.36 |
| Main Dam | 5.44 |
| Marshall Park | 4.11 |
| Model Airplane Field | 3.75 |
| Ned Brown Meadow | 3.38 |
| South Pool | 4.13 |
| Wildlife Refuge | 3.40 |
| Woodland Meadow | 3.62 |
Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.
Sample Location 2024 Shannon Index
Andrews Park,4.00
Beisner Road Entrance,5.00
Busse Lake,4.52
Elk Pasture,4.06
Forest North Grove,3.54
Lake Boating Center,4.77
Large Event Area,4.36
Main Dam,5.44
Marshall Park,4.11
Model Airplane Field,3.75
Ned Brown Meadow,3.38
South Pool,4.13
Wildlife Refuge,3.40
Woodland Meadow,3.62
Follow the workflow in the tutorial: link here.
Enter the p value as a decimal between 0 and 1.
0.35418327 0.00350000