Essentials of Modern Business Statistics with Microsoft Office Excel (Book Only)
7th Edition
ISBN: 9781337298353
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 3, Problem 3.2.3CP
Case Problem 2 Motion Picture Industry
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 DATAfile 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.
Managerial Report
Use the numerical methods of
3. Descriptive statistics showing the relationship between total gross sales and each of the other variables. Discuss.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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 racing bikes reviewed by the magazine (Bicycling website).
The datafile logo.
Brand
Weight
Price ($)
FELT F5
17.8
2100
PINARELLO Paris
16.1
6250
ORBEA Orca GDR
14.9
8370
EDDY MERCKX EMX-7
15.9
6200
BH RC1 Ultegra
17.2
4000
BH Ultralight 386
13.1
8600
CERVELO S5 Team
16.2
6000
GIANT TCR Advanced 2
17.1
2580
WILIER TRIESTINA Gran Turismo
17.6
3400
SPECIALIZED S-Works Amira SL4
14.1
8000
a. Use the data to develop an estimated regression equation that could be used to estimate the price for a bike given the weight. If required, enter negative values as negative numbers.
price + weight (to whole…
A statistics instructor at a large western university would like to examine the relationship
(if any) between the number of optional homework problems students do during the
semester and their final course grade. She randomly selects 12 students for study and
asks them to keep track of the number of these problems completed during the course of
the semester. At the end of the class each student's total marks is recorded along with their
final grade. The data follow in Table 2.
Table 2
Problem
Course Grade
51
62
58
68
62
66
65
66
67
68
76
72
77
73
78
72
78
78
84
73
85
76
91
75
For this setting identify the response variable.
i.
i.
For this setting, identify the predictor variable.
Compute the linear correlation coefficient for this data set
iv.
ii.
Classify the direction and strength of the correlation
Test the hypothesis for a significant linear correlation, a = 0.05
What is the valid prediction range for this setting?
Use the regression equation to predict a student's final course…
In 2011 home prices and mortgage rates dropped so low that in a number of cities the monthly cost of owning a home was less expensive than renting. The following data show the average asking rent for 10 markets and the monthly mortgage on the median priced home (including taxes and insurance) for 10 cities where the average monthly mortgage payment was less than the average asking rent (The Wall Street Journal, November 26–27, 2011).Click on the datafile logo to reference the data.
Enter negative values as negative numbers.
a. Develop the estimated regression equation that can be used to predict the monthly mortgage given the average asking rent (to 2 decimals).The regression equation is:Mortgage ($) = + Rent ($)
Chapter 3 Solutions
Essentials of Modern Business Statistics with Microsoft Office Excel (Book Only)
Ch. 3.1 - Consider a sample with data values of 10, 20, 12,...Ch. 3.1 - Consider a sample with data values of 10, 20, 21,...Ch. 3.1 - Consider the following data and corresponding...Ch. 3.1 - Consider the following data. What is the mean...Ch. 3.1 - Prob. 5ECh. 3.1 - Prob. 6ECh. 3.1 - The average number of minutes Americans commute to...Ch. 3.1 - The WWI Street Journal reported that the median...Ch. 3.1 - Which companies spend the most money on...Ch. 3.1 - Prob. 10E
Ch. 3.1 - According to the National Education Association...Ch. 3.1 - The Big Bang Theory, a situation comedy featuring...Ch. 3.1 - In automobile mileage and gasoline-consumption...Ch. 3.1 - Prob. 14ECh. 3.1 - Martinez Auto Supplies has retail stores located...Ch. 3.1 - The grade point average for college students is...Ch. 3.1 - The following table shows the total return and the...Ch. 3.1 - Prob. 18ECh. 3.1 - Prob. 19ECh. 3.1 - Prob. 20ECh. 3.1 - If an asset declines in value from $5000 to $3500...Ch. 3.1 - The current value of a company is $25 million. If...Ch. 3.2 - Consider a sample with data values of 10, 20, 12,...Ch. 3.2 - Prob. 24ECh. 3.2 - Prob. 25ECh. 3.2 - Data collected by the Oil Price Information...Ch. 3.2 - The results of a search to find the least...Ch. 3.2 - The Australian Open is the first of the four Grand...Ch. 3.2 - Prob. 29ECh. 3.2 - The following data were used to construct the...Ch. 3.2 - Prob. 31ECh. 3.2 - Prob. 32ECh. 3.2 - Scores turned in by an amateur golfer at the...Ch. 3.2 - The following times were recorded by the...Ch. 3.3 - Consider a sample with data values of 10, 20, 12,...Ch. 3.3 - Prob. 36ECh. 3.3 - Prob. 37ECh. 3.3 - Prob. 38ECh. 3.3 - The results of a national survey showed that on...Ch. 3.3 - Prob. 40ECh. 3.3 - Prob. 41ECh. 3.3 - Many families in California are using backyard...Ch. 3.3 - Prob. 43ECh. 3.3 - Prob. 44ECh. 3.3 - The Wall Street Journal reported that Walmart...Ch. 3.4 - Prob. 46ECh. 3.4 - Prob. 47ECh. 3.4 - Prob. 48ECh. 3.4 - Prob. 49ECh. 3.4 - Naples, Florida hosts a half-marathon (13.1 -mile...Ch. 3.4 - Annual sales, in millions of dollars, for 21...Ch. 3.4 - Consumer Reports provided overall customer...Ch. 3.4 - Fortune magazine's list of the world's most...Ch. 3.4 - Prob. 54ECh. 3.5 - Five observations taken for two variables follow...Ch. 3.5 - Five observations taken for two variables follow...Ch. 3.5 - Prob. 57ECh. 3.5 - A department of transportation's study on driving...Ch. 3.5 - Over the past 40 years, the percentage of homes in...Ch. 3.5 - Prob. 60ECh. 3.5 - A random sample of 30 colleges from Kiplinger's...Ch. 3 - The average number of times Americans dine out in...Ch. 3 - Prob. 63SECh. 3 - The average waiting time for a patient at an El...Ch. 3 - U.S. companies lose $63.2 billion per year from...Ch. 3 - Prob. 66SECh. 3 - Public transportation and the automobile are two...Ch. 3 - In 2007 the New York Times reported that the...Ch. 3 - Prob. 69SECh. 3 - Travel + Leisure magazine presented its annual...Ch. 3 - The 32 teams in the National Football League (NFL)...Ch. 3 - Does a major league baseball team's record during...Ch. 3 - The days to maturity for a sample of five money...Ch. 3 - Automobiles traveling on a road with a posted...Ch. 3 - The Panama Railroad Company was established in...Ch. 3 - Case Problem 1 Pelican Stores Pelican S to res, a...Ch. 3 - Case Problem 1 Pelican Stores Pelican S to res, a...Ch. 3 - Problem 2Motion Picture Industry The motion...Ch. 3 - Case Problem 2 Motion Picture Industry The motion...Ch. 3 - Case Problem 2 Motion Picture Industry The motion...Ch. 3 - Case Problem 3 Business Schools of Asia-Pacific...Ch. 3 - Case Problem 3 Business Schools of Asia-Pacific...Ch. 3 - Case Problem 3 Business Schools of Asia-Pacific...Ch. 3 - Case Problem 3 Business Schools of Asia-Pacific...Ch. 3 - Case Problem 5 African Elephant Populations...Ch. 3 - Case Problem 5 African Elephant Populations...Ch. 3 - Case Problem 5 African Elephant Populations...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- Cholesterol Cholesterol in human blood is necessary, but too much can lead to health problems. There are three main types of cholesterol: HDL (high-density lipoproteins), LDL (low-density lipoproteins), and VLDL (very low-density lipoproteins). HDL is considered “good” cholesterol; LDL and VLDL are considered “bad” cholesterol. A standard fasting cholesterol blood test measures total cholesterol, HDL cholesterol, and triglycerides. These numbers are used to estimate LDL and VLDL, which are difficult to measure directly. Your doctor recommends that your combined LDL/VLDL cholesterol level be less than 130 milligrams per deciliter, your HDL cholesterol level be at least 60 milligrams per deciliter, and your total cholesterol level be no more than 200 milligrams per deciliter. (a) Write a system of linear inequalities for the recommended cholesterol levels. Let x represent the HDL cholesterol level, and let y represent the combined LDL VLDL cholesterol level. (b) Graph the system of inequalities from part (a). Label any vertices of the solution region. (c) Is the following set of cholesterol levels within the recommendations? Explain. LDL/VLDL: 120 milligrams per deciliter HDL: 90 milligrams per deciliter Total: 210 milligrams per deciliter (d) Give an example of cholesterol levels in which the LDL/VLDL cholesterol level is too high but the HDL cholesterol level is acceptable. (e) Another recommendation is that the ratio of total cholesterol to HDL cholesterol be less than 4 (that is, less than 4 to 1). Identify a point in the solution region from part (b) that meets this recommendation, and explain why it meets the recommendation.arrow_forwardThe top three sources of oil imports for the United States in the same year were Saudi Arabia, Mexico, and Canada. The three top countries accounted for 47% of oil imports. The United States imported 1.8% more from Saudi Arabia than they did from Mexico, and 1.7% more from Saudi Arabia than they did from Canada. What percent of the United States oil imports were from these three countries?[29]arrow_forwardName the four parts of a mathematical system. HINT: See Section 1.3arrow_forward
- Box Office Hits The table below shows the highest grossing movie of the given year. The amount is the domestic box office gross, in millions of dollars. Year Movie Amount(millions) 2006 Pirates of the Caribbean: Dead Mans chest 423.32 2007 Spider-Man 3 336.53 2008 The Dark Knight 533.35 2009 Avatar 760.51 2010 Toy Story 3 415.00 2011 Harry Potter and the Deathly Hallows: Part 2 381.01 2012 The Avengers 623.28 2013 The Hunger Games: Catching Fire 424.67 2014 American Sniper 350.13 Let M=M(y) denote the highest grossing movie in year y, and let B=B(y) denote the gross for that movie. a. Give the values of M(2014) and B(2014). b. Use the functional notation to indicate the amount for the movie with the highest gross in 2013.arrow_forwardExamine the chart below. This shows the proportion of vote-share received by the GOP (Republican Party) in the 2012 and 2016 Presidential elections for 1055 counties from Midwestern states. Each data point represents a unique county. Which of the following statements about this chart are true? Click all that apply.arrow_forwardBicycling, 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_forward
- An business reviews data on the daily amount of calls it receives. Are the data discrete or continous?arrow_forwardMost Expensive Colleges Listed below are the annual costs (dollars) of tuition and fees at the 10 most expensive colleges in the United States for a recent year (based on data from U.S. News & World Report). The colleges listed in order are Columbia, Vassar, Trinity, George Washington, Carnegie Mellon, Wesleyan, Tulane, Bucknell, Oberlin, and Union. What does this “top 10” list tell us about those costs for the population of all U.S. college tuitions?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. Suppose the following data show the number of cars in service (1,000s) and the annual revenue ($ millions) for six smaller car rental companies. Cars Revenue Company (1,000s) ($ millions) Company A 11.5 120 Company B 10.0 133 Company C 9.0 102 Company D 5.5 37 Company E 4.2 42 Company F 3.3 34 (a) Develop a scatter diagram with the number of cars in service as the independent variable. 160T 160T 160 160- 140- 140 140 140 120 120 120 120- 100 100 100 100- 80 80 80 80 60 60 60 60 .. . 40 40 .. 40 40 20 20 20 20 4 6 8 10 12 14 2 4 8 10 12 14 2 4 6 8 10 12 14 2 4 6 8 10 12 14 Cars in Service (1,000s) Cars in Service (1,000s) Cars in Service (1,000s) Cars in Service (1,000s) (b) What does the scatter diagram developed in part (a) indicate about the relationship between…arrow_forward
- Companies 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. Suppose the following data show the number of cars in service (1,000s) and the annual revenue ($ millions) for six smaller car rental companies. Cars Revenue Company (1,000s) ($ millions) Company A 11.5 116 Company B 10.0 137 Company C 9.0 102 Company D 5.5 39 Company E 4.2 40 Company F 3.3 34 (a) Develop a scatter diagram with the number of cars in service as the independent variable. 160- 140- 160 160 160 120 140- 140- 140 100 120 120- 120- 80 100 100- 100- 60 80 80 80 40 60 60 60 20 40 40 40 20 20 20 4 6 8 10 12 14 2 4 6 8 10 12 14 2 4 6 8 10 12 14 4 6 8 10 12 14 Cars in Service (1,000s) Cars in Service (1,000s) Cars in Service (1,000s) Cars in Service (1,000s) (b) What does the scatter diagram developed in part (a) indicate about the relationship between the…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. Suppose the following data show the number of cars in service (1,000s) and the annual revenue ($ millions) for six smaller car rental companies. Cars Revenue Company (1,000s) ($ millions) Company A 11.5 118 Company B 10.0 137 Company C 9.0 102 Company D 5.5 39 Company E 4.2 40 Company F 3.3 32 (a) Develop a scatter diagram with the number of cars in service as the independent variable. 160T 160T 140 140 120 . 120 100- 100 80 80- 60 60 . 40 40 20 20- 4 6 8 10 Cars in Service (1,000) 0 6 8 10 0 4 6 8 10 12 14 Cars in Service (1,000) Cars in Service (1,000) (b) What does the scatter diagram developed in part (a) indicate about the relationship between the two variables? O There appears to be a negative linear relationship between cars in service (1,000s) and annual…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. Suppose the following data show the number of cars in service (1,000s) and the annual revenue ($ millions) for six smaller car rental companies. Cars Revenue Company (1,000s) ($ millions) Company A 11.5 120 Company B 10.0 137 Company C 9.0 98 Company D 5.5 35 Сompany E 4.2 40 Company F 3.3 32 (a) Develop a scatter diagram with the number of cars in service as the independent variable. 合160, 140- 160 160, 160, 140- 120- 140 140- 120 120 120 100 100 100 100 80 80 80 80 60 60 60 60 ... 40- 20- 40 .. 40 ... 40 20- 20- 20- 6 10 12 2 6 8 10 12 2 6 10 12 2 14 4 14 4 14 6 8 10 12 14 Cars in Service (1,000s) Cars in Service (1,000s) Cars in Service (1,000s) Cars in Service (1,000s) (b) What does the scatter diagram developed in part (a) indicate about the relationship…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Algebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:Cengage
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
Time Series Analysis Theory & Uni-variate Forecasting Techniques; Author: Analytics University;https://www.youtube.com/watch?v=_X5q9FYLGxM;License: Standard YouTube License, CC-BY
Operations management 101: Time-series, forecasting introduction; Author: Brandoz Foltz;https://www.youtube.com/watch?v=EaqZP36ool8;License: Standard YouTube License, CC-BY