Hide Assignment Information

Instructions

EXCEL APPLICATION: Heritage Dogs Website Metrics

The board of directors at Heritage Dogs is meeting to consider how its website is serving the needs of volunteers, donors, and potential pet adopters. The website coordinator has asked you to create an Excel spreadsheet to help them 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 visitors who view only one page.$)$ Together, these are a measure of website $$stickiness$$the ability to keep visitors interested and coming back for more. Additionally, she wants two line charts that display website usage statistics.

Download the Excel file Ch$06$Ex$02($Figure $6\mathrm{.}21),$ and add calculations for Total Visitors, Percentage Repeat Visitors, Page Views per Visit, and Bounce Rate. Bounce Rate can be calculated as Single Page Views divided by Visits.

How would you describe the pattern of website usage in terms of visits, total visitors, and page views? How would you describe the website in terms of $$stickiness$?$