About this paper

Appears in:
Pages: 8225-8232
Publication year: 2018
ISBN: 978-84-697-9480-7
ISSN: 2340-1079
doi: 10.21125/inted.2018.2000

Conference name: 12th International Technology, Education and Development Conference
Dates: 5-7 March, 2018
Location: Valencia, Spain

TEACHING STATISTICAL RFM SEGMENTATION IN EXCEL

M. Králová, P. Lasak

Masaryk University (CZECH REPUBLIC)
RFM (Recency, Frequency, Monetary) segmentation, visualization and interpretation belong among essential skills expected from "business study programs" graduates. However, specialized SWs suitable for these analyzes aren’t usually available at universities. Although Excel does not have a specialized module for RFM analyses there are standard Excel modules which can be easily adjusted to process it.

The aim of the article is first to present the adoption of standard Excel tools to perform tasks related to RFM segmentation (visualization, customers’ distribution and interactive evaluation). Further, the article covers a topic of teaching techniques needed for teaching multidisciplinary subjects. (Here, soft IT knowledge, business economics knowledge, critical thinking and inquiry based approach should be implemented.) Didactic notes are added.

The instructions for manual creation of standard graphs with settings adjusted for RFM segmentation will be supplemented with practical examples and its interpretations. Instructions for VBA programming as well as for related pivot tables will be provided for advanced users.

From students’ perspective using Excel for RFM segmentation is highly beneficial not only because of their familiarity with this SW but also for almost certain availability of Excel at any work place.
@InProceedings{KRALOVA2018TEA,
author = {Kr{\'{a}}lov{\'{a}}, M. and Lasak, P.},
title = {TEACHING STATISTICAL RFM SEGMENTATION IN EXCEL},
series = {12th International Technology, Education and Development Conference},
booktitle = {INTED2018 Proceedings},
isbn = {978-84-697-9480-7},
issn = {2340-1079},
doi = {10.21125/inted.2018.2000},
url = {http://dx.doi.org/10.21125/inted.2018.2000},
publisher = {IATED},
location = {Valencia, Spain},
month = {5-7 March, 2018},
year = {2018},
pages = {8225-8232}}
TY - CONF
AU - M. Králová AU - P. Lasak
TI - TEACHING STATISTICAL RFM SEGMENTATION IN EXCEL
SN - 978-84-697-9480-7/2340-1079
DO - 10.21125/inted.2018.2000
PY - 2018
Y1 - 5-7 March, 2018
CI - Valencia, Spain
JO - 12th International Technology, Education and Development Conference
JA - INTED2018 Proceedings
SP - 8225
EP - 8232
ER -
M. Králová, P. Lasak (2018) TEACHING STATISTICAL RFM SEGMENTATION IN EXCEL, INTED2018 Proceedings, pp. 8225-8232.
User:
Pass: