Exercise Problem: Trend Projection (12 pts.) the follmVing data, use the least squares methods to derive a trend projection. What is your estimated of the demand in period 7? (Note: Show whole process manually to get a full credit) "Peril; 9. Demand 1 7 2 9 3 5 4 i 1 5 l O 6 l 3 Q1. Establish the linear trend equation (i.e., Y = a + b t) (6 pts.) Q2. What is the estimate of the demand in year 7? (2 pts.) Q3. What is the model's correlation coefficient (R) and coefficient of determination (R2) and What do they represent (ie, interpret it based on their values)? (Note: You can find its value directly through Excel program) (4 pts.)