Business Analytics Exam test quiz
and answers graded A+
Population - is the collection of all items of interest or under investigation
- N represents the population size
- all= population
Sample - is an observed subset of the population
-n represents sample size
Parameter - is a specific characteristic of a population
Statistic - is a specific characteristic of a sample
bar chart - a chart that displays horizontally and is used for comparison among individual items
line graph - is used to show values of a variable overtime
time is measured on there horizontal axis
variable of interest is on the vertical axis
pie chart - a chart that displays a comparison of each value to a total
histogram -
scatter diagram - a chart that shows the relationship between numeric variables
spreadsheet - a two dimensional grid that can be used to model quantitive data and perform
accurate and rapid calculations with results ranging from simple budgets to financial and statistical
analysis
cell - the intersection of a row and a column in a table or worksheet
, row - a horizontal set of cells that encompass all the columns in a worksheet
column - a vertical set of cells that encompasses all the rows in a worksheet
formula - performs a mathematical calculation using information in the active worksheets and other
worksheets to calculate new values , it contains cell references , constants, functions and
mathematical operators
worksheet - each instance of a spread sheet , grid columns and rows in which data is entered
what if analysis - an analysis that changes in a spread sheet to explore all the various results
record - all of the categories of data that pertain to one person, thing , place , event or idea and that
are formatted as a row in a worksheet or database table
field - a specific piece of information that is stored in every record and when formatted appears as a
column in a database table, an item of information in a worksheet column that is associated with
something of interest
workbook - is a file that contains one or more worksheets
active worksheet - is the worksheet that is visible in the excel application window and is denoted by
a white tab
cell reference - a reference to a particular cell or cell range within a formula or function instead of a
value
active cell - the cell that is the recipient of the action
Mode.Mult function - a function that returns the most frequently occurring values in a range of data
comment - a text box, similar to a sticky note
and answers graded A+
Population - is the collection of all items of interest or under investigation
- N represents the population size
- all= population
Sample - is an observed subset of the population
-n represents sample size
Parameter - is a specific characteristic of a population
Statistic - is a specific characteristic of a sample
bar chart - a chart that displays horizontally and is used for comparison among individual items
line graph - is used to show values of a variable overtime
time is measured on there horizontal axis
variable of interest is on the vertical axis
pie chart - a chart that displays a comparison of each value to a total
histogram -
scatter diagram - a chart that shows the relationship between numeric variables
spreadsheet - a two dimensional grid that can be used to model quantitive data and perform
accurate and rapid calculations with results ranging from simple budgets to financial and statistical
analysis
cell - the intersection of a row and a column in a table or worksheet
, row - a horizontal set of cells that encompass all the columns in a worksheet
column - a vertical set of cells that encompasses all the rows in a worksheet
formula - performs a mathematical calculation using information in the active worksheets and other
worksheets to calculate new values , it contains cell references , constants, functions and
mathematical operators
worksheet - each instance of a spread sheet , grid columns and rows in which data is entered
what if analysis - an analysis that changes in a spread sheet to explore all the various results
record - all of the categories of data that pertain to one person, thing , place , event or idea and that
are formatted as a row in a worksheet or database table
field - a specific piece of information that is stored in every record and when formatted appears as a
column in a database table, an item of information in a worksheet column that is associated with
something of interest
workbook - is a file that contains one or more worksheets
active worksheet - is the worksheet that is visible in the excel application window and is denoted by
a white tab
cell reference - a reference to a particular cell or cell range within a formula or function instead of a
value
active cell - the cell that is the recipient of the action
Mode.Mult function - a function that returns the most frequently occurring values in a range of data
comment - a text box, similar to a sticky note
