Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Routledge Handbook Of Environmental Accounting

Authors: Jan Bebbington, Carlos Larrinaga, Brendan O'Dwyer, Ian Thomson

1st Edition

0367724901, 9780367724900

More Books

Students also viewed these Accounting questions

Question

Define Scientific Management

Answered: 1 week ago

Question

Explain budgetary Control

Answered: 1 week ago

Question

Solve the integral:

Answered: 1 week ago

Question

What is meant by Non-programmed decision?

Answered: 1 week ago