Show:
scales of measurement
central tendency
standard deviation
variability
computer days 1-3
100
Which scale of measurement does NOT include a true zero?
Interval
100
What are the measures of central tendency?
mean, medium and mode
100
What percentage of the data is within one standard deviation of the mean (in a normal distribution)?
68%
100
How is the range of a data set calculated?
By subtracting the smallest number from the largest number
100
What is the function of COUNTIF
Counts the number of cells within a range that meet the given condition
200
"Rate how prepared you feel for the test: not prepared at all, somewhat prepared, very prepared." Which scale of measurement is being used?
Nominal
200
2, 3, 6, 6, 9 What is the median?
6
200
What percentage of the data is within two standard deviations of the mean?
95%
200
Why is it not useful to calculate the average deviation from the mean?
Because it is always zero
200
What is the first step in calculating the mean of a set of data in excel?
Select an empty cell
300
Temperature (in fahrenheit or celsius) is an example of which scale of measurement?
interval
300
Which measure of central tendency can be measured for all scales of measurement (nominal, ordinal, interval and ratio)?
Mode
300
Why is the standard deviation never negative?
Because the equation involves squaring the deviations from the mean (x-xbar) and a squared number cannot be negative
300
What are two measures of variability?
Range, standard deviation, average deviation from the mean
300
What is the second step in calculating the mean of a data set in excel?
click the fx button
400
An example of ________ scale of measurement would be to arrange a class by shortest to tallest.
ordinal
400
What equation is used to calculate the mean?
summation of x / n
400
If a data set included an outlier, how would the standard deviation be affected?
The standard deviation would be larger
400
2, 3, 6, 6, 9 What is the range?
7
400
What was being measured in the maze experiment (from computer day 2)?
The time it took to complete the maze in each trial and the number of errors made in each trial (Improvement in performance - less errors, faster time)
500
http://www.heritage.org/static/reportimages/8134F5559D86276054A2F1E375CE8403.gif Which scale of measurement is being used on the y-axis? Which scale of measurement is being used on the x-axis?
y-axis: ratio x-axis: nominal
500
Which measure of central tendency represent the 50th percentile?
Median
500
2, 3, 6, 6, 9
2.72
500
Name three things that could have caused variability in the helicopter experiment from computer day 3?
Drop height, size of paper clip, holding position, thickness of paper, accuracy of folds, accuracy of timer
500
List the steps to create a frequency distribution in excel?
1. Select the data that you want to include 2. Click on Insert 3. Select the type of table you want to make