NUM

be96_a79c

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 Park4.85
Busse Lake4.94
Debra Park3.51
Elk Pasture3.44
Forest Central Grove3.82
Forest South Grove3.94
Lake Boating Center4.19
Large Event Area3.82
Main Pool4.43
Marshall Park3.74
Nature Preserve5.00
Wildlife Refuge3.72
Woodland Meadow3.72

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.85
Busse Lake,4.94
Debra Park,3.51
Elk Pasture,3.44
Forest Central Grove,3.82
Forest South Grove,3.94
Lake Boating Center,4.19
Large Event Area,3.82
Main Pool,4.43
Marshall Park,3.74
Nature Preserve,5.00
Wildlife Refuge,3.72
Woodland Meadow,3.72

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.60465351 0.00600000 NUM

e95d_bb94

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 Park3.11
Beisner Road Entrance4.07
Boat Launch Area3.87
Busse Lake3.03
Debra Park4.01
Elk Pasture4.54
Forest West Grove3.67
Lake Boating Center4.51
Large Event Area3.48
Marshall Park3.18
Model Airplane Field3.38
Nature Preserve4.16
North Pool5.15
Osborn Park3.13
Woodland Meadow4.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,3.11
Beisner Road Entrance,4.07
Boat Launch Area,3.87
Busse Lake,3.03
Debra Park,4.01
Elk Pasture,4.54
Forest West Grove,3.67
Lake Boating Center,4.51
Large Event Area,3.48
Marshall Park,3.18
Model Airplane Field,3.38
Nature Preserve,4.16
North Pool,5.15
Osborn Park,3.13
Woodland Meadow,4.11

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.26319908 0.00260000 NUM

0721_3a75

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 Park4.49
Beisner Road Entrance3.45
Boat Launch Area4.14
Busse Lake4.35
Debra Park4.51
Elk Pasture4.72
Forest North Grove3.86
Lake Boating Center4.99
Large Event Area3.76
Main Dam4.43
Marshall Park4.87
Model Airplane Field3.81
Nature Preserve5.08
Salt Creek Trail3.37
South Pool3.92
Woodland Meadow4.28

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.49
Beisner Road Entrance,3.45
Boat Launch Area,4.14
Busse Lake,4.35
Debra Park,4.51
Elk Pasture,4.72
Forest North Grove,3.86
Lake Boating Center,4.99
Large Event Area,3.76
Main Dam,4.43
Marshall Park,4.87
Model Airplane Field,3.81
Nature Preserve,5.08
Salt Creek Trail,3.37
South Pool,3.92
Woodland Meadow,4.28

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.09311957 0.00100000 NUM

2cbe_ee87

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 Entrance3.81
Boat Launch Area3.90
Debra Park3.98
Elk Pasture4.21
Forest Central Grove4.29
Forest South Grove4.50
Lake Boating Center4.10
Main Dam4.20
Model Airplane Field4.68
Nature Preserve3.63
Ned Brown Meadow3.71
North Pool3.38
South Pool3.90
Woodland Meadow4.38

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.81
Boat Launch Area,3.90
Debra Park,3.98
Elk Pasture,4.21
Forest Central Grove,4.29
Forest South Grove,4.50
Lake Boating Center,4.10
Main Dam,4.20
Model Airplane Field,4.68
Nature Preserve,3.63
Ned Brown Meadow,3.71
North Pool,3.38
South Pool,3.90
Woodland Meadow,4.38

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.76536605 0.00770000 NUM

dea9_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
Andrews Park4.05
Boat Launch Area3.74
Elk Pasture3.34
Forest Central Grove3.91
Lake Boating Center4.68
Large Event Area4.00
Main Dam4.08
Main Pool4.26
Model Airplane Field3.93
North Pool4.21
Osborn Park3.83
Salt Creek Trail3.67
South Pool4.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,4.05
Boat Launch Area,3.74
Elk Pasture,3.34
Forest Central Grove,3.91
Lake Boating Center,4.68
Large Event Area,4.00
Main Dam,4.08
Main Pool,4.26
Model Airplane Field,3.93
North Pool,4.21
Osborn Park,3.83
Salt Creek Trail,3.67
South Pool,4.12

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.93368851 0.00930000 NUM

76a1_23e7

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 Park4.07
Debra Park3.17
Elk Pasture4.25
Forest Central Grove3.23
Forest North Grove4.76
Forest South Grove3.95
Lake Boating Center4.29
Large Event Area4.69
Main Pool4.23
Marshall Park3.79
Model Airplane Field4.24
Nature Preserve4.44
Osborn Park3.80
Salt Creek Trail4.28
Woodland Meadow4.19

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.07
Debra Park,3.17
Elk Pasture,4.25
Forest Central Grove,3.23
Forest North Grove,4.76
Forest South Grove,3.95
Lake Boating Center,4.29
Large Event Area,4.69
Main Pool,4.23
Marshall Park,3.79
Model Airplane Field,4.24
Nature Preserve,4.44
Osborn Park,3.80
Salt Creek Trail,4.28
Woodland Meadow,4.19

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.55260746 0.00550000 NUM

a22c_8214

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 Park3.78
Beisner Road Entrance4.39
Boat Launch Area4.18
Busse Lake4.38
Debra Park5.48
Elk Pasture3.47
Forest Central Grove4.12
Forest North Grove3.68
Large Event Area3.71
Main Pool2.99
Marshall Park4.45
Model Airplane Field2.09
Nature Preserve4.04
Osborn Park2.90
Salt Creek Trail4.59

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.78
Beisner Road Entrance,4.39
Boat Launch Area,4.18
Busse Lake,4.38
Debra Park,5.48
Elk Pasture,3.47
Forest Central Grove,4.12
Forest North Grove,3.68
Large Event Area,3.71
Main Pool,2.99
Marshall Park,4.45
Model Airplane Field,2.09
Nature Preserve,4.04
Osborn Park,2.90
Salt Creek Trail,4.59

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.45140178 0.00450000 NUM

b7d5_9c18

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 Entrance3.43
Busse Lake4.35
Debra Park4.54
Forest Central Grove4.34
Forest North Grove4.46
Forest South Grove4.44
Lake Boating Center4.03
Large Event Area4.30
Main Dam4.71
Marshall Park5.03
Model Airplane Field4.21
Nature Preserve4.00
North Pool4.70
Osborn Park3.71
Salt Creek Trail3.36
Wildlife Refuge4.39

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.43
Busse Lake,4.35
Debra Park,4.54
Forest Central Grove,4.34
Forest North Grove,4.46
Forest South Grove,4.44
Lake Boating Center,4.03
Large Event Area,4.30
Main Dam,4.71
Marshall Park,5.03
Model Airplane Field,4.21
Nature Preserve,4.00
North Pool,4.70
Osborn Park,3.71
Salt Creek Trail,3.36
Wildlife Refuge,4.39

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.09558070 0.00100000 NUM

8a08_b627

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 Entrance3.39
Busse Lake4.39
Forest Central Grove4.87
Forest North Grove4.44
Forest South Grove3.83
Forest West Grove3.27
Lake Boating Center4.01
Marshall Park4.17
Model Airplane Field4.15
Nature Preserve4.29
North Pool3.61
Salt Creek Trail4.88
South Pool4.14
Wildlife Refuge5.11
Woodland Meadow2.78

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.39
Busse Lake,4.39
Forest Central Grove,4.87
Forest North Grove,4.44
Forest South Grove,3.83
Forest West Grove,3.27
Lake Boating Center,4.01
Marshall Park,4.17
Model Airplane Field,4.15
Nature Preserve,4.29
North Pool,3.61
Salt Creek Trail,4.88
South Pool,4.14
Wildlife Refuge,5.11
Woodland Meadow,2.78

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.56709106 0.00570000 NUM

e8bb_04ce

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 Park3.34
Beisner Road Entrance4.83
Busse Lake3.69
Debra Park4.45
Elk Pasture4.04
Forest Central Grove3.94
Forest West Grove4.22
Large Event Area3.64
Main Pool4.69
Model Airplane Field4.65
North Pool4.34
Salt Creek Trail3.65
South Pool3.81
Wildlife Refuge4.85
Woodland Meadow3.14

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
Beisner Road Entrance,4.83
Busse Lake,3.69
Debra Park,4.45
Elk Pasture,4.04
Forest Central Grove,3.94
Forest West Grove,4.22
Large Event Area,3.64
Main Pool,4.69
Model Airplane Field,4.65
North Pool,4.34
Salt Creek Trail,3.65
South Pool,3.81
Wildlife Refuge,4.85
Woodland Meadow,3.14

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.58175413 0.00580000 NUM

3460_50c8

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 Park4.67
Beisner Road Entrance2.64
Boat Launch Area3.71
Busse Lake4.71
Elk Pasture3.46
Forest Central Grove3.20
Forest North Grove4.42
Forest South Grove4.45
Forest West Grove3.92
Lake Boating Center4.97
Large Event Area3.74
Main Pool4.23
Marshall Park4.85
Model Airplane Field4.10
Nature Preserve3.61
Ned Brown Meadow3.04
Osborn Park4.05
South Pool2.82
Wildlife Refuge2.66
Woodland Meadow3.81

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,2.64
Boat Launch Area,3.71
Busse Lake,4.71
Elk Pasture,3.46
Forest Central Grove,3.20
Forest North Grove,4.42
Forest South Grove,4.45
Forest West Grove,3.92
Lake Boating Center,4.97
Large Event Area,3.74
Main Pool,4.23
Marshall Park,4.85
Model Airplane Field,4.10
Nature Preserve,3.61
Ned Brown Meadow,3.04
Osborn Park,4.05
South Pool,2.82
Wildlife Refuge,2.66
Woodland Meadow,3.81

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.27322177 0.00270000 NUM

5bec_a5bd

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 Area3.77
Busse Lake4.61
Debra Park4.10
Elk Pasture3.78
Forest North Grove5.28
Forest West Grove3.69
Lake Boating Center3.12
Nature Preserve3.80
Ned Brown Meadow3.17
North Pool2.97
Osborn Park4.59
Salt Creek Trail4.13
South Pool4.29

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.77
Busse Lake,4.61
Debra Park,4.10
Elk Pasture,3.78
Forest North Grove,5.28
Forest West Grove,3.69
Lake Boating Center,3.12
Nature Preserve,3.80
Ned Brown Meadow,3.17
North Pool,2.97
Osborn Park,4.59
Salt Creek Trail,4.13
South Pool,4.29

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.74625973 0.00750000 NUM

c9bc_7a0d

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 Park3.96
Beisner Road Entrance4.12
Boat Launch Area5.22
Busse Lake4.26
Forest West Grove4.18
Lake Boating Center4.40
Large Event Area3.85
Main Dam4.38
Main Pool3.98
Marshall Park3.88
Nature Preserve4.02
Ned Brown Meadow4.24
South Pool4.71
Woodland Meadow4.15

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.96
Beisner Road Entrance,4.12
Boat Launch Area,5.22
Busse Lake,4.26
Forest West Grove,4.18
Lake Boating Center,4.40
Large Event Area,3.85
Main Dam,4.38
Main Pool,3.98
Marshall Park,3.88
Nature Preserve,4.02
Ned Brown Meadow,4.24
South Pool,4.71
Woodland Meadow,4.15

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.13564447 0.00140000 NUM

10fb_50c8

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 Park3.89
Beisner Road Entrance4.58
Boat Launch Area4.87
Busse Lake3.88
Debra Park5.07
Forest Central Grove3.82
Large Event Area4.60
Main Dam4.05
Marshall Park3.56
Model Airplane Field4.23
Ned Brown Meadow2.95
Osborn Park4.24
Salt Creek Trail4.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,3.89
Beisner Road Entrance,4.58
Boat Launch Area,4.87
Busse Lake,3.88
Debra Park,5.07
Forest Central Grove,3.82
Large Event Area,4.60
Main Dam,4.05
Marshall Park,3.56
Model Airplane Field,4.23
Ned Brown Meadow,2.95
Osborn Park,4.24
Salt Creek Trail,4.63

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.27328325 0.00270000 NUM

8192_81a3

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 Park2.83
Beisner Road Entrance3.87
Busse Lake4.49
Debra Park3.67
Forest Central Grove4.00
Forest North Grove4.32
Forest South Grove3.62
Main Dam4.13
Nature Preserve4.11
Ned Brown Meadow3.63
Osborn Park3.44
Wildlife Refuge3.01

Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.

Sample Location 2024 Shannon Index
Andrews Park,2.83
Beisner Road Entrance,3.87
Busse Lake,4.49
Debra Park,3.67
Forest Central Grove,4.00
Forest North Grove,4.32
Forest South Grove,3.62
Main Dam,4.13
Nature Preserve,4.11
Ned Brown Meadow,3.63
Osborn Park,3.44
Wildlife Refuge,3.01

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.16585666 0.00170000 NUM

eaef_66a9

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 Entrance4.14
Boat Launch Area3.16
Busse Lake3.32
Elk Pasture3.49
Forest Central Grove2.74
Forest North Grove4.30
Large Event Area4.35
Main Dam4.44
Ned Brown Meadow3.34
North Pool3.58
Osborn Park3.57
South Pool3.96
Wildlife Refuge3.37

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.14
Boat Launch Area,3.16
Busse Lake,3.32
Elk Pasture,3.49
Forest Central Grove,2.74
Forest North Grove,4.30
Large Event Area,4.35
Main Dam,4.44
Ned Brown Meadow,3.34
North Pool,3.58
Osborn Park,3.57
South Pool,3.96
Wildlife Refuge,3.37

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.05000272 0.00100000 NUM

4ed1_77d0

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 Entrance3.60
Boat Launch Area3.91
Busse Lake3.50
Debra Park3.19
Elk Pasture3.28
Forest Central Grove2.83
Forest South Grove4.02
Lake Boating Center5.15
Main Dam4.16
Main Pool5.38
Marshall Park4.15
Model Airplane Field4.51
Ned Brown Meadow4.27
North Pool4.69
Osborn Park3.53
Salt Creek Trail3.90
South Pool4.24
Wildlife Refuge3.49
Woodland Meadow3.64

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.60
Boat Launch Area,3.91
Busse Lake,3.50
Debra Park,3.19
Elk Pasture,3.28
Forest Central Grove,2.83
Forest South Grove,4.02
Lake Boating Center,5.15
Main Dam,4.16
Main Pool,5.38
Marshall Park,4.15
Model Airplane Field,4.51
Ned Brown Meadow,4.27
North Pool,4.69
Osborn Park,3.53
Salt Creek Trail,3.90
South Pool,4.24
Wildlife Refuge,3.49
Woodland Meadow,3.64

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.83045243 0.00830000 NUM

961c_69d4

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 Entrance3.70
Busse Lake3.57
Debra Park3.57
Forest South Grove3.76
Main Dam3.06
Main Pool4.17
Marshall Park2.21
Model Airplane Field4.10
Ned Brown Meadow3.27
North Pool2.69
Osborn Park3.26
Salt Creek Trail4.28
South Pool5.32
Wildlife Refuge4.81

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.70
Busse Lake,3.57
Debra Park,3.57
Forest South Grove,3.76
Main Dam,3.06
Main Pool,4.17
Marshall Park,2.21
Model Airplane Field,4.10
Ned Brown Meadow,3.27
North Pool,2.69
Osborn Park,3.26
Salt Creek Trail,4.28
South Pool,5.32
Wildlife Refuge,4.81

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.05953904 0.00100000 NUM

ff70_c3c2

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 Park4.36
Beisner Road Entrance3.64
Boat Launch Area2.94
Busse Lake4.33
Debra Park3.12
Forest Central Grove3.52
Forest North Grove3.83
Forest South Grove4.15
Forest West Grove4.55
Lake Boating Center3.44
Large Event Area3.58
Main Dam3.77
Main Pool2.52
Nature Preserve3.81
Ned Brown Meadow4.99
North Pool3.59
Osborn Park3.35
South Pool4.49
Wildlife Refuge4.58
Woodland Meadow5.60

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
Beisner Road Entrance,3.64
Boat Launch Area,2.94
Busse Lake,4.33
Debra Park,3.12
Forest Central Grove,3.52
Forest North Grove,3.83
Forest South Grove,4.15
Forest West Grove,4.55
Lake Boating Center,3.44
Large Event Area,3.58
Main Dam,3.77
Main Pool,2.52
Nature Preserve,3.81
Ned Brown Meadow,4.99
North Pool,3.59
Osborn Park,3.35
South Pool,4.49
Wildlife Refuge,4.58
Woodland Meadow,5.60

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.49288495 0.00490000 NUM

efa3_cd46

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 Park3.29
Boat Launch Area5.00
Busse Lake3.61
Debra Park5.00
Forest Central Grove4.19
Forest North Grove5.02
Forest South Grove3.60
Forest West Grove4.36
Large Event Area3.70
Main Dam3.55
Main Pool4.18
Marshall Park4.43
Model Airplane Field4.15
Nature Preserve2.30
North Pool4.15
Osborn Park3.68
Salt Creek Trail4.92
South Pool4.19
Wildlife Refuge4.15
Woodland Meadow4.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,3.29
Boat Launch Area,5.00
Busse Lake,3.61
Debra Park,5.00
Forest Central Grove,4.19
Forest North Grove,5.02
Forest South Grove,3.60
Forest West Grove,4.36
Large Event Area,3.70
Main Dam,3.55
Main Pool,4.18
Marshall Park,4.43
Model Airplane Field,4.15
Nature Preserve,2.30
North Pool,4.15
Osborn Park,3.68
Salt Creek Trail,4.92
South Pool,4.19
Wildlife Refuge,4.15
Woodland Meadow,4.07

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.56601915 0.00570000 NUM

a0c8_ea5c

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 Entrance4.12
Busse Lake4.18
Elk Pasture3.90
Forest Central Grove4.23
Forest North Grove3.82
Lake Boating Center4.82
Large Event Area3.56
Main Pool4.55
Ned Brown Meadow4.52
North Pool3.74
Osborn Park3.73
Salt Creek Trail3.92
Wildlife Refuge4.66
Woodland Meadow5.29

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.12
Busse Lake,4.18
Elk Pasture,3.90
Forest Central Grove,4.23
Forest North Grove,3.82
Lake Boating Center,4.82
Large Event Area,3.56
Main Pool,4.55
Ned Brown Meadow,4.52
North Pool,3.74
Osborn Park,3.73
Salt Creek Trail,3.92
Wildlife Refuge,4.66
Woodland Meadow,5.29

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.17569694 0.00180000 NUM

3357_5714

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 Entrance4.58
Boat Launch Area3.16
Forest Central Grove5.05
Main Dam3.70
Main Pool4.41
Model Airplane Field4.19
Nature Preserve5.12
Ned Brown Meadow4.71
North Pool4.16
Osborn Park3.07
Salt Creek Trail4.00
Wildlife Refuge3.94

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.58
Boat Launch Area,3.16
Forest Central Grove,5.05
Main Dam,3.70
Main Pool,4.41
Model Airplane Field,4.19
Nature Preserve,5.12
Ned Brown Meadow,4.71
North Pool,4.16
Osborn Park,3.07
Salt Creek Trail,4.00
Wildlife Refuge,3.94

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.31463126 0.00310000 NUM

91b8_09fd

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 Park3.67
Beisner Road Entrance4.16
Boat Launch Area3.98
Busse Lake4.21
Debra Park4.55
Elk Pasture4.17
Forest Central Grove4.38
Forest North Grove5.91
Forest South Grove4.08
Forest West Grove4.09
Lake Boating Center4.61
Large Event Area4.37
Main Dam3.66
Main Pool3.71
Nature Preserve4.09
Osborn Park4.13
Salt Creek Trail4.41
South Pool4.49
Wildlife Refuge3.60
Woodland Meadow3.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,3.67
Beisner Road Entrance,4.16
Boat Launch Area,3.98
Busse Lake,4.21
Debra Park,4.55
Elk Pasture,4.17
Forest Central Grove,4.38
Forest North Grove,5.91
Forest South Grove,4.08
Forest West Grove,4.09
Lake Boating Center,4.61
Large Event Area,4.37
Main Dam,3.66
Main Pool,3.71
Nature Preserve,4.09
Osborn Park,4.13
Salt Creek Trail,4.41
South Pool,4.49
Wildlife Refuge,3.60
Woodland Meadow,3.69

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.13999628 0.00140000 NUM

4894_7131

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 Park3.84
Beisner Road Entrance4.60
Boat Launch Area2.85
Busse Lake3.97
Debra Park5.10
Elk Pasture3.78
Forest Central Grove4.10
Forest North Grove3.57
Forest South Grove4.35
Forest West Grove4.68
Lake Boating Center4.86
Main Dam3.97
Main Pool3.99
Marshall Park3.33
Model Airplane Field4.99
Nature Preserve4.82
North Pool3.21
Osborn Park4.99
South Pool3.27
Woodland Meadow5.34

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.84
Beisner Road Entrance,4.60
Boat Launch Area,2.85
Busse Lake,3.97
Debra Park,5.10
Elk Pasture,3.78
Forest Central Grove,4.10
Forest North Grove,3.57
Forest South Grove,4.35
Forest West Grove,4.68
Lake Boating Center,4.86
Main Dam,3.97
Main Pool,3.99
Marshall Park,3.33
Model Airplane Field,4.99
Nature Preserve,4.82
North Pool,3.21
Osborn Park,4.99
South Pool,3.27
Woodland Meadow,5.34

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.17850656 0.00180000 NUM

a466_9fee

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 Entrance3.60
Boat Launch Area2.83
Debra Park3.39
Elk Pasture4.04
Forest Central Grove3.56
Forest North Grove3.86
Forest South Grove4.37
Forest West Grove4.25
Lake Boating Center3.68
Large Event Area3.76
Main Dam3.92
Main Pool4.07
Model Airplane Field3.06
North Pool4.08
Salt Creek Trail5.02
South Pool2.85
Wildlife Refuge3.61
Woodland Meadow3.77

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.60
Boat Launch Area,2.83
Debra Park,3.39
Elk Pasture,4.04
Forest Central Grove,3.56
Forest North Grove,3.86
Forest South Grove,4.37
Forest West Grove,4.25
Lake Boating Center,3.68
Large Event Area,3.76
Main Dam,3.92
Main Pool,4.07
Model Airplane Field,3.06
North Pool,4.08
Salt Creek Trail,5.02
South Pool,2.85
Wildlife Refuge,3.61
Woodland Meadow,3.77

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.09269635 0.00100000 NUM

7729_10ba

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 Park4.20
Elk Pasture3.32
Forest North Grove3.71
Large Event Area2.35
Main Pool3.80
Marshall Park4.12
Nature Preserve4.77
Ned Brown Meadow5.53
North Pool4.66
Osborn Park3.55
Salt Creek Trail3.81
Woodland Meadow3.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.20
Elk Pasture,3.32
Forest North Grove,3.71
Large Event Area,2.35
Main Pool,3.80
Marshall Park,4.12
Nature Preserve,4.77
Ned Brown Meadow,5.53
North Pool,4.66
Osborn Park,3.55
Salt Creek Trail,3.81
Woodland Meadow,3.95

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.91188692 0.00910000 NUM

59ed_813e

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 Entrance4.91
Boat Launch Area4.50
Busse Lake3.77
Debra Park3.40
Elk Pasture4.62
Forest Central Grove3.44
Forest North Grove3.16
Forest South Grove5.45
Forest West Grove4.59
Lake Boating Center4.56
Large Event Area4.13
Main Pool4.79
Marshall Park3.78
Nature Preserve3.58
Ned Brown Meadow3.50
North Pool5.15
Salt Creek Trail2.57
Wildlife Refuge3.60
Woodland Meadow3.75

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.91
Boat Launch Area,4.50
Busse Lake,3.77
Debra Park,3.40
Elk Pasture,4.62
Forest Central Grove,3.44
Forest North Grove,3.16
Forest South Grove,5.45
Forest West Grove,4.59
Lake Boating Center,4.56
Large Event Area,4.13
Main Pool,4.79
Marshall Park,3.78
Nature Preserve,3.58
Ned Brown Meadow,3.50
North Pool,5.15
Salt Creek Trail,2.57
Wildlife Refuge,3.60
Woodland Meadow,3.75

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.63268619 0.00630000 NUM

3e1a_50e9

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 Park3.41
Beisner Road Entrance3.65
Busse Lake4.41
Debra Park3.70
Forest Central Grove4.46
Forest North Grove4.71
Forest South Grove5.04
Lake Boating Center5.27
Large Event Area3.98
Main Pool3.64
Model Airplane Field3.73
Nature Preserve4.55
Ned Brown Meadow5.74
North Pool4.14
Osborn Park3.37
Wildlife Refuge4.38
Woodland Meadow3.90

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.41
Beisner Road Entrance,3.65
Busse Lake,4.41
Debra Park,3.70
Forest Central Grove,4.46
Forest North Grove,4.71
Forest South Grove,5.04
Lake Boating Center,5.27
Large Event Area,3.98
Main Pool,3.64
Model Airplane Field,3.73
Nature Preserve,4.55
Ned Brown Meadow,5.74
North Pool,4.14
Osborn Park,3.37
Wildlife Refuge,4.38
Woodland Meadow,3.90

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.09909802 0.00100000 NUM

71c8_5277

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 Park3.11
Boat Launch Area4.49
Debra Park3.72
Elk Pasture4.13
Forest Central Grove4.16
Forest South Grove4.57
Forest West Grove3.39
Lake Boating Center3.77
Main Pool3.59
Marshall Park3.18
Model Airplane Field3.63
Nature Preserve4.77
Ned Brown Meadow2.17
South Pool4.31
Wildlife Refuge3.08
Woodland Meadow4.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,3.11
Boat Launch Area,4.49
Debra Park,3.72
Elk Pasture,4.13
Forest Central Grove,4.16
Forest South Grove,4.57
Forest West Grove,3.39
Lake Boating Center,3.77
Main Pool,3.59
Marshall Park,3.18
Model Airplane Field,3.63
Nature Preserve,4.77
Ned Brown Meadow,2.17
South Pool,4.31
Wildlife Refuge,3.08
Woodland Meadow,4.20

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.12014467 0.00120000 NUM

f796_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
Beisner Road Entrance3.59
Boat Launch Area3.84
Busse Lake5.02
Debra Park4.08
Elk Pasture4.79
Forest Central Grove3.86
Forest North Grove3.77
Forest South Grove3.89
Forest West Grove2.97
Lake Boating Center4.23
Large Event Area3.55
Main Dam3.21
Main Pool3.59
Model Airplane Field3.93
Nature Preserve4.55
North Pool3.42
Salt Creek Trail3.19
South Pool4.27
Wildlife Refuge3.77
Woodland Meadow3.83

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.59
Boat Launch Area,3.84
Busse Lake,5.02
Debra Park,4.08
Elk Pasture,4.79
Forest Central Grove,3.86
Forest North Grove,3.77
Forest South Grove,3.89
Forest West Grove,2.97
Lake Boating Center,4.23
Large Event Area,3.55
Main Dam,3.21
Main Pool,3.59
Model Airplane Field,3.93
Nature Preserve,4.55
North Pool,3.42
Salt Creek Trail,3.19
South Pool,4.27
Wildlife Refuge,3.77
Woodland Meadow,3.83

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.32335021 0.00320000 NUM

6c07_d60f

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 Entrance4.02
Boat Launch Area3.88
Busse Lake3.54
Debra Park4.76
Elk Pasture3.55
Forest North Grove5.12
Forest South Grove4.08
Forest West Grove3.49
Lake Boating Center2.59
Large Event Area4.63
Main Pool4.24
Marshall Park4.67
Model Airplane Field4.84
Ned Brown Meadow3.97
Osborn Park3.73
Salt Creek Trail3.82
Wildlife Refuge4.65
Woodland Meadow3.29

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.02
Boat Launch Area,3.88
Busse Lake,3.54
Debra Park,4.76
Elk Pasture,3.55
Forest North Grove,5.12
Forest South Grove,4.08
Forest West Grove,3.49
Lake Boating Center,2.59
Large Event Area,4.63
Main Pool,4.24
Marshall Park,4.67
Model Airplane Field,4.84
Ned Brown Meadow,3.97
Osborn Park,3.73
Salt Creek Trail,3.82
Wildlife Refuge,4.65
Woodland Meadow,3.29

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.73252528 0.00730000 NUM

49e8_6ae5

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 Park4.69
Beisner Road Entrance4.72
Debra Park3.29
Elk Pasture4.03
Forest Central Grove3.81
Forest North Grove3.68
Forest West Grove3.49
Lake Boating Center4.11
Large Event Area3.99
Main Dam3.16
Main Pool4.94
Marshall Park4.27
Model Airplane Field4.21
Nature Preserve2.87
North Pool4.06
Osborn Park4.66
Salt Creek Trail3.76
South Pool3.27
Wildlife Refuge3.94
Woodland Meadow3.15

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.69
Beisner Road Entrance,4.72
Debra Park,3.29
Elk Pasture,4.03
Forest Central Grove,3.81
Forest North Grove,3.68
Forest West Grove,3.49
Lake Boating Center,4.11
Large Event Area,3.99
Main Dam,3.16
Main Pool,4.94
Marshall Park,4.27
Model Airplane Field,4.21
Nature Preserve,2.87
North Pool,4.06
Osborn Park,4.66
Salt Creek Trail,3.76
South Pool,3.27
Wildlife Refuge,3.94
Woodland Meadow,3.15

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.47889049 0.00480000 NUM

e263_f225

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 Park4.09
Beisner Road Entrance3.47
Debra Park3.87
Forest Central Grove4.23
Forest North Grove4.48
Forest West Grove3.47
Large Event Area3.85
Main Pool4.56
Marshall Park3.47
Model Airplane Field4.14
Nature Preserve3.45
Ned Brown Meadow4.38
North Pool3.64
Osborn Park2.77
Salt Creek Trail3.19
South Pool4.54
Woodland Meadow4.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,4.09
Beisner Road Entrance,3.47
Debra Park,3.87
Forest Central Grove,4.23
Forest North Grove,4.48
Forest West Grove,3.47
Large Event Area,3.85
Main Pool,4.56
Marshall Park,3.47
Model Airplane Field,4.14
Nature Preserve,3.45
Ned Brown Meadow,4.38
North Pool,3.64
Osborn Park,2.77
Salt Creek Trail,3.19
South Pool,4.54
Woodland Meadow,4.12

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.35671880 0.00360000 NUM

4c2d_dc57

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 Park3.72
Beisner Road Entrance3.17
Boat Launch Area4.01
Busse Lake4.60
Debra Park4.44
Elk Pasture4.52
Forest Central Grove4.18
Forest North Grove5.10
Forest South Grove3.32
Forest West Grove4.07
Lake Boating Center4.69
Main Pool4.45
Marshall Park4.50
Nature Preserve3.32
Ned Brown Meadow3.14
North Pool4.60
Salt Creek Trail4.91
South Pool5.14
Wildlife Refuge4.70
Woodland Meadow3.29

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.72
Beisner Road Entrance,3.17
Boat Launch Area,4.01
Busse Lake,4.60
Debra Park,4.44
Elk Pasture,4.52
Forest Central Grove,4.18
Forest North Grove,5.10
Forest South Grove,3.32
Forest West Grove,4.07
Lake Boating Center,4.69
Main Pool,4.45
Marshall Park,4.50
Nature Preserve,3.32
Ned Brown Meadow,3.14
North Pool,4.60
Salt Creek Trail,4.91
South Pool,5.14
Wildlife Refuge,4.70
Woodland Meadow,3.29

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.14922796 0.00150000 NUM

398b_d7b6

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
Debra Park3.64
Elk Pasture5.19
Forest Central Grove3.62
Forest North Grove3.74
Forest West Grove3.76
Large Event Area3.84
Main Dam4.23
Main Pool3.41
Model Airplane Field3.72
North Pool4.60
Osborn Park3.87
Salt Creek Trail3.84
South Pool3.44
Wildlife Refuge4.24
Woodland Meadow5.44

Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.

Sample Location 2024 Shannon Index
Debra Park,3.64
Elk Pasture,5.19
Forest Central Grove,3.62
Forest North Grove,3.74
Forest West Grove,3.76
Large Event Area,3.84
Main Dam,4.23
Main Pool,3.41
Model Airplane Field,3.72
North Pool,4.60
Osborn Park,3.87
Salt Creek Trail,3.84
South Pool,3.44
Wildlife Refuge,4.24
Woodland Meadow,5.44

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.80290268 0.00800000 NUM

5233_aab2

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 Entrance4.11
Boat Launch Area3.52
Debra Park4.17
Elk Pasture4.64
Forest Central Grove4.72
Forest South Grove4.01
Lake Boating Center3.28
Large Event Area3.35
Main Dam3.13
Marshall Park4.76
Model Airplane Field3.73
Nature Preserve4.06
North Pool4.53
Osborn Park2.53
Salt Creek Trail4.68
South Pool4.19
Wildlife Refuge3.98
Woodland Meadow3.47

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.11
Boat Launch Area,3.52
Debra Park,4.17
Elk Pasture,4.64
Forest Central Grove,4.72
Forest South Grove,4.01
Lake Boating Center,3.28
Large Event Area,3.35
Main Dam,3.13
Marshall Park,4.76
Model Airplane Field,3.73
Nature Preserve,4.06
North Pool,4.53
Osborn Park,2.53
Salt Creek Trail,4.68
South Pool,4.19
Wildlife Refuge,3.98
Woodland Meadow,3.47

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.65427279 0.00650000 NUM

3fc8_2fc1

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 Park3.86
Beisner Road Entrance3.96
Boat Launch Area4.97
Busse Lake3.89
Elk Pasture3.86
Forest Central Grove3.73
Forest South Grove4.19
Lake Boating Center3.04
Main Dam3.94
Ned Brown Meadow3.76
Osborn Park3.86
Salt Creek Trail2.97
Wildlife Refuge3.72
Woodland Meadow4.22

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.86
Beisner Road Entrance,3.96
Boat Launch Area,4.97
Busse Lake,3.89
Elk Pasture,3.86
Forest Central Grove,3.73
Forest South Grove,4.19
Lake Boating Center,3.04
Main Dam,3.94
Ned Brown Meadow,3.76
Osborn Park,3.86
Salt Creek Trail,2.97
Wildlife Refuge,3.72
Woodland Meadow,4.22

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.36587140 0.00370000 NUM

80bc_3b19

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 Park3.66
Elk Pasture3.42
Forest North Grove2.85
Forest South Grove4.04
Forest West Grove3.35
Large Event Area3.25
Main Dam4.08
Marshall Park4.00
Nature Preserve5.27
North Pool3.80
Salt Creek Trail3.55
Wildlife Refuge3.89
Woodland Meadow4.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,3.66
Elk Pasture,3.42
Forest North Grove,2.85
Forest South Grove,4.04
Forest West Grove,3.35
Large Event Area,3.25
Main Dam,4.08
Marshall Park,4.00
Nature Preserve,5.27
North Pool,3.80
Salt Creek Trail,3.55
Wildlife Refuge,3.89
Woodland Meadow,4.25

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.23121773 0.00230000 NUM

984e_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
Andrews Park3.19
Beisner Road Entrance4.23
Boat Launch Area3.99
Busse Lake3.78
Debra Park4.66
Elk Pasture3.85
Forest South Grove3.35
Lake Boating Center3.65
Large Event Area4.11
Main Pool4.50
Marshall Park4.28
Model Airplane Field3.91
North Pool4.14
Osborn Park4.45
Salt Creek Trail3.92
South Pool4.19

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.19
Beisner Road Entrance,4.23
Boat Launch Area,3.99
Busse Lake,3.78
Debra Park,4.66
Elk Pasture,3.85
Forest South Grove,3.35
Lake Boating Center,3.65
Large Event Area,4.11
Main Pool,4.50
Marshall Park,4.28
Model Airplane Field,3.91
North Pool,4.14
Osborn Park,4.45
Salt Creek Trail,3.92
South Pool,4.19

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.93358650 0.00930000 NUM

edf8_b259

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 Park3.91
Boat Launch Area4.39
Busse Lake3.48
Debra Park4.20
Forest West Grove4.67
Large Event Area4.86
Main Dam5.37
Main Pool4.29
Marshall Park3.71
Model Airplane Field4.34
Nature Preserve4.76
Ned Brown Meadow4.07
Salt Creek Trail3.50
South Pool4.24
Wildlife Refuge4.08
Woodland Meadow4.37

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.91
Boat Launch Area,4.39
Busse Lake,3.48
Debra Park,4.20
Forest West Grove,4.67
Large Event Area,4.86
Main Dam,5.37
Main Pool,4.29
Marshall Park,3.71
Model Airplane Field,4.34
Nature Preserve,4.76
Ned Brown Meadow,4.07
Salt Creek Trail,3.50
South Pool,4.24
Wildlife Refuge,4.08
Woodland Meadow,4.37

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.07728407 0.00100000 NUM

7e3c_4a89

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 Entrance3.78
Busse Lake4.53
Debra Park5.47
Elk Pasture3.31
Forest Central Grove3.87
Forest North Grove2.15
Lake Boating Center4.18
Large Event Area3.93
Main Dam3.47
Marshall Park3.71
Model Airplane Field4.05
Nature Preserve4.39
Ned Brown Meadow4.38
Salt Creek Trail3.95
South Pool3.90
Wildlife Refuge3.98
Woodland Meadow3.80

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
Busse Lake,4.53
Debra Park,5.47
Elk Pasture,3.31
Forest Central Grove,3.87
Forest North Grove,2.15
Lake Boating Center,4.18
Large Event Area,3.93
Main Dam,3.47
Marshall Park,3.71
Model Airplane Field,4.05
Nature Preserve,4.39
Ned Brown Meadow,4.38
Salt Creek Trail,3.95
South Pool,3.90
Wildlife Refuge,3.98
Woodland Meadow,3.80

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.64203175 0.00640000 NUM

8576_5e65

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 Entrance3.87
Boat Launch Area4.05
Busse Lake3.00
Debra Park5.07
Elk Pasture4.52
Forest Central Grove4.69
Forest South Grove3.20
Main Dam4.02
Model Airplane Field3.91
Nature Preserve3.89
Ned Brown Meadow4.28
North Pool4.31
Osborn Park4.96
Salt Creek Trail4.16
South Pool3.26
Wildlife Refuge5.31
Woodland Meadow4.36

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.87
Boat Launch Area,4.05
Busse Lake,3.00
Debra Park,5.07
Elk Pasture,4.52
Forest Central Grove,4.69
Forest South Grove,3.20
Main Dam,4.02
Model Airplane Field,3.91
Nature Preserve,3.89
Ned Brown Meadow,4.28
North Pool,4.31
Osborn Park,4.96
Salt Creek Trail,4.16
South Pool,3.26
Wildlife Refuge,5.31
Woodland Meadow,4.36

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.24764579 0.00250000 NUM

9de5_7ad1

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 Area4.23
Elk Pasture3.46
Forest Central Grove3.77
Forest North Grove4.11
Forest South Grove3.22
Lake Boating Center4.83
Large Event Area3.33
Main Pool3.91
Model Airplane Field4.49
Nature Preserve2.90
Salt Creek Trail3.83
South Pool3.90
Wildlife Refuge3.89

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.23
Elk Pasture,3.46
Forest Central Grove,3.77
Forest North Grove,4.11
Forest South Grove,3.22
Lake Boating Center,4.83
Large Event Area,3.33
Main Pool,3.91
Model Airplane Field,4.49
Nature Preserve,2.90
Salt Creek Trail,3.83
South Pool,3.90
Wildlife Refuge,3.89

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.32482410 0.00320000 NUM

8cd8_61af

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 Park4.87
Beisner Road Entrance3.54
Boat Launch Area3.26
Busse Lake5.61
Elk Pasture5.23
Forest Central Grove4.16
Forest North Grove4.25
Large Event Area3.29
Main Dam3.24
Main Pool4.13
Marshall Park3.31
Model Airplane Field3.89
North Pool4.71
Osborn Park3.96
Salt Creek Trail5.62
South Pool4.24

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.87
Beisner Road Entrance,3.54
Boat Launch Area,3.26
Busse Lake,5.61
Elk Pasture,5.23
Forest Central Grove,4.16
Forest North Grove,4.25
Large Event Area,3.29
Main Dam,3.24
Main Pool,4.13
Marshall Park,3.31
Model Airplane Field,3.89
North Pool,4.71
Osborn Park,3.96
Salt Creek Trail,5.62
South Pool,4.24

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.16784337 0.00170000 NUM

0962_16ed

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 Park3.97
Beisner Road Entrance4.26
Boat Launch Area4.08
Debra Park4.01
Elk Pasture3.13
Forest Central Grove4.29
Forest South Grove4.29
Forest West Grove4.83
Lake Boating Center4.49
Large Event Area3.62
Main Dam2.95
Main Pool3.94
Marshall Park3.98
Nature Preserve4.10
Ned Brown Meadow2.96
North Pool3.64
Salt Creek Trail4.12
South Pool4.71
Wildlife Refuge3.36
Woodland Meadow4.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,3.97
Beisner Road Entrance,4.26
Boat Launch Area,4.08
Debra Park,4.01
Elk Pasture,3.13
Forest Central Grove,4.29
Forest South Grove,4.29
Forest West Grove,4.83
Lake Boating Center,4.49
Large Event Area,3.62
Main Dam,2.95
Main Pool,3.94
Marshall Park,3.98
Nature Preserve,4.10
Ned Brown Meadow,2.96
North Pool,3.64
Salt Creek Trail,4.12
South Pool,4.71
Wildlife Refuge,3.36
Woodland Meadow,4.91

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.89327283 0.00890000 NUM

8ca9_24a0

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 Entrance4.05
Debra Park3.99
Forest Central Grove4.30
Forest North Grove4.37
Forest South Grove4.32
Lake Boating Center3.70
Large Event Area3.27
Marshall Park4.24
Nature Preserve4.43
North Pool5.21
Osborn Park4.33
Salt Creek Trail4.72
South Pool4.66
Wildlife Refuge4.57

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.05
Debra Park,3.99
Forest Central Grove,4.30
Forest North Grove,4.37
Forest South Grove,4.32
Lake Boating Center,3.70
Large Event Area,3.27
Marshall Park,4.24
Nature Preserve,4.43
North Pool,5.21
Osborn Park,4.33
Salt Creek Trail,4.72
South Pool,4.66
Wildlife Refuge,4.57

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.06388074 0.00100000 NUM

a6cb_5681

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 Park3.87
Beisner Road Entrance3.89
Boat Launch Area3.40
Busse Lake3.33
Debra Park4.35
Elk Pasture4.76
Forest Central Grove3.68
Forest North Grove3.78
Forest South Grove3.96
Forest West Grove3.65
Large Event Area4.27
Main Pool3.80
Marshall Park3.65
Model Airplane Field4.18
Nature Preserve3.68
Ned Brown Meadow3.57
North Pool3.13
Osborn Park3.82
Salt Creek Trail3.68
South Pool4.29

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.89
Boat Launch Area,3.40
Busse Lake,3.33
Debra Park,4.35
Elk Pasture,4.76
Forest Central Grove,3.68
Forest North Grove,3.78
Forest South Grove,3.96
Forest West Grove,3.65
Large Event Area,4.27
Main Pool,3.80
Marshall Park,3.65
Model Airplane Field,4.18
Nature Preserve,3.68
Ned Brown Meadow,3.57
North Pool,3.13
Osborn Park,3.82
Salt Creek Trail,3.68
South Pool,4.29

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.22439269 0.00220000 NUM

510b_ef62

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 Entrance3.40
Busse Lake4.63
Debra Park3.20
Elk Pasture3.27
Forest Central Grove4.22
Forest North Grove3.59
Forest South Grove4.11
Forest West Grove4.09
Lake Boating Center3.19
Large Event Area3.67
Main Dam4.05
Marshall Park3.61
Model Airplane Field4.68
Nature Preserve3.51
Ned Brown Meadow3.95
North Pool4.12
Salt Creek Trail3.19
South Pool2.61
Woodland Meadow4.09

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.40
Busse Lake,4.63
Debra Park,3.20
Elk Pasture,3.27
Forest Central Grove,4.22
Forest North Grove,3.59
Forest South Grove,4.11
Forest West Grove,4.09
Lake Boating Center,3.19
Large Event Area,3.67
Main Dam,4.05
Marshall Park,3.61
Model Airplane Field,4.68
Nature Preserve,3.51
Ned Brown Meadow,3.95
North Pool,4.12
Salt Creek Trail,3.19
South Pool,2.61
Woodland Meadow,4.09

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.06533294 0.00100000 NUM

d560_cf41

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 Area3.56
Busse Lake3.80
Debra Park2.81
Elk Pasture4.00
Forest Central Grove2.58
Forest North Grove4.59
Forest South Grove5.00
Forest West Grove3.96
Lake Boating Center3.79
Large Event Area2.85
Main Dam5.28
Main Pool3.30
Model Airplane Field3.54
Nature Preserve3.44
North Pool4.73
Osborn Park2.55
South Pool4.34
Wildlife Refuge3.62

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.56
Busse Lake,3.80
Debra Park,2.81
Elk Pasture,4.00
Forest Central Grove,2.58
Forest North Grove,4.59
Forest South Grove,5.00
Forest West Grove,3.96
Lake Boating Center,3.79
Large Event Area,2.85
Main Dam,5.28
Main Pool,3.30
Model Airplane Field,3.54
Nature Preserve,3.44
North Pool,4.73
Osborn Park,2.55
South Pool,4.34
Wildlife Refuge,3.62

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.09423165 0.00100000 NUM

