Concept explainers
The motion picture industry is a competitive business. More than 50 studios produce several hundred new motion pictures each year, and the financial success of the motion pictures varies considerably. The opening weekend gross sales, the total gross sales, the number of
Theaters the movie was shown in, and the number of weeks the motion picture was in release are common variables used to measure the success of a motion picture. Data on the top 100 grossing motion pictures released in 2011 (Box Office Mojo website. March 17, 2012) are contained in the DATA file named 2011Movies. Table 3.10 shows the data for the first 10 motion pictures in this file. Note that some movies, such as War Horse, were released late in 2011 and continued to run in 2012.
Use the numerical methods of
- 1. Descriptive statistics for each of the four variables along with a discussion of what the descriptive statistics tell us about the motion picture industry.
- 2. What motion pictures, if any, should be considered high-performance outliers? Explain.
- 3. Descriptive statistics showing the relationship between total gross sales and each of the other variables. Discuss.
1.
Find the descriptive statistics for each of the four variables along with a discussion of the descriptive statistics to tell about the motion pictures industry.
Answer to Problem 2CP
For opening gross sales, the mean is 27.51, the standard deviation is 26.52, the minimum is 0.07, the maximum is 169.2, the first quartile is 12.97, the median is 19.08, and the third quartile is 32.06.
For total gross sales, the mean is 90.47, the standard deviation is 68.12, the minimum is 29.14, the maximum is 381, the first quartile is 39.35, the median is 72.40, and the third quartile is 107.08.
For the number of theatres, the mean is 3,114.4, the standard deviation is 610.79, the minimum is 1,038, the maximum is 4,375, the first quartile is 2,849.25, the median is 3,102.5, and the third quartile is 3,553.25.
For week in release, the mean is 14.58, the standard deviation is 5.049, the minimum is 6, the maximum is 43, the first quartile is 11.250, the median is 14.5, and the third quartile is 17.
Explanation of Solution
Calculation:
The data represent the performance for 10 motion pictures.
For opening Gross Sales:
Software procedure:
Step-by-step procedure to obtain the descriptive statistics using EXCEL:
- In an EXCEL sheet enter the data.
- Go to Data > Data Analysis (in case it is not default, take the Analysis Tool Pak from Excel Add Ins) > Descriptive statistics.
- Enter Input Range as $R$1:$R$100, select Columns in Grouped By, tick on Summary statistics.
- Click on OK.
Output using EXCEL is given as follows:
The first and third quartile for data is to be obtained.
First quartile:
The EXCEL function to compute first quartile is
Software Procedure:
Step-by-step procedure to obtain the first quartile using EXCEL:
- In an EXCEL sheet enter the data values.
- In a cell enter the formula QUARTILE.EXC (R1:R100,1).
- Click on OK.
Output using EXCEL is given as follows:
From the EXCEL output, the first quartile is 12.97.
Third quartile:
The EXCEL function to compute third quartile is
Software Procedure:
Step-by-step procedure to obtain the third quartile using EXCEL:
- In an EXCEL sheet enter the data values.
- In a cell enter the formula QUARTILE.EXC (R1:R100,3).
- Click on OK.
Output using EXCEL is given as follows:
From the EXCEL output, the third quartile is 32.06.
Thus, the first and third quartiles are 12.97 and 32.06, respectively.
Observation:
The mean opening for gross sales is $27.51. The opening weekend gross sales is low as $70,000 and high as $169.19 million. The 50% of the motion pictures has opening gross sales as $19.08 million or less. The 25% of the motion pictures has opening gross sales as $12.97 million or less, and the top 25% of the motion pictures has opening gross sales as $32.06 million or more.
For Total Gross Sales:
Software procedure:
Step-by-step procedure to obtain the descriptive statistics using EXCEL:
- In an EXCEL sheet enter the data.
- Go to Data > Data Analysis (in case it is not default, take the Analysis Tool Pak from Excel Add Ins) > Descriptive statistics.
- Enter Input Range as $R$1:$R$100, select Columns in Grouped By, tick on Summary statistics.
- Click on OK.
Output using EXCEL is given as follows:
The first and third quartile for data is to be obtained.
First quartile:
The EXCEL function to compute first quartile is
Software Procedure:
Step-by-step procedure to obtain the first quartile using EXCEL:
- In an EXCEL sheet enter the data values.
- In a cell enter the formula QUARTILE.EXC (R1:R100,1).
- Click on OK.
Output using EXCEL is given as follows:
From the EXCEL output, the first quartile is 39.35.
Third quartile:
The EXCEL function to compute third quartile is
Software Procedure:
Step-by-step procedure to obtain the third quartile using EXCEL:
- In an EXCEL sheet enter the data values.
- In a cell enter the formula QUARTILE.EXC (R1:R100,3).
- Click on OK.
Output using EXCEL is given as follows:
From the EXCEL output, the third quartile is 107.08.
Thus, the first and third quartiles are 39.35 and 107.08, respectively.
Observation:
The mean total gross sales is $90.47. The total gross sales is low as $29.14 million and high as $381 million. The 50% of the motion pictures has total gross sales as $72.40 million or less. The 25% of the motion pictures has total gross sales as $39.35 million or less, and the top 25% of the motion pictures has opening gross sales as $107.08 million or more.
For number of theatres:
Software procedure:
Step-by-step procedure to obtain the descriptive statistics using EXCEL:
- In an EXCEL sheet enter the data.
- Go to Data > Data Analysis (in case it is not default, take the Analysis Tool Pak from Excel Add Ins) > Descriptive statistics.
- Enter Input Range as $R$1:$R$100, select Columns in Grouped By, tick on Summary statistics.
- Click on OK.
Output using EXCEL is given as follows:
The first and third quartile for data is to be obtained.
First quartile:
The EXCEL function to compute first quartile is
Software Procedure:
Step-by-step procedure to obtain the first quartile using EXCEL:
- In an EXCEL sheet enter the data values.
- In a cell enter the formula QUARTILE.EXC (R1:R100,1).
- Click on OK.
Output using EXCEL is given as follows:
From the EXCEL output, the first quartile is 2,849.25.
Third quartile:
The EXCEL function to compute third quartile is
Software Procedure:
Step-by-step procedure to obtain the third quartile using EXCEL:
- In an EXCEL sheet enter the data values.
- In a cell enter the formula QUARTILE.EXC (R1:R100,3).
- Click on OK.
Output using EXCEL is given as follows:
From the EXCEL output, the third quartile is 3,553.25.
Thus, the first and third quartiles are 2,849.25 and 3,553.25, respectively.
Observation:
The mean number of theatres is 3,114.4. The total number of theatres for motion pictures is low as 1,038 theatres and high as 4,375 theatres. The 50% of the motion pictures has been released in 3,102.5 theatres. The 25% of the motion pictures has been released in 2,849.25 theatres or less, and the top 25% of the motion pictures has been released in 3,553.3 theatres or more.
For number of weeks:
Software procedure:
Step-by-step procedure to obtain the descriptive statistics using EXCEL:
- In an EXCEL sheet enter the data.
- Go to Data > Data Analysis (in case it is not default, take the Analysis Tool Pak from Excel Add Ins) > Descriptive statistics.
- Enter Input Range as $R$1:$R$100, select Columns in Grouped By, tick on Summary statistics.
- Click on OK.
Output using EXCEL is given as follows:
The first and third quartile for data is to be obtained.
First quartile:
The EXCEL function to compute first quartile is
Software Procedure:
Step-by-step procedure to obtain the first quartile using EXCEL:
- In an EXCEL sheet enter the data values.
- In a cell enter the formula QUARTILE.EXC (R1:R100,1).
- Click on OK.
Output using EXCEL is given as follows:
From the EXCEL output, the first quartile is 11.25.
Third quartile:
The EXCEL function to compute third quartile is
Software Procedure:
Step-by-step procedure to obtain the third quartile using EXCEL:
- In an EXCEL sheet enter the data values.
- In a cell enter the formula QUARTILE.EXC (R1:R100,3).
- Click on OK.
Output using EXCEL is given as follows:
From the EXCEL output, the third quartile is 17.
Thus, the first and third quartiles are 11.25 and 17, respectively.
Observation:
The mean number of weeks is 14.58. The total number of weeks for motion pictures to be released in a high volume is low as 6 weeks and high as 43 weeks. The 50% of the motion pictures have been released for 15 weeks or less. The 25% of the motion pictures have been released for 12 weeks or less, and the top 25% of the motion pictures have been released for 17 weeks or more.
b.
Find the motion pictures that should be considered high-performance outliers.
Answer to Problem 2CP
The six pictures have high-openings gross compared with the other motion pictures with more total gross sales. The three motion pictures are released in less number of theatres compared with the other pictures, and the two motion pictures are released for more number of weeks compared with others.
Explanation of Solution
Calculation:
Box plot for Opening Gross Sales:
Software Procedure:
Step-by-step procedure to obtain the Boxplot of Opening Gross Sales using the EXCEL software:
- In an EXCEL sheet enter the data values and select the column of values.
- Choose Insert > Chart > All Charts> Box &Whisker.
- Click on Chart and select Axis Titles from Chart elements.
- Output using the EXCEL software is given below:
From the box plot, it is clear that the there are six outliers, and these outliers show more opening gross sales compared with the other motion pictures.
Box plot for Total Gross Sales:
Software Procedure:
Step-by-step procedure to obtain the Boxplot of Total Gross Sales using the EXCEL software:
- In an EXCEL sheet enter the data values and select the column of values.
- Choose Insert > Chart > All Charts> Box&Whisker.
- Click on Chart and select Axis Titles from Chart elements.
- Output using the EXCEL software is given below:
From the box plot, it is clear that there are six outliers, and these outliers show more total gross sales compared with the other motion pictures.
Box plot for number of theatres:
Software Procedure:
Step-by-step procedure to obtain the Boxplot of Number of Theatres using the EXCEL software:
- In an EXCEL sheet enter the data values and select the column of values.
- Choose Insert > Chart > All Charts> Box&Whisker.
- Click on Chart and select Axis Titles from Chart elements.
- Output using the EXCEL software is given below:
From the box plot, it is clear that there are three outliers, and these outliers show the motion pictures released in less number of theatres compared with the other pictures.
Box plot for number of weeks:
Software Procedure:
Step-by-step procedure to obtain the Boxplot of Weeks in Release using the EXCEL software:
- In an EXCEL sheet enter the data values and select the column of values.
- Choose Insert > Chart > All Charts> Box & Whisker.
- Click on Chart and select Axis Titles from Chart elements.
- Output using the EXCEL software is given below:
From the box plot, it is clear that there are two outliers, and these outliers show the motion pictures released more number of weeks compared with others.
c.
Find the descriptive statistics that shows the relationship between total gross sales and each of the other variables.
Answer to Problem 2CP
The relationship between total gross sales and each of the other variables is predicted to be positive.
Explanation of Solution
Calculation:
Correlation between Opening Gross Sales and Total Gross Sales:
Software Procedure:
Step-by-step procedure to obtain the correlation coefficient using EXCEL software:
- In an EXCEL sheet enter the data values of Opening Gross Sales in column R and enter the data values of Total Gross Sales in column S.
- In a cell enter the formula =CORREL(R2:R101,S2:S101).
- Click Enter.
Output using EXCEL software is given below:
Thus, the sample correlation coefficient between total gross sales and opening gross sales is 0.887.
Correlation between Total Gross Sales and Number of Theatres:
Software Procedure:
Step-by-step procedure to obtain the correlation coefficient using EXCEL software:
- In an EXCEL sheet enter the data values of Total Gross Sales in column S and enter the data values of Number of Theatres in column T.
- In a cell enter the formula =CORREL(S2:S101,T2:T101).
- Click Enter.
Output using EXCEL software is given below:
The sample correlation coefficient between total gross sales and number of theatres is 0.641.
Correlation between Total Gross Sales and Weeks in Release:
Software Procedure:
Step-by-step procedure to obtain the correlation coefficient using EXCEL software:
- In an EXCEL sheet enter the data values of Total Gross Sales in column S and enter the data values of Weeks in Release in column U.
- In a cell enter the formula =CORREL(S2:S101,U2:U101).
- Click Enter.
Output using EXCEL software is given below:
The sample correlation coefficient between total gross sales and weeks in release is 0.333.
Here, the sample correlation coefficient between total gross sales and opening gross sales is 0.887, which is close to 1. Thus, it can be concluded that there exists a strong positive correlation between total gross sales and opening gross sales.
The sample correlation coefficient between total gross sales and number of theatres is 0.641. Thus, it can be concluded that there exists a positive correlation between total gross sales and number of theatres.
The sample correlation coefficient between total gross sales and weeks in release is 0.333. Thus, it can be concluded that there exists a positive correlation between total gross sales and weeks in release.
Want to see more full solutions like this?
Chapter 3 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
- Bicycling, the world's leading cycling magazine, reviews hundreds of bicycles throughout the year. Their "Road-Race" category contains reviews of bikes used by riders primarily interested in racing. One of the most important factors in selecting a bike for racing is the weight of the bike. The following data show the weight (pounds) and price ($) for 10 racing bikes reviewed by the magazine (Bicycling website). DATA file Brand FELT F5 PINARELLO Paris ORBEA Orca GDR EDDY MERCKX EMX-7 BH RC1 Ultegra BH Ultralight 386 CERVELO S5 Team GIANT TCR Advanced 2 WILIER TRIESTINA Gran Turismo (to 3 decimals) Weight Price ($) 17.8 16.1 14.9 15.9 Did the estimated regression equation provide a good fit? The estimated regression equation provided a - Select your answer - fit. c. Predict the price for a bike that weighs 15 pounds. (to whole number) 2100 6250 8370 6200 17.2 13.1 16.2 17.1 17.6 SPECIALIZED S-Works Amira SL4 14.1 8000 a. Use the data to develop an estimated regression equation that could…arrow_forwardCompanies in the U.S. car rental market vary greatly in terms of the size of the fleet, the number of locations, and annual revenue. In 2011 Hertz had 320,000 cars in service and annual revenue of approximately $4.2 billion. The following data show the number of cars in service (1000s) and the annual revenue ($millions) for six smaller car rental companies (Auto Rental News website, August 7, 2012). If required, enter negative values as negative numbers. c. Use the least squares method to develop the estimated regression equation (to 3 decimals). d. For every additional car placed in service, estimate how much annual revenue will change. Use estimated value rounded to 3 decimals. e. Fox Rent A Car has 11,000 cars in service. Use the estimated regression equation developed in part (c) to predict annual revenue for Fox Rent A Car. Round your answer to nearest whole value. millionarrow_forwardThe Hollywood film industry is a competitive business. More than 50 studios produce a total of 400 to 500 new films each year. The final success of each film varies considerably. The total of the worldwide gross sales is commonly used to measure the success of each film. The table below indicates the top 10 highest grossing films of all time. Rank Title Total Worldwide Gross Sales (USD Billions) Yea 1 Avatar $2,80 200 2 Avengers: Endgame $2,79 201 3 Titanic $2,18 199 4 Star Wars: The Force Awakens $2,06 201 5 Avengers: Infinity War $2,04 201 6 Spider-Man: No Way Home $1,90 202 7 Jurassic World $1,67 201 8 The Lion King $1,65 201 9 The Avengers $1,51 201 10 Furious 7 $1,50 201 Use a calculation tool like Excel to determine the standard deviation of the total worldwide gross sales. Enter only your final answer into the textbox below. Round your final answer off to 2 decimal places. Use a period (.) instead of a comma (,) to indicate the decimal place.arrow_forward
- MarkLines is an online portal (www.marklines.com) that reports automotive industry data. The table below shows the number of cars sold in the United States from January to November in 2017 and 2018. The top 22 manufacturers, plus others, are listed here. Sales data often is reported in this way to compare current sales to last year’s sales. Car Sales Manufacturer Jan.-Nov.2017 Jan.-Nov.2018 GM (Est.) 2,691,493 2,654,568 Ford 2,334,290 2,265,590 Toyota 2,211,533 2,205,762 Fiat Chrysler 1,887,430 2,038,684 Honda 1,492,112 1,449,713 Nissan 1,455,238 1,345,157 Hyundai 621,961 612,225 Subaru 584,614 615,594 Kia 546,629 542,245 Mercedes (includes Sprinter) 332,990 318,012 BMW 271,432 276,657 VW 309,395 322,017 Mazda 262,577 274,455 Audi 199,534 200,558 Tesla (Est.) 40,320 106,050 Land Rover 66,759 81,526 Volvo 71828 89437 Mitsubishi 95,185 109,088 Porsche 51,507 53,116 MINI 42,494 40,887 Jaguar 36,180 27,021 Others 18,901 17,251 smart…arrow_forwardAmericans' trust in government and the media has generally been on a downward trend since pollsters first asked questions on these topics in the second half of the twentieth century. Trust in government hit an all-time low of 14% in 2014, while trust in the media bottomed out at 32% in 2016. The bar graph shows the percentage of Americans trusting in the government and the medial for five selected years. Use this information to answer pårts a-c. + Percentage ÷ 70- 60 50- 40- 30 20 10 Trust in media Trust in Goverment 54 36 32 More 47 20 43 19 39 17 42 a. Use the information in the graph to estimate the yearly loss in the percentage of people trusting in government. The yearly loss in the percentage of people trusting in government is 35%. (Round to the nearest tenth as needed.) 2003 2007 2011 2015 2019 5arrow_forwardResearchers initiated a long-term study of the population of American black bears. One aspect of the study was to develop a model that could be used to predict a bear's weight (since it is not practical to weigh bears in the field). One variable thought to be related to weight is the length of the bear. The accompanying data represent the lengths and weights of 12 American black bears. Complete parts (a) through (d) below. Click the icon to view the data table. Click the icon to view the critical values table. ..... (a) Which variable is the explanatory variable based on the goals of the research? O A. The number of bears B. The weight of the bear O C. The length of the bear (b) Draw a scatter diagram of the data. Choose the correct graph below. O A. O B. O C. D. A Weight (kg) 180- AWeight (kg) 180- ALength (cm) 180- A Weight (kg) 180- 40- 100 40- 100 Length (cm) 40- 100 40- 100 200 200 200 200 Length (cm) Weight (kg) Length (cm) (c) Determine the linear correlation coefficient between…arrow_forward
- A high school guidance counselor analyzed data from a sample of 200 community colleges throughout the United States. One of his goals was to estimate the annual tuition costs of community colleges in the United States. Describe the population and variable of interest to the guidance counselor. Why?arrow_forwardPlease help with (d)arrow_forwardAn insurance company crashed four cars in succession at 5 miles per hour. The cost of repair for each of the crashes was $421,$465,$412,$218. Compute the range of dataarrow_forward
- The percentage of U.S. college freshmen claiming no religious affiliation has risen in recent decades. The bar graph shows the percentage of first-year college students claiming no religious affiliation for four selected years from 1980 through 2012. a. Estimate the average yearly increase in the percentage of first-year college females claiming no religious affiliation. Round the percentage to the nearest tenth. b. Estimate the percentage of first-year college females who will claim no religious affiliation in 2030. Percentage of First-year U.S. College Students Claiming No Religious Affiliation b. The percentage of first-year college females who will claim no religious affiliation in 2030 is approximately.%. (Round to the nearest tenth as needed.) Percentage 30 Males 9 $ $ 25- 20- 15- Females 9.7 10- a. The average yearly increase in the percentage of first-year college females claiming no religious affiliation is approximately % per year. (Round to the nearest tenth as needed.) 14.9…arrow_forwardThe report, “The Older Population: 2010” also indicates that in 1900 approximately 4% of the U.S. population was made up of individuals who were 65 years or older, while in 2010 this same age group made up about 13% of the population. Write a complete sentence that describes the relative change in the percentage of people 65 years or older.arrow_forwardravelAir.com samples domestic airline flights to explore the relationship between airfare and distance. The service would like to know if there is a correlation between airfare and flight distance. If there is a correlation, what percentage of the variation in airfare is accounted for by distance? How much does each additional mile add to the fare? The data follow. Origin Destination Distance Fare Detroit, MI Myrtle Beach, SC 636 $ 109 Baltimore, MD Sacramento, CA 2,395 252 Las Vegas, NV Philadelphia, PA 2,176 221 Sacramento, CA Seattle, WA 605 151 Atlanta, GA Orlando, FL 403 138 Boston, MA Miami, FL 1,258 209 Chicago, IL Covington, KY 264 254 Columbus, OH Minneapolis, MN 627 259 Fort Lauderdale, FL Los Angeles, CA 2,342 215 Chicago, IL Indianapolis, IN 177 128 Philadelphia, PA San Francisco, CA 2,521 348 Houston, TX…arrow_forward
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGALAlgebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell