Exam 9: Regression Analysis

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.

Exhibit 9.6 The partial regression output below applies to the following questions. -Refer to Exhibit 9.6.What is the MS for Residual?

Based on the following regression output,what proportion of the total variation in Y is explained by X?

Residuals are assumed to be

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?

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.

An analyst has identified 3 independent variables X₁,X₂,X₃)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?

Exhibit 9.5 The following questions are based on the description and spreadsheet below. An analyst has identified 3 independent variables X₁,X₂,X₃)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 - Parameter Estimates 0.00089 -0.1240 23.548 =93.7174,=0.922 0.38700 0.3104 18.448 =57.0803,=1.545 and 0.39100 0.2170 19.654 =50.2927,=1.952,=1.554 0.84130 0.8214 9.3858 =31.6238,=1.132 and 0.84130 0.7960 10.033 =31.133,=0.148,=1.132 and 0.98630 0.9824 2.948 =14.169,=0.985,=0.995 , and 0.98710 0.9807 3.085 =11.113,=0.899,=0.990, -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.

Which of the following is an advantage of using the TREND)function versus the regression tool?

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 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.

In regression analysis,the total variation is:

The reason an analyst creates a regression model is

The terms b₀ and b₁ are

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_i)required to process a batch of parts X_i).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.

The total sum of squares TSS)is best defined as

The forecasting model that makes use of the least squares method is called

Regression analysis is a modeling technique

Exhibit 9.5 The following questions are based on the description and spreadsheet below. An analyst has identified 3 independent variables X₁,X₂,X₃)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 - Parameter Estimates 0.00089 -0.1240 23.548 =93.7174,=0.922 0.38700 0.3104 18.448 =57.0803,=1.545 and 0.39100 0.2170 19.654 =50.2927,=1.952,=1.554 0.84130 0.8214 9.3858 =31.6238,=1.132 and 0.84130 0.7960 10.033 =31.133,=0.148,=1.132 and 0.98630 0.9824 2.948 =14.169,=0.985,=0.995 , and 0.98710 0.9807 3.085 =11.113,=0.899,=0.990, -Refer to Exhibit 9.5.Predict the mean value based on X₁,X₂,X₃)= 3,32,50).Use the best predictive model based on data from the table.

The regression function indicates the