BANA Exam 1

bar chart

A chart that is recommended as an alternative to a pie chart is a - line chart. - stacked column chart. - bar chart. - box plot.

cincinnati zoo

The company identified in Chapter 3, Analytics in Action, is - Cincinnati Zoo & Botanical Garden - Procter & Gamble - U.S. Census Bureau - Alliance Data Systems

alliance data systems

The company identified in Chapter 7, Analytics in Action, is - Alliance Data Systems - U.S. Census Bureau - John Morrell & Company - Procter & Gamble

residual

The difference between the observed value of the dependent variable and the value predicted using the estimated regression equation is known as the - residual. - error term. - constant term. - model parameter.

straight line

The graph of the simple linear regression equation is a(n) - hyperbola. - straight line. - ellipse. - parabola.

reduces

The ratio of the amount of ink used in a table or chart that is necessary to convey information to the total amount of ink used in the table and chart is known as data-ink ratio. Using additional ink that is not necessary to convey information has what effect on the data-ink ratio? ​​ ​- increases - it doesn't change the data-ink ratio ​- the data-ink ratio becomes zero - ​reduces

excel

The software package most commonly used for creating simple charts is - SAS. - XLMiner. - Excel. - R.

0.43

What would be the coefficient of determination if the total sum of squares (SST) is 23.29 and the sum of squares due to regression (SSR) is 10.03? - 0.43 - 0.19 - 2.32 - 0.89

18.43

What would be the value of the sum of squares due to regression (SSR) if the total sum of squares (SST) is 25.32 and the sum of squares due to error (SSE) is 6.89? - 31.89 - 18.43 - 19.32 - 15.32

scatter chart

A _____________ is a graphical presentation of the relationship between two quantitative variables. - pie chart - scatter chart - bar chart - histogram

scatter chart

A _____________ is a graphical presentation of the relationship between two quantitative variables. - scatter chart - histogram - pie chart - bar chart

trendline

A _____________ is a line that provides an approximation of the relationship between the variables. - line chart - trendline - gridline - sparkline

it can be difficult to perceive small differences in areas

A disadvantage of stacked-column charts and stacked-bar charts is that - they cannot be used to compare relative values of quantitative variables for the same category. -- it can be difficult to perceive small differences in areas. - they do not include all the values of the variable. - they are only used when many quantitative variables need to be displayed.

predictive analytics

A forecast that helps direct police officers to areas where crimes are likely to occur based on past data is an example of - decision analysis. - prescriptive analytics. - predictive analytics. - descriptive analytics.

column chart

A graphical presentation that uses vertical bars to display the magnitude of quantitative data is known as a ​ - clustered column chart. - scatter chart. - column chart. - bubble chart.

sparkline

A line chart that has no axes but is used to provide information on overall trends for time series data is called a - time series plot. - trendline. - sparkline. - bubble chart.

simple linear regression

A regression analysis involving one independent variable and one dependent variable is referred to as a - time series analysis. - factor analysis. - data mining. - simple linear regression.

heat map

A two-dimensional graph representing the data using different shades of color to indicate magnitude is called a - column chart. - heat map. - bubble chart. - pie chart.

a dummy variable

A variable used to model the effect of categorical independent variables in a regression model which generally takes only the value zero or one is called - a dummy variable. - the coefficient of determination. - a residual. - interaction.

clustered column chart

An alternative for a stacked column chart when comparing more than a couple of quantitative variables in each category is a - clustered bar chart. - stacked bar chart. - pie chart. - clustered column chart.

heat map and sparklines

An effective display of trend and magnitude is achieved by using a combination of a - line chart and trendlines. - time series plot and sparklines. - heat map and sparklines. - bubble chart and trendlines.

cross-validation

Assessing the regression model on data other than the sample data that was used to generate the model is known as - graphical validation. - postulation. - cross-validation. - approximation.

data visualization

Chapter 3 focuses on - descriptive statistics - linear regression - spreadsheet models - data visualization

linear regression

Chapter 7 focuses on - data visualization - descriptive statistics - spreadsheet models - linear regression

data dashboards

Corporate-level managers use ______ to summarize sales by region, current inventory levels, and other company-wide metrics all in a single screen. - simulations - crosstabulation - tables - data dashboards

line chart

DJ needs to display data over time. Which of the following charts should he use? - Bar chart - Pie chart - Line chart - Scatter chart

descriptive

Data dashboards are a type of _________ analytics. - predictive - descriptive - prescriptive - decision

is necessary to convey the meaning of the data to the audience

Data-ink is the ink used in a table or chart that - helps in presenting data when the audience need not know exact values. - is necessary to convey the meaning of the data to the audience. - increases the non-data-ink ratio. - does not help in conveying the data to the audience.

increases the data-ink ratio

Deleting the grid lines in a table and the horizontal lines in a chart - increases the data-ink ratio. - increases the non-data-ink ratio. - does not affect the data-ink ratio. - decreases the data-ink ratio.

filters

Fields may be chosen to represent all of the following except ____________ in the body of a PivotTable. - columns - filters - rows - values

overfitting

Fitting a model too closely to sample data, resulting in a model that does not accurately reflect the population is termed as - hypothesizing. - postulating. - approximation. - overfitting.

independent variable

In a linear regression model, the variable (or variables) used for predicting or explaining values of the response variable are known as the ________________. It(they) is(are) denoted by x. - regression variable - dependent variable - residual variable - independent variable

readability

In many cases, white space in a chart can improve - stability. - readability. - functionality. - complexity.

bubble chart

In order to visualize three variables in a two-dimensional graph, we use a - column chart. - 3-D chart. - 2-D chart. - bubble chart.

pie chart

Making visual comparisons between different values of a categorical variable is difficult in a - column chart. - line chart. - pie chart. - scatter chart.

multiple regression

Regression analysis involving one dependent variable and more than one independent variable is known as - multiple regression. - simple regression. - linear regression. - none of these.

the values being displayed have different units or very different magnitudes

Tables should be used instead of charts when - there are more than two columns of data. - the reader needs relative comparisons of data. - the reader need not differentiate the columns and rows. - the values being displayed have different units or very different magnitudes.

a data dashboard

The Analytics in Action example in Chapter 3 concerned - predictive analytics. - a data dashboard. - weather forecasting. - descriptive statistics

predicting the effect of advertising

The Analytics in Action example in Chapter 7 concerned - testing a hypothesis. - weather forecasting. - descriptive statistics. - predicting the effect of advertising.

coefficient of determination

The ___________ is a measure of the goodness of fit of the estimated regression equation. It can be interpreted as the proportion of the variability in the dependent variable y that is explained by the estimated regression equation. - interaction variable - dummy variable - residual - coefficient of determination

bar charts and column charts

The charts that are helpful in making comparisons between categorical variables are - scatter charts and line charts. - bar charts and scatter charts. - column charts and line charts. - bar charts and column charts.

quadratic regression model

Which of the following regression models is used to model a nonlinear relationship between the independent and dependent variables by including the independent variable and the square of the independent variable in the model? - a simple regression model - a multiple regression model - quadratic regression model - a least squares regression model

PivotTables can only be used if one variable is categorical and the other is quantitative data.

Which one of the following statements is not true concerning PivotTables in Excel? - PivotTables are also known as crosstabulation tables. ​- PivotTables summarize data for two variables. - PivotTables are interactive. - PivotTables can only be used if one variable is categorical and the other is quantitative data.

training set

__________ is the data set used to build the candidate models. - Training set - Codomain - Validation set - Range

validation set

_____________ refers to the data set used to compare model forecasts and ultimately pick a model for predicting values of the dependent variable. - Range - Validation set - Codomain - Training set

interaction

_____________ refers to the scenario in which the relationship between the dependent variable and one independent variable is different at different values of a second independent variable. - Autocorrelation - Covariance - Interaction - Multicollinearity

predictive

_______________ analytics are techniques that use models, constructed from past data, to predict the future or to ascertain the impact of one variable on another. - Predictive ​- Descriptive - Simulation ​- Prescriptive

prescriptive

_______________ analytics use techniques that take input data and yield a best course of action. - Prescriptive - Simulation ​- Strategic ​- Operational

f test

________________ is used to test the hypothesis that the values of the regression parameters B1, B2, ... Bq are all zero. - An F test - Extrapolation - The least squares method - A t test