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
Get step-by-step solutions from verified subject matter experts
