Question

Sales Rep   Expenses ($)
Crawford   221.39
Crawford   81.58
Crawford   233.43
Crawford   87.54
Crawford   108.43
Crawford   200.73
Crawford   212.59
Crawford   162.23
Crawford   192.52
Crawford   215.36
Crawford   150.78
Crawford   111.17
Crawford   187.45
Crawford   135.86
Jones   94.35
Jones   232.76
Jones   195.17
Jones   148.33
Jones   278.91
Jones   264.97
Jones   200.33
Jones   81.23
Jones   96.48
Jones   153.56
Jones   256.86
Jones   201.57
Jones   164.09
Jones   270.56
Smith   217.52
Smith   170.19
Smith   158.11
Smith   184.25
Smith   125.65
Smith   87.19
Smith   151.95
Smith   113.32
Smith   134.43
Rogers   172.51
Rogers   199.28
Rogers   80.01
Rogers   81.34
Rogers   220.09
Rogers   236.23
Rogers   233.31
Rogers   84.59
Rogers   85.29
Rogers   238.83
Rogers   218.01
Rogers   245.88
Rogers   180.59
Rogers   224.36
Rogers   113.79

Conduct a chi-square test using a level of significance of 0.05 to determine if normal distribution can reasonably model the expense data in the accompanying Travel Expenses data. Click the icon to view the Travel Expenses data. Create a frequency table Bin Frequency 0-100 101-125 126-150 151-175 176-200 201-225 226-250 251-275 276-300 (Type whole numbers.)

Answer 1

The frequency table is given below. I used MS Excel to complete this table.

Bin	Class Boundaries	Frequency
0-100	-0.5-100.5	10
101-125	100.5-125.5	4
126-150	125.5-150.5	4
151-175	150.5-175.5	8
176-200	175.5-200.5	7
201-225	200.5-225.5	9
226-250	225.5-250.5	6
251-275	250.5-275.5	3
276-300	275.5-300.5	1