What exact formulas do I need for all five buttons to put into excel?? 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.