Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 15.5, Problem 19E
In exercise 1, the following estimated regression equation based on 10 observations was presented.
Here SST = 6724.125, SSR = 6216.375,
- a. Compute MSR and MSE.
- b. Compute F and perform the appropriate F test. Use α = .05.
- c. Perform a t test for the significance of β1. Use α = .05.
- d. Perform a t test for the significance of β2. Use α = .05.
- 1. The estimated regression equation for a model involving two independent variables and 10 observations follows.
- a. Interpret b1 and b2 in this estimated regression equation.
- b. Predict y when x1 = 180 and x2 = 310.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
You spilled water on your calculations from (a) and can't remember what your estimated regression parameters are. But you do have two possible estimated errors for each of your initial four observations:
For 40 eruptions of the Old Faithful geyser in Yellowstone National Park, duration times (sec) were recorded along with the heights (ft) of the eruptions. The linear correlation coefficient is r = 0.0915 and the regression equation is = 119 + 0.0331x, where x represents duration time. The mean of the 40 duration times is 245.0 sec and the mean of the 40 heights is 127.2 ft. What is the best predicted height of an eruption with a duration time of 120 min?
If I want to estimate the regression of a model by using OLS on Eveiws , and I chose the "keep it as general as possible" approach, what tests can I apply through the estimation and inference process to validate the model and the variables?
Chapter 15 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Ch. 15.2 - 1. The estimated regression equation for a model...Ch. 15.2 - Consider the following data for a dependent...Ch. 15.2 - Prob. 3ECh. 15.2 - 4. A shoe store developed the following estimated...Ch. 15.2 - The owner of Showtime Movie Theaters, Inc. would...Ch. 15.2 - NFL Winning Percentage. The National Football...Ch. 15.2 - Prob. 7ECh. 15.2 - Scoring Cruise Ships. The Condé Nast Traveler Gold...Ch. 15.2 - The Professional Golfers Association (PGA)...Ch. 15.2 - Baseball Pitcher Performance. Major League...
Ch. 15.3 - 11. In exercise 1, the following estimated...Ch. 15.3 - 12. In exercise 2, 10 observations were provided...Ch. 15.3 - Prob. 13ECh. 15.3 - Prob. 14ECh. 15.3 - 15. In exercise 5, the owner of Showtime Movie...Ch. 15.3 - Prob. 16ECh. 15.3 - In part (d) of exercise 9, data contained in the...Ch. 15.3 - Prob. 18ECh. 15.5 - In exercise 1, the following estimated regression...Ch. 15.5 - Prob. 20ECh. 15.5 - Prob. 21ECh. 15.5 - Prob. 22ECh. 15.5 - Testing Significance in Theater Revenue. Refer to...Ch. 15.5 - Testing Significance in Predicting NFL Wins. The...Ch. 15.5 - The Condé Nast Traveler Gold List provides ratings...Ch. 15.5 - Prob. 26ECh. 15.6 - Prob. 27ECh. 15.7 - 32. Consider a regression study involving a...Ch. 15.7 - Prob. 33ECh. 15.7 - 34. Management proposed the following regression...Ch. 15.7 - Repair Time. Refer to the Johnson Filtration...Ch. 15.7 - Prob. 36ECh. 15.7 - Prob. 37ECh. 15.8 - Prob. 40ECh. 15.8 - Exercise 5 gave the following data on weekly gross...Ch. 15.8 - The following table reports the price, horsepower,...Ch. 15 - 49. The admissions officer for Clearwater College...Ch. 15 - The personnel director for Electronics Associates...Ch. 15 - Prob. 46SECh. 15 - Recall that in exercise 44, the admissions officer...Ch. 15 - Recall that in exercise 45 the personnel director...Ch. 15 - Fortune magazine publishes an annual list of the...Ch. 15 - The Department of Energy and the U.S....Ch. 15 - The Tire Rack, an online distributor of tires and...Ch. 15 - The National Basketball Association (NBA) records...Ch. 15 - Consumer Research, Inc., is an independent agency...Ch. 15 - Matt Kenseth won the 2012 Daytona 500, the most...Ch. 15 - When trying to decide what car to buy, real value...
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
- According to World Health Organization (WHO), the recommended limit for a noise level inside a classroom is 35 dBA. However, nine out of ten schools fail to meet this recommendation. A researcher wishes to conduct a study relevant to the prior information, but as a gap, he decides to include the area (in square meters) of every classroom and how it could possibly affect the resulting noise level. He selects 17 classrooms at random, and the noise levels are recorded in the next slide. a. Find the regression equation and construct the scatter plot diagram. b. Predict the noise level if a classroom has an area of 85.97 m2 . c. Calculate the coefficient of determination and interpret the findings. d. Calculate the coefficient of alienation and interpret the findings. Use Excelarrow_forwardfind the (a) explained variation, (b) unexplained variation, and (c) indicated prediction interval. In each case, there is sujficient evidence to support a claim of a linear correlation, so it is reasonable to use the regression equation when making predictions. Altitude and Temperature Listed below are altitudes (thousands of feet) and outside air temperatures (°F) recorded by the author during Delta Flight 1053 from New Orleans to Atlanta. For the prediction interval, use a 95% confidence level with the altitude of 6327 ft (or 6.327 thousand feet).arrow_forwardSuppose the entering freshmen at a certain college have a mean combined SAT score of 1231 with a standard deviation of 122 In the first semester, these students attained a mean GPA of 2.64, with a standard deviation of 0.53. A scatterplot showed the association to be reasonably linear, and the correlation between SAT score and GPA was 0.47 How do i find the regression line using the equationarrow_forward
- It is required to use the data given in the table to estimate the parameters of the simple linear regression equation by any of the estimation methods:arrow_forwardThe table below gives the number of hours seven randomly selected students spent studying and their corresponding midterm exam grades. Using this data, consider the equation of the regression line, yˆ=b0+b1x�^=�0+�1�, for predicting the midterm exam grade that a student will earn based on the number of hours spent studying. Keep in mind, the correlation coefficient may or may not be statistically significant for the data given. Remember, in practice, it would not be appropriate to use the regression line to make a prediction if the correlation coefficient is not statistically significant. Hours Studying 1 2 3 3.5 4 4.5 5 Midterm Grades 60 66 73 76 78 84 90 Table Copy Data Step 1 of 6: Find the estimated slope. Round your answer to three decimal places.arrow_forwardThe table below gives the number of hours seven randomly selected students spent studying and their corresponding midterm exam grades. Using this data, consider the equation of the regression line, yˆ=b0+b1x�^=�0+�1�, for predicting the midterm exam grade that a student will earn based on the number of hours spent studying. Keep in mind, the correlation coefficient may or may not be statistically significant for the data given. Remember, in practice, it would not be appropriate to use the regression line to make a prediction if the correlation coefficient is not statistically significant. Hours Studying 11 1.51.5 2.52.5 33 44 4.54.5 55 Midterm Grades 6666 6969 7575 7979 9090 9595 9898 Find the estimated slope. Round your answer to three decimal places. Find the estimated y-intercept. Round your answer to three decimal places. Determine if the statement "Not all points predicted by the linear model fall on the same line" is true or false.…arrow_forward
- The table below gives the number of hours seven randomly selected students spent studying and their corresponding midterm exam grades. Using this data, consider the equation of the regression line, yˆ=b0+b1x�^=�0+�1�, for predicting the midterm exam grade that a student will earn based on the number of hours spent studying. Keep in mind, the correlation coefficient may or may not be statistically significant for the data given. Remember, in practice, it would not be appropriate to use the regression line to make a prediction if the correlation coefficient is not statistically significant. Hours Studying 1 2 3 3.5 4 4.5 5 Midterm Grades 60 66 73 76 78 84 90 Step 2 of 6: Find the estimated y-intercept. Round your answer to three decimal places. Step 3 of 6: Find the estimated value of y when x=2�=2. Round your answer to three decimal places. Step 4 of 6: Substitute the values you found in steps 1 and 2 into the equation for the regression line to find the estimated…arrow_forwardAfter performing a statistical regression on a set of data the value of the correlation coefficient r was -0.2041. What does that imply about the data?arrow_forwardThe table below gives the number of hours five randomly selected students spent studying and their corresponding midterm exam grades. Using this data, consider the equation of the regression line. ^y=b0+b1x for predicting the midterm exam grade that a student will earn based on the number of hours spent studying. Keep in mind, the correlation coefficient may or may not be statistically significant for the data given. Remember, in practice, it would not be appropriate to use the regression line to make a prediction if the correlation coefficient is not statistically significant. Hours Studying 2 3 4 5 6 Midterm Grades 60 81 86 98 100 Find the error prediction when x= 5. Round your answer to three decimal places. * What we know: Estimated slope b1=9.700Estimated intercept b0=46.200arrow_forward
- Suppose the following data were collected from a sample of 15 houses relating selling price to square footage and the architectural style of the house. Use statistical software to find the following regression equation: PRICEi=b0+b1SQFTi+b2COLONIALi+b3RANCHi+ei . Is there enough evidence to support the claim that on average, houses that are ranch style have lower selling prices than houses that are Victorian style at the 0.05 level of significance? If yes, write the regression equation in the spaces provided with answers rounded to two decimal places. Else, select "There is not enough evidence."Selling Price Square Footage Colonial (1 if house is Colonial style, 0 otherwise) Ranch (1 if house is Ranch style, 0 otherwise) Victorian (1 if house is Victorian style, 0 otherwise) 377640 1941 1 0 0 460996 3397 0 1 0 405781 2764 0 0 1 407216 2906 0 0 1 435139 3401 1 0 0 405275 2600 0 0 1 381141 2203 0 1 0 370490 2046 1 0 0 404070 2210 0 0 1 460196 3692 0 1 0 382780 2172 1 0 0 406466 2606 0 1…arrow_forwardThe following results are from data concerning the amount withdrawn from an ATM machine based on the amount of time spent at the ATM machine (SECONDS) and the gender, FEMALE (dummy variable = 1 for females and = 0 for males) and an interaction term, SECONDS*FEMALE Based on the regression results, if a male and female each spend the same amount of time at the ATM machine (say 27 seconds), how much more (or less) will a male withdraw? (if a male withdraws more then your answer should be a positive number and if a male withdraws less then your answer should be a negative number? (please express your answer using 1 decimal places)arrow_forwardA researcher examined the relationship between the annual tax amount paid by the construction company owners and the total expense items spent for the construction with regression analysis and calculated the regression line estimation as Y=6+2X. According to this; Write the interpretations of the cutoff and regression parameters, respectively, in your OWN SENTENCES in a statistically appropriate way over the tax amount and expenses.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage Learning
Statistics 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:PEARSON
The Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. Freeman
Introduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
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