Re: Statistics in Excel?

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 <1146037973.637181.230720@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
azspecter@xxxxxxxxx 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!


.

Relevant Pages

  • Statistics in Excel?
    ... some statistics, and yes I have the Analysis tools installed. ... on the shelf- and multiple products have sat on the shelf for the same ... I want to see how many products sold for each count of ... The end result will display a chart so I can see ...
    (microsoft.public.excel.charting)
  • Re: Small proto boxes with LCD and buttons?
    ... The one I saw did not have download capabilities but could display the depth profile of a dive on its LCD. ... on the $500 unit, the 1/3 rule applies to everything you sell, not to each specific product, its an average, you could have loss leaders that sells for 1/2 cost/sell ratio to get customers in the door, and then sell others with a 1/5 cost/sell ratio to keep you business. ... I have designed loss leaders myself but for corporations who made their core revenue with other products that generated a solid profit per unit. ...
    (sci.electronics.design)
  • FS: Project Pins ID4, DM, also DM parts.
    ... I have a few games I would like to sell off. ... sort, a few missing transistors, I will let them go for $300, with display. ... I have a spare head for a DM, in nice shape, covered in a plastic protector. ... Also a DM display panel, with metal hooks and speakers, in nice shape. ...
    (rec.games.pinball)
  • Re: OT - Walmart Service Surprise
    ... They had a computer on display ... that they weren't going to stock any more and they had none in stock, ... but they wouldn't sell the floor model because that is their policy. ... but that he would ask a manager. ...
    (rec.crafts.textiles.quilting)
  • Re: LCD TVs as computer monitors.
    ... (either on the shelf or the Product itself) ... when you ask what Resolution ... a Display has (cos they always answer questions like that by referring ...
    (uk.people.silversurfers)