Ask Your Question
0

how to get correct results from multiple operations with two variables with LibreOfficev.4.3.3.2?

asked 2015-05-07 12:57:27 +0100

cale gravatar image

updated 2015-08-27 20:29:43 +0100

Alex Kemp gravatar image

I use LibreOffice v.4.3.3.2 under Linux. I met difficulties with multiple operations with two variables, and went back to the help function, redoing the example provided there, step by step. Instead of the results presented in the example, I obtained the following: 8 10 15 20 500 -6016 -5020 -2530 -40 1000 -2016 -20 4970 9960 1500 1984 4980 12470 19960 2000 5984 9980 19970 29960 2500 9984 14980 27470 39960 3000 13984 19980 34970 49960 3500 17984 24980 42470 59960 4000 21984 29980 49970 69960 4500 25984 34980 57470 79960 5000 29984 39980 64970 89960

I replicated the example a few times, with the same output. I cannot trace the originin of the divergence and become concerned with using the tool. Can you please help?

edit retag flag offensive close merge delete

Comments

Do you use the function directly or do you use the wizard? What task do you want to solve with "multiple operations"?

Regina gravatar imageRegina ( 2015-05-07 16:36:48 +0100 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2015-05-07 16:56:26 +0100

m.a.riosv gravatar image

Works for me. Attached a file with help sample.

  • Select D1:F11
  • Menu/Data/Multiple Operations.

image description

Ok.

image description

edit flag offensive delete link more

Comments

Thanks a lot. You're right -- it works as it should. I guess my problem was due to some fatigue leading me to a dichotomy between what i was thinking and what I was writing. Now I can go back to my original problem and pursue the quest. Cale

cale gravatar imagecale ( 2015-05-10 16:08:10 +0100 )edit
0

answered 2015-05-08 01:31:34 +0100

Regina gravatar image

I have made an example for you to use MULTIPLE.OPERATIONS without the wizard. Start reading on the first sheet. ExampleMultipleOperations.ods.

If you still see problems, please provide a tiny example document.

edit flag offensive delete link more

Comments

Thanks for the example. I shall walk through and replicate it to get more insights. Meanwhile, the object of my question is overcome -- I had just messed up the references for rows and columns. I am trying to get 3 parameters for fitting a nonlinear curve through a Monte Carlo simulation or a bootstrap procedure. I shall let you know about my walk through your example. Cale

cale gravatar imagecale ( 2015-05-10 16:21:42 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-05-07 12:57:27 +0100

Seen: 149 times

Last updated: May 08 '15