Concept explainers
The data sets in the first three problems are unrealistically small to allow you to practice the computational routines presented in this chapter. Most problems use SPSS.
In problem 12.1, data regarding voter turnout in five cities was presented. For the sake of convenience, the data for three of the variables arc presented again here along with
City | Turnout | Unemployment Rate | % Negative Ads | |
A | 55 | 5 | 60 | |
B | 60 | 8 | 63 | |
C | 65 | 9 | 55 | |
D | 68 | 9 | 53 | |
E | 70 | 10 | 48 | |
|
63.6 | 8.2 | 55.8 | |
|
5.5 | 1.7 | 5.3 | |
Unemployment Rate |
Negative Ads | |||
Turnout | 0.95 |
|
||
Unemployment rate |
|
|||
a. Compute the partial
b. Compute the partial correlation coefficient for the relationship between turnout
c. Find the unstandardized multiple regression equation with unemployment
d. Compute beta-weights for each independent variable. Which has the stronger impact on turnout? (HINT: Use Formulas 13. 7 and 13.8 to calculate the beta-weights.)
e. Compute the coefficient of multiple determination
f. Write a paragraph summarizing your conclusions about the relationships among these three variables.
(a)
To find:
The partial correlation coefficient between turnout and unemployment while controlling for the effect of negative advertising.
Answer to Problem 13.1P
Solution:
The partial correlation coefficient between turnout and unemployment while controlling for the effect of negative advertising is 0.97 and the relationship between turnout and unemployment rate is direct.
Explanation of Solution
Given:
The correlation matrix is given in the table below,
Unemployment Rate |
Negative Ads |
|
Turnout |
0.95 | |
Unemployment rate |
Formula used:
The formula to calculate the first order partial correlation is given by,
Where,
Calculation:
From the given correlation matrix, the zero order correlations are,
And,
Substitute 0.95 for
Simplify further,
The first order partial correlation
Conclusion:
Therefore, the partial correlation coefficient between turnout and unemployment while controlling for the effect of negative advertising is 0.97 and the relationship between turnout and unemployment rate is direct.
(b)
To find:
The partial correlation coefficient between turnout and negative ads while controlling for the effect of unemployment.
Answer to Problem 13.1P
Solution:
The partial correlation coefficient between turnout and negative ads while controlling for the effect of unemployment is
Explanation of Solution
Given:
The correlation matrix is given in the table below,
Unemployment Rate |
Negative Ads |
|
Turnout |
0.95 | |
Unemployment rate |
Formula used:
The formula to calculate the first order partial correlation is given by,
Where,
Calculation:
From the given correlation matrix, the zero order correlations are,
And,
Substitute
Simplify further,
The first order partial correlation
Conclusion:
Therefore, the partial correlation coefficient between turnout and negative ads while controlling for the effect of unemployment is
(c)
To find:
The unstandardized multiple regression equation with unemployment
Answer to Problem 13.1P
Solution:
The unstandardized multiple regression equation with unemployment
Explanation of Solution
Given:
The correlation matrix is given in the table below,
Unemployment Rate |
Negative Ads |
|
Turnout |
0.95 | |
Unemployment rate |
The descriptive statistics is given in the table below,
Turnout |
Unemployment Rate |
% Negative Ads |
|
63.6 | 8.2 | 55.8 | |
5.5 | 1.7 | 5.3 |
Formula used:
The formula to calculate the partial slopes for the independent variables is given by,
And,
Where,
The least square multiple regression line is given by,
The formula to calculate the
Calculation:
From the given information,
The formula for partial slopes of unemployment rate is given by,
Substitute 5.5 for
The formula for partial slopes of negative ads is given by,
Substitute 5.5 for
The formula to calculate the
From equation
The least square multiple regression line is given by,
From equation
For predicted value of
Thus, the unstandardized multiple regression equation with unemployment
Conclusion:
Therefore, the unstandardized multiple regression equation with unemployment
(d)
To find:
The beta weights for each given independent variable and the variable with the stronger impact on turnout.
Answer to Problem 13.1P
Solution:
The beta weight for unemployment rate is 0.6676 and for negative ads is
Explanation of Solution
Given:
The correlation matrix is given in the table below,
Unemployment Rate |
Negative Ads |
|
Turnout |
0.95 | |
Unemployment rate |
The descriptive statistics is given in the table below,
Turnout |
Unemployment Rate |
% Negative Ads |
|
63.6 | 8.2 | 55.8 | |
5.5 | 1.7 | 5.3 |
Formula used:
The formula to calculate the beta weights for two independent variables is given by,
And,
Where,
Calculation:
From the given information and part
The formula to calculate the beta weights for unemployment rate is given by,
Substitute 5.5 for
The formula to calculate the beta weights for negative ads is given by,
Substitute 5.5 for
Compare the beta weights, the unemployment rate has the stronger effect than the negative ads on turnouts, the net effect of the first independent variable after controlling the effect of negative ads is positive, while the net effect of second independent variable is negative.
Conclusion:
Therefore, the beta weight for unemployment rate is 0.6676 and for negative ads is
(e)
To find:
The coefficient of multiple determination.
Answer to Problem 13.1P
Solution:
The coefficient of multiple determination is 0.985 and 98.5% of the variance in voter turnout is explained by the two independent variables combined.
Explanation of Solution
Given:
The correlation matrix is given in the table below,
Unemployment Rate |
Negative Ads |
|
Turnout |
0.95 | |
Unemployment rate |
The descriptive statistics is given in the table below,
Turnout |
Unemployment Rate |
% Negative Ads |
|
63.6 | 8.2 | 55.8 | |
5.5 | 1.7 | 5.3 |
Formula used:
The formula to calculate the coefficient of multiple determination is given by,
Where,
Calculation:
From the given information and part
The formula to calculate the coefficient of multiple determination is given by,
Substitute 0.95 for
Thus, 98.5% of the variance in voter turnout is explained by the two independent variables combined.
Conclusion:
Therefore, the coefficient of multiple determination is 0.985 and 98.5% of the variance in voter turnout is explained by the two independent variables combined.
(f)
To explain:
The relationship among the given three variables.
Answer to Problem 13.1P
Solution:
The variation explained between turnout and unemployment rate while controlling for negative advertising is 95%. The variation explained between turnout and negative advertising while controlling for unemployment is in negative 89%, but 98.5% of the variance in voter turnout is explained by unemployment rate and negative ads combined.
Explanation of Solution
Given:
The correlation matrix is given in the table below,
Unemployment Rate |
Negative Ads |
|
Turnout |
0.95 | |
Unemployment rate |
The descriptive statistics is given in the table below,
Turnout |
Unemployment Rate |
% Negative Ads |
|
63.6 | 8.2 | 55.8 | |
5.5 | 1.7 | 5.3 |
Approach:
The variation explained between turnout and unemployment rate while controlling for negative advertising is 95%. The variation explained between turnout and negative advertising while controlling for unemployment is in negative 89%, but 98.5% of the variance in voter turnout is explained by unemployment rate and negative ads combined.
Want to see more full solutions like this?
- Please answer the questions using the data in Table 8. (Note: You must use either Microsoft Excel or Minitab for this problem and include the table they produce with your work.) Questions 8A to 8C Table 8. Data for problem 8. I2 18.7 18.7 I1 9.2 9.3 9.6 9.0 11.7 8.2 11.0 10.0 10.5 8.7 18.1 21.3 21.1 19.7 19.7 19.5 16.4 19.7 13 27.4 23.8 38.1 32.4 24.6 27.0 25.0 27.5 26.3 43.1 80.6 62.8 137.3 94.8 62.0 72.6 68.2 79.5 86.9 154.1 8A. Use technology to find the multiple regression equation for the data shown in Table 8. (Note: You must use either Microsoft Excel or Minitab for this problem and include the table the app produces with your work to get full score.) 8B. Find the standard error of estimate and interpret the result. 8C. Find the coefficient of determination and interpret the result. (Note: do not use the adjusted R-square.)arrow_forwardThe business problem facing the director of broadcasting operations for a television station was the issue of standby hours and what factors were related to standby hours. The study included the following variables:Standby hours (Y) –Total number of standby hours in a week weekly staff count (X1) –Weekly total of people-days. Remote engineering hours (X2) –Total number of engineering hours worked by employees at locations away from the central plant data were collected for 26 weeks. These data are organized and stored in. A)Interpret the meaning of the coefficients b1and b2 in this problem B)What is the significance of b0? C)Predict the mean standby hours for a week in which the weekly staff count was 310 people-days and the remote-engineering hours total was 400 Standby_hours_(Y) Total_Staff_Present(X1) Remote_Hours_(X2) 247 338 414 177 333 600 269 358 656 211 372 631 196 337 528 135 289 419 195 334 382 118 293 399 116 325 343 147 311 338 154 304 353 146 312…arrow_forwardThe business problem facing the director of broadcasting operations for a television station was the issue of standby hours and what factors were related to standby hours. The study included the following variables: Standby hours (Y) – Total number of standby hours in a week Weekly staff count (X1) – Weekly total of people-days Remote engineering hours (X2) – Total number of engineering hours worked by employees at locations away from the central plant Data were collected for 26 weeks. (See image attached) A)Interpret the meaning of the coefficients b1 and b2 in this problem B) What is the significance of b0? C) Predict the mean standby hours for a week in which the weekly staff count was 310 people-days and the remote-engineering hours total was 400arrow_forward
- Problem 1. During your spring break you decided to take a fishing trip. You caught and released two different types of bass. For each fish, you recorded its weight as in the following table. Florida Bass Weight in lbs. 6.8 7.2 12.6 10.5 7.4 13.1 11.4 6.9 6.8 12.9 Northern Bass Weight in lbs. 6.5 7.2 6.7 6.2 8.3 6.4 8.2 12.2 10.8 6.8 Assume that weights of both the Florida bass and the Northern bass are normally distributed. Use a 0.01 significance level to test the claim of a biologist that the mean weight of the Florida bass is different from the mean weight of the Northern bass. Use the following steps: Step 1. Write the Claim, Null Hypothesis and Alternative Hypothesis in symbols. Step 2. Identify Step 3. Check and identify the requirements for this test. Step 4. State the test statistic and P-value (use Excel but do not round…arrow_forwardUse the data given in the three scenarios below to produce scatter plots, determine the type of model demonstrated in each example and then answer the questions based on the graph you created. Scenario 1 Rescue 911 In a rural community, fire and paramedic crews must service a large region. They often cover 2 or 3 towns several kilometres apart. These crews travel, on average, 70 km/h to their destination. The Chief of Station 42 wants to determine the time required to reach the patient's home (response time) for his region. The station is located next to the local hospital. The Chief knows the distances to each community that he services, including Deerborn, the furthest community, at 55 km away. Using the data below, create a scatter plot showing the relationship between distance to patient and response time. Distance to Patient (km) Response Time (minutes) 10 8.6 15 12.9 40 34.3 50 42.9 55 47.1arrow_forwardCan you assit me with this problem 13 by showing me the process step by step. I prefer it not be in the form of an excel sheet because it is hard to follow along. Thank you kindlyarrow_forward
- Problem 4. Suppose we use the GSS data to examine the relationship between education attainment (RDEGREE: 0 = less than high school, 1 = high school degree, 2 = some college or more) and the variable HELPPOOR, which measures support for the statement that the government should do everything possible to improve the standard of living of all poor Americans (see table below). Less than HS degree High school degree Some college or more Total Should government improve standard of living? 1 = Government action 30 65 32 127 2 6 32 41 79 3 = Agree with both 32 153 126 311 4 6 56 58 120 5 = People help selves 14 69 35 118 Total 88 375 292 755 Use the procedure we learned in class to calculate the value of Chi-square. Present the expected values for each cell in a table. Then, report the value Chi-square value. Using an alpha of 0.05, do you reject the…arrow_forwardQuestion 1 Stopping Distances In a study on speed control, it was found that the main reasons for regulations were to make traffic flow more efficient and to minimize the risk of danger. An area that was focused on in the study was the distance required to completely stop a vehicle at various speeds. Use the following tables to answer the questions. MPH BRAKING DISTANCES (FEET) 20 20 30 45 40 81 50 133 60 205 80 411 Assume MPH is going to be used to predict stopping distance. Calculate the correlation coefficient ‘r’ for these values. What does a correlation coefficient tell about the relationship between two variables? Within what range can a correlation coefficient assume a value. Will you expect a positive, negative or zero correlation between the two variables for each of the following examples Variables Type of Correlation Grade of a student and hours spent studying Incomes and entertainment expenditures of…arrow_forwardProvide a graphical display of respondent marital status (MARITAL), where: 1 = Married; 2 = Widowed; 3 = Divorced; 4 = Separated; 5 = Never married. Can you tell me the steps to do this in excel and the formulas to use, as I cannot share the actual excel spreadsheet with the data here.arrow_forward
- Problem B30 students were given a two-hour exam and their scores were determined. After the exam, the students were subjected to a 30-minute physical exercise and then took another two-hour exam. 1. Identify the variables and their data types. Indicate whether independent or dependent.2. Identify the t-test to be used.arrow_forwardProblem 3: North America Airlines maintains an extensive inventory of wing flaps. The number of wing flaps needed to replace damaged wing flaps each month depends partially on the number of flying hours for the fleet that month. Flying 162 149 185 171 138 154 Hours (1000s) Number 12 13 14 10 11 of Wing Flaps 1. Determine the number of wing flaps needed for 150,000 flying hours. 2. Is the regression model a good model? Why?arrow_forwardQuestion 1 Stopping Distances In a study on speed control, it was found that the main reasons for regulations were to make traffic flow more efficient and to minimize the risk of danger. An area that was focused on in the study was the distance required to completely stop a vehicle at various speeds. Use the following tables to answer the questions. MPH BRAKING DISTANCES (FEET) 20 20 30 45 40 81 50 133 60 205 80 411 Assume MPH is going to be used to predict stopping distance. Develop the regression equation for the sample. Can braking distance be accurately predicted from MPH? Estimate the breaking distance if a motor vehicle is travelling at 35 MPH and 76 MPH.arrow_forward
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman