3-26 The Blacksburg Company is separating materials handling cost into fixed....

If possible, can you please explain without Microsoft Excel. Thank you very much.

5. E (c) Identify the statistical factors which are used to test a regression equation for good- ness of fit and, for each item identified, indicate whether a high or low value describes a "good" fit (d) Explain what each of the following terms means with respect to regression analysis. 1. Linearity within a relevant range 2. Constant variance (homoscedasticity) 3. Serial correlation 4. Normality 5. Multicollinearity (IMA adapted) High-Low Cost Estimation and Simple Regression Analysis The components. The following data have been collected over a five-month peri amounts are in thousands) 3-26 Blacksburg Company is separating materials handling cost into fixed and variable Direct Cost of Materials Month Labor Hours Materials Issued Handling Costs $1.60 1.70 1.80 1.90 2.00 $7 Required (1) Determine the fixed and variable materials handling cost by the high-low method using direct labor hours as the measure of volume (2) Determine the fixed and variable materials handling cost by the method of least squares using direct labor hours as the measure of volume (3) Repeat (2) using cost of materials issued as the measure of volume (4) Which of the two measures of volume in (2) and (3) seems preferable? Why