BusinessCourse

Return to course

Course Content $/$ Chapter $5/$ Data Analytics Assignment Chapter $5$

Data Analytics Assignment Chapter $5$

Question $3$

Partially correct

Mark $7$ out of $30$

Flag question

Forecasting Sales Using Excel

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 th 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 imp 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

Required

Download the following Excel file: Clack Inc.

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. to select data in non$-$contiguous cells. Open the Insert tab and click the Scatter chart in the Charts group.

List the category of the $x-$value and the category of the $y-$value.

$x-$value:

Number of Ad impressions

$y-$value:

Cash sales

Time left $2$:$30$:$07$

Question $3$ Partially correct

Mark $9$ out of $30$

Flag question

eBook

Print

Forecasting Sales Using Excel

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 the number of 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 or ad clicks.

Required

Download the following Excel file: Clack Inc.

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.

List the category of the $x-$value and the category of the $y-$value.

$x-$value:

Number of Ad impressions

$y-$value:

Add a trendline to the chart and display the regression equation and $R-$squared value. Hint: Right$-$click inside the data points on your chart, select Add trendline, check the Display equation on chart. check Display $R$ squared value on chart.

$85\%$

Masciy ciauray

Search