Question: b . How many fields are in the database? c . Are there any missing data? Hint: Use COUNTBLANK on all columns d . What

b.How many fields are in the database? c.Are there any missing data? Hint: Use COUNTBLANK on all columns d.What state was ranked 25th in population in 1993?Hint: Use MATCH(Large(H3:H53,25,H3:H53,0)e.What state had the largest percentage increase in population from 1990to 1999?Hint: Create new column for the percentage increase 1999over 1900and sort. f.Which states had populations of more than 1million and less than 2million in 1995?Hint: Use FILTER on population 1995and use the Number filter option to specify upper and lower limits.g.Create a histogram of the population by state for 1999and interpet it.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!