stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Chapter 8 Review Flashcards | StudBud
Explore
/
Chapter 8 Review
Chapter 8 Review
25 terms
·
StudBud Administration
·
48 plays
Imported from external platform
Flashcards
25 cards
F
Practice quiz
P
Host live
L
Questions
25
Answers
1
In the linear equation y = mx + b, the slope is represented by the letter ________.
m
x
y
b
2
If you autofill the formula =RANK.AVG(A1,$A$1:$A$5,0) from B1 to B5, what would the value be in B5?
3.5
3
4.5
4
3
The RANK.EQ function returns ________.
the rank of a value within a dataset, giving same ranking to tied values
the rank of a value within a dataset, giving an avg ranking to tied values
the rank of a value within a dataset, giving the highest a possible to ties
the rank of a value within a dataset, throwing out ties
4
1) Which function returns the standard deviation of a population including logical values and text?
STDEVA
STDEV.P
STDEV.S
STDEVPA
5
Relative Standing measures ________.
the rank of one value with regard to other values in a dataset
the rank value of the quartiles of a dataset
the median of a dataset
the standard deviation of a dataset
6
Why is it important to analyze the relationships between a sample and full population?
) To help make more informed statements about a population
) To bring diverging data into analysis
To limit variance
To find out how many data points are necessary to be statistically valid
7
What function returns the variance of a population?
VAR.A
VARPA
VAR.S
VAR.P
8
What are the two arguments for the FREQUENCY function?
data_array, bins_array
data_array, outlier
data_array, correlation_array
data_array, set_value
9
What is the common name for the square root of the variance?
P-value
Correlation coefficient
T-test
Standard deviation
10
A(n) ________ is a visual depiction of a population distribution created by the Analysis ToolPak.[
histogram
mu
Correlation Coefficient
ANOVA
11
A(n) ________ is a business intelligence tool which extrapolates future values based on current trends
Standard Deviatiom
Forecast Worksheets
Frequency
Analysis of variance
12
Which of the following functions determines the standard deviation of a sample?
STDEVA
STDEV.S
STDEV.P
VARA
13
Which of the following is an Excel Add-in?
Standard deviation
Frequency
ANOVA
Analysis ToolPak
14
Which function would you use to determine the number of occurrences of a particular value in a dataset?
DEVP
BINS
CORREL
FREQUENCY
15
Which function would you use to test for a relationship between students' attendance and their test scores?
CORREL
RELATE.S
RELATE.P
VARPA
16
The simplest method of creating a ________ is with the Analysis Toolpak
histogram
Frequency Chart
Standard deviation
distribution chart
17
A college admissions use the following functions to offer scholarships to student in the top 10% high school classes.
PERCENTRANK.INC
PERCENTILE.EXC
PERCENTRANK.EXC
PERCENTILE.INC
18
Which of the following is not an argument in the PERCENTRANK.INC and PERCENTRANK.EXC functions?
criteria
x
array
significance
19
________ determines how two sets of data from a sample vary simultaneously.
COVARIANCE.S
STDEV.S
STDEV.P
CORREL
20
Which function returns the rank of a value within a dataset, assigning an average rank for tied values?
RANK.EQ
RANK.TIE
AVERAGERANK
RANK.AVG
21
______ is a measure of how two sets of data vary simultaneously
Deviation
Covariance
Probability
Frequency
22
Which of the following values would demonstrate the strongest positive relationship while using the CORREL function?
0
0.5
-1
1
23
A ________ is a dataset that contains a manageable subset of a population
variance
standard deviation
Sample
population
24
The ________ function returns the variance of a sample of numerical data.
VAR.P
VARA
VAR.S
VARPA
25
Which of the following is an allowable quart argument in a QUARTILE.EXC function?
4
0
5
2
