Business Analytics
3rd Edition
ISBN: 9780135231678
Author: Evans, James R. (james Robert)
Publisher: PEARSON EDUCATION (COLLEGE)
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 1, Problem 5PEA
Return on investment (ROI) is profit divided by investment. In marketing, ROI is determined as incremental sales times gross margin minus marketing investment, all divided by marketing investment. Suppose that a company plans to spend $3 million to place search engine ads and expects $15 million in incremental sales. Its gross margin is estimated to be 45%.
- Develop a spreadsheet to compute the marketing ROI.
- Use the spreadsheet to predict how ROI will change if the incremental sales estimate is wrong (consider a
range of values above and below the expected sales).
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Business discuss
BUSINESS DISCUSS
A researcher wishes to estimate, with 90% confidence, the population proportion of adults who support labeling
legislation for genetically modified organisms (GMOs). Her estimate must be accurate within 4% of the true proportion.
(a) No preliminary estimate is available. Find the minimum sample size needed.
(b) Find the minimum sample size needed, using a prior study that found that 65% of the respondents said they support
labeling legislation for GMOs.
(c) Compare the results from parts (a) and (b).
...
(a) What is the minimum sample size needed assuming that no prior information is available?
n =
(Round up to the nearest whole number as needed.)
Chapter 1 Solutions
Business Analytics
Ch. 1 - Explain why analytics is important in todays...Ch. 1 - Define business analytics.Ch. 1 - State three examples of how business analytics is...Ch. 1 - What are the key benefits of using business...Ch. 1 - What challenges do organizations face in using...Ch. 1 - Prob. 2.1CYUCh. 1 - How do statistical methods enhance business...Ch. 1 - What is operations research/management science?Ch. 1 - How does modern business analytics integrate...Ch. 1 - What are the components of a decision support...
Ch. 1 - Define prescriptive analytics and provide two...Ch. 1 - Define prescriptive analytics and provide two...Ch. 1 - Define prescriptive analytics and provide two...Ch. 1 - State three examples of how data are used in...Ch. 1 - How are data obtained from the Web used in...Ch. 1 - Define big data and list the four characteristics...Ch. 1 - Explain the concepts of data reliability and...Ch. 1 - Define a model and state three common forms of a...Ch. 1 - Prob. 5.2CYUCh. 1 - Prob. 5.3CYUCh. 1 - Define optimization and the characteristics of...Ch. 1 - Explain the importance of assumptions in building...Ch. 1 - What is the difference between uncertainty and...Ch. 1 - List the major phases of problem solving and...Ch. 1 - What lessons did Hewlett-Packard learn about using...Ch. 1 - For each of the following scenarios, state whether...Ch. 1 - Suppose that a manufacturer can produce a part for...Ch. 1 - Use the model developed in Example 1.5 to predict...Ch. 1 - A bank developed a model for predicting the...Ch. 1 - Four key marketing decision options are price (P),...Ch. 1 - Total marketing effort is a term used to describe...Ch. 1 - A manufacturer of headphones is preparing to set...Ch. 1 - PERFORMANCE LAWN EQUIPMENT In each chapter of this...Ch. 1 - Develop a spreadsheet for computing the demand for...Ch. 1 - The Excel file Science and Engineering Jobs shows...Ch. 1 - A new graduate has taken a job with an annual...Ch. 1 - Example 1.2 in the chapter described a scenario...Ch. 1 - Return on investment (ROI) is profit divided by...Ch. 1 - In the Accounting Professionals database, use...Ch. 1 - Prob. 7PEACh. 1 - Prob. 8PEACh. 1 - The worksheet Base Data in the Excel file Credit...Ch. 1 - The Excel file Store and Regional Sales Database...Ch. 1 - Define range names for all the data and model...Ch. 1 - Define range names for all the entities in the...Ch. 1 - Define range names for all the entities in 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 table available below shows the costs per mile (in cents) for a sample of automobiles. At a = 0.05, can you conclude that at least one mean cost per mile is different from the others? Click on the icon to view the data table. Let Hss, HMS, HLS, Hsuv and Hмy represent the mean costs per mile for small sedans, medium sedans, large sedans, SUV 4WDs, and minivans respectively. What are the hypotheses for this test? OA. Ho: Not all the means are equal. Ha Hss HMS HLS HSUV HMV B. Ho Hss HMS HLS HSUV = μMV Ha: Hss *HMS *HLS*HSUV * HMV C. Ho Hss HMS HLS HSUV =μMV = = H: Not all the means are equal. D. Ho Hss HMS HLS HSUV HMV Ha Hss HMS HLS =HSUV = HMVarrow_forwardQuestion: A company launches two different marketing campaigns to promote the same product in two different regions. After one month, the company collects the sales data (in units sold) from both regions to compare the effectiveness of the campaigns. The company wants to determine whether there is a significant difference in the mean sales between the two regions. Perform a two sample T-test You can provide your answer by inserting a text box and the answer must include: Null hypothesis, Alternative hypothesis, Show answer (output table/summary table), and Conclusion based on the P value. (2 points = 0.5 x 4 Answers) Each of these is worth 0.5 points. However, showing the calculation is must. If calculation is missing, the whole answer won't get any credit.arrow_forwardBinomial Prob. Question: A new teaching method claims to improve student engagement. A survey reveals that 60% of students find this method engaging. If 15 students are randomly selected, what is the probability that: a) Exactly 9 students find the method engaging?b) At least 7 students find the method engaging? (2 points = 1 x 2 answers) Provide answers in the yellow cellsarrow_forward
- In a survey of 2273 adults, 739 say they believe in UFOS. Construct a 95% confidence interval for the population proportion of adults who believe in UFOs. A 95% confidence interval for the population proportion is ( ☐, ☐ ). (Round to three decimal places as needed.)arrow_forwardFind the minimum sample size n needed to estimate μ for the given values of c, σ, and E. C=0.98, σ 6.7, and E = 2 Assume that a preliminary sample has at least 30 members. n = (Round up to the nearest whole number.)arrow_forwardIn a survey of 2193 adults in a recent year, 1233 say they have made a New Year's resolution. Construct 90% and 95% confidence intervals for the population proportion. Interpret the results and compare the widths of the confidence intervals. The 90% confidence interval for the population proportion p is (Round to three decimal places as needed.) J.D) .arrow_forward
- Let p be the population proportion for the following condition. Find the point estimates for p and q. In a survey of 1143 adults from country A, 317 said that they were not confident that the food they eat in country A is safe. The point estimate for p, p, is (Round to three decimal places as needed.) ...arrow_forward(c) Because logistic regression predicts probabilities of outcomes, observations used to build a logistic regression model need not be independent. A. false: all observations must be independent B. true C. false: only observations with the same outcome need to be independent I ANSWERED: A. false: all observations must be independent. (This was marked wrong but I have no idea why. Isn't this a basic assumption of logistic regression)arrow_forwardBusiness discussarrow_forward
- Spam filters are built on principles similar to those used in logistic regression. We fit a probability that each message is spam or not spam. We have several variables for each email. Here are a few: to_multiple=1 if there are multiple recipients, winner=1 if the word 'winner' appears in the subject line, format=1 if the email is poorly formatted, re_subj=1 if "re" appears in the subject line. A logistic model was fit to a dataset with the following output: Estimate SE Z Pr(>|Z|) (Intercept) -0.8161 0.086 -9.4895 0 to_multiple -2.5651 0.3052 -8.4047 0 winner 1.5801 0.3156 5.0067 0 format -0.1528 0.1136 -1.3451 0.1786 re_subj -2.8401 0.363 -7.824 0 (a) Write down the model using the coefficients from the model fit.log_odds(spam) = -0.8161 + -2.5651 + to_multiple + 1.5801 winner + -0.1528 format + -2.8401 re_subj(b) Suppose we have an observation where to_multiple=0, winner=1, format=0, and re_subj=0. What is the predicted probability that this message is spam?…arrow_forwardConsider an event X comprised of three outcomes whose probabilities are 9/18, 1/18,and 6/18. Compute the probability of the complement of the event. Question content area bottom Part 1 A.1/2 B.2/18 C.16/18 D.16/3arrow_forwardJohn and Mike were offered mints. What is the probability that at least John or Mike would respond favorably? (Hint: Use the classical definition.) Question content area bottom Part 1 A.1/2 B.3/4 C.1/8 D.3/8arrow_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
Trigonometry (MindTap Course List)TrigonometryISBN:9781337278461Author:Ron LarsonPublisher:Cengage Learning
Elementary AlgebraAlgebraISBN:9780998625713Author:Lynn Marecek, MaryAnne Anthony-SmithPublisher:OpenStax - Rice University
College AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781337278461
Author:Ron Larson
Publisher:Cengage Learning
Elementary Algebra
Algebra
ISBN:9780998625713
Author:Lynn Marecek, MaryAnne Anthony-Smith
Publisher:OpenStax - Rice University
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY