(e) In cell E37, write a formula to compute Total Actual Visitors, copy the formula to cell E38. (f) Compute the percent increase in the Total Actual Visitors as compared to Expected mobile website visitors, write the formula in cell G37 and copy to cell G38. (g) In cell H37, Use the IF Function to create a formula to print "Yes" if the App Launch was beneficial to the firm; else, the formula should print "No". Copy the formula to cell H38. Hint: If the Percent increase is positive, then the launch is beneficial; else, it is not beneficial.

Microsoft Windows 10 Comprehensive 2019
1st Edition
ISBN:9780357392607
Author:FREUND
Publisher:FREUND
Chapter8: Mastering Digital Media
Section: Chapter Questions
Problem 4AYK
icon
Related questions
Question

(e) In cell E37, write a formula to compute Total Actual Visitors, copy the formula to cell E38.

(f) Compute the percent increase in the Total Actual Visitors as compared to Expected mobile website visitors, write the formula in cell G37 and copy to cell G38.

(g) In cell H37, Use the IF Function to create a formula to print "Yes" if the App Launch was beneficial to the firm; else, the formula should print "No". Copy the formula to cell H38.
Hint: If the Percent increase is positive, then the launch is beneficial; else, it is not beneficial.

SCREENSHOT ATTACHED THNAKS

25
26
27
28
34
35
A
36
37
38
39
40
41
42
43
44
45
46
Year
B
Year
2018
2019
Mobile Website
2018
2019
Actual Mobile
Website Visitor
Year
48219
49000
2018
2019
D
Website Visitor
48219
49000
Mobile App Actual
Visitors
Actual Mobile
Website Visitor
48219
49000
Increase
29 Strategy Team is interested in knowing whether the app launch helped increase visitors' number to the e-commerce store.
30 (e) In cell E37, write a formula to compute Total Actual Visitors, copy the formula to cell E38.
31 (f) Compute the percent increase in the Total Actual Visitors as compared to Expected mobile website visitors, write the formula in cell G37 and copy to cell G38.
(g) In cell H37, Use the IF Function to create a formula to print "Yes" if the App Launch was beneficial to the firm; else, the formula should print "No". Copy the formula to cell H38.
32 Hint: If the Percent increase is positive, then the launch is beneficial; else, it is not beneficial.
13500
28000
E
Table 7
Total Actual
Visitors
Mobile App Actual
Visitors
cannibalization?
13500
28000
Expected Mobile
Visitors
Total Actual
Visitors
0
0|
61719
77000
G
Sample Answer
Percentage
Increase
Year
2018
2019
56417
70539
H
Expected Mobile Percentage
Visitors
Increase
Mobile Website
48219
49000
Was Launch of App
beneficial to the firm?
Website Visitor
9.40% Yes
9.16% Yes
Was Launch of App
beneficial to the firm?
56417
70539
K
Increase
L
-14.5307%
-30.5346%
Transcribed Image Text:25 26 27 28 34 35 A 36 37 38 39 40 41 42 43 44 45 46 Year B Year 2018 2019 Mobile Website 2018 2019 Actual Mobile Website Visitor Year 48219 49000 2018 2019 D Website Visitor 48219 49000 Mobile App Actual Visitors Actual Mobile Website Visitor 48219 49000 Increase 29 Strategy Team is interested in knowing whether the app launch helped increase visitors' number to the e-commerce store. 30 (e) In cell E37, write a formula to compute Total Actual Visitors, copy the formula to cell E38. 31 (f) Compute the percent increase in the Total Actual Visitors as compared to Expected mobile website visitors, write the formula in cell G37 and copy to cell G38. (g) In cell H37, Use the IF Function to create a formula to print "Yes" if the App Launch was beneficial to the firm; else, the formula should print "No". Copy the formula to cell H38. 32 Hint: If the Percent increase is positive, then the launch is beneficial; else, it is not beneficial. 13500 28000 E Table 7 Total Actual Visitors Mobile App Actual Visitors cannibalization? 13500 28000 Expected Mobile Visitors Total Actual Visitors 0 0| 61719 77000 G Sample Answer Percentage Increase Year 2018 2019 56417 70539 H Expected Mobile Percentage Visitors Increase Mobile Website 48219 49000 Was Launch of App beneficial to the firm? Website Visitor 9.40% Yes 9.16% Yes Was Launch of App beneficial to the firm? 56417 70539 K Increase L -14.5307% -30.5346%
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Datatypes
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Microsoft Windows 10 Comprehensive 2019
Microsoft Windows 10 Comprehensive 2019
Computer Science
ISBN:
9780357392607
Author:
FREUND
Publisher:
Cengage