How to Use the Array Formula in Google Sheets
September 23, 2024
Article
New year. Big goals. Bigger savings. Unlock a year of unlimited access to learning with Coursera Plus for $199. Save now.
Instructor: Juan H Klopper
7,271 already enrolled
Included with
(49 reviews)
(49 reviews)
Learn to use the Wolfram Language.
Start to summarize data, create plots and charts, and do statistical tests.
Add to your LinkedIn profile
6 assignments
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
This course aims to empower you to do statistical tests, ready for incorporation into your dissertations, research papers, and presentations. The ability to summarize data, create plots and charts, and to do the statistical tests that you commonly see in the literature is a powerful skill indeed.
There are powerful tools readily available to achieve these goals. None are quite as easy to learn, yet as powerful to use, as the Wolfram Language. Knowledge is literally built into the language. With its well-structured and consistent approach to creating code, you will become an expert in no time. This course follows the approach of learning statistical analysis through the use of a computer language. It requires no prior knowledge of coding. An exciting journey awaits. If you want even more, there are optional Honors lessons on machine learning that cover the support in the Wolfram Language for deep learning.
This first week establishes the aims of the course and motivation for using the Wolfram Language. We aim to support you in gaining a remarkable new set of skills for doing statistical analysis that you can continue to use long after you complete the course. We will also describe the process of procuring the software that you will use in the course. The first is the absolutely free version, which is software as a service, meaning it runs in any web browser. The second is the desktop version. If you work or study at an institution with a site licence, you will be able to get the software for free. There is also the option to purchase your own licence.
14 videos8 readings2 discussion prompts
In week 2, we start with some actual coding, now that you know about the Wolfram Language and its different coding environments. We start off with a demonstration of a completed project. It is just a little teaser, showcasing what you will be able to do at the end. Next, we are going to learn to code by doing simple arithmetic. That is simple addition, subtraction, multiplication, and so on. Once you have realized just how simple these tasks are, you will be introduced to the way in which data is stored in a computer language. These are the stepping stone required to bringing in your own data, ready for the analyses in the following weeks.
20 videos8 readings1 assignment
In week 3, its time to start analyzing data, now that you can write some code and import your data. The two most important steps to understand the message hidden in data, are to summarize and visualize it. Descriptive statistics turn rows and columns of data into something that we as humans can understand. By summarizing values and replacing them with single values, we start to get an idea of what our analyses might show. Visualizing the data is an even better way of getting to grips with data. Box-and-whisker plots, scatter plots, bar charts, and the like are wonderful ways to augment your understanding of the data. The Wolfram Language makes summary statistics easy but it really shines when creating plots. There are almost no limits to customizing plots. No matter what your project requirements, you will learn to create plots that work for you. Starting this week is an optional Honors lessons that introduce machine learning using the Wolfram Language.
27 videos10 readings2 assignments
This final week covers all the common statistical tests - going from Student's t-test to analysis of variance to chi-squared tests. We conclude the course with a run-through of the demonstration research project that you saw at the beginning of week two. This brings together all the skills that you have acquired during the course and prepares you for the final exam. You will also have the opportunity to create your own computational essay, if you are not content with just working through the demonstration project. For those following the optional Honors lessons there is an introduction to deep learning using the Wolfram Language.
27 videos13 readings3 assignments1 discussion prompt
We asked all learners to give feedback on our instructors based on the quality of their teaching style.
The University of Cape Town is the oldest university in South Africa and is one of the leading research universities on the African continent. UCT has over 28 000 students, of whom 30% are postgraduate students. We offer degrees in six faculties: Commerce, Engineering & the Built Environment, Health Sciences, Humanities, Law, and Science. We pride ourself on our diverse student body, which reflects the many cultures and backgrounds of the region. We welcome international students and are currently home to thousands of international students from over 100 countries. UCT has a tradition of academic excellence that is respected world-wide and is privileged to have more than 30 A-rated researchers on our staff, all of whom are recognised as world leaders in their field. Our aim is to ensure that our research contributes to the public good through sharing knowledge for the benefit of society. Past students include five Nobel Laureates – Max Theiler, Alan Cormack, Sir Aaron Klug, Ralph Bunche and, J M Coetzee.
Rice University
Course
Vanderbilt University
Course
The University of Sydney
Course
Johns Hopkins University
Course
49 reviews
75.51%
16.32%
6.12%
2.04%
0%
Showing 3 of 49
Reviewed on Sep 17, 2020
This is a Fantastic Course. Those interested to learn Bio statistics with Wolfram should definitely go for this one.
Reviewed on Mar 21, 2021
The course was great, I enjoyed learning on this platform.
Reviewed on Jul 24, 2020
Learn lot of things about Mathematica language. Thank you very much
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Earn a degree from world-class universities - 100% online
Upskill your employees to excel in the digital economy
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
You will be eligible for a full refund until two weeks after your payment date, or (for courses that have just launched) until two weeks after the first session of the course begins, whichever is later. You cannot receive a refund once you’ve earned a Course Certificate, even if you complete the course within the two-week refund period. See our full refund policy.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.