Beginner Question: correlation of Units & Average Price

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

snapshotjen
Posts: 1
Joined: Wed Jun 27, 2012 10:31 pm

Beginner Question: correlation of Units & Average Price

Postby snapshotjen » Wed Jun 27, 2012 10:43 pm

Hello all,

I'm so glad I found this forum! I'm really hopping someone can help me out; I haven't touched SPSS since college and I'm a little rusty. I'm wanting to run a correlation, get SD & Pearson Coefficient. What data I'm looking at is for coffee makers (brand & model). I have the Units sold and Average Price across 5 weeks. I want to see if there is a correlation across the 5 weeks in regards to units sold and average price. For example, if X brand/model coffee maker had a lower price in week 3 (as apposed to week 2, possibly indicating a drop in price) does this have a negative correlation with the average price (i.e., as units go up does average price go down). My main question is - how do I set my data up in excel before running it in SPSS? I have hundreds of brands/items I'm looking at. I'm so confused!

Thank you so much for helping & I look forward to the benifits of this forum.

Who is online

Users browsing this forum: No registered users and 2 guests

cron