Results 1 to 3 of 3

Math Help - Excel and 3d cube matrices

  1. #1
    Newbie
    Joined
    Feb 2010
    Posts
    4

    Excel and 3d cube matrices

    I have been given a piece of course work for university, see attachment. I have completed questions 1 and 2 but am completely stumped with question 3 as the 3d stuff has thrown me off and dont even know how to get the cubes cordinates in 3d for excel.

    I sure this is childs play for some of the experts on here but a little help with the cordinates and transformations will be much apreciated.

    thank you
    Attached Files Attached Files
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Grand Panjandrum
    Joined
    Nov 2005
    From
    someplace
    Posts
    14,972
    Thanks
    4
    Quote Originally Posted by danblukk View Post
    I have been given a piece of course work for university, see attachment. I have completed questions 1 and 2 but am completely stumped with question 3 as the 3d stuff has thrown me off and dont even know how to get the cubes cordinates in 3d for excel.

    I sure this is childs play for some of the experts on here but a little help with the cordinates and transformations will be much apreciated.

    thank you
    It might be child's play but most won't open an office attachment, try retyping the question in the text entry box

    CB
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Newbie
    Joined
    Feb 2010
    Posts
    4
    ok, sorry





    Question 1


    Solve the matrix equation A X + I = B


    where A=, B= and I is the 2x2 identity matrix.


    -1 -3
    2 0





    Question 2


    Using Excel, produce your own design of the 2D image of a building (front or side elevation) which has one of its vertices at the point with coordinates (5,4).


    Rotate your image about the point (5,4) in an anticlockwise direction through an angle of 75o.Then reflect the rotated image in the straight line 2y=x+3.


    Determine the single 3x3 matrix which performs this transformation and produce a plot of the original image and the transformed image on the same graph.


    Marks will be awarded for the design of your building.


    Question 3


    A cube has vertices (0,0,0),(0,1,0),(1,1,0),(1,0,0),(1,0,1),(1,1,1),(0 ,1,1),(0,0,1).


    The cube is rotated about the y-axis through an angle of 40o and then translated downwards (in the negative y direction) by 3. The image is then projected onto the viewing plane z=0 and viewed from the point (0,0,4).


    Determine the overall 4x4 transformation matrix and calculate the position of the two vanishing points.


    Using Excel, produce a picture showing the transformed cube and the vanishing points.



    cheers
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. help in excel
    Posted in the Math Software Forum
    Replies: 1
    Last Post: May 26th 2011, 06:29 AM
  2. Cube Root times Cube Root
    Posted in the Pre-Calculus Forum
    Replies: 6
    Last Post: December 1st 2009, 07:03 AM
  3. The Hilbert cube homeomorphic to the cube?
    Posted in the Differential Geometry Forum
    Replies: 0
    Last Post: June 12th 2009, 10:35 AM
  4. excel
    Posted in the Math Software Forum
    Replies: 8
    Last Post: April 23rd 2008, 08:48 AM
  5. Excel
    Posted in the Math Software Forum
    Replies: 1
    Last Post: August 13th 2007, 06:26 PM

Search Tags


/mathhelpforum @mathhelpforum