MHB Need help with a work related math problem

  • Thread starter Thread starter semaxus
  • Start date Start date
  • Tags Tags
    Work
Click For Summary
The discussion revolves around a user struggling with a math problem related to pricing for wooden sauna cabins based on their dimensions. The user has an Excel table showing width and height against price but finds it challenging to determine a mathematical relationship due to the non-linear nature of the price increase. There is a suggestion that creating a complex formula may not be necessary, as the data points could be approximated by a polynomial equation. The user seeks assistance in formulating a solution to this pricing problem. Overall, the conversation highlights the difficulty of deriving a clear mathematical relationship from the given data.
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: 100
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

  • · Replies 5 ·
Replies
5
Views
2K
  • · Replies 12 ·
Replies
12
Views
3K
Replies
4
Views
2K
  • · Replies 7 ·
Replies
7
Views
470
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 11 ·
Replies
11
Views
3K
  • · Replies 2 ·
Replies
2
Views
1K
Replies
2
Views
3K
  • · Replies 9 ·
Replies
9
Views
2K
  • · Replies 49 ·
2
Replies
49
Views
5K