Forecasting slides #63-65 (active apparel) A manager at Active Apparel plans to forecast annual sales for all new stores, based on store size. To examine the relationship between the store size in square feet and its annual sales, data were collected from a sample of 14 stores. Store Square Feet Annual Sales (Millions of (Thousands) Dollars) 3 1.7 37 2 1.6 a9 3 28 4.7 4 5.6 9.5 5 13 34 & 22 5.6 7 1.3 3.7 8 11 27 9 3.2 5.5 10 1.5 19 11 5.2 10.7 12 4.6 7.6 13 5.8 11.8 14 3.0 4.1 Conduct the regression analysis in Excel and use the information in the output port to answer the following questions: D Question 1 What is the regression equation? Enter 1if your answer is: Sales = 0.9445 - 1.6699"Store size Enter 2 if your answer is: Sales = 1.6699 + 0.9645 "Store size Enter 3 if your answer is: Store size = 0.9645 + 1.6699 Sales Enter 4 if your answer is: Store size = 1.669% + 0.9645 *Sales Enter 5if your answer is: Sales = 0.9445 + 1.6699"Store size Answer = B cstion 2 o/tp | What is the correlation coefficient? Round your answer to two decimal places | 1o Snipping' Question 3 1/1pts Is there a positive or negative correlation between store size and annual sales? Enter 1if your answer is positive Enter 2 if your answer is negative Answer = m Question 4 0/1pts What is the predicted annual sales for a store with 4,000 square feet? MNote: Round the intermediate calculation to four decimal places and the final answer to three decimal places. Sales are in millions, and Store size is in thousands Answer = million (Enter your answer in millions) T e e gk s e ok w e e