PART 2: You will write a MEMO (In WORD) to Steven Spielberg referring to the evidence developed in your analysis of the USA movie box office revenue above. (Use TO: FROM:, RE:, DATE: format). You will address these concerns: 1. Based on the HISTORICAL DATA you analyzed: When is the best time of year (month and weeks) to launch a movie? 1 Develop a theory as to what would be the best time to open a movie (which month, and weeks). 2. I am not asking you to speculate as to WHY this would be the best time I am asking you to just report on what you see in the data. Be precise: what months, what weeks. This is a form of Prescriptive Analytics ii. Also given the best-selling movies, what choices should be made to maximize box office revenues in terms of the following (which will require using the RESOURCES below to find such data): a. Genre, Script source, and MPAA rating Explain your reasoning. You are making this decision looking at 15 years of data ending in 2008 Explain what caveats do you need to consider in this analysis? Given your analysis of historical data, now look at data from 2019 for the top 10 films in terms of box office revenue; what are their attributes per genre, script source, MPAA rating, and time of release? Does your hypothesis hold given this new data? Explain what you learned and your speculation about any differences observed. sources PART 2: You will write a MEMO (In WORD) to Steven Spielberg referring to the evidence developed in your analysis of the USA movie box office revenue above. (Use TO: FROM:, RE:, DATE: format). You will address these concerns: 1. Based on the HISTORICAL DATA you analyzed: When is the best time of year (month and weeks) to launch a movie? 1 Develop a theory as to what would be the best time to open a movie (which month, and weeks). 2. I am not asking you to speculate as to WHY this would be the best time I am asking you to just report on what you see in the data. Be precise: what months, what weeks. This is a form of Prescriptive Analytics ii. Also given the best-selling movies, what choices should be made to maximize box office revenues in terms of the following (which will require using the RESOURCES below to find such data): a. Genre, Script source, and MPAA rating Explain your reasoning. You are making this decision looking at 15 years of data ending in 2008 Explain what caveats do you need to consider in this analysis? Given your analysis of historical data, now look at data from 2019 for the top 10 films in terms of box office revenue; what are their attributes per genre, script source, MPAA rating, and time of release? Does your hypothesis hold given this new data? Explain what you learned and your speculation about any differences observed. sources