EBK STATISTICS FOR BUSINESS & ECONOMICS
12th Edition
ISBN: 8220100460463
Author: Anderson
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 15.5, Problem 24E
The Wall Street Journal conducted a study of basketball spending at top colleges. A portion of the data showing the revenue ($ millions), percentage of wins, and the coach’s salary ($ millions) for 39 of the country’s top basketball programs follows (The Wall Street Journal, March 11–12, 2006).
- a. Develop the estimated regression equation that can be used to predict the coach’s salary given the revenue generated by the program and the percentage of wins.
- b. Use the F test to determine the overall significance of the relationship. What is your conclusion at the .05 level of significance?
- c. Use the t test to determine the significance of each independent variable. What is your conclusion at the .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
One of the biggest changes in higher education in recent years has been the growth of online universities. The Online Education Database is an independent organization whose mission is to build a comprehensive list of the top accredited online colleges. The following table shows the retention rate (%) and the graduation rate (%) for 29 online colleges.a). Use Excel Data Analysis Tool – Regression to get the relationship between the two variables;b). Create a scatter diagram for the two variables and display regression equation and R square on chart, then explain the relationship between the variables;c). Did the estimated regression equation provide a good fit?d). Suppose you were the president of South University. After reviewing the results, would you be able to use the regression result for forecasting.
College
RR(%)
GR(%)
Western International University
7
25
South University
51
25
University of Phoenix
4
28
American InterContinental University
29
32
Franklin…
The Toyota Camry is one of the best-selling cars in North America. The cost of a previously owned Camry depends on many factors, including the model year, mileage, and condition. To investigate the relationship between the car’s mileage and the sales price for Camrys, the following data show the mileage and sale price for 19 sales (PriceHub web site, February 24, 2012).
A. Develop an estimated regression equation showing how price is related to miles. What is the estimated regression model? Let x represent the miles.
B. calculate the predicted price and residual for each automobile in the data. Identify the two automobiles that were the biggest bargains
C. Suppose that you are considering purchasing a previously owned Camry that has been driven 40,000 miles. Use the estimated regression equation developed in part (A) to predict the price for this car.
Use the Financial database from “Excel Databases.xls” on Blackboard. Use Total Revenues, Total Assets, Return on Equity, Earnings Per Share, Average Yield, and Dividends Per Share to predict the average P/E ratio for a company. Use Excel to develop the multiple linear regression model. Assume a 5% level of significance.
Which independent variable is the strongest predictor of the average P/E ratio of a company?
A. Total Revenues
B. Average Yield
C. Earnings Per Share
D.Return on Equity
E. Total Assets
F.Dividends Per Share
Company
Type
Total Revenues
Total Assets
Return on Equity
Earnings per Share
Average Yield
Dividends per Share
Average P/E Ratio
AFLAC
6
7251
29454
17.1
2.08
0.9
0.22
11.5
Albertson's
4
14690
5219
21.4
2.08
1.6
0.63
19
Allstate
6
20106
80918
20.1
3.56
1
0.36
10.6
Amerada Hess
7
8340
7935
0.2
0.08
1.1
0.6
698.3
American General
6
3362
80620
7.1
2.19
3
1.4
21.2
American Stores
4
19139
8536
12.2
1.01
1.4
0.34
23.5
Amoco
7
36287…
Chapter 15 Solutions
EBK STATISTICS FOR BUSINESS & ECONOMICS
Ch. 15.2 - The estimated regression equation for a model...Ch. 15.2 - Consider the following data for a dependent...Ch. 15.2 - In a regression analysis involving 30...Ch. 15.2 - A shoe store developed the following estimated...Ch. 15.2 - The owner of Showtime Movie Theaters, Inc., would...Ch. 15.2 - The National Football League (NFL) records a...Ch. 15.2 - PC World rated four component characteristics for...Ch. 15.2 - The Cond Nast Traveler Gold List provides ratings...Ch. 15.2 - Waterskiing and wakeboarding are two popular...Ch. 15.2 - Prob. 10E
Ch. 15.3 - In exercise 1, the following estimated regression...Ch. 15.3 - Prob. 12ECh. 15.3 - In exercise 3, the following estimated regression...Ch. 15.3 - In exercise 4, the following estimated regression...Ch. 15.3 - In exercise 5, the owner of Showtime Movie...Ch. 15.3 - In exercise 6, data were given on the average...Ch. 15.3 - Prob. 17ECh. 15.3 - Prob. 18ECh. 15.5 - In exercise 1, the following estimated regression...Ch. 15.5 - Refer to the data presented in exercise 2. The...Ch. 15.5 - The following estimated regression equation was...Ch. 15.5 - In exercise 4, the following estimated regression...Ch. 15.5 - Prob. 23ECh. 15.5 - The Wall Street Journal conducted a study of...Ch. 15.5 - The Cond Nast Traveler Gold List for 2012 provided...Ch. 15.5 - In exercise 10, data showing the values of several...Ch. 15.6 - In exercise 1, the following estimated regression...Ch. 15.6 - Refer to the data in exercise 2. The estimated...Ch. 15.6 - In exercise 5, the owner of Showtime Movie...Ch. 15.6 - Prob. 30ECh. 15.6 - The American Association of Individual Investors...Ch. 15.7 - Consider a regression study involving a dependent...Ch. 15.7 - Consider a regression study involving a dependent...Ch. 15.7 - Management proposed the following regression model...Ch. 15.7 - Refer to the Johnson Filtration problem introduced...Ch. 15.7 - This problem is an extension of the situation...Ch. 15.7 - The Consumer Reports Restaurant Customer...Ch. 15.7 - A 10-year study conducted by the American Heart...Ch. 15.8 - Data for two variables, x and y, follow. xi 1 2 3...Ch. 15.8 - Data for two variables, x and y, follow. xi 22 24...Ch. 15.8 - Exercise 5 gave the following data on weekly gross...Ch. 15.8 - The following data show the curb weight,...Ch. 15.8 - Prob. 43ECh. 15.9 - Refer to the Simmons Stores example introduced in...Ch. 15.9 - In Table 15.12 we provided estimates of the...Ch. 15.9 - Community Bank would like to increase the number...Ch. 15.9 - Over the past few years the percentage of students...Ch. 15.9 - The Tire Rack maintains an independent consumer...Ch. 15 - The admissions officer for Clearwater College...Ch. 15 - The personnel director for Electronics Associates...Ch. 15 - A partial computer output from a regression...Ch. 15 - Recall that in exercise 49, the admissions officer...Ch. 15 - Recall that in exercise 50 the personnel director...Ch. 15 - The Tire Rack, Americas leading online distributor...Ch. 15 - The Department of Energy and the U.S....Ch. 15 - A portion of a data set containing information for...Ch. 15 - Fortune magazine publishes an annual list of the...Ch. 15 - Consumer Research, Inc., is an independent agency...Ch. 15 - Matt Kenseth won the 2012 Daytona 500, the most...Ch. 15 - Finding the Best Car Value When trying to decide...
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_forwardBrandon works as a statistician for the Toronto Blue Jays, and wants to analyze the relationship between a player's age and how many strikeouts they accumulate in a season. He takes a sample of 5 Blue Jays players with age between 25 and 34 and finds there is a linear relationship between their ages and the number of strikeouts they had in the 2015 season. Here are the numerical summaries for age and the number of strikeouts: r = 0.6, age = 25.3, Sage = 3.2, strikeout = 105.7, S strikeout = 7.48 a) What is the value of b₁, the estimated slope? (Round your answer to 3 decimal places, if needed.) Answer: b) What is the value of bo, the estimated intercept? (Round your answer to 3 decimal places, if needed.) Answer: c) What is the percent of variation in the number of strikeouts that is explained by age, using linear regression? (Round your answer to 2 decimal places, if needed.) Answer: % d) Can we use this linear regression to predict the number of strikeouts for a player age at 37? No,…arrow_forwardA magazine publishes restaurant ratings for various locations around the world. The magazine rates the restaurants for food, decor, service, and the cost per person. Develop a regression model to predict the cost per person, based on a variable that represents the sum of the three ratings. The magazine has compiled the accompanying table of this summated ratings variable and the cost per person for 25 restaurants in a major city. Complete parts (a) through (e) below. Click the icon to view the table of summated ratings and cost per person. ..... a. Construct a scatter plot. Choose the correct graph below. A. Ов. С. D. ACost ($) 90- ACost ($) 90- ACost ($) 90- ACost ($) 90- 0- 0- 90 90 90 90 Rating Rating Rating Rating b. Assuming a linear relationship, use the least-squares method to compute the regression coefficients b, and b,. bo = and b, (Round to two decimal places as needed.) c. Interpret the meaning of the Y-intercept, bo, and the slope, b,. Choose the correct answer below. O A.…arrow_forward
- A magazine publishes restaurant ratings for various locations around the world. The magazine rates the restaurants for food, decor, service, and the cost per person. Develop a regression model to predict the cost per person, based on a variable that represents the sum of the three ratings. The magazine has compiled the accompanying table of this summated ratings variable and the cost per person for 25 restaurants in a major city. Complete parts (a) through (e) below. Click the icon to view the table of summated ratings and cost per person. a. Construct a scatter plot. Choose the correct graph below. O A. Ов. OC. OD. ACost ($) 90- Q A Cost ($) 904 A Cost ($) 90- ACost ($) 90- 0- 0- 0- 0- 90 Rating 90 Rating 90 90 Rating Rating Summated ratings and cost per person b. Assuming a linear relationship, use the least-squares method to compute the regression coefficients bo and b,. bo =D and b, =O (Round to two decimal places as needed.) Summated Rating Cost ($ per person)|9 c. Interpret the…arrow_forwardA magazine publishes restaurant ratings for various locations around the world. The magazine rates the restaurants for food, decor, service, and the cost per person. Develop a regression model to predict the cost per person, based on a variable that represents the sum of the three ratings. The magazine has compiled the accompanying table of this summated ratings variable and the cost per person for 25 restaurants in a major city. Complete parts (a) through (e) below. Click the icon to view the table of summated ratings and cost per person. a. Construct a scatter plot. Choose the correct graph below. O A. 90+ 0 0 Cost ($) The M Rating 90 Q O B. A Cost (5) 90+ 0 H +4 Alpe Rating 90 Q b. Assuming a linear relationship, use the least-squares method to compute the regression coefficients bo and b₁. bo= and b₁ = (Round to two decimal places as needed.) C O C. 90+ 0- Cost (S) HA Rating 90 Q Summated Ratings and Cost Per Person Summated Rating Cost ($ per person) 40 48 60 61 42 40 43 55 67 69…arrow_forwardBrandon works as a statistician for the Toronto Blue Jays, and wants to analyze the relationship between a player's age and how many strikeouts they accumulate in a season. He takes a sample of 8 Blue Jays players with age between 25 and 34 and finds there is a linear relationship between their ages and the number of strikeouts they had in the 2015 season. Here are the numerical summaries for age and the number of strikeouts: r = 0.67, age = 28.4, Sage = 3.96, strikeout= 102.9, S strikeout = 7.7 (a) What is the value of b₁, i.e. the fitted slope? (Round your answer to 3 decimal places) Answer: (b) What the value of bo, i.e. the fitted intercept? (Round your answer to 3 decimal places.) Answer: (c) What is the percent of variation of the number of strikeouts that is explained by age using a linear regression? (Round your answer to 2 decimal places.) Answer: % (d) Can we use this linear regression to predict the number of strikeouts for a player age 38? Answer: O No, because the…arrow_forward
- Is the number of calories in a beer related to the number of carbohydrates and/or the percentage of alcohol in the beer? The accompanying table has data for 35 beers. The values for three variables are included: the number of calories per 12ounces, the alcohol percentage, and the number of carbohydrates (in grams) per 12 ounces. a. Perform a multiple linear regression analysis, using calories as the dependent variable and percentage alcohol and number of carbohydrates as the independent variables. Let X1 represent alcohol percentage and let X2 represent the number of carbohydrates. (Round to four decimal places as needed.)arrow_forwardThe number of megapixels in a digital camera is one of the most important factors in determining picture quality. But, do digital cameras with more megapixels cost more? The following data show the number of megapixels and the price ($) for 10 digital cameras(Consumer Reports, March 2009). Would you feel comfortable using the estimated regression equation developed to predict the price of a digital camera given the number of megapixels? Explain. Brand and Model Megapixels Price (S) Canon PowerShot SD1100 IS Casio Exilim Card EX-510 180 200 230 8 10 Sony Cyber-shot DSC-170 Pentax Optio M50 Canon PowerShot Gl10 8 120 470 15 Canon PowerShot A590 IS 8 140 Canon PowerShot El Fujifilm FinePix FOOFD Sony Cyber-shot DSC-W170 Canon PowerShot A470 10 12 180 310 10 250 110arrow_forwardConsumer Reports tested 19 different brands and models of road, fitness, and comfort bikes. Road bikes are designed for long road trips; fitness bikes are designed for regular workouts or daily commuters; and comfort bikes are designed for leisure rides on typically flat roads. The data file Bikes show the type, weight (lb.), and price ($) for the 20 bicycles tested. Develop an estimated regression equation that can be used to predict Price by using Type and Weight. Brand and Model Type Weight Price Klein Rêve v Road 20 1800 Giant OCR Composite 3 Road 22 1800 Giant OCR 1 Road 22 1000 Specialized Roubaix Road 21 1300 Trek Pilot 2.1 Road 21 1320 Cannondale Synapse 4 Road 21 1050 LeMond Poprad Road 22 1350 Raleigh Cadent 1.0 Road 24 650 Giant FCR3 Fitness 23 630 Schwinn Super Sport GS Fitness 23 700 Fuji Absolute 2.0 Fitness 24 700 Jamis Coda Comp Fitness 26 830 Cannondale Road Warrior 400 Fitness 25 700 Schwinn Sierra GS Comfort 31 340 Mongoose…arrow_forward
- In a quantitative analysis where widowed people suffering with bereavement suffer with a poor quality of life. Would Widowed Individuals be the Unit of Analysis? The quality of life be the dependent variable, therefore making bereavement the independent variable?arrow_forwardMsvarrow_forwardIdentify the type of data that would be used when the variable of interest is most-watched TV show.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
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
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
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
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