Finding the equation from a set of numbers

bobbym · 2011-07-07 04:22:11

Hi;

I remind you that i want an equation of this format: A=B+k*C , mainly i want to find k, but from inserting 4000 A,B and C values.

4000 data entries is not a big problem for Mathematica. You must make sure that the data is entered correctly.

Old_Trafford · 2011-07-07 04:23:28

Yeah, thats the main problem.

Old_Trafford · 2011-07-07 04:24:33

I have already provided you with 3 values. Could you please tell me how exactly to enter these 3, and then i will add the rest?

bobbym · 2011-07-07 04:42:50

Hi;

The first thing that needs to be done is the data should be entered into mathematica like this: B , C , A and right now you have A,B,C for your columns.

Old_Trafford · 2011-07-07 04:46:59

data={{1,3,8},{2,5,13},{3,8,17}}

When i enter the data in the brackets, it is:

1) data={{B,C,A},{B,C,A},{B,C,A}}

OR

2)data={{B,B,B},{C,C,C},{A,A,A}}

?

bobbym · 2011-07-07 04:49:37

Hi;

We are looking for

data={{B,C,A},{B,C,A},{B,C,A}}, that is B's in the first position, C's in the middle and A's on the right.

Old_Trafford · 2011-07-07 04:59:07

Thanks for everything, i will return from more questions later. Cheers.

bobbym · 2011-07-07 05:06:16

bobbym wrote:

We are looking for
data={{B,C,A},{B,C,A},{B,C,A}}, that is B's in the first position, C's in the middle and A's on the right.

If you can not do that manually we can have mathematica do it for us.

Old_Trafford · 2011-07-08 00:25:00

How can mathematica do this?

bobbym · 2011-07-08 00:27:35

What kind of file type is your data stored in?

Old_Trafford · 2011-07-08 00:30:12

excel

Old_Trafford · 2011-07-08 00:32:02

do you want me to send you the file?

bobbym · 2011-07-08 00:34:17

If you want or I can show you how to do it yourself. It will take some trial and error.

Old_Trafford · 2011-07-08 00:38:31

I prefer you to show me how to do it, because i will want to do it again in the future

Old_Trafford · 2011-07-08 00:39:34

i have 3 columns on the excel, with A,B and C inside it.

bobbym · 2011-07-08 00:41:39

The first problem is how to get the data from the file into mathematica for processing...

I need to know a few things about the structure you have chosen. You said your file had this form:

508.463 29.8554 33.3831
515.271 29.8752 33.5417
522.866 29.9544 33.6408
A B C

The data has commas between them or not?

Old_Trafford · 2011-07-08 00:45:58

can you send me your email so you can see the file please?

bobbym · 2011-07-08 00:48:06

Hi;

[Deleted by Moderator]

Old_Trafford · 2011-07-08 00:51:53

I sent it

Old_Trafford · 2011-07-08 00:55:59

Solar Irradiance is A, Ambient Temperature is B and Module Temperature is C

bobbym · 2011-07-08 01:09:21

Okay I have the data. I will need some time now.

Old_Trafford · 2011-07-08 01:15:24

Thank you

bobbym · 2011-07-08 01:18:55

Is the first piece of data 508.463?

Old_Trafford · 2011-07-08 01:40:53

yes

bobbym · 2011-07-08 02:01:06

Hi;

I have the data and it is in mathematica. Before I switch columns I have notices a problem in your data. There is a bunch of .741

Here are the first 2:

.741 28.0122 24.3655
.741 27.9527 24.3457
etc.

Duplicates might upset the fitting algorithm after all how can different inputs yield the same A?

Math Is Fun Forum

#26 2011-07-07 04:22:11

Re: Finding the equation from a set of numbers

#27 2011-07-07 04:23:28

Re: Finding the equation from a set of numbers

#28 2011-07-07 04:24:33

Re: Finding the equation from a set of numbers

#29 2011-07-07 04:42:50

Re: Finding the equation from a set of numbers

#30 2011-07-07 04:46:59

Re: Finding the equation from a set of numbers

#31 2011-07-07 04:49:37

Re: Finding the equation from a set of numbers

#32 2011-07-07 04:59:07

Re: Finding the equation from a set of numbers

#33 2011-07-07 05:06:16

Re: Finding the equation from a set of numbers

#34 2011-07-08 00:25:00

Re: Finding the equation from a set of numbers

#35 2011-07-08 00:27:35

Re: Finding the equation from a set of numbers

#36 2011-07-08 00:30:12

Re: Finding the equation from a set of numbers

#37 2011-07-08 00:32:02

Re: Finding the equation from a set of numbers

#38 2011-07-08 00:34:17

Re: Finding the equation from a set of numbers

#39 2011-07-08 00:38:31

Re: Finding the equation from a set of numbers

#40 2011-07-08 00:39:34

Re: Finding the equation from a set of numbers

#41 2011-07-08 00:41:39

Re: Finding the equation from a set of numbers

#42 2011-07-08 00:45:58

Re: Finding the equation from a set of numbers

#43 2011-07-08 00:48:06

Re: Finding the equation from a set of numbers

#44 2011-07-08 00:51:53

Re: Finding the equation from a set of numbers

#45 2011-07-08 00:55:59

Re: Finding the equation from a set of numbers

#46 2011-07-08 01:09:21

Re: Finding the equation from a set of numbers

#47 2011-07-08 01:15:24

Re: Finding the equation from a set of numbers

#48 2011-07-08 01:18:55

Re: Finding the equation from a set of numbers

#49 2011-07-08 01:40:53

Re: Finding the equation from a set of numbers

#50 2011-07-08 02:01:06

Re: Finding the equation from a set of numbers

Board footer