BStat Prep - Math / Excel
To make the denominators of the two fractions the same, we _____
find the least common multiple of the two numbers
To make the denominators of the two fractions the same, we _____.
find the least common multiple of the two numbers
The sum of two non-zero, positive numbers is always going to be ______________.
greater than both numbers
When one divides two whole numbers, what value represents the number of times one number goes into the other?
Quotient
To compute the standard deviation of a data sample ______________
Use STDEV.S
Additional functions and their usage can be found in ___________
- "Lookup & Reference" tab within Formulas - Help for Microsoft Excel
You can insert formulas by ______________
- Clicking on "Formulas" and then "Insert Function" - Typing "=" and a function name - If the "formula bar" is enabled in the view settings, typing directly in it
A pie chart is ____.
- a graph - an illustration of data points - a representation of numerical proportions
We have a number, 4.38E-02, in scientific notation. How would we represent it in non-scientific notation?
0.0438 1. Enter 4.38E-02 into excel 2. Right click on the number 3. "Format cells" 4. "General"
In scientific notation, the number 12,340,000,000 is represented in Excel as ____.
1.234E+10 1. Enter 12,340,000,000 into excel 2. Right click on the number 3. "Format cells" 4. "Scientific"
Approximately how many digits will be there in the product of 3-digit and 2-digit whole numbers?
4 or more
When dividing two fractions, 4/5 ÷ 2/6, the denominator of the answer will be ____
5 x 2
When multiplying two fractions, 4/5 x 2/6, the denominator of the answer will be ____
5 x 6
In the video example, what brand has the smallest sales, and how can we tell from the pie chart?
Lamborghini has the smallest sales, because its proportion of the pie is smallest.
When we multiply 243 x 7, what is the first step?
Multiply 7 x 3
In Excel, in a formula, the character for computing the power of a number is ____.
^
We begin the long division problem of dividing 365 by 30 looking at _____.
how many times the divisor goes into the first digit of the dividend.
In order to solve this problem, 4/5 divided by 5/7, we ____
multiply 4/5 by 7/5
In Excel, in a formula, the asterisk character (*) is used for ________.
multiplying two numbers
A pie chart is most useful to illustrate ______________
proportions of the whole
If the brand that had most sales was Lamborghini, then ______________.
the bar (or column) corresponding to Lamborghini would be the largest
We add the numerators only when ______________
the denominators are the same.
We subtract the numerators only when ______________
the denominators are the same.
A bar graph is ______________.
- a series of contiguous columns of varying heights to denote variations in data - an illustration of data points - a pictorial representation of statistical variations
If the brand that had most sales was VW, then ______________.
the segment of the pie corresponding to VW would be the largest
A bar graph can have vertical or horizontal columns.
True
When is scientific notation useful?
When working with data sets that have a wide range of values.
The first step when adding two fractions is to _____.
check the denominator of the two fractions
A digit is carried over only when ______________
the number in the top row is less than the one in the bottom row
How many steps are there when one multiplies 3-digit and 2-digit whole numbers?
3
When the remainder is zero, it means that the dividend is a multiple of the divisor.
True
You can choose which numbers to add/subtract/multiply/divide by selecting the cell.
True
Which is a correct statement for when two numbers can be subtracted?
We can only subtract when the number in the top row is greater than or equal to the number in the bottom row.
In the example shown, which brand of vehicles has the highest sales, and how can we tell?
Audi, because the bar representing its sales is longest.
The first step when subtracting two fractions is to ____.
check the denominator of the two fractions
When we subtract two numbers, the result is ____.
dependent on the two numbers