Instructions: Building on the knowledge gained from the previous spreadsheet exercise using the Fun Fact States website, create a spreadsheet using the unorganized data below.

 

Unorganized Data:

Alabama-- Pop 2001-- 4,464,356-- GSP 1999-- 115,071-- Per Capita Personal Income 1999-- 22,694
Alaska-- Pop 2001-- 634,892-- GSP 1999-- 26,353-- Per Capita Personal Income 1999-- 27,994
Arizona-- Pop 2001-- 5,307,331-- GSP 1999-- 143,683-- Per Capita Personal Income 1999-- 23,755
Arkansas-- Pop 2001-- 2,692,090-- GSP 1999-- 64,773-- Per Capita Personal Income 1999-- 21,107
California-- Pop 2001-- 34,501,130-- GSP 1999-- 1,229,098-- Per Capita Personal Income 1999-- 29,772
Colorado-- Pop 2001-- 4,417,714-- GSP 1999-- 153,728-- Per Capita Personal Income 1999-- 30,206
Connecticut-- Pop 2001-- 3,425,074-- GSP 1999-- 151,779-- Per Capita Personal Income 1999-- 38,441
Delaware-- Pop 2001-- 796,165-- GSP 1999-- 34,669-- Per Capita Personal Income 1999-- 29,207
Florida-- Pop 2001-- 16,396,515-- GSP 1999-- 442,895-- Per Capita Personal Income 1999-- 26,593
Georgia-- Pop 2001-- 8,383,915-- GSP 1999-- 275,719-- Per Capita Personal Income 1999-- 26,499
Hawaii-- Pop 2001-- 1,224,398-- GSP 1999-- 40,914-- Per Capita Personal Income 1999-- 26,800
Idaho-- Pop 2001-- 1,321,006-- GSP 1999-- 34,025-- Per Capita Personal Income 1999-- 22,371
Illinois-- Pop 2001-- 12,482,301-- GSP 1999-- 445,666-- Per Capita Personal Income 1999-- 30,301
Indiana-- Pop 2001-- 6,114,745-- GSP 1999-- 182,202-- Per Capita Personal Income 1999-- 25,625
Iowa-- Pop 2001-- 2,923,179-- GSP 1999-- 85,243-- Per Capita Personal Income 1999-- 24,962
Kansas-- Pop 2001-- 2,694,641-- GSP 1999-- 80,843-- Per Capita Personal Income 1999-- 26,155
Kentucky-- Pop 2001-- 4,065,556-- GSP 1999-- 113,539-- Per Capita Personal Income 1999-- 22,682
Louisiana-- Pop 2001-- 4,465,430-- GSP 1999-- 128,959-- Per Capita Personal Income 1999-- 22,274
Maine-- Pop 2001-- 1,286,670-- GSP 1999-- 34,064-- Per Capita Personal Income 1999-- 24,268
Maryland-- Pop 2001-- 5,375,156-- GSP 1999-- 174,710-- Per Capita Personal Income 1999-- 31,641
Massachusetts-- Pop 2001-- 6,379,304-- GSP 1999-- 262,564-- Per Capita Personal Income 1999-- 34,485
Michigan-- Pop 2001-- 9,990,817-- GSP 1999-- 308,310-- Per Capita Personal Income 1999-- 27,854
Minnesota-- Pop 2001-- 4,972,294-- GSP 1999-- 172,982-- Per Capita Personal Income 1999-- 30,105
Mississippi-- Pop 2001-- 2,858,029-- GSP 1999-- 64,286-- Per Capita Personal Income 1999-- 20,109
Missouri-- Pop 2001-- 5,629,707-- GSP 1999-- 170,470-- Per Capita Personal Income 1999-- 25,877
Montana-- Pop 2001-- 904,433-- GSP 1999-- 20,636-- Per Capita Personal Income 1999-- 21,490
Nebraska-- Pop 2001-- 1,713,235-- GSP 1999-- 53,744-- Per Capita Personal Income 1999-- 26,656
Nevada-- Pop 2001-- 2,106,074-- GSP 1999-- 69,864-- Per Capita Personal Income 1999-- 28,786
New Hampshire-- Pop 2001-- 1,259,181-- GSP 1999-- 44,229-- Per Capita Personal Income 1999-- 30,425
New Jersey-- Pop 2001-- 8,484,431-- GSP 1999-- 331,544-- Per Capita Personal Income 1999-- 34,622
New Mexico-- Pop 2001-- 1,829,146-- GSP 1999-- 51,026-- Per Capita Personal Income 1999-- 20,949
New York-- Pop 2001-- 19,011,378-- GSP 1999-- 754,590-- Per Capita Personal Income 1999-- 32,585
North Carolina-- Pop 2001-- 8,186,268-- GSP 1999-- 258,592-- Per Capita Personal Income 1999-- 25,302
North Dakota-- Pop 2001-- 634,448-- GSP 1999-- 16,991-- Per Capita Personal Income 1999-- 22,969
Ohio-- Pop 2001-- 11,373,541-- GSP 1999-- 361,981-- Per Capita Personal Income 1999-- 26,753
Oklahoma-- Pop 2001-- 3,460,097-- GSP 1999-- 86,382-- Per Capita Personal Income 1999-- 22,505
Oregon-- Pop 2001-- 3,472,867-- GSP 1999-- 109,694-- Per Capita Personal Income 1999-- 26,261
Pennsylvania-- Pop 2001-- 12,287,150-- GSP 1999-- 382,980-- Per Capita Personal Income 1999-- 27,993
Rhode Island-- Pop 2001-- 1,058,920-- GSP 1999-- 32,546-- Per Capita Personal Income 1999-- 27,769
South Carolina-- Pop 2001-- 4,063,011-- GSP 1999-- 106,917-- Per Capita Personal Income 1999-- 22,906
South Dakota-- Pop 2001-- 756,600-- GSP 1999-- 21,631-- Per Capita Personal Income 1999-- 24,460
Tennessee-- Pop 2001-- 5,740,021-- GSP 1999-- 170,085-- Per Capita Personal Income 1999-- 24,723
Texas-- Pop 2001-- 21,325,018-- GSP 1999-- 687,272-- Per Capita Personal Income 1999-- 26,224
Utah-- Pop 2001-- 2,269,789-- GSP 1999-- 62,641-- Per Capita Personal Income 1999-- 22,305
Vermont-- Pop 2001-- 613,090-- GSP 1999-- 17,164-- Per Capita Personal Income 1999-- 25,522
Virginia-- Pop 2001-- 7,187,734-- GSP 1999-- 242,221-- Per Capita Personal Income 1999-- 29,299
Washington-- Pop 2001-- 5,987,973-- GSP 1999-- 209,258-- Per Capita Personal Income 1999-- 29,819
West Virginia-- Pop 2001-- 1,801,916-- GSP 1999-- 40,685-- Per Capita Personal Income 1999-- 20,697
Wisconsin-- Pop 2001-- 5,401,906-- GSP 1999-- 166,481-- Per Capita Personal Income 1999-- 26,869
Wyoming-- Pop 2001-- 494,423-- GSP 1999-- 17,448-- Per Capita Personal Income 1999-- 25,986

 

Using the above data, create a spreadsheet in the Microsoft Excel Spreadsheet below to organize the above data.

***First, you need to to click on the export to Excel icon on the Tool Bar, and save the spreadsheet either on your computer or on a floppy disk as an Excel file. Do this first in order to ensure that the data that you input in the spreadsheet is saved. If you do not save first and you leave this page (e.g., by clicking the "Back to Home Page" or the "Go to Instructions for the Student"), you will lose all of the information that has been put in the spreadsheet. Remember to answer the questions at the end once you have completed the activity.

To use this Web page interactively, you must have Microsoft® Internet Explorer 4.01 or later and the Microsoft Office Web Components.  See the Microsoft Office Web site for more information.

 

Questions

  1. What are the headings of the spreadsheet (Or, what information is found in Row 1, in columns A, B, C, and D)?
  2. If we ranked the states in ascending order, which state would be listed first, which would be listed last?
  3. Why is a spreadsheet useful in analyzing data? How did using a spreadsheet help you with the unorganized data above?
  4. What are three examples of other types of information that would benefit from being presented in a spreadsheet format?
  5. If I looked at your spreadsheet, what would I find in Column C in row 35 if the states are alphabetized and the Population GSP, and Personal Income headings are alphabetized?

 

Lesson Extension: You can use spreadsheets for so many things. In the Graphs Graphs Graphs Lesson we will learn how to use spreadsheets to create charts and graphs. If you'd like to see another extension of how to use spreadsheets, go to Descriptive Statistics and read the Introduction and learn more about the following topics: Mode, Median, Mean, Central Tendency, Variation, Range, Variance, and Standard Deviation.

Once you have completed the tour of the Descriptive Statistics website, print out and complete the Descriptive Statistics Word Search.

 

 


 

 

Back to Kellie's Home Page

Go to Learning Data Analysis

Go to Instructions for the Student

Go to Instructions for the Teacher

 

These pages were made through TeacherTECH, the teacher professional development component of GirlTECH, which is sponsored by the Center for Excellence and Equity in Education (CEEE) with support from the National Science Foundation through EOT-PACI, RGK Foundation, the Verizon Foundation, Rice University, and HiPerSoft.

Copyright © June 2002 by Kellie Butler.