Basics of Statistics
Excel
Chapter 5
Chapter 6
Chapter 7
100

When symmetrical, a skewness score will equal…

0

100

What does the function "AVERAGE" compute?

The mean of a set of numbers

100

This provides a numerical description of the outcome of an experiment?

What is a Random Variable?

100

What does n represent?

# of times an experiment is done

100

What is called a parameter.

A numerical characteristic of a population, such as a population mean u, a population standard deviation o, a population proportion p, and so on.

200

What is a "sample" of a given amount of data?

A portion of the whole data.

200

Excel uses dollar signs ($) to indicate that...

A reference is fixed

200

This describes how the probabilities are distributed over the values the random variable can assume?

What is the Probability Distribution for a Random Variable?

200

What does p represent?


Probability of something happening


200

When we refer to simple random sampling, what are we assuming?

we will asume the samplingis without replacement.

300

Probabilities are only numbers between _and _


0 and 1

300

What must an excel formula always start with?

An equals (=) sign

300

This type of distribution is used when it is desirable to determine the probability of obtaining x occurrences over an interval of time or space.

What is the Poisson distribution?

300

What does the highest point of the normal curve tell us?


The highest point is the mean which can also be interpreted as the median and mode

300

A population where it's possible to count its individuals is called?

What is Finite Population.

400

What does descriptive statistics consist of?

Consists of the collection, organization, summarization, and presentation of data

400

What are the 3 steps taken to create a chart based on the data given?

  1. Select the data for which you want to create a chart.
  2. Click INSERT > Recommended Charts.
  3. When you find the chart you like, click it.
400

This type of distribution is used to compute the probability of x successes in n trials, but the probability of success changes from trial to trial?

What is Hypergeometric distribution? 

400

What does the area under a graph of f(x) represent between x1 and x2?

The area under a graph of f(x) between x1 and x2 represents probability

400

What is the parameter?

A numerical descriptive measure of a population

500

What is the goal of statistics?


"To make better decisions using data in the presence of uncertainty."

500

What are the four areas of a pivot table?

Filters, Columns, Rows, and Values

500

This type of distribution is used to determine the probability of success of successes in n trials, when the trials are independent, the probability of success does not change from trial to trial, and there are two outcomes possible in each trial?

What is a Binomial distribution?

500
What are the 3 key numbers regarding standard deviation?

68 (% of the values fall within 1 standard deviation of the mean)

95 (% of those values fall within 2 standard deviations of the mean) 

99.7 (% of the values fall within 3 standard deviations of the mean)

500

If the value of p=.50, then it can be concluded that pbar=__

.50

M
e
n
u