Exam 14: Introduction to Multiple Regression

TABLE 14-4 A real estate builder wishes to determine how house size (House)is influenced by family income (Income)and family size (Size).House size is measured in hundreds of square feet and income is measured in thousands of dollars.The builder randomly selected 50 families and ran the multiple regression.Partial Microsoft Excel output is provided below: Also SSR (X₁ ∣ X₂)= 36400.6326 and SSR (X₂ ∣ X₁)= 3297.7917 -Referring to Table 14-4 and allowing for a 1% probability of committing a type I error,what is the decision and conclusion for the test H₀ : β₁ = β₂ = 0 vs.H₁ : At least one β_j ≠ 0,j = 1,2?

TABLE 14-7 The department head of the accounting department wanted to see if she could predict the GPA of students using the number of course units (credits)and total SAT scores of each.She takes a sample of students and generates the following Microsoft Excel output: -Referring to Table 14-7,the net regression coefficient of X₂ is ________.

TABLE 14-4 A real estate builder wishes to determine how house size (House)is influenced by family income (Income)and family size (Size).House size is measured in hundreds of square feet and income is measured in thousands of dollars.The builder randomly selected 50 families and ran the multiple regression.Partial Microsoft Excel output is provided below: Also SSR (X₁ ∣ X₂)= 36400.6326 and SSR (X₂ ∣ X₁)= 3297.7917 -Referring to Table 14-4,one individual in the sample had an annual income of $40,000 and a family size of 1.This individual owned a home with an area of 1,000 square feet (House = 10.00).What is the residual (in hundreds of square feet)for this data point?

TABLE 14-17 Given below are results from the regression analysis where the dependent variable is the number of weeks a worker is unemployed due to a layoff (Unemploy)and the independent variables are the age of the worker (Age)and a dummy variable for management position (Manager: 1 = yes,0 = no). The results of the regression analysis are given below: -Referring to Table 14-17,what is the value of the test statistic to determine whether there is a significant relationship between the number of weeks a worker is unemployed due to a layoff and the entire set of explanatory variables?

TABLE 14-10 You worked as an intern at We Always Win Car Insurance Company last summer.You notice that individual car insurance premiums depend very much on the age of the individual and the number of traffic tickets received by the individual.You performed a regression analysis in EXCEL and obtained the following partial information: -Referring to Table 14-10,the regression sum of squares that is missing in the ANOVA table should be ________.

TABLE 14-3 An economist is interested to see how consumption for an economy (in $ billions)is influenced by gross domestic product ($ billions)and aggregate price (consumer price index).The Microsoft Excel output of this regression is partially reproduced below. -Referring to Table 14-3,one economy in the sample had an aggregate consumption level of $4 billion,a GDP of $6 billion,and an aggregate price level of 200.What is the residual for this data point?

TABLE 14-15 The superintendent of a school district wanted to predict the percentage of students passing a sixth-grade proficiency test.She obtained the data on percentage of students passing the proficiency test (% Passing),mean teacher salary in thousands of dollars (Salaries),and instructional spending per pupil in thousands of dollars (Spending)of 47 schools in the state. Following is the multiple regression output with Y = % Passing as the dependent variable,X₁ = Salaries and X₂ = Spending: -True or False: Referring to Table 14-15,there is sufficient evidence that the percentage of students passing the proficiency test depends on both of the explanatory variables at a 5% level of significance.

TABLE 14-17 Given below are results from the regression analysis where the dependent variable is the number of weeks a worker is unemployed due to a layoff (Unemploy)and the independent variables are the age of the worker (Age)and a dummy variable for management position (Manager: 1 = yes,0 = no). The results of the regression analysis are given below: -Referring to Table 14-17,what is the standard error of estimate?

TABLE 14-17 Given below are results from the regression analysis where the dependent variable is the number of weeks a worker is unemployed due to a layoff (Unemploy)and the independent variables are the age of the worker (Age)and a dummy variable for management position (Manager: 1 = yes,0 = no). The results of the regression analysis are given below: -True or False: Referring to Table 14-17,we can conclude definitively that,holding constant the effect of the other independent variables,there is not a difference in the mean number of weeks a worker is unemployed due to a layoff between a worker who is in a management position and one who is not at a 1% level of significance if all we have is the information of the 95% confidence interval estimate for the difference in the mean number of weeks a worker is unemployed due to a layoff between a worker who is in a management position and one who is not.

TABLE 14-15 The superintendent of a school district wanted to predict the percentage of students passing a sixth-grade proficiency test.She obtained the data on percentage of students passing the proficiency test (% Passing),mean teacher salary in thousands of dollars (Salaries),and instructional spending per pupil in thousands of dollars (Spending)of 47 schools in the state. Following is the multiple regression output with Y = % Passing as the dependent variable,X₁ = Salaries and X₂ = Spending: -Referring to Table 14-15,predict the percentage of students passing the proficiency test for a school which has a mean teacher salary of 40,000 dollars,and an instructional spending per pupil of 2,000 dollars.

TABLE 14-6 One of the most common questions of prospective house buyers pertains to the cost of heating in dollars (Y).To provide its customers with information on that matter,a large real estate firm used the following 2 variables to predict heating costs: the daily minimum outside temperature in degrees of Fahrenheit (X₁)and the amount of insulation in inches (X₂).Given below is EXCEL output of the regression model. Also SSR (X₁ ∣ X₂)= 8343.3572 and SSR (X₂ ∣ X₁)= 4199.2672 -True or False: Consider a regression in which b₂ = -1.5 and the standard error of this coefficient equals 0.3.To determine whether X₂ is a significant explanatory variable,you would compute an observed t-value of -5.0.

TABLE 14-17 Given below are results from the regression analysis where the dependent variable is the number of weeks a worker is unemployed due to a layoff (Unemploy)and the independent variables are the age of the worker (Age)and a dummy variable for management position (Manager: 1 = yes,0 = no). The results of the regression analysis are given below: -Referring to Table 14-17,which of the following is a correct statement?

TABLE 14-17 Given below are results from the regression analysis where the dependent variable is the number of weeks a worker is unemployed due to a layoff (Unemploy)and the independent variables are the age of the worker (Age)and a dummy variable for management position (Manager: 1 = yes,0 = no). The results of the regression analysis are given below: -True or False: Referring to Table 14-17,there is sufficient evidence that age has an effect on the number of weeks a worker is unemployed due to a layoff while holding constant the effect of the other independent variable at a 10% level of significance.

TABLE 14-16 What are the factors that determine the acceleration time (in sec.)from 0 to 60 miles per hour of a car? Data on the following variables for 30 different vehicle models were collected: Y (Accel Time): Acceleration time in sec. X₁ (Engine Size): c.c. X₂ (Sedan): 1 if the vehicle model is a sedan and 0 otherwise The regression results using acceleration time as the dependent variable and the remaining variables as the independent variables are presented below. The various residual plots are as shown below. The coefficient of partial determinations and are 0.3301,and 0.0594,respectively. The coefficient of determination for the regression model using each of the 2 independent variables as the dependent variable and the other independent variable as independent variables ( )are,respectively 0.0077,and 0.0077. -True or False: Referring to Table 14-16,there is enough evidence to conclude that being a sedan or not makes a significant contribution to the regression model in the presence of the other independent variable at a 5% level of significance.

TABLE 14-17 Given below are results from the regression analysis where the dependent variable is the number of weeks a worker is unemployed due to a layoff (Unemploy)and the independent variables are the age of the worker (Age)and a dummy variable for management position (Manager: 1 = yes,0 = no). The results of the regression analysis are given below: -True or False: Referring to Table 14-17,you can conclude that,holding constant the effect of the other independent variable,age has no impact on the mean number of weeks a worker is unemployed due to a layoff at a 5% level of significance if we use only the information of the 95% confidence interval estimate for the effect of a one year increase in age on the mean number of weeks a worker is unemployed due to a layoff.

TABLE 14-17 Given below are results from the regression analysis where the dependent variable is the number of weeks a worker is unemployed due to a layoff (Unemploy)and the independent variables are the age of the worker (Age)and a dummy variable for management position (Manager: 1 = yes,0 = no). The results of the regression analysis are given below: -True or False: Referring to Table 14-17,the null hypothesis H₀ : β₁ = β₂ = 0 implies that the number of weeks a worker is unemployed due to a layoff is not related to one of the explanatory variables.

TABLE 14-6 One of the most common questions of prospective house buyers pertains to the cost of heating in dollars (Y).To provide its customers with information on that matter,a large real estate firm used the following 2 variables to predict heating costs: the daily minimum outside temperature in degrees of Fahrenheit (X₁)and the amount of insulation in inches (X₂).Given below is EXCEL output of the regression model. Also SSR (X₁ ∣ X₂)= 8343.3572 and SSR (X₂ ∣ X₁)= 4199.2672 -True or False: A multiple regression is called "multiple" because it has several explanatory variables.