Reference no: EM131112772

Question 1 - A 10-year study conducted by the American Heart Association provided data on how age, blood pressure, and smoking relate to the risk of strokes. Data from a portion of this study follow. Risk is interpreted as the probability (times 100) that a person will have a stroke over the next 10-years period. For the smoker variable, 1 indicates a smoker and 0 indicates a nonsmoker.

a. Develop an estimated regression equation that can be used to predict the risk of stroke given the age and blood-pressure level.

b. Consider adding two independent variables to the model developed in part (a), one for (the interaction between age and blood-pressure level and the other for whether the person is a smoker. Develop an estimated regression equation using these four independent variables.

c. At a .05 level of significance, test to see whether the addition of the interaction term and the smoker variable contribute significantly to the estimated regression equation developed in part (a).

Question 2 - The National Football League rates prospects by position on a scale that ranges from 5 to 9. The ratings are interpreted as follows: 8-9 should start the first year; 7.0-7.9 should start; 6.0-6.9 will make the team as backup; and 5.0-5.9 can make the club and contribute. The following table shows the position, weight, time in seconds to run 40 yards, and ratings for 40 NFL prospects (USA Today, April 14, 2000).

a. Develop dummy variables that will account for the player's position.

b. Develop an estimated regression equation to show how rating is related to position, weight, and time to run 40 yards.

c. At the .05 level of significance, test whether the estimated regression equation developed in part (b) represents a significant relationship between the independent variables and the dependent variable.

d. Is position a significant factor in the player's rating? Use a = .05. Explain.

Question 3 - 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 40 companies provided the following data.

a. Develop the estimated regression equation using all of the independent variables.

b. Did the estimated regression equation developed in part (a) provide 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) to ex-plain as much of the variability in Delay as possible.

Detailed Question: I need these questions completed step by step using excel and the details on how to find the solutions.