8. Using the OccupancyRate and LotCode columns, construct box plots for each parking lot. You can use Insert > Insert Statistic Chart >Box and Whisker for this purpose. Do all parking lots experience approximately equal occupancy rates? Are some parking lots more frequented than others? Is this what you expected? 9. Select any 2 parking lots. For each one, prepare a scatter plot showing the occupancy rate against TimeStamp for the week 11/20/2016 –11/26/2016. Are the occupancy rates time-dependent? If so, which times seem to experience the highest occupancy rates? Is this what you expected?

Cooper, cpa, is auditing the financial statements of a small rural municipality. the receivable balances represent residents’ delinquent real estate taxes. internal control at the municipality is weak. to determine the existence of the accounts receivable balances at the balance sheet date, cooper would most likely: cooper, cpa, is auditing the financial statements of a small rural municipality. the receivable balances represent residents’ delinquent real estate taxes. internal control at the municipality is weak. to determine the existence of the accounts receivable balances at the balance sheet date, cooper would most likely:

Investment x offers to pay you $5,700 per year for 9 years, whereas investment y offers to pay you $8,300 per year for 5 years. if the discount rate is 6 percent, what is the present value of these cash flows? (do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) present value investment x $ investment y $ if the discount rate is 16 percent, what is the present value of these cash flows? (do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) present value investment x $ investment y

On january 1, year 1, purl corp. purchased as a long-term investment $500,000 face amount of shaw, inc.’s 8% bonds for $456,200. the bonds were purchased to yield 10% interest. the bonds mature on january 1, year 6, and pay interest annually on january 1. purl uses the effective interest method of amortization. what amount (rounded to nearest $100) should purl report on its december 31, year 2, balance sheet for these held-to-maturity bonds?