Sophia is an intern trainee on a research team at the digital division of WeFun2021, a company that sells digital products. The research team needs her help prepare a scatter plot (with line) that illustrates how the company's actual pay per click varies with the website's quality score on Google. Sophia knows that there are four competitors with which WeFun2021 competes for pay ads slots on SERP at Google. Sophia learns the max bid and quality score for each of these four competitors as well as the max bid for WeFun2021. She would like to seek some insights into the CPC analysis. Sophia provides you with the worksheet (in the Excel document cpc.xlsx) based on which she needs to prepare a scatter plot (with line). She turns to you for help as you have taken class 21 to 25 of MKTG/BADM 3661. 1. Please calculate the actual cost per click for WeFun2021 for each quality score from 1 to 10 and complete the following table. (10 points) (Hint: You only need to write the actual cost per click for each quality score in the table below.) Actual cost per click Quality score Actual cost per click 6 Quality score 1 2 3 4 5 7 8 9 10 A B C D E F G 1 Max bid Ad Rank Actual CPC for WeFun 2021 NP 2 3 Quality Score 10 7 30 ? Quality Score 1 2 3 3 5.5 Advertiser ID Competitor 1 Competitor 2 Competitor 3 Competitor 4 We Fun2021 ? 38.5 28 4 7 4 ? 5 10 2 20 4 ? 6 8.5 5 ? 7 6 ? 8 7 ? 9 8 ? 10 9 ? 11 10 ? 12 2. Please provide a scatter plot (with line) that illustrates how Wefun2021's actual cost per click varies with its website quality score. (5 points) (Hint: Please generate the plot in the Excel document and copy and paste it in the box below.) Sophia is an intern trainee on a research team at the digital division of WeFun2021, a company that sells digital products. The research team needs her help prepare a scatter plot (with line) that illustrates how the company's actual pay per click varies with the website's quality score on Google. Sophia knows that there are four competitors with which WeFun2021 competes for pay ads slots on SERP at Google. Sophia learns the max bid and quality score for each of these four competitors as well as the max bid for WeFun2021. She would like to seek some insights into the CPC analysis. Sophia provides you with the worksheet (in the Excel document cpc.xlsx) based on which she needs to prepare a scatter plot (with line). She turns to you for help as you have taken class 21 to 25 of MKTG/BADM 3661. 1. Please calculate the actual cost per click for WeFun2021 for each quality score from 1 to 10 and complete the following table. (10 points) (Hint: You only need to write the actual cost per click for each quality score in the table below.) Actual cost per click Quality score Actual cost per click 6 Quality score 1 2 3 4 5 7 8 9 10 A B C D E F G 1 Max bid Ad Rank Actual CPC for WeFun 2021 NP 2 3 Quality Score 10 7 30 ? Quality Score 1 2 3 3 5.5 Advertiser ID Competitor 1 Competitor 2 Competitor 3 Competitor 4 We Fun2021 ? 38.5 28 4 7 4 ? 5 10 2 20 4 ? 6 8.5 5 ? 7 6 ? 8 7 ? 9 8 ? 10 9 ? 11 10 ? 12 2. Please provide a scatter plot (with line) that illustrates how Wefun2021's actual cost per click varies with its website quality score. (5 points) (Hint: Please generate the plot in the Excel document and copy and paste it in the box below.)
