(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.
(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.
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
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
thanks
!!!!
Transcribed Image Text:22
23
24
A
25
26
27
20
B
Year
C
2018
2019
D
16
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.
Mobile Website
48219
49000
E
(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.
Table 6
Expected Mobile
Website Visitor
F
Percentage
Increase
G
Is there
cannibalization?
H
Year
2018
2019
I
Mobile Website
J
48219
49000
Sample Answer
Expected Mobile
Website Visitor
56417
70539
K
L
Percentage
Increase
M
N
Is there
cannibalization?
-14.5307% Yes
-30.5346% Yes
0
P
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY