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 UnitCircle (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 unitcircle's first (45degrees) 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 (yintercept 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. 
May 21st, 2019, 03:09 PM  #2 
Global Moderator Joined: Dec 2006 Posts: 20,969 Thanks: 2219 
On each edge of the first octant, at least one point has 0 as its xcoordinate and at least one poiint has 0 as its ycoordinate, so it doesn't make sense to specify "all x and y coordinates have positive values, within or upon the edges of the octant".


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 midpoint 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 semicircle 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 