e139_3ed5

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 Park3.12
Busse Lake3.70
Debra Park3.71
Forest Central Grove3.96
Forest North Grove3.91
Lake Boating Center4.03
Main Pool4.29
Marshall Park3.81
Model Airplane Field5.05
Ned Brown Meadow4.11
North Pool4.35
Osborn Park3.50
Salt Creek Trail4.15

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.12
Busse Lake,3.70
Debra Park,3.71
Forest Central Grove,3.96
Forest North Grove,3.91
Lake Boating Center,4.03
Main Pool,4.29
Marshall Park,3.81
Model Airplane Field,5.05
Ned Brown Meadow,4.11
North Pool,4.35
Osborn Park,3.50
Salt Creek Trail,4.15

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.88605519 0.00890000 NUM

dd5d_4366

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 Entrance3.03
Boat Launch Area3.94
Debra Park5.52
Forest North Grove2.86
Forest West Grove4.67
Lake Boating Center4.21
Main Dam3.15
Main Pool3.31
Marshall Park3.48
Model Airplane Field4.73
Nature Preserve3.03
North Pool3.70
Salt Creek Trail3.58
South Pool4.01

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.03
Boat Launch Area,3.94
Debra Park,5.52
Forest North Grove,2.86
Forest West Grove,4.67
Lake Boating Center,4.21
Main Dam,3.15
Main Pool,3.31
Marshall Park,3.48
Model Airplane Field,4.73
Nature Preserve,3.03
North Pool,3.70
Salt Creek Trail,3.58
South Pool,4.01

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.21560098 0.00220000 NUM

0db3_04ce

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 Park4.57
Boat Launch Area3.74
Debra Park4.01
Forest Central Grove4.21
Forest North Grove3.69
Forest South Grove4.35
Forest West Grove3.68
Marshall Park3.71
Nature Preserve4.66
Ned Brown Meadow3.79
North Pool3.41
Wildlife Refuge5.25
Woodland Meadow4.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,4.57
Boat Launch Area,3.74
Debra Park,4.01
Forest Central Grove,4.21
Forest North Grove,3.69
Forest South Grove,4.35
Forest West Grove,3.68
Marshall Park,3.71
Nature Preserve,4.66
Ned Brown Meadow,3.79
North Pool,3.41
Wildlife Refuge,5.25
Woodland Meadow,4.12

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.58226608 0.00580000 NUM

86c7_913d

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 Park4.46
Busse Lake4.89
Debra Park3.96
Forest Central Grove4.31
Forest North Grove4.47
Forest West Grove4.68
Main Dam3.85
Nature Preserve3.74
Ned Brown Meadow3.25
Osborn Park4.46
South Pool5.08
Wildlife Refuge4.25
Woodland Meadow3.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,4.46
Busse Lake,4.89
Debra Park,3.96
Forest Central Grove,4.31
Forest North Grove,4.47
Forest West Grove,4.68
Main Dam,3.85
Nature Preserve,3.74
Ned Brown Meadow,3.25
Osborn Park,4.46
South Pool,5.08
Wildlife Refuge,4.25
Woodland Meadow,3.52

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.17708962 0.00180000 NUM

cc33_3cdb

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 Park4.12
Beisner Road Entrance3.58
Boat Launch Area4.45
Elk Pasture3.20
Forest North Grove4.05
Forest South Grove3.07
Forest West Grove3.50
Large Event Area4.33
Main Dam3.09
Main Pool4.15
North Pool4.31
Salt Creek Trail4.41
South Pool3.41

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.12
Beisner Road Entrance,3.58
Boat Launch Area,4.45
Elk Pasture,3.20
Forest North Grove,4.05
Forest South Grove,3.07
Forest West Grove,3.50
Large Event Area,4.33
Main Dam,3.09
Main Pool,4.15
North Pool,4.31
Salt Creek Trail,4.41
South Pool,3.41

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.28146111 0.00280000 NUM

f7d8_7fb7

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 Park4.37
Beisner Road Entrance4.97
Busse Lake4.85
Debra Park4.25
Elk Pasture4.60
Forest Central Grove4.33
Forest South Grove3.64
Forest West Grove3.21
Lake Boating Center5.18
Large Event Area3.99
Main Pool4.66
Marshall Park4.87
Model Airplane Field3.94
Ned Brown Meadow3.30
Osborn Park3.42
South Pool4.93
Wildlife Refuge3.59
Woodland Meadow4.66

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.37
Beisner Road Entrance,4.97
Busse Lake,4.85
Debra Park,4.25
Elk Pasture,4.60
Forest Central Grove,4.33
Forest South Grove,3.64
Forest West Grove,3.21
Lake Boating Center,5.18
Large Event Area,3.99
Main Pool,4.66
Marshall Park,4.87
Model Airplane Field,3.94
Ned Brown Meadow,3.30
Osborn Park,3.42
South Pool,4.93
Wildlife Refuge,3.59
Woodland Meadow,4.66

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.06149707 0.00100000 NUM

47a2_8fbf

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 Park2.86
Boat Launch Area4.20
Busse Lake4.62
Debra Park3.40
Forest North Grove4.06
Forest West Grove4.89
Large Event Area3.62
Main Pool4.90
Model Airplane Field4.30
Ned Brown Meadow4.13
North Pool4.80
Osborn Park3.80
Salt Creek Trail3.15
South Pool4.20
Wildlife Refuge3.49
Woodland Meadow3.00

Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.

Sample Location 2024 Shannon Index
Andrews Park,2.86
Boat Launch Area,4.20
Busse Lake,4.62
Debra Park,3.40
Forest North Grove,4.06
Forest West Grove,4.89
Large Event Area,3.62
Main Pool,4.90
Model Airplane Field,4.30
Ned Brown Meadow,4.13
North Pool,4.80
Osborn Park,3.80
Salt Creek Trail,3.15
South Pool,4.20
Wildlife Refuge,3.49
Woodland Meadow,3.00

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.80903846 0.00810000 NUM

1747_99c0

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 Park3.97
Busse Lake3.84
Forest Central Grove4.19
Forest North Grove4.20
Forest South Grove3.39
Forest West Grove4.50
Large Event Area3.58
Main Pool4.63
Marshall Park3.89
Model Airplane Field5.33
Nature Preserve3.71
Ned Brown Meadow3.98
North Pool5.18
Osborn Park4.39
Salt Creek Trail3.93
South Pool4.65
Woodland Meadow4.19

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.97
Busse Lake,3.84
Forest Central Grove,4.19
Forest North Grove,4.20
Forest South Grove,3.39
Forest West Grove,4.50
Large Event Area,3.58
Main Pool,4.63
Marshall Park,3.89
Model Airplane Field,5.33
Nature Preserve,3.71
Ned Brown Meadow,3.98
North Pool,5.18
Osborn Park,4.39
Salt Creek Trail,3.93
South Pool,4.65
Woodland Meadow,4.19

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.15128640 0.00150000 NUM

3024_6093

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 Park3.97
Beisner Road Entrance4.17
Boat Launch Area3.02
Busse Lake4.07
Debra Park3.23
Elk Pasture4.22
Forest Central Grove3.73
Forest North Grove3.49
Lake Boating Center5.50
Main Dam3.43
Marshall Park3.89
Model Airplane Field3.10
Nature Preserve4.66
Ned Brown Meadow4.88
North Pool3.31
Salt Creek Trail3.11
South Pool3.81
Wildlife Refuge3.39
Woodland Meadow4.02

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.97
Beisner Road Entrance,4.17
Boat Launch Area,3.02
Busse Lake,4.07
Debra Park,3.23
Elk Pasture,4.22
Forest Central Grove,3.73
Forest North Grove,3.49
Lake Boating Center,5.50
Main Dam,3.43
Marshall Park,3.89
Model Airplane Field,3.10
Nature Preserve,4.66
Ned Brown Meadow,4.88
North Pool,3.31
Salt Creek Trail,3.11
South Pool,3.81
Wildlife Refuge,3.39
Woodland Meadow,4.02

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.25134911 0.00250000 NUM

1294_53e1

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 Park3.68
Beisner Road Entrance4.28
Debra Park4.12
Elk Pasture3.72
Forest Central Grove4.45
Forest South Grove3.95
Forest West Grove4.44
Lake Boating Center4.70
Large Event Area4.21
Model Airplane Field4.51
Nature Preserve3.91
North Pool4.58
Osborn Park3.98
Salt Creek Trail2.11
Wildlife Refuge3.68
Woodland Meadow5.10

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.68
Beisner Road Entrance,4.28
Debra Park,4.12
Elk Pasture,3.72
Forest Central Grove,4.45
Forest South Grove,3.95
Forest West Grove,4.44
Lake Boating Center,4.70
Large Event Area,4.21
Model Airplane Field,4.51
Nature Preserve,3.91
North Pool,4.58
Osborn Park,3.98
Salt Creek Trail,2.11
Wildlife Refuge,3.68
Woodland Meadow,5.10

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.55407382 0.00550000 NUM

abbf_6760

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 Entrance3.89
Boat Launch Area4.67
Forest North Grove3.67
Lake Boating Center4.48
Large Event Area4.12
Main Dam4.26
Main Pool3.97
Marshall Park4.24
Model Airplane Field3.77
Nature Preserve4.60
Ned Brown Meadow4.06
Osborn Park3.02
Salt Creek Trail2.78
Wildlife Refuge4.20
Woodland Meadow3.90

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.89
Boat Launch Area,4.67
Forest North Grove,3.67
Lake Boating Center,4.48
Large Event Area,4.12
Main Dam,4.26
Main Pool,3.97
Marshall Park,4.24
Model Airplane Field,3.77
Nature Preserve,4.60
Ned Brown Meadow,4.06
Osborn Park,3.02
Salt Creek Trail,2.78
Wildlife Refuge,4.20
Woodland Meadow,3.90

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.87349346 0.00870000 NUM

097d_108b

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 Entrance4.25
Boat Launch Area4.59
Debra Park4.23
Elk Pasture4.44
Forest South Grove3.80
Forest West Grove3.59
Lake Boating Center3.69
Marshall Park3.70
Model Airplane Field4.63
Ned Brown Meadow5.24
North Pool4.46
Osborn Park3.99
Woodland Meadow3.29

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.25
Boat Launch Area,4.59
Debra Park,4.23
Elk Pasture,4.44
Forest South Grove,3.80
Forest West Grove,3.59
Lake Boating Center,3.69
Marshall Park,3.70
Model Airplane Field,4.63
Ned Brown Meadow,5.24
North Pool,4.46
Osborn Park,3.99
Woodland Meadow,3.29

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.37979433 0.00380000 NUM

3866_8bcf

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 Entrance4.33
Boat Launch Area2.28
Debra Park4.42
Elk Pasture3.85
Forest Central Grove4.89
Forest North Grove4.17
Forest South Grove4.80
Forest West Grove3.74
Main Dam4.50
Main Pool3.66
Marshall Park4.89
Osborn Park4.32
Salt Creek Trail4.25
Wildlife Refuge4.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,4.33
Boat Launch Area,2.28
Debra Park,4.42
Elk Pasture,3.85
Forest Central Grove,4.89
Forest North Grove,4.17
Forest South Grove,4.80
Forest West Grove,3.74
Main Dam,4.50
Main Pool,3.66
Marshall Park,4.89
Osborn Park,4.32
Salt Creek Trail,4.25
Wildlife Refuge,4.53

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.24139982 0.00240000 NUM

2e5d_b2d2

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 Park4.44
Busse Lake3.37
Debra Park3.80
Forest North Grove3.43
Forest West Grove3.45
Main Dam4.36
Main Pool4.23
Model Airplane Field3.93
Ned Brown Meadow4.57
Osborn Park3.50
Salt Creek Trail4.07
South Pool2.81

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.44
Busse Lake,3.37
Debra Park,3.80
Forest North Grove,3.43
Forest West Grove,3.45
Main Dam,4.36
Main Pool,4.23
Model Airplane Field,3.93
Ned Brown Meadow,4.57
Osborn Park,3.50
Salt Creek Trail,4.07
South Pool,2.81

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.32634847 0.00330000 NUM

e789_e5e3

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 Entrance3.93
Boat Launch Area4.43
Busse Lake4.36
Debra Park4.53
Elk Pasture3.14
Forest North Grove3.76
Forest South Grove3.22
Forest West Grove4.12
Large Event Area3.66
Marshall Park3.26
Model Airplane Field3.69
Nature Preserve3.86
South Pool3.66
Wildlife Refuge3.66

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.93
Boat Launch Area,4.43
Busse Lake,4.36
Debra Park,4.53
Elk Pasture,3.14
Forest North Grove,3.76
Forest South Grove,3.22
Forest West Grove,4.12
Large Event Area,3.66
Marshall Park,3.26
Model Airplane Field,3.69
Nature Preserve,3.86
South Pool,3.66
Wildlife Refuge,3.66

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.22567155 0.00230000 NUM

df11_92a0

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 Area2.98
Busse Lake4.33
Elk Pasture4.19
Forest North Grove4.05
Forest West Grove3.03
Lake Boating Center3.92
Large Event Area4.27
Main Dam3.98
Main Pool3.64
Marshall Park4.80
Model Airplane Field4.38
Nature Preserve3.30
Wildlife Refuge3.95
Woodland Meadow3.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,2.98
Busse Lake,4.33
Elk Pasture,4.19
Forest North Grove,4.05
Forest West Grove,3.03
Lake Boating Center,3.92
Large Event Area,4.27
Main Dam,3.98
Main Pool,3.64
Marshall Park,4.80
Model Airplane Field,4.38
Nature Preserve,3.30
Wildlife Refuge,3.95
Woodland Meadow,3.99

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.59606469 0.00600000 NUM

7df1_8b4f

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 Park4.60
Beisner Road Entrance4.92
Boat Launch Area3.98
Elk Pasture2.58
Forest Central Grove3.97
Forest North Grove4.27
Forest South Grove3.12
Forest West Grove4.48
Lake Boating Center2.82
Large Event Area3.10
Main Dam3.30
Main Pool4.00
Marshall Park3.92
Model Airplane Field3.56
Ned Brown Meadow3.20
North Pool3.56
Osborn Park4.24
Salt Creek Trail4.78
South Pool3.72
Woodland Meadow4.34

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.60
Beisner Road Entrance,4.92
Boat Launch Area,3.98
Elk Pasture,2.58
Forest Central Grove,3.97
Forest North Grove,4.27
Forest South Grove,3.12
Forest West Grove,4.48
Lake Boating Center,2.82
Large Event Area,3.10
Main Dam,3.30
Main Pool,4.00
Marshall Park,3.92
Model Airplane Field,3.56
Ned Brown Meadow,3.20
North Pool,3.56
Osborn Park,4.24
Salt Creek Trail,4.78
South Pool,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.18707549 0.00190000 NUM

4b48_36e8

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 Park2.79
Beisner Road Entrance3.45
Boat Launch Area3.45
Busse Lake4.03
Forest Central Grove4.49
Forest North Grove4.93
Forest South Grove3.95
Forest West Grove4.10
Lake Boating Center4.11
Main Pool4.12
Model Airplane Field4.06
Nature Preserve3.38
North Pool3.49
Osborn Park3.00
South Pool4.28
Wildlife Refuge4.31
Woodland Meadow4.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,2.79
Beisner Road Entrance,3.45
Boat Launch Area,3.45
Busse Lake,4.03
Forest Central Grove,4.49
Forest North Grove,4.93
Forest South Grove,3.95
Forest West Grove,4.10
Lake Boating Center,4.11
Main Pool,4.12
Model Airplane Field,4.06
Nature Preserve,3.38
North Pool,3.49
Osborn Park,3.00
South Pool,4.28
Wildlife Refuge,4.31
Woodland Meadow,4.53

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.53626831 0.00540000 NUM

2800_0da1

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 Area4.27
Busse Lake4.08
Debra Park4.56
Elk Pasture3.49
Forest Central Grove4.33
Forest South Grove4.87
Forest West Grove3.38
Large Event Area3.82
Ned Brown Meadow4.66
Osborn Park4.22
South Pool3.65
Wildlife Refuge4.45
Woodland Meadow3.65

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.27
Busse Lake,4.08
Debra Park,4.56
Elk Pasture,3.49
Forest Central Grove,4.33
Forest South Grove,4.87
Forest West Grove,3.38
Large Event Area,3.82
Ned Brown Meadow,4.66
Osborn Park,4.22
South Pool,3.65
Wildlife Refuge,4.45
Woodland Meadow,3.65

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.50860094 0.00510000 NUM

51e9_1f03

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 Park3.93
Boat Launch Area4.43
Busse Lake3.48
Debra Park4.19
Elk Pasture3.46
Forest Central Grove4.15
Forest West Grove4.39
Large Event Area3.01
Main Pool4.81
Marshall Park4.18
Osborn Park3.66
Salt Creek Trail3.62
Woodland Meadow3.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.93
Boat Launch Area,4.43
Busse Lake,3.48
Debra Park,4.19
Elk Pasture,3.46
Forest Central Grove,4.15
Forest West Grove,4.39
Large Event Area,3.01
Main Pool,4.81
Marshall Park,4.18
Osborn Park,3.66
Salt Creek Trail,3.62
Woodland Meadow,3.54

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.59501159 0.00600000 NUM

3b6f_3cf2

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 Park3.33
Beisner Road Entrance4.89
Busse Lake5.10
Forest Central Grove3.68
Forest North Grove3.89
Lake Boating Center4.42
Nature Preserve4.00
Ned Brown Meadow4.73
North Pool2.71
Osborn Park3.44
South Pool4.48
Wildlife Refuge4.88

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.33
Beisner Road Entrance,4.89
Busse Lake,5.10
Forest Central Grove,3.68
Forest North Grove,3.89
Lake Boating Center,4.42
Nature Preserve,4.00
Ned Brown Meadow,4.73
North Pool,2.71
Osborn Park,3.44
South Pool,4.48
Wildlife Refuge,4.88

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.45582202 0.00460000 NUM

1581_3a8c

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 Park4.18
Beisner Road Entrance4.90
Busse Lake4.12
Debra Park3.15
Forest Central Grove4.46
Forest North Grove4.94
Forest South Grove3.09
Forest West Grove3.78
Lake Boating Center4.44
Large Event Area4.11
Main Dam4.29
Main Pool3.72
Marshall Park3.81
Nature Preserve4.71
Ned Brown Meadow4.21
Salt Creek Trail4.14
South Pool5.39
Woodland Meadow3.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.18
Beisner Road Entrance,4.90
Busse Lake,4.12
Debra Park,3.15
Forest Central Grove,4.46
Forest North Grove,4.94
Forest South Grove,3.09
Forest West Grove,3.78
Lake Boating Center,4.44
Large Event Area,4.11
Main Dam,4.29
Main Pool,3.72
Marshall Park,3.81
Nature Preserve,4.71
Ned Brown Meadow,4.21
Salt Creek Trail,4.14
South Pool,5.39
Woodland Meadow,3.20

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.29969394 0.00300000 NUM

3ece_52de

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 Entrance4.01
Debra Park4.22
Elk Pasture3.83
Forest Central Grove4.74
Forest South Grove4.12
Large Event Area4.57
Main Dam3.39
Main Pool4.68
Model Airplane Field4.77
Nature Preserve3.39
Ned Brown Meadow4.87
North Pool4.87
Osborn Park3.41
Salt Creek Trail4.28
South Pool3.73
Wildlife Refuge3.58
Woodland Meadow3.96

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.01
Debra Park,4.22
Elk Pasture,3.83
Forest Central Grove,4.74
Forest South Grove,4.12
Large Event Area,4.57
Main Dam,3.39
Main Pool,4.68
Model Airplane Field,4.77
Nature Preserve,3.39
Ned Brown Meadow,4.87
North Pool,4.87
Osborn Park,3.41
Salt Creek Trail,4.28
South Pool,3.73
Wildlife Refuge,3.58
Woodland Meadow,3.96

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.32796206 0.00330000 NUM

3461_e9c5

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 Park4.42
Beisner Road Entrance3.79
Boat Launch Area4.39
Busse Lake3.99
Debra Park3.76
Elk Pasture3.83
Forest Central Grove2.39
Forest South Grove4.09
Lake Boating Center4.49
Large Event Area4.16
Main Dam3.58
Marshall Park4.08
Model Airplane Field3.10
Nature Preserve3.14
Ned Brown Meadow4.30
North Pool4.73
Osborn Park3.83
South Pool4.07
Wildlife Refuge3.72

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.42
Beisner Road Entrance,3.79
Boat Launch Area,4.39
Busse Lake,3.99
Debra Park,3.76
Elk Pasture,3.83
Forest Central Grove,2.39
Forest South Grove,4.09
Lake Boating Center,4.49
Large Event Area,4.16
Main Dam,3.58
Marshall Park,4.08
Model Airplane Field,3.10
Nature Preserve,3.14
Ned Brown Meadow,4.30
North Pool,4.73
Osborn Park,3.83
South Pool,4.07
Wildlife Refuge,3.72

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.41321476 0.00410000 NUM

5b55_8db1

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 Area3.78
Busse Lake3.83
Debra Park3.41
Elk Pasture5.18
Forest Central Grove4.53
Forest North Grove4.44
Forest South Grove4.46
Forest West Grove4.06
Lake Boating Center4.03
Large Event Area4.85
Main Dam3.68
Main Pool2.83
Marshall Park2.55
Nature Preserve4.43
Ned Brown Meadow3.59
Osborn Park3.16
South Pool3.77
Woodland Meadow3.77

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.78
Busse Lake,3.83
Debra Park,3.41
Elk Pasture,5.18
Forest Central Grove,4.53
Forest North Grove,4.44
Forest South Grove,4.46
Forest West Grove,4.06
Lake Boating Center,4.03
Large Event Area,4.85
Main Dam,3.68
Main Pool,2.83
Marshall Park,2.55
Nature Preserve,4.43
Ned Brown Meadow,3.59
Osborn Park,3.16
South Pool,3.77
Woodland Meadow,3.77

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.51686775 0.00520000 NUM

4d2b_23e7

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 Park3.72
Beisner Road Entrance3.32
Boat Launch Area3.28
Busse Lake4.46
Debra Park3.73
Elk Pasture3.57
Forest North Grove4.54
Lake Boating Center4.73
Large Event Area3.87
Main Dam3.82
Main Pool4.52
Marshall Park3.76
Model Airplane Field3.81
Nature Preserve4.23
Ned Brown Meadow4.62
North Pool3.43
Osborn Park3.17
Salt Creek Trail4.42
Wildlife Refuge3.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.72
Beisner Road Entrance,3.32
Boat Launch Area,3.28
Busse Lake,4.46
Debra Park,3.73
Elk Pasture,3.57
Forest North Grove,4.54
Lake Boating Center,4.73
Large Event Area,3.87
Main Dam,3.82
Main Pool,4.52
Marshall Park,3.76
Model Airplane Field,3.81
Nature Preserve,4.23
Ned Brown Meadow,4.62
North Pool,3.43
Osborn Park,3.17
Salt Creek Trail,4.42
Wildlife Refuge,3.45

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.55341051 0.00550000 NUM

