1. Whole Foods is an all-natural grocery chain that has 50,000 square foot stores, up from industry average of 34,000 square feet. Sales per square foot of supermarkets average just under $400 per square foot, as reported by USA Today. Suppose that sales per square foot in the most recent fiscal year are recorded and analyzed in excel for a sample of 10 Whole Foods supermarket.
A real estate developer wants to study the relationship between the size of a home a client will purchase (in square feet) and other variables. Possible independent variables include family income (reported in 000’s)and family size. A sample of 10 families is obtained and the excel analysis of this data is located on the last page of this exam. For each question, justify your answer by identifying and referring to appropriate information from the excel analysis. (80%)