Tables - Flight Trials Winter 2020

source_path = "~/Desktop/git_repositories/SBB-dispersal/avbernat/Rsrc/"

script_names = c("center_flight_data.R", # Re-centers data 
                 "clean_flight_data.R" # Loads and cleans data
                 )

for (script in script_names) { 
  path = paste0(source_path, script)
  source(path) 
}

## 
## Attaching package: 'lubridate'

## The following objects are masked from 'package:base':
## 
##     date, intersect, setdiff, union

data <- read_flight_data("data/all_flight_data-Winter2020.csv")

## Warning: `funs()` was deprecated in dplyr 0.8.0.
## Please use a list of either functions or lambdas: 
## 
##   # Simple named list: 
##   list(mean = mean, median = median)
## 
##   # Auto named with `tibble::lst()`: 
##   tibble::lst(mean, median)
## 
##   # Using lambdas
##   list(~ mean(., trim = .2), ~ median(., na.rm = TRUE))

data_all <- data[[1]]
data_tested <- data[[2]]

Counts

Grouped by Season

Season	Year	Dates	Experimental Setup	N Tested	Wing Morph
Fall	2019	October 15 to October 23	30 min	182	short and long
Fall	2019	October 23 to October 29	60 min	130	short and long
Fall	2019	October 30 to November 4	90 min	126	short and long
Fall	2019	November 5 to November 8	unlimited	66	long
Winter	2020	February 17 to February 28	unlimited	332	long
Winter	2020	March 3 to March 10	unlimited	282	long


Season	Year	Dates	Experimental Setup	N Tested	Wing Morph
Fall	2019	October 15 to October 23	30 min	182	short and long
Fall	2019	October 23 to October 29	60 min	130	short and long
Fall	2019	October 30 to November 4	90 min	126	short and long
Fall	2019	November 5 to November 8	unlimited	66	long
Winter	2020	February 17 to February 28	unlimited	332	long
Winter	2020	March 3 to March 10	unlimited	282	long

Winter

Grouped by Sex

	All	Tested
F	274	119
M	484	213

Females that Laid Eggs:

	Females That Didn’t Lay Eggs	Females That Laid Eggs	Total Females	Sample Prop
Unique Values	25	94	119	0.79

Grouped by Population

Tested Bugs By Pop, Sex, and Trial Type (Unique)
	Sex Sample Sizes		Trial Sample Sizes
Population	Females	Males	Trial 1	Trial 2
Key Largo	18	27	45	43
North Key Largo	51	92	143	125
Lake Wales	6	5	11	9
Homestead	12	15	27	22
Gainesville	2	15	17	11
Plantation Key	17	36	53	46
Leesburg	3	9	12	9
Lake Placid	10	14	24	17

Number of bugs that died between T1 and T2
50

Tested Bugs By Population and Site
		Coordinates		Sample Sizes
population	site	latitude	longitude	n_site	n_pop
Gainesville	23rd & 8th	29.66200	-82.34731	17	17
Homestead	SW 296th St	25.49136	-80.48582	27	27
Key Largo	KLMRL	25.10002	-80.43752	23	45
Key Largo	JP	25.12846	-80.40809	22	45
Lake Placid	110N Main	27.29863	-81.36615	24	24
Lake Wales	Polk Ave	27.89674	-81.58047	11	11
Leesburg	Mount & 8th	28.79634	-81.87788	12	12
North Key Largo	Carysfort	25.25656	-80.31080	18	143
North Key Largo	Dagny Trellis	25.17557	-80.36780	18	143
North Key Largo	DD front	25.27349	-80.30410	32	143
North Key Largo	Dynamite Docks	25.28675	-80.29059	7	143
North Key Largo	Charlemagne	25.19515	-80.34592	21	143
North Key Largo	N. Dagny	25.18209	-80.36319	30	143
North Key Largo	MM165	25.22752	-80.32838	17	143
Plantation Key	Aregood Ln	24.97357	-80.55392	18	53
Plantation Key	Founder’s	24.96424	-80.56733	35	53

Tested Bugs By Host Plant, Population, and Site
			Coordinates		Sample Sizes
host plant	population	site	latitude	longitude	n_site	n_pop
K. elegans	Gainesville	23rd & 8th	29.66200	-82.34731	17	17
K. elegans	Leesburg	Mount & 8th	28.79634	-81.87788	12	12
K. elegans	Lake Wales	Polk Ave	27.89674	-81.58047	11	11
K. elegans	Lake Placid	110N Main	27.29863	-81.36615	24	24
K. elegans	Homestead	SW 296th St	25.49136	-80.48582	27	27
C. corindum	North Key Largo	Dynamite Docks	25.28675	-80.29059	7	143
C. corindum	North Key Largo	DD front	25.27349	-80.30410	32	143
C. corindum	North Key Largo	Carysfort	25.25656	-80.31080	18	143
C. corindum	North Key Largo	MM165	25.22752	-80.32838	17	143
C. corindum	North Key Largo	Charlemagne	25.19515	-80.34592	21	143
C. corindum	North Key Largo	N. Dagny	25.18209	-80.36319	30	143
C. corindum	North Key Largo	Dagny Trellis	25.17557	-80.36780	18	143
C. corindum	Key Largo	JP	25.12846	-80.40809	22	45
C. corindum	Key Largo	KLMRL	25.10002	-80.43752	23	45
C. corindum	Plantation Key	Aregood Ln	24.97357	-80.55392	18	53
C. corindum	Plantation Key	Founder’s	24.96424	-80.56733	35	53

Table 1. Field soapberry bugs collected and tested for flight trials.
Winter 2020
			Coordinates		Sample Sizes
host plant	population	site	latitude	longitude	$ n_{site}$	$ n_{pop}$
K. elegans	Gainesville	23rd & 8th	29.66200	-82.34731	17	17
K. elegans	Leesburg	Mount & 8th	28.79634	-81.87788	12	12
K. elegans	Lake Wales	Polk Ave	27.89674	-81.58047	11	11
K. elegans	Lake Placid	110N Main	27.29863	-81.36615	24	24
K. elegans	Homestead	SW 296th St	25.49136	-80.48582	27	27
C. corindum	North Key Largo	Dynamite Docks	25.28675	-80.29059	7	143
C. corindum	North Key Largo	DD front	25.27349	-80.30410	32	143
C. corindum	North Key Largo	Carysfort	25.25656	-80.31080	18	143
C. corindum	North Key Largo	MM165	25.22752	-80.32838	17	143
C. corindum	North Key Largo	Charlemagne	25.19515	-80.34592	21	143
C. corindum	North Key Largo	N. Dagny	25.18209	-80.36319	30	143
C. corindum	North Key Largo	Dagny Trellis	25.17557	-80.36780	18	143
C. corindum	Key Largo	JP	25.12846	-80.40809	22	45
C. corindum	Key Largo	KLMRL	25.10002	-80.43752	23	45
C. corindum	Plantation Key	Aregood Ln	24.97357	-80.55392	18	53
C. corindum	Plantation Key	Founder’s	24.96424	-80.56733	35	53

Table 1. Field soapberry bugs collected and tested for flight trials.
Fall 2019
			Coordinates		Sample Sizes
host plant	population	site	latitude	longitude	$ n_{site}$	$ n_{pop}$
K. elegans	Gainesville	NW 10th Ave & 18th St	29.66182	-82.34721	14	14
K. elegans	Leesburg	Veteran’s Memorial Park	28.81298	-81.87789	13	13
K. elegans	Lake Wales	Polk	27.90335	-81.58946	11	11
K. elegans	Lake Placid	Barber shop	27.29866	-81.36612	43	43
K. elegans	Homestead	SW 296th St & 182nd Ave	25.49197	-80.48562	34	34
C. corindum	North Key Largo	DD	25.28637	-80.29077	26	65
C. corindum	North Key Largo	DD front	25.27352	-80.30428	2	65
C. corindum	North Key Largo	Carysfort Cr	25.25648	-80.31069	8	65
C. corindum	North Key Largo	DD -inter	25.25284	-80.31183	2	65
C. corindum	North Key Largo	Charlemagne	25.19484	-80.34590	9	65
C. corindum	North Key Largo	N. Dagny	25.18229	-80.36370	5	65
C. corindum	North Key Largo	Dagny Trellis	25.17550	-80.36782	8	65
C. corindum	North Key Largo	Dagny 1/2 Loop	25.17369	-80.37153	5	65
C. corindum	Key Largo	JP Grove	25.12846	-80.40809	14	14
C. corindum	Plantation Key	Founder’s #2	24.98519	-80.54710	1	13
C. corindum	Plantation Key	Founder’s #1	24.96448	-80.56739	12	13

Data Stats

Mass Stats

	mass (g)
	mean	sd	sample size
F	0.079	0.024	213
M	0.039	0.007	398

	mass (g)
	mean	sd	sample size
C. corindum	0.054	0.025	453
K. elegans	0.049	0.022	0

	mass (g)
	C. corindum		K. elegans
	mean	sd	mean	sd
F	0.081	0.025	0.073	0.020
M	0.040	0.007	0.036	0.007

Morphology Stats

		All Bugs
		thorax (mm)		body (mm)		wing (mm)
	sample size	mean	sd	mean	sd	mean	sd
F	274	3.37	0.30	12.01	1.60	8.44	1.50
M	484	2.97	0.23	10.73	1.17	7.69	1.11

		Tested Bugs
		thorax (mm)		body (mm)		wing (mm)
	sample size	mean	sd	mean	sd	mean	sd
F	119	3.41	0.28	12.43	1.02	8.85	0.87
M	213	3.00	0.20	11.01	0.70	7.96	0.60

Flight Response Stats

	prop flew	sd	sample size
Trial 1	0.61	0.49	332
Trial 2	0.50	0.50	282

	Trial 1			Trial 2
	prop flew	sd	sample size	prop flew	sd	sample size
F	0.38	0.49	119	0.27	0.45	97
M	0.73	0.44	213	0.63	0.48	185

Distance Stats

	Distances Flew (m)
	Trial 1			Trial 2
	mean	sd	sample size	mean	sd	sample size
F	1361.29	3671.26	119	602.30	2091.15	97
M	1681.59	3504.31	213	1474.98	3353.59	185

	Distances Flew (m)
	Trial 1			Trial 2
	mean	sd	sample size	mean	sd	sample size
	1.70	6.42	133	0.49	1.28	140
B	49.90	137.07	89	150.37	686.44	67
BC	3157.61	4006.91	14	4590.96	5098.05	19
C	5109.65	4987.89	92	4473.25	4394.51	52
CB	302.84	203.58	4	328.44	171.67	4

	Distances Flew (m)
	Trial 1			Trial 2
	mean	sd	sample size	mean	sd	sample size
	1.70	6.42	133	0.49	1.28	140
B	49.90	137.07	89	150.37	686.44	67
C	4686.42	4882.94	110	4282.02	4530.75	75

Speed Stats

	Average Speed Flew (m/s)
	Trial 1			Trial 2
	mean	sd	sample size	mean	sd	sample size
F	0.17	0.18	119	0.09	0.14	97
M	0.22	0.15	213	0.20	0.17	185

	Average Speed Flew (m/s)
	Trial 1			Trial 2
	mean	sd	sample size	mean	sd	sample size
	0.07	0.15	133	0.03	0.11	140
B	0.28	0.12	89	0.28	0.13	67
BC	0.29	0.09	14	0.29	0.08	19
C	0.30	0.09	92	0.30	0.10	52
CB	0.27	0.13	4	0.26	0.15	4

	Average Speed Flew (m/s)
	Trial 1			Trial 2
	mean	sd	sample size	mean	sd	sample size
	0.07	0.15	133	0.03	0.11	140
B	0.28	0.12	89	0.28	0.13	67
C	0.30	0.09	110	0.30	0.10	75

Tables - Flight Trials Winter 2020

Anastasia Bernat

8/4/2020

Counts

Grouped by Season

Winter

Grouped by Sex

Females that Laid Eggs:

Grouped by Population

Data Stats

Mass Stats

Morphology Stats

Flight Response Stats

Distance Stats

Speed Stats