O'Reilly logo

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition 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 43. Estimating Straight Line Relationships

Suppose you manage a plant that manufactures small refrigerators. National headquarters tells you how many refrigerators to produce each month. For budgeting purposes, you want to forecast your monthly operating costs. You have the following questions:

  • How can I determine the relationship between monthly production and monthly operating costs?

  • How accurately does this relationship explain the monthly variation in plant operating cost?

  • How accurate are my predictions likely to be?

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

Every business analyst should have the ability to estimate the relationship between ...

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