Deck 9: Regression Analysis

ملء الشاشة (f)
exit full mode
سؤال
The regression residuals are computed as


A) Y^iYi\hat { Y } _ { i } - Y _ { i }
B) Y~iYi)2\left. \tilde { \mathrm { Y } } _ { \mathrm { i } } - \mathrm { Y } _ { \mathrm { i } } \right) ^ { 2 }
C) YiY^iY _ { i } - \hat { Y } _ { i }
D) Y^iXi\hat { \mathrm { Y } } _ { \mathrm { i } } - \mathrm { X } _ { \mathrm { i } }
استخدم زر المسافة أو
up arrow
down arrow
لقلب البطاقة.
سؤال
The terms b0 and b1 are

A)estimated population parameters.
B)estimated intercept and slope values,respectively.
C)random variables.
D)all of these.
سؤال
The regression line denotes the between the dependent and independent variables.

A)unsystematic variation
B)systematic variation
C)random variation
D)average variation
سؤال
The reason an analyst creates a regression model is

A)to determine the errors in the data collected.
B)to predict a dependent variable value given specific independent variable values.
C)to predict an independent variable value given specific dependent variable values.
D)to verify the errors are normally distributed.
سؤال
The error sum of squares term is used as a criterion for determining b0 and b1 because

A)the sum of errors will always equal zero.
B)the term can be solved for exact values of b0 and b1.
C)both b0 and b1 can be easily calculated using the sum of squares term.
D)all of these.
سؤال
Estimation errors are often referred to as

A)mistakes.
B)constant errors.
C)residuals.
D)squared errors.
سؤال
The regression function indicates the

A)average value the dependent variable assumes for a given value of the independent variable.
B)actual value the independent variable assumes for a given value of the dependent variable
C)average value the dependent variable assumes for a given value of the dependent variable
D)actual value the dependent variable assumes for a given value of the independent variable
سؤال
On average,the differences between the actual and predicted values of Y

A)are equal to b0.
B)sum to an unknown value.
C)are distributed uniformly.
D)sum to zero.
سؤال
The β1 term indicates

A)the average change in Y for a unit change in X.
B)the Y value for a given value of X.
C)the change in observed X for a given change in Y.
D)the Y value when X equals zero.
سؤال
The error term ε in a regression model represents

A)a random error in the data.
B)unsystematic variation in the dependent variable.
C)variation not explained by the independent variables.
D)all of these.
سؤال
In the equation Y = β0 + β1 X1i + ε,β1 is

A)the Y intercept
B)the slope of the regression line
C)the mean of the dependent data.
D)the X intercept
سؤال
The terms b0 and b1 are referred to as

A)population variables.
B)population parameters.
C)estimated population variables.
D)estimated population parameters.
سؤال
The term ε in the regression model represents

A)the slope of the regression model.
B)a random error term.
C)a correction for mistakes in measuring X.
D)a correction for the fact that we are taking a sample.
سؤال
In regression terms what does "best fit" mean?

A)The estimated parameters,b0 and b1,are minimized.
B)The estimated parameters,b0 and b1,are linear.
C)The error terms are as small as possible.
D)The largest error term is as small as possible.
سؤال
The problem of finding the optimal values of b0 and b1 is

A)a linear programming problem.
B)an unconstrained nonlinear optimization problem.
C)a goal programming problem.
D)a constrained nonlinear optimization problem.
سؤال
The total sum of squares TSS)is best defined as

A)the sums of squares of the dependent variables.
B)the total variation of Y around its mean.
C)the sums of squares of the predicted values.
D)the variation of Y around its mean plus the variation of Y around the predicted values.
سؤال
Regression analysis is a modeling technique

A)that assumes all data is normally distributed.
B)for analyzing the relationship between dependent and independent variables.
C)for examining linear trend data only.
D)for capturing uncertainty in predicted values of Y.
سؤال
The actual value of a dependent variable will generally differ from the regression equation estimate due to

A)unaccounted for random variation.
B)the inability of the nonlinear Solver to find optimal values.
C)not building the regression model with enough data.
D)the model R2 not equal to 1.
سؤال
The terms β0 and β1 are referred to as

A)sample statistics
B)random variables
C)population variables
D)population parameters
سؤال
Why do we create a scatter plot of the data in regression analysis?

A)To compute the error terms.
B)Because Excel calculates the function from the scatter plot.
C)To visually check for a relationship between X and Y.
D)To estimate predicted values.
سؤال
What is the correct range for R2 values?

A)−1 ≤ R2 ≤ 0)
B)−1 ≤ R2 ≤ 1)
C)0 ≤ R2 ≤ 1)
D)0 ≤ R2 ≤ .5)
سؤال
The method of least squares finds parameter values that

A)minimizes TSS.
B)minimizes RSS.
C)minimizes ESS.
D)minimizes ESS + RSS.
سؤال
An analyst has identified 3 independent variables X1,X2,X3)which might be used to predict Y.He has computed the regression equations using all combinations of the variables and the results are summarized in the following table.Which combination of variables provides the best regression results?
<strong>An analyst has identified 3 independent variables X<sub>1</sub>,X<sub>2</sub>,X<sub>3</sub>)which might be used to predict Y.He has computed the regression equations using all combinations of the variables and the results are summarized in the following table.Which combination of variables provides the best regression results?  </strong> A)X<sub>1</sub> B)X<sub>1</sub>,X<sub>2</sub><sub> </sub>and X<sub>3</sub> C)X<sub>1</sub><sub> </sub>and X<sub>2</sub> D)X<sub>2</sub><sub> </sub>and X<sub>3</sub> <div style=padding-top: 35px>

A)X1
B)X1,X2 and X3
C)X1 and X2
D)X2 and X3
سؤال
The standard prediction error is

A)always smaller than the standard error.
B)used to construct confidence intervals for predicted values.
C)measures the variability in the predicted values.
D)all of these.
سؤال
What is a clear indicator of non-constant variance in a plot of regression model residuals?

A)A non-linear trend in the residual plot.
B)An intercept standard error larger that the estimated intercept coefficient.
C)A funnel shaped trend in the residual plot.
D)The standard errors from each independent variable differ.
سؤال
The standard error measures the

A)variability in the X values.
B)variability in the actual data around the fitted regression function.
C)variability in the independent variable around the fitted regression function.
D)variability in the dependent variable around the fitted regression function.
سؤال
When using the Regression tool in Excel the dependent variable is entered as the

A)X-range.
B)Y-range.
C)dependent-range.
D)independent-range.
سؤال
Based on the following regression output,what proportion of the total variation in Y is explained by X?
<strong>Based on the following regression output,what proportion of the total variation in Y is explained by X?  </strong> A)0.917214 B)0.841282 C)0.821442 D)9.385572 <div style=padding-top: 35px>

A)0.917214
B)0.841282
C)0.821442
D)9.385572
سؤال
Based on the following regression output,what conclusion can you reach about β1?
<strong>Based on the following regression output,what conclusion can you reach about β<sub>1</sub>?  </strong> A)β<sub>1</sub><sub> </sub>= 0,with P-value = 0.016353 B)β<sub>1</sub><sub> </sub>≠ 0,with P-value =0.016353 C)β<sub>1</sub><sub> </sub>= 0,with P-value = 0.000186 D)β<sub>1</sub><sub> </sub>≠ 0,with P-value =0.000186 <div style=padding-top: 35px>

A)β1 = 0,with P-value = 0.016353
B)β1 ≠ 0,with P-value =0.016353
C)β1 = 0,with P-value = 0.000186
D)β1 ≠ 0,with P-value =0.000186
سؤال
R2 is also referred to as

A)coefficient of determination.
B)correlation coefficient.
C)total sum of squares.
D)regression sum of squares.
سؤال
What goodness-of-fit measure is commonly used to evaluate a multiple regression function?

