(b) Using CAGR computed in E15, write the formula in cells D26 and D27 to calculate the Expected Mobile website visitor in 2018 and 2019, respectively.(c) Compute the percent decline or increase in the mobile website visitors, write a formula in cell E26 and copy to cell E27.(d) In cell F26, Use the IF Function to create a formula to print "Yes" if there is cannibalization; else, the formula should print "No". Copy the formula to cell F27.Hint: If the percent increase is negative then there is cannibalization, else there is no cannibalization. Screenshot attached A22232425262728B1017 Superficially, it looks like the mobile app has not cannibalized the mobile website, this is because the monthly mobile website visitor has grown in 2018 and 2019.18 However, the comparison of actual visitors in 2018 to 2017 actual visitors is not correct. To find cannibalization, we should compare the actual visitors to the expected visitors.19 Assume that if the firm did not launch the app, the mobile website user base would have grown at the CAGR rate.20 (b) Using CAGR computed in E15, write the formula in cells D26 and D27 to calculate the Expected Mobile website visitor in 2018 and 2019, respectively.21 (c) Compute the percent decline or increase in the mobile website visitors, write a formula in cell E26 and copy to cell E27.YearD20182019(d) In cell F26, Use the IF Function to create a formula to print "Yes" if there is cannibalization; else, the formula should print "No". Copy the formula to cell F27.Hint: If the percent increase is negative then there is cannibalization, else there is no cannibalization.Mobile Website4821949000GTable 6Expected MobileWebsite VisitorPercentageIncreaseIs therecannibalization?HYear20182019Mobile WebsiteSample AnswerExpected MobileWebsite Visitor48219490005641770539PercentageIncreaseMNIs therecannibalization?-14.5307% Yes-30.5346% Yes0

Solution: Compound annual growth rate:

Answered: (b) Using CAGR computed in E15, write…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

(b) Using CAGR computed in E15, write the formula in cells D26 and D27 to calculate the Expected Mobile website visitor in 2018 and 2019, respectively.

(c) Compute the percent decline or increase in the mobile website visitors, write a formula in cell E26 and copy to cell E27.

(d) In cell F26, Use the IF Function to create a formula to print "Yes" if there is cannibalization; else, the formula should print "No". Copy the formula to cell F27.
Hint: If the percent increase is negative then there is cannibalization, else there is no cannibalization.

Screenshot attached

A
22
23
24
25
26
27
28
B
10
17 Superficially, it looks like the mobile app has not cannibalized the mobile website, this is because the monthly mobile website visitor has grown in 2018 and 2019.
18 However, the comparison of actual visitors in 2018 to 2017 actual visitors is not correct. To find cannibalization, we should compare the actual visitors to the expected visitors.
19 Assume that if the firm did not launch the app, the mobile website user base would have grown at the CAGR rate.
20 (b) Using CAGR computed in E15, write the formula in cells D26 and D27 to calculate the Expected Mobile website visitor in 2018 and 2019, respectively.
21 (c) Compute the percent decline or increase in the mobile website visitors, write a formula in cell E26 and copy to cell E27.
Year
D
2018
2019
(d) In cell F26, Use the IF Function to create a formula to print "Yes" if there is cannibalization; else, the formula should print "No". Copy the formula to cell F27.
Hint: If the percent increase is negative then there is cannibalization, else there is no cannibalization.
Mobile Website
48219
49000
G
Table 6
Expected Mobile
Website Visitor
Percentage
Increase
Is there
cannibalization?
H
Year
2018
2019
Mobile Website
Sample Answer
Expected Mobile
Website Visitor
48219
49000
56417
70539
Percentage
Increase
M
N
Is there
cannibalization?
-14.5307% Yes
-30.5346% Yes
0

Expert Solution

Step by step

Solved in 2 steps with 7 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions