Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)
6th Edition
ISBN: 9780357228708
Author: David R. Anderson; Dennis J. Sweeney; Thomas A. Williams
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 15.3, Problem 13E
a.
To determine
Compute
b.
To determine
Find
c.
To determine
Comment on the goodness of fit
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The regression equation for for the association between BMI and total cholesterol level is:
y = 28.07 + 6.49x
A.) Suppose a participant has a BMI of 26. What would we estimate the total cholesterol to be?
B.) Suppose two individuals have a mean BMI that differs by 3 units. What is the estimated difference in total cholesterol.
C.) What ranges of BMI should the equation be used to predict total cholesterol?
Listed below are the overhead widths (cm) of seals measured from photographs and the weights (kg) of the seals.
Overhead width 7.2 7.4 9.8 9.4 8.8 8.4
Weight 116 154 245 202 200 191
The four pairs of values below were obtained from the regression equation. Which is an extrapolation?
a) overhead width 7.5 cm, weight 144 kg
b) overhead width 10 cm, weight 245 kg
c) overhead width 7.2 cm, weight 132 kg
d) overhead width 8.1 cm, weight 169 kg
2) Use the given information to find the coefficient of determination. A regression equation is
obtained for a collection of paired data. It is found that the total variation is 20.711, the
explained variation is 18.592, and the unexplained variation is 2.119.
A) 1.114
B) 0.102
C) 0.898
D) 0.114
Chapter 15 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)
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
- For the following exercises, consider the data in Table 5, which shows the percent of unemployed in a city ofpeople25 years or older who are college graduates is given below, by year. 41. Based on the set of data given in Table 7, calculatethe regression line using a calculator or othertechnology tool, and determine the correlationcoefficient to three decimal places.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_forwardProvide a detailed interpretation analysis of the regression results below. Pay attention to the main tested variables, model fit characteristics (R 2 ) and number of respondents in the sample. State what is dependent and what are independent variables. Was the hypotheses rejected or confirmed? a) H1: 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 havearrow_forward
- Using the lengths (in.), chest sizes (in.), and weights (lb) of bears from a data set, the resulting regression equation is Weight=-274 +0.426 Length + 12.1 Chest Size. The P-value is 0.000 and the adjusted R² value is 0.925. If an additional predictor variable of neck size (in.) is included, the P-value becomes 0.000 and the adjusted R² becomes 0.933. Why is it better to use values of adjusted R² instead of simply using values of R²? Choose the correct answer below. C O A. The unadjusted R² can only be calculated for regression equations with two or fewer predictor variables, while the adjusted R² can be calculated for regression equations with any number of predictor variables. O B. The unadjusted R² increases or remains the same as more variables are included, but the adjusted R² is adjusted for the number of variables and sample size. OC. The unadjusted R² can only be calculated for regression equations with P-values greater than 0, while the adjusted R² can be calculated for…arrow_forwardUsing the lengths (in.), chest sizes (in.), and weights (lb) of bears from a data set, the resulting regression equation is Weight= -274 +0.426 Length + 12.1 Chest Size. The P-value is 0.000 and the adjusted R² value is 0.925. If an additional predictor variable of neck size (in.) is included, the P-value becomes 0.000 and the adjusted R² becomes 0.933. Why is it better to use values of adjusted R² instead of simply using values of R²? Choose the correct answer below. C O A. The unadjusted R² can only be calculated for regression equations with P-values greater than 0, while the adjusted R² can be calculated for regression equations with any manner of P-value. O B. The unadjusted R² increases or remains the same as more variables included, but the adjusted R² is adjusted for the number of variables and sample size. OC. The unadjusted R² decreases or remains the same as more variables are included, but the adjusted R² is adjusted for the number of variables and sample size. O D. The…arrow_forwardA data set consists of these points: (2, 4), (4, 7), (5, 12). Malinda found the regression equation to be ŷ = 2.5x- 1.5. Is she correct? A. No. Both a and bare incorrect. O B. No. The value for b is incorrect. C. No. The value for a is incorrect. O D. Yes. This is the correct equation.arrow_forward
- For the given data below, Solve, a. Find the regression equation, y = b0 + b1x.b. If x = 170 orders, how many shipments are expected?arrow_forwardDr. Zion measures the relationship between two variables X (exam anxiety) and Y (performance) and obtained the following interval scores:Participant X Y1 10 72 8 63 9 114 6 45 5 56 3 77 7 48 2 59 4 610 1 4a. Determine the regression equation.b. How are the size of r and the size of the standard error of the estimate related?arrow_forwardA vending machine company operates coffee vending machines in office buildings. The company wants to study the relationship between the number of cups of coffee sold per day and the number of persons working in each building. Data were collected were collected by the company and presented below. Number of Number of Cups of f. Make a copy of the scatter diagram in this item. Draw the line that best fits in the scatter diagram using the regression equation. persons Coffee Sold working at Location g. Locate the (X,). Describe its location in relation to the other plotted data. 15 20 10 15 h. Give a practical interpretation of the values of a and b. 16 20 i. Show that the regression equation can be expressed in the form: (y - y) = b(x - x) 18 25 22 30arrow_forward
- The regression line for a data set showing the monthly utility bill U in a certain city versus the square footage F of the residence is given by U = 0.2F − 100 dollars. What monthly utility bill would be expected for a 2500 square foot home in this city? $arrow_forwardA sales manager collected the following data on y = annual sales and x = years of experience. The estimated regression equation for these data is y = 80 + 4x. Click on the datafile logo to reference the data. (NEED ANSWERS FOR A, B, C) a. Compute SST, SSR, and SSE. b. Compute the coefficient of determination r2. Comment on the goodness of fit. __________ (provides a good fit / does not produce much of a fit) c. What is the value of the sample correlation coefficient (to 2 decimals)?arrow_forwardUse the model to make the appropriate prediction. A sociologist wanted to determine whether there was a relation between a state's poverty rate (x) and its teen pregnancy rate (y). Data from all 50 states produced the regression model: yˆ=4.3+1.4(x) What does the model suggest for the poverty rate of Florida, which has a poverty rate of 16.6? a) 9.2% b) 27.5% c) 12.9% d) 17% e) 22.4%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
- Trigonometry (MindTap Course List)TrigonometryISBN:9781337278461Author:Ron LarsonPublisher:Cengage LearningFunctions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage LearningAlgebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:Cengage
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781337278461
Author:Ron Larson
Publisher:Cengage Learning
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
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