PLEASE HEEEEEEELPPPP !!!!!!

M Microsoft Excel - ch09 Question File : Eile Edit Wiew Insert Format Iools Data Window Help \begin{tabular}{|l|l|} \hline 1 & \multicolumn{1}{|c}{ Marina Clo } \\ \hline 2 & \multicolumn{1}{|c}{ Source } \\ \hline 3 & Altavista.com \\ \hline 4 & Ballystore.com \\ \hline 5 & BestSearch.com \\ \hline 6 & BrooksBrothers.com \\ \hline 7 & Fashionista.com \\ \hline \end{tabular} Your firm, Marina Clothiers, makes casual pants, shirts, and other clothes for both men and women. Your firm has been attempting to increase the number of on-line customers by placing advertising banners for your Web site at other Web sites. When users click on these banner ads, they automatically are transported to your Web site. Data from your advertising campaign are summarized in the weekly Marketing Trends Reports (MTR) produced by your Web site analysis software, which appears on the Laudon Web site for Chapter 9.(Note: The site is only available for most recent editions of the book.) - Visitors are the number of people who visited your Web site by clicking on a banner ad for your site that was placed on an affiliated Web site. - Shoppers are the number of visitors referred by banner ads who reached a page in your Web site designated as a shopping page. - Attempted buyers - are the number of potential buyers referred by banner ads who reached a Web site designated as a page for summarizing and paying for purchases. - Buyers - are the number of buyers referred by banner ads who actually placed an order from your Web site. - Source-- indicates the specific Web site from which visitors came to your Web site. In trying to increase the number of on-line customers, you must determine your Web site's success in converting visitors to actual buyers. You must also look at the abandonment rate-the percentage of attempted buyers who abandon your Web site just as they were about to make a purchase. Low conversion rates and high abandonment rates are indicators that a Web site is not very effective. You also must identify likely Web site partners for a new advertising campaign. Use the MTR with your spreadsheet software to help you answer the questions below. Include graphic presentation to support your findings: 1. What are the total number of visitors, shoppers, attempted buyers, and buyers at your Web site for this period? 2. Which sources provided the highest conversion rate to buyers at your Web site--that is, the percentage of visitors from a previous site that become buyers on your site? What is the average conversion rate for your Web site? 3. Which sources provided the highest abandonment rate at your Web site? (That is the percentage of attempted buyers that abandoned their shopping cart at your Web site before completing a purchase) .What is the average abandonment rate for your Web site? 4. On which Web sites (or types of Web sites) should your firm purchase more banner ads? M Microsoft Excel - ch09 Question File : Eile Edit Wiew Insert Format Iools Data Window Help \begin{tabular}{|l|l|} \hline 1 & \multicolumn{1}{|c}{ Marina Clo } \\ \hline 2 & \multicolumn{1}{|c}{ Source } \\ \hline 3 & Altavista.com \\ \hline 4 & Ballystore.com \\ \hline 5 & BestSearch.com \\ \hline 6 & BrooksBrothers.com \\ \hline 7 & Fashionista.com \\ \hline \end{tabular} Your firm, Marina Clothiers, makes casual pants, shirts, and other clothes for both men and women. Your firm has been attempting to increase the number of on-line customers by placing advertising banners for your Web site at other Web sites. When users click on these banner ads, they automatically are transported to your Web site. Data from your advertising campaign are summarized in the weekly Marketing Trends Reports (MTR) produced by your Web site analysis software, which appears on the Laudon Web site for Chapter 9.(Note: The site is only available for most recent editions of the book.) - Visitors are the number of people who visited your Web site by clicking on a banner ad for your site that was placed on an affiliated Web site. - Shoppers are the number of visitors referred by banner ads who reached a page in your Web site designated as a shopping page. - Attempted buyers - are the number of potential buyers referred by banner ads who reached a Web site designated as a page for summarizing and paying for purchases. - Buyers - are the number of buyers referred by banner ads who actually placed an order from your Web site. - Source-- indicates the specific Web site from which visitors came to your Web site. In trying to increase the number of on-line customers, you must determine your Web site's success in converting visitors to actual buyers. You must also look at the abandonment rate-the percentage of attempted buyers who abandon your Web site just as they were about to make a purchase. Low conversion rates and high abandonment rates are indicators that a Web site is not very effective. You also must identify likely Web site partners for a new advertising campaign. Use the MTR with your spreadsheet software to help you answer the questions below. Include graphic presentation to support your findings: 1. What are the total number of visitors, shoppers, attempted buyers, and buyers at your Web site for this period? 2. Which sources provided the highest conversion rate to buyers at your Web site--that is, the percentage of visitors from a previous site that become buyers on your site? What is the average conversion rate for your Web site? 3. Which sources provided the highest abandonment rate at your Web site? (That is the percentage of attempted buyers that abandoned their shopping cart at your Web site before completing a purchase) .What is the average abandonment rate for your Web site? 4. On which Web sites (or types of Web sites) should your firm purchase more banner ads