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
Question
Chapter 15.5, Problem 26E
a.
To determine
Perform F test to determine the overall significance of the relationship.
Draw conclusion at
b.
To determine
Perform t test to determine the significance of each independent variable and draw conclusion at the 0.05 level of significance.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
In a study of housing demand, the county assessor is interested in developing a regression model to estimate the market value (i.e., selling price) of residential property within his jurisdiction. The assessor feels that the most important variable affecting selling price (measured in thousands of dollars) is the size of house (measured in hundreds of square feet). He randomly selected 15 houses and measured both the selling price and size, as shown in the following table.
OBSERVATIONi
SELLING PRICE (× $1,000)Y
SIZE (× 100 ft2 )X
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
265.2
279.6
311.2
328.0
352.0
281.2
288.4
292.8
356.0
263.2
272.4
291.2
299.6
307.6
320.4
12.0
20.2
27.0
30.0
30.0
21.4
21.6
25.2
37.2
14.4
15.0
22.4
23.9
26.6
30.7
a. Plot the data.b. Determine the estimated regression line. Give an economic interpretation of the estimated slope (b) coefficient.c. Determine if size is a statistically significant variable in estimating selling price.d. Calculate the coefficient…
The data in the table represent the number of licensed drivers in various age groups and the number of fatal accidents within the age group by gender. Complete parts (a) through (c) below.
Click the icon to view the data table.
... .
(a) Find the least-squares regression line for males treating the number of licensed drivers as the explanatory variable, x, and the number of fatal crashes, y, as the response variable. Repeat this procedure for females.
Find the least-squares regression line for males.
y=x+O
Data for licensed drivers by age and gender.
%3D
(Round the x coefficient to three decimal places as needed. Round the constant to the nearest integer as needed.)
Find the least-squares regression line for females.
y =
Number of
Number o
X+
Number of Male Fatal
Number of Female Fatal
(Round the x coefficient to three decimal places as needed. Round the constant to the nearest integer as needed.)
Licensed Drivers Crashes
Licensed Drivers
Crashes
(b) Interpret the slope of the…
The data in the table represent the number of licensed drivers in various age groups and the number of fatal accidents within the age group by gender. Complete parts (a) through (c) below.
Click the icon to view the data table.
.....
(a) Find the least-squares regression line for males treating the number of licensed drivers as the explanatory variable, x, and the number of fatal crashes, y, as the response variable. Repeat this procedure for females.
Find the least-squares regression line for males.
y =x+O
%D/
(Round the x coefficient to three decimal places as needed. Round the constant to the nearest integer as needed.)
Find the least-squares regression line for females.
y =
ý =x+O
%3D
(Round the x coefficient to three decimal places as needed. Round the constant to the nearest integer as needed.)
(b) Interpret the slope of the least-squares regression line for each gender, if appropriate. How might an insurance company use this information?
What is the correct interpretation of the…
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
- Find the equation of the regression line for the following data set. x 1 2 3 y 0 3 4arrow_forwardA regression model to predict Y, the state burglary rate per 100,000 people, used the following four state predictors: X1 = median age, X2 = number of bankruptcies per 1,000 population, X3 = federal expenditures per capita (a leading predictor), and X4 = high school graduation percentage. Click here for the Excel Data File (a) Using the sample size of 45 people, calculate the tcalc and p-value in the table given below. (Negative values should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Round your t-values to 3 decimal places and p- values to 4 decimal places.) Predictor Intercept AgeMed Coefficient SE tcalc p-value 4,641.0430 798.0634 -28.8630 12.4684 Bankrupt 20.1604 12.1079 FedSpend HSGrad% -0.0181 0.0181 -30.3196 7.1136 (b-1) What is the critical value of Student's tin Appendix D for a two-tailed test at a = .01? (Round your answer to 3 decimal places.) -value =arrow_forwardA regression model to predict Y, the state burglary rate per 100,000 people, used the following four state predictors: X₁ = median age, X₂ = number of bankruptcies per 1.000 population, X3 = federal expenditures per capita (a leading predictor), and X4 = high school graduation percentage. Click here for the Excel Data File (a) Using the sample size of 50 people, calculate the calc and p-value in the table given below. (Negative values should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 4 decimal places.) Predictor Intercept AgeMed Bankrupt FedSpend HSGrad% Answer is complete but not entirely correct. *calc 5.2526 -2.1764✔✔ 1.4101✔ Coefficient 4,198.5808 -27.3540 17.4893 -0.0124 -29.0314 SE 799.3395 12.5687 12.4033 0.0176 7.1268 -0.7045 -4.0736 p-value 0.0000 0.0348 0.2935 0.4848 0.0002arrow_forward
- Pre-study and post-study scores for a class of 120 students were considered. The residual plot for the least squares regression line showed no pattern. The least squares regression line was y-hat = 0.2 + 0.9x with a correlation coefficient r=0.85. What percent of the variation of post-study scores can be explained by the variation in pre-study scires? A) 72.3% b) 85.0% c) 90.0% d) 92.2% e) we can not determine with the information givenarrow_forwardThe data in the table represent the number of licensed drivers in various age groups and the number of fatal accidents within the age group by gender. Complete parts (a) to (c) below. E Click the icon to view the data table. ked Бcor (a) Find the least-squares regression line for males treating the number of licensed drivers as the explanatory variable, x, and the number of fatal crashes, y, as the response variable. Repeat this procedure for females. Find the least-squares regression line for males. Data for licensed drivers by age and gender. (Round the slope to three decimal places and round the constan ion estion 4 Number of Number of tion Number of Male Fatal Licensed Drivers Crashes Number of Female Fatal Licensed Drivers (000s) Crashes Age (000s) (Males) (Females) 74 4,803 2,022 5,375 973 Enter your answer in the edit fields and then click Check Ans Print Done parts remainingarrow_forwardA multiple regression model is to be constructed to predict the heart rate in beats per minute (bpm) of a person based upon their age, weight and height. Data has been collected on 10 randomly selected individuals: Heart Rate Age Weight Height 81 51 211 71 83 41 108 69 112 48 216 69 63 34 105 69 99 47 226 66 82 37 102 64 57 23 122 62 70 27 261 67 88 24 251 72 62 38 101 61 Copy-and-paste the data into an Excel spreadsheet. Use Excel to perform all calculations. a) Calculate the multiple regression equation using all three explanatory variables. Write the equation in the answer blank. Round all of the equation coefficient values to two (2) decimal places. You may use the variables names or replace them with y, x1, x2, and x3. b) What percentage of variation in heart rates is explained by the regression model using all three variables? c) Using the 10% level of significance, which predictor variables are statistically significant predictors of heart rate? d) Remove the Height…arrow_forward
- Calculate the Pearson product-moment correlation coefficient (r) to 2 decimal places for the data and comment on the strength and type of the relationship. b) What is the least squares regression equation that can be used to predict film speed? c) Calculate the Coefficient of Determination and interpret the value. d) Predict the film speed of a camera that is 9.5 months old to 2 decimal places. e) Predict the film speed of a camera that is 14 months old to 2 decimal places. f) Comment on the validity of these predictionsarrow_forwardTwo measures of a baseball player's effectiveness as a hitter are the number of hits he makes in a season and thenumber of times he "bats in" a run (knows as "Runs Batted In" or RBIs). Can we predict a batter's RBIs from hisMajor League Baseball batters in 2017.hits? Below is numerical and graphical output from a computer regression of RBIs on Hits for 12 randomly selected Major League Baseball batters in 2017. Assume that the conditions for inference have been satisfied.(a) Do these data provide convincing evidence that there is a linear relationship between RBIs and Flits for MajorLeague Baseball batters in 2017? (b) Construct a 95% confidence interval for the slope of the population regression line for predicting RBIs from Hits.arrow_forwardLINEAR REGRESSION AND CORRELATIONarrow_forward
- 31arrow_forwardAn attempt was made to construct a regression model explaining student scores in intermediate economics courses (Waldauer, Duggal, and Williams 1992). The population regression model assumed thatY = total student score in intermediate economics coursesX1 = mathematics score on Scholastic Aptitude TestX2 = verbal score on Scholastic Aptitude TestX3 = grade in college algebra (A = 4, B = 3, C = 2, D = 1)X4 = grade in college principles of economics courseX5 = dummy variable taking the value 1 if the student is female and 0 if maleX6 = dummy variable taking the value 1 if the instructor is male and 0 if femaleX7 = dummy variable taking the value 1 if the student and instructor are the same gender and 0 otherwiseThis model was fitted to data on 262 students. Next we report t-ratios, so that tj is the ratio of the estimate of bj to its associated estimated standard error. These ratios are as follows:t1 = 4.69, t2 = 2.89, t3 = 0.46, t4 = 4.90,t5 = 0.13, t6 = -1.08, t7 = 0.88The objective of…arrow_forwardThe data in the table represent the number of licensed drivers in various age groups and the number of fatal accidents within the age group by gender. Complete parts (a) to (c) below. Click the icon to view the data table. (a) Find the least-squares regression line for males treating the number of licensed drivers as the explanatory variable, x, and the number of fatal crashes, y, as the response variable. Repeat this procedure for females. Find the least-squares regression line for males. Data for licensed drivers by age and gender. y = x+ (Round the slope to three decimal places and round the constant to the nearest integer as needed.) Find the least-squares regression line for females. y =x+ Number of Number of (Round the slope to three decimal places and round the constant to the nearest integer as needed.) Number of Male Fatal Number of Female Fatal Licensed Drivers Crashes Licensed Drivers Crashes (b) Interpret the slope of the least-squares regression line for each gender, if…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Elementary Linear Algebra (MindTap Course List)AlgebraISBN:9781305658004Author:Ron LarsonPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
Elementary Linear Algebra (MindTap Course List)
Algebra
ISBN:9781305658004
Author:Ron Larson
Publisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
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