Analysis of theatre experience

Date of data collection: from 2024-10-10 to 2024-12-14
Geographic location of data collection: Music theatre Kapsäkki, Hämeentie 68, FI-00550 Helsinki, Finland

File List: 

Variables.xlsx
List of variables in data files, with brief explanation.

UKK_booths_master_data.xlsx    
Ratings given at customer satisfaction kiosks, with date, time, and number of show (out of 20 shows in total) per rating/answer on each row. Total number of ratings (rows) is 1,887. 
– Number of variables: 7
– Number of cases/rows: 1,887

UKK_no_of_audience_per_show.xlsx
Information on number of members of audience, number and % of ratings given at customer satisfaction kiosks, and number and % of answer to questionnaire per show on each row. Total number of shows (rows) is 20.
– Number of variables: 10
– Number of cases/rows: 20

UKK_questionnaire_Likert_open_answers_UK.xlsx
Quantitative ratings on Likert-scale and qualitative open-ended answers to questionnaire. Answers per respondent, with information on which show they relate to, are on each line, with variables in columns. Total number of answers (rows) is 458. Open-ended answers in this file are translated into English from the original open-ended answers given in Finnish. Total number of open-ended answers is 268. The 190 MISSING values for open-ended answers indicate that respondents have replied on questions with answers on Likert-scale but not given any open-ended feedback.
– Number of variables: 24
– Number of cases/rows: 458

UKK_questionnaire_open_answers_FI.xlsx
Original open-ended answers given in Finnish, per respondent. Total number of open-ended answers is 268. The 190 missing values indicate that respondents have replied on questions with answers on Likert-scale but not given any open-ended feedback.
– Number of variables: 2
– Number of cases/rows: 458. The 190 MISSING values indicate that respondents have replied on questions with answers on Likert-scale but not given any open-ended feedback.

Relationship between files:
1. Original open-ended answers in Finnish in file UKK_questionnaire_open_answers_FI.xlsx are connected with quantitative ratings on Likert-scale and qualitative open-ended answers translated into English in file UKK_questionnaire_Likert_open_answers_UK.xlsx using ID in the first column in both files.
2. Show number (1 to 20) is used in files UKK_booths_master_data.xlsx, UKK_no_of_audience_per_show.xlsx, and UKK_questionnaire_Likert_open_answers_UK.xlsx.

Description of methods used for data collection are described in detail in publication Measuring audience experience across 20 showings of the same theatre performance using customer feedback kiosks and a questionnaire by Sams et al. (2025) (manuscript, no link yet). In short, 1,887 r