Data Analysis For The Big Data
In a world that’s full of data, we have many questions: we assume that data conform to the normal distribution but it that always true and why does that matter? How are our sales growing: in a straight line, in a seasonal manner or in a rapid, non linear way? We have so much data that we can’t see the wood for the trees … now what?
The world is also full of data to help us answer those questions. This course will walk through the basics of statistical thinking: starting with an interesting question. Then, we’ll learn the correct statistical tool to help answer our question of interest – using Microsoft Excel and hands on Cases. Finally, we’ll learn how to interpret our findings and develop meaningful conclusions.
This course introductions to each major sub topic that will be followed by some guided questions to help your understanding of the topic which will be integrated with/followed by Excel demonstrations, which we’ll then apply using real world datasets. We’ll cover Descriptive Statistics as our first topic learning about visualising and summarising data. Topic two will be a Modelling Investigation where we’ll discuss linear, exponential and logistic growth functions. Finally in the third Unit, we’ll learn about Inferential Statistical Tests such as the t test, analysis of variance (ANOVA) and Chi square.
This course is designed to be sequential, with each new topic building on the previous topics. Once completed, delegates will feel comfortable using basic statistical techniques to answer their own questions about their own data, using Microsoft Excel.
By the end of this course, delegates will be able to: