A
azspecter
I tried to do a search, but haven't found my answer. I am trying to run
some statistics, and yes I have the Analysis tools installed.
I have a group of products that I want to do different things with. The
1st task is this:
I want to run #s and display a chart that will tell me how many days
products have sat on the shelf. Each product has the # of days it was
on the shelf- and multiple products have sat on the shelf for the same
# of days (ie- 5 products took 3 days to sell, 2 products took 120 days
to sell, etc). I want to see how many products sold for each count of
days on the shelf. The end result will display a chart so I can see
which products, on average, sat on the shelf the most often number of
days, and how many days exactly that was. Notice- this is NOT
displaying the products that took the longest to sell- it's displaying
the 'sweet spot' of the majority of the products sold on day 47 or
whatever.
Task 2-
I want to run #s to display comparison charts of various attributes.
For example- the products that took the longest to sell compared to
their individual weight. Or- which products sold the fastest compared
to their color. Or- which products sell the fastest compared to their
location in the store, etc. I think you get the idea.
It's been many years since I took statistical analysis in college, but
Im sure it'll come back to me when I start seeing the answers here. Any
help you guys can provide is EXTREMELY appreciated!
Thanks!
some statistics, and yes I have the Analysis tools installed.
I have a group of products that I want to do different things with. The
1st task is this:
I want to run #s and display a chart that will tell me how many days
products have sat on the shelf. Each product has the # of days it was
on the shelf- and multiple products have sat on the shelf for the same
# of days (ie- 5 products took 3 days to sell, 2 products took 120 days
to sell, etc). I want to see how many products sold for each count of
days on the shelf. The end result will display a chart so I can see
which products, on average, sat on the shelf the most often number of
days, and how many days exactly that was. Notice- this is NOT
displaying the products that took the longest to sell- it's displaying
the 'sweet spot' of the majority of the products sold on day 47 or
whatever.
Task 2-
I want to run #s to display comparison charts of various attributes.
For example- the products that took the longest to sell compared to
their individual weight. Or- which products sold the fastest compared
to their color. Or- which products sell the fastest compared to their
location in the store, etc. I think you get the idea.
It's been many years since I took statistical analysis in college, but
Im sure it'll come back to me when I start seeing the answers here. Any
help you guys can provide is EXTREMELY appreciated!
Thanks!