Create a gt-format table of results from EJAM — table_gt_from

Uses the list of results of ejamit()

Usage

table_gt_from_ejamit(ejamitoutput = NULL, type = c("demog", "envt")[1])

Arguments

ejamitoutput: list of EJAM results formatted as in testoutput_ejamit_100pts_1miles, as would be the output of ejamit()
type: Must be "demog" or "envt" – Creates one of these at a time

Value

Provides table in gt format from the R package called gt

Details

See the R package called gt. Also see code that creates html tables from html template and code that creates formatted spreadsheets like table_xls_format()

Examples

 table_gt_from_ejamit(testoutput_ejamit_100pts_1miles)


  Socioeconomic Indicators
      Value
      Average
 in State¹
      Percentile
 in State¹
      Average
 in USA
      Percentile
 in USA
      Ratio to
 State Avg.
      Ratio to
 USA Avg.
    
Demographic Index USA
167.69%
149.13%
63.53
134.07%
69
1.25
1.3
Supplemental Demographic Index USA
169.39%
146.84%
59.06
164.23%
59
1.11
1.0
% People of Color
58%
45%
64
40%
71
1.3
1.5
% Low Income
32%
28%
60
30%
58
1.2
1.0
% Unemployed
6%
6%
63
6%
67
1.1
1.1
% in limited English-speaking Households
7%
6%
70
5%
80
1.2
1.5
% with Less Than High School Education
14%
12%
62
11%
69
1.2
1.2
% under Age 5
6%
5%
59
5%
60
1.1
1.1
% over Age 64
14%
17%
45
18%
43
0.8
0.8
¹ Avg. in state means the average indicator value, among all the residents at these sites, using the statewide value in each resident's state. Percentile in state means the same, but using the site-specific value (expressed as a percentile) where each resident lives.

Socioeconomic Indicators	Value	Average in State¹	Percentile in State¹	Average in USA	Percentile in USA	Ratio to State Avg.	Ratio to USA Avg.
Demographic Index USA	167.69%	149.13%	63.53	134.07%	69	1.25	1.3
Supplemental Demographic Index USA	169.39%	146.84%	59.06	164.23%	59	1.11	1.0
% People of Color	58%	45%	64	40%	71	1.3	1.5
% Low Income	32%	28%	60	30%	58	1.2	1.0
% Unemployed	6%	6%	63	6%	67	1.1	1.1
% in limited English-speaking Households	7%	6%	70	5%	80	1.2	1.5
% with Less Than High School Education	14%	12%	62	11%	69	1.2	1.2
% under Age 5	6%	5%	59	5%	60	1.1	1.1
% over Age 64	14%	17%	45	18%	43	0.8	0.8
¹ Avg. in state means the average indicator value, among all the residents at these sites, using the statewide value in each resident's state. Percentile in state means the same, but using the site-specific value (expressed as a percentile) where each resident lives.