Simple Worksheet

Click on the “S2 Questions” worksheet. Here you will find a list of questions and a column for entering your answers. Answer these questions. Some of them are easy and some are more challenging. Some of the questions will need to be answered using the data glossary on the Kaggle page. Any changes you make to the data should be made to Working Data. When possible, your answers should use an Excel function and the Excel function should be visible in the formula bar for that cell. If you use a function (such as Sort) that would not be visible in the formula bar, please describe your steps to get the answer in the Comments cell so I can recreate those steps if I wanted. Be clear and concise in the Comments.

10. Click on the “S3 Visualization” worksheet. Answer these questions. Here you will find a description of the final data visualization exercise. You will need to calculate 9 numbers and then create a chart using those numbers. When possible, your answers should use an Excel function and the Excel function should be visible in the formula bar for that cell (Note: If you use Unique, the formula should be visible in the three cells). The final part of the exercise is to write a statement associated with the chart that states which campaign was best and why.

.

we have to work on this website https://www.kaggle.com/datasets/loveall/clicks-conversion-tracki

Powered by WordPress