i need emergency help with this questions, can you please have them done by 11:30 tonight? another one of the tutors did it incomplete and is not responding back

All-Time Movie Box Office Data The motion picture industry is an extremely competitive business. Dozens of movie studios produce hundreds of movies each year, many of which cost hundreds of millions of dollars to produce and distribute. Some of these movies will go on to earn hundreds of millions of dollars in box office revenues, while others will earn much less than their production cost. Data from fifty of the top box office receipt generating movies are provided in the file \"Ch3 Top50Movies\". The categorical variables included in the data set for each movie are the rating and genre. Quantitative variables for the movie's release year, inflation- and noninflation-adjusted box office receipts in the United States, budget, and the world box office receipts are also included. Managerial Report Use the data visualization methods presented in this chapter to explore these data and discover relationships between the variables. Include the following, in your report: 1. Create a scatter chart to examine the relationship between the year released and the inflation-adjusted U.S. box office receipts. Include a trendline for this scatter chart. What does the scatter chart indicate about inflation-adjusted U.S. box office receipts over time for these top 50 movies? 2. Create a scatter chart to examine the relationship between the budget and the noninflation-adjusted world box office receipts. (Note: You may have to adjust the data in Excel to ignore the missing budget data values to create your scatter chart. You can do this by first sorting the data using Budget and then creating a scatter chart using only the movies that include data for Budget.) What does this scatter chart indicate about the relationship between the movie's budget and the world box office receipts? 3. Create a frequency distribution, percent frequency distribution, and histogram for inflation-adjusted U.S. box office receipts. Use bin sizes of $100 million. Interpret the results. Do any data points appear to be outliers in this distribution? 4. Create a PivotTable for these data. Use the PivotTable to generate a crosstabulation for movie genre and rating. Determine which combinations of genre and rating are most represented in the top 50 movie data. Now filter the data to consider only movies released in 1980 or later. What combinations of genre and rating are most represented for movies after 1980? What does this indicate about how the preferences of moviegoers may have changed over time? 5. Use the PivotTable to display the average inflation-adjusted U.S. box office receipts for each genre-rating pair for all movies in the dataset. Interpret the results. Title Gone With the Wind Star Wars The Sound of Music E.T. Titanic The Ten Commandments Jaws Doctor Zhivago The Jungle Book Snow White and the Seven Dwarfs Ben-Hur One Hundred and One Dalmatians The Exorcist Avatar The Empire Strikes Back Return of the Jedi The Lion King Year Released 1939 1977 1965 1982 1997 U.S. Box Office Receipts (Inflation Adjusted Millions $) Rating $1,650 G $1,426 PG $1,145 G $1,132 PG $1,096 PG-13 Genre Drama SciFi/Fantasy Musical SciFi/Fantasy Drama Budget (Non-Inflation Adjusted Millions $) $3 $11 --$200 World Box Office Receipts (NonInflation Adjusted Millions $) $391 $798 $163 $757 $2,185 U.S. Box Office Receipts (Non-Inflation Adjusted Millions $) $199 $461 $163 $435 $659 1956 $1,053 G Drama $14 $80 $80 1975 1965 1967 $1,029 PG $973 PG-13 $871 G Action Drama Animated $12 $11 -- $471 $112 $206 $260 $112 $142 $1 $185 $185 $15 $70 $70 -- $215 $153 $12 $230 $358 $2,778 $205 $761 1937 $854 G Animated 1959 $844 G Drama 1961 $825 G Animated 1973 2009 $809 R $804 PG-13 Horror Action 1980 $772 PG SciFi/Fantasy $18 $534 $290 1983 1994 $741 PG $722 G SciFi/Fantasy Animated $33 $45 $573 $952 $309 $423 Star Wars: The Phantom Menace 1999 $720 PG SciFi/Fantasy $110 $1,027 $475 The Sting Mary Poppins Raiders of the Lost Ark Jurassic Park The Graduate Fantasia Marvel's The Avengers The Godfather Forrest Gump Close Encounters of the Third Kind The Dark Knight Sleeping Beauty Grease Shrek 2 Butch Cassidy and the Sundance Kid Spider-Man Bambi Independence Day Love Story Beverly Hills Cop Pinocchio Home Alone Cleopatra Airport American Graffiti Ghostbusters The Robe 1973 1964 1981 1993 1967 1940 2012 1972 1994 $715 $686 $683 $676 $671 $651 $623 $623 $618 Drama Musical Action Action Drama Animated SciFi/Fantasy Drama Drama $6 -$20 $63 -$2 $220 $6 $55 $160 $102 $384 $920 $104 $76 $1,512 $135 $680 $160 $102 $248 $357 $104 $76 $623 $135 $330 1977 $612 PG Drama -- $300 $128 2008 1959 1978 2004 $589 $570 $562 $557 SciFi/Fantasy Animated Comedy Animated $150 $6 $6 $75 $1,002 $52 $380 $912 $533 $52 $182 $437 1969 $553 PG Western -- $102 $102 2002 1942 1996 1970 1984 1940 1990 1963 1970 1973 1984 1953 $552 $552 $549 $549 $548 $529 $528 $527 $518 $515 $515 $513 SciFi/Fantasy Animated SciFi/Fantasy Drama Comedy Animated Comedy Drama Drama Drama SciFi/Fantasy Drama $139 -$75 --$3 -$44 $10 $1 $30 $5 $807 $268 $813 $106 $316 $84 $534 $58 $101 $115 $292 $36 $404 $103 $306 $106 $235 $84 $286 $58 $101 $115 $239 $36 PG G PG PG-13 PG G PG-13 R PG-13 PG-13 G PG PG PG-13 G PG-13 PG R G PG UR G PG PG UR Pirates of the Caribbean: Dead Man's Chest 2006 $513 PG-13 Action $225 $1,066 $423 Around the World in 80 Days $507 G Action $6 $42 $42 LOTR: The Return of the King 2003 $496 PG-13 SciFi/Fantasy $94 $1,129 $377 Blazing Saddles Batman $496 R $494 PG-13 Comedy SciFi/Fantasy --- $120 $413 $120 $251 1956 1974 1989 University Boston College Brandeis University Brown University California Institute of Technology Carnegie Mellon University Case Western Reserve Univ. College of William and Mary Columbia University Cornell University Dartmouth College Duke University Emory University Georgetown University Harvard University Johns Hopkins University Lehigh University Massachusetts Inst. of Technology New York University Northwestern University Pennsylvania State Univ. Princeton University Rice University Stanford University Tufts University Tulane University U. of California-Berkeley U. of California-Davis U. of California-Irvine U. of California-Los Angeles U. of California-San Diego U. of California-Santa Barbara U. of Chicago U. of Florida U. of Illinois-Urbana Champaign U. of Michigan-Ann Arbor U. of North Carolina-Chapel Hill U. of Notre Dame U. of Pennsylvania U. of Rochester U. of Southern California U. of Texas-Austin U. of Virginia U. of Washington U. of Wisconsin-Madison Vanderbilt University Wake Forest University Washington University-St. Louis Yale University State Graduation Rate MA MA RI CA PA OH VA NY NY NH NC GA DC MA MD PA MA NY IL PA NJ TX CA MA LA CA CA CA CA CA CA IL FL IL MI NC IN PA NY CA TX VA WA WI TN NC MO CT 87 77 91 87 77 74 90 91 93 93 93 82 92 95 89 79 94 74 90 81 95 90 91 86 72 85 73 76 80 81 70 83 67 79 83 84 96 88 77 70 67 93 72 75 82 82 86 95 % of Classes Under 20 37 69 58 64 68 50 47 70 71 62 66 66 53 71 66 56 67 65 64 31 67 64 67 69 57 60 32 40 42 48 47 64 30 29 49 41 53 65 65 51 39 45 37 35 70 61 74 76 Student-Faculty Alumni Ratio Giving Rate 13 8 8 3 10 8 12 7 13 10 8 7 10 8 9 11 6 13 8 19 5 8 7 9 12 17 19 20 18 19 20 4 23 15 15 16 13 7 10 13 21 13 12 13 9 11 7 7 25 35 39 46 26 29 25 29 35 54 44 36 27 45 29 39 46 14 29 22 69 42 32 30 17 16 6 10 11 10 13 38 20 21 15 28 47 40 24 22 12 27 12 11 30 40 33 48 A lumni G iving Alumni donations are an important source of revenue for colleges and universities. If administrators could determine the factors that could lead to increases in the percentage of alumni who make a donation, they might be able to implement policies that could lead to increased revenues. Research shows that students who are more satisfied with their contact with teachers are more likely to graduate. As a result, one might suspect that smaller class sizes and lower student/faculty ratios might lead to a higher percentage of satisfied graduates, which in turn might lead to increases in the percentage of alumni who make a donation. The following partial table shows a portion of the data for 48 US universities in the file \"Ch4 AlumniGiving\". The Graduation Rate column is the percentage of students who initially enrolled at the university and graduated. The % of Classes Under 20 column shows the percentages of classes offered with fewer than 20 students. The Student/Faculty Ratio column is the number of students enrolled divided by the total number of faculty. Finally, the Alumni Giving Rate column is the percentage of alumni who made a donation to the university. Managerial Report 1. Use methods of descriptive statistics to summarize the data. 2. Develop an estimated simple linear regression model that can be used to predict the alumni giving rate, given the graduation rate. Discuss your findings. 3. Develop an estimated multiple linear regression model that could be used to predict the alumni giving rate using the Graduation Rate, % of Classes Under 20, and Student/Faculty Ratio as independent variables. Discuss your findings. 4. Based on the results in parts 2 and 3, do you believe another regression model may be more appropriate? Estimate this model, and discuss your results. 5. What conclusions and recommendations can you derive from your analysis? What universities are achieving a substantially higher alumni giving rate than would be expected, given their Graduation Rate, % of Classes Under 20, and Student/Faculty Ratio? What universities are achieving a substantially lower alumni giving rate than would be expected, given their Graduation Rate, % of Classes Under 20, and Student/Faculty Ratio? What other independent variables could be included in the model? University Boston College Brandeis University Brown University California Institute of Technology Carnegie Mellon University Case Western Reserve Univ. College of William and Mary Columbia University Cornell University Dartmouth College Duke University Emory University Georgetown University Harvard University Johns Hopkins University Lehigh University Massachusetts Inst. of Technology New York University Northwestern University Pennsylvania State Univ. Princeton University Rice University Stanford University Tufts University Tulane University U. of California-Berkeley U. of California-Davis U. of California-Irvine U. of California-Los Angeles U. of California-San Diego U. of California-Santa Barbara U. of Chicago U. of Florida U. of Illinois-Urbana Champaign U. of Michigan-Ann Arbor U. of North Carolina-Chapel Hill U. of Notre Dame U. of Pennsylvania U. of Rochester U. of Southern California U. of Texas-Austin U. of Virginia U. of Washington U. of Wisconsin-Madison Vanderbilt University Wake Forest University Washington University-St. Louis Yale University State Graduation Rate MA MA RI CA PA OH VA NY NY NH NC GA DC MA MD PA MA NY IL PA NJ TX CA MA LA CA CA CA CA CA CA IL FL IL MI NC IN PA NY CA TX VA WA WI TN NC MO CT 87 77 91 87 77 74 90 91 93 93 93 82 92 95 89 79 94 74 90 81 95 90 91 86 72 85 73 76 80 81 70 83 67 79 83 84 96 88 77 70 67 93 72 75 82 82 86 95 % of Classes Under 20 37 69 58 64 68 50 47 70 71 62 66 66 53 71 66 56 67 65 64 31 67 64 67 69 57 60 32 40 42 48 47 64 30 29 49 41 53 65 65 51 39 45 37 35 70 61 74 76 Student-Faculty Alumni Ratio Giving Rate 13 8 8 3 10 8 12 7 13 10 8 7 10 8 9 11 6 13 8 19 5 8 7 9 12 17 19 20 18 19 20 4 23 15 15 16 13 7 10 13 21 13 12 13 9 11 7 7 25 35 39 46 26 29 25 29 35 54 44 36 27 45 29 39 46 14 29 22 69 42 32 30 17 16 6 10 11 10 13 38 20 21 15 28 47 40 24 22 12 27 12 11 30 40 33 48 A lumni G iving Alumni donations are an important source of revenue for colleges and universities. If administrators could determine the factors that could lead to increases in the percentage of alumni who make a donation, they might be able to implement policies that could lead to increased revenues. Research shows that students who are more satisfied with their contact with teachers are more likely to graduate. As a result, one might suspect that smaller class sizes and lower student/faculty ratios might lead to a higher percentage of satisfied graduates, which in turn might lead to increases in the percentage of alumni who make a donation. The following partial table shows a portion of the data for 48 US universities in the file \"Ch4 AlumniGiving\". The Graduation Rate column is the percentage of students who initially enrolled at the university and graduated. The % of Classes Under 20 column shows the percentages of classes offered with fewer than 20 students. The Student/Faculty Ratio column is the number of students enrolled divided by the total number of faculty. Finally, the Alumni Giving Rate column is the percentage of alumni who made a donation to the university. Managerial Report 1. Use methods of descriptive statistics to summarize the data. 2. Develop an estimated simple linear regression model that can be used to predict the alumni giving rate, given the graduation rate. Discuss your findings. 3. Develop an estimated multiple linear regression model that could be used to predict the alumni giving rate using the Graduation Rate, % of Classes Under 20, and Student/Faculty Ratio as independent variables. Discuss your findings. 4. Based on the results in parts 2 and 3, do you believe another regression model may be more appropriate? Estimate this model, and discuss your results. 5. What conclusions and recommendations can you derive from your analysis? What universities are achieving a substantially higher alumni giving rate than would be expected, given their Graduation Rate, % of Classes Under 20, and Student/Faculty Ratio? What universities are achieving a substantially lower alumni giving rate than would be expected, given their Graduation Rate, % of Classes Under 20, and Student/Faculty Ratio? What other independent variables could be included in the model