Finding the estimated equation of multiple regression
Not what you're looking for?
A study investigated the relationship between audit delay (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.
Industry A dummy variable coded 1 if the firm was an industrial company or 0 if the firm was a bank, savings and loan, or insurance company.
Public A dummy variable coded 1 if the company was traded on an organized exchange or over the counter; otherwise coded 0.
Quality A measure of overall quality of internal controls, as judged by the auditor, on a five-point scale ranging from "virtually none" (1) to "excellent" (5).
Finished A measure ranging from 1 to 4, as judged by the auditor, where 1 indicates "all work performed subsequent to year-end" and 4 indicates "most work performed prior to year-end"
A sample of companies provided the following data,
Delay Industy Public Quality Finished
62 0 0 3 1
45 0 1 3 3
54 0 0 2 2
71 0 1 1 2
91 0 0 1 1
62 0 0 4 4
61 0 0 3 2
69 0 1 5 2
80 0 0 1 1
52 0 0 5 3
47 0 0 3 2
65 0 1 2 3
60 0 0 1 3
81 1 0 1 2
73 1 0 2 2
89 1 0 2 1
71 1 0 5 4
76 1 0 2 2
68 1 0 1 2
68 1 0 5 2
a. Develop the estimated regression equation using all of the independent variables.
b. Did the estimated regression equation developed in part a proide a good fit? Explain.
c. Develop a scatter diagram showing delay as a function of finished. what does this scatter diagram indicate about the relationship between delay and finished?
d. On the basis of your observations about the relationship between delay and finished, develop an alternative estimated regression equation to the one developed in ( a) explain as much of the variability in delay as possible.
Purchase this Solution
Solution Summary
The solution gives details on finding the estimated equation of multiple regression using excel and then analyzing the model.
Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.