(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 attachedthanks!!!! 222324A25262720BYearC20182019D1617 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 Website4821949000E(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 6Expected MobileWebsite VisitorFPercentageIncreaseGIs therecannibalization?HYear20182019IMobile WebsiteJ4821949000Sample AnswerExpected MobileWebsite Visitor5641770539KLPercentageIncreaseMNIs therecannibalization?-14.5307% Yes-30.5346% Yes0P

CAGR which refers to the Compound Annual Growth Rate. Excel which does not have any direct formula…

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

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...

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

thanks

!!!!