Recall that the file P4_2.XLS contains information on 66 movie stars. In particular, the data set contains the name of each actor and the following four variables: gender, domestic gross (average domestic gross of the star’s last few movies, in millions of dollars), foreign gross (average foreign gross of the star’s last few movies, in millions of dollars), and salary (current amount the star asks for a movie, in millions of dollars). 

a. Find all movie stars who are either (1) females with domestic gross between 40 and 80 million dollars (inclusive) and foreign gross between 40 and 80 million dollars (inclusive), or (2) males with domestic gross between 50 and 90 million dollars (inclusive) and foreign gross between 50 and 90 million dollars (inclusive).

b. Find the mean and median salaries of the movie stars who meet the conditions specified above.

c. What proportion of the stars identified in part a earn salaries in excess of 10 million dollars per movie?