Recently Published
Assignment2
Part 1: Build Table
• Choose six recent popular movies.
• Ask at least five people that you know (friends, family, classmates, imaginary friends if
necessary) to rate each of these movies that they have seen on a scale of 1 to 5.
Part 2: Store data in SQL database
• Take the results (observations) and store them in the class MySQL database:
- Server name: cunydata607sql.mysql.database.azure.com
- Username / password: will be given to you in an email
Part 3: Transfer data from SQL database to R dataframe
• Load the information from the SQL database into an R data frame.
Part 4: Missing data strategy
• Implement an approach to missing data
• Explain why you decided to take the chosen approach