The database Income.xlsx‡ contains average personal income data for a number of states over the years 1929-1999.

a. How many records are in this database?

b. How many fields are in this database?

c. What was the absolute increase in the personal income of Maine over this period?

d. What was the percentage increase in the personal income of California over this period?

e. In what years was the personal income of Illinois at, or under, 399 and that of Massachusetts at, or over, 613?

f. Plot the personal income for Connecticut over this time period.

g. Create a histogram of average personal income by state for 1999 and interpret it