Use Excel’s COUNTIF function to find the number of days with a PM2.5 AQI value over 50. Use this to find the proportion of days for which the air quality was not good in your sample. You will need to know the number of successes, the sample size, and the proportion of successes for to continue.

Perform a four-step hypothesis test (hypothesize, prepare, compute to compare, and interpret) to test whether the proportion of days which do not have “Good” air quality has changed. Insert any work done using StatCrunch into your Mod 8 tab.

Date	AQS_SITE_ID	POC	Daily Mean PM2.5 Concentration	UNITS	DAILY_AQI_VALUE	DAILY_OBS_COUNT	PERCENT_COMPLETE	AQS_PARAMETER_CODE	AQS_PARAMETER_DESC	CBSA_CODE	CBSA_NAME	STATE_CODE	STATE	COUNTY_CODE	COUNTY	SITE_LATITUDE	SITE_LONGITUDE
1/1/2005	360290005	1	7.8	ug/m3 LC	33	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
1/4/2005	360290005	1	13.3	ug/m3 LC	54	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
1/7/2005	360290005	1	7	ug/m3 LC	29	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
1/10/2005	360290005	1	10.1	ug/m3 LC	42	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
1/13/2005	360290005	1	8.6	ug/m3 LC	36	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
1/16/2005	360290005	1	12.6	ug/m3 LC	52	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
1/22/2005	360290005	1	8.7	ug/m3 LC	36	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
1/25/2005	360290005	1	13.9	ug/m3 LC	55	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
1/28/2005	360290005	1	29.1	ug/m3 LC	87	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
1/31/2005	360290005	1	26.4	ug/m3 LC	81	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
2/3/2005	360290005	1	39.7	ug/m3 LC	111	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
2/6/2005	360290005	1	34.2	ug/m3 LC	97	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
2/9/2005	360290005	1	10	ug/m3 LC	42	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
2/12/2005	360290005	1	13.9	ug/m3 LC	55	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
2/15/2005	360290005	1	16.4	ug/m3 LC	60	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
2/18/2005	360290005	1	4.6	ug/m3 LC	19	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
2/21/2005	360290005	1	15.1	ug/m3 LC	57	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
2/24/2005	360290005	1	12.5	ug/m3 LC	52	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
2/27/2005	360290005	1	11.5	ug/m3 LC	48	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
3/2/2005	360290005	1	5.6	ug/m3 LC	23	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
3/5/2005	360290005	1	28.7	ug/m3 LC	86	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
3/8/2005	360290005	1	5.7	ug/m3 LC	24	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
3/11/2005	360290005	1	17	ug/m3 LC	61	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
3/14/2005	360290005	1	8.4	ug/m3 LC	35	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
3/17/2005	360290005	1	20.8	ug/m3 LC	69	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
3/20/2005	360290005	1	18	ug/m3 LC	63	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
3/23/2005	360290005	1	3.9	ug/m3 LC	16	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
3/26/2005	360290005	1	12.5	ug/m3 LC	52	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
3/29/2005	360290005	1	12.1	ug/m3 LC	51	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
4/1/2005	360290005	1	4.9	ug/m3 LC	20	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
4/7/2005	360290005	1	25.1	ug/m3 LC	78	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
4/10/2005	360290005	1	8.1	ug/m3 LC	34	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
4/13/2005	360290005	1	8	ug/m3 LC	33	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
4/16/2005	360290005	1	14.8	ug/m3 LC	57	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
4/19/2005	360290005	1	29.3	ug/m3 LC	87	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
4/22/2005	360290005	1	7	ug/m3 LC	29	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
4/25/2005	360290005	1	5.9	ug/m3 LC	25	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
4/28/2005	360290005	1	8.9	ug/m3 LC	37	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
5/1/2005	360290005	1	15.2	ug/m3 LC	58	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
5/4/2005	360290005	1	12.2	ug/m3 LC	51	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
5/7/2005	360290005	1	26.5	ug/m3 LC	81	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
5/10/2005	360290005	1	19.1	ug/m3 LC	66	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
5/13/2005	360290005	1	5	ug/m3 LC	21	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
5/16/2005	360290005	1	4	ug/m3 LC	17	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
5/19/2005	360290005	1	8.7	ug/m3 LC	36	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
5/22/2005	360290005	1	3	ug/m3 LC	13	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
5/25/2005	360290005	1	5.2	ug/m3 LC	22	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
5/28/2005	360290005	1	7.5	ug/m3 LC	31	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
5/31/2005	360290005	1	8.3	ug/m3 LC	35	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
6/3/2005	360290005	1	6.1	ug/m3 LC	25	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
6/6/2005	360290005	1	15.1	ug/m3 LC	57	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
6/9/2005	360290005	1	30.5	ug/m3 LC	90	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
6/12/2005	360290005	1	33.3	ug/m3 LC	96	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
6/15/2005	360290005	1	8.9	ug/m3 LC	37	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
6/18/2005	360290005	1	3	ug/m3 LC	13	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
6/21/2005	360290005	1	25.4	ug/m3 LC	79	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
6/24/2005	360290005	1	23.8	ug/m3 LC	76	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
6/27/2005	360290005	1	27.5	ug/m3 LC	83	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
6/30/2005	360290005	1	28.5	ug/m3 LC	85	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
7/3/2005	360290005	1	13.7	ug/m3 LC	54	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
7/6/2005	360290005	1	7.1	ug/m3 LC	30	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
7/9/2005	360290005	1	10.3	ug/m3 LC	43	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
7/12/2005	360290005	1	24.7	ug/m3 LC	77	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
7/15/2005	360290005	1	28	ug/m3 LC	84	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
7/18/2005	360290005	1	33.7	ug/m3 LC	96	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
7/21/2005	360290005	1	18.4	ug/m3 LC	64	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
7/24/2005	360290005	1	14.2	ug/m3 LC	55	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
7/27/2005	360290005	1	6.9	ug/m3 LC	29	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
7/30/2005	360290005	1	13.7	ug/m3 LC	54	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
8/2/2005	360290005	1	21	ug/m3 LC	70	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
8/5/2005	360290005	1	5.8	ug/m3 LC	24	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
8/8/2005	360290005	1	21.2	ug/m3 LC	70	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
8/11/2005	360290005	1	15.1	ug/m3 LC	57	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
8/14/2005	360290005	1	9	ug/m3 LC	38	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
8/17/2005	360290005	1	11.4	ug/m3 LC	48	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
8/20/2005	360290005	1	11.1	ug/m3 LC	46	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
8/23/2005	360290005	1	5	ug/m3 LC	21	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
8/26/2005	360290005	1	15.8	ug/m3 LC	59	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
8/29/2005	360290005	1	18.2	ug/m3 LC	64	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
9/1/2005	360290005	1	8.5	ug/m3 LC	35	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
9/4/2005	360290005	1	6.9	ug/m3 LC	29	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
9/7/2005	360290005	1	25.6	ug/m3 LC	79	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
9/10/2005	360290005	1	8	ug/m3 LC	33	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
9/13/2005	360290005	1	47	ug/m3 LC	129	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
9/16/2005	360290005	1	10.5	ug/m3 LC	44	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
9/19/2005	360290005	1	22	ug/m3 LC	72	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
9/22/2005	360290005	1	21.7	ug/m3 LC	71	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
9/28/2005	360290005	1	11.2	ug/m3 LC	47	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
10/1/2005	360290005	1	21.7	ug/m3 LC	71	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
10/4/2005	360290005	1	44.7	ug/m3 LC	124	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
10/7/2005	360290005	1	5.1	ug/m3 LC	21	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
10/22/2005	360290005	1	4.8	ug/m3 LC	20	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
10/31/2005	360290005	1	17.9	ug/m3 LC	63	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
11/3/2005	360290005	1	11.8	ug/m3 LC	49	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
11/6/2005	360290005	1	10.2	ug/m3 LC	43	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
11/9/2005	360290005	1	8	ug/m3 LC	33	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
11/12/2005	360290005	1	9	ug/m3 LC	38	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
11/15/2005	360290005	1	11	ug/m3 LC	46	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
11/18/2005	360290005	1	7.6	ug/m3 LC	32	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
11/21/2005	360290005	1	15.5	ug/m3 LC	58	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
11/24/2005	360290005	1	1.8	ug/m3 LC	8	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
11/27/2005	360290005	1	19.4	ug/m3 LC	66	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
11/30/2005	360290005	1	7	ug/m3 LC	29	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
12/3/2005	360290005	1	2.7	ug/m3 LC	11	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
12/6/2005	360290005	1	14.5	ug/m3 LC	56	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
12/9/2005	360290005	1	17.6	ug/m3 LC	63	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
12/12/2005	360290005	1	13.4	ug/m3 LC	54	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
12/15/2005	360290005	1	15.1	ug/m3 LC	57	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
12/18/2005	360290005	1	17.4	ug/m3 LC	62	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
12/21/2005	360290005	1	17.5	ug/m3 LC	62	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
12/24/2005	360290005	1	32.1	ug/m3 LC	93	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
12/27/2005	360290005	1	11.6	ug/m3 LC	48	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
12/30/2005	360290005	1	8.4	ug/m3 LC	35	1	100	88101	PM2.5 - Local Conditions	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
1/4/2005	360290005	6	14.3	ug/m3 LC	56	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
1/10/2005	360290005	6	12.6	ug/m3 LC	52	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
1/16/2005	360290005	6	13	ug/m3 LC	53	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
1/22/2005	360290005	6	10.1	ug/m3 LC	42	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
1/28/2005	360290005	6	27.3	ug/m3 LC	83	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
2/3/2005	360290005	6	41.7	ug/m3 LC	116	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
2/9/2005	360290005	6	10.3	ug/m3 LC	43	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
2/15/2005	360290005	6	16.7	ug/m3 LC	61	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
2/21/2005	360290005	6	15.2	ug/m3 LC	58	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
2/27/2005	360290005	6	13.3	ug/m3 LC	54	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
3/5/2005	360290005	6	31.7	ug/m3 LC	92	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
3/11/2005	360290005	6	17	ug/m3 LC	61	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
3/17/2005	360290005	6	31.2	ug/m3 LC	91	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
3/23/2005	360290005	6	6.6	ug/m3 LC	28	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
3/29/2005	360290005	6	14.7	ug/m3 LC	56	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
4/4/2005	360290005	6	6.5	ug/m3 LC	27	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
4/10/2005	360290005	6	8.8	ug/m3 LC	37	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
4/16/2005	360290005	6	15.1	ug/m3 LC	57	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
4/22/2005	360290005	6	6.2	ug/m3 LC	26	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
4/28/2005	360290005	6	9.1	ug/m3 LC	38	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
5/4/2005	360290005	6	13.6	ug/m3 LC	54	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
5/10/2005	360290005	6	20.7	ug/m3 LC	69	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
5/16/2005	360290005	6	4	ug/m3 LC	17	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
5/22/2005	360290005	6	4.2	ug/m3 LC	18	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
5/28/2005	360290005	6	8.7	ug/m3 LC	36	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
6/3/2005	360290005	6	6.7	ug/m3 LC	28	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
6/9/2005	360290005	6	30.9	ug/m3 LC	91	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
6/15/2005	360290005	6	8.3	ug/m3 LC	35	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
6/21/2005	360290005	6	26	ug/m3 LC	80	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
6/27/2005	360290005	6	28.9	ug/m3 LC	86	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
7/3/2005	360290005	6	13.6	ug/m3 LC	54	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
7/9/2005	360290005	6	10.8	ug/m3 LC	45	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
7/15/2005	360290005	6	28.4	ug/m3 LC	85	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
7/21/2005	360290005	6	18.9	ug/m3 LC	65	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
7/27/2005	360290005	6	7.5	ug/m3 LC	31	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
8/2/2005	360290005	6	24.8	ug/m3 LC	78	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
8/8/2005	360290005	6	21.2	ug/m3 LC	70	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
8/14/2005	360290005	6	8.6	ug/m3 LC	36	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
8/20/2005	360290005	6	12.8	ug/m3 LC	52	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
8/26/2005	360290005	6	16	ug/m3 LC	59	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
9/1/2005	360290005	6	8.6	ug/m3 LC	36	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
9/7/2005	360290005	6	25.8	ug/m3 LC	80	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
9/13/2005	360290005	6	45.8	ug/m3 LC	126	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
9/19/2005	360290005	6	21.9	ug/m3 LC	72	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
9/25/2005	360290005	6	27.2	ug/m3 LC	83	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
10/1/2005	360290005	6	22.5	ug/m3 LC	73	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
10/7/2005	360290005	6	5.4	ug/m3 LC	23	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
10/13/2005	360290005	6	5.2	ug/m3 LC	22	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
10/19/2005	360290005	6	6.8	ug/m3 LC	28	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
10/25/2005	360290005	6	3.3	ug/m3 LC	14	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
10/31/2005	360290005	6	18.5	ug/m3 LC	64	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
11/6/2005	360290005	6	11.8	ug/m3 LC	49	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
11/12/2005	360290005	6	10.1	ug/m3 LC	42	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
11/18/2005	360290005	6	8.3	ug/m3 LC	35	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
11/24/2005	360290005	6	2.6	ug/m3 LC	11	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
11/30/2005	360290005	6	7.8	ug/m3 LC	33	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
12/6/2005	360290005	6	13.8	ug/m3 LC	55	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
12/12/2005	360290005	6	12	ug/m3 LC	50	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
12/18/2005	360290005	6	27.6	ug/m3 LC	84	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601
12/30/2005	360290005	6	9	ug/m3 LC	38	1	100	88502	Acceptable PM2.5 AQI & Speciation Mass	15380	Buffalo-Cheektowaga-Niagara Falls, NY	36	New York	29	Erie	42.87690667	-78.80952601

Answer rating: 100% (QA)

1 What is the yearly payment amount required for the note payable Explanation We are given the following information Face value of the note payable 1100000 Date of issue of the note payable Oct120Y4 D... View the full answer