Table 10 provides the daily website traffic overview for the last week. You are analyzing the data for presenting to the webmaster. Construct simple cell formula by doing the following: In cell L12: Using the Sum function, compute the total number of users who visited the website last week. In cell L13: Using the Sum function, compute the total number of new users who visited the website last week. In cell L14: Compute the percentage of users who are new in the last week. In cell L15: Using the Sumproduct function, compute the average number of sessions per user. In cell L16: Using the Count function, find the number of days when total page views data 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 Average session duration (in sec) 57 66 43 179 99 150 102l 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 752 651

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. 

Need help with the formula for L14, L15, L16.

Thanks!!

Table 10 provides the daily website traffic overview for the last week.
You are analyzing the data for presenting to the webmaster.
Construct simple cell formula by doing the following:
In cell L12: Using the Sum function, compute the total number of users who visited the website last week.
In cell L13: Using the Sum function, compute the total number of new users who visited the website last week.
In cell L14: Compute the percentage of users who are new in the last week.
In cell L15: Using the Sumproduct function, compute the average number of sessions per user.
In cell L16: Using the Count function, find the number of days when total page views data 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
per user
1.8
2.5
1.4
1.3
1.2
1.5
1
Total Page
views
313
470
466
385
336
Average session
duration (in sec)
57
66
43
179
99
150
102
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
752
651
Transcribed Image Text:Table 10 provides the daily website traffic overview for the last week. You are analyzing the data for presenting to the webmaster. Construct simple cell formula by doing the following: In cell L12: Using the Sum function, compute the total number of users who visited the website last week. In cell L13: Using the Sum function, compute the total number of new users who visited the website last week. In cell L14: Compute the percentage of users who are new in the last week. In cell L15: Using the Sumproduct function, compute the average number of sessions per user. In cell L16: Using the Count function, find the number of days when total page views data 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 per user 1.8 2.5 1.4 1.3 1.2 1.5 1 Total Page views 313 470 466 385 336 Average session duration (in sec) 57 66 43 179 99 150 102 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 752 651
Expert Solution
steps

Step by step

Solved in 2 steps with 3 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