BITM 215 EXAM 3 QUESTIONS & ANSWERS
When do you use structured references? - answer -w/ respect to tables with data
***must specifically name a data table
What is the difference btwn a qualified and unqualified structured reference? - answer -
if you use a structured reference within a table, unqualified
If you use a structured reference outside a table, fully qualified reference
Qualified has table name in formula
What is analysis of variance used for? - answer -test to determine if samples of data
were taken from the same population
What's a histogram? - answer -visual display of tabulated frequencies
What is covariance? - answer -how two sets of data vary simultaneously
What are two covariance functions? - answer -population and sample
What is ibitda? - answer -income before interest taxes depreciation and amortization
Amortization refers to 2 processes: - answer -1. Loan payments
2. Assets (value)
What is amortization? - answer -process of decreasing or accounting for an amount;
over a period
Spreading payments over multiple periods
What is pmt function? - answer -calculates monthly payments
Which is easier to understand? A structured reference or a cell reference? Why? -
answer -structured reference
If you add or delete columns/rows, the cell references may no longer be valid but the
structured references are
Statistical functions, suffixed with an s, perform calculations based on? - answer -
multiple conditions
What does countif function calculate - answer -number of cells in a range only for data
meeting a specific condition
2 arguments
1.range
, 2.criteria
What does averageif function calculate? - answer -average of cells in a range only for
data meeting a specific condition
3 arguments
1.range
2.criteria
3.sum range
What does sumif calculate? - answer -sum of values in a range only for data meeting a
specific condition
3 arguments
1. Range
2.criteria
3. Sum range
What do statistical functions calculate? - answer -range specified in arguments
What do conditional statistical functions calculate? - answer -based on condition
What will f test tell you? - answer -if a group of variables are jointly significant
If f value is greater than f critical then you can - answer -reject null hypothesis
What will p test tell you? - answer -which variables within that group are significant
What will a t test tell you? - answer -if a single variable is significant
What are three measures of spread? - answer -range
Variance
Standard deviation
What are three measures of center? - answer -mode
Median
Mean
What constitutes a fully qualified reference? - answer -using a table name and a
structured reference
Ipmt and ppmt can be used to - answer -create an amortization table
Ipmt=interest payment function syntax- calculates interest portion of a loan payment
Ppmt=principal payment function syntax-calculates principal portion of loan payment
Analysis toolpak add-in - answer -program that adds functionality to excel
When do you use structured references? - answer -w/ respect to tables with data
***must specifically name a data table
What is the difference btwn a qualified and unqualified structured reference? - answer -
if you use a structured reference within a table, unqualified
If you use a structured reference outside a table, fully qualified reference
Qualified has table name in formula
What is analysis of variance used for? - answer -test to determine if samples of data
were taken from the same population
What's a histogram? - answer -visual display of tabulated frequencies
What is covariance? - answer -how two sets of data vary simultaneously
What are two covariance functions? - answer -population and sample
What is ibitda? - answer -income before interest taxes depreciation and amortization
Amortization refers to 2 processes: - answer -1. Loan payments
2. Assets (value)
What is amortization? - answer -process of decreasing or accounting for an amount;
over a period
Spreading payments over multiple periods
What is pmt function? - answer -calculates monthly payments
Which is easier to understand? A structured reference or a cell reference? Why? -
answer -structured reference
If you add or delete columns/rows, the cell references may no longer be valid but the
structured references are
Statistical functions, suffixed with an s, perform calculations based on? - answer -
multiple conditions
What does countif function calculate - answer -number of cells in a range only for data
meeting a specific condition
2 arguments
1.range
, 2.criteria
What does averageif function calculate? - answer -average of cells in a range only for
data meeting a specific condition
3 arguments
1.range
2.criteria
3.sum range
What does sumif calculate? - answer -sum of values in a range only for data meeting a
specific condition
3 arguments
1. Range
2.criteria
3. Sum range
What do statistical functions calculate? - answer -range specified in arguments
What do conditional statistical functions calculate? - answer -based on condition
What will f test tell you? - answer -if a group of variables are jointly significant
If f value is greater than f critical then you can - answer -reject null hypothesis
What will p test tell you? - answer -which variables within that group are significant
What will a t test tell you? - answer -if a single variable is significant
What are three measures of spread? - answer -range
Variance
Standard deviation
What are three measures of center? - answer -mode
Median
Mean
What constitutes a fully qualified reference? - answer -using a table name and a
structured reference
Ipmt and ppmt can be used to - answer -create an amortization table
Ipmt=interest payment function syntax- calculates interest portion of a loan payment
Ppmt=principal payment function syntax-calculates principal portion of loan payment
Analysis toolpak add-in - answer -program that adds functionality to excel
