1.
The Arizona AutomobileAssociations (AAA) is interested to compare the affordability of vacationing inArizona withother states. The daily hotel accommodation charges seem to be an importantfactor in selecting a vacation destination for many families.
AAA’s latest surrey of randomly selected 36resorts in Arizonarevealed the following daily charges for a one-bedroom suite during last year touristseason.

Daily Charge foe a  One-bedroom Suite ($)

317 304 210 285 186 243 281 385 260    165 296 275 324 309 232 271 245 412    265 230 312 237 264 404 355 276 312    195 329 320 286 167 312 185 428 311

Toassist AAA, you have been requested
toprepare the following parts:

a.Manually create:
i.
Frequency distribution (table)
ii.
Relative frequency
(table)
iii.
Cumulative frequency (table)
iv.
Histogram (graph)
v.
Ogive (graph)

b. Use Microsoft Excel andSPSS to create the frequency distribution and the histogram for your data andcompare them with your manual solutions.

c
AAA
would like to know the most expensive daily rate of the bottom 25% andthe least expensive daily rate of the top 25% for this data set.

d.Manually (do not use any computer) calculate the following descriptivestatistics forthe third row (only9 daily rates):