## Tables and Excel Created c. 2013 by Microsoft Corporation [Public domain], via Wikimedia Commons

Excel comes in handy for creating tables of values for limits. This FAQ contains two PDFs that demonstrate the process of creating a table using a “fill” in Excel.

How Do I Make A Table Of Values In Excel?

This same process may be used to create tables in other types of spreadsheets such as Google Sheets.

Posted on Categories Uncategorized

## How Do You Compute Conditional Probability From Data?

It easy to confuse conditional probability with probability of an intersection of two event. They are related! The probability of an event A given that event B has occurred is The vertical bar | means “given” and the event after it is the event that has already occurred.

Let’s look at some data to determine how to find several different probabilities including conditional probability.

Go to the MathFAQ >>

Posted on Categories Uncategorized

## How Do You Compute the Sample Mean or Variance in a Spreadsheet? Both Excel and Sheets use the same commands to calculate a sample mean, sample variance, or sample standard deviation. This FAQ demonstrates how to use these commands.

Goto the MathFAQ >>

Posted on Categories Uncategorized

## Undoing Rates Using A Graph

Often a rate function or derivative is given by data or a graph. If we can find a function for the data, we can take the antiderivative of the function to undo the rate. But what if the rate is given by a graph whose formula is unknown? Go To MathFAQ

Posted on Categories Uncategorized

## The Future Value Of An Annuity in Google Sheets The future value of either an ordinary annuity or an annuity due may be calculated in Google Sheets. The Sheets command FV helps you to do this.

Goto the MathFAQ

Posted on Categories Uncategorized