Exam 17: Getting Ready to Analyze Data

SCENARIO 17-2 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 4 variables to predict heating costs: the daily minimum outside temperature in degrees of Fahrenheit $\left( X _ { 1 } \right)$ , the amount of insulation in inches $\left( X _ { 2 } \right)$ , the number of windows in the house $\left( X _ { 3 } \right)$ , and the age of the furnace in years $\left( X _ { 4 } \right)$ . Given below are the EXCEL outputs of two regression models. Model 1 Regression Statistics R Square 0.8080 Adjusted R Square 0.7568 Observations 20 $\text { ANOVA }$ df SS MS F Significance F Regression 4 169503.4241 42375.86 15.7874 0.0000 Residual 15 40262.3259 2684.155 Total 19 209765.75 Coefficients Standard Error t Stat P-value Lower 90.0\% Upper 90.0\% Intereept 421.4277 77.8614 5.4125 0.0000 284.9327 557.9227 (Temperature) -4.5098 0.8129 -5.5476 0.0000 -5.9349 -3.0847 (Insulation) -14.9029 5.0508 -2.9505 0.0099 -23.7573 -6.0485 (Windows) 0.2151 4.8675 0.0442 0.9653 -8.3181 8.7484 (Furnace Age) 6.3780 4.1026 1.5546 0.1408 -0.8140 13.5702 $\text { Model } 2$ Regression Statistics R Square 0.7768 Adjusted R Square 0.7506 Observations 20 $\text { ANOVA }$ Coefficients Standard Error t Stat P-value Lower 95\% Upper 95\% Intercept 489.3227 43.9826 11.1253 0.0000 396.5273 582.1180 (Temperature) -5.1103 0.6951 -7.3515 0.0000 -6.5769 -3.6437 (Insulation) -14.7195 4.8864 -3.0123 0.0078 -25.0290 -4.4099 -Referring to Scenario 17-2, what is the 90% confidence interval for the expected change in heating costs as a result of a 1 degree Fahrenheit change in the daily minimum outside Temperature using Model 1?

Which of the following is NOT one of the categories of predictive analytics methods?

SCENARIO 17-9 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 171 different vehicle models were collected: Accel Time: Acceleration time in sec. Cargo Vol: Cargo volume in cu. ft. HP: Horsepower MPG: Miles per gallon SUV: 1 if the vehicle model is an SUV with Coupe as the base when SUV and Sedan are both 0 Sedan: 1 if the vehicle model is a sedan with Coupe as the base when SUV and Sedan are both 0 The regression results using acceleration time as the dependent variable and the remaining variables as the independent variables are presented below. -Referring to Scenario 17-9, what is the value of the test statistic to determine whether SUV makes a significant contribution to the regression model in the presence of the other independent variables at a 5% level of significance?

Every spring semester, the School of Business coordinates with local business leaders a luncheon for graduating seniors, their families, and friends. Corporate sponsorship pays for the lunches of Each of the seniors, but students have to purchase tickets to cover the cost of lunches served to Guests they bring with them. Data on the number of guests each graduating senior invited to the Luncheon and the number of graduating seniors in each category were collected. You want to Know the most popular number of guests brought by the graduating seniors. Which of the Following will you compute?

SCENARIO 17-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 ( $R _ { \mathrm { y } } ^ { 2 }$ (All raiables excopt $j$ ) ) of each of the 6 predictors are, respectively, $0.2807$ , $0.0386,0.0317,0.0141,0.0958$ , and $0.1201$ . Regression Statistics Multiple R 0.7035 R Square 0.4949 Adjusted R 0.4030 Square Standard 18.4861 Error Observations 40 $\text { ANOVA }$ Coefficients Standard Error t Stat P-value Lower 95\% Upper 95\% Intercept 32.6595 23.18302 1.4088 0.1683 -14.5067 79.8257 Age 1.2915 0.3599 3.5883 0.0011 0.5592 2.0238 Edu -1.3537 1.1766 -1.1504 0.2582 -3.7476 1.0402 Job Yr 0.6171 0.5940 1.0389 0.3064 -0.5914 1.8257 Married -5.2189 7.6068 -0.6861 0.4974 -20.6950 10.2571 Head -14.2978 7.6479 -1.8695 0.0704 -29.8575 1.2618 Manager -24.8203 11.6932 -2.1226 0.0414 -48.6102 -1.0303 -Referring to Scenario 17-10 Model 1, which of the following is a correct statement?

SCENARIO 17-4 You decide to predict gasoline prices in different cities and towns in the United States for your term project. Your dependent variable is price of gasoline per gallon and your explanatory variables are per capita income, the number of firms that manufacture automobile parts in and around the city, the number of new business starts in the last year, population density of the city, percentage of local taxes on gasoline, and the number of people using public transportation. You collected data of 32 cities and obtained a regression sum of squares SSR= 122.8821. Your computed value of standard error of the estimate is 1.9549. -Referring to Scenario 17-4, the value of adjusted $r ^ { 2 }$ is

SCENARIO 17-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 17-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 17-15 The tree diagram below shows the results of the classification tree model that has been constructed to predict the probability of a cable company's customers who will switch ("Yes" or "No") into its bundled program offering based on the price ($30, $40, $50, $60) and whether the customer spends more than 5 hours a day watching TV ("Yes" or "No") using the data set of 100 customers collected from a survey. -Referring to Scenario 17-15, what is the highest rate of switching into the bundled offering?

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?

Data were collected on the amount of detergent used in gallons in a month by 25 drive-through car wash operations in Phoenix. You can use a time-series plot to pressing this information.

SCENARIO 17-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 ( $R _ { \mathrm { y } } ^ { 2 }$ (All raiables excopt $j$ ) ) of each of the 6 predictors are, respectively, $0.2807$ , $0.0386,0.0317,0.0141,0.0958$ , and $0.1201$ . Regression Statistics Multiple R 0.7035 R Square 0.4949 Adjusted R 0.4030 Square Standard 18.4861 Error Observations 40 $\text { ANOVA }$ Coefficients Standard Error t Stat P-value Lower 95\% Upper 95\% Intercept 32.6595 23.18302 1.4088 0.1683 -14.5067 79.8257 Age 1.2915 0.3599 3.5883 0.0011 0.5592 2.0238 Edu -1.3537 1.1766 -1.1504 0.2582 -3.7476 1.0402 Job Yr 0.6171 0.5940 1.0389 0.3064 -0.5914 1.8257 Married -5.2189 7.6068 -0.6861 0.4974 -20.6950 10.2571 Head -14.2978 7.6479 -1.8695 0.0704 -29.8575 1.2618 Manager -24.8203 11.6932 -2.1226 0.0414 -48.6102 -1.0303 -Referring to Scenario 17-10 Model 1, ________ of the variation in the number of weeks a worker is unemployed due to a layoff can be explained by the six independent variables.

SCENARIO 17-3 A financial analyst wanted to examine the relationship between salary (in $\$ 1,000$ ) and 4 variables: age $\left( X _ { 1 } = \mathrm { Age } \right)$ , experience in the field $\left( X _ { 2 } = \right.$ Exper $)$ , number of degrees $\left( X _ { 3 } = \right.$ Degrees $)$ , and number of previous jobs in the field ( $X _ { 4 } =$ Prevjobs). He took a sample of 20 employees and obtained the following Microsoft Excel output: SUMMARY OUTPUT Regression Statistics Multiple R 0.992 R Square 0.984 Adjusted R Square 0.979 Standard Error 2.26743 Observations 20 df SS MS F Signif F Regression 4 4609.83164 1152.45791 224.160 0.0001 Residual 15 77.11836 5.14122 Total 19 4686.95000 Coeff StdError Stat P-value Intercept -9.611198 2.77988638 -3.457 0.0035 Age 1.327695 0.11491930 11.553 0.0001 Exper -0.106705 0.14265559 -0.748 0.4660 Degrees 7.311332 0.80324187 9.102 0.0001 Prevjobs -0.504168 0.44771573 -1.126 0.2778 -Referring to Scenario 17-3, the value of the adjusted coefficient of multiple determination, adj $r ^ { 2 }$ , is ________.

It was believed that the probability of being hit by lightning is the same during the course of a thunderstorm. Which of the following distributions would you use to determine the probability Of being hit by a lightning during the first half of a thunderstorm?

SCENARIO 17-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 ( $R _ { \mathrm { y } } ^ { 2 }$ (All raiables excopt $j$ ) ) of each of the 6 predictors are, respectively, $0.2807$ , $0.0386,0.0317,0.0141,0.0958$ , and $0.1201$ . Regression Statistics Multiple R 0.7035 R Square 0.4949 Adjusted R 0.4030 Square Standard 18.4861 Error Observations 40 $\text { ANOVA }$ Coefficients Standard Error t Stat P-value Lower 95\% Upper 95\% Intercept 32.6595 23.18302 1.4088 0.1683 -14.5067 79.8257 Age 1.2915 0.3599 3.5883 0.0011 0.5592 2.0238 Edu -1.3537 1.1766 -1.1504 0.2582 -3.7476 1.0402 Job Yr 0.6171 0.5940 1.0389 0.3064 -0.5914 1.8257 Married -5.2189 7.6068 -0.6861 0.4974 -20.6950 10.2571 Head -14.2978 7.6479 -1.8695 0.0704 -29.8575 1.2618 Manager -24.8203 11.6932 -2.1226 0.0414 -48.6102 -1.0303 -Referring to Scenario 17-10 Model 1, ________ of the variation in the number of weeks a worker is unemployed due to a layoff can be explained by the age of the worker while controlling for the other independent variables.

