Need help with a work related math problem

  • Context: MHB 
  • Thread starter Thread starter semaxus
  • Start date Start date
  • Tags Tags
    Work
Click For Summary
SUMMARY

The discussion revolves around a math problem involving the relationship between the dimensions of a wooden sauna cabin (width X and height Y) and its price, as presented in an Excel table. The user struggles to formulate an equation to describe this relationship, noting that the price increases non-linearly with size. A suggestion is made that a polynomial equation could be used to approximate the relationship, given the large number of data points available.

PREREQUISITES
  • Understanding of basic algebra and polynomial equations
  • Familiarity with Excel for data analysis
  • Knowledge of non-linear regression techniques
  • Ability to interpret data from graphs and tables
NEXT STEPS
  • Learn how to perform polynomial regression in Excel
  • Research non-linear regression analysis methods
  • Explore data visualization techniques to better understand price trends
  • Study the principles of mathematical modeling for real-world applications
USEFUL FOR

This discussion is beneficial for individuals involved in data analysis, pricing strategy, or anyone needing to apply mathematical modeling to real-world scenarios, particularly in construction or product pricing.

semaxus
Messages
1
Reaction score
0
Hello guys, I confess that I absolutely suck at math. Unfortunately my boss handed me what is basically a math problem I got to solve, and I have no idea how to do it cause of lack of my math skills. I am hoping someone can help me with this or I'm screwed.

Co basically I've got this table in excel, where X (row) is a width and Y is a height (column) of a wooden sauna cabin, the X;Y is the price for a sauna with said dimensions. I need to find a relationship between the size of the sauna and the price And formulate ani equation. I can't seem to find it, the price seems to grow non linearly, I can't seem to find any coeficient. Again, I suck at math, maybe solution is simple, but I just don't see it. Can anyone help me please?

Table Is at this link https://ibb.co/fGrxSvf . Thanks for any help!
 

Attachments

  • Bez názvu.jpg
    Bez názvu.jpg
    86.3 KB · Views: 105
Physics news on Phys.org
You have the information in a table form where you can easily read off the information you need. I can't imagine why you would want a "formula" that either would be extremely complex (Generally speaking "n" data points can be calculated by a polynomial of degree n-1. Here you have a large number of data points!) or is only approximate, if not both.
 
Last edited:

Similar threads

Graduate Solve Line Integral Question | Get Math Help from Physics Forums
  • · Replies 5 ·
Replies
5
Views
2K
Undergrad How do Tensors "work" in relation to linear algebraic objects?
  • · Replies 7 ·
Replies
7
Views
876
MHB Regularization of an Non-conergent Integral
  • · Replies 1 ·
Replies
1
Views
2K
Other Math Help for Physics Undergrad: Advice Needed
  • · Replies 9 ·
Replies
9
Views
2K
Other Where Can I Find Challenging Math Puzzles for Calculus 2 and Beyond?
  • · Replies 49 ·
2
Replies
49
Views
5K
MHB A relatively simple integral problem....
  • · Replies 7 ·
Replies
7
Views
2K
MHB Real Estate math word problem help
  • · Replies 3 ·
Replies
3
Views
2K
MHB Rigorous definition of "Differential"
  • · Replies 7 ·
Replies
7
Views
4K
MHB Expanding Brackets: Math Help for 2nd Term Maths
  • · Replies 4 ·
Replies
4
Views
2K
Relativity Introduction Math for General Relativity - Engineers
  • · Replies 16 ·
Replies
16
Views
3K