Final Definitions

Question 1

data

Answer 1

facts and figures collected, analyzed, and summarized for presentation and interpretation

Question 2

data set

Answer 2

all data collected in a particular study

Question 3

elements

Answer 3

entities on which data are collected

Question 4

variable

Answer 4

characteristic of interest for the elements

Question 5

observation

Answer 5

set of measurements obtained for a particular element

Question 6

categorical data

Answer 6

data that can be grouped by specific categories

Question 7

quantitative data

Answer 7

data that use numerical values to indicate how much or how many are referred to

Question 8

categorical variable

Answer 8

variable with categorical data

Question 9

quantitative variable

Answer 9

variable with quantitative data

Question 10

population

Answer 10

set of all elements of interest in a particular study

Question 11

sample

Answer 11

subset of the population

Question 12

frequency distribution

Answer 12

tabular summary of data showing the number (frequency) of observation in each of several non-overlapping categories or classes

Question 13

relative frequency distrivution

Answer 13

shows the fraction or proportion of observations belonging in a class (ie 0.38)

relative frequency of a class=frequency of a class/n

Question 14

percent frequency distribution

Answer 14

summarizes the percent frequency of data for each class ie (38%)

Question 15

bar chart

Answer 15

graphical display for depicting categorical data summarized in a frequency, relative frequency, or percent frequency distribution
-categorical data: gap between bars

Question 16

pie chart

Answer 16

presents relative frequency and percent frequency distributions for categorical data

Question 17

dot plot

Answer 17

show the details of the data and are useful for comparing the distribution of the data for 2 or more variables

Question 18

histogram

Answer 18

bar chart with no gaps

Question 19

stem and leaf display

Answer 19

used to show simultaneously the rank order and shape of a distribution of data

Question 20

variance

Answer 20

measure of variability that utilizes all the data

based on the difference between the value of each observation, xi, and the mean

Question 21

standard deviation

Answer 21

positive square root of the variance

Question 22

coefficient of variation

Answer 22

indicates how large the standard deviation is relative to the mean

Question 23

tree diagram

Answer 23

helps visualize a multi step random expirement

Question 24

discrete random variable

Answer 24

a random variable that may assume either a finite number of values or an infinite sequence of values ie 0,1,2,3,4 etc

Question 25

continuous random variable

Answer 25

a random variable that may assume any numerical value in an interval or collection of intervals ie 2.751

Question 26

probability distribution

Answer 26

describes how probabilities are distributed over the values of the random variable

Question 27

probability function

Answer 27

provides the probability for each value of the random variable

Question 28

empirical discrete distribution

Answer 28

the use of the relative frequency method to develop discrete probability distributions leads to an empirical discrete distribution

Question 29

discrete uniform probability distribution

Answer 29

f(x)=1/n

Question 30

expected value

Answer 30

mean

Question 31

binomial experiment

Answer 31

1. consists of a sequence of n identical trials 2. two outcomes are possible for each trial, success or failure 3. probability of success=p, does not change from trial to trial. the probability of failure=1-p, also does not change from trial to trial 4. the trials are independent

Question 32

binomial probability distribution

Answer 32

associated with the discrete random variable, x

Question 33

sampled population

Answer 33

population from which the sample is drawn

Question 34

simple random sample

Answer 34

of size n from a finite population of size N is a sample selected such that each possible sample of size n has the same probability of being selected

Question 35

random sample

Answer 35

of size n from an infinite population is a sample selected such that 1. each element selected comes from the same population 2. each element is selected independently

Question 36

point estimate

Answer 36

p bar | x/n

Question 37

sampling distribution

Answer 37

shows distribution of frequencies of a range of different outcomes that could occur

Question 38

If the number 12.0 appears in a cell, which number might actually be stored there?

Answer 38

11.99

Question 39

All the columns in a worksheet must have the same width. | T or F?

Answer 39

F

Question 40

Excel workbooks have the file extension...

Answer 40

.xlsx

Question 41

Which of the following entries would be considered text?

Answer 41

555-1212

Question 42

In Excel, a workbook is the same as...

Answer 42

an Excel file

Question 43

In Excel, column headings are always designated by...

Answer 43

letters

Question 44

In Excel, row headings are always designated by...

Answer 44

numbers

Question 45

In Excel, an entire row or column can be hidden for clarity, and then later revealed. T or F

Answer 45

T

Question 46

A cell reads 3.1E-3. This means the cell contains the number...

Answer 46

0.0031

Question 47

The ribbon in Excel can be moved to any place on the screen. T or F

Answer 47

F

Question 48

What symbol must precede every formula?

Answer 48

=

Question 49

What Excel function adds up all the numbers in a range of data in cells?

Answer 49

SUM

Question 50

What should you type, exactly, in cell C8 to find the mean cost-per-hour?

Answer 50

=AVERAGE(C2:C7)

Question 51

What symbol would you add to a cell reference in the formula bar in order to change a relative reference of a cell to an absolute reference?

Answer 51

$

Question 52

The Excel expression "A2:B3" represents....

Answer 52

a rectangle of cells selected with corners at cells A2 and B3

Question 53

What must you press to execute the FREQUENCY function

Answer 53

CTRL-SHIFT-ENTER

Question 54

The Analysis ToolPak makes it possible to quickly generate a histogram from a set of data. Before the Histogram Tool can be used to do this, however, it is necessary to...

Answer 54

choose upper bounds for the bins we want to use and enter them in a column.

Question 55

How could the formula in cell E2 be altered so that, when copied into cells E3 and E4, the correct counts will be displayed?

Answer 55

=COUNTIF($A$1:$A$15, D2)

Question 56

Excel can generate a variety of graphs very easily. One type of graph that Excel does not make is a

Answer 56

box plot.

Question 57

What must be done to get the information in a PivotTable to update after a change is made in the data?

Answer 57

Click "refresh" in the PivotTable Tools menu.

Question 58

What is the difference between COUNTIF and COUNTIFS?

Answer 58

COUNTIFS can count over multiple ranges and criteria, COUNTIF can only count one range according to one criterion.

Question 59

How could the formula in cell G3 be altered so that when copied down and across, the correct counts will appear?

Answer 59

=COUNTIFS($B$2:$B$11,G$2,$C$2:$C$11,$F3)

Question 60

What's the best kind of chart to use in Excel to visualize the relationship between two numerical variables?

Answer 60

Scatterplot

Question 61

To measure correlation, Excel has an embedded formula CORREL. Is the following statement true or false? "Typing =CORREL(A1:A10, B1:B10) will give you the same value as typing in =CORREL(B1:B10, A1:A10)." T or F

Answer 61

T