Applied Statistics in Business and Economics
5th Edition
ISBN: 9781259329050
Author: DOANE
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 12.5, Problem 23SE
Instructions for exercises 12.23 and 12.24: (a) Perform a regression using MegaStat or Excel. (b) State the null and alternative hypotheses for a two-tailed test for a zero slope. (c) Report the p-value and the 95 percent confidence interval for the slope shown in the regression results. (d) Is the slope significantly different from zero? Explain your conclusion.
12.23
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Q: Using the Student Grades data posed below this question, apply the Excel Regression tool using the midterm grade as the independent variable and the final exam grade as the dependent variable. Interpret all key regression results, hypothesis tests, and confidence intervals in the output.
The hypothesis test and confidence interval you should interpret are for the slope. Include the Excel data, output, and your interpretations. Also interpret the standard error of the estimates and the R^2 coefficient.
Student Grades
Student
Midterm
Final Exam
1
76
65
2
84
90
3
79
68
4
88
84
5
76
61
6
66
79
7
77
73
8
94
93
9
66
60
10
92
86
11
80
53
12
87
83
13
86
55
14
63
72
15
92
87
16
75
89
17
69
81
18
92
94
19
79
78
20
60
71
21
68
84
22
71
74
23
61
74
24
68
54
25
76
94
26
72
79
27
99
89
28
58
53
29
82
78
30
72
82
31
77
69
32
95
98
33
72
93
34
71
80
35
72
82
36
96
96
37
72
61
38
89
84
39
94
97
40
85
89…
What is the null hypothesis to test the significance of the slope in a regression equation?
Multiple Choice
Ho:B 20
Ho: Bs0
O Ho: B = 0
Ho: B 0
Use the shoe print lengths and heights shown below to find the regression equation, letting shoe print lengths be the predictor (x) variable. Then find the best predicted height of a male who has a shoe print length of
28.5
cm. Would the result be helpful to police crime scene investigators in trying to describe the male? Use a significance level of
α=0.05.
Shoe Print (cm)
29.1
29.1
31.8
31.9
27.5
Foot Length (cm)
25.7
25.4
27.9
26.7
25.1
Height (cm)
175.4
177.8
185.2
175.4
173.2
The best predicted height is
enter your response here
cm.
(Round to two decimal places as needed.)
Would the result be helpful?
A.
No, because the description would be the same regardless of shoe print length.
B.
Yes, because the description would be based on an actual shoe print length.
C.
Yes, because the correlation is strong, so the predicted…
Chapter 12 Solutions
Applied Statistics in Business and Economics
Ch. 12.1 - Prob. 1SECh. 12.1 - Prob. 2SECh. 12.1 - Prob. 3SECh. 12.1 - Prob. 4SECh. 12.1 - Prob. 5SECh. 12.1 - Prob. 6SECh. 12.2 - (a) Interpret the slope of the fitted regression...Ch. 12.2 - (a) Interpret the slope of the fitted regression...Ch. 12.2 - Prob. 9SECh. 12.2 - (a) Interpret the slope of the fitted regression...
Ch. 12.2 - (a) Interpret the slope of the fitted regression...Ch. 12.3 - Prob. 12SECh. 12.3 - Prob. 13SECh. 12.3 - The regression equation Credits = 15.4 .07 Work...Ch. 12.3 - Below are fitted regressions for Y = asking price...Ch. 12.3 - Refer back to the regression equation in exercise...Ch. 12.3 - Refer back to the regression equation in exercise...Ch. 12.4 - Instructions for exercises 12.18 and 12.19: (a)...Ch. 12.4 - Instructions for exercises 12.18 and 12.19: (a)...Ch. 12.4 - Instructions for exercises 12.2012.22: (a) Use...Ch. 12.4 - Instructions for exercises 12.2012.22: (a) Use...Ch. 12.4 - Instructions for exercises 12.2012.22: (a) Use...Ch. 12.5 - Instructions for exercises 12.23 and 12.24: (a)...Ch. 12.5 - Prob. 24SECh. 12.5 - A regression was performed using data on 32 NFL...Ch. 12.5 - A regression was performed using data on 16...Ch. 12.6 - Prob. 27SECh. 12.6 - Prob. 28SECh. 12.6 - Instructions for exercises 12.2912.31: (a) Use...Ch. 12.6 - Instructions for exercises 12.2912.31: (a) Use...Ch. 12.6 - Instructions for exercises 12.2912.31: (a) Use...Ch. 12.7 - Refer to the Weekly Earnings data set below. (a)...Ch. 12.7 - Prob. 33SECh. 12.8 - Prob. 34SECh. 12.8 - Prob. 35SECh. 12.9 - An estimated regression for a random sample of...Ch. 12.9 - An estimated regression for a random sample of...Ch. 12.9 - Prob. 38SECh. 12.9 - Prob. 39SECh. 12 - (a) How does correlation analysis differ from...Ch. 12 - (a) What is a simple regression model? (b) State...Ch. 12 - (a) Explain how you fit a regression to an Excel...Ch. 12 - (a) Explain the logic of the ordinary least...Ch. 12 - (a) Why cant we use the sum of the residuals to...Ch. 12 - Prob. 6CRCh. 12 - Prob. 7CRCh. 12 - Prob. 8CRCh. 12 - Prob. 9CRCh. 12 - Prob. 10CRCh. 12 - Prob. 11CRCh. 12 - Prob. 12CRCh. 12 - (a) What is heteroscedasticity? Identify its two...Ch. 12 - (a) What is autocorrelation? Identify two main...Ch. 12 - Prob. 15CRCh. 12 - Prob. 16CRCh. 12 - (a) What is a log transform? (b) What are its...Ch. 12 - Prob. 40CECh. 12 - Prob. 41CECh. 12 - Prob. 42CECh. 12 - Prob. 43CECh. 12 - Prob. 44CECh. 12 - Prob. 45CECh. 12 - Prob. 46CECh. 12 - Prob. 47CECh. 12 - Prob. 48CECh. 12 - Prob. 49CECh. 12 - Prob. 50CECh. 12 - Prob. 51CECh. 12 - Prob. 52CECh. 12 - Prob. 53CECh. 12 - Prob. 54CECh. 12 - Prob. 55CECh. 12 - Prob. 56CECh. 12 - Prob. 57CECh. 12 - Prob. 58CECh. 12 - Prob. 59CECh. 12 - In the following regression, X = weekly pay, Y =...Ch. 12 - Prob. 61CECh. 12 - In the following regression, X = total assets (...Ch. 12 - Prob. 63CECh. 12 - Below are percentages for annual sales growth and...Ch. 12 - Prob. 65CECh. 12 - Prob. 66CECh. 12 - Prob. 67CECh. 12 - Simple regression was employed to establish the...Ch. 12 - Prob. 69CECh. 12 - Prob. 70CECh. 12 - Prob. 71CECh. 12 - Below are revenue and profit (both in billions)...Ch. 12 - Below are fitted regressions based on used vehicle...Ch. 12 - Below are results of a regression of Y = average...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- Life Expectancy The following table shows the average life expectancy, in years, of a child born in the given year42 Life expectancy 2005 77.6 2007 78.1 2009 78.5 2011 78.7 2013 78.8 a. Find the equation of the regression line, and explain the meaning of its slope. b. Plot the data points and the regression line. c. Explain in practical terms the meaning of the slope of the regression line. d. Based on the trend of the regression line, what do you predict as the life expectancy of a child born in 2019? e. Based on the trend of the regression line, what do you predict as the life expectancy of a child born in 1580?2300arrow_forwardFind the equation of the regression line for the following data set. x 1 2 3 y 0 3 4arrow_forwardOlympic Pole Vault The graph in Figure 7 indicates that in recent years the winning Olympic men’s pole vault height has fallen below the value predicted by the regression line in Example 2. This might have occurred because when the pole vault was a new event there was much room for improvement in vaulters’ performances, whereas now even the best training can produce only incremental advances. Let’s see whether concentrating on more recent results gives a better predictor of future records. (a) Use the data in Table 2 (page 176) to complete the table of winning pole vault heights shown in the margin. (Note that we are using x=0 to correspond to the year 1972, where this restricted data set begins.) (b) Find the regression line for the data in part ‚(a). (c) Plot the data and the regression line on the same axes. Does the regression line seem to provide a good model for the data? (d) What does the regression line predict as the winning pole vault height for the 2012 Olympics? Compare this predicted value to the actual 2012 winning height of 5.97 m, as described on page 177. Has this new regression line provided a better prediction than the line in Example 2?arrow_forward
- XYZ Corporation Stock Prices The following table shows the average stock price, in dollars, of XYZ Corporation in the given month. Month Stock price January 2011 43.71 February 2011 44.22 March 2011 44.44 April 2011 45.17 May 2011 45.97 a. Find the equation of the regression line. Round the regression coefficients to three decimal places. b. Plot the data points and the regression line. c. Explain in practical terms the meaning of the slope of the regression line. d. Based on the trend of the regression line, what do you predict the stock price to be in January 2012? January 2013?arrow_forwardFor the following exercises, use Table 4 which shows the percent of unemployed persons 25 years or older who are college graduates in a particular city, by year. Based on the set of data given in Table 5, calculate the regression line using a calculator or other technology tool, and determine the correlation coefficient. Round to three decimal places of accuracyarrow_forwardNoise and Intelligibility Audiologists study the intelligibility of spoken sentences under different noise levels. Intelligibility, the MRT score, is measured as the percent of a spoken sentence that the listener can decipher at a cesl4ain noise level in decibels (dB). The table shows the results of one such test. (a) Make a scatter plot of the data. (b) Find and graph the regression line. (c) Find the correlation coefficient. Is a linear model appropriate? (d) Use the linear model in put (b) to estimate the intelligibility of a sentence at a 94-dB noise level.arrow_forward
- Help with: Draw a scatter diagram of the data, treating age as the explanatory variable. What type of relation, if any, appears to exist between age and HDL cholesterol? Determine the least-squares regression equation from the sample data Assuming the residuals are normally distributed, test whether a linear relation exists between age and HDL cholesterol levels at the α=0.01 level of significance. What are the null and alternative hypotheses? What is the P Value: What conclusion can be drawn at α=0.01 level of significance? Assuming the residuals are normally distributed, construct a 95% confidence interval about the slope of the true least-squares regression line. Lower bound Upper bound For a 42-year-old male patient who visits the doctor's office, would using the least-squares regression line obtained in part (b) to predict the HDL cholesterol of this patient be recommended? A good estimate for the HDL cholesterol of this patient isarrow_forwardResearchers are interested in whether or not shoe size could predict height. Data was collected from 25 students. Students reported their height and shoe size. (Source: Intro to Statistics by Gould & Ryan). Height = 51.46 + 1.728 (Shoe Size) 74 72 5 6 7 8 9 10 11 12 13 Shoe Size a. From the scatterplot points, estimate a range of heights for students with a size 8 shoe. b. Use the equation of the regression line to calculate the predicted height of a student with a size 8 shoe. Do not round your answer. c. The data values are fairly close to the line, so we can say we there is a moderate association. Can we be very confident, moderately confident, or not at all confident that this prediction is close to the actual mileage? Explain. Height (in inches)arrow_forwardPlease assist second part? Thank you!arrow_forward
- Determine the regression equation. Write the formula (e.g., Y = bx + a where you will put in values for b and a). Show work step by step Determine the cutoff value (Fcrit) for determining if the model (ANOVA) is significant (provide correct value from the F Distribution ANOVA Table found in Table C.3 in the back of the Privitera textbook) Determine if the model is significant (Complete the F). Show work step by step Determine the standard error of the estimate for the regression determine what the predicted flight time to complete a private pilot’s license would be if the following IQs are known (show step by step process) X = 104 X = 96 X = 125 IQ Flight Hours to Complete Private 100 62 115 59 108 45 98 55 120 44 147 47 132 51 85 75 105 70 110 65arrow_forwardUsed cars 2010 Vehix.com offered several used ToyotaCorollas for sale. The following table displays the ages ofthe cars and the advertised prices. a) Make a scatterplot for these data.b) Do you think a linear model is appropriate? Explain.c) Find the equation of the regression line. d) Check the residuals to see if the conditions for infer-ence are met. Age (yr) Price ($) Age (yr) Price ($)1 15988 6 99951 13988 6 119882 14488 7 89903 10995 8 94883 13998 8 89954 13622 9 59904 12810 10 41005 9988 12 2995arrow_forward5. Provide a detailed interpretation analysis of the regression results below. Pay attention to the main tested variables, model fit characteristics (R²) and number of respondents in the sample. State what is dependent and what are independent variables. Was the hypotheses rejected or confirmed? (5 Marks) a) Hl: If a woman has a job she will have less children born b) H2: The younger a woman got married the more children she has c) H3: Education positively affects number of children to have Coefficients" Model Unstandardized Standardized Sig. Coefficients Coefficients B Std. Error Beta (Constant) 2.542 .394 6.445 .000 Do you have a job (yes - 1; no - 0)? How old were you when you .161 .133 .098 1.214 .227 -.169 .054 -227 -3.111 .002 got married? What is the highest educational level that you have attained? What is your family income? Does your husband have a job (yes - 1; no – 0)? a. Dependent Variable: how many children do you have? R? 0.456 -.142 .073 -159 -1.947 .053 .231 .032 .564…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
College AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY