Need help creating a pivot table!

A) The first 12 records in the dataset are selected to look only at the response (MAX_SEV_IR) and the two predictors: WEATHER_R and TRAF_CON_R

Create two pivot tables that examine injury (MAX_SEV_IR) as a function of the 2 predictors for these 12 records. One pivot table will have MAX_SEV_IR (row) as a function of WEATHER_R (column) and the other will have MAX_SEV_IR (row) as a function of TRAF_CON_R (column). The values inside the cells should convey the count (how many records are in that cell).

QUESTION: What variable will go in the values section of the pivot table? I know I have to get the count of it but I am unsure of what variable will go there. Would it be NO_INJ_I?

Here is the dataset/excel sheets in case you need to look at them:

https://www.dropbox.com/s/qbw8c0ddx6yampo/Accidents.xls?dl=0

Here are the variables:

Variables

1

HOUR_I_R

1=rush hour, 0=not (rush = 6-9 am, 4-7 pm)

2

ALCOHOL_I

Alcohol involved = 1, not involved = 2

3

ALIGN_I

1 = straight, 2 = curve

4

STRATUM_R

1= NASS Crashes Involving At Least One Passenger Vehicle, i.e., A Passenger Car, Sport Utility Vehicle, Pickup Truck Or Van) Towed Due To Damage From The Crash Scene And No Medium Or Heavy Trucks Are Involved.

0=not

5

WRK_ZONE

1= yes, 0= no

6

WKDY_I_R

1=weekday, 0=weekend

7

INT_HWY

Interstate? 1=yes, 0= no

8

LGTCON_I_R

Light conditions - 1=day, 2=dark (including dawn/dusk), 3=dark, but lighted,4=dawn or dusk

9

MAN_COL_I

0=no collision, 1=head-on, 2=other form of collision

10

PED_ACC_R

1=pedestrian/cyclist involved, 0=not

11

REL_JCT_I_R

1=accident at intersection/interchange, 0=not at intersection

12

REL_RWY_R

1=accident on roadway, 0=not on roadway

13

PROFIL_I_R

1= level, 2= grade, 3= hillcrest, 8= other, 9= unknown

14

SPD_LIM

Speed limit, miles per hour

15

SUR_CON

Surface conditions (1=dry, 2=wet, 3=snow/slush, 4=ice, 5=sand/dirt/oil, 8=other, 9=unknown)

16

TRAF_CON_R

Traffic control device: 0=none, 1=signal, 2=other (sign, officer )

17

TRAF_WAY

1=two-way traffic, 2=divided hwy, 3=one-way road

18

VEH_INVL

Number of vehicles involved

19

WEATHER_R

1=no adverse conditions, 2=rain, snow or other adverse condition

20

INJURY_CRASH

1=yes, 0= no

21

NO_INJ_I

Number of injuries

22

PRPTYDMG_CRASH

1=property damage, 2=no property damage

23

FATALITIES

1= yes, 0= no

24

MAX_SEV_IR

0=no injury, 1=non-fatal inj., 2=fatal inj.