I have windows 7 with Office 2010. Using the Excel software, is it possible to analayse data to make predictions? For example if the shop in question does a paper based survey of clients and finds that every 3 weeks a 40-50 year olds buys a black dress and spends 拢50, every 2 days a 20-30 year spends 拢25 on brown shoes etc is it possible with lots of that data of ages, clothes items etc to predict as best as possible that eg tomorrow a 40 year old will buy a blue shirt. This is not for stock purposes but more for anaylsing clients needs, spending habits etc. I have already put most of the data on a spreadsheet.
With the above data I already have on an Excel spreadsheet do you happen to know if there is a way/formulae to sort data automatically without clicking on sort, smallest to largest etc. For example if column A has values a to z and column B has number values can I set it up some way that columns C and D automtically sort and show the largest number values and their a to z value if I makes changes to column A or B? At the moment I am copying and pasting A and B to other columns and sorting, smalled to largest etc manually.
You can take a slew of data and "forecast" what is coming next. This obviously isn't necessarily true but you can take a Trouwjurken look at trends and see where the trend is leading. This is a very common thing to do in business, particularly restaurants for ordering food etc.
As far as auto-sorting, there are various ways to do it. Een Schouder Prom Dresses You can use formulas Vintage Trouwjurk or VBA macros. It's odd to house the sorted data right next to your source data though. Usually you only want to see a snippit and so it is previewed on another worksheet, separate from the main database. That being said.
No comments:
Post a Comment