Create the spreadsheet shown in Figure 6-21 and add calculations for Total Visitors, Percentage Repeat Visitors, Page

Question:

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”?