Find Function

%3CLINGO-SUB%20id%3D%22lingo-sub-2984924%22%20slang%3D%22en-US%22%3EFind%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2984924%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%202%20groups%20of%20data%2C%20and%20I%20want%20to%20find%20what%20function%20can%20relate%20the%20two%20groups.%20Thanks.%26nbsp%3B%3C%2FP%3E%3CP%3Egroup1%3A%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%220%22%20width%3D%22128%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22128%22%20height%3D%2220%22%3E0.178%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E0.64%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E1.09%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E1.63%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E2.48%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E3.37%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E4.54%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E4.85%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3Egroup2%3A%3C%2FP%3E%3CTABLE%20border%3D%220%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22128%22%20height%3D%2220%22%3E-40%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E-18%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E-7%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E4%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E20%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E38%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E70%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E100%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2984924%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2984948%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2984948%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1223873%22%20target%3D%22_blank%22%3E%40AkeelMaroof%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20explain%20in%20detail%20what%20you%20mean%20by%20%22relate%22.%20Perhaps%20a%20chart%20with%20a%20trendline%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0898.png%22%20style%3D%22width%3A%20771px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F328169i91E20B4BA78B4851%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S0898.png%22%20alt%3D%22S0898.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2985519%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2985519%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi.%20first%2C%20thank%20you%20for%20your%20response.%20second%3A%20I%20meant%20that%20if%20x%3CFONT%20size%3D%221%202%203%204%205%206%207%22%3En%3C%2FFONT%3E%20is%20a%20number%20in%20the%201st%20group%2C%20and%20y%3CFONT%20size%3D%221%202%203%204%205%206%207%22%3En%3C%2FFONT%3E%20is%20a%20number%20in%20the%202nd%20group%2C%20then%20y%3CFONT%20size%3D%221%202%203%204%205%206%207%22%3En%3C%2FFONT%3E%3Df(x%3CFONT%20size%3D%221%202%203%204%205%206%207%22%3En%3C%2FFONT%3E).%20And%20I%20want%20to%20find%20out%20what%20is%20the%20formula%20of%20the%20function%20that%20can%20(relate)%20these%20two%20groups.%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2985697%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2985697%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1223873%22%20target%3D%22_blank%22%3E%40AkeelMaroof%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUnless%20you%20already%20know%20what%20kind%20of%20function%20it%20should%20be%2C%20there%20is%20no%20definite%20answer.%20There%20is%20an%20infinite%20number%20of%20functions%20that%20pass%20through%20all%20the%20data%20points.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOne%20option%20would%20be%20a%20degree%207%20polynomial%2C%20since%20you%20have%208%26nbsp%3B%20data%20points.%20See%20the%20attached%20sample%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, I have 2 groups of data, and I want to find what function can relate the two groups. Thanks. 

group1:                   

0.178
0.64
1.09
1.63
2.48
3.37
4.54
4.85

group2:

-40
-18
-7
4
20
38
70
100
 
5 Replies

@AkeelMaroof 

Please explain in detail what you mean by "relate". Perhaps a chart with a trendline?

S0898.png

@Hans Vogelaar 

Hi. first, thank you for your response. second: I meant that if xn is a number in the 1st group, and yn is a number in the 2nd group, then yn=f(xn). And I want to find out what is the formula of the function that can (relate) these two groups. Thanks.

@AkeelMaroof 

Unless you already know what kind of function it should be, there is no definite answer. There is an infinite number of functions that pass through all the data points.

 

One option would be a degree 7 polynomial, since you have 8  data points. See the attached sample workbook.

I would like to appreciate your answer even I don't know whether this is the only perfect answer.

@AkeelMaroof 

As I mentioned, without knowing what kind of function it should be, there is an infinite number of solutions...