05-08-2013, 01:06 AM | #1 |
PM Bug Supporter Join Date: Oct 2011 Location: SE USA
Posts: 1,275
Liked: 691 times | Factor Analysis of Ameru Sales My newest article is very numbers-intensive, so will not likely appeal to most of you, but I hope that some of you guys (wait, wait, I know at least one!) who might... "Factor Analysis" is a multivariate statistical routine that seeks to simplify complex data sets into a relatively compact model, yet retain some predictive power. I am hoping to use this and other methods to help me find useful nuggets in our sales data, like (an example) if I buy 500 pcs of X, how confident should I be in buying 200 pcs of Y if they are used in the same vehicle? http://tinyurl.com/bsjlho7 I am only an "advanced beginner" with this, I have a little training, but as they say, "a little knowledge is a very dangerous thing". Comments and suggestions for further work are extremely welcome! |
05-08-2013, 06:35 AM | #2 |
Golden Cockroach Join Date: Oct 2011 Location: In Scrooge McDuck's vault
Posts: 7,027
Liked: 2449 times | Sorry DCRB, it looks all Greek to me. Glad you got your computer working again.
__________________ The journey of a thousand miles begins with a single step. - Lao Tzu Important stuff: PMBug 101 * Forum Guidelines * Support PMBug |
05-08-2013, 09:11 AM | #3 |
Super Moderator Join Date: Mar 2012 Location: Migratory
Posts: 1,620
Liked: 685 times | Interesting read; a few comments: 1) You do have some really strong correlations, which is great for you. Typically, I only see correlation coefficients over 0.9 in a class room example! 2) If you have a decent idea of what products are correlated with product X, why don't you try something like multiple linear regression? Even excel has a free patch download that includes regression (data analysis I believe) that lets you run up to 16 variables through regression. This will give you an equation to calcuate how many of a certain product to purchase given certain inputs. Essentially, if you know how many of product 1(X) you are going to buy, how many of product 2 (Y) to purchase. Regression will solve the beta0 and beta1 portion of the below equation. Y = beta0 + beta1*X http://en.wikipedia.org/wiki/Regression_analysis http://office.microsoft.com/en-us/ex...010219001.aspx
__________________ I drive men mad For love of me, Easily beaten, Never free. PMBug 101 *** Forum Rules Last edited by benjamen; 05-08-2013 at 09:27 AM. |
05-08-2013, 10:40 AM | #4 |
PM Bug Supporter Join Date: Oct 2011 Location: SE USA
Posts: 1,275
Liked: 691 times | ... benjamen, a multiple regression along the lines of what you suggest looks like a great idea, thanks! *** I am wondering about the very high correlations as well. Perhaps business data does not behave in the messy way of typical "Social Sciences" studies that show correlations of 0.3 - 0.6, for example. But a correlation of 0.463 (as in one of my examples) does me little good as a buyer! Another thing I need to be looking at would be "spurious correlations" (The Signal and the Noise, Nate Silver). These would be apparently related pieces that got in the "by chance" only. But, as my data set gets larger, and as I do this more often (say every three months), those spurious correlations should lessen. The regression method you suggest would at least give me a prediction as well as an error component. That could be very useful, and it is better than just "dead reckoning". |
05-08-2013, 10:50 AM | #5 | |
Super Moderator Join Date: Mar 2012 Location: Migratory
Posts: 1,620
Liked: 685 times |
Things to watch for in your regression model: R square: You want this to be high; essentially means what percentage of the variance is explained by your model Significance F: You want this to be low; essentially means the chance your model is completely useless p-value of each predictor variable: you want this to be low; essentially means the chance that predictor variable is completely useless
__________________ I drive men mad For love of me, Easily beaten, Never free. PMBug 101 *** Forum Rules | |
Thread Tools | |
| |
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Analysis please... | AgNostic | PM Bug | 9 | 04-04-2013 10:53 AM |
Rhodium (ten page analysis inside) | swissaustrian | PM Bug | 17 | 07-11-2012 10:51 AM |
Analysis of trading data on April 4th smash | PMBug | PM Bug | 5 | 04-19-2012 06:00 PM |
Silver demand and supply analysis | Silver_Bug | Silver Bug | 8 | 12-22-2011 04:23 PM |
Gold price analysis tools, charts, tables | DoChenRollingBearing | Gold Bug | 3 | 11-03-2011 07:26 PM |