# Finding the estimated equation of multiple regression

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.

https://brainmass.com/statistics/regression-model-validation/finding-the-estimated-equation-of-multiple-regression-634661

#### Solution Summary

The solution gives details on finding the estimated equation of multiple regression using excel and then analyzing the model.