Spreadsheet Model for Complex Variable Integration: A Sociocybernetic Approach to the Emotional Component in Violent Actors Interviews

Sociocybernetic perspective tries to adapt available cybernetic strategies and conceptual resources to problem solution through a heuristic approach (Geyer, 1995). In the case of capricious observable conditions in social analysis there are situations in which empirical information present irregularities difficult to overcome. On the one hand difficulties begin with incomplete information in an observation unit missing several dependent variables (Ibáñez, 1994). In the other hand, there are unstable and very significant emotions behavior that may alter the explicit observables attributes. (Guba y Lincoln, 1994)

Incomplete information  in first order techniques present a headache from statistics perspective. It is not possible to accept an observation unit with two or more data missing (Padua, 1982). In second order techniques like discourse analysis the number of observations associated with several paragraphs may not allow an integration of variables into categories for analysis inference (Ibáñez, 1994). Although intelligent analysis may be done out of theoretical principles i.e. that of size definition of samples in statistics or the necessary existence of all variables needed for category integration, in both cases there is not enough theoretical criteria to make it rationally valid.

Emotional issues in violence situations are strongly difficult to record and evaluate. One strategy is to make analogies between real violent moments with post-violence narrations. Text analysis with implicit emotionality contents modifies descriptions, judgments and assessments. Logic in the algorithms that emulate the valuations of these conducts should include the non linear behavour.

In this paper I present an algorithm that proposes a better alternative to resolve the above cases just referred and the inclusion of emotional behavior. It is implemented in a Spreadsheet language that configures an application for social analysis. The model is applied to a real case involved in interviews of violence actors.