Hello, I am struggling with this assignment is anyone able to help with this.

1. Construct a scatter plot to understand the relationship between the year released and the budget (Exclude the movies with missing budget data values). What does the scatter chart indicate about the budget over time for these top 50 movies?

2. Construct a scatter plot to understand the relationship between the budget and the noninflationadjusted world box office receipts. (Exclude the movies with missing budget data values). What does this scatter chart indicate about the relationship between the movie's budget and the world box office receipts?

3. Construct a frequency distribution, relative frequency distribution, percent frequency distribution, and histogram for year released. Use bin sizes of 10 years. Interpret the results. What is the shape of distribution? In which decades the most top movies have been released?

4. Construct a PivotTable for movie genre and rating. What combinations of genre and rating are most represented for top 50 movies? Now filter the data to consider only movies released in 1990 or later. How many movies were released in and after 1990? What combinations of genre and rating are most represented for movies in and after 1990? What does this indicate about how the preferences of moviegoers may have changed over time?

5. Construct a PivotTable to display the average inflation-adjusted U.S. box office receipts for each genre- rating pair for all movies in the dataset. What combinations of genre and rating generated the highest inflation-adjusted receipt? What rating generated the highest inflation-adjusted receipt and why?