Often, cruise ships conduct all on-board transactions, with the exception of gambling, on a cashless basis. At the end of the cruise, guests pay one bill that covers allonboardtransactions. Suppose that 30 singles were surveyed as to their on-board bills for a seven-day cruise from Los Angeles to the Mexican Riviera. The data from their responses are as follows:

54; 57; 102; 145; 250; 333; 274; 58; 63; 129; 142; 300; 243; 256; 288; 176; 181; 59; 304; 264; 167; 136; 216; 189; 349; 450; 99; 187; 145; 222

1. Group the data by 50's, i.e. 1-50, 51-100, etc.

2. Use the data provided to create a histogram of thegrouped frequencytable. Show both the histogram and groupedfrequency table in Exc