2. A Least square regressicon analysis is required. Defermine thei a. Manufacturing assembly variatile cost per unit. 1. The the Variatile Cont formula stactan n(X2)(X)(X)n(XY)(X)(Y) 2. Confirm with Linest 4. Manstacturing assembly fised cost 3. Wie the Flued Cost Total shown in the dassroom. n(X2)(X)(X)(Y)(X2)(X)(XY) 4. Confirm with interceph c. Describe the resulting cost function. d. If 1950 machine hours are expected for January, which is the total cost using the cost function of requirement c. 3. Determine the goodness of fit a. Square R using the formula shown. R2=1(Y2(Yy)2 b. Interpret the least square result, indicating its limitations. 4. Present the corresponding table with the required columns and the Excel Summary Output of the Regression. 5. Shows the formulas uses in Excel. Pedro Padilla, president of Padilla Window and Doors CORP, present the following kn mis Required: 1. Using the High - Low method, determine the: a. Manufacturing assembly variable cost per uoit Yaciables cost b. Manifacturing assembly foced cost 6. The resulting cost function d. If 1950 machine hours are expected for January, which is the total cost using the cout function of requirement c