You must have a high level of experience in excel and have references.
I need to create a data analysis model that will predict or show probability of a cancellation for my customers. For my current position, I want to see where or what indicators are common in our current or past customers at my company and then use that model to show the danger or probability in a new customer and when they would most likely cancel their business with us so that we can address any of the needs and concerns early to prevent cancellations.
So, what we would use is certain criteria to develop this model and logic to predict.
Criteria like; business size in square feet, age of business, locations (single location or maybe 4, 8, or more locations give a certain value), number of classes (we provide education for classes) at the time the business signed up (to show strength in their current programming, or weakness), cost of program that customer pays us, number of classes on schedule for our specific programming in their business location, etc..
Note: I image we can have about 20 different criteria that we use to build the model and then we can make adjustments after seeing how it predicts.
Summary: approximately 20 to 25 fields of data that will be entered in a common data entry screen and fed into the excel.
1. highlighted common indicators of when a business cancelled with us in each category size. Meaning, the customer/business is put into different categories based on data field entry (example: small, medium and large based on sq. foot size, another category is for-profit and non-profit business categories)
Note: so the model might show that customers that are small non-profit businesses cancel with us in month 6 more often and for-profit medium businesses cancel with us in month 13 more often.
2. highlighted outcomes of the "program type" that the customer is using of our program sold to them and what month is most common, business size, etc...
There are several more outcomes we are looking for, but this is the basic model we are looking for. It must be simple to data input and should provide no less than 6 pre-set reports that can be reproduced for emailing or sharing.
I need to have this completed in no less than 10 days.