Movie Data Navigator $(45$ points$)$ Using the IMDb movie database, write VBA code to perform the following tasks. Notes: Ensure each button functions as intended $($e$.$g$.,$ pressing Button $2$ should automatically complete both subtasks a and b $).$ Feel free to customize your button's appearance. Validating user input is recommended but not mandatory. You may start by recording a Macro to create the code for each task. However, your final VBA code must dynamically accommodate changes in the dataset $($e$.$g$.,$ adding or removing movies$).$ In other words, your code should not rely on static data ranges. Ref: Class $15-$ Dynamic Referencing in VBA Button$1(10$ points$)$: Data summary a$.$ Report the summary statistics $($i$.$e$.,$ mean, standard deviation, min and max$)$ of IMDB score and Total Reviews in the table. Hint: Use 'Application WorksheetFunction' to apply Excel functions in VBA Button $2(10$ points$)$: Navigate the data by total reviews and IMDb Score a$.$ Filter to show only the movies with the top $10$ highest total reviews. b$.$ After filtering, apply conditional formatting to highlight the rows where IMDb score is greater than $8.$ Button $3(5$ points$)$: Clear filters and formats a$.$ Clear any existing filters and formatting on the worksheet. Button $4(10$ points$)$: Navigate the data by director name a$.$ Prompt the user to enter a director's name. b$.$ Filter the data to show only movies by the selected director. c$.$ Display a message with the number of movies and average IMDb score for the selected director. d$.$ Clear the filter after displaying the message. Button $5(10$ points$)$: Random movie picker a$.$ Generate a random number corresponding to the rows of the movie dataset. b$.$ Display a message box with the name of the randomly selected movie. Hint: use 'RandRetween $(1,$ RowNumber$)\text{'}$ where RowNumber reflects the total number of movies.Analyzing the IMDB Movie Dataset: Access the imdb$\_$movies.csv file and perform the following tasks. Identify trends in movie genres, Explore the relationship between budget and revenue, and Predict the success of future movies.

The excel file$/$the actual code that is written for these steps.