GH Data Section 6 A full year analysis of maintenance costs at Riverglen Manufacturing is as follows: Units Produced Maintenance Costs Month Feb Mar ES 21,000 33,000 38,000 20,000 18,000 44,000 27,000 23,000 45,000 31,000 31,500 23,500 $79,000 83,000 84,000 60,000 59,000 102,000 81 000 74,000 106,000 90,000 98,000 94,000 Nov Dec WEBERNINN 18 Answer Section 26 Prepare some statistical analysis on this data: Summary Statistics Total maintenance costs for the year Average number of units produced per month Lowest number of units produced in a month Highest maintenance costs in a month Average maintenance cost per unit produced for the year FORMULA1 FORMULA2 FORMULA3 FORMULA FORMULAS Formulas to use: SUM AVERAGE -MIN MAX SUM Linear Regression Fixed cost per month (intercept) Variable cost per unit produced (slope) FORMULA6 FORMULAZ INTERCEPT SLOPE Estimated volume for next month Cost prediction for next month (forecast) 30,000 FORMULAS TREND ATSH