Question 1

The problem of finding the optimal values of b0 and b1 is

Accepted Answer

A)  a linear programming problem. 
B)  an unconstrained nonlinear optimization problem. 
C)  a goal programming problem. 
D)  a constrained nonlinear optimization problem. 
A)  a linear programming problem. 
B)  an unconstrained nonlinear optimization problem. 
C)  a goal programming problem. 
D)  a constrained nonlinear optimization problem.

Question 2

Exhibit 9.4
The following questions are based on the problem description and spreadsheet below.
A charitable organization wants to determine what type of people donate to charities like itself. The charity felt that a person's education (in years), annual income, ($1,000) and the number of children the person had were important variables to consider. The charity developed regression models for all of the possible combinations of these three variables but does not know what to do with the results.  
-Refer to Exhibit 9.4. Based on the data in the table which is the best model for the charity to use? Explain which values you used to reach your conclusion.

Accepted Answer

Education and Kids h

Question 3

The objective function in regression analysis is

Accepted Answer

A)    
B)    
C)    
D)    
A)    
B)    
C)    
D)

Question 4

Polynomial regression is used when

Accepted Answer

A)  the independent variables are non-linear. 
B)  there is a non-linear relationship between the dependent and independent variables. 
C)  there is a non-linear relationship between the independent variables. 
D)  there is a curvilinear change in the dependent variables. 
A)  the independent variables are non-linear. 
B)  there is a non-linear relationship between the dependent and independent variables. 
C)  there is a non-linear relationship between the independent variables. 
D)  there is a curvilinear change in the dependent variables.

Question 5

The company would like to build a prediction interval on the time for a new batch of 8 parts. What formula should be entered in cells B17:F21 of the following spreadsheet to compute this prediction interval? Partial results of the Regression analysis of the data are provided below.

Accepted Answer

The answer of The company would like to build a...

Question 6

Exhibit 9.3
The following questions are based on the problem description and spreadsheet below.
A researcher is interested in determining how many calories young men consume. She measured the age of the individuals and recorded how much food they ate each day for a month. The average daily consumption was recorded as the dependent variable. She has developed the following Excel spreadsheet of the results.  
-Refer to Exhibit 9.3. What is the estimated regression function for this problem? Explain what the terms in your equation mean

Accepted Answer

@#IMG-DLM& The average calories consumed decreases

Question 7

Exhibit 9.2
The following questions are based on the problem description and spreadsheet below.
A paint manufacturer is interested in knowing how much pressure (in pounds per square inch, PSI) builds up inside aerosol cans at various temperatures (degrees Fahrenheit). It has developed the following Excel spreadsheet of the results.  
-Refer to Exhibit 9.2. Interpret the meaning of the "Lower 95%" and "Upper 95%" terms in cells F16:G16 of the spreadsheet.

Accepted Answer

We are 95%

Question 8

Which of the following represents a regression model?

Accepted Answer

A)    
B)    
C)  Y = f(X1, X2, ..., Xk) 
D)  Y = f(X1, X2, ..., Xk) + ε 
A)    
B)    
C)  Y = f(X1, X2, ..., Xk) 
D)  Y = f(X1, X2, ..., Xk) + ε

Question 9

What is the correct range for R2 values?

Accepted Answer

A)  (−1 ≤ R2 ≤ 0) 
B)  (−1 ≤ R2 ≤ 1) 
C)  (0 ≤ R2 ≤ 1) 
D)  (0 ≤ R2 ≤ .5) 
A)  (−1 ≤ R2 ≤ 0) 
B)  (−1 ≤ R2 ≤ 1) 
C)  (0 ≤ R2 ≤ 1) 
D)  (0 ≤ R2 ≤ .5)

Question 10

Exhibit 9.5
The following questions are based on the description and spreadsheet below.
An analyst has identified 3 independent variables (XS1U1B11S1U1B0, XS1U1B12S1U1B0,XS1U1B13S1U1B0) which might be used to predict Y. He has computed the regression equations using all of the variables and the results are summarized in the following table.  
-Refer to Exhibit 9.5. Predict the mean value based on (X1, X2, X3) = (3, 32, 50). Use the best predictive model based on data from the table.

Accepted Answer

Question 11

A pattern resulting from random variation or unexplained causes is called

Accepted Answer

A)  noise 
B)  trend 
C)  seasonality 
D)  time series 
A)  noise 
B)  trend 
C)  seasonality 
D)  time series

Question 12

What is the formula for total sum of squares (TSS)

Accepted Answer

A)    
B)    
C)    
D)    
A)    
B)    
C)    
D)

Question 13

When using the Regression tool in Excel the independent variable is entered as the

Accepted Answer

A)  X-range. 
B)  Y-range. 
C)  dependent-range. 
D)  independent-range. 
A)  X-range. 
B)  Y-range. 
C)  dependent-range. 
D)  independent-range.

Question 14

Exhibit 9.2
The following questions are based on the problem description and spreadsheet below.
A paint manufacturer is interested in knowing how much pressure (in pounds per square inch, PSI) builds up inside aerosol cans at various temperatures (degrees Fahrenheit). It has developed the following Excel spreadsheet of the results.  
-Refer to Exhibit 9.2. What is the estimated regression function for this problem? Explain what the terms in your equation mean.

Accepted Answer

@#IMG-DLM& The average pressure in a can

Question 15

Exhibit 9.1
The following questions are based on the problem description and spreadsheet below.
A company has built a regression model to predict the number of labor hours (YS1U1B1iS1U1B0) required to process a batch of parts (XS1U1B1iS1U1B0). It has developed the following Excel spreadsheet of the results.  
-Refer to Exhibit 9.1. What is the estimated regression function for this problem? Explain what the terms in your equation mean.

Accepted Answer

@#IMG-DLM& The average labor hours for a

Question 16

Exhibit 9.1
The following questions are based on the problem description and spreadsheet below.
A company has built a regression model to predict the number of labor hours (YS1U1B1iS1U1B0) required to process a batch of parts (XS1U1B1iS1U1B0). It has developed the following Excel spreadsheet of the results.  
-Refer to Exhibit 9.1. Provide a rough 95% confidence interval on the number of labor hours for a batch of 5 parts.

Accepted Answer

The answer of Exhibit 9.1
The following questions are based on...

Question 17

Exhibit 9.1
The following questions are based on the problem description and spreadsheet below.
A company has built a regression model to predict the number of labor hours (YS1U1B1iS1U1B0) required to process a batch of parts (XS1U1B1iS1U1B0). It has developed the following Excel spreadsheet of the results.  
-Refer to Exhibit 9.1. Test the significance of the model and explain which values you used to reach your conclusions.

Accepted Answer

The regression model is signif

Question 18

What goodness-of-fit measure is commonly used to evaluate a multiple regression function?

Accepted Answer

A)  R2 
B)  adjusted R2 
C)  partial R2 
D)  total R2 
A)  R2 
B)  adjusted R2 
C)  partial R2 
D)  total R2

Question 19

The regression line denotes the ____ between the dependent and independent variables.

Accepted Answer

A)  unsystematic variation 
B)  systematic variation 
C)  random variation 
D)  average variation 
A)  unsystematic variation 
B)  systematic variation 
C)  random variation 
D)  average variation

Question 20

In the equation Y = β0 + β1 X1i + ε, β1 is

Accepted Answer

A)  the Y intercept 
B)  the slope of the regression line 
C)  the mean of the dependent data. 
D)  the X intercept 
A)  the Y intercept 
B)  the slope of the regression line 
C)  the mean of the dependent data. 
D)  the X intercept

The problem of finding the optimal values of b₀ and b₁ is

The objective function in regression analysis is

Polynomial regression is used when

The company would like to build a prediction interval on the time for a new batch of 8 parts. What formula should be entered in cells B17:F21 of the following spreadsheet to compute this prediction interval? Partial results of the Regression analysis of the data are provided below.

Which of the following represents a regression model?

What is the correct range for R² values?

A pattern resulting from random variation or unexplained causes is called

What is the formula for total sum of squares (TSS)

When using the Regression tool in Excel the independent variable is entered as the

What goodness-of-fit measure is commonly used to evaluate a multiple regression function?

The regression line denotes the ____ between the dependent and independent variables.

In the equation Y = β₀ + β₁ X_1i + ε, β₁ is

Introduction to Modeling and Decision Analysis

Introduction to Optimization and Linear Programming

Modeling and Solving Lp Problems in a Spreadsheet

Sensitivity Analysis and the Simplex Method

Network Modeling

Integer Linear Programming

Goal Programming and Multiple Objective Optimization

Nonlinear Programming Evolutionary Optimization

Data Mining

Time Series Forecasting

Introduction to Simulation Using Analytic Solver Platform

Queuing Theory

Decision Analysis

Project Management Online

Filters

Exam 9: Regression Analysis

The problem of finding the optimal values of b0 and b1 is

The objective function in regression analysis is

Polynomial regression is used when

The company would like to build a prediction interval on the time for a new batch of 8 parts. What formula should be entered in cells B17:F21 of the following spreadsheet to compute this prediction interval? Partial results of the Regression analysis of the data are provided below.

Which of the following represents a regression model?

What is the correct range for R2 values?

A pattern resulting from random variation or unexplained causes is called

What is the formula for total sum of squares (TSS)

When using the Regression tool in Excel the independent variable is entered as the

What goodness-of-fit measure is commonly used to evaluate a multiple regression function?

The regression line denotes the ____ between the dependent and independent variables.

In the equation Y = β0 + β1 X1i + ε, β1 is

Introduction to Modeling and Decision Analysis

Introduction to Optimization and Linear Programming

Modeling and Solving Lp Problems in a Spreadsheet

Sensitivity Analysis and the Simplex Method

Network Modeling

Integer Linear Programming

Goal Programming and Multiple Objective Optimization

Nonlinear Programming Evolutionary Optimization

Data Mining

Time Series Forecasting

Introduction to Simulation Using Analytic Solver Platform

Queuing Theory

Decision Analysis

Project Management Online

Filters

The problem of finding the optimal values of b₀ and b₁ is

What is the correct range for R² values?

In the equation Y = β₀ + β₁ X_1i + ε, β₁ is