d10d_99c3

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 Entrance4.33
Boat Launch Area4.74
Debra Park3.63
Elk Pasture2.75
Forest Central Grove4.29
Forest North Grove3.73
Forest South Grove3.86
Forest West Grove3.72
Large Event Area3.91
Main Dam3.92
Main Pool3.82
Marshall Park2.89
Model Airplane Field4.86
Nature Preserve3.42
Ned Brown Meadow3.71
Osborn Park3.86
Salt Creek Trail3.04
South Pool3.80
Wildlife Refuge5.01
Woodland Meadow4.52

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.33
Boat Launch Area,4.74
Debra Park,3.63
Elk Pasture,2.75
Forest Central Grove,4.29
Forest North Grove,3.73
Forest South Grove,3.86
Forest West Grove,3.72
Large Event Area,3.91
Main Dam,3.92
Main Pool,3.82
Marshall Park,2.89
Model Airplane Field,4.86
Nature Preserve,3.42
Ned Brown Meadow,3.71
Osborn Park,3.86
Salt Creek Trail,3.04
South Pool,3.80
Wildlife Refuge,5.01
Woodland Meadow,4.52

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.41440588 0.00410000 NUM

3c83_a148

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 Park4.43
Boat Launch Area3.74
Busse Lake3.67
Forest North Grove3.94
Forest South Grove3.50
Forest West Grove3.49
Lake Boating Center3.44
Large Event Area4.40
Main Dam4.75
Main Pool4.17
Marshall Park4.66
Model Airplane Field4.00
Nature Preserve4.65
Ned Brown Meadow4.25
North Pool5.02
Osborn Park4.16
Salt Creek Trail4.59
South Pool4.93
Wildlife Refuge4.60
Woodland Meadow3.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.43
Boat Launch Area,3.74
Busse Lake,3.67
Forest North Grove,3.94
Forest South Grove,3.50
Forest West Grove,3.49
Lake Boating Center,3.44
Large Event Area,4.40
Main Dam,4.75
Main Pool,4.17
Marshall Park,4.66
Model Airplane Field,4.00
Nature Preserve,4.65
Ned Brown Meadow,4.25
North Pool,5.02
Osborn Park,4.16
Salt Creek Trail,4.59
South Pool,4.93
Wildlife Refuge,4.60
Woodland Meadow,3.94

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.10659344 0.00110000 NUM

e5fc_3a75

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 Park5.44
Busse Lake4.12
Debra Park3.13
Forest Central Grove3.89
Forest South Grove4.70
Forest West Grove4.59
Large Event Area3.85
Main Dam4.29
Main Pool4.20
Marshall Park4.09
Ned Brown Meadow4.54
North Pool4.10
Osborn Park5.51
Salt Creek Trail3.95
South Pool4.03
Wildlife Refuge3.60

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.44
Busse Lake,4.12
Debra Park,3.13
Forest Central Grove,3.89
Forest South Grove,4.70
Forest West Grove,4.59
Large Event Area,3.85
Main Dam,4.29
Main Pool,4.20
Marshall Park,4.09
Ned Brown Meadow,4.54
North Pool,4.10
Osborn Park,5.51
Salt Creek Trail,3.95
South Pool,4.03
Wildlife Refuge,3.60

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.09311957 0.00100000 NUM

439f_62b3

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 Entrance3.27
Busse Lake3.81
Debra Park3.56
Elk Pasture4.33
Forest Central Grove4.56
Forest North Grove2.33
Forest West Grove3.11
Large Event Area3.92
Main Dam3.07
Main Pool3.75
Osborn Park4.64
Salt Creek Trail3.73

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.27
Busse Lake,3.81
Debra Park,3.56
Elk Pasture,4.33
Forest Central Grove,4.56
Forest North Grove,2.33
Forest West Grove,3.11
Large Event Area,3.92
Main Dam,3.07
Main Pool,3.75
Osborn Park,4.64
Salt Creek Trail,3.73

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.05929349 0.00100000 NUM

f34a_016c

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 Park4.21
Beisner Road Entrance4.88
Debra Park4.33
Elk Pasture4.27
Forest West Grove3.47
Large Event Area3.96
Main Dam3.90
Main Pool3.64
Marshall Park5.50
Model Airplane Field4.18
Salt Creek Trail3.93
Woodland Meadow4.82

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.21
Beisner Road Entrance,4.88
Debra Park,4.33
Elk Pasture,4.27
Forest West Grove,3.47
Large Event Area,3.96
Main Dam,3.90
Main Pool,3.64
Marshall Park,5.50
Model Airplane Field,4.18
Salt Creek Trail,3.93
Woodland Meadow,4.82

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.13710016 0.00140000 NUM

dd5a_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 Park5.39
Beisner Road Entrance3.99
Boat Launch Area3.53
Busse Lake3.76
Debra Park3.90
Elk Pasture3.89
Forest South Grove4.47
Large Event Area3.42
Main Dam3.43
Marshall Park4.12
Model Airplane Field4.08
Ned Brown Meadow2.78
North Pool3.33
Osborn Park4.57
Salt Creek Trail2.94
Wildlife Refuge4.63
Woodland Meadow3.90

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.39
Beisner Road Entrance,3.99
Boat Launch Area,3.53
Busse Lake,3.76
Debra Park,3.90
Elk Pasture,3.89
Forest South Grove,4.47
Large Event Area,3.42
Main Dam,3.43
Marshall Park,4.12
Model Airplane Field,4.08
Ned Brown Meadow,2.78
North Pool,3.33
Osborn Park,4.57
Salt Creek Trail,2.94
Wildlife Refuge,4.63
Woodland Meadow,3.90

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.44970754 0.00450000 NUM

e565_dd68

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 Park3.27
Beisner Road Entrance4.23
Boat Launch Area3.27
Busse Lake3.93
Debra Park3.96
Forest Central Grove4.91
Forest North Grove4.94
Forest South Grove3.70
Forest West Grove4.17
Lake Boating Center5.09
Large Event Area3.72
Main Dam3.58
Marshall Park3.61
Model Airplane Field3.47
North Pool3.99
Osborn Park3.29
Salt Creek Trail3.67
South Pool3.51
Wildlife Refuge4.50
Woodland Meadow4.28

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.27
Beisner Road Entrance,4.23
Boat Launch Area,3.27
Busse Lake,3.93
Debra Park,3.96
Forest Central Grove,4.91
Forest North Grove,4.94
Forest South Grove,3.70
Forest West Grove,4.17
Lake Boating Center,5.09
Large Event Area,3.72
Main Dam,3.58
Marshall Park,3.61
Model Airplane Field,3.47
North Pool,3.99
Osborn Park,3.29
Salt Creek Trail,3.67
South Pool,3.51
Wildlife Refuge,4.50
Woodland Meadow,4.28

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.73450654 0.00730000 NUM

fb25_e7a6

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 Park4.32
Beisner Road Entrance4.32
Boat Launch Area5.35
Busse Lake4.21
Debra Park4.56
Elk Pasture4.35
Forest Central Grove4.72
Forest South Grove3.64
Lake Boating Center3.13
Large Event Area4.20
Main Dam3.24
Main Pool4.09
Model Airplane Field4.59
Ned Brown Meadow4.65
North Pool3.88
Salt Creek Trail4.68
South Pool3.05
Wildlife Refuge5.02
Woodland Meadow4.41

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.32
Boat Launch Area,5.35
Busse Lake,4.21
Debra Park,4.56
Elk Pasture,4.35
Forest Central Grove,4.72
Forest South Grove,3.64
Lake Boating Center,3.13
Large Event Area,4.20
Main Dam,3.24
Main Pool,4.09
Model Airplane Field,4.59
Ned Brown Meadow,4.65
North Pool,3.88
Salt Creek Trail,4.68
South Pool,3.05
Wildlife Refuge,5.02
Woodland Meadow,4.41

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.09175620 0.00100000 NUM

0e00_8c10

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 Park4.11
Elk Pasture3.02
Forest South Grove4.65
Forest West Grove4.84
Large Event Area3.96
Main Dam3.99
Nature Preserve5.57
Ned Brown Meadow4.48
North Pool3.73
Osborn Park2.38
South Pool3.89
Wildlife Refuge4.29

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.11
Elk Pasture,3.02
Forest South Grove,4.65
Forest West Grove,4.84
Large Event Area,3.96
Main Dam,3.99
Nature Preserve,5.57
Ned Brown Meadow,4.48
North Pool,3.73
Osborn Park,2.38
South Pool,3.89
Wildlife Refuge,4.29

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.66151391 0.00660000 NUM

eb3e_1833

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 Park4.41
Beisner Road Entrance4.06
Boat Launch Area3.91
Debra Park3.54
Elk Pasture4.41
Forest Central Grove3.59
Forest North Grove5.00
Forest South Grove4.52
Forest West Grove5.22
Large Event Area4.32
Main Dam3.78
Main Pool3.35
Marshall Park4.39
Model Airplane Field4.43
Ned Brown Meadow4.21
North Pool3.61
Osborn Park4.23
South Pool4.76
Wildlife Refuge3.38
Woodland Meadow4.04

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,4.06
Boat Launch Area,3.91
Debra Park,3.54
Elk Pasture,4.41
Forest Central Grove,3.59
Forest North Grove,5.00
Forest South Grove,4.52
Forest West Grove,5.22
Large Event Area,4.32
Main Dam,3.78
Main Pool,3.35
Marshall Park,4.39
Model Airplane Field,4.43
Ned Brown Meadow,4.21
North Pool,3.61
Osborn Park,4.23
South Pool,4.76
Wildlife Refuge,3.38
Woodland Meadow,4.04

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.23893120 0.00240000 NUM

e0e1_a9dc

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 Entrance3.53
Forest Central Grove3.08
Forest North Grove4.50
Forest South Grove2.27
Forest West Grove4.21
Large Event Area3.80
Main Pool4.20
Model Airplane Field3.23
Nature Preserve3.96
North Pool3.70
Osborn Park4.08
Woodland Meadow3.64

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
Forest Central Grove,3.08
Forest North Grove,4.50
Forest South Grove,2.27
Forest West Grove,4.21
Large Event Area,3.80
Main Pool,4.20
Model Airplane Field,3.23
Nature Preserve,3.96
North Pool,3.70
Osborn Park,4.08
Woodland Meadow,3.64

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.06750816 0.00100000 NUM

b62e_09fe

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 Entrance4.46
Debra Park2.20
Forest Central Grove4.12
Forest North Grove3.24
Forest South Grove3.78
Forest West Grove3.38
Large Event Area3.76
Model Airplane Field4.78
Nature Preserve3.58
Osborn Park4.56
Salt Creek Trail3.99
South Pool3.98
Wildlife Refuge4.53
Woodland Meadow3.77

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.46
Debra Park,2.20
Forest Central Grove,4.12
Forest North Grove,3.24
Forest South Grove,3.78
Forest West Grove,3.38
Large Event Area,3.76
Model Airplane Field,4.78
Nature Preserve,3.58
Osborn Park,4.56
Salt Creek Trail,3.99
South Pool,3.98
Wildlife Refuge,4.53
Woodland Meadow,3.77

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.40486492 0.00400000 NUM

fd35_bec0

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 Park4.03
Beisner Road Entrance3.33
Debra Park3.15
Elk Pasture4.95
Forest Central Grove3.44
Forest North Grove3.67
Forest South Grove4.07
Forest West Grove3.54
Large Event Area4.07
Main Dam4.13
Main Pool4.90
Marshall Park4.37
Model Airplane Field5.54
Ned Brown Meadow3.44
North Pool3.39
Osborn Park3.27
Salt Creek Trail3.56
South Pool3.16
Wildlife Refuge4.91
Woodland Meadow4.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.03
Beisner Road Entrance,3.33
Debra Park,3.15
Elk Pasture,4.95
Forest Central Grove,3.44
Forest North Grove,3.67
Forest South Grove,4.07
Forest West Grove,3.54
Large Event Area,4.07
Main Dam,4.13
Main Pool,4.90
Marshall Park,4.37
Model Airplane Field,5.54
Ned Brown Meadow,3.44
North Pool,3.39
Osborn Park,3.27
Salt Creek Trail,3.56
South Pool,3.16
Wildlife Refuge,4.91
Woodland Meadow,4.25

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.75707604 0.00760000 NUM

5821_f114

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 Entrance4.03
Boat Launch Area4.69
Busse Lake3.57
Debra Park5.14
Elk Pasture3.35
Forest Central Grove4.26
Lake Boating Center3.88
Main Dam4.83
Main Pool3.74
Model Airplane Field3.31
Nature Preserve3.84
Ned Brown Meadow4.81
Salt Creek Trail3.74
South Pool3.84
Wildlife Refuge4.11
Woodland Meadow3.36

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.03
Boat Launch Area,4.69
Busse Lake,3.57
Debra Park,5.14
Elk Pasture,3.35
Forest Central Grove,4.26
Lake Boating Center,3.88
Main Dam,4.83
Main Pool,3.74
Model Airplane Field,3.31
Nature Preserve,3.84
Ned Brown Meadow,4.81
Salt Creek Trail,3.74
South Pool,3.84
Wildlife Refuge,4.11
Woodland Meadow,3.36

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.83496871 0.00830000 NUM

8b0d_721c

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 Entrance4.31
Busse Lake4.56
Elk Pasture3.99
Forest North Grove4.44
Forest South Grove4.89
Forest West Grove4.03
Lake Boating Center4.40
Large Event Area4.05
Main Pool3.70
Nature Preserve4.34
Ned Brown Meadow3.43
Salt Creek Trail3.57
South Pool4.34
Woodland Meadow4.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,4.31
Busse Lake,4.56
Elk Pasture,3.99
Forest North Grove,4.44
Forest South Grove,4.89
Forest West Grove,4.03
Lake Boating Center,4.40
Large Event Area,4.05
Main Pool,3.70
Nature Preserve,4.34
Ned Brown Meadow,3.43
Salt Creek Trail,3.57
South Pool,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.28706123 0.00290000 NUM

9471_7f1a

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 Entrance4.65
Boat Launch Area4.32
Busse Lake3.64
Elk Pasture3.47
Forest North Grove4.23
Forest South Grove4.87
Forest West Grove4.88
Lake Boating Center4.38
Large Event Area4.55
Main Pool4.52
Marshall Park4.46
Model Airplane Field4.26
Nature Preserve3.38
Ned Brown Meadow3.92
North Pool4.45
Salt Creek Trail4.40
Wildlife Refuge4.16
Woodland Meadow4.25

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.65
Boat Launch Area,4.32
Busse Lake,3.64
Elk Pasture,3.47
Forest North Grove,4.23
Forest South Grove,4.87
Forest West Grove,4.88
Lake Boating Center,4.38
Large Event Area,4.55
Main Pool,4.52
Marshall Park,4.46
Model Airplane Field,4.26
Nature Preserve,3.38
Ned Brown Meadow,3.92
North Pool,4.45
Salt Creek Trail,4.40
Wildlife Refuge,4.16
Woodland Meadow,4.25

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.05987816 0.00100000 NUM

e6fa_4a8b

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 Entrance3.46
Boat Launch Area4.72
Busse Lake4.05
Debra Park3.48
Lake Boating Center4.86
Main Pool6.00
Marshall Park3.96
Model Airplane Field4.60
Nature Preserve4.24
Ned Brown Meadow4.37
Osborn Park3.42
Woodland Meadow4.77

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.46
Boat Launch Area,4.72
Busse Lake,4.05
Debra Park,3.48
Lake Boating Center,4.86
Main Pool,6.00
Marshall Park,3.96
Model Airplane Field,4.60
Nature Preserve,4.24
Ned Brown Meadow,4.37
Osborn Park,3.42
Woodland Meadow,4.77

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.05864809 0.00100000 NUM

a2a4_b8a3

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 Park3.59
Beisner Road Entrance3.98
Boat Launch Area3.54
Busse Lake4.96
Debra Park3.05
Elk Pasture2.86
Forest Central Grove3.48
Forest North Grove3.66
Forest South Grove4.07
Forest West Grove4.51
Lake Boating Center3.86
Main Dam4.38
Marshall Park3.26
Model Airplane Field4.18
Ned Brown Meadow3.92
North Pool4.21
Wildlife Refuge4.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,3.59
Beisner Road Entrance,3.98
Boat Launch Area,3.54
Busse Lake,4.96
Debra Park,3.05
Elk Pasture,2.86
Forest Central Grove,3.48
Forest North Grove,3.66
Forest South Grove,4.07
Forest West Grove,4.51
Lake Boating Center,3.86
Main Dam,4.38
Marshall Park,3.26
Model Airplane Field,4.18
Ned Brown Meadow,3.92
North Pool,4.21
Wildlife Refuge,4.79

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.49196661 0.00490000 NUM

f10a_3807

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 Park3.36
Beisner Road Entrance4.49
Busse Lake2.31
Forest Central Grove4.13
Forest South Grove3.50
Forest West Grove3.99
Lake Boating Center4.44
Large Event Area4.87
Main Dam3.88
Marshall Park3.17
Nature Preserve4.21
North Pool3.27
Osborn Park4.50
Salt Creek Trail4.25
Wildlife Refuge3.05
Woodland Meadow3.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,3.36
Beisner Road Entrance,4.49
Busse Lake,2.31
Forest Central Grove,4.13
Forest South Grove,3.50
Forest West Grove,3.99
Lake Boating Center,4.44
Large Event Area,4.87
Main Dam,3.88
Marshall Park,3.17
Nature Preserve,4.21
North Pool,3.27
Osborn Park,4.50
Salt Creek Trail,4.25
Wildlife Refuge,3.05
Woodland Meadow,3.62

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.21745143 0.00220000 NUM

91d1_fcbc

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 Area4.45
Busse Lake4.27
Elk Pasture5.11
Large Event Area5.15
Main Dam3.53
Main Pool3.94
Marshall Park4.03
Nature Preserve3.55
North Pool3.67
Osborn Park4.35
Salt Creek Trail5.80
South Pool3.31

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.45
Busse Lake,4.27
Elk Pasture,5.11
Large Event Area,5.15
Main Dam,3.53
Main Pool,3.94
Marshall Park,4.03
Nature Preserve,3.55
North Pool,3.67
Osborn Park,4.35
Salt Creek Trail,5.80
South Pool,3.31

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.12842160 0.00130000 NUM

a3c2_4518

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 Park4.84
Beisner Road Entrance4.05
Boat Launch Area3.18
Busse Lake4.17
Debra Park4.30
Forest Central Grove4.08
Forest North Grove5.05
Forest South Grove3.83
Forest West Grove3.73
Lake Boating Center4.24
Large Event Area4.23
Marshall Park4.63
Model Airplane Field5.10
Nature Preserve3.69
Ned Brown Meadow4.59
Osborn Park3.00

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.84
Beisner Road Entrance,4.05
Boat Launch Area,3.18
Busse Lake,4.17
Debra Park,4.30
Forest Central Grove,4.08
Forest North Grove,5.05
Forest South Grove,3.83
Forest West Grove,3.73
Lake Boating Center,4.24
Large Event Area,4.23
Marshall Park,4.63
Model Airplane Field,5.10
Nature Preserve,3.69
Ned Brown Meadow,4.59
Osborn Park,3.00

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.25882753 0.00260000 NUM

b031_622c

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 Park4.18
Busse Lake3.47
Debra Park4.09
Elk Pasture4.86
Forest Central Grove4.99
Forest South Grove4.55
Forest West Grove3.42
Lake Boating Center4.06
Main Pool5.15
Marshall Park3.91
Model Airplane Field4.89
Ned Brown Meadow4.05
Salt Creek Trail4.51
Wildlife Refuge4.45
Woodland Meadow3.22

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.18
Busse Lake,3.47
Debra Park,4.09
Elk Pasture,4.86
Forest Central Grove,4.99
Forest South Grove,4.55
Forest West Grove,3.42
Lake Boating Center,4.06
Main Pool,5.15
Marshall Park,3.91
Model Airplane Field,4.89
Ned Brown Meadow,4.05
Salt Creek Trail,4.51
Wildlife Refuge,4.45
Woodland Meadow,3.22

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.10199463 0.00100000 NUM

a9c8_8a59

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 Park3.21
Beisner Road Entrance4.78
Boat Launch Area3.95
Busse Lake4.27
Debra Park4.19
Forest South Grove3.99
Lake Boating Center4.31
Main Dam4.93
Main Pool4.06
Marshall Park4.90
Model Airplane Field4.09
Nature Preserve3.97
Ned Brown Meadow3.16
North Pool3.55
Osborn Park4.19
Salt Creek Trail3.16
South Pool4.58
Wildlife Refuge3.92

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.21
Beisner Road Entrance,4.78
Boat Launch Area,3.95
Busse Lake,4.27
Debra Park,4.19
Forest South Grove,3.99
Lake Boating Center,4.31
Main Dam,4.93
Main Pool,4.06
Marshall Park,4.90
Model Airplane Field,4.09
Nature Preserve,3.97
Ned Brown Meadow,3.16
North Pool,3.55
Osborn Park,4.19
Salt Creek Trail,3.16
South Pool,4.58
Wildlife Refuge,3.92

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.63454972 0.00630000 NUM

acd7_515d

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 Entrance5.02
Busse Lake4.56
Debra Park5.09
Elk Pasture3.54
Forest Central Grove4.05
Forest West Grove4.37
Large Event Area4.03
Main Pool3.80
Model Airplane Field3.51
Nature Preserve4.84
Ned Brown Meadow3.94
Osborn Park4.20
Salt Creek Trail3.43
Wildlife Refuge3.96
Woodland Meadow3.87

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,5.02
Busse Lake,4.56
Debra Park,5.09
Elk Pasture,3.54
Forest Central Grove,4.05
Forest West Grove,4.37
Large Event Area,4.03
Main Pool,3.80
Model Airplane Field,3.51
Nature Preserve,4.84
Ned Brown Meadow,3.94
Osborn Park,4.20
Salt Creek Trail,3.43
Wildlife Refuge,3.96
Woodland Meadow,3.87

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.34158784 0.00340000 NUM

0c75_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
Beisner Road Entrance4.56
Busse Lake2.85
Debra Park4.02
Elk Pasture3.60
Forest North Grove4.52
Forest South Grove5.21
Forest West Grove4.37
Lake Boating Center3.92
Large Event Area4.68
Main Dam4.37
Main Pool3.98
Marshall Park4.75
Nature Preserve4.64
Ned Brown Meadow3.55
North Pool4.35
Osborn Park3.56
Salt Creek Trail4.77
South Pool4.68
Wildlife Refuge4.01
Woodland Meadow3.51

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.56
Busse Lake,2.85
Debra Park,4.02
Elk Pasture,3.60
Forest North Grove,4.52
Forest South Grove,5.21
Forest West Grove,4.37
Lake Boating Center,3.92
Large Event Area,4.68
Main Dam,4.37
Main Pool,3.98
Marshall Park,4.75
Nature Preserve,4.64
Ned Brown Meadow,3.55
North Pool,4.35
Osborn Park,3.56
Salt Creek Trail,4.77
South Pool,4.68
Wildlife Refuge,4.01
Woodland Meadow,3.51

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.14610047 0.00150000 NUM

