Exam 17: Getting Ready to Analyze Data
Exam 1: Defining and Collecting Data202 Questions
Exam 2: Organizing and Visualizing256 Questions
Exam 3: Numerical Descriptive Measures217 Questions
Exam 4: Basic Probability167 Questions
Exam 5: Discrete Probability Distributions165 Questions
Exam 6: The Normal Distribution and Other Continuous Distributions170 Questions
Exam 7: Sampling Distributions165 Questions
Exam 8: Confidence Interval Estimation219 Questions
Exam 9: Fundamentals of Hypothesis Testing: One-Sample Tests194 Questions
Exam 10: Two-Sample Tests240 Questions
Exam 11: Analysis of Variance170 Questions
Exam 12: Chi-Square and Nonparametric188 Questions
Exam 13: Simple Linear Regression243 Questions
Exam 14: Introduction to Multiple394 Questions
Exam 15: Multiple Regression146 Questions
Exam 16: Time-Series Forecasting235 Questions
Exam 17: Getting Ready to Analyze Data386 Questions
Exam 18: Statistical Applications in Quality Management159 Questions
Exam 19: Decision Making126 Questions
Exam 20: Probability and Combinatorics421 Questions
Select questions type
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: married, otherwise), a dummy variable for head of household (Head: yes, no) and a dummy variable for management position (Manager: yes, no). We shall call this Model 1. The coefficient of partial determination ( (All raiables excopt ) ) of each of the 6 predictors are, respectively, , , and .
Regression Statistics Multiple R 0.7035 R Square 0.4949 Adjusted R 0.4030 Square Standard 18.4861 Error Observations 40
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, we can conclude that, holding constant the
effect of the other independent variables, the number of years of education received has no impact
on the mean number of weeks a worker is unemployed due to a layoff at a 1% level of
significance if all we have is the information of the 95% confidence interval estimate for?2 .
(True/False)
4.8/5
(96)
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 regression sum of squares that is missing in the ANOVA table
should be ______.
(Short Answer)
4.9/5
(81)
SCENARIO 17-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 (Atitude 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 17-12, which of the following is the correct expression for the estimated model? a) Income LawnSize Atitude Teenager Age
b) = -70.49+0.2868 Income +1.0647 LawnSize -12.744 Atitude -0.200 Teenager +1.0792 Age
c) odds ratio Income LawnSize Atitude Teenager Age
d) estimated odds ratio) Income LawnSize Atitude Teenager Age
(Short Answer)
4.8/5
(65)
Suppose the probability of a power outage at a nuclear power plant on a single day is the same every day of the year. Also the probability of having a power outage on a single day does not
Increase or decrease the probability of a power outage on another day. Which of the following
Distributions would you use to determine the probability that a power outage will occur next
Monday?
(Multiple Choice)
4.8/5
(89)
The probability that a particular brand of smoke alarm will function properly and sound an alarm in the presence of smoke is 0.8. You have 5 such alarms in your home and they operate
Independently. Which of the following distributions would you use to determine the probability
That all of them will function properly in case of a fire?
(Multiple Choice)
4.7/5
(72)
Some business analytics involve starting with many variables, followed by filtering
the data by exploring specific combinations of categorical values or numerical range. In Excel, this
approach is mimicked by using a drill-down.
(True/False)
4.8/5
(75)
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 HP
makes a significant contribution to the regression model in the presence of the other independent
variables at a 5% level of significance?
(Short Answer)
4.8/5
(92)
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: married, otherwise), a dummy variable for head of household (Head: yes, no) and a dummy variable for management position (Manager: yes, no). We shall call this Model 1. The coefficient of partial determination ( (All raiables excopt ) ) of each of the 6 predictors are, respectively, , , and .
Regression Statistics Multiple R 0.7035 R Square 0.4949 Adjusted R 0.4030 Square Standard 18.4861 Error Observations 40
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, 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 all the other independent variables at a 10% level of significance.
(True/False)
4.9/5
(81)
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: married, otherwise), a dummy variable for head of household (Head: yes, no) and a dummy variable for management position (Manager: yes, no). We shall call this Model 1. The coefficient of partial determination ( (All raiables excopt ) ) of each of the 6 predictors are, respectively, , , and .
Regression Statistics Multiple R 0.7035 R Square 0.4949 Adjusted R 0.4030 Square Standard 18.4861 Error Observations 40
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 and using both Model 1 and Model 2, what are the null and
alternative hypotheses for testing whether the independent variables that are not significant
individually are also not significant as a group in explaining the variation in the dependent
variable at a 5% level of significance?
(Essay)
4.8/5
(79)
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, the first split occurs at what price?
(Short Answer)
4.8/5
(80)
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: married, otherwise), a dummy variable for head of household (Head: yes, no) and a dummy variable for management position (Manager: yes, no). We shall call this Model 1. The coefficient of partial determination ( (All raiables excopt ) ) of each of the 6 predictors are, respectively, , , and .
Regression Statistics Multiple R 0.7035 R Square 0.4949 Adjusted R 0.4030 Square Standard 18.4861 Error Observations 40
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 and using both Model 1 and Model 2, what is the p-value of the
test statistic for testing whether the independent variables that are not significant individually are
also not significant as a group in explaining the variation in the dependent variable at a 5% level
of significance?
(Essay)
4.8/5
(82)
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, there is enough evidence to conclude that MPG
makes a significant contribution to the regression model in the presence of the other independent
variables at a 5% level of significance.
(True/False)
4.7/5
(82)
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: married, otherwise), a dummy variable for head of household (Head: yes, no) and a dummy variable for management position (Manager: yes, no). We shall call this Model 1. The coefficient of partial determination ( (All raiables excopt ) ) of each of the 6 predictors are, respectively, , , and .
Regression Statistics Multiple R 0.7035 R Square 0.4949 Adjusted R 0.4030 Square Standard 18.4861 Error Observations 40
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, what is the p-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?
(Short Answer)
4.9/5
(75)
SCENARIO 17-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
Regression Statistics
Multiple R 0.865 R Square 0.748 Adjusted R Square 0.726 Standard Error 5.195 Observations 50
ANOVA
df SS MS F Signif F Regression 3605.7736 1201.9245 0.0000 Residual 1214.2264 26.3962 Total 49 4820.0000
Coeff StdError t Stat P -value Intercept -1.6335 5.8078 -0.281 0.7798 Income 0.4485 0.1137 3.9545 0.0003 Size 4.2615 0.8062 5.286 0.0001 School -0.6517 0.4319 -1.509 0.1383
-Referring to Scenario 17-1, what fraction of the variability in house size is explained by income, size of family, and education?
(Multiple Choice)
4.8/5
(83)
SCENARIO 17-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 Passing as the dependent variable, Attendance, Salaries and Spending:
Regression Statistics Multiple R 0.7930 R Square 0.6288 Adjusted R 0.6029 Square Standard 10.4570 Error Observations 47
ANOVA
Coefficients Standard Error t Stat P-value Lower 95\% Upper 95\% Intercept -753.4225 101.1149 -7.4511 0.0000 -957.3401 -549.5050 \% Attendance 8.5014 1.0771 7.8929 0.0000 6.3292 10.6735 Salary 0.000000685 0.0006 0.0011 0.9991 -0.0013 0.0013 Spending 0.0060 0.0046 1.2879 0.2047 -0.0034 0.0153
-Referring to Scenario 17-8, the alternative hypothesis ,
3 implies that percentage of students passing the proficiency test is related to at least one of the
explanatory variables.
(True/False)
4.8/5
(71)
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 p-value of the test statistic to determine whether Cargo
Vol makes a significant contribution to the regression model in the presence of the other
independent variables at a 5% level of significance?
(Short Answer)
4.8/5
(77)
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: married, otherwise), a dummy variable for head of household (Head: yes, no) and a dummy variable for management position (Manager: yes, no). We shall call this Model 1. The coefficient of partial determination ( (All raiables excopt ) ) of each of the 6 predictors are, respectively, , , and .
Regression Statistics Multiple R 0.7035 R Square 0.4949 Adjusted R 0.4030 Square Standard 18.4861 Error Observations 40
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 and using both Model 1 and Model 2, there is
insufficient evidence to conclude that the independent variables that are not significant
individually are significant as a group in explaining the variation in the dependent variable at a
5% level of significance?
(True/False)
4.9/5
(80)
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: married, otherwise), a dummy variable for head of household (Head: yes, no) and a dummy variable for management position (Manager: yes, no). We shall call this Model 1. The coefficient of partial determination ( (All raiables excopt ) ) of each of the 6 predictors are, respectively, , , and .
Regression Statistics Multiple R 0.7035 R Square 0.4949 Adjusted R 0.4030 Square Standard 18.4861 Error Observations 40
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 after
taking into consideration the number of independent variables and the number of observations.
(Short Answer)
4.9/5
(75)
SCENARIO 17-6
A weight-loss clinic wants to use regression analysis to build a model for weight-loss of a client
(measured in pounds). Two variables thought to affect weight-loss are client's length of time on the
weight loss program and time of session. These variables are described below: Y = Weight-loss (in pounds) = Length of time in weight-loss program (in months) =1 if morning session, 0 if not =1 if afternoon session, 0 if not (Base level = evening session)
Data for 12 clients on a weight-loss program at the clinic were collected and used to fit the interaction model:
Partial output from Microsoft Excel follows:
Regression Statistics Multiple R 0.73514 R Square 0.540438 Adjusted R Square 0.157469 Standard Error 12.4147 Observations 12
Coeff StdError t Stat P -value Intercept 0.089744 14.127 0.0060 0.9951 Length 6.22538 2.43473 2.54956 0.0479 Morn Ses 2.217272 22.1416 0.100141 0.9235 Aft Ses 11.8233 3.1545 3.558901 0.0165 Length*Morn Ses 0.77058 3.562 0.216334 0.8359 Length"Aft Ses -0.54147 3.35988 -0.161158 0.8773
-Referring to Scenario 17-6, which of the following statements is supported by the analysis shown? a) There is sufficient evidence (at ) of curvature in the relationship between weight-loss and months in program .
b) There is sufficient evidence (at ) to indicate that the relationship between weight-loss and months in program depends on session time.
c) There is sufficient evidence (at ) to indicate that the session time (morning, afternoon, evening) affects weight-loss .
d) There is insufficient evidence (at ) to indicate that the relationship between weight-loss and months in program depends on session time.
(Short Answer)
4.8/5
(64)
A powerful women's group has claimed that men and women differ in attitudes about sexual discrimination. A group of 50 men (group 1) and 40 women (group 2) were asked if they thought
Sexual discrimination is a problem in the United States. Of those sampled, 11 of the men and 19
Of the women did believe that sexual discrimination is a problem. Which of the following tests
Will you use to find out if there is any difference in attitudes about sexual discrimination?
(Multiple Choice)
4.8/5
(70)
Showing 21 - 40 of 386
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)