Pages

Tuesday, November 12, 2013

Integral Made Easy with Microsoft Mathematics

Integration is an important concept in mathematics and, together with its inverse, differentiation, is one of the two main operations in calculus. Given a function f of a real variable x and an interval [a, b] of the real line, 

How to solve integral problem with Microsoft Mathematics?

Example 1

  1. Click +Calculus in the Calculator Pad
  2. click ∫ (Indefinite integral of a function)

Saturday, November 9, 2013

How to Solve Equations and Create Graphs with Microsoft Mathematics?

Microsoft Mathematics provides a set of mathematical tools that help students get school work done quickly and easily. With Microsoft Mathematics, students can learn to solve equations step-by-step, while gaining a better understanding of fundamental concepts in pre-algebra, algebra, trigonometry, physics, chemistry, and calculus. Microsoft Mathematics includes a full-featured graphing calculator that’s designed to work just like a handheld calculator. Additional math tools help you evaluate triangles, convert from one system of units to another, and solve systems of equations.

Familiarize yourself with the interface
When you first open Microsoft Mathematics, you’ll see the following elements displayed:
  1. The Calculator Pad which includes a number pad and the following button groups: Statistics, Trigonometry, Linear Algebra, Calculus, Standard, and Favorite Buttons.
  2. The Worksheet tab is displayed by default, and is where you will do most of your numerical computing. This tab includes both an input and output pane. The input pane gives you the option of using the graphing calculator, keyboard or ink input. When you click buttons on the calculator pad, you construct a mathematical expression in the keyboard input pane. 
  3. The Graphing tab can be used to create most mathematical graphs. This tab includes an input pane to enter the function equation, inequality, data sets, or parametric equations that you want to plot. 
  4. Math Tools : On the Home tab, in the Tools group, you'll see buttons for additional math tools:

Wednesday, November 6, 2013

Using Names for Constants or Formulas

In addition to using Names to name cells or ranges, you can also name constants or formulas, these constants or formulas don’t have to appear in a cell. This is a good way of storing a constant or a formula that may have to be used several times.

Naming a constant
Imagine having to work out someone’s holiday leave loading. You might have the leave loading in a cell (H6 in the example below), so that you can use this value in a formula. By having the value in a separate cell, if the leave loading rate ever changes you would only have to change the value in H6 and all formulas referring to this cell would update. The formula in this case is =(D5/52)*4*$H$6, i.e. the salary divided by 52 weeks, multiplied by 4 weeks and then multiplied by 17.5%.