Exam 18: A Roadmap for Analyzing Data

SCENARIO 18-12 The marketing manager for a nationally franchised lawn service company would like to study the characteristics that differentiate home owners who do and do not have a lawn service.A random sample of 30 home owners located in a suburban area near a large city was selected; 15 did not have a lawn service (code 0)and 15 had a lawn service (code 1).Additional information available concerning these 30 home owners includes family income (Income, in thousands of dollars), lawn size (Lawn Size, in thousands of square feet), attitude toward outdoor recreational activities (Attitude 0 = unfavorable, 1 = favorable), number of teenagers in the household (Teenager), and age of the head of the household (Age). The Minitab output is given below: -Referring to Scenario 18-12, what is the p-value of the test statistic when testing whether Teenager makes a significant contribution to the model in the presence of the other independent variables?

SCENARIO 18-10 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), the number of years of education received (Edu), the number of years at the previous job (Job Yr), a dummy variable for marital status (Married: 1 = married, 0 = otherwise), a dummy variable for head of household (Head: 1 = yes, 0 = no)and a dummy variable for management position (Manager: 1 = yes, 0 = no).We shall call this Model 1.The coefficient of partial determination of each of the 6 predictors are, respectively, 0.2807, 0.0386, 0.0317, 0.0141, 0.0958, and 0.1201. Model 2 is the regression analysis where the dependent variable is Unemploy and the independent variables are Age and Manager.The results of the regression analysis are given below: -Referring to Scenario 18-10 Model 1, the null hypothesis should be rejected at a 10% level of significance when testing 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.

SCENARIO 18-12 The marketing manager for a nationally franchised lawn service company would like to study the characteristics that differentiate home owners who do and do not have a lawn service.A random sample of 30 home owners located in a suburban area near a large city was selected; 15 did not have a lawn service (code 0)and 15 had a lawn service (code 1).Additional information available concerning these 30 home owners includes family income (Income, in thousands of dollars), lawn size (Lawn Size, in thousands of square feet), attitude toward outdoor recreational activities (Attitude 0 = unfavorable, 1 = favorable), number of teenagers in the household (Teenager), and age of the head of the household (Age). The Minitab output is given below: -Referring to Scenario 18-12, what should be the decision ('reject' or 'do not reject')on the null hypothesis when testing whether Age makes a significant contribution to the model in the presence of the other independent variables at a 0.05 level of significance?

SCENARIO 18-10 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), the number of years of education received (Edu), the number of years at the previous job (Job Yr), a dummy variable for marital status (Married: 1 = married, 0 = otherwise), a dummy variable for head of household (Head: 1 = yes, 0 = no)and a dummy variable for management position (Manager: 1 = yes, 0 = no).We shall call this Model 1.The coefficient of partial determination of each of the 6 predictors are, respectively, 0.2807, 0.0386, 0.0317, 0.0141, 0.0958, and 0.1201. Model 2 is the regression analysis where the dependent variable is Unemploy and the independent variables are Age and Manager.The results of the regression analysis are given below: -Referring to Scenario 18-10 Model 1, which of the following is the correct null hypothesis to test whether being married or not makes a difference in the mean number of weeks a worker is unemployed due to a layoff while holding constant the effect of all the other independent variables?

SCENARIO 18-11 A logistic regression model was estimated in order to predict the probability that a randomly chosen university or college would be a private university using information on mean total Scholastic Aptitude Test score (SAT)at the university or college, the room and board expense measured in thousands of dollars (Room/Brd), and whether the TOEFL criterion is at least 550 (Toefl550 = 1 if yes, 0 otherwise.)The dependent variable, Y, is school type (Type = 1 if private and 0 otherwise). The Minitab output is given below: -Referring to Scenario 18-11, the null hypothesis that the model is a good- fitting model cannot be rejected when allowing for a 5% probability of making a type I error.

SCENARIO 18-10 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), the number of years of education received (Edu), the number of years at the previous job (Job Yr), a dummy variable for marital status (Married: 1 = married, 0 = otherwise), a dummy variable for head of household (Head: 1 = yes, 0 = no)and a dummy variable for management position (Manager: 1 = yes, 0 = no).We shall call this Model 1.The coefficient of partial determination of each of the 6 predictors are, respectively, 0.2807, 0.0386, 0.0317, 0.0141, 0.0958, and 0.1201. Model 2 is the regression analysis where the dependent variable is Unemploy and the independent variables are Age and Manager.The results of the regression analysis are given below: -Referring to Scenario 18-10 Model 1, the alternative hypothesis At least one of for j = 1, 2, 3, 4, 5, 6 implies that the number of weeks a worker is unemployed due to a layoff is related to all of the explanatory variables.

SCENARIO 18-10 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), the number of years of education received (Edu), the number of years at the previous job (Job Yr), a dummy variable for marital status (Married: 1 = married, 0 = otherwise), a dummy variable for head of household (Head: 1 = yes, 0 = no)and a dummy variable for management position (Manager: 1 = yes, 0 = no).We shall call this Model 1.The coefficient of partial determination of each of the 6 predictors are, respectively, 0.2807, 0.0386, 0.0317, 0.0141, 0.0958, and 0.1201. Model 2 is the regression analysis where the dependent variable is Unemploy and the independent variables are Age and Manager.The results of the regression analysis are given below: -Referring to Scenario 18-10 Model 1, which of the following is a correct statement?

SCENARIO 18-10 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), the number of years of education received (Edu), the number of years at the previous job (Job Yr), a dummy variable for marital status (Married: 1 = married, 0 = otherwise), a dummy variable for head of household (Head: 1 = yes, 0 = no)and a dummy variable for management position (Manager: 1 = yes, 0 = no).We shall call this Model 1.The coefficient of partial determination of each of the 6 predictors are, respectively, 0.2807, 0.0386, 0.0317, 0.0141, 0.0958, and 0.1201. Model 2 is the regression analysis where the dependent variable is Unemploy and the independent variables are Age and Manager.The results of the regression analysis are given below: -Referring to Scenario 18-10 Model 1, which of the following is the correct alternative hypothesis 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?

SCENARIO 18-10 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), the number of years of education received (Edu), the number of years at the previous job (Job Yr), a dummy variable for marital status (Married: 1 = married, 0 = otherwise), a dummy variable for head of household (Head: 1 = yes, 0 = no)and a dummy variable for management position (Manager: 1 = yes, 0 = no).We shall call this Model 1.The coefficient of partial determination of each of the 6 predictors are, respectively, 0.2807, 0.0386, 0.0317, 0.0141, 0.0958, and 0.1201. Model 2 is the regression analysis where the dependent variable is Unemploy and the independent variables are Age and Manager.The results of the regression analysis are given below: -Referring to Scenario 18-10 Model 1, predict the number of weeks being unemployed due to a layoff for a worker who is a thirty-year old, has 10 years of education, has 15 years of experience at the previous job, is married, is the head of household and is a manager.

SCENARIO 18-8 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), daily mean of the percentage of students attending class (% Attendance), mean teacher salary in dollars (Salaries), and instructional spending per pupil in dollars (Spending)of 47 schools in the state. Following is the multiple regression output with as the dependent variable, -Referring to Scenario 18-8, the alternative hypothesis : At least one of for j = 1, 2, 3 implies that percentage of students passing the proficiency test is related to all of the explanatory variables.

SCENARIO 18-10 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), the number of years of education received (Edu), the number of years at the previous job (Job Yr), a dummy variable for marital status (Married: 1 = married, 0 = otherwise), a dummy variable for head of household (Head: 1 = yes, 0 = no)and a dummy variable for management position (Manager: 1 = yes, 0 = no).We shall call this Model 1.The coefficient of partial determination of each of the 6 predictors are, respectively, 0.2807, 0.0386, 0.0317, 0.0141, 0.0958, and 0.1201. Model 2 is the regression analysis where the dependent variable is Unemploy and the independent variables are Age and Manager.The results of the regression analysis are given below: -Referring to Scenario 18-10 Model 1, ________ of the variation in the number of weeks a worker is unemployed due to a layoff can be explained by whether the worker is in a management position while controlling for the other independent variables.

