BStat Prep
We have a number, 4.38E-02, in scientific notation. How would we represent it in non-scientific notation?
0.0438
Measures of Central Tendency are representative of a central location in the distribution
True
You can choose which numbers to add/subtract/multiply/divide by selecting the cell.
True
Additional functions and their usage can be found in ___________ Lookup & reference tab within formulas Help for Microsoft Excel
All of the options
The symbol ∑ is used to denote ___________
sum of data
To compute the standard deviation, one _______.
takes the square root of variance
Statistics for a sample are denoted by _____.
x̄, s2
The mean of a sample and standard deviation of a population are denoted by ______________
x̄, σ
According to the data in this video, which breed of dog is within one standard deviation of the mean height?
Beagle
In order to compute variance, ______ needs to be computed.
Mean
Given the sample data set 4, 5, 6, what is the variance?
1
The Mean of a distribution is always a value from the distribution
False
In this data set, 1, 2, 3, 4, 4, the mode is
4
You can insert formulas by _____________ Clicking on formulas and then insert function Typing = and function name If the formula bar is enabled in the view settings, typing directly in it
All of the options
In the video example, which dog breed has the largest variation?
Doberman
In Excel, in a formula, the character for computing the power of a number is ____
^
Absolute deviations are _____________.
always positive
In Excel, in a formula, the asterisk character (*) is used for ________.
multiplying two numbers
In scientific notation, the number 12,340,000,000 is represented in Excel as ____.
1.234E+10
When there are an odd number of values in a distribution, the Median is the centrally located value when all the values are in ascending order.
True
To compute the standard deviation of a data sample ______________
Use STDEV.S
When is scientific notation useful?
When working with data sets that have a wide range of values.