Exam 18: A Roadmap for Analyzing Data

Private colleges and universities rely on money contributed by individuals and corporations for their operating expenses.Much of this money is put into a fund called an endowment,and the college spends only the interest earned by the fund.A recent survey of 8 private colleges in the United States collected information on the endowment amount.Based on this information,which of the following will you construct to learn about the mean endowment of all private colleges in the United States?

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 Y = % Passing as the dependent variable, X₁ =% Attendance, X ₂ = Salaries and X₃ = Spending: -Referring to Scenario 18-8,which of the following is the correct null hypothesis to test whether instructional spending per pupil has any effect on percentage of students passing the proficiency test,considering the effect of all the other independent variables?

It was believed that the probability of a small business that declared bankruptcy per month was the same in any month.Also,the number of small businesses that declared bankruptcy was the same every month.Which of the following distributions would you use to determine the probability that more than 3 bankruptcies will occur next month?

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 Y = % Passing as the dependent variable, X₁ =% Attendance, X ₂ = Salaries and X₃ = Spending: -Referring to Scenario 18-8,the alternative hypothesis H₁ : At least one of $\beta$ _j $\neq$ 0 for j = 1,2,3 implies that percentage of students passing the proficiency test is related to all of the 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-10 Model 1,what are the numerator and denominator degrees of freedom,respectively,for 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 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?

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?

A professor of economics at a small Texas university wanted to determine what year in school students were taking his tough economics course.Data were collected on the class status ("freshman","sophomore","junior" or "senior")of 50 students enrolled in one of his economics courses.A side-by-side bar chart can be used to present this information.

Suppose that past history shows that 60% of college students prefer Coca-Cola.A sample of 10 students is to be selected.Which of the following distributions would you use to figure out the probability that at least half of them will prefer Coca-Cola?

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 Y = % Passing as the dependent variable, X₁ =% Attendance, X ₂ = Salaries and X₃ = Spending: -Referring to Scenario 18-8,the null hypothesis should be rejected at a 5% level of significance when testing whether instructional spending per pupil has any effect on percentage of students passing the proficiency test,considering the effect of all the other independent variables.

SCENARIO 18-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. The various residual plots are as shown below. The coefficient of partial determination ( R² _{yj.(All variables except j )} )of each of the 5 predictors are, respectively,0.0380,0.4376,0.0248,0.0188,and 0.0312. The coefficient of multiple determination for the regression model using each of the 5 variables X _j as the dependent variable and all other X variables as independent variables ( R² _j )are,respectively, 0.7461,0.5676,0.6764,0.8582,0.6632. -Referring to Scenario 18-9,the errors (residuals)appear to be right-skewed.

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 Y_i = $\alpha$ + $\beta$ ₁ X_1i + $\beta$ ₂ X _2i + $\beta$ ₃ X _3i + $\varepsilon$ where Y is the meter price X₁ is the number of blocks to the quad X₂ is a dummy variable that takes the value 1 if the meter is located in downtown and off campus and the value 0 otherwise X₃ 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-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: -Referring to Scenario 18-5,to test the significance of the multiple regression model,what is the form of the null hypothesis?

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

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.He has also found out special types do have an impact on average charges.Which of the following tests will be the most appropriate to find out which primary specialty has the highest charges?

If a 95% confidence interval for a multiple regression parameter includes 0,there is insufficient evidence to conclude the coefficient contributes significantly to the model.

An airline wants to select a computer software package for its reservation system.Four software packages (1,2,3,and 4)are commercially available.An experiment is set up in which each package is used to make reservations for 5 randomly selected weeks and data on the number of passengers that are bumped over a month are collected.(A total of 20 weeks was included in the experiment. )The variance on the number of passengers that are bumped is found to be roughly the same for the 4 packages.Which of the following tests will be the most appropriate to find out if the mean number of passengers being bumped over a month is the same across the 4 packages?

SCENARIO 18-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: -Referring to Scenario 18-5,the proportion of the total variability in insurance premiums that can be explained by AGE,TICKETS,and DENSITY is .

SCENARIO 18-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. The various residual plots are as shown below. The coefficient of partial determination ( R² _{yj.(All variables except j )} )of each of the 5 predictors are, respectively,0.0380,0.4376,0.0248,0.0188,and 0.0312. The coefficient of multiple determination for the regression model using each of the 5 variables X _j as the dependent variable and all other X variables as independent variables ( R² _j )are,respectively, 0.7461,0.5676,0.6764,0.8582,0.6632. -Referring to Scenario 18-9,what is the p-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?

SCENARIO 18-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. The various residual plots are as shown below. The coefficient of partial determination ( R² _{yj.(All variables except j )} )of each of the 5 predictors are, respectively,0.0380,0.4376,0.0248,0.0188,and 0.0312. The coefficient of multiple determination for the regression model using each of the 5 variables X _j as the dependent variable and all other X variables as independent variables ( R² _j )are,respectively, 0.7461,0.5676,0.6764,0.8582,0.6632. -Referring to Scenario 18-9,what is the correct interpretation for the estimated coefficient for MPG?