Ask Your Question

calc, graph of y=2*x^2+5 [closed]

asked 2013-09-10 18:26:26 +0200

altair gravatar image

Hello! Please, can anyone help me to write the graph of the function y=2*x^2+5 in calc? Do I need to make any table first, or is the formula enough? How to get graph directly from the formula?

Many thanks!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-07 23:55:21.220359

3 Answers

Sort by » oldest newest most voted

answered 2013-09-10 19:09:07 +0200

JohnSUN gravatar image

Demonstration calc-graph

edit flag offensive delete link more

answered 2013-09-10 18:39:44 +0200

horst gravatar image

You will need to make a table first and then the graph as x-y-scatter.

edit flag offensive delete link more


Well, as the other answer demonstrates, you don't need an xy-scatter plot/chart - a line chart works too.

bencomp gravatar imagebencomp ( 2014-01-07 21:10:36 +0200 )edit

answered 2013-09-10 22:18:43 +0200

altair gravatar image

Helloe, JohnSUN! PLEASE, how did U get this animated?

Many thanks!!!

edit flag offensive delete link more


Oh, that's easy enough. Fifty presses of PrintScreen button and this program

JohnSUN gravatar imageJohnSUN ( 2013-09-11 10:32:14 +0200 )edit


altair gravatar imagealtair ( 2013-09-11 16:43:21 +0200 )edit

Please use comments to respond to answers. Thanks.

bencomp gravatar imagebencomp ( 2014-01-07 21:11:29 +0200 )edit

Hi JohnSUN, how did you make that trick? I meant Formula you put in $B$2 = 2X^2+5, the sheet turned back the value as if you type = 2[A2]^2 + 5.

TingliChan gravatar imageTingliChan ( 2020-08-27 15:49:33 +0200 )edit

@TingliChan Just open a spreadsheet document, choose Tools - Options - LibreOffice Calc - Calculate and check Automatically find column and row labels

JohnSUN gravatar imageJohnSUN ( 2020-08-27 16:12:06 +0200 )edit

Wow! Thank you.

TingliChan gravatar imageTingliChan ( 2020-08-27 16:20:22 +0200 )edit

I followed the steps in animation. Cells A2 and B2 being copied down A(n) went as expected, B(n) turned out constant which is 205. Why is that so?

TingliChan gravatar imageTingliChan ( 2020-08-28 04:53:37 +0200 )edit

The same behavior if you use the formula =2*A2^2+5, not =2*X^2+5?

JohnSUN gravatar imageJohnSUN ( 2020-08-28 05:01:08 +0200 )edit

Mm-hmm, =2*A2^2+5 was expected to be typed in B2 as a regular spreadsheet user. But I saw the illustration you gave out, it stunned me that a question came to my mind "Is there such a way to make things like that works out?" To me it seems like a new way to work things out. Very much thank you for your kind responses and patience to the newbie like I am.

TingliChan gravatar imageTingliChan ( 2020-08-28 08:22:30 +0200 )edit

It seems to me that yesterday, when I explained about "column labels", everything worked correctly. Now I checked it, I see the same as you. If you save, close and open the document, the results are correct, but the Recalculate (F9) and Recalculate Hard (Ctrl+Shift+F9) have no effect. BTW, select (for example) B7 while it show 205 and press Ctrl+F2 (Function Wizard). Do you see? It show correct result 55. I think that it is bug of current version

JohnSUN gravatar imageJohnSUN ( 2020-08-28 09:23:20 +0200 )edit

Question Tools

1 follower


Asked: 2013-09-10 18:26:26 +0200

Seen: 1,884 times

Last updated: Sep 10 '13