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