Question
Stratton, Inc., has collected the following information on its cost of electricity: Machine Hours Total Electricity Costs January 510 $240 February 540 $300 March 360
Stratton, Inc., has collected the following information on its cost of electricity:
| Machine Hours | Total Electricity Costs | ||||
| January | 510 | $240 | |||
| February | 540 | $300 | |||
| March | 360 | $205 | |||
| April | 450 | $215 | |||
| May | 660 | $290 | |||
| June | 690 | $300 | |||
| July | 340 | $180 | |||
| August | 520 | $260 | |||
| September | 240 | $120 | |||
| October | 750 | $340 | |||
| November | 840 | $360 | |||
| December | 600 | $320 |
Assuming the line intersects the y-axis at $50 and using the August activity levels calculate the equation of the line that would be drawn for a scattergraph.
a. Y = $__ X MH + $__
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Statistical Analysis Microsoft Excel 2010
Authors: Conrad Carlberg
1st Edition
0789747200, 9780789747204
