Assignment2A-KCH-Approach

Approach

This assignment involves data collection via a Movie Survey. The survey was distributed to a group of potential participants, with the goal of capturing movie preferences from at least five people. The scope of this specific Movie Survey was limited to films with the Director role as Paul Thomas Anderson. Nine of Anderson’s films were listed with a rating system of 1 (Strongly Dislike) to 5 (Strongly Like). The release year of each movie was included, and that data was sourced from the website ‘imdb.com’. Potential participants received the Movie Survey via email or URL link.

Once data collection has completed, the next step is to input the survey results into a SQL database. After inputting the data, analysis will be performed in R, utilizing SQL queries to retrieve the data from the local database.

Anticipated challenges in this assignment include the initial data collection phase and managing missing ratings in the survey. One strategy to increase the survey’s reach is to post the survey link in the DATA 607 slack channel or to share the URL with classmates during a meetup. Strategies to manage missing data include calculating the proportion of each rating for responses for each film. In other words, rather than relying on raw counts of ‘Strongly Dislike’ and other ratings, the percent of responses displaying ‘Strongly Dislike’ will be calculated, and the same process will be executed for other ratings. Another strategy could be to make “no response” its own category, and display that with the data in histograms. This would help to visualize the relative magnitude of ‘no response’ vs. ‘rated response’.

Possible enhancements to this assignment include secure database credential management, assessing the benefits of normalizing the database schema, and determining the advantage of standardizing ratings. Once findings of this study are determined and verified, recommendations for future improvements and analysis will be outlined.