SCENARIO 17-13 The table below contains the sparklines for the rates of return (in percentage) for three different stocks from 2007 to 2013. -Referring to Scenario 17-13, the sparklines enable you to conclude that the rates of return of the stock market in general is volatile from 2007 to 2013.

A physician and president of a Tampa Health Maintenance Organization (HMO) are attempting to show the benefits of managed health care to an insurance company. The physician believes that Certain types of doctors are more cost-effective than others. To investigate this, the president Obtained independent random samples of 20 HMO physicians from each of 4 primary specialties - General Practice (GP), Internal Medicine (IM), Pediatrics (PED), and Family Physicians (FP) - And recorded the total charges per member per month for each. A second variable which the President believes influences total charges per member per month is whether the doctor is a Foreign or USA medical school graduate. To investigate this, the president also collected data on 20 foreign medical school graduates in each of the 4 primary specialty types described above. So Information on charges for 40 doctors (20 foreign and 20 USA medical school graduates) was Obtained for each of the 4 specialties. The president has already found out that specialty types And origin of the medical degree do not interact to affect the charges. Which of the following Tests will be the most appropriate to find out if the primary specialty affects the charges?

SCENARIO 17-5 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, the number of traffic tickets received by the individual, and the population density of the city in which the individual lives. You performed a regression analysis in EXCEL and obtained the following information: Regression Statistics Multiple R 0.63 R Square 0.40 Adjusted R Square 0.23 Standard Error 50.00 Observations 15.00 ANOVA df SS MS F Significance F Regression 3 5994.24 2.40 0.12 Residual 11 27496.82 Total 45479.54 Coefficients Standard Error t Stat P-value Lower 99.0\% Upper 99.0\% Intercept 123.80 48.71 2.54 0.03 -27.47 275.07 AGE -0.82 0.87 -0.95 0.36 -3.51 1.87 TICKETS 21.25 10.66 1.99 0.07 -11.86 54.37 DENSITY -3.14 6.46 -0.49 0.64 -23.19 16.91 AGE -0.82 0.87 -0.95 0.36 -3.51 1.87 TICKETS 21.25 10.66 1.99 0.07 -11.86 54.37 DENSITY -3.14 6.46 -0.49 0.64 -23.19 16.91 -Referring to Scenario 17-5, the adjusted $r ^ { 2 }$ is _________.

SCENARIO 17-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 ( $R _ { \mathrm { y } } ^ { 2 }$ (All raiables excopt $j$ ) ) of each of the 6 predictors are, respectively, $0.2807$ , $0.0386,0.0317,0.0141,0.0958$ , and $0.1201$ . Regression Statistics Multiple R 0.7035 R Square 0.4949 Adjusted R 0.4030 Square Standard 18.4861 Error Observations 40 $\text { ANOVA }$ Coefficients Standard Error t Stat P-value Lower 95\% Upper 95\% Intercept 32.6595 23.18302 1.4088 0.1683 -14.5067 79.8257 Age 1.2915 0.3599 3.5883 0.0011 0.5592 2.0238 Edu -1.3537 1.1766 -1.1504 0.2582 -3.7476 1.0402 Job Yr 0.6171 0.5940 1.0389 0.3064 -0.5914 1.8257 Married -5.2189 7.6068 -0.6861 0.4974 -20.6950 10.2571 Head -14.2978 7.6479 -1.8695 0.0704 -29.8575 1.2618 Manager -24.8203 11.6932 -2.1226 0.0414 -48.6102 -1.0303 -Referring to Scenario 17-10 Model 1, the null hypothesis should be rejected at a 10% level of significance when testing 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 17-9 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 171 different vehicle models were collected: Accel Time: Acceleration time in sec. Cargo Vol: Cargo volume in cu. ft. HP: Horsepower MPG: Miles per gallon SUV: 1 if the vehicle model is an SUV with Coupe as the base when SUV and Sedan are both 0 Sedan: 1 if the vehicle model is a sedan with Coupe as the base when SUV and Sedan are both 0 The regression results using acceleration time as the dependent variable and the remaining variables as the independent variables are presented below. -Referring to Scenario 17-9, which of the following assumptions is most likely violated based on the normal probability plot?

Data on the amount of time spent studying and the exam score of 150 students at a high school were collected. You want to know if a student's exam score is linearly related to the amount of Time spent on studying. Which of the following would you compute?