1.1-1.4 Homework #1

A predefined formula is also known as a(n) ______.

function

Consider the following data: 0, 0, 0, 0, 1, 1, 1, 3, 3, 3, 4, 5, 20, 30 Which of the following statements are true? (choose one or more)

- mode represents the low end of the distribution - median is best estimation of central tendency - mean is affected by outliers - most values are under 5

In Excel, which of following functions calculates the mean of set of numbers?

AVERAGE

When using the SUM function in Excel, which of the following are you calculating?

Adding numbers in cells

T/F? The misuse of statistics is always intentional.

False

When you create a formula that goes beyond a simple one, you need to remember which of the following?

The order in which operations are carried out.

What is the term used to describe the specific cells on which you want a function performed?

argument

Which of the following refers to the type of statistical methods used to organize and describe the characteristics of a dataset?

descriptive statistics

Jennifer is thinking of moving into a new neighborhood that is closer to campus. Before signing a lease, she checks the number of robberies in the neighborhood. What type of variable is the number of robberies reported in the neighborhood during the last year?

discrete

Which of the following refers to the type of statistical methods used to draw conclusions about the population based on a sample?

inferential statistics

Which measure of central tendency is affected by outliers?

mean

What is the term associated with scores that are at the extreme ends of the distribution?

outliers

You collect blood pressure readings from 150 patients. What type of data are these readings?

quantitative

What does the notation ∑ mean?

sum

Where are functions found in Excel?

under the Formulas tab

What is a function in Excel?

A predefined formula