Chapter 53. Estimating straight-line relationships
Questions answered in this chapter:
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 costs?
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?
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 and need answers to the questions that are the focus of this chapter.
Every business ...
Get Microsoft Excel 2013: Data Analysis and Business Modeling now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
