O'Reilly logo

Microsoft® Excel Data Analysis and Business Modeling by Wayne L. Winston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 41. Estimating Straight Line Relationships

  • I manage a plant that produces small refrigerators. National headquarters tells me how many refrigerators to produce each month. For budgeting purposes, I want to forecast my monthly operating costs. How can I determine the relationship between monthly production and monthly operating costs?

  • How well does my relationship explain the monthly variation in plant operating cost?

  • How accurate are my predictions likely to be?

  • When estimating a straight line relationship, which Excel functions can I use to give me the slope and intercept of the line that best fits the data?

Every business analyst should have the ability to estimate the relationship between important business variables. The Excel trend curve, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required