The database Tissue.xlsx contains a transaction history describing more than 3,700 purchases of facial tissues at a

Question:

The database Tissue.xlsx contains a transaction history describing more than 3,700 purchases of facial tissues at a number of stores in a grocery chain over a period of several weeks.

a. How many records are in this database?

b. How many fields are in this database?

c. Is the field STORE nominal or numerical?

d. How many records have a price exceeding 5?

e. Which field contains blank cells, and how many does it contain?

f. For what percentage of records does profit equal zero?

g. What is the second-highest value for profit?

h. Compare the average price across stores.

i. Compare the distribution of profit across the weeks.

j. Describe the relationship between price and profit for items on sale (SALE = S).

k. How much average profit did STORE 102 make in WEEK 390?

Distribution
The word "distribution" has several meanings in the financial world, most of them pertaining to the payment of assets from a fund, account, or individual security to an investor or beneficiary. Retirement account distributions are among the most...