Comm 291 Statistics Populations Parameters 2014 Assignment 2 Berkowitz

Explain why you might expect this type of association

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: at two time plots on the same axes does not? Scatterplot directly shows how the amount of spots in a month is related to revenue. The scatterplot shows the correlation. Question 4 – Motion Picture Industry revisited In Assignment 1, Question 5, you constructed graphs and descriptive statistics. We will continue the analysis here, with scatterplots and regression. For your convenience I have copied a portion of the relevant data into the Assignment 2 spreadsheet. As before TopMovies2012 has data for the top 100 motion pictures, sorted from highest to lowest gross (domestic) sales. a) Construct a scatterplot of Total Gross on the vertical axis and Total Theatres on the horizontal axis. Add the trendline. (Note: This is an option for this in the Excel scatterplot macro. “Trendline” is Excel’s name for the least squares line.) Total Gross vs Total Theatres $700,000,000 $600,000,000 $500,000,000 Total gross $400,000,000 $300,000,000 Total Gross vs Total Theatres $200,000,000 Linear(Total Gross vs Total Theatres) $100,000,000 $0 - $100,000,000 - $200,000,000 0 1,000 2,000 3,000 4,000 5,000 Total Theaters Open for Movie Release 10 b) Describe the relationship. Explain why you might expect this type of association. Total revenue has a total positive correlation to the amount of theaters open on opening day. This is expected because the more theaters supporting the movie the higher the gross should be. Less theaters open makes it harder for people to watch the movie. c) Use Excel to calculate the mean and standard deviation for both var...
View Full Document

Ask a homework question - tutors are online