Randy is attending film school and one of his projects involves researching the ratingsgiven to movies by critics and viewers. He has selected a random sample of movies andhas recorded the average critic score (X1) and the average viewer score (X2) for eachmovie. The scores were obtained from a website that collates movie reviews and ratingssubmitted by critics and viewers. Randy also recorded the genre (X3) of each movie. Thedata are stored in the file AssignmentData.RData in the data frame movies.df.(a) [3 marks] Create a scatter plot of average critic score against average viewer scorefor comedies, with average viewer score along the x-axis. Make sure to give yourplot a proper descriptive title and appropriate labels for the x and y axes. Describethe relationship between these two variables for comedies

Sarah, a reviewer for MovieMania Reviews, is updating the database with recent ratings and reviews for the film 'Tenet' directed by Christopher Nolan.Create a program that records and displays the rating and review details for the movie.Input format :The first line of input consists of an integer N, representing the movie rating (1 to 5 stars).The second line consists of a string containing the review text.Output format :The first line of output prints "Recent Review Rating: [N] stars"The second line prints "Review Details: " followed by the review text.Refer to the sample output for formatting specifications.Code constraints :1 ≤ N ≤ 5Sample test cases :Input 1 :4The movie has a complex narrative but is visually stunning.Output 1 :Recent Review Rating: 4 starsReview Details: The movie has a complex narrative but is visually stunning.Input 2 :5An incredible film with mind-blowing sequences and outstanding performances.Output 2 :Recent Review Rating: 5 starsReview Details: An incredible film wit

Directions: The given graph shows how a particular movie was rated by users of an online movie review site. Each user could vote only once. Go through the given graph and answer the questions based on it.

You are managing a database for a movie production company. The database includes information about actors, directors, movies, movie cast, and ratings.Write a query for updating the ratings of all movies directed by 'Lankesh' to a new rating of 3 in a database that contains information about actors, directors, movies, movie casts, and ratings.The following table is already created, and the records are inserted into the table.

Figure 3.1.G shows a stem and leaf plot of the ratings (out of 100 ) of an actor's performance in different movies.Stem Leaf4 1 75 2 3 46 4 4 77 1 3 5 68 79 0Figure 3.1.G: Performance rating of an actor.Here 6 | 4 means Rating of 64What is the median rating, if 3 points are added to all of his ratings and then converted to 10 points. (Correct up to 2 decimal point accuracy.)

Task: Determine the most common genres of movies in the dataset. Then, for each genre, calculate descriptive statistics (mean, median, mode, range, variance, standard deviation) of the IMDB scores.Hint: Use Excel's COUNTIF function to count the number of movies for each genre. You might need to manipulate the 'genres' column to separate multiple genres for a single movie. Use Excel's functions like AVERAGE, MEDIAN, MODE, MAX, MIN, VAR, and STDEV to calculate descriptive statistics. Compare the statistics to understand the impact of genre on movie ratings.