A)R2
B)adjusted R2
C)partial R2
D)total R2
سؤال
Based on the following regression output,what conclusion can you reach about ?0?
 <strong>Based on the following regression output,what conclusion can you reach about ?<sub>0</sub>?   </strong> A) \beta _ { 0 } = 0 , \text { with P-value } = 0.016353  B) B_{0} \neq 0 \text {, with } P \text {-value }=0.016353   C) \beta _ { 0 } = 0 , \text { with p-value } = 0.000186  D) \text { B }_0 \neq 0 \text {. with p-value } = 0.000186  <div style=padding-top: 35px>

A) β0=0, with P-value =0.016353\beta _ { 0 } = 0 , \text { with P-value } = 0.016353
B) B00, with P-value =0.016353B_{0} \neq 0 \text {, with } P \text {-value }=0.016353

C) β0=0, with p-value =0.000186\beta _ { 0 } = 0 , \text { with p-value } = 0.000186
D)  B 00. with p-value =0.000186\text { B }_0 \neq 0 \text {. with p-value } = 0.000186
سؤال
An analyst has identified 3 independent variables X1,X2,X3)which might be used to predict Y.He has computed the regression equations using all combinations of the variables and the results are summarized in the following table.Why is the R2 value for the X3 model the same as the R2 value for the X1 and X3 model,but the Adjusted R2 values differ?
<strong>An analyst has identified 3 independent variables X<sub>1</sub>,X<sub>2</sub>,X<sub>3</sub>)which might be used to predict Y.He has computed the regression equations using all combinations of the variables and the results are summarized in the following table.Why is the R<sup>2</sup><sup> </sup>value for the X<sub>3</sub><sub> </sub>model the same as the R<sup>2</sup><sup> </sup>value for the X<sub>1</sub><sub> </sub>and X<sub>3</sub><sub> </sub>model,but the Adjusted R<sup>2</sup><sup> </sup>values differ?  </strong> A)The standard error for X<sub>1</sub><sub> </sub>is greater than the standard error for X<sub>3</sub>. B)X<sub>1</sub><sub> </sub>does not reduce ESS enough to compensate for its addition to the model. C)X<sub>1</sub><sub> </sub>does not reduce TSS enough to compensate for its addition to the model. D)X<sub>1</sub><sub> </sub>and X<sub>3</sub><sub> </sub>represent similar factors so multicollinearity exists. <div style=padding-top: 35px>

A)The standard error for X1 is greater than the standard error for X3.
B)X1 does not reduce ESS enough to compensate for its addition to the model.
C)X1 does not reduce TSS enough to compensate for its addition to the model.
D)X1 and X3 represent similar factors so multicollinearity exists.
سؤال
A variable which takes on m discrete values would be modeled using

A)m − 1)binary variables.
B)m binary variables.
C)m − 1)integer variables.
D)m non-linear variables.
سؤال
Polynomial regression is used when

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.
سؤال
The R2 statistic

A)varies between −1 and 1.
B)compares the regression sum of squares to the total sum of squares.
C)accounts for the number of parameters in the regression model.
D)is the ratio of the error sum of squares to the regression sum of squares.
سؤال
When using the Regression tool in Excel the independent variable is entered as the

A)X-range.
B)Y-range.
C)dependent-range.
D)independent-range.
سؤال
Residuals are assumed to be

A)dependent,uniformly distributed random variables.
B)independent,uniformly distributed random variables.
C)dependent,normally distributed random variables.
D)independent,normally distributed random variables.
سؤال
Which of the following is an advantage of using the TREND)function versus the regression tool?

A)The TREND)function provides more statistical information.
B)The TREND)function handles multiple dependent variable data.
C)The TREND)function is dynamically updated when input to the function changes.
D)The TREND)function does not use a least squares regression line.
سؤال
R2 is calculated as

A)ESS/TSS
B)1 − RSS/TSS)
C)RSS/ESS
D)RSS/TSS
سؤال
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.
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.Test the significance of the model and explain which values you used to reach your conclusions.<div style=padding-top: 35px>
Refer to Exhibit 9.3.Test the significance of the model and explain which values you used to reach your conclusions.
سؤال
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.
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.<div style=padding-top: 35px>
Refer to Exhibit 9.2.Interpret the meaning of the "Lower 95%" and "Upper 95%" terms in cells F16:G16 of the spreadsheet.
سؤال
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 Yi)required to process a batch of parts Xi).It has developed the following Excel spreadsheet of the results.
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 Y<sub>i</sub>)required to process a batch of parts X<sub>i</sub>).It has developed the following Excel spreadsheet of the results.    -Refer to Exhibit 9.1.Predict the mean number of labor hours for a batch of 5 parts.<div style=padding-top: 35px>

-Refer to Exhibit 9.1.Predict the mean number of labor hours for a batch of 5 parts.
سؤال
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 Yi)required to process a batch of parts Xi).It has developed the following Excel spreadsheet of the results.
 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 Y<sub>i</sub>)required to process a batch of parts X<sub>i</sub>).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.  \widehat { \mathrm { Y } } _ { \mathrm { i } } = 4.8400 + 1.4836 \mathrm { X } _ { \mathrm { li } } <div style=padding-top: 35px>

-Refer to Exhibit 9.1.What is the estimated regression function for this problem? Explain what the terms in your equation mean.
Y^i=4.8400+1.4836Xli\widehat { \mathrm { Y } } _ { \mathrm { i } } = 4.8400 + 1.4836 \mathrm { X } _ { \mathrm { li } }
سؤال
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.
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.Interpret the meaning of R square in cell B3 of the spreadsheet.<div style=padding-top: 35px>
Refer to Exhibit 9.3.Interpret the meaning of R square in cell B3 of the spreadsheet.
سؤال
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.
 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.  \widehat { \mathrm { Y } } _ { \mathrm { i } } = 38.1923 + 1.2447 \mathrm { X } _ { \mathrm { l i} } <div style=padding-top: 35px>

-Refer to Exhibit 9.2.What is the estimated regression function for this problem? Explain what the terms in your equation mean.
Y^i=38.1923+1.2447Xli\widehat { \mathrm { Y } } _ { \mathrm { i } } = 38.1923 + 1.2447 \mathrm { X } _ { \mathrm { l i} }
سؤال
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 Yi)required to process a batch of parts Xi).It has developed the following Excel spreadsheet of the results.
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 Y<sub>i</sub>)required to process a batch of parts X<sub>i</sub>).It has developed the following Excel spreadsheet of the results.   Refer to Exhibit 9.1.Interpret the meaning of the Lower 95% and Upper 95% terms in cells F16:G16 of the spreadsheet.<div style=padding-top: 35px>
Refer to Exhibit 9.1.Interpret the meaning of the "Lower 95%" and "Upper 95%" terms in cells F16:G16 of the spreadsheet.
سؤال
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.
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.Test the significance of the model and explain which values you used to reach your conclusions.<div style=padding-top: 35px>
Refer to Exhibit 9.2.Test the significance of the model and explain which values you used to reach your conclusions.
سؤال
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.
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 R Square in cell B3 of the spreadsheet.<div style=padding-top: 35px>
Refer to Exhibit 9.2.Interpret the meaning of R Square in cell B3 of the spreadsheet.
سؤال
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 Yi)required to process a batch of parts Xi).It has developed the following Excel spreadsheet of the results.
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 Y<sub>i</sub>)required to process a batch of parts X<sub>i</sub>).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.<div style=padding-top: 35px>

-Refer to Exhibit 9.1.Provide a rough 95% confidence interval on the number of labor hours for a batch of 5 parts.
سؤال
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.
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.Predict the mean pressure for a temperature of 120 degrees.<div style=padding-top: 35px>

-Refer to Exhibit 9.2.Predict the mean pressure for a temperature of 120 degrees.
سؤال
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.
 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  \widehat { \mathrm { Y } } _ { \mathrm { i } } = 3995.991 - 54.2303 \mathrm { X } _ { \mathrm { li } } <div style=padding-top: 35px>

-Refer to Exhibit 9.3.What is the estimated regression function for this problem? Explain what the terms in your equation mean
Y^i=3995.99154.2303Xli\widehat { \mathrm { Y } } _ { \mathrm { i } } = 3995.991 - 54.2303 \mathrm { X } _ { \mathrm { li } }
سؤال
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 Yi)required to process a batch of parts Xi).It has developed the following Excel spreadsheet of the results.
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 Y<sub>i</sub>)required to process a batch of parts X<sub>i</sub>).It has developed the following Excel spreadsheet of the results.   Refer to Exhibit 9.1.Interpret the meaning of R Square in cell B3 of the spreadsheet.<div style=padding-top: 35px>
Refer to Exhibit 9.1.Interpret the meaning of R Square in cell B3 of the spreadsheet.
سؤال
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.
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.Interpret the meaning of the Lower 95% and Upper 95% terms in cells F16:G16 of the spreadsheet.<div style=padding-top: 35px>
Refer to Exhibit 9.3.Interpret the meaning of the "Lower 95%" and "Upper 95%" terms in cells F16:G16 of the spreadsheet.
سؤال
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.
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.   <div style=padding-top: 35px>
سؤال
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 Yi)required to process a batch of parts Xi).It has developed the following Excel spreadsheet of the results.
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 Y<sub>i</sub>)required to process a batch of parts X<sub>i</sub>).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.<div style=padding-top: 35px>
Refer to Exhibit 9.1.Test the significance of the model and explain which values you used to reach your conclusions.
سؤال
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.
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.Predict the mean number of calories consumed by a 19 year old man.<div style=padding-top: 35px>

-Refer to Exhibit 9.3.Predict the mean number of calories consumed by a 19 year old man.
سؤال
The researcher would like to build a prediction interval on the calories consumed by an 18 year old man.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.
The researcher would like to build a prediction interval on the calories consumed by an 18 year old man.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.   <div style=padding-top: 35px>
سؤال
The company would like to build a prediction interval on the pressure for a can with a temperature of 125 degrees.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.
The company would like to build a prediction interval on the pressure for a can with a temperature of 125 degrees.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.   <div style=padding-top: 35px>
سؤال
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.
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.<div style=padding-top: 35px>
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.
سؤال
Exhibit 9.7
The partial regression output below applies to the following questions.
Exhibit 9.7 The partial regression output below applies to the following questions.   Refer to Exhibit 9.7.What is the SS for Total?<div style=padding-top: 35px>
Refer to Exhibit 9.7.What is the SS for Total?
سؤال
Exhibit 9.6
The partial regression output below applies to the following questions.
Exhibit 9.6 The partial regression output below applies to the following questions.   Refer to Exhibit 9.6.What is the F-statistic value?<div style=padding-top: 35px>
Refer to Exhibit 9.6.What is the F-statistic value?
سؤال
The forecasting model that makes use of the least squares method is called

A)regression
B)naive approach
C)moving average
D)exponential smoothing
سؤال
Exhibit 9.5
The following questions are based on the description and spreadsheet below.
An analyst has identified 3 independent variables X1,X2,X3)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.
 Independent  Variable Adjusted  the R2R2 Se Parameter Estimates X10.000890.124023.548 b0=93.7174, b1=0.922X20.387000.310418.448 b0=57.0803, b2=1.545X1 and X20.391000.217019.654 b0=50.2927, b1=1.952, b2=1.554X30.841300.82149.3858 b0=31.6238, b3=1.132X1 and X30.841300.796010.033 b0=31.133, b1=0.148, b3=1.132X2 and X30.986300.98242.948 b0=14.169, b2=0.985, b3=0.995X1,X2 and X30.987100.98073.085 b0=11.113, b1=0.899, b2=0.990, b\begin{array}{lrrrl}\text { Independent }\\\text { Variable}& \text { Adjusted }\\\text { the } & \mathrm{R}^{2} & -\mathrm{R}^{2} & \mathrm{~S}_{\mathrm{e}} & \text { Parameter Estimates }\\\hline\mathrm{X}_{1} & 0.00089 & -0.1240 & 23.548 & \mathrm{~b}_{0}=93.7174, \mathrm{~b}_{1}=0.922 \\\mathrm{X}_{2} & 0.38700 & 0.3104 & 18.448 & \mathrm{~b}_{0}=57.0803, \mathrm{~b}_{2}=1.545 \\\mathrm{X}_{1} \text { and } \mathrm{X}_{2} & 0.39100 & 0.2170 & 19.654 & \mathrm{~b}_{0}=50.2927, \mathrm{~b}_{1}=1.952, \mathrm{~b}_{2}=1.554 \\\mathrm{X}_{3} & 0.84130 & 0.8214 & 9.3858 & \mathrm{~b}_{0}=31.6238, \mathrm{~b}_{3}=1.132 \\\mathrm{X}_{1} \text { and } \mathrm{X}_{3} & 0.84130 & 0.7960 & 10.033 & \mathrm{~b}_{0}=31.133, \mathrm{~b}_{1}=0.148, \mathrm{~b}_{3}=1.132 \\\mathrm{X}_{2} \text { and } \mathrm{X}_{3} & 0.98630 & 0.9824 & 2.948 & \mathrm{~b}_{0}=14.169, \mathrm{~b}_{2}=0.985, \mathrm{~b}_{3}=0.995 \\\mathrm{X}_{1}, \mathrm{X}_{2} \text { and } \mathrm{X}_{3} & 0.98710 & 0.9807 & 3.085 & \mathrm{~b}_{0}=11.113, \mathrm{~b}_{1}=0.899, \mathrm{~b}_{2}=0.990, \mathrm{~b}\end{array}


-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.
سؤال
A pattern resulting from random variation or unexplained causes is called

A)noise
B)trend
C)seasonality
D)time series
سؤال
In regression analysis,the total variation is:

A)the sum of the squared deviations of each value of y from the mean of x
B)the sum of the explained variation and unexplained variation
C)the standard error of the forecast
D)equal to R2
سؤال
A persistent upward or downward movement of data is called

A)trend
B)seasonality
C)irregular variation
D)dampening signal
سؤال
Exhibit 9.7
The partial regression output below applies to the following questions.
Exhibit 9.7 The partial regression output below applies to the following questions.   Refer to Exhibit 9.7.What is the SS for Residual and MS for Residual?<div style=padding-top: 35px>
Refer to Exhibit 9.7.What is the SS for Residual and MS for Residual?
سؤال
R2 measures

A)the percentage of variability in the dependent variable,Y,explained by the model
B)the unexplained variability
C)the ratio of RSS/ESS
D)the model sophistication
سؤال
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.
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.Predict the mean donation by a person with 16 years of education,$90,000 annual income and 2 children.Use a full model based on data from the table.<div style=padding-top: 35px>

-Refer to Exhibit 9.4.Predict the mean donation by a person with 16 years of education,$90,000 annual income and 2 children.Use a full model based on data from the table.
سؤال
How many independent variables are there in simple regression analysis?

A)1
B)2
C)3
D)4
سؤال
Exhibit 9.6
The partial regression output below applies to the following questions.
Exhibit 9.6 The partial regression output below applies to the following questions.   Refer to Exhibit 9.6.What is the MS for Residual?<div style=padding-top: 35px>
Refer to Exhibit 9.6.What is the MS for Residual?
سؤال
Exhibit 9.5
The following questions are based on the description and spreadsheet below.
An analyst has identified 3 independent variables X1,X2,X3)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.
 Independent  Variable Adjusted  the R2R2 Se Parameter Estimates X10.000890.124023.548 b0=93.7174, b1=0.922X20.387000.310418.448 b0=57.0803, b2=1.545X1 and X20.391000.217019.654 b0=50.2927, b1=1.952, b2=1.554X30.841300.82149.3858 b0=31.6238, b3=1.132X1 and X30.841300.796010.033 b0=31.133, b1=0.148, b3=1.132X2 and X30.986300.98242.948 b0=14.169, b2=0.985, b3=0.995X1,X2 and X30.987100.98073.085 b0=11.113, b1=0.899, b2=0.990, b\begin{array}{lrrrl}\text { Independent }\\\text { Variable}& \text { Adjusted }\\\text { the } & \mathrm{R}^{2} & -\mathrm{R}^{2} & \mathrm{~S}_{\mathrm{e}} & \text { Parameter Estimates }\\\hline\mathrm{X}_{1} & 0.00089 & -0.1240 & 23.548 & \mathrm{~b}_{0}=93.7174, \mathrm{~b}_{1}=0.922 \\\mathrm{X}_{2} & 0.38700 & 0.3104 & 18.448 & \mathrm{~b}_{0}=57.0803, \mathrm{~b}_{2}=1.545 \\\mathrm{X}_{1} \text { and } \mathrm{X}_{2} & 0.39100 & 0.2170 & 19.654 & \mathrm{~b}_{0}=50.2927, \mathrm{~b}_{1}=1.952, \mathrm{~b}_{2}=1.554 \\\mathrm{X}_{3} & 0.84130 & 0.8214 & 9.3858 & \mathrm{~b}_{0}=31.6238, \mathrm{~b}_{3}=1.132 \\\mathrm{X}_{1} \text { and } \mathrm{X}_{3} & 0.84130 & 0.7960 & 10.033 & \mathrm{~b}_{0}=31.133, \mathrm{~b}_{1}=0.148, \mathrm{~b}_{3}=1.132 \\\mathrm{X}_{2} \text { and } \mathrm{X}_{3} & 0.98630 & 0.9824 & 2.948 & \mathrm{~b}_{0}=14.169, \mathrm{~b}_{2}=0.985, \mathrm{~b}_{3}=0.995 \\\mathrm{X}_{1}, \mathrm{X}_{2} \text { and } \mathrm{X}_{3} & 0.98710 & 0.9807 & 3.085 & \mathrm{~b}_{0}=11.113, \mathrm{~b}_{1}=0.899, \mathrm{~b}_{2}=0.990, \mathrm{~b}\end{array}


-Refer to Exhibit 9.5.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.
سؤال
Project 9.1 ? Test Stand Cost Analysis Estimation
Handel Manufacturing produces test stands for various maintenance functions ranging from automobile to jet airline testing stations.For years,their cost estimating function was based on a myriad of historical data fed into a cost analysis model that produced very accurate estimates of both development and support costs for various proposed test stands.James Mudd was a recent hire into the cost analysis shop.Unfortunately,during his first week on the job,James deleted the cost analysis database and failed to maintain a backup of the model.Fortunately,all is not lost.The computer support personnel can come in Monday and retrieve the model using their system backup tapes.
Unfortunately,the cost proposals for three new test stand development and deployment projects are due first thing Monday morning.Since James recently left the company,you have been tasked to complete the cost estimate portion of the proposals.
After much gnashing of your teeth,you settle down to make the best of what you initially believe is a losing situation.While studying James' files you find historical records on 25 recent test stand development and deployment projects.Rejuvenated,you realize you can succeed in this prematurely perceived doomed situation.All you need to do is analyze this historical data,develop some cost estimating functions using regression,and then use your regression models to develop estimates for the three projects due Monday.The historical data in the files is the following.
Test Stand Product Cost Estimation
 Project 9.1 ? Test Stand Cost Analysis Estimation Handel Manufacturing produces test stands for various maintenance functions ranging from automobile to jet airline testing stations.For years,their cost estimating function was based on a myriad of historical data fed into a cost analysis model that produced very accurate estimates of both development and support costs for various proposed test stands.James Mudd was a recent hire into the cost analysis shop.Unfortunately,during his first week on the job,James deleted the cost analysis database and failed to maintain a backup of the model.Fortunately,all is not lost.The computer support personnel can come in Monday and retrieve the model using their system backup tapes. Unfortunately,the cost proposals for three new test stand development and deployment projects are due first thing Monday morning.Since James recently left the company,you have been tasked to complete the cost estimate portion of the proposals. After much gnashing of your teeth,you settle down to make the best of what you initially believe is a losing situation.While studying James' files you find historical records on 25 recent test stand development and deployment projects.Rejuvenated,you realize you can succeed in this prematurely perceived doomed situation.All you need to do is analyze this historical data,develop some cost estimating functions using regression,and then use your regression models to develop estimates for the three projects due Monday.The historical data in the files is the following. Test Stand Product Cost Estimation   The data estimates for the three cost proposal due Monday is the following: Estimates for New Lines  \begin{array}{llllllll} &\text { Lines of  } & \text {Reparable } & \text { Primary  } & \text {Deployed } & \text { Estmated  } & \text {Estmated }\\ &\text { Code } & \text {  Items } & \text { Functions  } & \text { Sites }& \text { Sales } & \text { Life } & \text { R\&M }\\ \hline1 & 5000 & 7 & 4 & 400 & 4000 & 7.5 & 0.965857 \\ 2 & 7500 & 5 & 5 & 450 & 4500 & 8.5 & 0.976311 \\ 3 & 34 n 0 & 6 & 3 & 375 & 3750 & 6 & 0.930541 \end{array}    One thing unclear from reading the files was on the form of the cost estimating relationships contained within the lost cost analysis model.You are somewhat sure the regression models were not polynomial in form,but you are not certain of this fact.You are not even sure which variables were included in the model for development cost and which variables were included in the model for support costs.However,you are undaunted because you know you can develop accurate models and produce good cost estimates for each of the proposed projects. Develop appropriate models for development and for support costs.Use these models to develop cost estimates for each of the new lines of test stands.For each of these cost estimates provide 95% confidence intervals for the predicted values.<div style=padding-top: 35px>
The data estimates for the three cost proposal due Monday is the following:
Estimates for New Lines
 Lines of Reparable  Primary Deployed  Estmated Estmated  Code  Items  Functions  Sites  Sales  Life  R&M 150007440040007.50.965857275005545045008.50.976311334n063375375060.930541\begin{array}{llllllll}&\text { Lines of } & \text {Reparable } & \text { Primary } & \text {Deployed } & \text { Estmated } & \text {Estmated }\\&\text { Code } & \text { Items } & \text { Functions } & \text { Sites }& \text { Sales } & \text { Life } & \text { R\&M }\\\hline1 & 5000 & 7 & 4 & 400 & 4000 & 7.5 & 0.965857 \\2 & 7500 & 5 & 5 & 450 & 4500 & 8.5 & 0.976311 \\3 & 34 n 0 & 6 & 3 & 375 & 3750 & 6 & 0.930541\end{array}


One thing unclear from reading the files was on the form of the cost estimating relationships contained within the lost cost analysis model.You are somewhat sure the regression models were not polynomial in form,but you are not certain of this fact.You are not even sure which variables were included in the model for development cost and which variables were included in the model for support costs.However,you are undaunted because you know you can develop accurate models and produce good cost estimates for each of the proposed projects.
Develop appropriate models for development and for support costs.Use these models to develop cost estimates for each of the new lines of test stands.For each of these cost estimates provide 95% confidence intervals for the predicted values.
سؤال
In time series regression analysis

A)the dependent variable represents time
B)the independent variable represents time
C)the sign of slope,b,is usually negative
D)the sign of slope,b,is usually positive
سؤال
Which of the following cannot be negative?

A)coefficient of determination
B)coefficient of correlation
C)coefficient of the independent variable,x,in the regression equation
D)y-intercept in the regression equation
سؤال
The adjusted R2 statistic

A)is equal to the value of unadjusted R2
B)adjusts R2 for the degrees of freedom in the multiple regression model
C)accounts for the parameters in the multiple regression model
D)is always greater than R2 unadjusted
سؤال
Assume you have chosen to use all three variables in your model.Test the significance of the model and explain which values you used to reach your conclusion.
Assume you have chosen to use all three variables in your model.Test the significance of the model and explain which values you used to reach your conclusion.  <div style=padding-top: 35px>
سؤال
How many binary variables are required to encode a person's age group as being either young,middle-age or old? What are the variables and what are the meanings of their 0,1 values?
سؤال
Which of the following best describes the relationship between cost and accuracy in forecasting?

A)low cost methods are always less accurate
B)statistical methods are more costly and more accurate
C)there is a tradeoff between cost and accuracy
D)cost should not be considered in business forecasting
فتح الحزمة
قم بالتسجيل لفتح البطاقات في هذه المجموعة!
Unlock Deck
Unlock Deck
1/82
auto play flashcards
العب
simple tutorial
ملء الشاشة (f)
exit full mode
Deck 9: Regression Analysis
1
The regression residuals are computed as


A) Y^iYi\hat { Y } _ { i } - Y _ { i }
B) Y~iYi)2\left. \tilde { \mathrm { Y } } _ { \mathrm { i } } - \mathrm { Y } _ { \mathrm { i } } \right) ^ { 2 }
C) YiY^iY _ { i } - \hat { Y } _ { i }
D) Y^iXi\hat { \mathrm { Y } } _ { \mathrm { i } } - \mathrm { X } _ { \mathrm { i } }
YiY^iY _ { i } - \hat { Y } _ { i }
2
The terms b0 and b1 are

A)estimated population parameters.
B)estimated intercept and slope values,respectively.
C)random variables.
D)all of these.
D
3
The regression line denotes the between the dependent and independent variables.

A)unsystematic variation
B)systematic variation
C)random variation
D)average variation
B
4
The reason an analyst creates a regression model is

A)to determine the errors in the data collected.
B)to predict a dependent variable value given specific independent variable values.
C)to predict an independent variable value given specific dependent variable values.
D)to verify the errors are normally distributed.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
5
The error sum of squares term is used as a criterion for determining b0 and b1 because

A)the sum of errors will always equal zero.
B)the term can be solved for exact values of b0 and b1.
C)both b0 and b1 can be easily calculated using the sum of squares term.
D)all of these.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
6
Estimation errors are often referred to as

A)mistakes.
B)constant errors.
C)residuals.
D)squared errors.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
7
The regression function indicates the

A)average value the dependent variable assumes for a given value of the independent variable.
B)actual value the independent variable assumes for a given value of the dependent variable
C)average value the dependent variable assumes for a given value of the dependent variable
D)actual value the dependent variable assumes for a given value of the independent variable
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
8
On average,the differences between the actual and predicted values of Y

A)are equal to b0.
B)sum to an unknown value.
C)are distributed uniformly.
D)sum to zero.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
9
The β1 term indicates

A)the average change in Y for a unit change in X.
B)the Y value for a given value of X.
C)the change in observed X for a given change in Y.
D)the Y value when X equals zero.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
10
The error term ε in a regression model represents

A)a random error in the data.
B)unsystematic variation in the dependent variable.
C)variation not explained by the independent variables.
D)all of these.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
11
In the equation Y = β0 + β1 X1i + ε,β1 is

A)the Y intercept
B)the slope of the regression line
C)the mean of the dependent data.
D)the X intercept
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
12
The terms b0 and b1 are referred to as

A)population variables.
B)population parameters.
C)estimated population variables.
D)estimated population parameters.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
13
The term ε in the regression model represents

A)the slope of the regression model.
B)a random error term.
C)a correction for mistakes in measuring X.
D)a correction for the fact that we are taking a sample.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
14
In regression terms what does "best fit" mean?

A)The estimated parameters,b0 and b1,are minimized.
B)The estimated parameters,b0 and b1,are linear.
C)The error terms are as small as possible.
D)The largest error term is as small as possible.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
15
The problem of finding the optimal values of b0 and b1 is

A)a linear programming problem.
B)an unconstrained nonlinear optimization problem.
C)a goal programming problem.
D)a constrained nonlinear optimization problem.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
16
The total sum of squares TSS)is best defined as

A)the sums of squares of the dependent variables.
B)the total variation of Y around its mean.
C)the sums of squares of the predicted values.
D)the variation of Y around its mean plus the variation of Y around the predicted values.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
17
Regression analysis is a modeling technique

A)that assumes all data is normally distributed.
B)for analyzing the relationship between dependent and independent variables.
C)for examining linear trend data only.
D)for capturing uncertainty in predicted values of Y.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
18
The actual value of a dependent variable will generally differ from the regression equation estimate due to

A)unaccounted for random variation.
B)the inability of the nonlinear Solver to find optimal values.
C)not building the regression model with enough data.
D)the model R2 not equal to 1.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
19
The terms β0 and β1 are referred to as

A)sample statistics
B)random variables
C)population variables
D)population parameters
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
20
Why do we create a scatter plot of the data in regression analysis?

A)To compute the error terms.
B)Because Excel calculates the function from the scatter plot.
C)To visually check for a relationship between X and Y.
D)To estimate predicted values.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
21
What is the correct range for R2 values?

A)−1 ≤ R2 ≤ 0)
B)−1 ≤ R2 ≤ 1)
C)0 ≤ R2 ≤ 1)
D)0 ≤ R2 ≤ .5)
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
22
The method of least squares finds parameter values that

A)minimizes TSS.
B)minimizes RSS.
C)minimizes ESS.
D)minimizes ESS + RSS.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
23
An analyst has identified 3 independent variables X1,X2,X3)which might be used to predict Y.He has computed the regression equations using all combinations of the variables and the results are summarized in the following table.Which combination of variables provides the best regression results?
<strong>An analyst has identified 3 independent variables X<sub>1</sub>,X<sub>2</sub>,X<sub>3</sub>)which might be used to predict Y.He has computed the regression equations using all combinations of the variables and the results are summarized in the following table.Which combination of variables provides the best regression results?  </strong> A)X<sub>1</sub> B)X<sub>1</sub>,X<sub>2</sub><sub> </sub>and X<sub>3</sub> C)X<sub>1</sub><sub> </sub>and X<sub>2</sub> D)X<sub>2</sub><sub> </sub>and X<sub>3</sub>

A)X1
B)X1,X2 and X3
C)X1 and X2
D)X2 and X3
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
24
The standard prediction error is

A)always smaller than the standard error.
B)used to construct confidence intervals for predicted values.
C)measures the variability in the predicted values.
D)all of these.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
25
What is a clear indicator of non-constant variance in a plot of regression model residuals?

A)A non-linear trend in the residual plot.
B)An intercept standard error larger that the estimated intercept coefficient.
C)A funnel shaped trend in the residual plot.
D)The standard errors from each independent variable differ.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
26
The standard error measures the

A)variability in the X values.
B)variability in the actual data around the fitted regression function.
C)variability in the independent variable around the fitted regression function.
D)variability in the dependent variable around the fitted regression function.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
27
When using the Regression tool in Excel the dependent variable is entered as the

A)X-range.
B)Y-range.
C)dependent-range.
D)independent-range.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
28
Based on the following regression output,what proportion of the total variation in Y is explained by X?
<strong>Based on the following regression output,what proportion of the total variation in Y is explained by X?  </strong> A)0.917214 B)0.841282 C)0.821442 D)9.385572

A)0.917214
B)0.841282
C)0.821442
D)9.385572
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
29
Based on the following regression output,what conclusion can you reach about β1?
<strong>Based on the following regression output,what conclusion can you reach about β<sub>1</sub>?  </strong> A)β<sub>1</sub><sub> </sub>= 0,with P-value = 0.016353 B)β<sub>1</sub><sub> </sub>≠ 0,with P-value =0.016353 C)β<sub>1</sub><sub> </sub>= 0,with P-value = 0.000186 D)β<sub>1</sub><sub> </sub>≠ 0,with P-value =0.000186

A)β1 = 0,with P-value = 0.016353
B)β1 ≠ 0,with P-value =0.016353
C)β1 = 0,with P-value = 0.000186
D)β1 ≠ 0,with P-value =0.000186
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
30
R2 is also referred to as

A)coefficient of determination.
B)correlation coefficient.
C)total sum of squares.
D)regression sum of squares.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
31
What goodness-of-fit measure is commonly used to evaluate a multiple regression function?

A)R2
B)adjusted R2
C)partial R2
D)total R2
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
32
Based on the following regression output,what conclusion can you reach about ?0?
 <strong>Based on the following regression output,what conclusion can you reach about ?<sub>0</sub>?   </strong> A) \beta _ { 0 } = 0 , \text { with P-value } = 0.016353  B) B_{0} \neq 0 \text {, with } P \text {-value }=0.016353   C) \beta _ { 0 } = 0 , \text { with p-value } = 0.000186  D) \text { B }_0 \neq 0 \text {. with p-value } = 0.000186

A) β0=0, with P-value =0.016353\beta _ { 0 } = 0 , \text { with P-value } = 0.016353
B) B00, with P-value =0.016353B_{0} \neq 0 \text {, with } P \text {-value }=0.016353

C) β0=0, with p-value =0.000186\beta _ { 0 } = 0 , \text { with p-value } = 0.000186
D)  B 00. with p-value =0.000186\text { B }_0 \neq 0 \text {. with p-value } = 0.000186
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
33
An analyst has identified 3 independent variables X1,X2,X3)which might be used to predict Y.He has computed the regression equations using all combinations of the variables and the results are summarized in the following table.Why is the R2 value for the X3 model the same as the R2 value for the X1 and X3 model,but the Adjusted R2 values differ?
<strong>An analyst has identified 3 independent variables X<sub>1</sub>,X<sub>2</sub>,X<sub>3</sub>)which might be used to predict Y.He has computed the regression equations using all combinations of the variables and the results are summarized in the following table.Why is the R<sup>2</sup><sup> </sup>value for the X<sub>3</sub><sub> </sub>model the same as the R<sup>2</sup><sup> </sup>value for the X<sub>1</sub><sub> </sub>and X<sub>3</sub><sub> </sub>model,but the Adjusted R<sup>2</sup><sup> </sup>values differ?  </strong> A)The standard error for X<sub>1</sub><sub> </sub>is greater than the standard error for X<sub>3</sub>. B)X<sub>1</sub><sub> </sub>does not reduce ESS enough to compensate for its addition to the model. C)X<sub>1</sub><sub> </sub>does not reduce TSS enough to compensate for its addition to the model. D)X<sub>1</sub><sub> </sub>and X<sub>3</sub><sub> </sub>represent similar factors so multicollinearity exists.

A)The standard error for X1 is greater than the standard error for X3.
B)X1 does not reduce ESS enough to compensate for its addition to the model.
C)X1 does not reduce TSS enough to compensate for its addition to the model.
D)X1 and X3 represent similar factors so multicollinearity exists.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
34
A variable which takes on m discrete values would be modeled using

A)m − 1)binary variables.
B)m binary variables.
C)m − 1)integer variables.
D)m non-linear variables.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
35
Polynomial regression is used when

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.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
36
The R2 statistic

A)varies between −1 and 1.
B)compares the regression sum of squares to the total sum of squares.
C)accounts for the number of parameters in the regression model.
D)is the ratio of the error sum of squares to the regression sum of squares.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
37
When using the Regression tool in Excel the independent variable is entered as the

A)X-range.
B)Y-range.
C)dependent-range.
D)independent-range.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
38
Residuals are assumed to be

A)dependent,uniformly distributed random variables.
B)independent,uniformly distributed random variables.
C)dependent,normally distributed random variables.
D)independent,normally distributed random variables.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
39
Which of the following is an advantage of using the TREND)function versus the regression tool?

A)The TREND)function provides more statistical information.
B)The TREND)function handles multiple dependent variable data.
C)The TREND)function is dynamically updated when input to the function changes.
D)The TREND)function does not use a least squares regression line.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
40
R2 is calculated as

A)ESS/TSS
B)1 − RSS/TSS)
C)RSS/ESS
D)RSS/TSS
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
41
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.
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.Test the significance of the model and explain which values you used to reach your conclusions.
Refer to Exhibit 9.3.Test the significance of the model and explain which values you used to reach your conclusions.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
42
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.
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.
Refer to Exhibit 9.2.Interpret the meaning of the "Lower 95%" and "Upper 95%" terms in cells F16:G16 of the spreadsheet.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
43
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 Yi)required to process a batch of parts Xi).It has developed the following Excel spreadsheet of the results.
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 Y<sub>i</sub>)required to process a batch of parts X<sub>i</sub>).It has developed the following Excel spreadsheet of the results.    -Refer to Exhibit 9.1.Predict the mean number of labor hours for a batch of 5 parts.

-Refer to Exhibit 9.1.Predict the mean number of labor hours for a batch of 5 parts.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
44
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 Yi)required to process a batch of parts Xi).It has developed the following Excel spreadsheet of the results.
 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 Y<sub>i</sub>)required to process a batch of parts X<sub>i</sub>).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.  \widehat { \mathrm { Y } } _ { \mathrm { i } } = 4.8400 + 1.4836 \mathrm { X } _ { \mathrm { li } }

-Refer to Exhibit 9.1.What is the estimated regression function for this problem? Explain what the terms in your equation mean.
Y^i=4.8400+1.4836Xli\widehat { \mathrm { Y } } _ { \mathrm { i } } = 4.8400 + 1.4836 \mathrm { X } _ { \mathrm { li } }
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
45
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.
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.Interpret the meaning of R square in cell B3 of the spreadsheet.
Refer to Exhibit 9.3.Interpret the meaning of R square in cell B3 of the spreadsheet.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
46
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.
 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.  \widehat { \mathrm { Y } } _ { \mathrm { i } } = 38.1923 + 1.2447 \mathrm { X } _ { \mathrm { l i} }

-Refer to Exhibit 9.2.What is the estimated regression function for this problem? Explain what the terms in your equation mean.
Y^i=38.1923+1.2447Xli\widehat { \mathrm { Y } } _ { \mathrm { i } } = 38.1923 + 1.2447 \mathrm { X } _ { \mathrm { l i} }
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
47
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 Yi)required to process a batch of parts Xi).It has developed the following Excel spreadsheet of the results.
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 Y<sub>i</sub>)required to process a batch of parts X<sub>i</sub>).It has developed the following Excel spreadsheet of the results.   Refer to Exhibit 9.1.Interpret the meaning of the Lower 95% and Upper 95% terms in cells F16:G16 of the spreadsheet.
Refer to Exhibit 9.1.Interpret the meaning of the "Lower 95%" and "Upper 95%" terms in cells F16:G16 of the spreadsheet.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
48
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.
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.Test the significance of the model and explain which values you used to reach your conclusions.
Refer to Exhibit 9.2.Test the significance of the model and explain which values you used to reach your conclusions.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
49
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.
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 R Square in cell B3 of the spreadsheet.
Refer to Exhibit 9.2.Interpret the meaning of R Square in cell B3 of the spreadsheet.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
50
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 Yi)required to process a batch of parts Xi).It has developed the following Excel spreadsheet of the results.
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 Y<sub>i</sub>)required to process a batch of parts X<sub>i</sub>).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.

-Refer to Exhibit 9.1.Provide a rough 95% confidence interval on the number of labor hours for a batch of 5 parts.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
51
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.
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.Predict the mean pressure for a temperature of 120 degrees.

-Refer to Exhibit 9.2.Predict the mean pressure for a temperature of 120 degrees.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
52
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.
 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  \widehat { \mathrm { Y } } _ { \mathrm { i } } = 3995.991 - 54.2303 \mathrm { X } _ { \mathrm { li } }

-Refer to Exhibit 9.3.What is the estimated regression function for this problem? Explain what the terms in your equation mean
Y^i=3995.99154.2303Xli\widehat { \mathrm { Y } } _ { \mathrm { i } } = 3995.991 - 54.2303 \mathrm { X } _ { \mathrm { li } }
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
53
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 Yi)required to process a batch of parts Xi).It has developed the following Excel spreadsheet of the results.
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 Y<sub>i</sub>)required to process a batch of parts X<sub>i</sub>).It has developed the following Excel spreadsheet of the results.   Refer to Exhibit 9.1.Interpret the meaning of R Square in cell B3 of the spreadsheet.
Refer to Exhibit 9.1.Interpret the meaning of R Square in cell B3 of the spreadsheet.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
54
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.
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.Interpret the meaning of the Lower 95% and Upper 95% terms in cells F16:G16 of the spreadsheet.
Refer to Exhibit 9.3.Interpret the meaning of the "Lower 95%" and "Upper 95%" terms in cells F16:G16 of the spreadsheet.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
55
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.
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.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
56
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 Yi)required to process a batch of parts Xi).It has developed the following Excel spreadsheet of the results.
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 Y<sub>i</sub>)required to process a batch of parts X<sub>i</sub>).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.
Refer to Exhibit 9.1.Test the significance of the model and explain which values you used to reach your conclusions.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
57
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.
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.Predict the mean number of calories consumed by a 19 year old man.

-Refer to Exhibit 9.3.Predict the mean number of calories consumed by a 19 year old man.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
58
The researcher would like to build a prediction interval on the calories consumed by an 18 year old man.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.
The researcher would like to build a prediction interval on the calories consumed by an 18 year old man.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.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
59
The company would like to build a prediction interval on the pressure for a can with a temperature of 125 degrees.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.
The company would like to build a prediction interval on the pressure for a can with a temperature of 125 degrees.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.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
60
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.
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.
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.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
61
Exhibit 9.7
The partial regression output below applies to the following questions.
Exhibit 9.7 The partial regression output below applies to the following questions.   Refer to Exhibit 9.7.What is the SS for Total?
Refer to Exhibit 9.7.What is the SS for Total?
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
62
Exhibit 9.6
The partial regression output below applies to the following questions.
Exhibit 9.6 The partial regression output below applies to the following questions.   Refer to Exhibit 9.6.What is the F-statistic value?
Refer to Exhibit 9.6.What is the F-statistic value?
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
63
The forecasting model that makes use of the least squares method is called

A)regression
B)naive approach
C)moving average
D)exponential smoothing
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
64
Exhibit 9.5
The following questions are based on the description and spreadsheet below.
An analyst has identified 3 independent variables X1,X2,X3)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.
 Independent  Variable Adjusted  the R2R2 Se Parameter Estimates X10.000890.124023.548 b0=93.7174, b1=0.922X20.387000.310418.448 b0=57.0803, b2=1.545X1 and X20.391000.217019.654 b0=50.2927, b1=1.952, b2=1.554X30.841300.82149.3858 b0=31.6238, b3=1.132X1 and X30.841300.796010.033 b0=31.133, b1=0.148, b3=1.132X2 and X30.986300.98242.948 b0=14.169, b2=0.985, b3=0.995X1,X2 and X30.987100.98073.085 b0=11.113, b1=0.899, b2=0.990, b\begin{array}{lrrrl}\text { Independent }\\\text { Variable}& \text { Adjusted }\\\text { the } & \mathrm{R}^{2} & -\mathrm{R}^{2} & \mathrm{~S}_{\mathrm{e}} & \text { Parameter Estimates }\\\hline\mathrm{X}_{1} & 0.00089 & -0.1240 & 23.548 & \mathrm{~b}_{0}=93.7174, \mathrm{~b}_{1}=0.922 \\\mathrm{X}_{2} & 0.38700 & 0.3104 & 18.448 & \mathrm{~b}_{0}=57.0803, \mathrm{~b}_{2}=1.545 \\\mathrm{X}_{1} \text { and } \mathrm{X}_{2} & 0.39100 & 0.2170 & 19.654 & \mathrm{~b}_{0}=50.2927, \mathrm{~b}_{1}=1.952, \mathrm{~b}_{2}=1.554 \\\mathrm{X}_{3} & 0.84130 & 0.8214 & 9.3858 & \mathrm{~b}_{0}=31.6238, \mathrm{~b}_{3}=1.132 \\\mathrm{X}_{1} \text { and } \mathrm{X}_{3} & 0.84130 & 0.7960 & 10.033 & \mathrm{~b}_{0}=31.133, \mathrm{~b}_{1}=0.148, \mathrm{~b}_{3}=1.132 \\\mathrm{X}_{2} \text { and } \mathrm{X}_{3} & 0.98630 & 0.9824 & 2.948 & \mathrm{~b}_{0}=14.169, \mathrm{~b}_{2}=0.985, \mathrm{~b}_{3}=0.995 \\\mathrm{X}_{1}, \mathrm{X}_{2} \text { and } \mathrm{X}_{3} & 0.98710 & 0.9807 & 3.085 & \mathrm{~b}_{0}=11.113, \mathrm{~b}_{1}=0.899, \mathrm{~b}_{2}=0.990, \mathrm{~b}\end{array}


-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.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
65
A pattern resulting from random variation or unexplained causes is called

A)noise
B)trend
C)seasonality
D)time series
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
66
In regression analysis,the total variation is:

A)the sum of the squared deviations of each value of y from the mean of x
B)the sum of the explained variation and unexplained variation
C)the standard error of the forecast
D)equal to R2
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
67
A persistent upward or downward movement of data is called

A)trend
B)seasonality
C)irregular variation
D)dampening signal
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
68
Exhibit 9.7
The partial regression output below applies to the following questions.
Exhibit 9.7 The partial regression output below applies to the following questions.   Refer to Exhibit 9.7.What is the SS for Residual and MS for Residual?
Refer to Exhibit 9.7.What is the SS for Residual and MS for Residual?
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
69
R2 measures

A)the percentage of variability in the dependent variable,Y,explained by the model
B)the unexplained variability
C)the ratio of RSS/ESS
D)the model sophistication
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
70
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.
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.Predict the mean donation by a person with 16 years of education,$90,000 annual income and 2 children.Use a full model based on data from the table.

-Refer to Exhibit 9.4.Predict the mean donation by a person with 16 years of education,$90,000 annual income and 2 children.Use a full model based on data from the table.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
71
How many independent variables are there in simple regression analysis?

