
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
- Examine the Variables: Carefully review and note the names of all variables in the dataset. Examples of these variables include: Mileage (mpg) Number of Cylinders (cyl) Displacement (disp) Horsepower (hp) Research: Google to understand these variables. Statistical Analysis: Select mpg variable, and perform the following statistical tests. Once you are done with these tests using mpg variable, repeat the same with hp Mean Median First Quartile (Q1) Second Quartile (Q2) Third Quartile (Q3) Fourth Quartile (Q4) 10th Percentile 70th Percentile Skewness Kurtosis Document Your Results: In RStudio: Before running each statistical test, provide a heading in the format shown at the bottom. “# Mean of mileage – Your name’s command” In Microsoft Word: Once you've completed all tests, take a screenshot of your results in RStudio and paste it into a Microsoft Word document. Make sure that snapshots are very clear. You will need multiple snapshots. Also transfer these results to the…arrow_forward2 (VaR and ES) Suppose X1 are independent. Prove that ~ Unif[-0.5, 0.5] and X2 VaRa (X1X2) < VaRa(X1) + VaRa (X2). ~ Unif[-0.5, 0.5]arrow_forward8 (Correlation and Diversification) Assume we have two stocks, A and B, show that a particular combination of the two stocks produce a risk-free portfolio when the correlation between the return of A and B is -1.arrow_forward
- 9 (Portfolio allocation) Suppose R₁ and R2 are returns of 2 assets and with expected return and variance respectively r₁ and 72 and variance-covariance σ2, 0%½ and σ12. Find −∞ ≤ w ≤ ∞ such that the portfolio wR₁ + (1 - w) R₂ has the smallest risk.arrow_forward7 (Multivariate random variable) Suppose X, €1, €2, €3 are IID N(0, 1) and Y2 Y₁ = 0.2 0.8X + €1, Y₂ = 0.3 +0.7X+ €2, Y3 = 0.2 + 0.9X + €3. = (In models like this, X is called the common factors of Y₁, Y₂, Y3.) Y = (Y1, Y2, Y3). (a) Find E(Y) and cov(Y). (b) What can you observe from cov(Y). Writearrow_forward1 (VaR and ES) Suppose X ~ f(x) with 1+x, if 0> x > −1 f(x) = 1−x if 1 x > 0 Find VaRo.05 (X) and ES0.05 (X).arrow_forward
- Joy is making Christmas gifts. She has 6 1/12 feet of yarn and will need 4 1/4 to complete our project. How much yarn will she have left over compute this solution in two different ways arrow_forwardSolve for X. Explain each step. 2^2x • 2^-4=8arrow_forwardOne hundred people were surveyed, and one question pertained to their educational background. The results of this question and their genders are given in the following table. Female (F) Male (F′) Total College degree (D) 30 20 50 No college degree (D′) 30 20 50 Total 60 40 100 If a person is selected at random from those surveyed, find the probability of each of the following events.1. The person is female or has a college degree. Answer: equation editor Equation Editor 2. The person is male or does not have a college degree. Answer: equation editor Equation Editor 3. The person is female or does not have a college degree.arrow_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





