# High-Low Method and Scatter graph Analysis

1.) Using the high-low method, estimate a cost formula for utilities. Express the formula in the form Y=a+bX). (The variable rate should be stated in terms of cost per scan).

2.) Prepare a scattergraph using the above data. (The number of scans should be placed on the horizontal axis, and utilities cost should be placed on the vertical axis). Fit a straight line to the plotted points using a ruler and estimate a cost formula for utilities using the quick-and-dirty method.

© BrainMass Inc. brainmass.com June 3, 2020, 10:34 pm ad1c9bdddfhttps://brainmass.com/business/accounting/high-low-method-scatter-graph-analysis-238748

#### Solution Summary

Excel file shows Scattergraph using the quick-and-dirty method and cost formula for utilities using high -low method.

$2.19