examples
Example 1.1Spreadsheet Analysis of a Projectile’s Trajectory4
Example 1.2Preparing to Solve a Problem9
Example 1.3Assessing the Accuracy of a Solution12
Example 1.4A Spreadsheet Solution to the Electrical Circuit Problem13
Example 2.1Writing an Excel Formula39
Example 2.2A Simple Spreadsheet Application42
Example 2.3Naming Cells44
Example 2.4Student Exam Scores52
Example 2.5Evaluating Trigonometric Functions53
Example 2.6Saving a Worksheet58
Example 2.7Printing a Worksheet62
Example 3.1Selecting a Block of Cells66
Example 3.2Preparing a Table by Copying Cells68
Example 3.3Editing a Worksheet83
Example 4.1Creating an X-Y Graph in Excel98
Example 4.2Adding Data to an X-Y Graph102
Example 4.3Adding Dependent Variables to an X-Y Graph105
Example 4.4Creating a Semi-Log Graph in Excel114
Example 4.5Creating a Log-Log Graph in Excel118
Example 4.6Creating a Line Graph in Excel122
Example 4.7Creating a Bar Graph in Excel127
Example 4.8Creating a Pie Chart in Excel132
Example 5.1Creating a List in Excel139
Example 5.2Sorting a List in Excel142
Example 5.3Filtering a List in Excel147
Example 5.4Creating a Pivot Table in Excel157
Example 6.1Importing Data from a Text File169
Example 6.2Exporting Data to a Text File174
Example 6.3Exporting Data to an HTML File180
Example 6.4Copying Data to Microsoft Word182
Example 6.5Embedding Data within Microsoft Word187
Example 6.6Linking Data between Excel and Microsoft Word190
Example 6.7Transferring Data to Microsoft PowerPoint195
Example 7.1A Simple Conversion (Feet to Meters)203
Example 7.2A Simple Conversion (Feet to Meters) in Excel207
Example 7.3Converting Feet to Millimeters208
Example 7.4Converting Celsius to Fahrenheit210
Example 7.5Converting a Temperature Difference210
Example 7.6A Complex Conversion (psi to Pascals)212
Example 7.7A Complex Excel Conversion (psi to Pascals)213
Example 8.1Analyzing a Data Set221
Example 8.2Constructing a Histogram226
Example 8.3Generating a Histogram in Excel 227
Example 8.4Constructing a Cumulative Distribution233
Example 8.5Generating a Cumulative Distribution in Excel234
Example 8.6Plotting the Cumulative Distribution236
Example 8.7Drawing Inferences from the Cumulative Distribution237
Example 9.1Linear Interpolation244
Example 9.2Linear Interpolation in Excel245
Example 9.3Fitting a Straight Line to a Set of Data252
Example 9.4Assessing a Curve Fit255
Example 9.5Fitting a Straight Line to a Set of Data in Excel256
Example 9.6Use of the Regression Feature in Excel261
Example 9.7Fitting an Exponential Function to a Set of Data265
Example 9.8Fitting an Exponential Function to a Set of Data in Excel266
Example 9.9Fitting a Power Function to a Set of Data270
Example 9.10Fitting a Polynomial to a Set of Data274
Example 9.11Obtaining a Straight-Line Plot Using Different Coordinate Systems280
Example 9.12Fitting Multiple Functions to a Set of Data283
Example 9.13Variable Substitution284
Example 9.14Scaling a Data Set287
Example 10.1Identifying the Real Roots of a Polynomial299
Example 10.2Solving a Polynomial Equation Graphically300
Example 10.3Solving a Polynomial Equation Using the Method of Bisection305
Example 10.4Solving a Polynomial Equation Using the Newton-Raphson Method307
Example 10.5Solving a Polynomial Equation in Excel Using Goal Seek310
Example 10.6Convergence Considerations312
Example 10.7Solving a Polynomial Equation in Excel Using Solver318
Example 11.1Writing a System of Simultaneous Equations in Matrix Form329
Example 11.2Matrix Multiplication330
Example 11.3Reconstructing a System of Simultaneous Equations331
Example 11.4Matrix Addition, Matrix Subtraction, and Scalar Multiplication332
Example 11.5Properties of the Inverse Matrix333
Example 11.6Solving Simultaneous Linear Equations Using Matrix Inversion335
Example 11.7Matrix Addition, Matrix Subtraction, and Scalar Multiplication in Excel339
Example 11.8Solving Simultaneous Equations in Excel Using Matrix Inversion341
Example 11.9Solving Simultaneous Linear Equations in Excel Using Solver346
Example 11.10Solving Simultaneous Nonlinear Equations in Excel Using Solver349
Example 12.1The Trapezoidal Rule for Unequally Spaced Data364
Example 12.2The Trapezoidal Rule for Unequally Spaced Data in Excel366
Example 12.3The Trapezoidal Rule for Equally Spaced Data367
Example 12.4The Trapezoidal Rule for Equally Spaced Data in Excel369
Example 12.5Accuracy and the Number of Intervals371
Example 12.6Comparing Simpson’s Rule with the Trapezoidal Rule375
Example 12.7Simpson’s Rule in Excel376
Example 12.8Simpson’s Rule in Excel – Another Approach379
Example 12.9Integrating Measured Data383
Example 13.1Student Grades391
Example 13.2Student Grades Revisited392
Example 13.3Simpson’s Rule Revisited393
Example 14.1Formatting a Number within a Cell402
Example 14.2Evaluating a Polynomial405
Example 14.3Analyzing Student Exam Scores409
Example 14.4Viewing the Class_Standing Macro415
Example 14.5Editing a Macro418
Example 15.1Accumulating Compound Interest426
Example 15.2A Single-Payment Loan427
Example 15.3Compound Interest: Frequency of Compounding428
Example 15.4A Single-Payment Loan with Monthly Compounding430
Example 15.5A Single-Payment Loan with Monthly Compounding in Excel431
Example 15.6Present Value of a Future Sum of Money437
Example 15.7Comparing Two Economic Alternatives437
Example 15.8Determining the Cost of a Loan440
Example 15.9Present Value of a Proposed Investment in Excel441
Example 15.10Future Value of a Series of Uniform Payments443
Example 15.11Present Value of an Irregular Cash Flow in Excel447
Example 15.12Use of the NPV Function in Excel449
Example 15.13Comparing Two Investment Opportunities451
Example 15.14Calculating the Internal Rate of Return456
Example 15.15Comparing Two Investment Opportunities Using IRR458
Example 15.16Internal Rate of Return as the Root of a Polynomial460
Example 16.1Scheduling Production to Maximize Profit465
Example 16.2A Minimum-Weight Structure468
Example 16.3Solving the Production Scheduling Problem in Excel477
Example 16.4Solving a Nonlinear Minimization Problem in Excel482