Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Sorry for the confusing question, I'm not sure how to word it right: here's a mock sample of my data

Name: Cheeseburger
Date: 1/20/2011
Stock: 30
Price: 200
Name: Hamburger
Date: 1/20/2011
Stock: 12
Price: 180
Name: Cheeseburger
Date: 1/21/2011
Stock: 31
Price: 210
...

I will have to make a table in excel or access capable of looking up the stock and price trends of a particular brand through time.

Trouble is, I have two independent variables (Stock, Price) and two known dependent variables (Name, Date).

So, I cannot use a simple table where the x axis is the name, y axis is the time, and the cells represent a quantity - each cell have to represent two quantities (Stock, Price)

Does anyone know how to do that? Thanks.

share|improve this question
    
Homework maybe? – Linker3000 Jan 31 '11 at 22:06
    
not quite - just a project I'm working on. – Xrave Jan 31 '11 at 22:11
up vote 0 down vote accepted

Don't confuse data structure with data analysis.

Your data have four variables: name, date, stock, price, which together represent a single unit-block and so the natural way to organize them is:

Name              date  Stock Price
-----------------------------------
Cheeseburger  1/20/2011    30   200
Hamburger     1/20/2011    12   180
Cheeseburger  1/21/2011     3   210

Obviously when you have to summarize your data in a 2x2 table, you have to choose which variable titles the rows, which one titles the columns and which one gives values. But remember: first comes data structure, then come summary tables.

Are you interested in brand price trend? Build a table Name x Date with cells containing price values.

Are you interested in brand stock trend? Build a table Name x Date with cells containing stock values.

share|improve this answer
    
thanks for clarifying. – Xrave Feb 20 '11 at 20:18

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .