Exam 9: Regression Analysis
Exam 1: Introduction to Modeling and Decision Analysis52 Questions
Exam 2: Introduction to Optimization and Linear Programming62 Questions
Exam 3: Modeling and Solving Lp Problems in a Spreadsheet88 Questions
Exam 4: Sensitivity Analysis and the Simplex Method72 Questions
Exam 5: Network Modeling72 Questions
Exam 6: Integer Linear Programming72 Questions
Exam 7: Goal Programming and Multiple Objective Optimization59 Questions
Exam 8: Nonlinear Programming and Evolutionary Optimization68 Questions
Exam 9: Regression Analysis76 Questions
Exam 10: Discriminant Analysis57 Questions
Exam 11: Time Series Forecasting111 Questions
Exam 12: Introduction to Simulation Using Risk Solver Platform65 Questions
Exam 13: Queuing Theory79 Questions
Exam 14: Decision Analysis102 Questions
Exam 15: Project Management Online61 Questions
Select questions type
Based on the following regression output, what conclusion can you reach about ?1? Regression Statistics Multiple R 0.917214 R Square 0.841282 Adjusted R Square 0.821442 Standard Error 9.385572 Observations 10 ANOVA df SS MS F Significance F Regression 1 3735.306 3735.306 42.40379 0.000186 Residual 8 704.7117 88.08896 Total 9 4440.017 Coefficients Standard Error t Stat P-value Lower 95\% Intercept 31.62378 10.44297 3.028236 0.016353 7.542233 X Variable 1 1.131661 0.173786 6.511819 0.000186 0.73091
(Multiple Choice)
4.8/5
(32)
For a simple linear regression model, a 100(1 )% prediction interval for a new value of Y when X = Xh is computed as
(Multiple Choice)
4.7/5
(27)
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.
-Refer to Exhibit 9.1. What is the estimated regression function for this problem? Explain what the terms in your equation mean.

(Essay)
4.9/5
(31)
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.

(Essay)
4.7/5
(41)
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?

(Essay)
4.8/5
(40)
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.


(Essay)
4.9/5
(33)
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

(Essay)
4.8/5
(31)
Exhibit 9.7
The partial regression output below applies to the following questions.
-Refer to Exhibit 9.7. What is the SS for Total?

(Short Answer)
4.8/5
(40)
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 in Adjusted the Model - Parameter Estimates 0.00089 -0.124 23.548 =93.7174,=0.922 0.3870 0.3104 18.448 =57.0803,=1.545 and 0.3910 0.2170 19.654 =50.2927,=1.952,=1.554 0.8413 0.8214 9.3858 =31.6238,=1.132 and 0.8413 0.7960 10.033 =31.133,=0.148,=1.132 and 0.9863 0.9824 2.948 =14.169,=0.985,=0.995 X and 0.9871 0.9807 3.085 =11.113.=0.899.=0.990.=0.993
-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.
(Essay)
4.7/5
(35)
Showing 21 - 40 of 76
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)