6-19. EXCEL APPLICATION: Heritage Dogs Website Metrics The board of directors at Heritage Dogs is meeting to con- sider how its website is serving the needs of volunteers, donors, and potential adoptive pet owners. The website coordinator has asked you to create an Excel spreadsheet to help her analyze quarterly data for several key indicators including percentage of repeat visitors, page views per visit, and bounce rate. The bounce rate is the percentage of visi- tors who view only one page. Together, these are a measure of website "stickiness"-the ability to keep visitors inter ested and coming back for more. Additionally, she wants two line charts that display website usage statistics. 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 chart select a layout that includes a chart title, axis title, and a legend. would you describe the pattern of website usage ld in terms of visits, total visitors, and page views? How wou you describe the website in terms of "stickiness"? 6-19. EXCEL APPLICATION: Heritage Dogs Website Metrics The board of directors at Heritage Dogs is meeting to con- sider how its website is serving the needs of volunteers, donors, and potential adoptive pet owners. The website coordinator has asked you to create an Excel spreadsheet to help her analyze quarterly data for several key indicators including percentage of repeat visitors, page views per visit, and bounce rate. The bounce rate is the percentage of visi- tors who view only one page. Together, these are a measure of website "stickiness"-the ability to keep visitors inter ested and coming back for more. Additionally, she wants two line charts that display website usage statistics. 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 chart select a layout that includes a chart title, axis title, and a legend. would you describe the pattern of website usage ld in terms of visits, total visitors, and page views? How wou you describe the website in terms of "stickiness
