Use the table to write a VLOOK Formula to find the Total Page Views, Number of sessions per user, and New Users thanks! screenshots attached b
Use the table to write a VLOOK Formula to find the Total Page Views, Number of sessions per user, and New Users thanks! screenshots attached b
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
Use the table to write a VLOOK Formula to find the Total Page Views, Number of sessions per user, and New Users
thanks!
screenshots attached below
Transcribed Image Text:9
10
11
12
13
14
15
16
17
18
19
20
A
B
E
F
in cell L1o. Using the Count function, find the number of days when total page views dala is available.
Day
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Users
Table 10: Daily website Traffic Overview
116
112
95
94
111
104
120
New users
100
99
78
82
91
93
108
Number of sessions Total Page
per user
views
1.8
2.5
1.4
1.3
1.2
1.5
1
313
470
466
385
336
G
Average session
duration (in sec)
57
66
43
179
99
150
102
I
Transcribed Image Text:B
3.8
28
29 Table 10 provides the daily website traffic overview for the last week.
30 The webmaster would like to extract a subset of the data for further analysis. know the number of users who visited the website on a particular da
31 (a) Using the VLOOKUP Function only, write a formula in cell D39 to find the total page views, copy the formula to D40:042.
40
41
42
32 (b) Using the VLOOKUP Function only, write a formula in cell E39 to find the number of sessions per user, copy the formula to E40:E42.
33 (c) Using the VLOOKUP Function only, write a formula in cell F39 to find the New Users, copy the formula to F40:F42.
34 Alternately, you can also create a Vlookup Array formula in D39 and copy to the range D39:D42.
35 Hint: The array formula is covered in Learning Exercise 11.4 (LE11.4).
36 Use cell reference for Day; don't hardcode the day text in the formula.
37
Day
Tuesday
Friday
Saturday
Sunday
F
Total
Page
views
Number of
sessions per
G
user
H
New
Users
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 2 steps with 2 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman