124 (Apr. 2019}; make a t2 column too (since, if you look at the data, you can see sales are Ushaped; hence the quadratic). Also make a column \"D" that is a dummy variable equal to one during the spring and summer months of March through August. Determine the correlation between the unadjusted and the adjusted monthly data {=CDRREL{unadjust., adjust.) in Excel], and produce scatterplots (with straight lines} of both. Do you think making a seasonal adjustment man be useful, given what you observe at this point?I Run four regressions: l} seasonally unadjusted monthly as the dependent, and t and t2 as the independents, 2} seasonally unadjusted monthly as the dependent, and t, t2, and D as the independents, 3) seasonally adjusted monthly as the dependent, and t and t2 as the independents, and 4} seasonally adjusted monthly as the dependent, and t, t2, and D as the independents. Discuss your ndings, and determine which of the tour models is the best for forecasting new home sales. In interpreting your pvalues, remember that, say, 1.0EIIIB is LII} * liloB, which is lllllllll. State the equation that would be used to forecast sales