Assignment : 1. The file P03_54.xlsx lists data for 593 movies released in 2011. Obviously, some movies are simply more popular than others, but success in 2011, measured by 2011 gross or 2011 tickets sold, could also be influenced by the release date. To check this, create a new variable, Days Out, which is the number of days the movie was out during 2011. For example, a movie released on 12/15 would have Days Out equal to 17 (which includes the release day). Create two scatterplots and corresponding correlations, one of 2011 Gross (Y axis) versus Days Out and one of 2011 Tickets Sold (Y axis) versus Days Out. Describe the behavior you see. Do you think a movie’s success can be predicted very well just by knowing how many days it has been out?2.The file P03_57.xlsx lists the average salary for each NFL team from 2002 to 2009, along with the number of team wins each of these years. Answer the same questions as in problem 55 for this football data.3. The file P03_58.xlsx lists salaries of MLB players in the years 2007 to 2009. Each row corresponds to a particular player. As indicated by blank salaries, some players played in one of these years, some played in two of these years, and the rest played in all three years. a. Create a new Yes/No variable, All 3 Years, that indicates which players played all three years. b. Create two pivot tables and corresponding pivot charts. The first should show the count of players by position who played all three years. The second should show the average salary each year, by position, for all players who played all three years. (For each of these, put the All 3 Years variable in the Filters area.) Explain briefly what these two pivot tables indicate. c. Define a StatTools data set on only the players who played all three years. Using this data set, create a table of correlations of the three salary variables. What do these correlations indicate about player salaries?Thanks,

nb: please provide short answers and sites/linksweek 6: Based upon the recommendations you plan to make for your week six written assignment, use the attached spreadsheet to create a financial case for your recommendations. Return on investment template.xlsxIn your posting, describe your recommendations and attach the return on investment spreadsheet with your costs and benefits. The following resources may help you:Video: Return on investment explains calculating return on investment, which is critically important before choosing specific IT initiatives. Article: Return on investment explains return on investment.In your responses to other students, comment on the viability of their financial cases and offer suggestions to revise the financial cases. Students will be updating the financial case for the week seven written strategy.week 7: After a project is successfully implemented, the resulting systems may be operational for several years. IT enhancements are often run as a series of small projects. Businesses generally want more enhancements than is affordable. Based on economic and technical feasibility considerations, and frameworks like the Balanced Scorecard, describe a process for deciding how you would plan to keep systems and the skills of your staff up to date. The following resources may help you:Read: Chapter 13 - Project Management and SDLC Chapter 13 - Project Management and SDLC.pptxVideo: What is Portfolio Management vs. Project Management? explains the difference between project management and portfolio management. Video: Project Portfolio Management Defined describes managing a portfolio of projects.