Concept explainers
Instructions: Choose one or more of the data sets A-J below, or as assigned by your instructor. The first column is X, or independent, variable and the second column is the Y, or dependent, variable. Use Excel or a statistical package (e.g., MegaStat or Minitab) to obtain the simple regression and required graphs. Write your answers to exercises 12.46 through 12.61 (or those assigned by your instructor) in a concise report, labeling your answers to each question. Insert tables and graphs in your report as appropriate. You may work with a partner if your instructor allows it.
(a) Based on the R2 and ANOVA table for your model, how would you assess the fit? (b) Interpret the p-value for the F statistic. (c) Would you say that your model’s fit is good enough to be of practical value?
DATA SET B Midterm and Final Exam Scores for Business Statistics Students, Fall Semester 2011 (n = 58 students)
a.
Explain how one would assess the fit based on the
Explanation of Solution
Answer will vary.
Here the data set B is taken, in which the midterm exam (X) and final exam score (Y) is given.
Hypotheses:
Null hypothesis:
That is, the slope is zero.
Alternative hypothesis:
That is, the slope not equal to zero.
Regression:
Suppose
Where,
The total sum of squares is denoted as,
The regression sum of squares is denoted as,
The error sum of squares is denoted as,
From the regression the fitted line is denoted as,
The 95% confidence interval for the slope,
Where,
Software Procedure:
Step-by-step software procedure to find R-squared using EXCEL is as follows:
- • Open an EXCEL file.
- • In column A and B, the Midterm Exam Score and Final Exam Score data were entered.
- • Click on data > click on Data analysis.
- • Choose Regression > click OK.
- • Select Input Y range asthe column of Final Exam Score.
- • Select Input X range asthe column of Midterm Exam Score.
- • Select the output range.
- • Click OK.
- Output using EXCEL is given below:
From the output, the R-squared value is 0.429.
The coefficient of determination (
The
b.
Interpret the p-value for the F statistic.
Explanation of Solution
Calculation:
For the F-test of the slope the p-value is 0.000.
Decision rule:
If
If
It is assumed that the level of significance is 0.05.
Conclusion:
Here the p-value is less than the level of significance.
That is,
Hence, by the decision rule, reject the null hypothesis.
Therefore, it can be concluded that there is not sufficient evidence to support that the slope is zero.
Hence, the linear model provides significant fit.
c.
Check whether the model’s fit is good enough to be of practical value.
Explanation of Solution
Now, a hypothesis test is needed to check the whether the model provides good fit or not.
Decision rule:
If
If
Critical value:
Here from the output, the sample size,
The degrees of freedom is,
Thus, the degrees of freedom is56.
For two tailed test, the critical value for t-test will be,
It is assumed that the level of significance,
Procedure for critical-value using EXCEL:
Software Procedure:
Step-by-step software procedure to obtain critical-value using EXCEL software is as follows:
- • Open an EXCEL file.
- • In cell A1, enter the formula “=F.INV.RT(0.05,1,56)”
- Output using EXCEL software is given below:
Hence, the critical value will be 4.013.
From the output of part (a), the F-statistic value is 42.22.
The level of significance is 0.05.
Conclusion:
Here the F-statistics is greater than the critical value.
That is,
Hence, by the decision rule, reject the null hypothesis.
Therefore, it can be concluded that there is not sufficient evidence to support that the slope is zero.
Hence, linear model provides significant fit.
The coefficient of determination (
Thus, using
Want to see more full solutions like this?
Chapter 12 Solutions
APPLIED STAT.IN BUS.+ECONOMICS
- You want to make a salad from whatever vegetable you have in the fridge. You have seven different tomatoes. There are 2 red tomatoes, 4 yellow tomatoes, and one black tomato in the fridge. You have three different bell peppers. There is 1 red pepper, 1 yellow pepper, and 1 green pepper. What is the probability of randomly choosing a vegetable and getting a red tomato, and a green pepper? Round your answer to four decimal places.arrow_forwarduppose automobile insurance companies gave annual premiums for top-rated companies in several states. The figure below shows box plots for the annual premium for urban customers in three states. Which state offers the lowest premium? Which state offers the highest premium?arrow_forwardWing Foot is a shoe franchise commonly found in shopping centers across the United States. Wing Foot knows that its stores will not show a profit unless they gross over $940,000 per year. Let A be the event that a new Wing Foot store grosses over $940,000 its first year. Let B be the event that a store grosses over $940,000 its second year. Wing Foot has an administrative policy of closing a new store if it does not show a profit in either of the first two years. Assume that the accounting office at Wing Foot provided the following information: 58% of all Wing Foot stores show a profit the first year; 72% of all Wing Foot store show a profit the second year (this includes stores that did not show a profit the first year); however, 86% of Wing Foot stores that showed a profit the first year also showed a profit the second year. Compute P(B|Ac). Round your answer to the nearest hundredth.arrow_forward
- You draw two cards from a standard deck of 52 cards, but before you draw the second card, you put the first one back and reshuffle the deck. If you get a3on the first card, find the probability of drawing a 3 for the second card.arrow_forwardDo bonds reduce the overall risk of an investment portfolio? Let x be a random variable representing annual percent return for the Vanguard Total Stock Index (all Stocks). Let y be a random variable representing annual return for the Vanguard Balanced Index (60% stock and 40% bond). For the past several years, assume the following data. Compute the coefficient of variation for each fund. Round your answers to the nearest tenth. x: 14 0 37 21 35 23 24 -14 -14 -17 y: 8 -2 29 17 22 17 17 -2 -3 -8arrow_forwardWhat percentage of the general U.S. population have bachelor's degrees? Suppose that the Statistical Abstract of the United States, 120th Edition, gives the following percentage of bachelor’s degrees by state. For convenience, the data are sorted in increasing order. 17 18 18 18 19 20 20 20 21 21 21 21 21 22 22 22 22 22 23 23 24 24 24 24 24 25 25 25 25 26 26 26 26 26 26 27 27 27 28 28 28 29 29 31 31 32 32 34 35 38 Illinois has a bachelor's degree percentage rate of about 18%. Into what quartile does this rate fall?arrow_forward
- What percentage of the general U.S. population have bachelor's degrees? Suppose that the Statistical Abstract of the United States, 120th Edition, gives the following percentage of bachelor’s degrees by state. For convenience, the data are sorted in increasing order. 17 18 18 18 19 20 20 20 21 21 21 21 21 22 22 22 22 22 23 23 24 24 24 24 24 25 25 25 25 26 26 26 26 26 26 27 27 27 28 28 28 29 29 31 31 32 32 34 35 38 Illinois has a bachelor's degree percentage rate of about 18%. Into what quartile does this rate fall?arrow_forwardFind the range for the following sample data. x 23 17 11 30 27arrow_forwardDo bonds reduce the overall risk of an investment portfolio? Let x be a random variable representing annual percent return for the Vanguard Total Stock Index (all Stocks). Let y be a random variable representing annual return for the Vanguard Balanced Index (60% stock and 40% bond). For the past several years, assume the following data. Compute the sample mean for x and for y. Round your answer to the nearest tenth. x: 11 0 36 22 34 24 25 -11 -11 -22 y: 9 -3 28 14 23 16 14 -3 -4 -9arrow_forward
- Do bonds reduce the overall risk of an investment portfolio? Let x be a random variable representing annual percent return for the Vanguard Total Stock Index (all Stocks). Let y be a random variable representing annual return for the Vanguard Balanced Index (60% stock and 40% bond). For the past several years, assume the following data. Compute the range for variable y. X 12 0 36 21 35 23 24 -12 -12 -21 Y 10 -2 26 15 22 18 15 -2 -3 -10arrow_forwardDo bonds reduce the overall risk of an investment portfolio? Let x be a random variable representing annual percent return for the Vanguard Total Stock Index (all Stocks). Let y be a random variable representing annual return for the Vanguard Balanced Index (60% stock and 40% bond). For the past several years, assume the following data. Compute the range for variable y. X 12 0 36 21 35 23 24 -12 -12 -21 Y 10 -2 26 15 22 18 15 -2 -3 -10arrow_forwardDo bonds reduce the overall risk of an investment portfolio? Let x be a random variable representing annual percent return for the Vanguard Total Stock Index (all Stocks). Let y be a random variable representing annual return for the Vanguard Balanced Index (60% stock and 40% bond). For the past several years, assume the following data. Compute the range for variable x. X 15 0 37 23 33 25 26 -15 -15 -23 Y 6 -1 28 18 24 17 18 -1 -2 -6arrow_forward
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillFunctions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage LearningBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
- Trigonometry (MindTap Course List)TrigonometryISBN:9781305652224Author:Charles P. McKeague, Mark D. TurnerPublisher:Cengage LearningHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL