Questions

$1.[15$ points$]$ The worksheet Movies contains data on a list of Movies produced in America: data description is

in the textbox of Movies worksheet.

a$.[1$ pt$.]$ How many variables are in the data set $($you can type a number without using cell reference$/$formula$)?$

b$.[2$ pts$.]$ How many observations are there in the file $($you need to use an excel function to get full marks$)?$

c$.[1$ pt$.]$ How many categorical variables are there in this sample $($you can type a number without using cell

reference$/$formula$)?$

d$.[2$ pts$.]$ What are the entities in this dataset $($type your answer$)?$

e$.[2$ pts$.]$ Which Movie has the lowest Production Cost $($use cell reference to get full marks$)?$

f$.[3$ pts$.]$ What is the total Profit for the movies from the Action genre? $[$You need to use excel functions and

cell referencing to get full marks. Hint: You may find the formula $=$SUMIF$()$ useful; you can get the answer

in other ways as well including cell$-$reference and intermediate steps of creating a subsample of the Action

genre only in a new worksheet.$]$

g$.[2$ pts$.]$ What is the $50$th percentile of Length?

h$.[2$ pts$.]$ What is the first quartile of Length?