Solve 320+(x*y)=x*z for x: Excel Formula & Analysis Tips

  • Context: High School 
  • Thread starter Thread starter wasya152
  • Start date Start date
Click For Summary

Discussion Overview

The discussion revolves around solving the equation 320 + (x*y) = x*z for the variable x, with a focus on how to express this in an Excel formula. Participants explore different approaches to rearranging the equation and consider the implications of integer constraints on the variables.

Discussion Character

  • Exploratory
  • Mathematical reasoning
  • Homework-related

Main Points Raised

  • One participant seeks assistance in rearranging the equation to solve for x and expresses a need for an Excel formula.
  • Another participant suggests rearranging the equation to x = 320/(z-y) and mentions using a Mac program for visualization.
  • A different participant questions the meaning of "solve" in this context, indicating a potential misunderstanding of the request.
  • One participant proposes that if x, y, and z are constrained to be positive integers, it leads to a different interpretation of the problem, suggesting that 320/x + y = z could be a useful form.
  • Another participant agrees that the integer constraint makes the problem more interesting but emphasizes that the original request was likely focused on simply isolating x in the formula.

Areas of Agreement / Disagreement

There is no clear consensus among participants. Some focus on rearranging the equation while others discuss the implications of integer constraints, leading to differing interpretations of the problem.

Contextual Notes

Participants have not established specific assumptions regarding the values of y and z, nor have they resolved the implications of integer constraints on the solution for x.

wasya152
Messages
2
Reaction score
0
i'm going an analysis for work, but at stuck at this point. it's been a while since i took math or really used it to this extent. i need to know what the equation would look like in order to solve at what x will both sides be equal. need to put it in as an excel formula. thanks all help is greatly appreciated.
 
Mathematics news on Phys.org
rearranging:

x=320/(z-y)

Do you have access to a Mac? Its 3D 'grapher' program will show you what this looks like in an instant.
 
thanks. that really helped. and unfortunately i don't have a mac.
 
solve? meaning what?
 
wasya152 said:
i'm going an analysis for work, but at stuck at this point. it's been a while since i took math or really used it to this extent. i need to know what the equation would look like in order to solve at what x will both sides be equal. need to put it in as an excel formula. thanks all help is greatly appreciated.

I'm going to take a guess here (because it makes the problem a little more interesting) and assume that x, y and z have to be integer positive numbers? In which case look at it like this:

320/x + y = z

Now if y and z are an integer, that means 320/x has to be, so what are the only possible values of x?

While you can determine the possible values of x, you can only determine a linear (with constant) relationship between y and z, not unless there is some sort of other restriction on the problem.
 
Zurtex said:
I'm going to take a guess here (because it makes the problem a little more interesting) and assume that x, y and z have to be integer positive numbers?

Yes it makes it more interesting but I'm pretty sure that the OP wanted nothing more than to make x the subject of the formula. :)

to solve at what x will both sides be equal. need to put it in as an excel formula
 
Last edited:

Similar threads

High School What went wrong with (-x)^2=x^2?
  • · Replies 22 ·
Replies
22
Views
3K
High School Fractional/decimal powers
  • · Replies 10 ·
Replies
10
Views
3K
High School Are Inverse Problems More Complex Than Direct Problems in Mathematics?
  • · Replies 13 ·
Replies
13
Views
3K
High School Solving Elevator Game: A Formula for Any Params
  • · Replies 26 ·
Replies
26
Views
3K
High School Cartesian Space vs. Euclidean Space
  • · Replies 10 ·
Replies
10
Views
3K
MHB Solve Exponent Problem: 3^x=4^y=12^z
  • · Replies 1 ·
Replies
1
Views
2K
High School Confusion over transposing formulae question
  • · Replies 13 ·
Replies
13
Views
2K
Undergrad Dimensional analysis seems wrong for this equation: z = -1/(x^2+y^2)
  • · Replies 7 ·
Replies
7
Views
1K
Undergrad Can Angular Velocity Accurately Control Ragdoll Limbs in Game Physics?
  • · Replies 6 ·
Replies
6
Views
4K
High School Learn 0^0 w/ Young Aussie of the Year: Calculus & Real Analysis Explained
  • · Replies 14 ·
Replies
14
Views
2K