Is there an Excel master here?

[sm0ke]

I can't figure out how to plot the data correctly. I need the data like this: x = year, y = real mean wage, and then separate lines for every cohort.

I thought I was getting it, but for the later cohorts that don't have a data entry for year=1940 (the first x value), the line still starts at 1940, and I couldn't figure out how to move it to the right.

I can't find a good website or video showing me how to do what I want to do. Does anybody here have any advice?

 

[88m3]

I need to figure out a couple formulas/functions in order to make this econ class project a little smoother and so I can pick up some skills along the way.

Basically, I have a column that has the mean wages for males and females in different age cohorts over time. I'm trying to get the wages in 2010 dollars. This implies dividing the wages by the proper CPI conversion factor according to the year (i.e. $100/0.064 for 1940).

What I need is either to get the original column in real wages (without manually going through and converting each cell) OR creating a new column with the values of the mean wage cells converted into 2010 dollars (again, without having to go through each cell and manually typing "=(E2)/0.064" and so on, for each cell.

Ideally, I'd like to have a formula that can look at the cell two rows to the left to see what year it is, and THEN divide the cell by the proper conversion factor.

I also might need help turning this into a cohort line graph, but that's not the issue at the moment.

Wish I could help you out, but I'm too busy mining bit coins right now.

 

[sm0ke]

Wish I could help you out, but I'm too busy mining bit coins right now.

Anyone? Anyone at all?

 

[69 others]

Anyone? Anyone at all?

upload you your file or the first few lines so we can see how it's organized and i might be able to help you out.

 

[sm0ke]

upload you your file or the first few lines so we can see how it's organized and i might be able to help you out.

https://docs.google.com/file/d/0B9qto88-qUE7SGdwMjJGMmJrU1k/edit?usp=sharing

The "male" sheet is just the data for males. That's the one I'd like to work on.

 

[69 others]

https://docs.google.com/file/d/0B9qto88-qUE7SGdwMjJGMmJrU1k/edit?usp=sharing

The "male" sheet is just the data for males. That's the one I'd like to work on.

do i need to be signed up to google to access it cause i can't i got it

 

[69 others]

https://docs.google.com/file/d/0B9qto88-qUE7SGdwMjJGMmJrU1k/edit?usp=sharing

The "male" sheet is just the data for males. That's the one I'd like to work on.

In the chart sheet i included a chart with the year in the x-axis, a realmeanwage line, and lines for people who were 20 in 1930, 1940 and 1950 but you can add the rest. i also included a pivot table which you should use to play with the data to see other ways you can look at it.

Xl Doc

 

[Ohene]

I need to figure out a couple formulas/functions in order to make this econ class project a little smoother and so I can pick up some skills along the way.

Basically, I have a column that has the mean wages for males and females in different age cohorts over time. I'm trying to get the wages in 2010 dollars. This implies dividing the wages by the proper CPI conversion factor according to the year (i.e. $100/0.064 for 1940).

What I need is either to get the original column in real wages (without manually going through and converting each cell) OR creating a new column with the values of the mean wage cells converted into 2010 dollars (again, without having to go through each cell and manually typing "=(E2)/0.064" and so on, for each cell.

Ideally, I'd like to have a formula that can look at the cell two rows to the left to see what year it is, and THEN divide the cell by the proper conversion factor.

I also might need help turning this into a cohort line graph, but that's not the issue at the moment.

Vlookup will help with this. How ever you would have to change the sheet so that the column is two columns to the right because VLOOKUP returns the value that is X columns to the right of the first. Unless negative column numbers work but i doubt that

 

[sm0ke]

In the chart sheet i included a chart with the year in the x-axis, a realmeanwage line, and lines for people who were 20 in 1930, 1940 and 1950 but you can add the rest. i also included a pivot table which you should use to play with the data to see other ways you can look at it.

Xl Doc

you did it

the chart on the "PivotTable" tab is all I need, really. I was trying to use the PivotChart/Table tool yesterday, but couldn't figure it out. Thanks a lot, man.

That cohort line graph is pretty cluttered looking, but I'm not sure how else I could display the data, other than the table itself.

Thanks again. This shyt was driving me nuts.

 

[Skooby]

Can someone explain vlookup in a simple way?