Please see attached file for full problem description.
Super Markets, Inc. is considering expanding into the Scottsdale, Arizona, area. Ms. Luann
Miller, Director of Planning, must present an analysis of the proposed expansion to the operating
committee of the board of directors. As a part of her proposal, she needs to include
information on the amount people in the region spend per month for grocery items. She
would also like to include information on the relationship between the amount spent for grocery
items and income. She gathered the following sample information.
This posting provides details on how to conduct regression analysis and interpret the output in Excel.