This dataset is small enough to view as a spreadsheet as it only contains data from 30 respondents and over 21 questions, plus a timestamp.
There were no null values in the dataset.
A second sheet was created in the survey 605 file as a summary table. As the various responses were tallied, it is evident that the responses were all multiple choice on the survey, though that could not be verified from the dataset’s description. This would have been helpful as it is currently unknown if there are any answer options that recieved zero responses, which would change the appearance of data visualizations. As it is, I investigated how many responses of “Strongly disagree” there were in the whole dataset as many of the questions used the same scale ratings as possible answers. There was exactly one “Strongly Disagree” response in the whole sheet, which means there are likely multiple questions with options that recieved zero response.
Since all of the answers are standardized, the entire summary table was created using COUNTIF funtions in google sheets.
The data was visualized using various tables in Tableau Public.
This dataset is useful in that it provides demographic information, provides insight into possible marketing campaign directions, and shows potential repeat-buying trends. The opinions and self-evaluations provided by the respondents, when combined with the separate fitbit user dataset could provide powerful insight into Bellabeat’s target market.