SCENARIO 18-7 As a project for his business statistics class, a student examined the factors that determined parking meter rates throughout the campus area.Data were collected for the price per hour of parking, blocks to the quadrangle, and one of the three jurisdictions: on campus, in downtown and off campus, or outside of downtown and off campus.The population regression model hypothesized is where Y is the meter price is the number of blocks to the quad is a dummy variable that takes the value 1 if the meter is located in downtown and off campus and the value 0 otherwise is a dummy variable that takes the value 1 if the meter is located outside of downtown and off campus, and the value 0 otherwise The following Excel results are obtained. -Referring to Scenario 18-7, predict the meter rate per hour if one parks outside of downtown and off campus 3 blocks from the quad.

SCENARIO 18-11 A logistic regression model was estimated in order to predict the probability that a randomly chosen university or college would be a private university using information on mean total Scholastic Aptitude Test score (SAT)at the university or college, the room and board expense measured in thousands of dollars (Room/Brd), and whether the TOEFL criterion is at least 550 (Toefl550 = 1 if yes, 0 otherwise.)The dependent variable, Y, is school type (Type = 1 if private and 0 otherwise). The Minitab output is given below: -Referring to Scenario 18-11, what is the estimated probability that a school with a mean SAT score of 1250, a TOEFL criterion that is at least 550, and the room and board expense of 5 thousand dollars will be a private school?

SCENARIO 18-1 A real estate builder wishes to determine how house size (House)is influenced by family income (Income), family size (Size), and education of the head of household (School).House size is measured in hundreds of square feet, income is measured in thousands of dollars, and education is in years.The builder randomly selected 50 families and ran the multiple regression.Microsoft Excel output is provided below: SUMMARY OUTPUT -Referring to Scenario 18-1, what is the value of the calculated F test statistic that is missing from the output for testing whether the whole regression model is significant?

A Paso Robles wine producer wanted to forecast the cases of Merlot wine sold.The number of cases of merlot wine sold in a 28-year period was collected.Which of the following would be the most appropriate analysis to perform?

Suppose the probability of producing a defective light bulb from a production line is the same over an interval of 90 minutes.Which of the following distributions would you use to determine the probability that a defective light bulb will be produced in a 15 minutes interval?

A Paso Robles wine producer wanted to forecast the cases of Merlot wine sold.The number of cases of merlot wine sold in a 28-year period was collected.Which of the following would be the most appropriate analysis to perform?

SCENARIO 18-10 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), the number of years of education received (Edu), the number of years at the previous job (Job Yr), a dummy variable for marital status (Married: 1 = married, 0 = otherwise), a dummy variable for head of household (Head: 1 = yes, 0 = no)and a dummy variable for management position (Manager: 1 = yes, 0 = no).We shall call this Model 1.The coefficient of partial determination of each of the 6 predictors are, respectively, 0.2807, 0.0386, 0.0317, 0.0141, 0.0958, and 0.1201. Model 2 is the regression analysis where the dependent variable is Unemploy and the independent variables are Age and Manager.The results of the regression analysis are given below: -Referring to Scenario 18-10 Model 1, 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?

A political pollster randomly selects a sample of 100 voters each day for 8 successive days and asks how many will vote for the incumbent.The pollster wishes to see if the percentage favoring the incumbent candidate is too erratic.Which of the following would be the most appropriate analysis to perform?

SCENARIO 18-3 A financial analyst wanted to examine the relationship between salary (in $1,000)and 4 variables: age ( = Age), experience in the field ( = Exper), number of degrees ( = Degrees), and number of previous jobs in the field ( = Prevjobs).He took a sample of 20 employees and obtained the following Microsoft Excel output: SUMMARY OUTPUT -Referring to Scenario 18-3, the analyst wants to use a t test to test for the significance of the coefficient of .At a level of significance of 0.01, the department head would decide that .