Learn the essential concepts of statistics and basic probability using Excel to discover the powerful tools at your disposal.
Duration
5 weeksWeekly study
3 hours100% online
How it worksIncluded in an ExpertTrack
Course 2 of 4
Statistics and Data Analysis in Excel
Develop crucial skills for a career as a data analyst
If you’re considering a career as a data analyst, you need to know about many aspects of statistics including histograms, pareto charts, boxplots, Bayes’ theorem, and much more.
On this five-week course, you’ll delve into applied statistics and learn how to use the powerful tools built into Excel to explore the core principles of statistics.
Learning from the specialists at CloudSwyft, a leading Learning-as-a-Service platform provider, you’ll develop essential data science skills to improve your knowledge and confidence in the field.
Learn the basics of descriptive statistics
On the course, you’ll develop an understanding of the concepts of descriptive statistics and basic probability before learning how to apply them.
For this process, you’ll learn how to use the calculation and visualisation environment of Excel.
Unpack random variables, confidence intervals, and more
To develop your statistical skills further, you’ll learn about the fundamentals of random variables, sampling, confidence intervals, and hypothesis testing – all key concepts in data analysis.
Learn how to apply concepts such as hypothesis testing
As you increase your knowledge on statistical concepts, you’ll learn how to apply it all in Excel.
This practical exercise will help you see the power of Excel in action and will give you the ability to calculate and visualise these essential statistical concepts in flexible ways.
With this understanding, you’ll be able to quickly explore data and produce valuable insights from the data set.
By the end of the course, you’ll have developed critical data analyst skills and have the confidence and knowledge to use Excel to its full potential.
What topics will you cover?
- Descriptive Statistics
- Basic Probability
- Random Variables
- Sampling and Confidence Intervals
- Hypothesis Testing
Prove you're job ready
Highlight the new, job-relevant skills you’ve gained and supplement existing qualifications with a hard-earned, industry-specific digital certificate – plus one for every course within your ExpertTrack.
- Learn the latest in your chosen industry or subject.
- Complete each course and pass assessments.
- Receive certificates validated by the educating organisation.
- Impress employers with learning outcomes you can add to your CV.
- Make your career dreams a reality.
Download a PDF
Learning on this course
On every step of the course you can meet other learners, share your ideas and join in with active discussions in the comments.
What will you achieve?
By the end of the course, you‘ll be able to...
- Present data using charts and statistical tools
- Explore basic probability, complements and independent events
- Interpret which statistical tools to use depending on which event
- Apply sampling strategies on observations from the population
Who is the course for?
This course is designed for anyone interested in learning more about statistics, and how to apply these concepts in Excel.
It will be particularly useful for those wanting to pursue a data analyst career.
What software or tools do you need?
You will need Microsoft Excel installed on your computer.
Start learning today - free 2-day trial
After your free trial you can:
- Pay $39 per month to keep learning online
- Have complete control over your subscription; you can cancel any time
- Work at your own pace and set your own deadlines at every stage
- Only pay while you’re learning; the subscription will cancel automatically when you finish
- Complete online assessments to test your knowledge and prove your skills
- Earn digital course certificates and a final award that you can share online, with potential employers, and your professional network
- Keep access to the content of courses you complete even after your subscription ends
Learning on FutureLearn
Your learning, your rules
- Courses are split into weeks, activities, and steps to help you keep track of your learning
- Learn through a mix of bite-sized videos, long- and short-form articles, audio, and practical activities
- Stay motivated by using the Progress page to keep track of your step completion and assessment scores
Join a global classroom
- Experience the power of social learning, and get inspired by an international network of learners
- Share ideas with your peers and course educators on every step of the course
- Join the conversation by reading, @ing, liking, bookmarking, and replying to comments from others
Map your progress
- As you work through the course, use notifications and the Progress page to guide your learning
- Whenever you’re ready, mark each step as complete, you’re in control
- Complete 90% of course steps and all of the assessments to earn your certificate
Want to know more about learning on FutureLearn? Using FutureLearn
Get a taste of this course
Find out what this course is like by previewing some of the course steps before you join: