Excel for Science & Math 6

What's inside

Excel for Science & Math 6: 12 courses, 240 hands-on lessons, with a full solutions appendix.

Learn by doing. Every lesson starts with a clear goal and a short explanation, shows the worksheet cell by cell, and gives you tasks to solve on your own computer in Excel, LibreOffice Calc or Google Sheets. When you are done, check your formulas against the solutions and hints in the appendix and correct your sheet.

• 12 complete courses, 240 lessons, 246 exam questions with answers
• Worksheets with row and column labels – easy to type in
• Tasks with exact solutions and hints in the appendix
• All figures are fictional practice data

Every course is also available as an interactive course on tabellab.com, where each cell is checked instantly.

Courses in this book

• Numerical Methods: Bisection, Newton-Raphson, Fixed-Point & Numerical Integration Accuracy
• Unit Conversions & Dimensional Analysis: Factor Chains, Rates & Mixed Units
• Coordinate Geometry with Spreadsheets: Distance, Slopes, Lines, Circles & Polygons
• Voting Methods & Social Choice: Plurality, Borda, Instant Runoff & Condorcet
• Chaos & Iteration in Spreadsheets: The Logistic Map, Fixed Points & Fractals
• Differential Equations in Spreadsheets: Euler, Heun & Runge–Kutta Methods
• Auction Math: First-Price, Second-Price, Reserve Prices & the Winner's Curse
• Apportionment Math: Hamilton, Jefferson, Webster & Huntington–Hill
• Probability Paradoxes in Spreadsheets: Monty Hall, Birthdays, Simpson's & Base Rates
• Vectors & 3D Geometry in Spreadsheets: Dot & Cross Products, Planes & Projections
• Markov Chains in Spreadsheets: Transition Matrices, Steady States & Board Games
• Complex Numbers in Spreadsheets: Rectangular & Polar Form, Arithmetic, Powers & Roots, Rotations and AC Phasors

Details

Format	PDF, US Letter (8.5 × 11 in)
Language	English
Pages	694
Series	The Tabellab Workbook, volume 6
Author	Babala Özdemir
Delivery	Instant download after payment