Tutoring at Indiana University (IU) in Bloomington, Indiana

Finite math, K201, calculus, and statistics explained

This video covers one of the more challenging types of combination and probability problems that are commonly seen on finite exams. We'll need to split the event space into two cases, and compute the number of combinations for each case. Finally, we'll add our two cases together and divide by the total number of combinations in our sample space.

This content was developed with the help of our tutors Grace and Alex, and our design intern Patrick. Thanks everyone!

Finite M118
Aug 30, 2017

Finite Math - Set Theory

Welcome to to the very first video in our finite math series! In this video, we'll talk about the basic concept of sets. Then, we'll use these concepts to frame a simple problem that involves determining how many elements are in a set.

This content was developed with the help of our tutors Grace and Alex, and our design intern Patrick. Thanks everyone!

To be honest, Excel's text functions are kind of awkward and limited. Unlike full-blown programming languages like Python and Javascript, you don't have access to regular expressions or standard string functions such as split, join, and replace. Instead, you have to make due with complicated combinations of Excel's LEFT, RIGHT, MID, LEN, FIND, and CONCATENATE formulas to manipulate text.

In this video, we walk you through a common GP9 string (text) manipulation problem that asks you to use these functions to split, format, and rearrange text into more useful representations.

Download the exercise files

Even casual Excel users have probably encountered a situation where they wanted to test a formula against a range of possible input values. One way to do this is by simply copying a formula down a column or row of your table. A more structured way of doing this, though, is Excel's Data Tables (What-if Analysis) feature. Most K201 students don't usually have much trouble with figuring out how this feature works, but it can be easy to forget under the pressure of an exam.

Actually, the trickiest thing we cover in this video is defining custom data formats. We're not sure why, but K201 GPs and exams usually like to ask you to create custom data formats as a followup to two-variable data table questions.

Download the exercise files

One of the more powerful features of Excel is its collection of lookup functions, which let you cross-reference tabular data in your spreadsheets. K201 students sometimes find them tricky to master though, especially when it comes to determining when to use a VLOOKUP, HLOOKUP, or INDEX-MATCH formula.

In this video for GP7, Dalia goes over examples for each of these formulas - you'll be done in no time!

Download the exercise files