I have a set of retail data explaining how many sales per store occurred during each week of the past 52 weeks. I want to group these stores by which follow each other the best over the course of the year. Let's say they'll be 10-20 stores in each group, although this number will be refined based on the analysis. These groups will be used to then create location specific curves of distribution. By grouping I can smooth out anomalies while creating a bigger dataset to pull from. I also want to find those stores that have the biggest deviation from the mean.(adsbygoogle = window.adsbygoogle || []).push({});

It would be nice to also find variance within each group, what is statistically significant in these groupings.

I did a simple analysis by just creating curves for each store and comparing them to the mean. Then finding the percent difference for each week, and ranking each store by its average percent difference.

What is a better way to analyze each curve with respect to each other to create groups?

**Physics Forums - The Fusion of Science and Community**

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Grouping Stores based on past retail sales.

Loading...

Similar Threads for Grouping Stores based | Date |
---|---|

A Grouping Non-Continuous Variables | Jan 8, 2018 |

A Testing if probability is the same for two groups | May 31, 2017 |

I Representing Tiling and Packing Solutions | May 26, 2017 |

A Interpreting Poisson Regression Estimates across groups | Apr 25, 2017 |

Probability of winning scratch off lottery from a store that just sold a winner | Jan 5, 2012 |

**Physics Forums - The Fusion of Science and Community**