A clothing company wants to forecast the demand for its main product, based on the data below. Week Sales 1 124 2 123 3 120 4 134 5 140 6 139 7 145 8 144 9 165 10 163 11 172 12 171 13 169 14 176 15 187 16 180 17 183 18 188 19 193 20 190 21 203 22 208 23 24 204 218 Management would like you to experiment with different forecasting methods, using Excel, to determine which forecasting method to be implemented. 4. Linear regression using Excel 4.1 Using data analysis toolpack, carry out linear regression for the demand data. Provide a detailed analysis of the regression output in the way we did in class. 4.2 Write the regression line equation. 4.3 Using the regression line equation, calculate in Excel demand forecast for weeks 1-24.