What is the formula for calculating approximate costs using multiple variables?

Click For Summary
SUMMARY

The discussion centers on the formula for calculating the price of a good (P) using multiple variables (k1, k2, k3) with respective coefficients (a, b, c). The formula is expressed as P(k1, k2, k3) = ak1 + bk2 + ck3. To determine the coefficients a, b, and c, the user suggests employing multivariable regression techniques based on historical purchase data where the values of k1, k2, k3, and P are known. The user seeks assistance in applying these regression methods effectively.

PREREQUISITES
  • Understanding of multivariable regression analysis
  • Familiarity with statistical software or programming languages (e.g., R, Python)
  • Basic knowledge of linear equations and their applications
  • Experience with data collection and preprocessing
NEXT STEPS
  • Research "Multivariable Regression Techniques in Python" for practical implementation
  • Explore "Statistical Analysis with R" to analyze historical purchase data
  • Study "Linear Regression Models" to understand coefficient estimation
  • Learn about "Data Preprocessing for Regression Analysis" to prepare datasets
USEFUL FOR

This discussion is beneficial for data analysts, statisticians, and anyone involved in pricing strategy or predictive modeling using regression analysis.

sergey
Messages
1
Reaction score
0
Hello!
I have the following formula -
a*k1 + b*k2 + c*k3 = P
This is a formula I'm trying to build. It will be used to calculate price of a specific good (P) according to criterions k1,k2,k3. Every k have its own value, that's why its being multiplied by coefficients a,b and c.
I have a history of many previous purchases where k1,k2,k3 and P are known and i need to approximately calculate a,b and c according to this.

Hope i explained this well.
Can someone help me with this?
 
Physics news on Phys.org
Just an idea:

[tex]P[/tex] is a function of [tex]k_1, k_2,[/tex] and [tex]k_3.[/tex]
So the multivariable formula is in the form [tex]P(k_1, k_2, k_3) = ak_1 + bk_2 + ck_3[/tex].

If you have many values of [tex]P[/tex] and [tex]k[/tex] in the formula [tex]P(k) = ak[/tex], you would run a single variable regression on the data to find a reasonable value of [tex]a[/tex]. Thus far, I am not fluent in multivariable regression, so here is a http://www.nd.com/NSBook/NEURAL%20AND%20ADAPTIVE%20SYSTEMS17_Regression_for_Multiple_Varia.html" that might help.
 
Last edited by a moderator:

Similar threads

  • · Replies 2 ·
Replies
2
Views
2K
Replies
4
Views
2K
Replies
6
Views
2K
  • · Replies 3 ·
Replies
3
Views
2K
  • · Replies 1 ·
Replies
1
Views
2K
Replies
3
Views
2K
Replies
5
Views
2K
  • · Replies 9 ·
Replies
9
Views
3K
  • · Replies 3 ·
Replies
3
Views
3K
  • · Replies 7 ·
Replies
7
Views
2K