Create a histogram for the variable \"world_sales_mln\". The bars should be blue with a black border.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

1. Make some initial transformations of the set: 

 

1.1. Remove from variable"world_sales_gross"commas and sign "$" 

and convert it to a numeric one.

1.2. Add a variable named "Sci_Fi" which is TRUE when "genres:" contains "Sci-Fi" and FALSE otherwise. 

1.3. Add a categorical variable that will have 4 values: 

        - the "1975-1984" value for films that were made in the years 1975-1984,

        - the "1985-1994" value for films that were made in the years 1985-1994,

        - similarly for the periods 1995-2004 and 2005-2014

       Name me "year_cat"; make sure that this variable is of type "factor".

 

1.4. Add a numeric variable named "world_sales_mln", which should be equal to world_sales_gross divided by million; values in the new variable should be rounded to one decimal place

 

1.5. How many missing data are there for the variable "studio"?

 

2. Perform the following analyzes: 

 

2.1. Enter the mean, median, standard deviation, and range for "rt_score".

 

2.2. How many categories are there in the "studio" variable?

 

2.3. Which movie (with which title) made the most money in the four time frames specified by the new "year_cat" variable?

 

2.4. Create a correlation matrix for the variables: "rt_audience_score", "rt_score", "imdb_rating" and "length". Which variables are most strongly correlated?

 

2.5. Films from which label (the "studio" variable) are rated the best on average by imdb, and which label are the worst rated from?

 

Zad 3. Visualizations.

 

3.1. Create a bar chart with each bar representing one category of the variable "year_cat" and the height of the bars representing the number of sci-fi movies in the dataset produced during that period (use the new variable "Sci_fi"). Add the appropriate axis labels and "color" the bars in different colors.

 

3.2. Create a histogram for the variable "world_sales_mln". The bars should be blue with a black border. Give the chart a title "Blockbuster world sales" and add the appropriate axis labels.

 

3.3. Create a scatterplot for the variables "rt_score" and "imdb_rating". Color the points in the graph green.

 

 

 

Zad.4. Perform a regression analysis in which the explained variable will be "world_sales_gross" and the variables

explaining "rt_audience_score", "rt_score" and "imdb_rating" (in other words, we are looking for a regression function,

 which will model the relationship between different movie ratings and the returns from that movie). Which explanatory variables are

related to the dependent variable, i.e. for which explanatory variables is the regression coefficient statistically significant?

 How big is the standard deviation of the residuals and the coefficient R2? What do these numbers show about the quality of our model?

 

Attachments:

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of