County	Region	PoorPhysHealthDays	PoorMentalHealthDays	Smoking	Obesity	FEI	Access	HighSchoolGrad	IncomeInequality	SocialAssociations
Allegany County	1	3.85	4.16	0.21	0.29	8.20	0	0.86	4.20	17.49
Cattaraugus County	1	4.25	4.41	0.23	0.28	8.10	0	0.84	4.29	14.89
Chautauqua County	1	4.15	3.95	0.24	0.33	7.80	0	0.83	4.69	17.28
Erie County	1	3.73	3.92	0.18	0.29	7.80	1	0.82	5.09	9.90
Niagara County	1	4.27	3.83	0.22	0.32	8.10	1	0.83	4.64	10.35
Genesee County	2	3.83	4.14	0.20	0.27	8.60	0	0.89	4.09	12.90
Livingston County	2	3.69	3.80	0.17	0.30	8.20	0	0.89	4.47	11.13
Monroe County	2	3.51	3.97	0.16	0.28	7.80	1	0.83	4.87	8.84
Ontario County	2	3.10	3.55	0.18	0.28	8.50	1	0.89	4.29	9.58
Orleans County	2	3.69	4.21	0.22	0.31	8.00	0	0.85	4.22	12.75
Seneca County	2	3.51	3.73	0.18	0.29	8.10	1	0.83	4.48	11.77
Wayne County	2	3.94	4.14	0.21	0.32	8.50	0	0.88	3.83	10.83
Wyoming County	2	3.72	3.69	0.22	0.27	8.20	0	0.90	3.71	16.34
Yates County	2	3.22	3.61	0.16	0.26	8.70	0	0.86	4.52	14.77
Broome County	3	3.83	3.88	0.20	0.27	8.00	1	0.83	4.85	11.96
Chemung County	3	3.94	4.01	0.21	0.33	7.80	1	0.73	4.81	12.75
Chenango County	3	3.61	3.82	0.19	0.31	8.50	0	0.84	4.46	11.87
Delaware County	3	3.49	3.66	0.19	0.29	8.50	0	0.83	4.53	13.90
Schuyler County	3	3.65	3.87	0.17	0.27	8.30	0	0.81	4.51	11.55
Steuben County	3	3.86	3.81	0.19	0.33	8.10	0	0.84	4.43	11.57
Tioga County	3	3.78	3.64	0.17	0.30	8.70	0	0.83	4.52	13.55
Tompkins County	3	3.44	3.70	0.15	0.24	7.70	1	0.86	5.75	10.20
Cayuga County	4	3.47	3.58	0.20	0.31	8.50	1	0.81	4.21	11.11
Cortland County	4	3.50	3.93	0.18	0.28	8.20	1	0.83	4.30	11.75
Madison County	4	3.10	3.80	0.18	0.28	8.60	0	0.83	4.18	9.74
Onondaga County	4	3.43	3.64	0.17	0.27	8.00	1	0.81	5.00	10.46
Oswego County	4	3.86	3.91	0.22	0.30	8.00	0	0.80	4.38	9.65
Clinton County	5	3.78	3.92	0.21	0.30	7.50	0	0.85	4.72	8.74
Essex County	5	3.42	3.49	0.17	0.27	8.60	1	0.86	3.97	15.85
Franklin County	5	3.82	4.04	0.23	0.27	7.40	0	0.83	5.13	10.46
Hamilton County	5	3.09	3.13	0.14	0.28	7.70	1	0.83	4.46	27.59
Jefferson County	5	3.83	3.75	0.19	0.31	7.60	0	0.85	4.04	10.46
Lewis County	5	3.30	3.44	0.17	0.33	8.10	0	0.88	3.98	17.81
St. Lawrence County	5	4.15	3.96	0.18	0.30	7.60	0	0.82	4.64	10.99
Fulton County	6	4.03	3.92	0.21	0.25	8.10	1	0.74	4.41	9.82
Herkimer County	6	3.60	3.95	0.20	0.31	7.90	0	0.81	4.38	11.25
Montgomery County	6	4.14	3.94	0.20	0.29	7.80	0	0.77	4.74	9.06
Oneida County	6	3.86	3.84	0.17	0.32	8.00	1	0.82	4.66	11.48
Otsego County	6	3.43	3.77	0.17	0.30	7.80	0	0.85	4.36	12.53
Schoharie County	6	3.54	3.59	0.18	0.28	8.20	0	0.81	4.34	8.94
Albany County	7	3.20	3.68	0.15	0.26	8.00	1	0.81	4.91	14.77
Columbia County	7	3.38	3.40	0.18	0.24	8.40	0	0.83	4.28	10.40
Greene County	7	3.74	3.57	0.18	0.24	8.20	0	0.86	4.58	10.08
Rensselaer County	7	3.51	3.77	0.17	0.29	8.30	0	0.87	4.43	8.67
Saratoga County	7	3.20	3.50	0.16	0.27	8.80	1	0.89	3.93	7.82
Schenectady County	7	3.64	3.94	0.16	0.27	8.10	1	0.79	4.66	8.28
Warren County	7	3.49	3.33	0.18	0.26	8.40	1	0.83	4.22	13.29
Washington County	7	3.70	3.79	0.19	0.31	8.30	0	0.82	4.01	10.45
Dutchess County	8	3.19	3.76	0.15	0.24	8.60	1	0.85	4.54	7.61
Orange County	8	3.80	3.70	0.15	0.30	8.70	1	0.86	4.78	7.28
Putnam County	8	3.01	3.39	0.15	0.25	9.30	1	0.92	4.09	7.37
Rockland County	8	3.35	3.26	0.12	0.24	8.80	1	0.86	5.27	9.97
Sullivan County	8	4.29	3.93	0.18	0.30	8.20	0	0.78	4.87	11.49
Ulster County	8	3.62	3.93	0.16	0.26	8.10	1	0.83	4.82	9.21
Westchester County	8	3.15	3.27	0.11	0.21	9.20	1	0.88	6.04	8.41
Nassau County	9	3.03	3.37	0.11	0.23	9.70	1	0.91	4.49	7.84
Suffolk County	9	3.23	3.18	0.15	0.25	9.40	1	0.89	4.39	6.54
Bronx County	10	4.73	4.17	0.16	0.30	7.90	1	0.60	6.56	2.64
Kings County	10	3.49	3.81	0.15	0.23	7.40	1	0.69	6.55	4.81
New York County	10	3.27	3.47	0.13	0.16	8.30	1	0.70	8.93	12.93
Queens County	10	3.32	3.25	0.12	0.24	8.70	1	0.71	4.91	4.66
Richmond County	10	3.67	4.07	0.16	0.28	9.10	1	0.79	5.42	4.49
County: Tells you the name of county in New York State
Region: The New York State Department of Economic Development divides NYS counties into nine different regions. These regions are coded as follows:
1 = Western New York
2 = Finger Lakes
3 = Southern Tier
4 = Central New York
5 = North Country
6 = Mohawk Valley
7 = Capital District
8 = Hudson
9 = Long Island
10 = New York City
PoorPhysHealthDays: Indicates the average number of days residents of a particular county report feeling physically unhealthy each month
PoorMentalHealthDays: Indicates the average number of days residents of a particular county report feeling mentally unhealthy each month
Smoking: Indicates the proportion of adults within a given county who currently smoke
Obesity: Indicates the proportion of adults within a given county who are currently obese
FEI: Provides information on the Food Environment Index; This measure explains the amount of access that residents of a given county have to healthy foods. The measure is reported on a 0-10 scale, with 10 indicating the healthiest food environment.
Access: Indicates whether a county has high or low levels of access to exercise opportunities (e.g., parks, biking trails, etc.). The variable is coded such that:
0 = Low access to exercise opportunities
1 = High access to exercise opportunities
HighSchoolGrad*: Indicates the proportion of county residents who have graduated from high school
IncomeInequality: Indicates the disparity of wealth/income within a county. Specifically, this variable is calculated by creating a ratio of household income at the 80th percentile within a county and comparing it to the household income at the 20th percentile within a county. Thus, larger numbers indicate greater disparities in wealth distribution.
SocialAssociations: A measure of the number of social associations in a county per 10,000 population. Social associations include religious groups, civic organizations, clubs, etc.
QUESTIONS
1.. Is there a difference in the average number of days of poor mental health experienced between counties with high and low access to exercise opportunities?"
2.. How does the prevalence of smoking within counties relate to the average number of days of poor mental health experienced?" Which statistical test will you use to address/test this question?
3.. Review the average level of health in each county in New York State including: the total number of counties in your study (i.e., sample size),
4.. What is the variable measuring? What does a higher/lower score imply? Report means/standard
5.. Make a table that shows the average number of days of poor physical health per month and the associated standard deviation in each NYS region
6.. Make a graph to show the average number of days of poor mental health per month in each NYS region
7.. Based on county-level analyses, identify/describe at least two indicators of county health that stood out as problematic across NYS counties. Why did these indicators stand out to you?
8.. Based on regional-level analyses, indicate whether any particular region of NYS seems to show particular challenges related to physical/mental health.