S
SMUboi
Hey guys,
I am new to the forums here, I just started doing excel as a researc
assistant at my school. I cannot figure out how to do this RMSE proble
i have. I dont know it I need an add-in or what. Anyway i will try m
best to explain, here goes.
RMSE= sqrt((1/N)*sum((x-x')/x)^2)
My RMSE's have to do with food tempurature, so i need an RMSE for ever
experimental tempurature difference i have. So i need a RMSE for 1-40
0-30, 3-29 and everything inbetween. 40*39/2 = 800 cells.
My x and x' come from 2 different columns on two different sheets.
My N in the is the difference between the two temperature values t
find RMSE for. Also x and x' change with the chosen temp values, say m
values are 4 degrees and 20 degrees then x and x' start with the value
in the 4th row and end with the values in the 20th row for summation
What i have been asked to do is create a function for one cell that
can drag to a 2d array of cells in excel to create ALL these RMS
values. So my columns would be labeled 0-40 and rows labeled 0-39. Thi
way you can simply look at the table, line up the row and colum
depending on the temperatures you need, and see the proper RMSE value
So is there any good programs out there from doing RMSE or can someon
help me do this, or can it be done?
I have tried my best to explain, and will answer any questions.
If you guys could help it would be greatly appriciated
thanks in advanc
I am new to the forums here, I just started doing excel as a researc
assistant at my school. I cannot figure out how to do this RMSE proble
i have. I dont know it I need an add-in or what. Anyway i will try m
best to explain, here goes.
RMSE= sqrt((1/N)*sum((x-x')/x)^2)
My RMSE's have to do with food tempurature, so i need an RMSE for ever
experimental tempurature difference i have. So i need a RMSE for 1-40
0-30, 3-29 and everything inbetween. 40*39/2 = 800 cells.
My x and x' come from 2 different columns on two different sheets.
My N in the is the difference between the two temperature values t
find RMSE for. Also x and x' change with the chosen temp values, say m
values are 4 degrees and 20 degrees then x and x' start with the value
in the 4th row and end with the values in the 20th row for summation
What i have been asked to do is create a function for one cell that
can drag to a 2d array of cells in excel to create ALL these RMS
values. So my columns would be labeled 0-40 and rows labeled 0-39. Thi
way you can simply look at the table, line up the row and colum
depending on the temperatures you need, and see the proper RMSE value
So is there any good programs out there from doing RMSE or can someon
help me do this, or can it be done?
I have tried my best to explain, and will answer any questions.
If you guys could help it would be greatly appriciated
thanks in advanc