BADM 308

_____ refers to the use of sample data to calculate a range of values that is believed to include the unknown value of a population parameter.

Interval estimation

Which of the following is NOT a problem with using a pie chart to display these data?

It provides general information at a glance

A crosstabulation in Excel is called a

Pivot Table

Which of the following methods would NOT improve the readability of the table shown below?

Put the numerical values in italic font.

is a statistical procedure used to develop an equation showing how two variables are related

Regression analysis

Suppose an estimated regression equation has a coefficient of determination (r2) of 0.866. Interpret this value.

The estimated regression equation explains approximately 86.6% of the variation in the dependent variable

Interpret the coefficient of determination for this regression model.

This regression model explains approximately 95.5% of the variation in cars sold for our sample data

A bubble chart is a graphical presentation that

has two axes that represent two variables, and the magnitude of the third variable is given by the size of the bubble

The process of making conjecture about the value of a population parameter, collecting sample data that can be used to assess this conjecture, measuring the strength of the evidence against the conjecture that is provided by the sample, and using these results to draw a conclusion about the conjecture is known as

hypothesis testing

The study of how a dependent variable y is related to two or more independent variables is called

multiple linear regression.

The difference between the observed value of the dependent variable and the value predicted using the estimated regression equation is known as the

residual

A PivotChart

s a graphical presentation created in Excel that functions similar to a PivotTable

A _____ is used to visualize sample data graphically and to draw preliminary conclusions about the possible relationship between the variables.

scatter chart

To better understand the relationship between advertising dollars spent and the subsequent sales, I could create a ________________ chart.

scatter chart

Regression analysis involving one independent variable and one dependent variable is referred to as

simple linear regression

In the simple linear regression equation, the parameter is the _______ of the true regression line.

slope

Which of the following can be used to show overall trend?

sparklines

In the simple linear regression model, the ________ accounts for the variability in the dependent variable that cannot be explained by the linear relationship between x and y.

error term

The term in the multiple regression model that accounts for the variability in y that cannot be explained by the linear effect of the q independent variables is the

error term

The _____ is the range of values of the independent variables in the data used to estimate the regression model.

experimental region

Simple linear regression refers to the type of regression analysis for which the relationship between the independent variable and dependent variable are approximated by a(n)

exponential curve

Prediction of the value of the dependent variable outside the experimental region is called

extrapolation

The process of making estimates and drawing conclusions about one or more characteristics of a population through analysis of sample data drawn from the population is known as

statistical inference.

When determining the best estimated regression equation to model a set of data, the procedure that uses an iterative variable selection procedure that considers adding an independent variable and removing an independent variable at each step is called

stepwise selection

The _____ is a measure of the error that results from using the estimated regression equation to predict the values of the dependent variable in a sample.

sum of squares due to error (SSE)

The procedure of using sample data to find the estimated regression equation is better known as

the least squares method.

If a residual plot of x verses the residuals, , shows a non-linear pattern then we should conclude that

the regression model is not an adequate representation of the relationship between the variables.

The tests of significance in regression analysis are based on assumptions about the error term ε. One such assumption is that the variance of ε, denoted by σ 2 , is

the same for all values of x

Increasing the "white space" in a table by removing unnecessary lines increases all of the following except

the table's size

The graph of the simple linear regression equation is a(n

line

DJ needs to display data over time. Which of the following charts should DJ use?

line chart

The following regression model has been proposed to predict sales at a gas station where x1 = their previous day's sales (in $1,000's), x2 = population within 5 miles (in 1,000's), x3 = 1 if any form of advertising was used, 0 if otherwise, and sales (in $1,000's). Predict sales (in dollars) for a store with competitor's previous day's sale of $3,000, a population of 10,000 within 5 miles, and twenty radio advertisements.

$86,000 y=(10)-4(3)+7(10)+8(1)

The tests of significance in regression analysis are based on assumptions about the error term ε. One such assumption is that the error term ε is a random variable with a mean or expected value of

0

In a regression analysis if SSE = 200 and SSR = 300, then the coefficient of determination is

0.6 300/(200 + 300) = 0.6.

What would be the coefficient of determination if the total sum of squares (SST) is 30 and the sum of squares due to regression (SSR) is 27?

0.90 27/30 = 0.9

What would be the value of the sum of squares due to regression (SSR) if the total sum of squares (SST) is 22.21 and the sum of squares due to error (SSE) is 6.89?

15.32 22.21-6.89

Which of the following would improve the layout and display of this line chart?

Add a title to the chart.

Geographic Information System (GIS)

merges maps and statistics to present data collected over different geographies

Based upon the p-values for "Month" and "Month Squared", what can we conclude about the current model?

Because both p-values are substantially less than 0.05, we can conclude that adding Months Squared to the model involving Months is significant

The mathematical equation relating the expected value of the dependent variable to the value of the independent variables, which has the form of is called

a multiple regression model.

Edward Tufte introduced the idea of the data-ink ratio, as a way of quantifying the proportion of "data-ink" to the total amount of ink used in a table or chart. Which of the following options would increase the data-ink ratio of a table?

adding a title to the table

The multiple regression equation based on the sample data, which has the form is called

an estimated multiple regression equation

Suppose a residual plot of x verses the residuals, , shows a nonconstant variance. In particular, as the values of x increase, suppose that the value of the residuals also increase. This means that

as the values of x get larger, the ability to predict y becomes less accurate

A tabular summary of data for two variables is referred to as a

crosstabulation

Of the options below, which graphical display can be used to compare categorical data?

bar chart

The KPIs displayed in a data dashboard should do all of the following except

be displayed across multiple screens

Which of the following options guarantees that the best model for a given number of variables will be found?

best subsets regression.

Which of the following options is NOT an iterative variable selection procedure?

best subsets regression.

Natalie needs to compare values across different categories. Which of the following charts should Natalie use?

column (bar) chart

When we use the estimated regression equation to develop an interval that can be used to predict the mean for ALL units that meet a particular set of given criteria, that interval is called a

confidence interval

A variable used to model the effect of categorical independent variables is called a

dummy variable.

Two variables have a positive linear correlation. As the dependent variable increases, the independent variable will

increases

The tests of significance in regression analysis are based on assumptions about the error term ε. One such assumption is that the values of ε are

independent.

A PivotTable

is a crosstabulation created in Excel that is interactive.

A Key Performance Indicator (KPI)

is a metric that is crucial for understanding the current performance of an organization

A heat map

is a two-dimensional graphical presentation of data in which color shadings indicate magnitudes

The coefficient of determination

is defined as SSR/SST

The tests of significance in regression analysis are based on assumptions about the error term ε. One such assumption is that the error term ε follows a ________ distribution for all values of x.

normal

When there are many independent variables to consider, special procedures are sometimes employed to select the independent variables to include in the regression model. All of the following are examples of variable selection procedures except for

overfitting

A graphical presentation used to examine more than two variables in which each variable is represented by a different vertical axis is called a

parallel coordinates plot

A(n) ________ refers to a measurable factor that defines a characteristic of a population, process, or system.

parameter

When we use the estimated regression equation to develop an interval that can be used to predict the mean for a specific unit that meets a particular set of given criteria, that interval is called a

prediction interval.

What type of regression model should be used when there is a nonlinear relationship between the independent and dependent variables which is fit by including the independent variable and the square of the independent variable?

quadratic regression model

Which of the following types of graphs is useful for visualizing hierarchical data along multiple dimensions?

treemap

An approximation of the linear relationship between variables in a chart can be represented with a

trendline.

A Dashboard is a visualization tool that

updates in real time and gives multiple outputs.

A bar chart is a graphical presentation that

uses horizontal bars to display the magnitude of quantitative data

In the simple linear regression equation, the parameter represents the _____ of the true regression line.

y-intercept

When the mean value of the response variable is independent of variation in the predictor variable, the slope of the regression line is

zero.