My Math Forum  

Go Back   My Math Forum > High School Math Forum > Trigonometry

Trigonometry Trigonometry Math Forum


Reply
 
LinkBack Thread Tools Display Modes
May 21st, 2019, 09:36 AM   #1
Newbie
 
Joined: May 2019
From: Colorado

Posts: 1
Thanks: 0

The Excel Circle Challenge

The following formula solution request will be used within a High School students Math class challenge problem.

The general problem is to create one formula that combines the Unit-Circle (radius = 1) equation (x^2+y^2 = 1) and the Slope Intercept equation for a line segment (y = mx+b).

The problem space is inside of a unit-circle's first (45-degrees) octant (note - all x and y coordinates have positive values, within or upon the edges of the octant).

Formula #1 - calculate a line segment (whose slope is '2') terminal coordinates on the circle's circumference, and its origin coordinate is x=0 (y-intercept is 0) and y is given as: 0<y<1.

Formula #2 - calculate a line segment (whose slope is '1'), terminal coordinates on the circle's circumference, and its origin coordinate 'x' is given as 0<x<1, and its origin coordinate 'y' is given as: 0<y<1.

Optional Excel Function Code - if you are familiar with Excel VBA coding, this formula needs to be converted into an Excel VBA function statement. before students can use this. Your help would be greatly appreciated.

My request is to receive the two formulas (#1 & #2), which are intended to compute each line segment's terminal coordinates, with the line slope values included within the formulas, as constants. The formula will produce the terminal x,y coordinates for each line segment. Thank you.
Stanley Gould is offline  
 
May 21st, 2019, 03:09 PM   #2
Global Moderator
 
Joined: Dec 2006

Posts: 20,746
Thanks: 2133

On each edge of the first octant, at least one point has 0 as its x-coordinate and at least one poiint has 0 as its y-coordinate, so it doesn't make sense to specify "all x and y coordinates have positive values, within or upon the edges of the octant".
skipjack is offline  
Reply

  My Math Forum > High School Math Forum > Trigonometry

Tags
challenge, circle, excel



Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Formula Help rfhitter Algebra 3 September 8th, 2017 03:22 PM
Line length from mid-point circle to outside diameter circle Byte Geometry 3 March 29th, 2017 03:56 PM
Excel formula help CherryTash Algebra 6 February 4th, 2016 05:23 PM
Area enclosed by a semi-circle and a quarter circle yeoky Algebra 4 May 3rd, 2014 01:06 AM
Excel and 3D cubes danblukk Algebra 1 April 11th, 2010 10:55 AM





Copyright © 2019 My Math Forum. All rights reserved.