Statistics in Excel?

[[email protected]]

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!

[Tushar Mehta]

If your data are organized in a tabular manner with 1 row per product, you
should be able to answer both questions with a PivotTable. For Q1 #days
would be the row field and count of product the data field.

For Q2 a cross-tab PT with the attribute of interest as the row field, the
#days as the column field and count of product as the data field.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
> 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!
>
>