Spread Sheet ( .xls ) Home Page

        www.mathnstuff.com/math/xls/xls.htm © 2008, A. Azzolino

 

 

Storage

    These spread sheets are stored on your computer by your browser (as is any web page) before they are "run."

 

    You may wish to save a spread sheet to a location for your later use.   You are hereby granted permission to do that.

 

To save a spread sheet,

Press File, then

Press Save As, (or Alt + F, then A) then

Save it SOMEWHERE YOU CAN FIND IT --

      Desktop, My Documents, etc.

 

 

Spreadsheet Notes

    The Spreadsheet Notes & Index is a page (linked at left through button) containing notes and instructions on how to do things like create a formula in a cell, sort data, and use a funtion.

 

 

Ready-Made Spreadsheets

area.xls Perimeter of rectangles, parallelograms, triangles, trapezoids, circles. Area of rectangles, parallelograms, triangles, trapezoids, circles, and figures with mixed areas. Volume of prisms, pyramids, cylinders, cones cramers.xls Properties of determinants. EVALUATE A DETERMINANT. 2 by2 determinant - graphic and hot determinant 3 by 3 determinant by augmented columns - graphic and hot determinant 3 by 3 or higher determinant evaluated by minors - graphic Solve Linear System in Two Unknowns by Cramer's Rule. Solve Linear System in Three Unknowns by Cramer's Rule. Compute each of the 6 possible ways of computing the 3x3 determinant by minors. curve.xls Given a set of test scores: Sorts scores. Computes mean. Computes standard deviation. Computes curved cut off scores. . Compute z-scores. exp.xls Compute yearly, semiyearly, quarterly, monthly, daily, and every minute given initial principal, rate, and time. Solve for P, P0, r, t, but not n, for instantaneous and non-instantaneous interest. Graph two exponential curves w/user entry of parameters. gradet.xls (grade test) Input number correct , total number, and grade range and the % and letter grades are stated. Using mean and standard deviation, curve a set of tests. Enter 3 raw 2nd quarter grades, the 1st quarter grade, and the midterm and get the 1st semester grade. graph.xls Provides the user with a table of 10, 20, or 30 cells and a graphed function. The user must edit the function then paste it to the other y-cells to draw a new graph. maytrix.xls Add 1x3, 2x3, 2x2, 3x3, or up to 5x5 arrays using matrix rules. Subtract up to 5x5. Multiply a 1x3 times a 3x1, a 2x3 times a 3x1, a 2x2 times a 2x2, a 3x3 times a 3x3, and conformable m by n times a n by p Multiply a 1x3 by a 3x2, a 2x3 by a 3x2, and a 2x3 by a 3x3 with color-coding to show the origin of each factor. Compute inverse of 2x2 or 3x3. Contains notes & worksheet. Answer key to worksheet and notes on computation of 3 by 3 inverse. UNDER CONSTRUCTION 3x3 inverse derivation Row transformation to find inverse Solve system by inverse, 2x2, 3x3 Matrix vs. Cramer's Rule to Solve a 3x3 UNDER CONSTRUCTION Solve system, Gauss-Jordan elimination User & Spread sheet jointly use row transformation to find inverse linear.xls Graphs line given m, b, starting x, increment in x. Does the above and also graphs a line given 2 points & computes the slope and y-intercept given the 2 points. poly.xls Graph a polynomial defined by degrees and coefficients. y= anxn + an -1xn -1 + an - 2xn -2 + an - 3xn -3 + an - 4xn - 4 + an - 5xn - 5 + an-6xn - 6 + an -7xn -7 Graph a polynomial displayed in factored form. y = A(x - b)B(x - c)C(x - d)D Synthetically divide and then view the quotient polynomial and remainder. Divide (anxn + an -1xn -1 + an - 2xn -2 + an - 3xn -3 + an - 4xn - 4 + an - 5xn - 5 + an-6xn - 6 + an -7xn -7) ÷ (x-c) Solves linear or quadratic equations. Multiplies 2 binomials or 3 binomials. prime.xls The prime factorization of whole numbers from 2 to 122 in two displays. Whole numbers from 1 to 1000 with primes highlighted.     This page is arrange to show that: ALL PRIMES, OTHER THAN 2 AND 3, MUST BE ONE MORE OR ONE LESS THAN A MULTIPLE OF 6. Whole numbers from 1 to 1002 with primes highlighted. The times tables up through 50 x 30 ratl.xls Graph and table of (Axm)/(Bxn) Watch the power of the top or bottom equal or dominate the other. Examine hoirzontal asymptotes or infinite increase or decrease. Think endbehavior and explore. Graph and table of rational function, polynomial A(x) divided by B(x). Examine asymptotes. Examine the role of factors A(x) and 1/B(x). Graph and table of rational functions written as A(x) / B(x) + C(x) Really play with C(x), the asymptote Complete synthetic division and rewrite of quotient and remainder. sine.xls Graphs y=Asin(Bx-C) +D, where A, B, C, D are input values. Scatter-Plots y=Atan(Bx-C)+D, where A, B, C, D are input values. Graphs two sine functions where A, B, C, D are input values. Graphs one sine function and one cosine function where where A, B, C, D are input values. solvtrg.xls Solve a right triangle. Solve a 45-45-90 triangle. Input leg a. Seek a leg and hypotenuse. Input side c. Seek two legs. Solve a 30-60-90 triangle. Input leg a. Seek a leg and hypotenuse. Input leg b. Seek a leg and hypotenuse. Input side c. Seek the hypotenuse. Use Pythagorean Theorem and arithmetic and basic trig. Input leg a and leg b. Seek the hypotenuse and the angles. Input hypotenuse c and leg a. Seek a leg and the angles. Input angle A and side a. Seek a leg, side, and hypotenuse. Solve any triangle. Use the Sine Law, if a side and the opposite angle are given. Input angles A , B, side a. Seek two sides and an angle. Input angle A , side a, side b. Seek two angles and a side. Use the Law of Cosines. Input sides a, b, c. Seek each angle. Input angle A , sides b,c. Seek no solution, 1 solution, or 2 solutions.