Statistics in Excel?

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!
 
T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top