IFSM 201

USA Counties spreadsheet.

Download the counties2010.txt file from the class web site.

Open it in Notepad or Mac TextEditor.
What font, style, and size is your Notepad using:___________ _________ __
What county is on line 2325:_________
What character is at column 31 of line 598: _
Find your home county: 
 What is it (name, state, population, area):______________ __ ________ ______
 What line number is it on:________
Which states have a county named Mineral:______________________
What is the range of fips values for Montana (MT):_______ to ________
What separates the fields/columns of the data:__________
Print this completed section.

Import counties2010.txt into Excel.  
Save it as an Excel Workbook.

Add a column "income" that is the product of population and percapIncome.
Format the three monetary columns in accounting style but without any cents.

Add a column "Pop density" that is the quotient of population and area.
Format it to one decimal digit.
Format the other columns in comma style, without decimal point.

Choose a state from the list below (states with too few counties are not on the list).
Everybody does a different state. Sign up for it in class.
Filter out all states but yours,  i.e. display just one state.
Sort your state's counties in decreasing order of income.
Print the first page of this.

On a separate worksheet, for your state:
 Show the minimum, maximum, total, and average county population, area, and income.  
 Show the minimum and maximum per capita income and population density.
 Show the average population density by dividing the total population by the total area.
 Show the number of counties.
You might need to copy your filtered counties to a new sheet.
Format this summary report attractively. 
 The statistics should be in the same format as their data.

Make a scatter plot of the population versus area. 
 Show the linear regression line and the R^2 value.
Make a scatter plot of percapIncome and medianHouseholdIncome.
 Show the linear regression line and the R^2 value.
Put each on a sheet by itself and print them.


Repeat the statistical summary for all the counties of the USA, i.e. the entire file.
Put this on the same sheet as your state's summary statistics.
Print it.

****************************************************************************
Alabama 	
Alaska 	
Arizona 	
Arkansas
California 	
Colorado 	
Florida 	
Georgia 	
Idaho
Illinois 	
Indiana 	
Iowa 	
Kansas
Kentucky 	
Louisiana 	
Maine 	
Maryland
Massachusetts 	
Michigan 	
Minnesota 	
Mississippi
Missouri 	
Montana 	
Nebraska 	
Nevada
New Jersey 	
New Mexico 	
New York
North Carolina 	
North Dakota 	
Ohio 	
Oklahoma
Oregon 	
Pennsylvania 	
South Carolina
South Dakota 	
Tennessee 	
Texas 	
Utah
Vermont 	
Virginia 	
Washington 	
West Virginia
Wisconsin 	
Wyoming