⋮
To find the sites that have the highest mean NO2, sort the timetable.
sortedMeanNO2bySite = sortrows(meanNO2bySite,"mean_MeasuredNO2","descend")
sortedMeanNO2bySite=1585×6 table
StateName
CountyName
SiteNum
Year
GroupCount
mean_MeasuredNO2
__________
__________
_______
____
__________
________________
California
LosAngeles
1103
1988
8272
61.526
California
LosAngeles
1103
1986
8083
61.266
California
LosAngeles
1103
1985
8217
59.965
California
LosAngeles
1105
1985
1194
58.399
California
LosAngeles
1002
1986
8084
57.422
California
LosAngeles
1002
1985
8159
57.401
California
LosAngeles
1701
1989
8299
57.118
California
LosAngeles
1701
1986
8229
55.924
California
LosAngeles
1103
1989
8135
55.335
California
LosAngeles
1701
1987
8284
54.864
California
LosAngeles
1601
1989
8201
54.685
California
LosAngeles
1701
1985
8341
54.147
California
LosAngeles
1103
1987
8150
54.092
California
LosAngeles
1601
1988
7546
53.828
California
LosAngeles
1601
1985
8307
53.377
California
LosAngeles
2005
1989
8225
53.174
⋮
You can create a table that includes only those sites exceeding 53 ppb by using logical indexing.
Create a logical vector that indicates the rows where mean_MeasuredNO2 is greater than 53. Use
that vector as a subscript to get matching rows from meanNO2bySite.
exceeded53ppb = meanNO2bySite.mean_MeasuredNO2 > 53;
sitesExceed53ppb = meanNO2bySite(exceeded53ppb,:)
sitesExceed53ppb=19×6 table
StateName
CountyName
SiteNum
Year
GroupCount
mean_MeasuredNO2
__________
__________
_______
____
__________
________________
California
LosAngeles
2
1988
8278
53.17
California
LosAngeles
1002
1985
8159
57.401
California
LosAngeles
1002
1986
8084
57.422
California
LosAngeles
1002
1988
8176
53.004
California
LosAngeles
1103
1985
8217
59.965
California
LosAngeles
1103
1986
8083
61.266
California
LosAngeles
1103
1987
8150
54.092
California
LosAngeles
1103
1988
8272
61.526
California
LosAngeles
1103
1989
8135
55.335
California
LosAngeles
1105
1985
1194
58.399
California
LosAngeles
1601
1985
8307
53.377
California
LosAngeles
1601
1988
7546
53.828
California
LosAngeles
1601
1989
8201
54.685
California
LosAngeles
1701
1985
8341
54.147
California
LosAngeles
1701
1986
8229
55.924
California
LosAngeles
1701
1987
8284
54.864
⋮
Grouped Calculations in Tables and Timetables
9-93