Answered step by step
Verified Expert Solution
Link Copied!

Question

00
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 with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

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

Intermediate Accounting

Authors: J. David Spiceland, James Sepe, Mark Nelson, Wayne Thomas

9th Edition

9781259722660

Students also viewed these Accounting questions

Question

CL I P COL Astro- L(1-cas0) Lsing *A=2 L sin(0/2)

Answered: 1 week ago