A)1
B)2
C)3
D)4
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
72
Exhibit 9.6
The partial regression output below applies to the following questions.
Exhibit 9.6 The partial regression output below applies to the following questions.   Refer to Exhibit 9.6.What is the MS for Residual?
Refer to Exhibit 9.6.What is the MS for Residual?
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
73
Exhibit 9.5
The following questions are based on the description and spreadsheet below.
An analyst has identified 3 independent variables X1,X2,X3)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.
 Independent  Variable Adjusted  the R2R2 Se Parameter Estimates X10.000890.124023.548 b0=93.7174, b1=0.922X20.387000.310418.448 b0=57.0803, b2=1.545X1 and X20.391000.217019.654 b0=50.2927, b1=1.952, b2=1.554X30.841300.82149.3858 b0=31.6238, b3=1.132X1 and X30.841300.796010.033 b0=31.133, b1=0.148, b3=1.132X2 and X30.986300.98242.948 b0=14.169, b2=0.985, b3=0.995X1,X2 and X30.987100.98073.085 b0=11.113, b1=0.899, b2=0.990, b\begin{array}{lrrrl}\text { Independent }\\\text { Variable}& \text { Adjusted }\\\text { the } & \mathrm{R}^{2} & -\mathrm{R}^{2} & \mathrm{~S}_{\mathrm{e}} & \text { Parameter Estimates }\\\hline\mathrm{X}_{1} & 0.00089 & -0.1240 & 23.548 & \mathrm{~b}_{0}=93.7174, \mathrm{~b}_{1}=0.922 \\\mathrm{X}_{2} & 0.38700 & 0.3104 & 18.448 & \mathrm{~b}_{0}=57.0803, \mathrm{~b}_{2}=1.545 \\\mathrm{X}_{1} \text { and } \mathrm{X}_{2} & 0.39100 & 0.2170 & 19.654 & \mathrm{~b}_{0}=50.2927, \mathrm{~b}_{1}=1.952, \mathrm{~b}_{2}=1.554 \\\mathrm{X}_{3} & 0.84130 & 0.8214 & 9.3858 & \mathrm{~b}_{0}=31.6238, \mathrm{~b}_{3}=1.132 \\\mathrm{X}_{1} \text { and } \mathrm{X}_{3} & 0.84130 & 0.7960 & 10.033 & \mathrm{~b}_{0}=31.133, \mathrm{~b}_{1}=0.148, \mathrm{~b}_{3}=1.132 \\\mathrm{X}_{2} \text { and } \mathrm{X}_{3} & 0.98630 & 0.9824 & 2.948 & \mathrm{~b}_{0}=14.169, \mathrm{~b}_{2}=0.985, \mathrm{~b}_{3}=0.995 \\\mathrm{X}_{1}, \mathrm{X}_{2} \text { and } \mathrm{X}_{3} & 0.98710 & 0.9807 & 3.085 & \mathrm{~b}_{0}=11.113, \mathrm{~b}_{1}=0.899, \mathrm{~b}_{2}=0.990, \mathrm{~b}\end{array}


-Refer to Exhibit 9.5.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.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
74
Project 9.1 ? Test Stand Cost Analysis Estimation
Handel Manufacturing produces test stands for various maintenance functions ranging from automobile to jet airline testing stations.For years,their cost estimating function was based on a myriad of historical data fed into a cost analysis model that produced very accurate estimates of both development and support costs for various proposed test stands.James Mudd was a recent hire into the cost analysis shop.Unfortunately,during his first week on the job,James deleted the cost analysis database and failed to maintain a backup of the model.Fortunately,all is not lost.The computer support personnel can come in Monday and retrieve the model using their system backup tapes.
Unfortunately,the cost proposals for three new test stand development and deployment projects are due first thing Monday morning.Since James recently left the company,you have been tasked to complete the cost estimate portion of the proposals.
After much gnashing of your teeth,you settle down to make the best of what you initially believe is a losing situation.While studying James' files you find historical records on 25 recent test stand development and deployment projects.Rejuvenated,you realize you can succeed in this prematurely perceived doomed situation.All you need to do is analyze this historical data,develop some cost estimating functions using regression,and then use your regression models to develop estimates for the three projects due Monday.The historical data in the files is the following.
Test Stand Product Cost Estimation
 Project 9.1 ? Test Stand Cost Analysis Estimation Handel Manufacturing produces test stands for various maintenance functions ranging from automobile to jet airline testing stations.For years,their cost estimating function was based on a myriad of historical data fed into a cost analysis model that produced very accurate estimates of both development and support costs for various proposed test stands.James Mudd was a recent hire into the cost analysis shop.Unfortunately,during his first week on the job,James deleted the cost analysis database and failed to maintain a backup of the model.Fortunately,all is not lost.The computer support personnel can come in Monday and retrieve the model using their system backup tapes. Unfortunately,the cost proposals for three new test stand development and deployment projects are due first thing Monday morning.Since James recently left the company,you have been tasked to complete the cost estimate portion of the proposals. After much gnashing of your teeth,you settle down to make the best of what you initially believe is a losing situation.While studying James' files you find historical records on 25 recent test stand development and deployment projects.Rejuvenated,you realize you can succeed in this prematurely perceived doomed situation.All you need to do is analyze this historical data,develop some cost estimating functions using regression,and then use your regression models to develop estimates for the three projects due Monday.The historical data in the files is the following. Test Stand Product Cost Estimation   The data estimates for the three cost proposal due Monday is the following: Estimates for New Lines  \begin{array}{llllllll} &\text { Lines of  } & \text {Reparable } & \text { Primary  } & \text {Deployed } & \text { Estmated  } & \text {Estmated }\\ &\text { Code } & \text {  Items } & \text { Functions  } & \text { Sites }& \text { Sales } & \text { Life } & \text { R\&M }\\ \hline1 & 5000 & 7 & 4 & 400 & 4000 & 7.5 & 0.965857 \\ 2 & 7500 & 5 & 5 & 450 & 4500 & 8.5 & 0.976311 \\ 3 & 34 n 0 & 6 & 3 & 375 & 3750 & 6 & 0.930541 \end{array}    One thing unclear from reading the files was on the form of the cost estimating relationships contained within the lost cost analysis model.You are somewhat sure the regression models were not polynomial in form,but you are not certain of this fact.You are not even sure which variables were included in the model for development cost and which variables were included in the model for support costs.However,you are undaunted because you know you can develop accurate models and produce good cost estimates for each of the proposed projects. Develop appropriate models for development and for support costs.Use these models to develop cost estimates for each of the new lines of test stands.For each of these cost estimates provide 95% confidence intervals for the predicted values.
The data estimates for the three cost proposal due Monday is the following:
Estimates for New Lines
 Lines of Reparable  Primary Deployed  Estmated Estmated  Code  Items  Functions  Sites  Sales  Life  R&M 150007440040007.50.965857275005545045008.50.976311334n063375375060.930541\begin{array}{llllllll}&\text { Lines of } & \text {Reparable } & \text { Primary } & \text {Deployed } & \text { Estmated } & \text {Estmated }\\&\text { Code } & \text { Items } & \text { Functions } & \text { Sites }& \text { Sales } & \text { Life } & \text { R\&M }\\\hline1 & 5000 & 7 & 4 & 400 & 4000 & 7.5 & 0.965857 \\2 & 7500 & 5 & 5 & 450 & 4500 & 8.5 & 0.976311 \\3 & 34 n 0 & 6 & 3 & 375 & 3750 & 6 & 0.930541\end{array}


One thing unclear from reading the files was on the form of the cost estimating relationships contained within the lost cost analysis model.You are somewhat sure the regression models were not polynomial in form,but you are not certain of this fact.You are not even sure which variables were included in the model for development cost and which variables were included in the model for support costs.However,you are undaunted because you know you can develop accurate models and produce good cost estimates for each of the proposed projects.
Develop appropriate models for development and for support costs.Use these models to develop cost estimates for each of the new lines of test stands.For each of these cost estimates provide 95% confidence intervals for the predicted values.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
75
In time series regression analysis

A)the dependent variable represents time
B)the independent variable represents time
C)the sign of slope,b,is usually negative
D)the sign of slope,b,is usually positive
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
76
Which of the following cannot be negative?

A)coefficient of determination
B)coefficient of correlation
C)coefficient of the independent variable,x,in the regression equation
D)y-intercept in the regression equation
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
77
The adjusted R2 statistic

A)is equal to the value of unadjusted R2
B)adjusts R2 for the degrees of freedom in the multiple regression model
C)accounts for the parameters in the multiple regression model
D)is always greater than R2 unadjusted
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
78
Assume you have chosen to use all three variables in your model.Test the significance of the model and explain which values you used to reach your conclusion.
Assume you have chosen to use all three variables in your model.Test the significance of the model and explain which values you used to reach your conclusion.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
79
How many binary variables are required to encode a person's age group as being either young,middle-age or old? What are the variables and what are the meanings of their 0,1 values?
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
80
Which of the following best describes the relationship between cost and accuracy in forecasting?

A)low cost methods are always less accurate
B)statistical methods are more costly and more accurate
C)there is a tradeoff between cost and accuracy
D)cost should not be considered in business forecasting
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.
فتح الحزمة
k this deck
locked card icon
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 82 في هذه المجموعة.