Problems

1. How many units of lip gloss did Zaret sell during 2004 and 2005?

2. Create a data table that contains each person’s total revenue and units sold.

3. How many units of lip gloss did Colleen sell outside the West region?

4. Using the data in file Makeupdb.xlsx, create a data table that shows the average per-unit revenue generated by each person for sales in which the average per-unit price exceeded $3.30.

5. Use the data in the file Sales.xlsx to determine the following:

   • Total dollar sales in the Midwest

   • Total dollars that Heather sold in the East

   • Total dollars that Heather sold or that were sold in the East

   • Total dollars sold in the East by Heather or John

   • Number of transactions in the East region

   • Number of transactions with greater than average sales

   • Total sales not in the Midwest

6. The file Housepricedata.xlsx contains the following information for selected homes:

   • Square footage

   • Price

   • Number of bathrooms

   • Number of bedrooms

   Use this information to answer the following questions:

   • What is the average price of all homes having a total number of bathrooms and bedrooms greater than or equal to 6?

   • How many homes sell for more than $300,000 and have a total number of bedrooms and bathrooms less than or equal to 5?

   • How many homes have at least 3 bathrooms but the total number of bedrooms and bathrooms is less than or equal to 6?

   • What is the highest price of a home having at most 3000 square feet and a total number of bedrooms and bathroom less than or equal to 6? (Hint: Use the DMAX function to solve this problem.)

7. The file Deciles.xlsx contains the unpaid balance for 20 accounts. Use DBASE functions to compute the total unpaid balances in each decile.