Work these five problems and submit your resulting Excel spreadsheet here. For the problems listed in the chapter, answer each of the questions associated with the problem. Put you answers below the work in the respective sheet. Problem 1 - From Appendix 4.1, work the Example Problem (X and Y data only), Table 4.7 Preliminary Calculations for Triple A Construction (page 146). Run a Regression on the data and ensure that you get the same results (slope, equation, R, and R2 values) as the example. Using a worked example ALWAYS helps with understanding and knowing that the software is being used correctly. Problems 2 - Work the following regression problem in software. What is the resulting equation? Using the equation, if 30 ads are placed, how many apartments can we expect to be leased? The sales manager of a large apartment rental complex feels the demand for apartments may be related to the number of newspaper ads placed during the previous month. She has collected the data shown in the accompanying table. Ads purchased, (X) Apartments leased, (Y) 15 6 9 4 40 16 20 6 25 13 25 9 15 10 35 16 Problem 4-21 (page 141) - The