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.