I have 3 data sets in an ArcGIS project: 1. a state shapefile 2. stations attribute table with coordinates, and 3. attribute table with amount of precipitation for each station for one year.

I need to create a map showing the average summer (June, July, August) precipitation in Oregon. Hint is to create a new field and calculate the values. How do I go about creating this map? Pictures of the two table are below to help:

Stations:

precipitation:

Let me know if there is any other information that I missed to include. Thanks!

M COOPID TYPE STATION_NAME LATDEG LATMIN LONDEG LONMIN ELEV LAT LON ObjectID * 1 350036 XNP ADEL 42 11 119 54 4583 42.183333 - 119.9 1 2 2. 350118 XNP ALKALI LAKE 42 58 120 0 4332 42.966667 -120 2 3 3 350145 P ALSEA FH FALL CREEK 44 24 123 45 230 44.4 -123.75 3 4 4 350197 XNP ANTELOPE 1 NW 44 55 120 44 2840 44.916667 - 120.733333 4 Field: Add Calculate Selection: Select By Attributes Zoom To Switch Clear Delete copy Rows: NUM STATION JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC ANN- ObjectID * 4. 5 6 150 PORT ORFORD 5 E 18.68 16.4 15.68 9.49 6.06 3.43 0.95 1.78 3.31 7.76 17.25 20.07 120.86 150 137 OTIS 2 NE 14.13 11.81 10.81 7.22 5.25 3.72 1.72 1.66 3.8 7.56 14.63 15.82 98.13 137 3 ALSEA F H FALL CREEK 14.06 12.38 10.29 6.92 4.28 2.45 0.79 1.17 2.97 6.02 14.51 15.86 91.7 3 191 TIDEWATER 2 SW 14.22 11.93 10.88 7 4.66 2.77 0.87 1.16 2.72 5.92 14.07 15.42 91.62 191 192 TILLAMOOK 1 W 13.09 10.79 9.9 6.81 4.84 3.41 1.64 1.42 3.68 7.16 13.72 13.94 90.4 192 7 00 8 M COOPID TYPE STATION_NAME LATDEG LATMIN LONDEG LONMIN ELEV LAT LON ObjectID * 1 350036 XNP ADEL 42 11 119 54 4583 42.183333 - 119.9 1 2 2. 350118 XNP ALKALI LAKE 42 58 120 0 4332 42.966667 -120 2 3 3 350145 P ALSEA FH FALL CREEK 44 24 123 45 230 44.4 -123.75 3 4 4 350197 XNP ANTELOPE 1 NW 44 55 120 44 2840 44.916667 - 120.733333 4 Field: Add Calculate Selection: Select By Attributes Zoom To Switch Clear Delete copy Rows: NUM STATION JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC ANN- ObjectID * 4. 5 6 150 PORT ORFORD 5 E 18.68 16.4 15.68 9.49 6.06 3.43 0.95 1.78 3.31 7.76 17.25 20.07 120.86 150 137 OTIS 2 NE 14.13 11.81 10.81 7.22 5.25 3.72 1.72 1.66 3.8 7.56 14.63 15.82 98.13 137 3 ALSEA F H FALL CREEK 14.06 12.38 10.29 6.92 4.28 2.45 0.79 1.17 2.97 6.02 14.51 15.86 91.7 3 191 TIDEWATER 2 SW 14.22 11.93 10.88 7 4.66 2.77 0.87 1.16 2.72 5.92 14.07 15.42 91.62 191 192 TILLAMOOK 1 W 13.09 10.79 9.9 6.81 4.84 3.41 1.64 1.42 3.68 7.16 13.72 13.94 90.4 192 7 00 8