Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help with the yellow boxes. I did the rest. The table is provided. The answers need to be in the yellow boxes. Table
I need help with the yellow boxes. I did the rest. The table is provided. The answers need to be in the yellow boxes.
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. | |||||||||||
Table 10 : Daily website Traffic Overview | |||||||||||
Day | Users | New users | Number of sessions per user | Total Page views | Average session duration (in sec) | Total users who visited website last week | |||||
Monday | 116 | 100 | 1.8 | 313 | 57 | Total new users who visited website last week | |||||
Tuesday | 112 | 99 | 2.5 | 66 | New users as a percent of all users in the last week | ||||||
Wednesday | 95 | 78 | 1.4 | 43 | Using sumproduct function compute the average number of sessions per user | ||||||
Thursday | 94 | 82 | 1.3 | 470 | 179 | Using Count function, find the number of days when total page views data is available | |||||
Friday | 111 | 91 | 1.2 | 466 | 99 | ||||||
Saturday | 104 | 93 | 1.5 | 385 | 150 | ||||||
Sunday | 120 | 108 | 1 | 336 | 102 | ||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started