Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Statistics in Excel?
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Please help with Statistics Formulas in Excel | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Opening two separate instances of Excel | Excel Discussion (Misc queries) | |||
Displaying frequency polygons in Excel (Statistics) | Charts and Charting in Excel |