Create the spreadsheet shown in Figure 6 21 and add calculations
Create the spreadsheet shown in Figure 6-21 and add calculations for Total Visitors, Percentage Repeat Visitors, Page Views per Visit, and Bounce Rate. To calculate Bounce Rate, divide Page Views by Single Page Views.
Create one line chart that shows Visits, Total Visitors, and Page Views. Create a second line chart that shows the Bounce Rate and the Percentage Repeat Customers. For both charts select a layout that includes a chart title, axis title, and a legend.
How would you describe the pattern of Web site usage in terms of visits, total visitors and page views? How would you describe the Web site in terms of “stickiness”?

Membership TRY NOW
  • Access to 800,000+ Textbook Solutions
  • Ask any question from 24/7 available
  • Live Video Consultation with Tutors
  • 50,000+ Answers by Tutors
Relevant Tutors available to help