ba2d_482b

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 Area4.42
Busse Lake2.62
Debra Park3.41
Forest North Grove4.00
Forest West Grove4.22
Lake Boating Center3.59
Large Event Area4.03
Marshall Park4.29
Nature Preserve3.69
Ned Brown Meadow3.80
North Pool4.79
Osborn Park3.17
Salt Creek Trail3.42
South Pool4.98
Wildlife Refuge3.26
Woodland Meadow3.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,4.42
Busse Lake,2.62
Debra Park,3.41
Forest North Grove,4.00
Forest West Grove,4.22
Lake Boating Center,3.59
Large Event Area,4.03
Marshall Park,4.29
Nature Preserve,3.69
Ned Brown Meadow,3.80
North Pool,4.79
Osborn Park,3.17
Salt Creek Trail,3.42
South Pool,4.98
Wildlife Refuge,3.26
Woodland Meadow,3.11

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.18242244 0.00180000 NUM

4b18_562b

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 Park4.13
Beisner Road Entrance3.83
Boat Launch Area3.24
Busse Lake4.37
Debra Park4.07
Forest Central Grove3.92
Forest North Grove3.36
Forest West Grove4.57
Lake Boating Center4.37
Large Event Area5.12
Main Dam4.39
Main Pool4.56
Marshall Park3.60
Model Airplane Field4.23
Nature Preserve3.87
Ned Brown Meadow3.00
Osborn Park3.28
South Pool4.50
Wildlife Refuge5.08

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.13
Beisner Road Entrance,3.83
Boat Launch Area,3.24
Busse Lake,4.37
Debra Park,4.07
Forest Central Grove,3.92
Forest North Grove,3.36
Forest West Grove,4.57
Lake Boating Center,4.37
Large Event Area,5.12
Main Dam,4.39
Main Pool,4.56
Marshall Park,3.60
Model Airplane Field,4.23
Nature Preserve,3.87
Ned Brown Meadow,3.00
Osborn Park,3.28
South Pool,4.50
Wildlife Refuge,5.08

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.56887051 0.00570000 NUM

c4bc_ab27

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 Park3.84
Beisner Road Entrance3.92
Boat Launch Area3.31
Debra Park4.45
Elk Pasture4.09
Forest Central Grove3.58
Forest North Grove3.83
Forest West Grove3.91
Lake Boating Center4.40
Main Dam3.52
Marshall Park4.11
Nature Preserve3.16
Ned Brown Meadow4.28
North Pool4.63
Osborn Park4.20
South Pool3.78
Woodland Meadow4.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,3.84
Beisner Road Entrance,3.92
Boat Launch Area,3.31
Debra Park,4.45
Elk Pasture,4.09
Forest Central Grove,3.58
Forest North Grove,3.83
Forest West Grove,3.91
Lake Boating Center,4.40
Main Dam,3.52
Marshall Park,4.11
Nature Preserve,3.16
Ned Brown Meadow,4.28
North Pool,4.63
Osborn Park,4.20
South Pool,3.78
Woodland Meadow,4.25

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.76484294 0.00760000 NUM

b919_4f74

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 Park4.05
Forest Central Grove4.80
Forest North Grove4.33
Forest South Grove3.14
Forest West Grove4.35
Large Event Area4.04
Main Dam3.71
Main Pool4.10
Marshall Park4.22
Nature Preserve3.98
Osborn Park4.28
Salt Creek Trail3.66
South Pool3.50
Wildlife Refuge3.12
Woodland Meadow3.72

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
Forest Central Grove,4.80
Forest North Grove,4.33
Forest South Grove,3.14
Forest West Grove,4.35
Large Event Area,4.04
Main Dam,3.71
Main Pool,4.10
Marshall Park,4.22
Nature Preserve,3.98
Osborn Park,4.28
Salt Creek Trail,3.66
South Pool,3.50
Wildlife Refuge,3.12
Woodland Meadow,3.72

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.66695453 0.00670000 NUM

9c92_a60a

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 Area4.37
Debra Park4.77
Forest Central Grove3.72
Forest North Grove3.19
Forest South Grove2.99
Forest West Grove4.23
Lake Boating Center4.13
Model Airplane Field3.59
Ned Brown Meadow3.21
North Pool2.51
South Pool4.91
Woodland Meadow4.09

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.37
Debra Park,4.77
Forest Central Grove,3.72
Forest North Grove,3.19
Forest South Grove,2.99
Forest West Grove,4.23
Lake Boating Center,4.13
Model Airplane Field,3.59
Ned Brown Meadow,3.21
North Pool,2.51
South Pool,4.91
Woodland Meadow,4.09

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.27055873 0.00270000 NUM

0656_7d0d

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 Park3.31
Beisner Road Entrance3.79
Boat Launch Area4.31
Busse Lake4.61
Elk Pasture4.01
Forest Central Grove3.49
Forest North Grove3.81
Forest South Grove4.02
Forest West Grove3.76
Lake Boating Center3.73
Large Event Area4.18
Main Pool4.09
Marshall Park3.65
Nature Preserve4.30
Ned Brown Meadow3.81
Osborn Park2.30
Woodland Meadow3.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,3.31
Beisner Road Entrance,3.79
Boat Launch Area,4.31
Busse Lake,4.61
Elk Pasture,4.01
Forest Central Grove,3.49
Forest North Grove,3.81
Forest South Grove,4.02
Forest West Grove,3.76
Lake Boating Center,3.73
Large Event Area,4.18
Main Pool,4.09
Marshall Park,3.65
Nature Preserve,4.30
Ned Brown Meadow,3.81
Osborn Park,2.30
Woodland Meadow,3.94

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.24272075 0.00240000 NUM

d8eb_f7ae

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 Area4.17
Debra Park3.33
Elk Pasture3.56
Forest Central Grove3.83
Forest North Grove2.96
Lake Boating Center4.08
Large Event Area3.47
Main Pool3.33
Model Airplane Field4.06
Ned Brown Meadow3.75
North Pool4.51
Osborn Park5.06
Woodland Meadow2.66

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.17
Debra Park,3.33
Elk Pasture,3.56
Forest Central Grove,3.83
Forest North Grove,2.96
Lake Boating Center,4.08
Large Event Area,3.47
Main Pool,3.33
Model Airplane Field,4.06
Ned Brown Meadow,3.75
North Pool,4.51
Osborn Park,5.06
Woodland Meadow,2.66

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.13541938 0.00140000 NUM

852f_f45b

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 Park4.38
Boat Launch Area2.95
Debra Park4.29
Forest North Grove3.41
Forest South Grove5.20
Lake Boating Center5.22
Main Dam3.35
Main Pool4.51
Marshall Park4.74
Model Airplane Field3.83
Nature Preserve3.94
South Pool3.65
Woodland Meadow4.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.38
Boat Launch Area,2.95
Debra Park,4.29
Forest North Grove,3.41
Forest South Grove,5.20
Lake Boating Center,5.22
Main Dam,3.35
Main Pool,4.51
Marshall Park,4.74
Model Airplane Field,3.83
Nature Preserve,3.94
South Pool,3.65
Woodland Meadow,4.69

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.31805618 0.00320000 NUM

e72f_7bad

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 Park4.00
Beisner Road Entrance4.96
Boat Launch Area4.37
Busse Lake3.77
Debra Park4.48
Forest Central Grove5.33
Forest West Grove4.06
Lake Boating Center4.16
Large Event Area4.42
Main Dam3.82
Model Airplane Field3.63
Ned Brown Meadow4.52
North Pool4.37
Salt Creek Trail3.53
South Pool4.60
Woodland Meadow4.35

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,4.96
Boat Launch Area,4.37
Busse Lake,3.77
Debra Park,4.48
Forest Central Grove,5.33
Forest West Grove,4.06
Lake Boating Center,4.16
Large Event Area,4.42
Main Dam,3.82
Model Airplane Field,3.63
Ned Brown Meadow,4.52
North Pool,4.37
Salt Creek Trail,3.53
South Pool,4.60
Woodland Meadow,4.35

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.06863220 0.00100000 NUM

f30e_9578

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 Park3.47
Beisner Road Entrance3.06
Boat Launch Area3.70
Busse Lake3.62
Elk Pasture3.89
Forest Central Grove4.43
Forest North Grove4.79
Forest South Grove3.80
Forest West Grove3.21
Lake Boating Center3.53
Large Event Area4.47
Marshall Park3.68
North Pool4.31
Osborn Park4.16
Wildlife Refuge4.13
Woodland Meadow4.40

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.47
Beisner Road Entrance,3.06
Boat Launch Area,3.70
Busse Lake,3.62
Elk Pasture,3.89
Forest Central Grove,4.43
Forest North Grove,4.79
Forest South Grove,3.80
Forest West Grove,3.21
Lake Boating Center,3.53
Large Event Area,4.47
Marshall Park,3.68
North Pool,4.31
Osborn Park,4.16
Wildlife Refuge,4.13
Woodland Meadow,4.40

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.57377540 0.00570000 NUM

7186_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 Park5.76
Debra Park3.30
Forest South Grove3.37
Lake Boating Center4.87
Large Event Area4.89
Main Dam3.49
Main Pool3.35
Marshall Park4.47
Model Airplane Field3.31
Nature Preserve4.11
Ned Brown Meadow3.74
North Pool3.75
Osborn Park4.21
Salt Creek Trail4.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,5.76
Debra Park,3.30
Forest South Grove,3.37
Lake Boating Center,4.87
Large Event Area,4.89
Main Dam,3.49
Main Pool,3.35
Marshall Park,4.47
Model Airplane Field,3.31
Nature Preserve,4.11
Ned Brown Meadow,3.74
North Pool,3.75
Osborn Park,4.21
Salt Creek Trail,4.54

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.60536206 0.00610000 NUM

5f0e_6a62

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 Park3.77
Beisner Road Entrance4.57
Busse Lake3.87
Debra Park2.72
Forest North Grove3.60
Forest West Grove3.16
Large Event Area4.02
Main Dam3.60
Main Pool3.93
Marshall Park4.03
Model Airplane Field3.65
Ned Brown Meadow3.34
North Pool5.50
Salt Creek Trail4.32
Wildlife Refuge5.12
Woodland Meadow3.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,3.77
Beisner Road Entrance,4.57
Busse Lake,3.87
Debra Park,2.72
Forest North Grove,3.60
Forest West Grove,3.16
Large Event Area,4.02
Main Dam,3.60
Main Pool,3.93
Marshall Park,4.03
Model Airplane Field,3.65
Ned Brown Meadow,3.34
North Pool,5.50
Salt Creek Trail,4.32
Wildlife Refuge,5.12
Woodland Meadow,3.62

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.62295501 0.00620000 NUM

f383_1bf2

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 Area4.13
Busse Lake3.57
Debra Park4.49
Elk Pasture5.15
Forest South Grove4.96
Large Event Area4.60
Marshall Park3.92
Model Airplane Field3.05
Ned Brown Meadow4.58
North Pool3.25
Osborn Park4.19
Salt Creek Trail4.50
South Pool4.00
Wildlife Refuge4.19

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.13
Busse Lake,3.57
Debra Park,4.49
Elk Pasture,5.15
Forest South Grove,4.96
Large Event Area,4.60
Marshall Park,3.92
Model Airplane Field,3.05
Ned Brown Meadow,4.58
North Pool,3.25
Osborn Park,4.19
Salt Creek Trail,4.50
South Pool,4.00
Wildlife Refuge,4.19

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.25046390 0.00250000 NUM

e007_2174

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 Area4.39
Busse Lake3.13
Debra Park4.04
Elk Pasture4.13
Forest Central Grove4.50
Forest South Grove3.73
Forest West Grove3.88
Lake Boating Center3.74
Large Event Area4.63
Main Dam3.52
Main Pool3.47
Marshall Park4.34
Model Airplane Field3.65
Ned Brown Meadow4.15
North Pool3.69
Salt Creek Trail4.63
South Pool3.59
Wildlife Refuge4.44
Woodland Meadow3.69

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.39
Busse Lake,3.13
Debra Park,4.04
Elk Pasture,4.13
Forest Central Grove,4.50
Forest South Grove,3.73
Forest West Grove,3.88
Lake Boating Center,3.74
Large Event Area,4.63
Main Dam,3.52
Main Pool,3.47
Marshall Park,4.34
Model Airplane Field,3.65
Ned Brown Meadow,4.15
North Pool,3.69
Salt Creek Trail,4.63
South Pool,3.59
Wildlife Refuge,4.44
Woodland Meadow,3.69

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.80076490 0.00800000 NUM

2f9f_108b

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 Park3.08
Boat Launch Area3.97
Elk Pasture4.04
Forest Central Grove3.64
Forest North Grove4.75
Forest West Grove3.16
Large Event Area4.06
Main Dam3.28
Marshall Park4.91
Model Airplane Field4.27
North Pool4.30
Osborn Park3.20
Wildlife Refuge3.28
Woodland Meadow4.09

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.08
Boat Launch Area,3.97
Elk Pasture,4.04
Forest Central Grove,3.64
Forest North Grove,4.75
Forest West Grove,3.16
Large Event Area,4.06
Main Dam,3.28
Marshall Park,4.91
Model Airplane Field,4.27
North Pool,4.30
Osborn Park,3.20
Wildlife Refuge,3.28
Woodland Meadow,4.09

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.38021091 0.00380000 NUM

feba_b817

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 Park4.55
Boat Launch Area4.73
Debra Park5.13
Elk Pasture4.08
Forest North Grove4.35
Forest South Grove4.61
Forest West Grove4.09
Main Dam4.07
Model Airplane Field3.87
Nature Preserve3.74
Ned Brown Meadow3.77
North Pool4.98
Salt Creek Trail4.08
Wildlife Refuge3.07
Woodland Meadow3.80

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
Boat Launch Area,4.73
Debra Park,5.13
Elk Pasture,4.08
Forest North Grove,4.35
Forest South Grove,4.61
Forest West Grove,4.09
Main Dam,4.07
Model Airplane Field,3.87
Nature Preserve,3.74
Ned Brown Meadow,3.77
North Pool,4.98
Salt Creek Trail,4.08
Wildlife Refuge,3.07
Woodland Meadow,3.80

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.20891013 0.00210000 NUM

1d8a_4aa5

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 Entrance2.90
Boat Launch Area4.34
Busse Lake4.72
Debra Park4.18
Elk Pasture4.00
Forest Central Grove4.31
Forest North Grove3.87
Forest South Grove3.57
Forest West Grove4.14
Large Event Area4.34
Main Dam3.83
Main Pool4.39
Marshall Park4.43
Model Airplane Field3.98
Nature Preserve2.94
Ned Brown Meadow4.06
North Pool4.43
Salt Creek Trail4.08
South Pool3.58
Woodland Meadow4.44

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.90
Boat Launch Area,4.34
Busse Lake,4.72
Debra Park,4.18
Elk Pasture,4.00
Forest Central Grove,4.31
Forest North Grove,3.87
Forest South Grove,3.57
Forest West Grove,4.14
Large Event Area,4.34
Main Dam,3.83
Main Pool,4.39
Marshall Park,4.43
Model Airplane Field,3.98
Nature Preserve,2.94
Ned Brown Meadow,4.06
North Pool,4.43
Salt Creek Trail,4.08
South Pool,3.58
Woodland Meadow,4.44

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.84342115 0.00840000 NUM

220d_7d0d

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 Park4.59
Beisner Road Entrance3.90
Boat Launch Area3.75
Busse Lake3.23
Forest Central Grove3.71
Forest North Grove4.14
Large Event Area3.51
Marshall Park4.66
Model Airplane Field4.69
Ned Brown Meadow3.95
North Pool3.21
Salt Creek Trail3.03
Wildlife Refuge3.27
Woodland Meadow3.74

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,3.90
Boat Launch Area,3.75
Busse Lake,3.23
Forest Central Grove,3.71
Forest North Grove,4.14
Large Event Area,3.51
Marshall Park,4.66
Model Airplane Field,4.69
Ned Brown Meadow,3.95
North Pool,3.21
Salt Creek Trail,3.03
Wildlife Refuge,3.27
Woodland Meadow,3.74

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.24319391 0.00240000 NUM

000e_4fe9

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 Entrance5.04
Boat Launch Area4.10
Busse Lake4.73
Debra Park4.38
Forest Central Grove3.41
Forest North Grove4.04
Forest South Grove3.92
Forest West Grove4.17
Lake Boating Center4.73
Large Event Area4.09
Main Pool4.63
Marshall Park3.10
Model Airplane Field4.24
Nature Preserve3.82
Ned Brown Meadow4.56
North Pool4.42
Osborn Park3.96
Salt Creek Trail4.30
South Pool4.19
Wildlife Refuge4.21

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,5.04
Boat Launch Area,4.10
Busse Lake,4.73
Debra Park,4.38
Forest Central Grove,3.41
Forest North Grove,4.04
Forest South Grove,3.92
Forest West Grove,4.17
Lake Boating Center,4.73
Large Event Area,4.09
Main Pool,4.63
Marshall Park,3.10
Model Airplane Field,4.24
Nature Preserve,3.82
Ned Brown Meadow,4.56
North Pool,4.42
Osborn Park,3.96
Salt Creek Trail,4.30
South Pool,4.19
Wildlife Refuge,4.21

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.13216498 0.00130000 NUM

d976_382d

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 Area3.59
Busse Lake3.62
Debra Park4.31
Elk Pasture3.99
Forest Central Grove3.73
Forest North Grove3.92
Forest West Grove3.93
Large Event Area3.35
Main Dam3.07
Main Pool4.60
Marshall Park2.97
Model Airplane Field3.79
Ned Brown Meadow4.28
North Pool3.61
Osborn Park4.26
Salt Creek Trail3.95
South Pool4.08
Wildlife Refuge3.20
Woodland Meadow4.28

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.59
Busse Lake,3.62
Debra Park,4.31
Elk Pasture,3.99
Forest Central Grove,3.73
Forest North Grove,3.92
Forest West Grove,3.93
Large Event Area,3.35
Main Dam,3.07
Main Pool,4.60
Marshall Park,2.97
Model Airplane Field,3.79
Ned Brown Meadow,4.28
North Pool,3.61
Osborn Park,4.26
Salt Creek Trail,3.95
South Pool,4.08
Wildlife Refuge,3.20
Woodland Meadow,4.28

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.18457893 0.00180000 NUM

cf66_ea5c

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 Area3.74
Debra Park4.79
Elk Pasture6.00
Forest South Grove3.35
Forest West Grove3.67
Model Airplane Field3.22
Nature Preserve3.69
Ned Brown Meadow4.36
North Pool4.49
Osborn Park4.73
Salt Creek Trail3.63
South Pool4.70
Wildlife Refuge4.56

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.74
Debra Park,4.79
Elk Pasture,6.00
Forest South Grove,3.35
Forest West Grove,3.67
Model Airplane Field,3.22
Nature Preserve,3.69
Ned Brown Meadow,4.36
North Pool,4.49
Osborn Park,4.73
Salt Creek Trail,3.63
South Pool,4.70
Wildlife Refuge,4.56

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.17561104 0.00180000 NUM

3eb8_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 Park4.13
Beisner Road Entrance4.64
Boat Launch Area3.87
Busse Lake4.21
Elk Pasture4.28
Forest Central Grove3.81
Forest North Grove4.89
Forest West Grove2.72
Large Event Area4.12
Main Pool3.75
Model Airplane Field3.48
Osborn Park4.11
Salt Creek Trail3.45
South Pool3.35
Wildlife Refuge3.29
Woodland Meadow3.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,4.13
Beisner Road Entrance,4.64
Boat Launch Area,3.87
Busse Lake,4.21
Elk Pasture,4.28
Forest Central Grove,3.81
Forest North Grove,4.89
Forest West Grove,2.72
Large Event Area,4.12
Main Pool,3.75
Model Airplane Field,3.48
Osborn Park,4.11
Salt Creek Trail,3.45
South Pool,3.35
Wildlife Refuge,3.29
Woodland Meadow,3.78

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.37705620 0.00380000 NUM

b15b_2712

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 Park5.11
Boat Launch Area3.54
Busse Lake4.17
Elk Pasture3.63
Forest South Grove4.43
Forest West Grove3.13
Lake Boating Center4.89
Large Event Area3.55
Main Dam3.52
Main Pool4.25
Marshall Park4.73
North Pool5.20
Salt Creek Trail3.92
Wildlife Refuge4.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,5.11
Boat Launch Area,3.54
Busse Lake,4.17
Elk Pasture,3.63
Forest South Grove,4.43
Forest West Grove,3.13
Lake Boating Center,4.89
Large Event Area,3.55
Main Dam,3.52
Main Pool,4.25
Marshall Park,4.73
North Pool,5.20
Salt Creek Trail,3.92
Wildlife Refuge,4.20

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.31195021 0.00310000 NUM

32ce_dc57

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 Park3.53
Beisner Road Entrance2.61
Boat Launch Area4.35
Busse Lake3.79
Debra Park5.21
Forest Central Grove4.27
Forest North Grove4.18
Forest West Grove4.46
Lake Boating Center3.52
Main Dam3.29
Main Pool4.23
Marshall Park5.33
Model Airplane Field4.39
Nature Preserve4.26
North Pool3.46
Osborn Park4.32
Salt Creek Trail5.26
South Pool4.04
Wildlife Refuge5.27

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.53
Beisner Road Entrance,2.61
Boat Launch Area,4.35
Busse Lake,3.79
Debra Park,5.21
Forest Central Grove,4.27
Forest North Grove,4.18
Forest West Grove,4.46
Lake Boating Center,3.52
Main Dam,3.29
Main Pool,4.23
Marshall Park,5.33
Model Airplane Field,4.39
Nature Preserve,4.26
North Pool,3.46
Osborn Park,4.32
Salt Creek Trail,5.26
South Pool,4.04
Wildlife Refuge,5.27

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.14944474 0.00150000 NUM

1e5e_ca04

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 Park4.38
Boat Launch Area4.11
Busse Lake4.52
Elk Pasture3.55
Forest Central Grove3.67
Forest North Grove4.46
Forest West Grove4.46
Lake Boating Center3.77
Large Event Area5.06
Main Pool2.66
Marshall Park4.04
Model Airplane Field3.58
Ned Brown Meadow3.91
Osborn Park4.43
Salt Creek Trail4.59
South Pool3.88
Wildlife Refuge4.18
Woodland Meadow4.05

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.38
Boat Launch Area,4.11
Busse Lake,4.52
Elk Pasture,3.55
Forest Central Grove,3.67
Forest North Grove,4.46
Forest West Grove,4.46
Lake Boating Center,3.77
Large Event Area,5.06
Main Pool,2.66
Marshall Park,4.04
Model Airplane Field,3.58
Ned Brown Meadow,3.91
Osborn Park,4.43
Salt Creek Trail,4.59
South Pool,3.88
Wildlife Refuge,4.18
Woodland Meadow,4.05

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.60956938 0.00610000 NUM

