Rechercher un cas : 0 résultats

Survival Analysis in Microsoft Excel without Add-ins

9B17E011
Résumé
Survival analysis refers to a collection of statistical techniques used to analyze the occurrence and expected timing of events. Survival analysis can provide not only the probability of an event of interest occurring, but also the time at which the event is likely to occur. A particularly useful application of survival analysis is in the area of "customer churn"--the loss of clients or customers--which is a major concern in many industries. This note introduces survival analysis and discusses two approaches to examine customer churn: the Kaplan-Meier estimator and the Cox proportional hazards model. Instructions are provided on how to build these models in Microsoft Excel, without add-ins.
Objectifs pédagogiques
This note is well suited for undergraduate and graduate courses dealing with data science, data mining, or analytics. The aim of this note is to: ·Introduce survival analysis to a business audience. ·Inform readers of the applications of survival analysis in different contexts and industries. ·Compare with classical techniques such as linear regression. ·Guide readers through the construction of two popular survival models in Microsoft Excel in order to analyze and draw insights from customer churn data. ·Demonstrate how statistical techniques can bolster management decision-making.
Mots-clés
statistics; regression; Kaplan-Meier; Cox model; proportional hazards
Public
Undergraduate/MBA
Livraison par lien de téléchargement
24
Non

Adhérents : 5,10 € HT / Non adhérent : 5,50 € HT
Licence à l'unité*
* Usage unique limité à une session. Prix par étudiant formé. Licence à renouveler pour chaque nouvelle session.