Intermediate Spreadsheets by DataCamp

Statistics is the science and art of analysing and interpreting data. To be able work effectively with your data, and to find solutions to your problems, you need to have a solid understanding of statistics. This course will provide you with a solid foundation of statistics. This course will teach you how to use Spreadsheets functions for exploring averages, distributions, and hypothesis testing. The course will end with a case study to demonstrate your new knowledge. Working with various datasets will be a part of the course, including historical presidential approval ratings, eBay auctions and train ridership. Enjoy!

Forecasts are something you depend on every day. Before you make a decision, you might check traffic or the weather app to see how it is. Your company's future strategy could be in your hands. You might be curious to learn how accurate forecasts can be and how you can project the future. Why is the weatherman always wrong? The Error and Uncertainty course teaches you how to make predictions and distinguish between real differences from random noise. It also examines psychological tricks that can prevent rational decision-making. You will be able identify patterns in Seattle's crime data, predict final grades, avoid traffic accidents in Nashville, as well as decide whether a bakery menu needs to change. Join us! We are sure you'll enjoy learning more about error, uncertainty.

Spreadsheets are an essential tool for marketing professionals. Spreadsheets are essential tools for marketing professionals. But how can you ensure that they remain accurate and clean, especially when multiple people add data to them? Marketing analysts have powerful tools such as regular expressions, validation of data and other tools. Clean data is only half the battle. After we learn how to clean the data, we will create charts to show it. To explore the types of data that digital marketing will encounter, we will use a dataset. Data validation will be used to identify errors in metrics and create charts to analyze campaign performance. Regular expressions can also be used to build charts to analyse campaign metrics. We will then use all of the information we have to create a dynamic dashboard.