Working with a couple of guys from my gym on building a Bio Age calculator. I am pretty comfortable in Excel but don't have a math/stats back ground so need some direction.
For an individual we capture responses to approx. 17 multiple choice questions which will give us 17 'bio markers'(BM)...
Hi all,
Working with some raw scan data & for each SKU I want to assign the price break it falls into.
Price Breaks are standardised: $0-5 | $5-8 | $8-11 | $11-14 | $14-19 | $19-35 | $35+
I have a column that shows average sell price for each SKU & I want to use this to determine which...
Figured it out & have uploaded to Google Docs...
https://spreadsheets.google.com/ccc?key=0Akyp1dAnVK67dGwtMHM5T0dhdUc2cm9OazNQRFJLTEE&hl=en&authkey=COT9k4oG
Andrew
Using Excel for 6 years.
- Employed in the Australian Liquor Industry.
- Background in Sales Analysis, Category Management, Commercial Finance, Market Intelligence & Insights.
- Currently consulting and getting more serious about it.
Focus on...
1. building Excel tools to make...
I built a horizontal bar chart showing the Top 10 Fastest Growing Brands.
- On the category axis I have the brand names.
- On the secondary category axis I have their total volume as labels.
- Series 1 plots the actual growth in litres.
- Series 2 is the % growth. Bars are hidden and I...