Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!