BStat Prep - Math / Excel

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

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


Set pelajaran terkait

Chapter 7 Individual and Group Decision making

View Set

Chapter 5: Understanding Consumer Behavior

View Set

Markets and Social Security Chapter 6

View Set