340c_b627

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 Entrance3.61
Busse Lake3.27
Elk Pasture4.97
Forest Central Grove4.22
Large Event Area3.98
Main Dam3.12
Nature Preserve4.98
North Pool3.27
Osborn Park3.86
Salt Creek Trail4.42
Wildlife Refuge3.97
Woodland Meadow3.14

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.61
Busse Lake,3.27
Elk Pasture,4.97
Forest Central Grove,4.22
Large Event Area,3.98
Main Dam,3.12
Nature Preserve,4.98
North Pool,3.27
Osborn Park,3.86
Salt Creek Trail,4.42
Wildlife Refuge,3.97
Woodland Meadow,3.14

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.56695686 0.00570000 NUM

a7bf_ca07

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 Park4.71
Beisner Road Entrance3.44
Boat Launch Area4.35
Debra Park4.30
Forest Central Grove4.15
Forest North Grove4.45
Forest South Grove4.32
Forest West Grove4.10
Large Event Area3.97
Main Pool5.29
Marshall Park4.00
Model Airplane Field4.82
Ned Brown Meadow2.96
North Pool4.57
Osborn Park4.08
Salt Creek Trail3.75
South Pool3.33
Wildlife Refuge4.38
Woodland Meadow3.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,4.71
Beisner Road Entrance,3.44
Boat Launch Area,4.35
Debra Park,4.30
Forest Central Grove,4.15
Forest North Grove,4.45
Forest South Grove,4.32
Forest West Grove,4.10
Large Event Area,3.97
Main Pool,5.29
Marshall Park,4.00
Model Airplane Field,4.82
Ned Brown Meadow,2.96
North Pool,4.57
Osborn Park,4.08
Salt Creek Trail,3.75
South Pool,3.33
Wildlife Refuge,4.38
Woodland Meadow,3.45

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.35480461 0.00350000 NUM

f640_69d4

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 Park3.28
Boat Launch Area3.51
Busse Lake4.61
Forest South Grove4.29
Lake Boating Center3.79
Large Event Area5.11
Main Dam5.12
Main Pool4.14
Model Airplane Field4.40
North Pool4.10
Salt Creek Trail5.33
South Pool4.41
Wildlife Refuge4.38
Woodland Meadow3.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,3.28
Boat Launch Area,3.51
Busse Lake,4.61
Forest South Grove,4.29
Lake Boating Center,3.79
Large Event Area,5.11
Main Dam,5.12
Main Pool,4.14
Model Airplane Field,4.40
North Pool,4.10
Salt Creek Trail,5.33
South Pool,4.41
Wildlife Refuge,4.38
Woodland Meadow,3.76

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.05953904 0.00100000 NUM

581e_b92b

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 Park2.81
Beisner Road Entrance3.39
Busse Lake4.41
Debra Park3.85
Elk Pasture4.03
Forest Central Grove4.60
Forest North Grove3.73
Forest South Grove3.70
Lake Boating Center4.66
Large Event Area3.32
Main Dam3.55
Main Pool2.74
Marshall Park3.37
Model Airplane Field4.11
Nature Preserve4.61
Ned Brown Meadow4.58
North Pool3.10
Osborn Park3.71
Salt Creek Trail3.71
Woodland Meadow3.96

Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.

Sample Location 2024 Shannon Index
Andrews Park,2.81
Beisner Road Entrance,3.39
Busse Lake,4.41
Debra Park,3.85
Elk Pasture,4.03
Forest Central Grove,4.60
Forest North Grove,3.73
Forest South Grove,3.70
Lake Boating Center,4.66
Large Event Area,3.32
Main Dam,3.55
Main Pool,2.74
Marshall Park,3.37
Model Airplane Field,4.11
Nature Preserve,4.61
Ned Brown Meadow,4.58
North Pool,3.10
Osborn Park,3.71
Salt Creek Trail,3.71
Woodland Meadow,3.96

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.13026120 0.00130000 NUM

b9ff_17d4

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 Park4.12
Beisner Road Entrance4.15
Boat Launch Area3.75
Busse Lake4.27
Elk Pasture4.57
Forest Central Grove3.51
Forest West Grove4.74
Lake Boating Center3.89
Large Event Area4.81
Main Dam4.11
Main Pool4.33
Marshall Park3.41
Model Airplane Field4.59
Nature Preserve3.78
Ned Brown Meadow3.66
North Pool4.07
Osborn Park4.89
Salt Creek Trail3.52
South Pool3.70
Wildlife Refuge4.09

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.12
Beisner Road Entrance,4.15
Boat Launch Area,3.75
Busse Lake,4.27
Elk Pasture,4.57
Forest Central Grove,3.51
Forest West Grove,4.74
Lake Boating Center,3.89
Large Event Area,4.81
Main Dam,4.11
Main Pool,4.33
Marshall Park,3.41
Model Airplane Field,4.59
Nature Preserve,3.78
Ned Brown Meadow,3.66
North Pool,4.07
Osborn Park,4.89
Salt Creek Trail,3.52
South Pool,3.70
Wildlife Refuge,4.09

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.46511585 0.00470000 NUM

f07b_0672

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 Area3.93
Busse Lake3.66
Forest Central Grove3.86
Forest South Grove4.30
Forest West Grove2.92
Lake Boating Center4.10
Large Event Area3.31
Main Dam4.50
Main Pool4.23
Marshall Park4.73
Model Airplane Field4.20
Nature Preserve3.88
Ned Brown Meadow3.30
North Pool3.99
Osborn Park4.22
Salt Creek Trail3.06
South Pool3.99
Wildlife Refuge3.36
Woodland Meadow4.23

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
Busse Lake,3.66
Forest Central Grove,3.86
Forest South Grove,4.30
Forest West Grove,2.92
Lake Boating Center,4.10
Large Event Area,3.31
Main Dam,4.50
Main Pool,4.23
Marshall Park,4.73
Model Airplane Field,4.20
Nature Preserve,3.88
Ned Brown Meadow,3.30
North Pool,3.99
Osborn Park,4.22
Salt Creek Trail,3.06
South Pool,3.99
Wildlife Refuge,3.36
Woodland Meadow,4.23

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.39384687 0.00390000 NUM

2f46_4144

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 Entrance4.82
Boat Launch Area3.68
Busse Lake4.88
Elk Pasture5.10
Forest Central Grove4.55
Forest South Grove3.60
Forest West Grove4.59
Lake Boating Center4.66
Large Event Area4.16
Main Pool3.63
Model Airplane Field3.69
Nature Preserve4.50
Ned Brown Meadow4.17
North Pool3.48
Osborn Park4.14
South Pool3.79
Woodland Meadow4.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,4.82
Boat Launch Area,3.68
Busse Lake,4.88
Elk Pasture,5.10
Forest Central Grove,4.55
Forest South Grove,3.60
Forest West Grove,4.59
Lake Boating Center,4.66
Large Event Area,4.16
Main Pool,3.63
Model Airplane Field,3.69
Nature Preserve,4.50
Ned Brown Meadow,4.17
North Pool,3.48
Osborn Park,4.14
South Pool,3.79
Woodland Meadow,4.53

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.10854280 0.00110000 NUM

c4ab_b0dc

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 Park3.41
Beisner Road Entrance3.94
Boat Launch Area4.65
Busse Lake3.65
Debra Park4.18
Elk Pasture3.66
Forest Central Grove4.65
Forest North Grove3.28
Lake Boating Center3.64
Large Event Area3.69
Main Dam4.87
Main Pool4.62
Marshall Park4.69
Model Airplane Field3.76
Nature Preserve4.84
North Pool3.53
Osborn Park3.11
Salt Creek Trail3.81
Woodland Meadow3.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,3.41
Beisner Road Entrance,3.94
Boat Launch Area,4.65
Busse Lake,3.65
Debra Park,4.18
Elk Pasture,3.66
Forest Central Grove,4.65
Forest North Grove,3.28
Lake Boating Center,3.64
Large Event Area,3.69
Main Dam,4.87
Main Pool,4.62
Marshall Park,4.69
Model Airplane Field,3.76
Nature Preserve,4.84
North Pool,3.53
Osborn Park,3.11
Salt Creek Trail,3.81
Woodland Meadow,3.76

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.92080998 0.00920000 NUM

9099_b72f

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 Entrance4.90
Busse Lake4.29
Debra Park4.12
Elk Pasture3.40
Forest Central Grove4.40
Forest North Grove5.40
Forest South Grove3.34
Forest West Grove3.83
Marshall Park4.69
Model Airplane Field3.78
Nature Preserve4.64
Ned Brown Meadow3.97
Osborn Park4.69
Salt Creek Trail3.94
South Pool4.00
Wildlife Refuge3.15
Woodland Meadow4.01

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.90
Busse Lake,4.29
Debra Park,4.12
Elk Pasture,3.40
Forest Central Grove,4.40
Forest North Grove,5.40
Forest South Grove,3.34
Forest West Grove,3.83
Marshall Park,4.69
Model Airplane Field,3.78
Nature Preserve,4.64
Ned Brown Meadow,3.97
Osborn Park,4.69
Salt Creek Trail,3.94
South Pool,4.00
Wildlife Refuge,3.15
Woodland Meadow,4.01

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.30264568 0.00300000 NUM

ae47_b259

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 Park3.72
Beisner Road Entrance4.03
Boat Launch Area4.50
Debra Park5.04
Forest North Grove3.80
Forest South Grove3.75
Forest West Grove5.44
Main Dam3.51
Main Pool3.85
Nature Preserve5.14
Ned Brown Meadow3.91
North Pool3.98
Osborn Park4.49
South Pool4.01
Wildlife Refuge4.93
Woodland Meadow4.14

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.72
Beisner Road Entrance,4.03
Boat Launch Area,4.50
Debra Park,5.04
Forest North Grove,3.80
Forest South Grove,3.75
Forest West Grove,5.44
Main Dam,3.51
Main Pool,3.85
Nature Preserve,5.14
Ned Brown Meadow,3.91
North Pool,3.98
Osborn Park,4.49
South Pool,4.01
Wildlife Refuge,4.93
Woodland Meadow,4.14

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.07728407 0.00100000 NUM

841a_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
Boat Launch Area3.50
Busse Lake3.11
Forest West Grove4.13
Lake Boating Center3.11
Main Pool3.93
Marshall Park4.15
Nature Preserve4.73
North Pool4.62
Osborn Park4.44
Salt Creek Trail3.86
South Pool4.95
Woodland Meadow3.73

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.50
Busse Lake,3.11
Forest West Grove,4.13
Lake Boating Center,3.11
Main Pool,3.93
Marshall Park,4.15
Nature Preserve,4.73
North Pool,4.62
Osborn Park,4.44
Salt Creek Trail,3.86
South Pool,4.95
Woodland Meadow,3.73

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.90045027 0.00900000 NUM

35c3_5cee

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 Park4.10
Beisner Road Entrance3.89
Boat Launch Area5.11
Busse Lake4.09
Debra Park3.76
Elk Pasture4.70
Forest West Grove4.44
Large Event Area3.96
Main Dam4.47
Main Pool3.29
Model Airplane Field3.13
North Pool4.05
Salt Creek Trail3.80
South Pool4.12
Woodland Meadow4.86

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.10
Beisner Road Entrance,3.89
Boat Launch Area,5.11
Busse Lake,4.09
Debra Park,3.76
Elk Pasture,4.70
Forest West Grove,4.44
Large Event Area,3.96
Main Dam,4.47
Main Pool,3.29
Model Airplane Field,3.13
North Pool,4.05
Salt Creek Trail,3.80
South Pool,4.12
Woodland Meadow,4.86

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.44624700 0.00450000 NUM

8d91_5c6e

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 Park4.54
Boat Launch Area3.54
Busse Lake4.65
Debra Park3.71
Forest Central Grove3.57
Forest North Grove4.28
Forest West Grove3.04
Lake Boating Center3.81
Large Event Area3.40
Main Dam3.81
Marshall Park3.04
Model Airplane Field4.09
North Pool3.29
Osborn Park5.19
Salt Creek Trail4.24
South Pool4.28
Wildlife Refuge4.23
Woodland Meadow4.58

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.54
Boat Launch Area,3.54
Busse Lake,4.65
Debra Park,3.71
Forest Central Grove,3.57
Forest North Grove,4.28
Forest West Grove,3.04
Lake Boating Center,3.81
Large Event Area,3.40
Main Dam,3.81
Marshall Park,3.04
Model Airplane Field,4.09
North Pool,3.29
Osborn Park,5.19
Salt Creek Trail,4.24
South Pool,4.28
Wildlife Refuge,4.23
Woodland Meadow,4.58

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.78031056 0.00780000 NUM

44f6_5b80

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 Entrance4.37
Boat Launch Area4.60
Busse Lake5.01
Forest Central Grove4.42
Forest North Grove3.75
Forest South Grove4.01
Lake Boating Center4.14
Large Event Area5.30
Main Pool3.00
Marshall Park4.02
Model Airplane Field3.85
Nature Preserve3.56
Ned Brown Meadow3.44
South Pool3.98
Wildlife Refuge2.75

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.37
Boat Launch Area,4.60
Busse Lake,5.01
Forest Central Grove,4.42
Forest North Grove,3.75
Forest South Grove,4.01
Lake Boating Center,4.14
Large Event Area,5.30
Main Pool,3.00
Marshall Park,4.02
Model Airplane Field,3.85
Nature Preserve,3.56
Ned Brown Meadow,3.44
South Pool,3.98
Wildlife Refuge,2.75

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.93141372 0.00930000 NUM

3fa8_fd80

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
Debra Park3.98
Elk Pasture3.57
Forest Central Grove4.23
Lake Boating Center3.73
Large Event Area3.40
Main Dam3.89
Main Pool3.94
Marshall Park2.91
Model Airplane Field3.83
North Pool3.84
Osborn Park3.10
Salt Creek Trail4.43
South Pool4.24
Wildlife Refuge4.10

Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.

Sample Location 2024 Shannon Index
Debra Park,3.98
Elk Pasture,3.57
Forest Central Grove,4.23
Lake Boating Center,3.73
Large Event Area,3.40
Main Dam,3.89
Main Pool,3.94
Marshall Park,2.91
Model Airplane Field,3.83
North Pool,3.84
Osborn Park,3.10
Salt Creek Trail,4.43
South Pool,4.24
Wildlife Refuge,4.10

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.21068887 0.00210000 NUM

f4f8_b92b

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 Park4.02
Beisner Road Entrance3.56
Boat Launch Area4.72
Busse Lake5.02
Debra Park4.09
Forest Central Grove2.69
Forest North Grove4.78
Forest West Grove3.93
Large Event Area4.59
Main Pool4.34
Marshall Park4.40
Nature Preserve4.36
Ned Brown Meadow4.25
Salt Creek Trail4.14
Woodland Meadow4.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.02
Beisner Road Entrance,3.56
Boat Launch Area,4.72
Busse Lake,5.02
Debra Park,4.09
Forest Central Grove,2.69
Forest North Grove,4.78
Forest West Grove,3.93
Large Event Area,4.59
Main Pool,4.34
Marshall Park,4.40
Nature Preserve,4.36
Ned Brown Meadow,4.25
Salt Creek Trail,4.14
Woodland Meadow,4.63

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.12983147 0.00130000 NUM

e82f_0459

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 Entrance3.95
Boat Launch Area3.34
Debra Park3.29
Elk Pasture3.84
Forest Central Grove4.76
Forest North Grove4.34
Forest South Grove3.79
Forest West Grove4.56
Lake Boating Center4.20
Large Event Area3.85
Main Dam3.27
Marshall Park4.41
Model Airplane Field3.35
Nature Preserve3.74
Ned Brown Meadow4.36
North Pool4.81
Osborn Park3.89
Salt Creek Trail3.97
Wildlife Refuge3.48
Woodland Meadow3.76

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.95
Boat Launch Area,3.34
Debra Park,3.29
Elk Pasture,3.84
Forest Central Grove,4.76
Forest North Grove,4.34
Forest South Grove,3.79
Forest West Grove,4.56
Lake Boating Center,4.20
Large Event Area,3.85
Main Dam,3.27
Marshall Park,4.41
Model Airplane Field,3.35
Nature Preserve,3.74
Ned Brown Meadow,4.36
North Pool,4.81
Osborn Park,3.89
Salt Creek Trail,3.97
Wildlife Refuge,3.48
Woodland Meadow,3.76

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.69832309 0.00700000 NUM

0c18_c6bc

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 Park4.63
Beisner Road Entrance4.89
Debra Park3.82
Forest Central Grove4.49
Forest South Grove4.85
Forest West Grove4.58
Lake Boating Center3.76
Large Event Area3.31
Marshall Park3.67
Ned Brown Meadow5.09
North Pool3.35
Osborn Park3.80
Salt Creek Trail3.85
Wildlife Refuge4.65
Woodland Meadow4.02

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.63
Beisner Road Entrance,4.89
Debra Park,3.82
Forest Central Grove,4.49
Forest South Grove,4.85
Forest West Grove,4.58
Lake Boating Center,3.76
Large Event Area,3.31
Marshall Park,3.67
Ned Brown Meadow,5.09
North Pool,3.35
Osborn Park,3.80
Salt Creek Trail,3.85
Wildlife Refuge,4.65
Woodland Meadow,4.02

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.23494575 0.00230000 NUM

9cfd_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
Beisner Road Entrance3.89
Boat Launch Area3.89
Busse Lake4.66
Debra Park5.25
Forest Central Grove4.04
Forest North Grove5.05
Forest South Grove3.83
Forest West Grove4.21
Lake Boating Center3.35
Large Event Area5.37
Main Dam4.66
Main Pool2.43
Marshall Park3.66
Model Airplane Field4.45
Nature Preserve4.11
North Pool5.06
Osborn Park4.35
Salt Creek Trail3.94
South Pool3.62
Woodland Meadow4.13

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.89
Boat Launch Area,3.89
Busse Lake,4.66
Debra Park,5.25
Forest Central Grove,4.04
Forest North Grove,5.05
Forest South Grove,3.83
Forest West Grove,4.21
Lake Boating Center,3.35
Large Event Area,5.37
Main Dam,4.66
Main Pool,2.43
Marshall Park,3.66
Model Airplane Field,4.45
Nature Preserve,4.11
North Pool,5.06
Osborn Park,4.35
Salt Creek Trail,3.94
South Pool,3.62
Woodland Meadow,4.13

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.14099979 0.00140000 NUM

d7e5_cf64

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 Area4.89
Busse Lake2.79
Elk Pasture4.48
Forest Central Grove4.72
Forest North Grove4.52
Forest West Grove3.82
Lake Boating Center4.05
Main Dam3.61
Main Pool3.57
Marshall Park4.91
Ned Brown Meadow3.25
Osborn Park5.21
Salt Creek Trail4.72
South Pool4.23
Wildlife Refuge4.16
Woodland Meadow4.44

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.89
Busse Lake,2.79
Elk Pasture,4.48
Forest Central Grove,4.72
Forest North Grove,4.52
Forest West Grove,3.82
Lake Boating Center,4.05
Main Dam,3.61
Main Pool,3.57
Marshall Park,4.91
Ned Brown Meadow,3.25
Osborn Park,5.21
Salt Creek Trail,4.72
South Pool,4.23
Wildlife Refuge,4.16
Woodland Meadow,4.44

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.16026923 0.00160000 NUM

db01_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
Beisner Road Entrance3.76
Busse Lake4.31
Debra Park4.23
Elk Pasture3.84
Forest Central Grove4.31
Forest North Grove3.49
Lake Boating Center4.02
Main Pool4.75
Marshall Park5.06
North Pool4.42
Osborn Park3.73
Salt Creek Trail3.56
Wildlife Refuge3.11
Woodland Meadow4.50

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.76
Busse Lake,4.31
Debra Park,4.23
Elk Pasture,3.84
Forest Central Grove,4.31
Forest North Grove,3.49
Lake Boating Center,4.02
Main Pool,4.75
Marshall Park,5.06
North Pool,4.42
Osborn Park,3.73
Salt Creek Trail,3.56
Wildlife Refuge,3.11
Woodland Meadow,4.50

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.62730427 0.00630000 NUM

e78d_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 Park4.14
Beisner Road Entrance3.61
Busse Lake2.81
Forest Central Grove4.19
Forest North Grove3.06
Large Event Area4.00
Main Pool4.66
Model Airplane Field3.60
Nature Preserve4.83
North Pool3.37
Osborn Park4.04
South Pool3.73
Wildlife Refuge3.85

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.14
Beisner Road Entrance,3.61
Busse Lake,2.81
Forest Central Grove,4.19
Forest North Grove,3.06
Large Event Area,4.00
Main Pool,4.66
Model Airplane Field,3.60
Nature Preserve,4.83
North Pool,3.37
Osborn Park,4.04
South Pool,3.73
Wildlife Refuge,3.85

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.32938775 0.00330000 NUM

7865_e657

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 Park4.60
Busse Lake4.64
Forest Central Grove4.21
Forest North Grove3.96
Forest South Grove3.69
Forest West Grove4.61
Large Event Area4.67
Main Dam3.47
Main Pool3.22
Marshall Park4.47
Model Airplane Field4.76
Salt Creek Trail4.57
Woodland Meadow3.60

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.60
Busse Lake,4.64
Forest Central Grove,4.21
Forest North Grove,3.96
Forest South Grove,3.69
Forest West Grove,4.61
Large Event Area,4.67
Main Dam,3.47
Main Pool,3.22
Marshall Park,4.47
Model Airplane Field,4.76
Salt Creek Trail,4.57
Woodland Meadow,3.60

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.25355466 0.00250000 NUM

ba4c_8db7

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 Park3.93
Beisner Road Entrance3.17
Boat Launch Area3.10
Busse Lake4.24
Debra Park4.70
Elk Pasture3.65
Forest Central Grove4.69
Forest South Grove4.18
Forest West Grove4.32
Lake Boating Center3.72
Large Event Area4.32
Nature Preserve3.36
Osborn Park4.25
South Pool4.49
Woodland Meadow4.22

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.93
Beisner Road Entrance,3.17
Boat Launch Area,3.10
Busse Lake,4.24
Debra Park,4.70
Elk Pasture,3.65
Forest Central Grove,4.69
Forest South Grove,4.18
Forest West Grove,4.32
Lake Boating Center,3.72
Large Event Area,4.32
Nature Preserve,3.36
Osborn Park,4.25
South Pool,4.49
Woodland Meadow,4.22

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.88367454 0.00880000 NUM

13b7_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
Andrews Park4.37
Beisner Road Entrance3.89
Boat Launch Area4.49
Busse Lake3.23
Debra Park3.54
Forest South Grove4.99
Forest West Grove4.06
Lake Boating Center4.17
Large Event Area3.81
Main Dam5.17
Main Pool4.10
Marshall Park3.59
Model Airplane Field3.69
Nature Preserve4.26
Ned Brown Meadow5.06
North Pool2.57
Osborn Park5.00
South Pool4.35
Wildlife Refuge4.85
Woodland Meadow4.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.37
Beisner Road Entrance,3.89
Boat Launch Area,4.49
Busse Lake,3.23
Debra Park,3.54
Forest South Grove,4.99
Forest West Grove,4.06
Lake Boating Center,4.17
Large Event Area,3.81
Main Dam,5.17
Main Pool,4.10
Marshall Park,3.59
Model Airplane Field,3.69
Nature Preserve,4.26
Ned Brown Meadow,5.06
North Pool,2.57
Osborn Park,5.00
South Pool,4.35
Wildlife Refuge,4.85
Woodland Meadow,4.62

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.15563587 0.00160000 NUM

5f9b_cb92

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 Area4.96
Busse Lake4.45
Debra Park4.24
Elk Pasture3.24
Forest Central Grove3.69
Forest North Grove5.01
Lake Boating Center4.53
Main Dam3.99
Model Airplane Field4.07
Nature Preserve3.81
Ned Brown Meadow2.50
Salt Creek Trail4.75
Wildlife Refuge4.13
Woodland Meadow5.14

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.96
Busse Lake,4.45
Debra Park,4.24
Elk Pasture,3.24
Forest Central Grove,3.69
Forest North Grove,5.01
Lake Boating Center,4.53
Main Dam,3.99
Model Airplane Field,4.07
Nature Preserve,3.81
Ned Brown Meadow,2.50
Salt Creek Trail,4.75
Wildlife Refuge,4.13
Woodland Meadow,5.14

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.26354869 0.00260000 NUM

1529_4ffc

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 Park3.51
Debra Park3.00
Elk Pasture3.04
Forest Central Grove3.52
Forest West Grove3.25
Large Event Area2.97
Main Dam3.73
Main Pool4.46
Nature Preserve4.28
Ned Brown Meadow3.31
North Pool4.29
Osborn Park3.87
Salt Creek Trail4.35
South Pool4.33
Woodland Meadow3.99

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.51
Debra Park,3.00
Elk Pasture,3.04
Forest Central Grove,3.52
Forest West Grove,3.25
Large Event Area,2.97
Main Dam,3.73
Main Pool,4.46
Nature Preserve,4.28
Ned Brown Meadow,3.31
North Pool,4.29
Osborn Park,3.87
Salt Creek Trail,4.35
South Pool,4.33
Woodland Meadow,3.99

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.07767154 0.00100000 NUM

1c4b_8970

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 Park4.93
Boat Launch Area3.70
Debra Park3.42
Elk Pasture3.82
Forest Central Grove4.80
Forest North Grove3.59
Forest South Grove4.41
Forest West Grove4.56
Large Event Area3.40
Main Dam4.43
Main Pool4.65
Model Airplane Field4.50
Ned Brown Meadow4.17
North Pool3.71
Salt Creek Trail4.74
Woodland Meadow4.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.93
Boat Launch Area,3.70
Debra Park,3.42
Elk Pasture,3.82
Forest Central Grove,4.80
Forest North Grove,3.59
Forest South Grove,4.41
Forest West Grove,4.56
Large Event Area,3.40
Main Dam,4.43
Main Pool,4.65
Model Airplane Field,4.50
Ned Brown Meadow,4.17
North Pool,3.71
Salt Creek Trail,4.74
Woodland Meadow,4.98

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.11239945 0.00110000 NUM

cecb_2c75

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
Busse Lake3.67
Elk Pasture3.87
Forest Central Grove4.01
Forest South Grove3.66
Forest West Grove3.58
Lake Boating Center4.91
Large Event Area2.96
Marshall Park4.41
Model Airplane Field3.05
North Pool3.92
Salt Creek Trail3.84
South Pool2.96
Woodland Meadow4.98

Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.

Sample Location 2024 Shannon Index
Busse Lake,3.67
Elk Pasture,3.87
Forest Central Grove,4.01
Forest South Grove,3.66
Forest West Grove,3.58
Lake Boating Center,4.91
Large Event Area,2.96
Marshall Park,4.41
Model Airplane Field,3.05
North Pool,3.92
Salt Creek Trail,3.84
South Pool,2.96
Woodland Meadow,4.98

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.31359593 0.00310000 NUM

a215_461e

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
Debra Park3.91
Forest Central Grove4.19
Forest North Grove3.91
Forest West Grove3.92
Lake Boating Center3.31
Main Dam3.63
Marshall Park4.07
Ned Brown Meadow4.22
North Pool3.79
Osborn Park4.13
South Pool4.66
Wildlife Refuge4.37
Woodland Meadow4.10

Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.

Sample Location 2024 Shannon Index
Debra Park,3.91
Forest Central Grove,4.19
Forest North Grove,3.91
Forest West Grove,3.92
Lake Boating Center,3.31
Main Dam,3.63
Marshall Park,4.07
Ned Brown Meadow,4.22
North Pool,3.79
Osborn Park,4.13
South Pool,4.66
Wildlife Refuge,4.37
Woodland Meadow,4.10

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.92266879 0.00920000 NUM

2bf7_b72f

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 Park3.42
Beisner Road Entrance4.04
Boat Launch Area4.42
Busse Lake4.89
Debra Park4.17
Elk Pasture4.26
Forest North Grove3.08
Forest West Grove3.99
Large Event Area3.26
Main Pool3.92
Ned Brown Meadow4.70
North Pool4.99
Osborn Park4.75
South Pool3.63
Wildlife Refuge4.40
Woodland Meadow4.55

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.42
Beisner Road Entrance,4.04
Boat Launch Area,4.42
Busse Lake,4.89
Debra Park,4.17
Elk Pasture,4.26
Forest North Grove,3.08
Forest West Grove,3.99
Large Event Area,3.26
Main Pool,3.92
Ned Brown Meadow,4.70
North Pool,4.99
Osborn Park,4.75
South Pool,3.63
Wildlife Refuge,4.40
Woodland Meadow,4.55

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.30340136 0.00300000 NUM

b383_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
Andrews Park3.62
Beisner Road Entrance3.03
Boat Launch Area4.82
Busse Lake4.64
Debra Park3.95
Elk Pasture3.34
Forest Central Grove3.17
Forest North Grove4.29
Forest South Grove4.65
Forest West Grove4.47
Lake Boating Center4.78
Large Event Area4.80
Main Pool4.29
Marshall Park3.97
Nature Preserve4.90
Ned Brown Meadow4.75
Salt Creek Trail4.37
Wildlife Refuge4.03
Woodland Meadow3.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,3.62
Beisner Road Entrance,3.03
Boat Launch Area,4.82
Busse Lake,4.64
Debra Park,3.95
Elk Pasture,3.34
Forest Central Grove,3.17
Forest North Grove,4.29
Forest South Grove,4.65
Forest West Grove,4.47
Lake Boating Center,4.78
Large Event Area,4.80
Main Pool,4.29
Marshall Park,3.97
Nature Preserve,4.90
Ned Brown Meadow,4.75
Salt Creek Trail,4.37
Wildlife Refuge,4.03
Woodland Meadow,3.98

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.14099812 0.00140000 NUM

b3c4_fc3a

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 Area4.61
Busse Lake3.91
Debra Park4.02
Forest North Grove4.34
Large Event Area3.76
Main Dam3.36
Main Pool4.20
Marshall Park4.58
Model Airplane Field4.21
Nature Preserve3.42
Ned Brown Meadow4.67
North Pool3.13
Salt Creek Trail3.42

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.61
Busse Lake,3.91
Debra Park,4.02
Forest North Grove,4.34
Large Event Area,3.76
Main Dam,3.36
Main Pool,4.20
Marshall Park,4.58
Model Airplane Field,4.21
Nature Preserve,3.42
Ned Brown Meadow,4.67
North Pool,3.13
Salt Creek Trail,3.42

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.86419816 0.00860000 NUM

c962_0c9e

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 Park4.19
Debra Park3.80
Elk Pasture3.75
Forest Central Grove3.42
Forest North Grove3.67
Forest South Grove3.55
Forest West Grove3.89
Lake Boating Center5.07
Main Dam5.29
Marshall Park3.88
Model Airplane Field3.15
Nature Preserve3.39
Ned Brown Meadow3.60
North Pool3.75
Osborn Park4.12
Salt Creek Trail3.79
South Pool3.77
Woodland Meadow3.66

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
Debra Park,3.80
Elk Pasture,3.75
Forest Central Grove,3.42
Forest North Grove,3.67
Forest South Grove,3.55
Forest West Grove,3.89
Lake Boating Center,5.07
Main Dam,5.29
Marshall Park,3.88
Model Airplane Field,3.15
Nature Preserve,3.39
Ned Brown Meadow,3.60
North Pool,3.75
Osborn Park,4.12
Salt Creek Trail,3.79
South Pool,3.77
Woodland Meadow,3.66

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.37464197 0.00370000 NUM

1cd4_845e

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 Park4.15
Boat Launch Area4.78
Debra Park3.18
Elk Pasture4.30
Forest Central Grove3.58
Forest North Grove5.17
Forest West Grove3.43
Lake Boating Center5.07
Large Event Area6.00
Main Dam4.15
Main Pool4.62
Marshall Park3.77
Model Airplane Field4.70
North Pool4.39
Osborn Park3.60
South Pool3.60
Wildlife Refuge3.91
Woodland Meadow3.33

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.15
Boat Launch Area,4.78
Debra Park,3.18
Elk Pasture,4.30
Forest Central Grove,3.58
Forest North Grove,5.17
Forest West Grove,3.43
Lake Boating Center,5.07
Large Event Area,6.00
Main Dam,4.15
Main Pool,4.62
Marshall Park,3.77
Model Airplane Field,4.70
North Pool,4.39
Osborn Park,3.60
South Pool,3.60
Wildlife Refuge,3.91
Woodland Meadow,3.33

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.14284389 0.00140000 NUM

f6e6_655a

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 Entrance3.52
Busse Lake4.06
Forest Central Grove3.79
Forest South Grove4.44
Forest West Grove4.04
Lake Boating Center3.64
Large Event Area4.32
Main Dam4.12
Main Pool3.83
Model Airplane Field4.65
Nature Preserve3.97
Osborn Park4.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.52
Busse Lake,4.06
Forest Central Grove,3.79
Forest South Grove,4.44
Forest West Grove,4.04
Lake Boating Center,3.64
Large Event Area,4.32
Main Dam,4.12
Main Pool,3.83
Model Airplane Field,4.65
Nature Preserve,3.97
Osborn Park,4.34

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.72903449 0.00730000 NUM

825d_8a59

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 Park3.91
Beisner Road Entrance3.79
Boat Launch Area4.87
Busse Lake4.35
Debra Park3.56
Elk Pasture3.83
Forest North Grove3.88
Forest West Grove3.89
Lake Boating Center3.89
Main Pool4.03
Model Airplane Field4.60
Nature Preserve3.36
Ned Brown Meadow3.81
North Pool3.94
South Pool3.11
Woodland Meadow4.04

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.91
Beisner Road Entrance,3.79
Boat Launch Area,4.87
Busse Lake,4.35
Debra Park,3.56
Elk Pasture,3.83
Forest North Grove,3.88
Forest West Grove,3.89
Lake Boating Center,3.89
Main Pool,4.03
Model Airplane Field,4.60
Nature Preserve,3.36
Ned Brown Meadow,3.81
North Pool,3.94
South Pool,3.11
Woodland Meadow,4.04

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.63478697 0.00630000 NUM

9e0a_8a5a

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 Park3.57
Beisner Road Entrance3.02
Boat Launch Area4.17
Debra Park4.27
Elk Pasture4.82
Forest Central Grove4.19
Forest North Grove4.65
Forest South Grove3.08
Lake Boating Center4.50
Main Dam4.09
Main Pool3.24
Marshall Park3.51
Model Airplane Field3.83
Nature Preserve4.03
North Pool3.39
Osborn Park3.28
South Pool3.65
Woodland Meadow4.43

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.57
Beisner Road Entrance,3.02
Boat Launch Area,4.17
Debra Park,4.27
Elk Pasture,4.82
Forest Central Grove,4.19
Forest North Grove,4.65
Forest South Grove,3.08
Lake Boating Center,4.50
Main Dam,4.09
Main Pool,3.24
Marshall Park,3.51
Model Airplane Field,3.83
Nature Preserve,4.03
North Pool,3.39
Osborn Park,3.28
South Pool,3.65
Woodland Meadow,4.43

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.37042979 0.00370000 NUM

06e4_a148

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 Park4.09
Busse Lake4.86
Debra Park4.83
Elk Pasture4.39
Forest Central Grove3.14
Forest South Grove4.41
Forest West Grove4.13
Large Event Area4.14
Main Dam4.46
Main Pool3.90
Marshall Park3.84
Model Airplane Field4.04
Nature Preserve4.77
Ned Brown Meadow4.34
North Pool4.21
Osborn Park3.96
South Pool3.29
Wildlife Refuge4.30
Woodland Meadow5.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,4.09
Busse Lake,4.86
Debra Park,4.83
Elk Pasture,4.39
Forest Central Grove,3.14
Forest South Grove,4.41
Forest West Grove,4.13
Large Event Area,4.14
Main Dam,4.46
Main Pool,3.90
Marshall Park,3.84
Model Airplane Field,4.04
Nature Preserve,4.77
Ned Brown Meadow,4.34
North Pool,4.21
Osborn Park,3.96
South Pool,3.29
Wildlife Refuge,4.30
Woodland Meadow,5.11

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.10745600 0.00110000 NUM

ff35_dc57

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 Park3.73
Beisner Road Entrance4.44
Boat Launch Area4.69
Busse Lake4.96
Debra Park3.67
Forest North Grove4.21
Forest South Grove3.37
Forest West Grove4.43
Lake Boating Center3.10
Main Pool4.61
Marshall Park4.47
Nature Preserve4.33
Ned Brown Meadow3.60
North Pool3.57
Salt Creek Trail5.29
South Pool4.98
Wildlife Refuge4.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.73
Beisner Road Entrance,4.44
Boat Launch Area,4.69
Busse Lake,4.96
Debra Park,3.67
Forest North Grove,4.21
Forest South Grove,3.37
Forest West Grove,4.43
Lake Boating Center,3.10
Main Pool,4.61
Marshall Park,4.47
Nature Preserve,4.33
Ned Brown Meadow,3.60
North Pool,3.57
Salt Creek Trail,5.29
South Pool,4.98
Wildlife Refuge,4.12

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.14899597 0.00150000 NUM

41d1_e160

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 Park4.30
Beisner Road Entrance3.63
Busse Lake3.54
Debra Park3.55
Forest Central Grove4.10
Forest South Grove4.39
Forest West Grove4.05
Lake Boating Center3.35
Main Pool3.73
Model Airplane Field3.53
North Pool3.55
Salt Creek Trail3.22
Woodland Meadow3.86

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.30
Beisner Road Entrance,3.63
Busse Lake,3.54
Debra Park,3.55
Forest Central Grove,4.10
Forest South Grove,4.39
Forest West Grove,4.05
Lake Boating Center,3.35
Main Pool,3.73
Model Airplane Field,3.53
North Pool,3.55
Salt Creek Trail,3.22
Woodland Meadow,3.86

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.13908673 0.00140000 NUM

0513_6352

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 Park3.79
Beisner Road Entrance3.00
Boat Launch Area3.38
Debra Park4.01
Elk Pasture3.77
Forest North Grove4.41
Forest West Grove3.67
Lake Boating Center3.46
Large Event Area5.30
Main Dam4.82
Main Pool3.23
Marshall Park3.00
Ned Brown Meadow4.15
North Pool3.58
Osborn Park3.74
South Pool3.86

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.79
Beisner Road Entrance,3.00
Boat Launch Area,3.38
Debra Park,4.01
Elk Pasture,3.77
Forest North Grove,4.41
Forest West Grove,3.67
Lake Boating Center,3.46
Large Event Area,5.30
Main Dam,4.82
Main Pool,3.23
Marshall Park,3.00
Ned Brown Meadow,4.15
North Pool,3.58
Osborn Park,3.74
South Pool,3.86

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.23833182 0.00240000 NUM

125c_835e

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 Park4.24
Beisner Road Entrance4.65
Busse Lake4.06
Debra Park4.19
Forest Central Grove4.24
Forest South Grove3.94
Lake Boating Center4.40
Large Event Area4.65
Main Dam3.88
Marshall Park4.60
Model Airplane Field5.10
Nature Preserve4.49
Ned Brown Meadow4.62
Osborn Park2.88
South Pool4.25
Wildlife Refuge3.16
Woodland Meadow3.58

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,4.65
Busse Lake,4.06
Debra Park,4.19
Forest Central Grove,4.24
Forest South Grove,3.94
Lake Boating Center,4.40
Large Event Area,4.65
Main Dam,3.88
Marshall Park,4.60
Model Airplane Field,5.10
Nature Preserve,4.49
Ned Brown Meadow,4.62
Osborn Park,2.88
South Pool,4.25
Wildlife Refuge,3.16
Woodland Meadow,3.58

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.23626176 0.00240000 NUM

42fe_9113

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 Area5.69
Busse Lake4.68
Debra Park3.70
Elk Pasture4.36
Forest Central Grove4.81
Forest North Grove3.68
Forest South Grove4.40
Forest West Grove3.95
Lake Boating Center4.17
Large Event Area4.92
Marshall Park4.69
Nature Preserve3.57
Ned Brown Meadow3.06
Osborn Park3.68
Salt Creek Trail4.52
Wildlife Refuge3.80

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,5.69
Busse Lake,4.68
Debra Park,3.70
Elk Pasture,4.36
Forest Central Grove,4.81
Forest North Grove,3.68
Forest South Grove,4.40
Forest West Grove,3.95
Lake Boating Center,4.17
Large Event Area,4.92
Marshall Park,4.69
Nature Preserve,3.57
Ned Brown Meadow,3.06
Osborn Park,3.68
Salt Creek Trail,4.52
Wildlife Refuge,3.80

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.12519375 0.00130000 NUM

a5ce_ff3f

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 Park4.80
Beisner Road Entrance4.01
Boat Launch Area4.29
Busse Lake4.36
Debra Park4.75
Main Pool4.42
Marshall Park4.44
Model Airplane Field4.65
Nature Preserve4.39
Ned Brown Meadow2.79
North Pool4.12
Osborn Park2.83
Salt Creek Trail4.04
South Pool4.97
Wildlife Refuge3.62
Woodland Meadow5.04

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.80
Beisner Road Entrance,4.01
Boat Launch Area,4.29
Busse Lake,4.36
Debra Park,4.75
Main Pool,4.42
Marshall Park,4.44
Model Airplane Field,4.65
Nature Preserve,4.39
Ned Brown Meadow,2.79
North Pool,4.12
Osborn Park,2.83
Salt Creek Trail,4.04
South Pool,4.97
Wildlife Refuge,3.62
Woodland Meadow,5.04

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.14246675 0.00140000 NUM

fb18_cf64

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 Entrance4.09
Busse Lake3.07
Elk Pasture3.02
Forest Central Grove4.28
Forest North Grove4.32
Forest West Grove3.28
Large Event Area4.35
Main Dam3.21
Main Pool3.75
Marshall Park5.31
Model Airplane Field2.81
Nature Preserve4.83
Ned Brown Meadow3.78
Osborn Park3.63
Salt Creek Trail3.29
South Pool4.07
Wildlife Refuge3.21
Woodland Meadow4.12

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.09
Busse Lake,3.07
Elk Pasture,3.02
Forest Central Grove,4.28
Forest North Grove,4.32
Forest West Grove,3.28
Large Event Area,4.35
Main Dam,3.21
Main Pool,3.75
Marshall Park,5.31
Model Airplane Field,2.81
Nature Preserve,4.83
Ned Brown Meadow,3.78
Osborn Park,3.63
Salt Creek Trail,3.29
South Pool,4.07
Wildlife Refuge,3.21
Woodland Meadow,4.12

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.15961820 0.00160000 NUM

9033_8eaf

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 Park4.66
Boat Launch Area3.92
Busse Lake4.38
Elk Pasture3.99
Forest Central Grove3.28
Forest South Grove3.91
Forest West Grove3.56
Lake Boating Center3.60
Large Event Area4.88
Marshall Park3.65
Model Airplane Field3.76
Nature Preserve4.77
North Pool3.03
Osborn Park4.57
South Pool3.16
Wildlife Refuge3.10
Woodland Meadow4.23

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.66
Boat Launch Area,3.92
Busse Lake,4.38
Elk Pasture,3.99
Forest Central Grove,3.28
Forest South Grove,3.91
Forest West Grove,3.56
Lake Boating Center,3.60
Large Event Area,4.88
Marshall Park,3.65
Model Airplane Field,3.76
Nature Preserve,4.77
North Pool,3.03
Osborn Park,4.57
South Pool,3.16
Wildlife Refuge,3.10
Woodland Meadow,4.23

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.53095401 0.00530000 NUM

590d_0bf6

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 Park4.14
Busse Lake4.35
Elk Pasture4.20
Forest North Grove4.30
Forest South Grove4.13
Forest West Grove4.59
Main Pool4.42
Marshall Park3.92
Nature Preserve4.12
North Pool3.63
Osborn Park3.36
Salt Creek Trail4.28

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.14
Busse Lake,4.35
Elk Pasture,4.20
Forest North Grove,4.30
Forest South Grove,4.13
Forest West Grove,4.59
Main Pool,4.42
Marshall Park,3.92
Nature Preserve,4.12
North Pool,3.63
Osborn Park,3.36
Salt Creek Trail,4.28

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.48842232 0.00490000 NUM

c189_55a8

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 Entrance2.33
Busse Lake3.77
Forest North Grove3.49
Forest South Grove3.93
Lake Boating Center4.77
Large Event Area4.75
Main Pool3.27
Marshall Park3.22
Nature Preserve3.82
Ned Brown Meadow4.65
North Pool4.37
Wildlife Refuge4.27
Woodland Meadow3.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,2.33
Busse Lake,3.77
Forest North Grove,3.49
Forest South Grove,3.93
Lake Boating Center,4.77
Large Event Area,4.75
Main Pool,3.27
Marshall Park,3.22
Nature Preserve,3.82
Ned Brown Meadow,4.65
North Pool,4.37
Wildlife Refuge,4.27
Woodland Meadow,3.91

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.50269032 0.00500000 NUM

529a_ba9d

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 Entrance4.25
Boat Launch Area3.53
Busse Lake4.50
Debra Park4.62
Elk Pasture3.88
Forest Central Grove2.95
Forest North Grove3.15
Forest South Grove4.15
Forest West Grove4.27
Large Event Area3.58
Main Dam4.27
Marshall Park2.39
Model Airplane Field3.70
Nature Preserve2.83
Ned Brown Meadow3.61
North Pool3.49
Salt Creek Trail3.55
South Pool4.68
Wildlife Refuge4.57
Woodland Meadow3.39

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.25
Boat Launch Area,3.53
Busse Lake,4.50
Debra Park,4.62
Elk Pasture,3.88
Forest Central Grove,2.95
Forest North Grove,3.15
Forest South Grove,4.15
Forest West Grove,4.27
Large Event Area,3.58
Main Dam,4.27
Marshall Park,2.39
Model Airplane Field,3.70
Nature Preserve,2.83
Ned Brown Meadow,3.61
North Pool,3.49
Salt Creek Trail,3.55
South Pool,4.68
Wildlife Refuge,4.57
Woodland Meadow,3.39

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.08376867 0.00100000 NUM

