Essentials Of Business Analytics
1st Edition
ISBN: 9781285187273
Author: Camm, Jeff.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 4, Problem 14P
A study investigated the relationship between audit delay (the length of time from a company’s fiscal year-end to the date of the auditor’s report) and variables that describe the client and the auditor. Some of the independent variables that were included in this study follow:
A sample of 40 companies provided the following data:
- a. Develop the estimated regression equation using all of the independent variables included in the data.
- b. Test for an overall regression relationship at the 0.05 level of significance. Is there a significant regression relationship?
- c. How much of the variation in the sample values of delay does this estimated regression equation explain? What other independent variables could you include in this regression model to improve the fit?
- d. Test the relationship between each independent variable and the dependent variable at the 0.05 level of significance, and interpret the relationship between each of the independent variables and the dependent variable.
- e. On the basis of your observations about the relationships between the dependent variable Delay and the independent variables Quality and Finished, suggest an alternative regression equation to the model developed in part a to explain as much of the variability in Delay as possible.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The county assessor feels that the use of more independent variables in the regression equation might improve the overall explanatory power of the model. In addition to size, the assessor feels that the total number of rooms, age, and whether or not the house has an attached garage might be important variables affecting selling price. The data for the 15 randomly selected dwellings are shown in the following table.
What proportion of the total variation in selling price is explained by the regression model?
D& T LTD marketing team needed more information about the effectiveness of their 3 main mode of advertising. To determine which type is the most effective, the manager collected one week’s data from 25 randomly selected stores. For each store, the following variables were recorded:
Weekly gross sales
Weekly expenditure on direct mailing (Direct)
Weekly expenditure on newspaper advertising (Newspaper)
Weekly expenditure on television commercials (Television)
Following is the regression output based on the above-mentioned data.
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.442…
D& T LTD marketing team needed more information about the effectiveness of their 3 main mode of advertising. To determine which type is the most effective, the manager collected one week’s data from 25 randomly selected stores. For each store, the following variables were recorded:
Weekly gross sales
Weekly expenditure on direct mailing (Direct)
Weekly expenditure on newspaper advertising (Newspaper) Weekly expenditure on television commercials (Television)
Following is the regression output based on the above-mentioned data.
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.442
R Square
A
Adjusted R Square
0.080
Standard Error
2.587
Observations
25
ANOVA
Df
SS
MS
F
Significance F
Regression
B
34.1036
E
F…
Chapter 4 Solutions
Essentials Of Business Analytics
Ch. 4 - Bicycling World, a magazine devoted to cycling,...Ch. 4 - In a manufacturing process the assembly line speed...Ch. 4 - Jensen Tire Auto is deciding whether to purchase...Ch. 4 - A sociologist was hired by a large city hospital...Ch. 4 - The regional transit authority for a major...Ch. 4 - A marketing professor at Givens College is...Ch. 4 - The Dow Jones Industrial Average (DJIA) and the...Ch. 4 - The Toyota Camry is one of the best-selling cars...Ch. 4 - Dixie Showtime Movie Theaters, Inc., owns and...Ch. 4 - Prob. 10P
Ch. 4 - The American Association of Individual Investors...Ch. 4 - The National Football League (NFL) records a...Ch. 4 - Johnson Filtration. Inc., provides maintenance...Ch. 4 - A study investigated the relationship between...Ch. 4 - The U.S. Department of Energys Fuel Economy Guide...Ch. 4 - A highway department is studying the relationship...Ch. 4 - A sample containing years to maturity and...Ch. 4 - In 2011, home prices and mortgage rates fell so...Ch. 4 - A recent 10-year study conducted by a research...Ch. 4 - The Scholastic Aptitude Test (or SAT) is a...Ch. 4 - Consider again the example introduced in Section...Ch. 4 - Alumni donations are an important source of...
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
- The Transactional Records Access Clearinghouse at Syracuse University reported data showing the odds of an Internal Revenue Service audit. The following table shows the average adjusted gross income reported and the percent of the returns that were audited for 20 selected IRS districts. Develop the estimated regression equation that could be used to predict the percent audited given the average adjusted gross income reported. At the .05 level of significance, determine whether the adjusted gross income and the percent audited are related. Did the estimated regression equation provide a good fit? District Adjusted Gross Income ($) Percent Audited Los Angeles 36,664 1.3 Sacramento 38,845 1.1 Atlanta 34,886 1.1 Boise 32,512 1.1 Dallas 34,531 1.0 Providence 35,995 1.0 San Jose 37,799 0.9 Cheyenne 33,876 0.9 Fargo 30,513 0.9 New Orleans 30,174 0.9 Oklahoma City 30,060 0.8 Houston 37,153…arrow_forwardConsider a linear regression model that relates school expenditures and family background to student performance in Massachusetts using 224 school districts. The response variable is the mean score on the MCAS (Massachusetts Comprehensive Assessment System) exam given in May 1998 to 10th-graders. Four explanatory variables are used: (1) STR is the student-to-teacher ratio, (2) TSAL is the average teacher’s salary, (3) INC is the median household income, and (4) SGL is the percentage of single family households. The Excel Regression output for the sample regression equation is given below. (a) What proportion of the variation in MCAS score is explained by the explanatory variables? (b) At the 5% level, are the explanatory variables jointly significant in explaining MCAS score? Explain briefly. (c) At the 5% level, which variables are individually significant at predicting MCAS score? Explain briefly. (d) Suppose a second regression model (Model 2) was generated using only…arrow_forwardConsider a linear regression model that relates school expenditures and family background to student performance in Massachusetts using 224 school districts. The response variable is the mean score on the MCAS (Massachusetts Comprehensive Assessment System) exam given in May 1998 to 10th-graders. Four explanatory variables are used: (1) STR is the student-to-teacher ratio, (2) TSAL is the average teacher’s salary, (3) INC is the median household income, and (4) SGL is the percentage of single family households. The Excel Regression output for the sample regression equation is given below. (a) What proportion of the variation in MCAS score is explained by the explanatory variables? (b) At the 5% level, are the explanatory variables jointly significant in explaining MCAS score? Explain briefly. (c) At the 5% level, which variables are individually significant at predicting MCAS score? Explain briefly. (d) Suppose a second regression model (Model 2) was generated using only…arrow_forward
- The regional transit authority for a major metropolitan area wants to determine whetherthere is a relationship between the age of a bus and the annual maintenance cost. A sampleof ten buses resulted in the following data: a. Develop a scatter chart for these data. What does the scatter chart indicate about therelationship between age of a bus and the annual maintenance cost?b. Use the data to develop an estimated regression equation that could be used to predictthe annual maintenance cost given the age of the bus. What is the estimated regressionmodel?c. Test whether each of the regression parameters b0 and b1 is equal to zero at a 0.05level of significance. What are the correct interpretations of the estimated regressionparameters? Are these interpretations reasonable?d. How much of the variation in the sample values of annual maintenance cost does themodel you estimated in part b explain?e. What do you predict the annual maintenance cost to be for a 3.5-year-old bus?arrow_forwardRestaurant Digest, a famous restaurant magazine writes that the amount of tips servers get in Florida is affected by several factors including the amount of bill, number of adult diners as well as kids and the income of the diners. Use the data below to answer the following questions: Find the multiple regression model. At a level of significance of 0.03, is there a significance relationship between the amount of tip and at least one of the independent variables? What is the likely amount of tip if a group of diners spend $40.33 and had an annual income of $81,000. The diners included 4 adults and 3 kids? What percent of the variation in amount of tip is accounted for by amount of bill, annual income, number of adults and kids? Customer Amount of Tip Amount of Bill Number of adult Diners Number of kids Annual Income 1 $ 7.00 $ 48.97 5 3 100000 2 $ 4.50 $ 28.23 4 3 80000 3…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
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
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
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