Day Monday Tuesday Wednesday Users Table 10: Daily website Traffic Overview 116 112 556 95 New users 100 99 78 Number of sessions Total Page per user views 1.8 2.5 1.4 313 Average session duration (in sec) 57 66 43 Total users who visit Total new users who New users as a perci Using sumproduct f

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

Problem is attached to the screenshot below thanks

solve for Users on the Bottom

thank you!

8
9
10
11
12
13
14
15
16
17
18
19
D
E
compare the average Minder or womerona per
In cell L16: Using the Count function, find the number of days when total page views data is available.
A
B
WIT SKIN WANT WAS WIS
Day
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
y one comp
Users
Table 10: Daily website Traffic Overview
Day
Wednesday
116
112
95
94
111
104
120
New users
100
99
Users
78
82
91
93
108
Number of sessions
per user
1.8
2.5
1.4
1.3
1.2
1.5
1
Total Page
views
313
470
466
385
336
G
Average session
duration (in sec)
57
66
43
179
99
150
102
H
J
20
21 Table 10 provides the daily website traffic overview for the last week.
22 The webmaster would like to know the number of users who visited the website on a particular day.
23 Using the VLOOKUP Function only, write a formula in cell D27 to find the number of users who visited the website during the Day mentioned in cell C27.
Use cell reference for Day; don't hardcode the day text in the formula.
24
25
26
27
K
Total users who visited website last week
Total new users who visited website last week
New users as a percent of all users in the last week
Using sumproduct function compute the average number of
sessions per user
Using Count function, find the number of days when total
page views data is available
L
752
651
86.57%
1153.20000
5
M
Transcribed Image Text:8 9 10 11 12 13 14 15 16 17 18 19 D E compare the average Minder or womerona per In cell L16: Using the Count function, find the number of days when total page views data is available. A B WIT SKIN WANT WAS WIS Day Monday Tuesday Wednesday Thursday Friday Saturday Sunday y one comp Users Table 10: Daily website Traffic Overview Day Wednesday 116 112 95 94 111 104 120 New users 100 99 Users 78 82 91 93 108 Number of sessions per user 1.8 2.5 1.4 1.3 1.2 1.5 1 Total Page views 313 470 466 385 336 G Average session duration (in sec) 57 66 43 179 99 150 102 H J 20 21 Table 10 provides the daily website traffic overview for the last week. 22 The webmaster would like to know the number of users who visited the website on a particular day. 23 Using the VLOOKUP Function only, write a formula in cell D27 to find the number of users who visited the website during the Day mentioned in cell C27. Use cell reference for Day; don't hardcode the day text in the formula. 24 25 26 27 K Total users who visited website last week Total new users who visited website last week New users as a percent of all users in the last week Using sumproduct function compute the average number of sessions per user Using Count function, find the number of days when total page views data is available L 752 651 86.57% 1153.20000 5 M
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
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 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…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
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
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman