Manuals / HP / Computer Equipment / Calculator

HP 17bII manual 218 14 Additional Examples, Solver Equation for Moving Averages

Models: 17bII

1 310

Download 310 pages 40.78 Kb

Page 218

A Solver Equation for Moving Averages:

name



N= the number of values averaged in each calculation.

LAST = the item number of the most recent value to be averaged.

name = the name of the SUM list whose data will be averaged. When you create and name the SUM list, make sure its name matches the name in the Solver equation.

The following example assumes MAVG into the Solver, using instructions on entering Solver Equations,” on page 30.

that you have entered the equation VOL for the SUM list’s name. For equations, see “Solving Your Own

Example: A Moving Average in Manufacturing. Calculate a three- month moving average for the number of units manufactured during the first half of the year. Manufacturing volumes are:

January	February	March	April	May	June
4400	5360	2900	3670	4040	3200

Keys:					Display:	Description:
						Displays SUM menu
						Displays SUM menu
						and
						current list.
						Clears current list or
@c						Clears current list or
or						gets
						a new one.
						a new one.
4400 I						Enters data.
5360 I					
2900 I					
3670 I					

218 14: Additional Examples

File name : English-M02-1-040308(Print).doc Print data : 2004/3/9

Image 218

HP 17bII manual 218 14 Additional Examples, Solver Equation for Moving Averages

Contents

Hp 17bII+ Financial Calculator Printing History Edition June JanuaryWelcome to the hp 17bII+ Welcome to the hp17bII+Contents Power Function Exponentiation Error MessagesUsing Parentheses in Calculations Saving and Reusing NumbersCash Flow Calculations Time Value of MoneyInterest Rate Conversions 10 121 Running Total and Statistics BondsDepreciation 11 141 Time, Appointments, and Date Arithmetic12 153 The Equation Solver 14 190 Additional Examples Assistance, Batteries, Memory, and Service More About CalculationsMenu Maps RPN Summary RPN The StackRPN Selected Examples Error Messages Index General Business Calculations List of ExamplesList of Examples Currency Exchange CalculationsInterest Rate Conversions Bonds and Notes Time, Alarms, and Date ArithmeticHow to Use the Equation Solver Running Total and Statistical CalculationsImportant Information Important InformationGetting Started Power On and Off Continuous MemoryAdjusting the Display Contrast Getting StartedKeys for language Key Description Setting the LanguageWhat You See in the Display 18 1 Getting StartedShift Key @ Backspacing and Clearing20 1 Getting Started Keys for ClearingKeys Display Description Doing Arithmetic Keys DisplayDescription22 1 Getting Started Using the Menu KeysKeying in Negative Numbers Main Menu Menu Labels Menu KeysMain Menu Menu Label Operations Done Covered This Category 24 1 Getting StartedChoosing Menus and Reading Menu Maps Displaying the MU%C menu Using the MU%C menu26 1 Getting Started Calculations Using Menus 28 1 Getting Started Exiting Menus eClearing Values in Menus Solving Your Own Equations Solve = CostTyping Words and Characters the ALPHAbetic Menu 30 1 Getting Started      Editing ALPHAbetic TextKeys CharactersKeyboard Calculating the Answer CalcAlphabetic Editing Operation Label or Key to Press 32 1 Getting StartedKeysDisplayDescription Internal Precision Controlling the Display FormatDecimal Places Temporarily SHOWing ALLRounding a Number Exchanging Periods and Commas in Numbers36 1 Getting Started Error MessagesModes Double Space. PressCalculator Memory @M Number of bytes Percentage of total Memory still freeVDoing Calculations ArithmeticCalculator Line 38 2 ArithmeticArithmetic VUsing Parentheses in CalculationsKeys Display 40 2 Arithmetic VThe Percent KeyMathematical Functions Key VThe Power Function ExponentiationShifted Math Functions 42 2 Arithmetic Math MenuMath Menu Labels DescriptionSaving and Reusing Numbers History Stack of Numbers44 2 Arithmetic VReusing the Last Result @LVKeys Display Storing and Recalling Numbers VKeys Display DescriptionArithmetic in Registers Keys New Register ContentsDoing Arithmetic Inside Registers and Variables Scientific Notation Range of Numbers 48 2 ArithmeticPercentage Calculations Business Business Percentages BUS Menus DescriptionPercent Change %CHG Using the BUS MenusExamples Using the BUS Menus 50 3 Percentage Calculations in BusinessPercent of Total %TOTL 52 3 Percentage Calculations in Business Markup as a Percent of Cost MU%CMarkup as a Percent of Price MU%P Sharing Variables Between Menus 54 4 Currency Exchange Calculation Currency Exchange CalculationsCurrx Menu Currency Exchange Calculation Selecting a Set of CurrenciesCurrx Menu Menu KeyCurrencies Currency Rate United States Conversion Chart in US$Entering a Rate Select CAN$ as currency58 4 Currency Exchange Calculation Select HK$ as currencyExample Converting between Hong Kong and U.S Dollars Converting Between Two CurrenciesStoring and Recalling Sets of Currencies Clearing the Currency Variables 60 4 Currency Exchange CalculationTime Value of Money Time Value of MoneyTVM Menu First Level of TVM Second Level of TVMSecond Level TVM Menu LabelsFirst Level Shortcut for N Multiplies the number in the display byCash Flow Diagrams and Signs of Numbers 64 5 Time Value of MoneyFV is Using the TVM Menu 66 5 Time Value of MoneyLoan Calculations 68 5 Time Value of Money Figures and stores number@c  70 5 Time Value of Money Figures and storesSavings Calculations 00072 5 Time Value of Money Figures and stores number Leasing Calculations 74 5 Time Value of Money 76 5 Time Value of Money Amortization Amrt Label Displaying an Amortization ScheduleAmrt Menu Labels 78 5 Time Value of MoneyTime Value of Money 80 5 Time Value of Money Next successive set of payments authorizedFirst year Printing an Amortization Table Table 82 5 Time Value of MoneyCalculates and prints Interest Rate Conversions 84 6 Interest Rate ConversionsInterest Rate Conversions Icnv MenuConverting Interest Rates 86 6 Interest Rate Conversions Compounding Periods Different from Payment Periods 88 6 Interest Rate Conversions  90 6 Interest Rate Conversions Cash Flow Calculations Cash Flow CalculationsCflo menu Cflo Menu Labels 92 7 Cash Flow CalculationsCash Flows Ungrouped Creating a Cash-Flow List 94 7 Cash Flow CalculationsEntering Cash Flows For grouped cash flows The display now showsPrompting for #TIMES #T?. When the calculator displays 96 7 Cash Flow CalculationsViewing and Correcting the List Display Description98 7 Cash Flow Calculations Copying a Number from a List to the Calculator LineNaming and Renaming a Cash-Flow List Deleting Cash Flows from List. PressingViewing the Name of the Current List. Press , then e Clearing a Cash-Flow List and Its NameStarting or GETting Another List Cash-Flow Calculations IRR, NPV, NUS, NFV 100 7 Cash Flow CalculationsCalc Menu for Cflo Lists Menu Label 102 7 Cash Flow Calculations Calculates NPV Group Number Amount 104 7 Cash Flow CalculationsPrompts for next cash 106 7 Cash Flow Calculations Doing Other Calculations with Cflo Data 108 8 Bonds BondsBond Menu Bonds Bond Menu LabelsMenu Description Label To calculate the price or yield of a bond Doing Bond Calculations110 8 Bonds Since there is no call on 112 8 Bonds MM.DDYYYY format 114 9 Depreciation DepreciationDeprc Menu Deprc Menu Labels Depreciation116 9 Depreciation Doing Depreciation CalculationsDB, SOYD, and SL Methods To calculate the depreciation for an assetBasis Salv 4,000 118 9 Depreciation Acrs MethodYear Percentage Deductible Keys Display Description Partial-Year Depreciation Calendar Year Depreciation Value 120 9 DepreciationRunning Total and Statistics Running Total and Statistics122 10 Running Total and Statistics SUM MenuSUM Menu Labels Creating a SUM List Entering Numbers and Viewing the Total124 10 Running Total and Statistics Transaction DateAmount Date Naming and Renaming a SUM List 126 10 Running Total and StatisticsClearing a SUM List and Its Name Doing Statistical Calculations Calc128 10 Running Total and Statistics Calculations with One VariableCalc Menu for SUM Lists Menu Key Month Phone ExpenseCalculations with Two Variables Frcst 130 10 Running Total and StatisticsCalc Total Mean Medn Stdev Range More MIN MAX Sort Frcst Frcst Menu Labels 132 10 Running Total and StatisticsCurve Fitting and Forecasting Logarithmic Curve Fit134 10 Running Total and Statistics To do curve fitting and forecastingAdvertising Values Number of Minutes Dollar SalesRadio 136 10 Running Total and Statistics MinutesMinutes Weighted Mean and Grouped Standard Deviation 138 10 Running Total and StatisticsSummation Statistics RentDoing Other Calculations with SUM Data 140 10 Running Total and StatisticsTime, Appointments, and Date Arithmetic Time, Appointments, Date ArithmeticViewing the Time and Date 142 11 Time, Appointments, and Date Arithmetic Time MenuTime Menu Labels Menu Label Description Setting the Time and Date SETSET Menu Labels Or DD.MMYYYY144 11 Time, Appointments, and Date Arithmetic Adjusting the Clock Setting AdjstChanging the Time and Date Formats SET Appointments Appt Viewing or Setting an Appointment APT1-APT10Menu Labels for Setting Appointments Description To set an appointment or view its current setting 146 11 Time, Appointments, and Date ArithmeticAcknowledging an Appointment 148 11 Time, Appointments, and Date Arithmetic Unacknowledged AppointmentsClearing Appointments To acknowledge a past-due appointmentDate Arithmetic Calc Calc Menu Labels for Date Arithmetic Determining the Day of the Week for Any DateCalculating the Number of Days between Dates 150 11 Time, Appointments, and Date ArithmeticCalculating Past or Future Dates 152 11 Time, Appointments, and Date Arithmetic DATE2Equation Solver Equation SolverSolver Example Sales Forecasts 154 12 The Equation Solver Next =OLD  Menu LabelKeys Solve Menu156 12 The Equation Solver To make an entry into the Solver list Entering EquationsSolve Menu Labels 158 12 The Equation Solver Calculating Using Solver Menus CalcTo do a calculation using a Solver menu Rmenu label 160 12 The Equation Solver EqtyEditing an Equation Edit Naming an EquationClearing Variables Finding an Equation in the Solver ListShared Variables 162 12 The Equation SolverDeleting Variables and Equations Deleting a variable is quite different from clearing itDeleting All Equations or All Variables in the Solver @c Writing EquationsDeleting One Equation or Its Variables Delet 164 12 The Equation Solver⋅ E 100⋅ C + 5 ⋅ E What Can Appear in an Equation166 12 The Equation Solver Using the Alpha Menu 168 12 The Equation Solver Using a Typing AidSolver Functions Solver Functions for Equations Description DDAYSd1d2calIFcond expr 1 expr 170 12 The Equation SolverHH.MMSS format Svariable nameSIZESSUM-listname Cfr c 1 c 2 s exprSIZECCFLO-listname #TCFLO-listnameflow#172 12 The Equation Solver Days ≥ = ≤ = ≠  174 12 The Equation Solver Conditional Expressions with ifOperatorKeys VALUE＝FIRST＋1 ⎟ FIRST. If FIRST＝0, then VALUE＝FIRST RatingExamples of Conditional Equations Percent Salary IncreaseSummation Function ∑ 176 12 The Equation SolverAccessing Cflo and SUM Lists from the Solver Creating Menus for Multiple Equations S Function 178 12 The Equation SolverHow the Solver Works Halting and Restarting the Iterative Search 180 12 The Equation SolverEntering Guesses 182 12 The Equation Solver  Printing 184 13 PrintingPrinting the DisplayP Printer’s Power SourceDouble-Space Printing PrintingPrinter Menu Labels Printing Other Information @pPrinting Variables, Lists, and Appointments List 186 13 Printing   188 13 Printing Printing Descriptive Messages MSGTrace Printing Trace How to Interrupt the Printer Keys Print-outSimple Annual Interest Additional ExamplesLoans 190 14 Additional ExamplesYield of a Discounted or Premium Mortgage Additional Examples192 14 Additional Examples Figures and stores totalAnnual Percentage Rate for a Loan with Fees See appendix F for RPN keystrokes for the next two examples11.5  194 14 Additional Examples@c e Loan with an Odd Partial First Period196 14 Additional Examples Solver Equation for Odd-Period CalculationsCanadian Mortgages 198 14 Additional Examples Solver Equation for Canadian MortgagesAdvance Payments Leasing Solver Equation for Advance Payments200 14 Additional Examples SavingsValue of a Fund with Regular Withdrawals Displays periodic Deposits Needed for a Child’s College Account 202 14 Additional ExamplesAdditional Examples Flow of Withdrawals 204 14 Additional ExamplesFor FLOW1 Value of a Tax-Free Account 206 14 Additional Examples35  Value of a Taxable Retirement Account 208 14 Additional ExamplesModified Internal Rate of Return 210 14 Additional Examples Group No. of Months Cash Flow, $ Flow noFLOW0 V8 /12180000 212 14 Additional Examples 200000 IV13 /12  Price of an Insurance Policy Solver Equation for Insurance Price214 14 Additional Examples Bonds Discounted Notes 216 14 Additional ExamplesStatistics Moving Average218 14 Additional Examples Solver Equation for Moving AveragesIf necessary Chi-Squared χ2 StatisticsUse 220 14 Additional Examples If the expected values varyKeystroke Display Description NumberAnswers to Common Questions Assistance, Batteries Memory, and ServiceAssistance, Batteries, Memory, and Service Obtaining Help in Operating the CalculatorAssistance, Batteries, Memory, and Service Do not use rechargeable batteries Power and BatteriesLow-Power Indications Installing Batteries Assistance, Batteries, Memory, and Service Managing Calculator Memory Resetting the Calculator Reset holeFor the other languages Erasing Continuous MemoryFor English language Environmental Limits Determining If the Calculator Requires ServiceClock Accuracy „ If the calculator won’t turn onAssistance, Batteries, Memory, and Service Confirming Calculator Operation Self-Test Warranty Assistance, Batteries, Memory, and Service Asia Pacific Country Telephone numbers ServiceEurope Country Telephone numbers America Country Telephone numbersHP Invent Japan Regulatory informationCanada Possible Outcomes of Calculating IRR% More About CalculationsIRR% Calculations More About CalculationsHalting and Restarting the IRR% Calculation Storing a Guess for IRR%O F I T = P R I C E － C O S T Direct SolutionsSolver Calculations S T = P R I C E － P R O F I TE a ＝ L x W ＝ a R E a ⎟ WIterative Solutions More About Calculations More About Calculations More About Calculations Equations Used by Built-in Menus Actuarial FunctionsAmortization Percentage Calculations in Business BUSTime Value of Money TVM NOM %  P Interest Rate ConversionsCash-Flow Calculations NPV ＝ CF0 + ∑CFj x Uspv i% nj x Sppv i% NjBond Calculations NUS ＝ Uspv i% N Total ＝ ∑nj ⋅ CFjDepreciation Calculations DB ＝ Basis ⋅ Fact % /100Model Transformation Sum and StatisticsForecasting − M Equations Used in ChapterSXY = Σ X SX 2 ⋅ SYModified Internal Rate of Return Odd-Period CalculationsAdvance Payments Menu Maps Menu MapsFigure C-2. Currx Menu Figure C-3. FIN Menu Figure C-3 . FIN Menu Figure C-4. SUM Menu Figure C-5. Time Menu Figure C-6. Solve Menu About RPN on the hp 17bII+ RPN SummaryAbout RPN RPN SummarySetting RPN Mode To select RPN mode Press @ ~ same as Where the RPN Functions AreFunction Definition Key to Use Name Same asSimple Arithmetic Arithmetic Topics Affected by RPN ModeDoing Calculations in RPN ↓. Except in Cflo and SUM lists, Efunction and the key also27 % To Calculate Press DisplayChain Calculations－No Parentheses RPN Mode ALG ModeCalculations with STO and RCL To Calculate Press DisplayRPN The Stack RPN The StackWhat the Stack Is Reviewing the Stack Roll Down Exchanging the X- and Y-Registers in the StackArithmetic－How the Stack Does It How Enter Works LostClearing Numbers Retrieving Numbers from Last Reusing NumbersLast X Register Chain Calculations Solution 23 @w13 E9 *-7@t+ ExercisesRPN Selected Examples RPN Selected ExamplesKeysDisplay  Calculates annual interest For E, press =, not #TIMES1 for FLOW1I11 I  Annual payment deposit    Error Messages Error MessagesError Messages Error Messages                 Error Messages Index IndexSpecial Characters 169 147156 166,  31-32 174-76144 145149 162-64 116Examples 181-83229 133168-71 138-39213-15 , 72-73 239242-46 , 132 , 109 , 49, 53 , 52, 128 , 128 , 128 , 128 Memory. See also Continuous Memory 143-44175 , 101 , 101 , 101 , 157 , 56 , 56 , 56 , 42 92-94 164-67, 56 , 42 , 18 @p, 186 P PMT. See also Payments in TVM, 63 rounded amortization Repeating appointments past-due, 148 setting 146-47 Using128 243-46 176171 148 178133-34 This regulation applies only to The Netherlands