An AbacusEducalc.net Pte Ltd - HP Calculator
Jump to: What's new here? Comments & Talk Back
Home » + Calc Solutions » Online Training » Training Reference: Finance » (a) Cost Estimation with Linear Regression » 

Using HP 10bII for Cost Estimation with Linear Regression

Johnson’s Chair Company has experienced the following costs for the first 6 months of the year:
# Chairs Made
5,000
5,500
4,800
5,300
4,950
5,150
Total Costs
$120,000
$122,100
$118,540
$122,400
$119,100
$124,200

Entering data in HP 10bII:

  • [Shift] [C All]
  • 5000 [Input] 120,000 [E+]
  • 5,500 [Input] 122,100 [E+]
  • 4,800 [Input] 118,540 [E+]
  • 5,300 [Input] 122,400 [E+]
  • 4,950 [Input] 119,100 [E+]
  • 5,150 [Input] 124,200  [E+]

Johnson’s fixed cost:

  • Press 0 then [Shift] [y,m]
  • Display 89,449.381 is the Answer

Johnson’s variable cost (cost to build on chair):

  • Press 1 then [Shift] [y,m]
  • Display 89,455.559
  • Deduct this with the above fixed cost  89,449.381
  • 6.178 which is the cost for one unit of chair.
  • or Press [Shift] [Swap] to get the same answer

How good is the fit of the linear regression line generated?

  • Press 0 then [Shift] [x,r]
  • Display -14,480.29
  • [Shift] [Swap]
  • Display 0.716 and this is the answer

Total costs for 5,400 chairs:

  • Enter 5,400 then [Shift] [y,m]
  • Display 122,806.907 is the Answer.

Total costs were $125,000, how many chairs:

  • Enter 125,000 then [Shift] [x,r]
  • Display 5,755.023 is the Answer.

This solution is also applicable to HP 10b Financial Calculator.


Mail this pageMail this page


Professional Real Estate Problem Solving; Using the HP12c; More Real Estate Books...


Essential Equations for the FE Exam; Civil Engineering PE Exam; More Engineering Books...