Share
Explore BrainMass

Regression Analysis

Please see attached there are 3 problems. I have added the instructions for #3

Attachments

Solution Summary

#3. The following table gives the annual amount of scrap produced by Machine Products, Inc.

Year Code Scrap (tons)
1997 1 2.0
1998 2 4.0
1999 3 3.0
2000 4 5.0
2001 5 6.0

*Determine the least squares trend equation. Estimate the amount of the scrap from the year 2003.

#9.Victor Anderson, the owner of Anderson Belts, Inc., is studying absenteeism among his employees. His workforce is small, consisting of only five employees. For the last three years he recorded the following number of employee's absences, in days, for each quarter.

Year I II III IV
1999 4 10 7 3
2000 5 12 9 4
2001 6 16 12 4

Determine a typical seasonal index for each of the four quarters.

#14. Mr. James McWhinney, president of Daniel-James Financial Services, believes there is a relationship between the number of client contacts and the dollar amount of sales. To document this assertion, Mr. McWhinney gathered the following sample information. The X column indicates the number of client contacts last month, and the Y column shows the value of sales ($ thousands) last month for each client sampled.

Number of Contacts (X) Sales ($Thousands) # of Contacts (X) Sales ($ Thousands)Y
14 24 23 30
12 14 48 90
20 28 50 85
16 30 55 120
46 80 50 110

a. Determine the Regression equation
b. Determine the estimated sales if 40 contacts are made.
c. Determine the standard error of estimate
d. Suppose a large sample is selected (instead of 10). About 95% of the predictions regarding sales would occur between what two values?

$2.19