SOLVE USING EXCEL

Conduct a chi-square test using a level of significance of 0.05 to determine if a normal distribution can reasonably model the expense data in the accompanying Travel Expenses data.

BIN Frequency

0-100 10

101-125 4

126-150 4

151-175 8

176-200 7

201-225 8

226-250 7

251-275 3

276-300 1

total 52

Sales Rep Expenses ($)

Crawford 224.03

Crawford 81.44

Crawford 235.74

Crawford 88.85

Crawford 109.84

Crawford 194.84

Crawford 207.93

Crawford 158.86

Crawford 193.08

Crawford 213.02

Crawford 153.18

Crawford 107.73

Crawford 192.17

Crawford 138.41

Jones 91.06

Jones 232.86

Jones 194.98

Jones 146.48

Jones 276.16

Jones 263.22

Jones 193.98

Jones 82.77

Jones 95.22

Jones 153.07

Jones 251.85

Jones 202.89

Jones 164.95

Jones 268.57

Smith 223.42

Smith 172.87

Smith 160.75

Smith 182.61

Smith 128.97

Smith 86.69

Smith 154.64

Smith 112.84

Smith 134.97

Rogers 168.03

Rogers 202.09

Rogers 81.63

Rogers 81.67

Rogers 218.22

Rogers 235.74

Rogers 231.18

Rogers 85.17

Rogers 82.53

Rogers 237.15

Rogers 219.02

Rogers 238.87

Rogers 181.06

Rogers 226.04

Rogers 112.42