The Excel Circle Challenge

Trigonometry equalities, inequalities and expressions - sin, cos, tan, cot

The Excel Circle Challenge

Postby Stanley Gould » Mon May 20, 2019 2:24 pm

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).

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

Problem #2 - calculate a line segment's terminal coordinates on the circle's circumference, whose slope is '1' and its origin coordinate 'x' is given as 0<x>1, and its origin coordinate 'y' is given as: 0<y>1.
Problem #3 - Optional Excel Function Code - if you are familiar with Excel VBA coding, this formula needs to be converted into an Excel VBA function statement.

The basic formula's origin coordinates values will be re-iteratively calculated from the previous calculation. The calculations will be performed using Excel VBA to make the data set as simple as possible, using a language that students can expand upon as needed, for problem extensions.
Stanley Gould
 
Posts: 2
Joined: Mon May 20, 2019 2:18 pm
Reputation: 0

Re: The Excel Circle Challenge

Postby Stanley Gould » Tue May 21, 2019 1:16 pm

The original post included some errors and needed clarification. I could not locate the means by which to correct the original post and therefore include the corrected post below:

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
 
Posts: 2
Joined: Mon May 20, 2019 2:18 pm
Reputation: 0


Return to Trigonometry - sin, cos, tan, cot, arcsin, arccos, arctan, arccot



Who is online

Users browsing this forum: No registered users and 3 guests