Calculate the Chi Square Statistic in Excel with formula from this data set:

Sales Rep Expenses ($)

Crawford 221.62

Crawford 80.43

Crawford 235.95

Crawford 90.22

Crawford 109.55

Crawford 196.65

Crawford 208.21

Crawford 161.27

Crawford 192.56

Crawford 219.88

Crawford 152.11

Crawford 107.67

Crawford 190.24

Crawford 137.77

Jones 93.62

Jones 232.13

Jones 200.63

Jones 147.17

Jones 278.75

Jones 259.81

Jones 195.69

Jones 81.94

Jones 96.67

Jones 155.37

Jones 260.21

Jones 202.88

Jones 164.96

Jones 270.46

Smith 217.62

Smith 170.03

Smith 159.52

Smith 179.71

Smith 126.35

Smith 85.77

Smith 152.22

Smith 114.13

Smith 135.01

Rogers 172.22

Rogers 198.19

Rogers 82.32

Rogers 81.95

Rogers 220.49

Rogers 241.04

Rogers 235.67

Rogers 85.18

Rogers 84.95

Rogers 235.41

Rogers 219.49

Rogers 240.22

Rogers 181.08

Rogers 224.62

Rogers 114.66