Explore BrainMass

Explore BrainMass

    High-Low Method and Scatter graph Analysis

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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 ad1c9bdddf
    https://brainmass.com/business/accounting/high-low-method-scatter-graph-analysis-238748

    Attachments

    Solution Summary

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

    $2.19

    ADVERTISEMENT