Essentials Of Business Analytics
1st Edition
ISBN: 9781285187273
Author: Camm, Jeff.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Concept explainers
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 solutionStudents have asked these similar questions
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…
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…
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?
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
- Find the equation of the regression line for the following data set. x 1 2 3 y 0 3 4arrow_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
- Consider 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_forwardJensen, Solberg, and Zorn investigated the relationship of insider ownership, debt, and dividend policies in companies. One of their findings was that firms with high insider ownership choose lower levels of both debt and dividends. Shown here is a sample of data of these three variables for 11 different industries. Use the data to develop the equation of the regression model to predict insider ownership by debt ratio and dividend payout. Comment on the regression coefficients.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
- You plan to fit a regression model that will be used to predict first-year college GPA (FYGPA) from high-school GPA (HSGPA), ACT score (ACT), first-generation status (Yes or No), socioeconomic class (lower class, lower to middle class, middle to upper class, and upper class), and school type (public or private). What is the total number of estimated regression coefficients? If the sample size is n = 250 students, what are the degrees of freedom for the following sources of variation: Regression Error Totalarrow_forwardOne 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…arrow_forwardA. Write the equation of the regression line. B. Interpret the slope in this context, and calculate the predicted birth weight of first borns and others C. Is there a statistically significant relationship between the average birth weight and parity? Provide an explanation with numeric support.arrow_forward
- Bill wants to explore factors affecting work stress. He would like to examine the relationship between age, number of years at the workplace, perceived social support, and work stress. He collects data on the variables from 100 employees (males and females) working in banks. The research question is How accurately can work stress be predicted from linear combination of the predictors (age, social support, number of years at the workplace)? Conduct a multiple regression analysis to answer the following questions: What is the regression equation for all the predictors? Write a results section based on your analysis that answers the research question.arrow_forwardBill wants to explore factors affecting work stress. He would like to examine the relationship between age, number of years at the workplace, perceived social support, and work stress. He collects data on the variables from 100 employees (males and females) working in banks. The research question is How accurately can work stress be predicted from linear combination of the predictors (age, social support, number of years at the workplace)? Conduct a multiple regression analysis to answer the following questions: What is the relationship of age, number of years, and social support with work stress? Is the regression significant? If yes, what does it indicate?arrow_forwardWhat is the purpose of multiple linear regression? a. To assess whether there is a significant difference between independent groups b. To predict scores of an independent variable from scores of a single dependent variable c. To predict scores of a single dependent variable from scores on multiple independent variables d. To predict scores of an independent variable from scores on multiple dependent variablesarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin HarcourtFunctions 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
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