solution

Boulanger Savings and Loan is proud of its long tradition in Winter Park, Florida. Begun by Michelle Boulanger 22 years after World War II, the S&L has bucked the trend of financial and liquidity problems that has repeatedly plagued the industry. Deposits have increased slowly but surely over the years, despite recessions in 1983, 1988, 1991, 2001, and 2010. Ms. Boulanger believes it is necessary to have a long-range strategic plan for her firm, including a 1-year forecast and preferably even a 5-year forecast of deposits. She examines the past deposit data and also peruses Florida’s gross state product (GSP) over the same 44 years. (GSP is analogous to gross national product [GNP] but on the state level.) The resulting data are in the following table.

a) Using exponential smoothing, with  = .6, then trend analysis, and finally linear regression, discuss which forecasting model fits best for Boulanger’s strategic plan. Justify the selection of one model over another.

b) Carefully examine the data. Can you make a case for excluding a portion of the information? Why? Would that change your choice of model?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Rhonda Clark, a Slippery Rock, Pennsylvania, real estate developer, has devised a regression model to help determine residential housing prices in northwestern Pennsylvania. The model was developed using recent sales in a particular neighborhood. The price  of the house is based on the size (square footage = ) of the house. The model is:

The coefficient of correlation for the model is 0.63.

a) Use the model to predict the selling price of a house that is 1,860 square feet.

b) An 1,860-square-foot house recently sold for $95,000.Explain why this is not what the model predicted.

c) If you were going to use multiple regression to developsuch a model, what other quantitative variables might you include?

d) What is the value of the coefficient of determination in this problem?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Accountants at the Tucson firm, Larry Youdelman, CPAs, believed that several traveling executives were submitting unusually high travel vouchers when they returned from business trips. First, they took a sample of 200 vouchers submitted from the past year. Then they developed the following multiple-regression equation relating expected travel cost to number of days on the road (1) and distance traveled (2) in miles:

The coefficient of correlation computed was .68.

a) If Barbara Downey returns from a 300-mile trip that took her out of town for 5 days, what is the expected amount she should claim as expenses?

b) Downey submitted a reimbursement request for $685. What should the accountant do?

c) Should any other variables be included? Which ones? Why?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Using the data in Problem 4.30, apply linear regression to study the relationship between the robbery rate and Dr. Fok’s patient load. If the robbery rate increases to 131.2 in year 11, how many phobic patients will Dr. Fok treat? If the robbery rate drops to 90.6, what is the patient projection?

Problem 4.30

Dr. Lillian Fok, a New Orleans psychologist, specializes in treating patients who are agoraphobic (i.e., afraid to leave their homes). The following table indicates how many patients Dr. Fok has seen each year for the past 10 years. It also indicates what the robbery rate was in New Orleans during the same year:

Using trend (linear regression) analysis, predict the number of patients Dr. Fok will see in years 11 and 12 as a function of time. How well does the model fit the data?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"