Question: The Excel file associated with this exercise includes weekly data for Clack Inc. including cash sales, number of ad impressions, and number of ad clicks.
The Excel file associated with this exercise includes weekly data for Clack Inc. including cash sales, number of ad impressions, and number of ad clicks. Ad impressions are the number of times that a digital advertisement is displayed on a person's screen. Ad clicks are the number of times that a user clicks on a digital advertisement. In this exercise, we examine the relation between the number of ad impressions and cash sales and the relation between the number of ad clicks and cash sales. Understanding the relations of ad impressions and ad clicks to cash sales can help us determine if future cash sales can be predicted given future estimates of ad impressions or ad clicks . Required 1. Download the following Excel file: Clack Inc. 2. Create a scatter chart in Excel using the 106 weeks of actual data in order to determine whether there is a relation between the number of ad impressions and cash sales. Hint: Highlight the data to be included in the chart. Use Ctrl to select data in non-contiguous cells. Open the Insert tab and click the Scatter chart in the Charts group. 3. List the category of the x-value and the category
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
