Statistics for Business & Economics (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
13th Edition
ISBN: 9781305585317
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 14, Problem 5CP
Buckeye Creek Amusement Park is open from the beginning of May to the end of October. Buckeye Creek relies heavily on the sale of season passes. The sale of season passes brings in significant revenue prior to the park opening each season, and season pass holders contribute a substantial portion of the food, beverage, and novelty sales in the park. Greg Ross, director of marketing at Buckeye Creek, has been asked to develop a targeted marketing campaign to increase season pass sales.
Greg has data for last season that show the number of season pass holders for each zip code within 50 miles of Buckeye Creek. He has also obtained the total population of each zip code from the U.S. Census bureau website. Greg thinks it may be possible to use
Managerial Report
- 1. Compute
descriptive statistics and construct ascatter diagram for the data. Discuss your findings. - 2. Using simple linear regression, develop an estimated regression equation that could be used to predict the number of season pass holders in a zip code given the total population of the zip code.
- 3. Test for a significant relationship at the .05 level of significance.
- 4. Did the estimated regression equation provide a good fit?
- 5. Use residual analysis to determine whether the assumed regression model is appropriate.
- 6. Discuss if/how the estimated regression equation should be used to guide the marketing campaign.
- 7. What other data might be useful to predict the number of season pass holders in a zip code?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Google has changed its strategy with regard to how much and over which media it invests in advertising. The following table shows Google's marketing budget in millions of dollars for 2008 and 2011 (The Wall Street Journal, March 27, 2012).
2008
2011
Internet
$26.0
$123.3
Newspaper, etc.
$4.0
$20.7
Television
$0.0
$69.3
a. Select a side-by-side bar chart with year as the variable on the horizontal axis.
United Dairies, Inc., supplies milk to several independent grocers throughout Dade County, Florida. Managers at United Dairies want to develop a forecast of the number of half-gallons of milk sold per week. Sales data for the past 12 weeks follow and have been transferred in the data file UDFMilk.xlsx download(also posted under week 11 module).
Week
Sales
Week
Sales
1
2750
7
3300
2
3100
8
3100
3
3250
9
2950
4
2800
10
3000
5
2900
11
3200
6
3050
12
3150
By Thursday, April 15 (11:55pm PST), answer the following 2 questions and attach a word doc or excel file to show your work.
Use the data in the file UDFMilk.xlsx downloadto construct a time series plot. What type of pattern exists in the data?
Use exponential smoothing with to develop a forecast of demand for week 13.
On December 17, 2007 baseball writer John Hickey wrote an article for the Seattle P-I about increases to ticket prices for Seattle Mariners games during the 2008 season. The article included a data set that listed the average ticket price for each MLB team, the league in which the team plays (AL or NL), the number of wins during the 2007 season and the cost per win (in dollars). The data for the 16 National League teams are shown below.
team
league
price
wins
cost/win
Arizona Diamondbacks
NL
19.68
90
35.40
Atlanta Braves
NL
17.07
84
32.89
Chicago Cubs
NL
34.30
85
65.33
Cincinnati Reds
NL
17.90
72
40.32
Colorado Rockies
NL
14.72
90
26.67
Florida Marlins
NL
16.70
71
38.13
Houston Astros
NL
26.66
73
59.11
Los Angeles Dodgers
NL
20.09
82
34.64
Milwaukee Brewers
NL
18.11
83
35.37
N.Y. Mets
NL
25.28
88
46.56
Philadelphia Phillies
NL
26.73
89
48.69
Pittsburgh Pirates
NL
17.08
68
40.67
San Diego Padres
NL
20.83
89
38.15
San Francisco Giants
NL
24.53
71…
Chapter 14 Solutions
Statistics for Business & Economics (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Ch. 14.2 - Given are five observations for two variables, x...Ch. 14.2 - Given are five observations for two variables, x...Ch. 14.2 - Given are five observations collected in a...Ch. 14.2 - The following data give the percentage of women...Ch. 14.2 - Brawdy Plastics, Inc., produces plastic seat belt...Ch. 14.2 - The National Football League (NFL) records a...Ch. 14.2 - A sales manager collected the following data on...Ch. 14.2 - The American Association of Individual Investors...Ch. 14.2 - Prob. 9ECh. 14.2 - On March 31, 2009, Ford Motor Companys shares were...
Ch. 14.2 - To help consumers in purchasing a laptop computer,...Ch. 14.2 - Concur Technologies, Inc., is a large...Ch. 14.2 - To the Internal Revenue Service, the...Ch. 14.2 - A large city hospital conducted a study to...Ch. 14.3 - The data from exercise 1 follow. xi 1 2 3 4 5 yi 3...Ch. 14.3 - The data from exercise 2 follow. xi 3 12 6 20 14...Ch. 14.3 - The data from exercise 3 follow. xi 2 6 9 13 20 yi...Ch. 14.3 - The following data show the brand, price (), and...Ch. 14.3 - In exercise 7 a sales manager collected the...Ch. 14.3 - Bicycling, the worlds leading cycling magazine,...Ch. 14.3 - An important application of regression analysis in...Ch. 14.3 - Refer to exercise 9, where the following data were...Ch. 14.5 - The data from exercise 1 follow. xi 1 2 3 4 5 yi 3...Ch. 14.5 - The data from exercise 2 follow. xi 3 12 6 20 14...Ch. 14.5 - The data from exercise 3 follow. xi 2 6 9 13 20 yi...Ch. 14.5 - In exercise 18 the data on price () and the...Ch. 14.5 - To identify high-paying jobs for people who do not...Ch. 14.5 - In exercise 8 ratings data on x = the quality of...Ch. 14.5 - Refer to exercise 21, where data on production...Ch. 14.5 - Refer to exercise 9, where the following data were...Ch. 14.5 - In exercise 20, data on x = weight (pounds) and y...Ch. 14.6 - The data from exercise 1 follow. xi 1 2 3 4 5 yi 3...Ch. 14.6 - The data from exercise 2 follow. xi 3 12 6 20 14...Ch. 14.6 - The data from exercise 3 follow. xi 2 6 9 13 20 yi...Ch. 14.6 - The following data are the monthly salaries y and...Ch. 14.6 - In exercise 7, the data on y = annual sales (...Ch. 14.6 - In exercise 13, data were given on the adjusted...Ch. 14.6 - Refer to exercise 21, where data on the production...Ch. 14.6 - In exercise 12, the following data on x = average...Ch. 14.7 - The commercial division of a real estate firm is...Ch. 14.7 - Following is a portion of the computer output for...Ch. 14.7 - A regression model relating x, number of...Ch. 14.7 - A 2012 suvey conducted by Idea Works provided data...Ch. 14.7 - Automobile racing, high-performance driving...Ch. 14.8 - Given are data for two variables, x and y. xi 6 11...Ch. 14.8 - The following data were used in a regression...Ch. 14.8 - Data on advertising expenditures and revenue (in...Ch. 14.8 - Refer to exercise 7, where an estimated regression...Ch. 14.8 - In 2011 home prices and mortgage rates dropped so...Ch. 14.9 - Consider the following data for two variables, x...Ch. 14.9 - Consider the following data for two variables, x...Ch. 14.9 - Charity Navigator is Americas leading independent...Ch. 14.9 - Many countries, especially those in Europe, have...Ch. 14.9 - Prob. 54ECh. 14 - Does a high value of r2 imply that two variables...Ch. 14 - In your own words, explain the difference between...Ch. 14 - What is the purpose of testing whether 1 = 0? If...Ch. 14 - The Dow Jones Industrial Average (DJIA) and the...Ch. 14 - Is the number of square feet of living space a...Ch. 14 - One of the biggest changes in higher education in...Ch. 14 - Jensen Tire Auto is in the process of deciding...Ch. 14 - In a manufacturing process the assembly line speed...Ch. 14 - A sociologist was hired by a large city hospital...Ch. 14 - The regional transit authority for a major...Ch. 14 - A marketing professor at Givens College is...Ch. 14 - The Transactional Records Access Clearinghouse at...Ch. 14 - The Toyota Camry is one of the best-selling cars...Ch. 14 - You have been assigned to analyze the risk...Ch. 14 - As part of a study on transportation safety, the...Ch. 14 - Consumer Reports tested 166 different...Ch. 14 - Finding the Best Car Value When trying to decide...Ch. 14 - Buckeye Creek Amusement Park is open from the...
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
- The Crazy Nut Company wishes to market two special nut mixes during the holiday season. The Fancy Mix contains 0.5 pound of peanuts and 0.5 pound of cashews. The Deluxe Mix contains 0.6pound of peanuts, 0.2 pound of cashews and 0.15 pound of almonds. Fancy Mix sells for $12 per can and Deluxe Mix sells for $16 per can. The data pertinent to the raw ingredients appear in the table. The Crazy can sell all cans of either mix that it produces, but wants to keep the production quantity of Fancy Mix at least twice as many as Deluxe Mix. Formulate an LP model to determine how many of each mix to produce to maximize the total profit. Do not solve it. You can formulate as a spreadsheet model or an algebraic model. Define your decision variables (changing cells) clearly. Ingredient Amount Available (lb) Cost Per Pound (s) Peanuts 300 $1 Cashews 120 $3 Almonds 90 $4arrow_forwardA company is analyzing the data of two branches located in different cities. Part of reviewing the effectiveness of the branches involves analyzing the member statistics on each branch's website. Branch A: The number of visitors doubles each week. Branch B: The number of visitors increases by 4 each week. Part A: The table below shows the number of visitors to each website for the first four weeks. Based on this table, which of the following statements best describes the data. Branch Branch A В Week 1 20 20 Week 2 40 24 Week 3 80 28 Week 4 160 32 Branch A is a linear function; Branch B is an exponential function. Branch A is an exponential function; Branch B is a linear function. Both Branch A and Branch B are linear functions. Both Branch A and Branch B are exponential functions. Part B Explain your response to Part A. Be sure to include an explanation for both Branch A and Branch B. Ω В I U S X, x² Font Size 99arrow_forwardWetlands offer a diversity of benefits. They provide a habitat for wildlife, spawning grounds for U.S. commercial fish, and renewable timber resources. In the last 200 years, the United States has lost more than half its wetlands. Environmental Almanac gives the percentage of wetlands lost in each state in the last 200 years. For the 30 of the lower 48 states, the percentage loss of wetlands per state is as follows. Make a stem-and-leaf display of these data. (Use the tens digit as the stem and the ones digit as the leaf. Enter NONE in any unused answer blanks.)arrow_forward
- Please explain properlyarrow_forwardA 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…arrow_forwardPlease fill in the blanks and select the correct answers over the image provided. Thank youarrow_forward
- Continue monitoring the process. A second ten days of data have been collected, see table labeled “2nd 10 Days of Monitoring Reservation Processing Time” in the Data File. Develop Xbar and R charts for the 2nd 10 days of monitoring. Plot the data for the 2nd 10 days on the Xbar and R charts. Is the reservation process for the 2nd 10 days of monitoring in control? If the control chart indicates an out-of-control process, note which days, the pattern, and whether it is the Xbar or R chart. Based on the X-bar and R Charts that you developed for the 2nd 10 days of data, is the process in control? Group of answer choices No. The X-bar and R Charts are both out of control. No. The X-bar Chart is in control, but the R Chart is out of control. No. The R Chart is in control, but the X-bar Chart is out of control. Yes. The X-bar and R Charts are both in control.arrow_forwardA company produces handmade shawls and afghans. They spin the yarn, dye it, and then weave it. A shawl requires 1 hour of spinning, 1 hour of dyeing, and 1 hour of weaving. An afghan requires 1 hour of spinning, 2 hours of dyeing, and 4 hours of weaving. There are at most 8 hours available each day for spinning, 10 hours for dyeing, and 16 hours for weaving. Summarize the data in a table. Use the table to write a system of inequalities. Then graph the feasible region. Complete the table. Hours Hours Number Spinning Dyeing Shawls x Afghans y Maximum Number of Hours Available 8 10 Hours Weaving 16arrow_forwardEach year forbes ranks the world’s most valuable brands. A portion of the data for 82 ofthe brands in the 2013 forbes list is shown in Table 2.12 (forbes website, february, 2014).The data set includes the following variables:brand: The name of the brand.Industry: The type of industry associated with the brand, labeled Automotive& Luxury, Consumer Packaged Goods, financial Services, Other, Technology.brand Value ($ billions): A measure of the brand’s value in billions of dollarsdeveloped by forbes based on a variety of financial information about the brand.1-Yr Value Change (%): The percentage change in the value of the brand over theprevious year.brand Revenue ($ billions): The total revenue in billions of dollars for the brand.a. Prepare a crosstabulation of the data on Industry (rows) and brand Value ($ billions).Use classes of 0–10, 10–20, 20–30, 30–40, 40–50, and 50–60 for brand Value($ billions).b. Prepare a frequency distribution for the data on Industry.arrow_forward
- The recommendations of respected wine critics have a substantial effect on the price of wine. Vintages that earn higher ratings command higher prices and spark surges in demand. These data are a random sample of ratings of wines selected from an online Web site from the 2000 and 2001 vintages. Complete parts (a) through (d). Click the icon to view the table of wine rating, price, and vintage. Yes, all the conditions are satisfied. B. No, the 2000 data contains outliers. No, the 2001 data is too skewed. D. No, the sampling procedure was not identified and it cannot be condluded that this is a simple random survey. No, the variances are drastically different. (b) Find the 95% confidence interval for the difference in average ratings in these two vintages. Does one of the years look better than the other? The 95% confidence interval for P2000 - P2001 is ( – 1.0. 1.7). (Round to one decimal place as needed.) Does one of the years look better than the other? O A. Yes, 2000 looks better…arrow_forwardA national park conducts a study on the behaviour of their leopards. A few of the park's leopards are registered and receive a GPS device which allows measuring the position of the leopard. Use this example to describe the following concepts: population, sample, observation, value, and variable.arrow_forwardAs the leader of the sales team, you would like to increase the revenue brought by your team. You discovered a program for sales personnel that supposedly improve interpersonal skills and thus help settle deals with customers more often. You decide to send8 of your sales people for the training, and compare the amount they brought in sales in the month before they went and in the month after they received the training. The data are: Xbefore: 400, 300, 1200, 2100, 700, 450, 650, 3400 Xafter: 1000, 400, 1000, 2500, 1200, 600, 800, 3000 A. Identify the appropriate statistical measure to use. B. Conduct the test. Make a decision about the null hypothesis, interpret your results and calculate effect size if applicable. At ?=.05, can you report to upper management that the training worked? Or was it a waste of money? C. Calculate 95% confidence intervals for the estimate of the difference.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
What Are Research Ethics?; Author: HighSchoolScience101;https://www.youtube.com/watch?v=nX4c3V23DZI;License: Standard YouTube License, CC-BY
What is Ethics in Research - ethics in research (research ethics); Author: Chee-Onn Leong;https://www.youtube.com/watch?v=W8Vk0sXtMGU;License: Standard YouTube License, CC-BY