how to make a survey kids using openoffice spread sheet

I wanted to write something up briefly because I saw some interest on Twitter on converting fixed width files (one of the most popular ways to release large data sets, such as CPS survey data) into a more accessible format. How Can You Get Import Width Files Into R and Export to a Spreadsheet Program? That sheet shows what to use as inflation, normalized to 1999 ( see more). Annual CPI Deflator: Year is release year, but the CPS survey is March of the previous year and the income data is the 12 months of the preceding year.Age Weights: Total Workforce Weight and Weight by Age by Year (to allow normalization/comparison).Average_Income_Year: Average income by year, same definition.Age_Year_Avg_Income: Average income of full-time and part-time workers ( see definition), split by age and year.Incomes are of people who were in the workforce in the previous year: I also have the 'overall' averages by year, and weights for ages per year so you can play with the composition of the workforce and determine how it affects statistics like average income. I compiled some data on average incomes by year and split up by age. It has four sheets, which I will explain briefly.

Here you go, if you want to skip to the good stuff: The end result of this walkthrough is a CSV file which you should be able to import into your favorite spreadsheet program. Today I'm going to walk you through my workflow where I import fixed width data into R, manipulate it, and export it for usage on this site.

How to make a survey kids using openoffice spread sheet