How Do I Calculate the Constants A, B, C, D, and E in My Formula?

  • Context: Undergrad 
  • Thread starter Thread starter patrickbrans
  • Start date Start date
  • Tags Tags
    Data Formula
Click For Summary
SUMMARY

The discussion focuses on calculating the constants A, B, C, D, and E in the formula {(AX+B)*((C(Y+D))^E)}/F=Z. To determine these constants, users need to provide at least five data points, resulting in five equations that can be solved simultaneously. The method of solving these equations will depend on the specific data available. Participants emphasize the necessity of sharing data files for more tailored assistance.

PREREQUISITES
  • Understanding of algebraic equations and systems of equations
  • Familiarity with data analysis tools such as Microsoft Excel
  • Knowledge of mathematical modeling techniques
  • Basic skills in data collection and organization
NEXT STEPS
  • Learn how to use Excel for solving systems of equations
  • Research mathematical modeling techniques for determining unknown constants
  • Explore regression analysis methods for data fitting
  • Study the use of solver tools in Excel for optimization problems
USEFUL FOR

This discussion is beneficial for data analysts, mathematicians, and anyone involved in mathematical modeling or data-driven decision-making processes.

patrickbrans
Messages
4
Reaction score
0
i've collected some datat to get a formula to calculate this data in general. but now the problem is that i don't know how to find that formula.

i think the formula is something like [tex]{(AX+B)*((C(Y+D))^E)}/F=Z[/tex]
but how do i calculate the A,B,C,D and E?

if someone would have my xls with the data, just pm or mail me
 
Last edited:
Mathematics news on Phys.org
I'm sorry but there isn't enough information in your question for us to help you...

You should be able to upload your document when you post, there is a "manage attachments" button below submit reply.
 
Since you have 5 "unknowns", A, B, C, D, E, you will need 5 data points, giving 5 equations. It should be possible to solve those 5 equations for the values but the best way will depend on the data.
 

Similar threads

MHB Understanding Cubic Equation Formula for Polynomials of Degree Three
  • · Replies 9 ·
Replies
9
Views
4K
MHB Standard formula for solving simultaneous equations of the form ax + by + c = 0
  • · Replies 5 ·
Replies
5
Views
2K
MHB Did I Calculate My Funds Distribution Correctly?
  • · Replies 2 ·
Replies
2
Views
2K
High School How to determine D and E given A/(B-C)=D/B + E/C?
  • · Replies 13 ·
Replies
13
Views
2K
High School Forming a formula from a-b=c-d
  • · Replies 3 ·
Replies
3
Views
2K
Undergrad Given a triangle ABC, on which side of the triangle does the point D lie?
  • · Replies 6 ·
Replies
6
Views
2K
MHB How do I use the midpoint formula to find the coordinates of point C?
  • · Replies 2 ·
Replies
2
Views
6K
Undergrad Uncovering the Mystery of Calorie Constants
  • · Replies 1 ·
Replies
1
Views
1K
Undergrad Are there any two pairs of integers with the same result in a specific function?
  • · Replies 7 ·
Replies
7
Views
3K
Graduate How do I calculate the rate constant units for excitation by electron impact?
  • · Replies 1 ·
Replies
1
Views
3K