The database Book Club.xlsx contains data on a number of current customers of a direct-mail book club.

Question:

The database Book Club.xlsx‡ contains data on a number of current customers of a direct-mail book club.

a. How many records are in this database?

b. How many fields are in this database?

c. How many fields have missing data?

d. What is the highest value for the amount spent on all products?

e. How many records are female s who first purchased 2 months ago?

f. What is the overall distribution of the amount spent on all products?

g. Does the distribution of the amount spent on all products change substantially with the number of Italian books purchased?

h. How are the amounts spent on all purchases and the number of purchases related?

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...