a2dc_cddb

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 Entrance3.78
Boat Launch Area2.60
Busse Lake3.21
Elk Pasture4.07
Forest South Grove4.22
Forest West Grove3.50
Lake Boating Center4.79
Main Dam3.50
Main Pool3.29
Ned Brown Meadow4.56
North Pool4.62
South Pool3.66
Woodland Meadow3.62

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,2.60
Busse Lake,3.21
Elk Pasture,4.07
Forest South Grove,4.22
Forest West Grove,3.50
Lake Boating Center,4.79
Main Dam,3.50
Main Pool,3.29
Ned Brown Meadow,4.56
North Pool,4.62
South Pool,3.66
Woodland Meadow,3.62

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.23302394 0.00230000 NUM

4cc3_562b

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 Park3.48
Beisner Road Entrance3.37
Busse Lake4.83
Elk Pasture5.15
Forest North Grove5.09
Forest South Grove4.17
Forest West Grove3.21
Lake Boating Center3.61
Main Dam4.23
Main Pool4.05
Ned Brown Meadow3.46
Salt Creek Trail4.96
Wildlife Refuge4.35
Woodland Meadow3.32

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.48
Beisner Road Entrance,3.37
Busse Lake,4.83
Elk Pasture,5.15
Forest North Grove,5.09
Forest South Grove,4.17
Forest West Grove,3.21
Lake Boating Center,3.61
Main Dam,4.23
Main Pool,4.05
Ned Brown Meadow,3.46
Salt Creek Trail,4.96
Wildlife Refuge,4.35
Woodland Meadow,3.32

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.56857100 0.00570000 NUM

4182_11bb

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 Park3.89
Beisner Road Entrance4.70
Boat Launch Area4.70
Busse Lake3.20
Debra Park4.20
Elk Pasture3.61
Forest North Grove3.48
Forest South Grove5.03
Lake Boating Center2.88
Large Event Area4.99
Main Dam3.68
Main Pool3.64
Model Airplane Field3.99
Ned Brown Meadow4.99
North Pool4.54
Osborn Park4.95
Salt Creek Trail4.78
Wildlife Refuge4.99
Woodland Meadow4.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.89
Beisner Road Entrance,4.70
Boat Launch Area,4.70
Busse Lake,3.20
Debra Park,4.20
Elk Pasture,3.61
Forest North Grove,3.48
Forest South Grove,5.03
Lake Boating Center,2.88
Large Event Area,4.99
Main Dam,3.68
Main Pool,3.64
Model Airplane Field,3.99
Ned Brown Meadow,4.99
North Pool,4.54
Osborn Park,4.95
Salt Creek Trail,4.78
Wildlife Refuge,4.99
Woodland Meadow,4.12

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.09549697 0.00100000 NUM

33f7_67d1

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 Entrance4.02
Boat Launch Area3.47
Busse Lake3.84
Debra Park3.28
Elk Pasture4.17
Forest North Grove3.62
Forest West Grove3.84
Main Dam3.33
Main Pool3.90
Marshall Park3.60
North Pool4.29
Salt Creek Trail3.47
Wildlife Refuge3.45
Woodland Meadow4.29

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.02
Boat Launch Area,3.47
Busse Lake,3.84
Debra Park,3.28
Elk Pasture,4.17
Forest North Grove,3.62
Forest West Grove,3.84
Main Dam,3.33
Main Pool,3.90
Marshall Park,3.60
North Pool,4.29
Salt Creek Trail,3.47
Wildlife Refuge,3.45
Woodland Meadow,4.29

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.12655142 0.00130000 NUM

db3d_5682

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 Entrance3.62
Boat Launch Area4.88
Debra Park4.42
Forest North Grove3.59
Forest South Grove4.53
Forest West Grove3.10
Large Event Area3.80
Marshall Park3.89
Model Airplane Field4.09
Nature Preserve4.10
Ned Brown Meadow3.67
North Pool5.09
Osborn Park5.04
Salt Creek Trail3.78
Wildlife Refuge3.46
Woodland Meadow3.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.62
Boat Launch Area,4.88
Debra Park,4.42
Forest North Grove,3.59
Forest South Grove,4.53
Forest West Grove,3.10
Large Event Area,3.80
Marshall Park,3.89
Model Airplane Field,4.09
Nature Preserve,4.10
Ned Brown Meadow,3.67
North Pool,5.09
Osborn Park,5.04
Salt Creek Trail,3.78
Wildlife Refuge,3.46
Woodland Meadow,3.67

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.76100092 0.00760000 NUM

14b3_a448

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 Park4.09
Beisner Road Entrance4.36
Boat Launch Area4.32
Busse Lake5.41
Debra Park4.32
Elk Pasture4.00
Forest Central Grove4.79
Forest South Grove3.10
Forest West Grove3.74
Lake Boating Center4.92
Main Dam4.11
Marshall Park3.90
Model Airplane Field4.68
Nature Preserve4.12
Ned Brown Meadow3.56
North Pool4.33
Osborn Park4.19
Salt Creek Trail5.01
South Pool3.77
Wildlife Refuge4.09

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.09
Beisner Road Entrance,4.36
Boat Launch Area,4.32
Busse Lake,5.41
Debra Park,4.32
Elk Pasture,4.00
Forest Central Grove,4.79
Forest South Grove,3.10
Forest West Grove,3.74
Lake Boating Center,4.92
Main Dam,4.11
Marshall Park,3.90
Model Airplane Field,4.68
Nature Preserve,4.12
Ned Brown Meadow,3.56
North Pool,4.33
Osborn Park,4.19
Salt Creek Trail,5.01
South Pool,3.77
Wildlife Refuge,4.09

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.07303992 0.00100000 NUM

88cd_4528

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 Park2.79
Beisner Road Entrance3.56
Debra Park4.59
Forest Central Grove4.68
Forest West Grove4.10
Lake Boating Center2.78
Large Event Area4.47
Main Dam4.08
Main Pool3.82
Marshall Park4.51
Nature Preserve3.88
Ned Brown Meadow3.44
North Pool2.83
Osborn Park4.89
Salt Creek Trail3.22
Wildlife Refuge3.28

Alternate Copyable Format:
Copy this text and use Data → Split text to columns → Comma in Google Sheets.

Sample Location 2024 Shannon Index
Andrews Park,2.79
Beisner Road Entrance,3.56
Debra Park,4.59
Forest Central Grove,4.68
Forest West Grove,4.10
Lake Boating Center,2.78
Large Event Area,4.47
Main Dam,4.08
Main Pool,3.82
Marshall Park,4.51
Nature Preserve,3.88
Ned Brown Meadow,3.44
North Pool,2.83
Osborn Park,4.89
Salt Creek Trail,3.22
Wildlife Refuge,3.28

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.19937532 0.00200000 NUM

b922_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
Boat Launch Area3.75
Busse Lake4.69
Debra Park3.61
Elk Pasture4.05
Forest Central Grove4.56
Forest North Grove3.10
Forest South Grove5.15
Forest West Grove5.08
Large Event Area3.84
Main Dam3.54
Marshall Park4.37
Model Airplane Field4.34
Nature Preserve5.05
Ned Brown Meadow3.26
North Pool4.66
Osborn Park3.35
Salt Creek Trail2.60
South Pool3.97
Wildlife Refuge4.58
Woodland Meadow4.43

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.75
Busse Lake,4.69
Debra Park,3.61
Elk Pasture,4.05
Forest Central Grove,4.56
Forest North Grove,3.10
Forest South Grove,5.15
Forest West Grove,5.08
Large Event Area,3.84
Main Dam,3.54
Marshall Park,4.37
Model Airplane Field,4.34
Nature Preserve,5.05
Ned Brown Meadow,3.26
North Pool,4.66
Osborn Park,3.35
Salt Creek Trail,2.60
South Pool,3.97
Wildlife Refuge,4.58
Woodland Meadow,4.43

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.46057374 0.00460000 NUM

928e_8b4f

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 Park4.75
Beisner Road Entrance4.19
Boat Launch Area3.92
Busse Lake4.03
Debra Park5.31
Forest North Grove4.10
Forest South Grove4.72
Forest West Grove4.77
Lake Boating Center4.01
Large Event Area4.03
Main Dam4.42
Marshall Park2.89
Model Airplane Field4.42
Nature Preserve3.74
Ned Brown Meadow3.03
Osborn Park3.90
Salt Creek Trail3.84
South Pool4.27
Wildlife Refuge4.35
Woodland Meadow4.85

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.75
Beisner Road Entrance,4.19
Boat Launch Area,3.92
Busse Lake,4.03
Debra Park,5.31
Forest North Grove,4.10
Forest South Grove,4.72
Forest West Grove,4.77
Lake Boating Center,4.01
Large Event Area,4.03
Main Dam,4.42
Marshall Park,2.89
Model Airplane Field,4.42
Nature Preserve,3.74
Ned Brown Meadow,3.03
Osborn Park,3.90
Salt Creek Trail,3.84
South Pool,4.27
Wildlife Refuge,4.35
Woodland Meadow,4.85

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.18707549 0.00190000 NUM

ecf9_122a

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 Area3.56
Busse Lake4.92
Debra Park5.04
Elk Pasture4.28
Forest North Grove4.37
Forest South Grove3.98
Forest West Grove3.57
Lake Boating Center2.94
Large Event Area3.04
Main Dam3.79
Main Pool6.00
Marshall Park3.60
Model Airplane Field4.70
Nature Preserve4.48
North Pool4.92
Osborn Park4.16
Salt Creek Trail4.72
Woodland Meadow4.06

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.56
Busse Lake,4.92
Debra Park,5.04
Elk Pasture,4.28
Forest North Grove,4.37
Forest South Grove,3.98
Forest West Grove,3.57
Lake Boating Center,2.94
Large Event Area,3.04
Main Dam,3.79
Main Pool,6.00
Marshall Park,3.60
Model Airplane Field,4.70
Nature Preserve,4.48
North Pool,4.92
Osborn Park,4.16
Salt Creek Trail,4.72
Woodland Meadow,4.06

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.10471404 0.00100000 NUM

181f_122a

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 Area4.52
Busse Lake5.13
Debra Park4.05
Forest West Grove4.58
Main Dam4.20
Main Pool4.69
Model Airplane Field3.91
Nature Preserve4.32
Ned Brown Meadow4.75
North Pool3.22
Osborn Park4.24
Salt Creek Trail4.17
South Pool4.19
Wildlife Refuge3.67

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.52
Busse Lake,5.13
Debra Park,4.05
Forest West Grove,4.58
Main Dam,4.20
Main Pool,4.69
Model Airplane Field,3.91
Nature Preserve,4.32
Ned Brown Meadow,4.75
North Pool,3.22
Osborn Park,4.24
Salt Creek Trail,4.17
South Pool,4.19
Wildlife Refuge,3.67

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.10493512 0.00100000 NUM

b335_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
Andrews Park3.56
Beisner Road Entrance4.46
Busse Lake4.74
Elk Pasture3.83
Forest North Grove4.76
Lake Boating Center3.14
Main Dam5.24
Marshall Park3.86
Nature Preserve4.73
North Pool4.21
South Pool3.69
Woodland Meadow3.56

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.56
Beisner Road Entrance,4.46
Busse Lake,4.74
Elk Pasture,3.83
Forest North Grove,4.76
Lake Boating Center,3.14
Main Dam,5.24
Marshall Park,3.86
Nature Preserve,4.73
North Pool,4.21
South Pool,3.69
Woodland Meadow,3.56

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.39177496 0.00390000 NUM

e4ed_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 Park4.16
Beisner Road Entrance2.83
Busse Lake3.84
Debra Park3.79
Forest Central Grove3.93
Forest North Grove4.23
Forest South Grove3.28
Forest West Grove3.36
Lake Boating Center2.51
Large Event Area3.07
Main Dam4.14
Marshall Park5.33
Model Airplane Field5.74
Nature Preserve4.31
Ned Brown Meadow4.78
North Pool3.99
Osborn Park5.82
South Pool4.94
Wildlife Refuge3.99

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.16
Beisner Road Entrance,2.83
Busse Lake,3.84
Debra Park,3.79
Forest Central Grove,3.93
Forest North Grove,4.23
Forest South Grove,3.28
Forest West Grove,3.36
Lake Boating Center,2.51
Large Event Area,3.07
Main Dam,4.14
Marshall Park,5.33
Model Airplane Field,5.74
Nature Preserve,4.31
Ned Brown Meadow,4.78
North Pool,3.99
Osborn Park,5.82
South Pool,4.94
Wildlife Refuge,3.99

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.43538293 0.00440000 NUM

4892_ad85

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 Park3.91
Beisner Road Entrance3.21
Boat Launch Area3.78
Busse Lake4.46
Debra Park4.43
Elk Pasture3.57
Forest Central Grove4.38
Forest North Grove4.77
Forest South Grove2.88
Lake Boating Center3.59
Main Pool4.83
Marshall Park3.85
Model Airplane Field3.61
Nature Preserve6.00
Ned Brown Meadow3.23
North Pool4.76
Osborn Park3.57
South Pool3.29
Wildlife Refuge4.61
Woodland Meadow4.92

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.91
Beisner Road Entrance,3.21
Boat Launch Area,3.78
Busse Lake,4.46
Debra Park,4.43
Elk Pasture,3.57
Forest Central Grove,4.38
Forest North Grove,4.77
Forest South Grove,2.88
Lake Boating Center,3.59
Main Pool,4.83
Marshall Park,3.85
Model Airplane Field,3.61
Nature Preserve,6.00
Ned Brown Meadow,3.23
North Pool,4.76
Osborn Park,3.57
South Pool,3.29
Wildlife Refuge,4.61
Woodland Meadow,4.92

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.53860842 0.00540000 NUM

e300_434c

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 Park3.29
Beisner Road Entrance5.96
Debra Park5.21
Elk Pasture4.75
Forest Central Grove3.14
Forest South Grove4.17
Lake Boating Center4.00
Main Pool3.81
Ned Brown Meadow3.50
Osborn Park4.08
Wildlife Refuge4.83
Woodland Meadow4.02

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.29
Beisner Road Entrance,5.96
Debra Park,5.21
Elk Pasture,4.75
Forest Central Grove,3.14
Forest South Grove,4.17
Lake Boating Center,4.00
Main Pool,3.81
Ned Brown Meadow,3.50
Osborn Park,4.08
Wildlife Refuge,4.83
Woodland Meadow,4.02

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.18420929 0.00180000 NUM

c60b_8fbf

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 Entrance3.81
Boat Launch Area5.54
Busse Lake4.09
Debra Park4.14
Elk Pasture4.16
Forest Central Grove4.46
Forest North Grove3.28
Forest West Grove4.02
Large Event Area3.70
Main Dam5.08
Main Pool4.01
Marshall Park4.13
Model Airplane Field3.95
Nature Preserve2.81
Ned Brown Meadow3.43
North Pool3.27
Osborn Park4.00
Salt Creek Trail3.01
Wildlife Refuge4.63
Woodland Meadow3.83

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.81
Boat Launch Area,5.54
Busse Lake,4.09
Debra Park,4.14
Elk Pasture,4.16
Forest Central Grove,4.46
Forest North Grove,3.28
Forest West Grove,4.02
Large Event Area,3.70
Main Dam,5.08
Main Pool,4.01
Marshall Park,4.13
Model Airplane Field,3.95
Nature Preserve,2.81
Ned Brown Meadow,3.43
North Pool,3.27
Osborn Park,4.00
Salt Creek Trail,3.01
Wildlife Refuge,4.63
Woodland Meadow,3.83

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.80859366 0.00810000 NUM

aea3_3a75

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 Park3.76
Beisner Road Entrance3.70
Boat Launch Area3.43
Debra Park3.75
Forest Central Grove2.98
Forest North Grove4.82
Forest South Grove3.88
Lake Boating Center3.99
Main Pool3.77
Marshall Park3.31
Nature Preserve3.58
Ned Brown Meadow3.69
Wildlife Refuge4.61
Woodland Meadow2.96

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.76
Beisner Road Entrance,3.70
Boat Launch Area,3.43
Debra Park,3.75
Forest Central Grove,2.98
Forest North Grove,4.82
Forest South Grove,3.88
Lake Boating Center,3.99
Main Pool,3.77
Marshall Park,3.31
Nature Preserve,3.58
Ned Brown Meadow,3.69
Wildlife Refuge,4.61
Woodland Meadow,2.96

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.09309525 0.00100000 NUM

fd50_af78

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 Area4.12
Busse Lake4.70
Debra Park4.87
Elk Pasture4.01
Forest Central Grove3.50
Forest North Grove4.04
Lake Boating Center3.37
Large Event Area4.55
Marshall Park4.27
North Pool3.13
South Pool4.18
Wildlife Refuge4.15

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.12
Busse Lake,4.70
Debra Park,4.87
Elk Pasture,4.01
Forest Central Grove,3.50
Forest North Grove,4.04
Lake Boating Center,3.37
Large Event Area,4.55
Marshall Park,4.27
North Pool,3.13
South Pool,4.18
Wildlife Refuge,4.15

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.66850446 0.00670000 NUM

a965_5898

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 Park3.45
Beisner Road Entrance4.41
Debra Park3.43
Forest North Grove4.34
Forest South Grove3.89
Forest West Grove2.43
Lake Boating Center4.58
Main Dam3.83
Marshall Park4.83
Model Airplane Field4.09
Nature Preserve3.99
Ned Brown Meadow3.84
North Pool3.41
Osborn Park3.56
Salt Creek Trail4.25
Wildlife Refuge3.87
Woodland Meadow4.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,3.45
Beisner Road Entrance,4.41
Debra Park,3.43
Forest North Grove,4.34
Forest South Grove,3.89
Forest West Grove,2.43
Lake Boating Center,4.58
Main Dam,3.83
Marshall Park,4.83
Model Airplane Field,4.09
Nature Preserve,3.99
Ned Brown Meadow,3.84
North Pool,3.41
Osborn Park,3.56
Salt Creek Trail,4.25
Wildlife Refuge,3.87
Woodland Meadow,4.07

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.48435766 0.00480000 NUM

e5d5_66f5

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 Park3.82
Boat Launch Area4.77
Debra Park4.07
Elk Pasture4.20
Forest Central Grove4.81
Forest North Grove3.78
Forest South Grove3.80
Forest West Grove4.19
Lake Boating Center2.70
Large Event Area4.85
Main Pool4.92
Marshall Park4.17
Model Airplane Field3.56
Nature Preserve4.21
Ned Brown Meadow2.72
Osborn Park4.24
Salt Creek Trail3.07
Wildlife Refuge4.44
Woodland Meadow3.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.82
Boat Launch Area,4.77
Debra Park,4.07
Elk Pasture,4.20
Forest Central Grove,4.81
Forest North Grove,3.78
Forest South Grove,3.80
Forest West Grove,4.19
Lake Boating Center,2.70
Large Event Area,4.85
Main Pool,4.92
Marshall Park,4.17
Model Airplane Field,3.56
Nature Preserve,4.21
Ned Brown Meadow,2.72
Osborn Park,4.24
Salt Creek Trail,3.07
Wildlife Refuge,4.44
Woodland Meadow,3.87

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.94208598 0.00940000 NUM

dc21_c123

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 Park3.39
Beisner Road Entrance4.42
Boat Launch Area4.60
Debra Park3.21
Elk Pasture3.38
Forest South Grove4.25
Lake Boating Center4.44
Large Event Area3.32
Main Dam3.30
Main Pool4.65
Marshall Park3.65
Nature Preserve3.93
Ned Brown Meadow3.73
Osborn Park2.70
Salt Creek Trail4.26
Woodland Meadow2.67

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.39
Beisner Road Entrance,4.42
Boat Launch Area,4.60
Debra Park,3.21
Elk Pasture,3.38
Forest South Grove,4.25
Lake Boating Center,4.44
Large Event Area,3.32
Main Dam,3.30
Main Pool,4.65
Marshall Park,3.65
Nature Preserve,3.93
Ned Brown Meadow,3.73
Osborn Park,2.70
Salt Creek Trail,4.26
Woodland Meadow,2.67

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.08757451 0.00100000 NUM

592d_3357

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 Park4.67
Beisner Road Entrance5.47
Busse Lake3.92
Elk Pasture4.47
Forest Central Grove4.18
Forest North Grove3.49
Forest South Grove2.65
Main Dam3.92
Main Pool4.10
Nature Preserve3.80
Ned Brown Meadow4.39
North Pool3.61
Osborn Park4.24
Salt Creek Trail4.52
South Pool4.10

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,5.47
Busse Lake,3.92
Elk Pasture,4.47
Forest Central Grove,4.18
Forest North Grove,3.49
Forest South Grove,2.65
Main Dam,3.92
Main Pool,4.10
Nature Preserve,3.80
Ned Brown Meadow,4.39
North Pool,3.61
Osborn Park,4.24
Salt Creek Trail,4.52
South Pool,4.10

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.51027653 0.00510000 NUM

f832_2206

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 Entrance4.14
Boat Launch Area3.35
Busse Lake2.55
Elk Pasture3.23
Forest Central Grove3.62
Forest North Grove4.61
Forest South Grove3.00
Forest West Grove3.19
Lake Boating Center4.01
Large Event Area4.89
Main Dam3.82
Main Pool3.57
Model Airplane Field4.08
Nature Preserve4.07
North Pool3.15
Osborn Park3.65
Salt Creek Trail4.38
South Pool4.34
Woodland Meadow3.84

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.14
Boat Launch Area,3.35
Busse Lake,2.55
Elk Pasture,3.23
Forest Central Grove,3.62
Forest North Grove,4.61
Forest South Grove,3.00
Forest West Grove,3.19
Lake Boating Center,4.01
Large Event Area,4.89
Main Dam,3.82
Main Pool,3.57
Model Airplane Field,4.08
Nature Preserve,4.07
North Pool,3.15
Osborn Park,3.65
Salt Creek Trail,4.38
South Pool,4.34
Woodland Meadow,3.84

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.08462815 0.00100000 NUM

041f_b165

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 Park3.26
Beisner Road Entrance4.71
Boat Launch Area3.76
Busse Lake4.17
Forest Central Grove4.03
Forest North Grove4.19
Forest South Grove4.19
Forest West Grove3.74
Lake Boating Center2.98
Large Event Area4.38
Main Dam3.73
Osborn Park4.18
Woodland Meadow3.58

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.26
Beisner Road Entrance,4.71
Boat Launch Area,3.76
Busse Lake,4.17
Forest Central Grove,4.03
Forest North Grove,4.19
Forest South Grove,4.19
Forest West Grove,3.74
Lake Boating Center,2.98
Large Event Area,4.38
Main Dam,3.73
Osborn Park,4.18
Woodland Meadow,3.58

Follow the workflow in the tutorial: link here.

Enter the p value as a decimal between 0 and 1.

0.61112014 0.00610000