Akiko Hamaguchi, the manager at a small sushi restaurant in Phoenix, Arizona, is concerned that the weak economic environment has hampered foot traffic in her area, thus causing a dramatic decline in sales. Her cousin in San Francisco, Hiroshi Sato, owns a similar restaurant, but he has seemed to prosper during these rough economic times.

Hiroshi agrees that higher unemployment rates have likely forced some customers to dine out less frequently, but he maintains an aggressive marketing campaign to thwart this apparent trend. For instance, he advertises in local papers with valuable two-for-one coupons and promotes early-bird specials over the airwaves. Despite the fact that advertising increases overall costs, he believes that this campaign has positively affected sales at his restaurant. In order to support his claim, Hiroshi provides monthly sales data and advertising costs pertaining to his restaurant, as well as the monthly unemployment rate from San Francisco County. A portion of the data is shown in the accompanying table; the entire data set, labeled Sushi_Restaurant, can be found on the text website.

In a report, use the sample information to:
1. Estimate a simple linear regression model, Sales = β0 + β1Advertising + as well as a multiple linear regression model, Sales = β0 + β1Advertising + β2Unemployment + .
2. Show that the multiple linear regression models is more appropriate for making predictions.
3. Make predictions for sales with an unemployment rate of 6% and advertising costs of $400 and$600.

Transcribed Image Text:

AdvertisingCotsUnemployment (in $) 550 425 MonthYear January 2008 February 2008 Sales (in $1,000s) 27.0 24.2 Rate (in percent) 4.6 4.3 May 2009 27.4 550 9.1