# Graphing spreadsheet results

Using Geogebra Classic under macOS "Mojave"

I made a nice drawing of a square involving sliders, interconnected lines, etc. These lines made a smaller square in the center of the larger one.

I've figured out how to use the sliders to generate points in a spreadsheet. I now want to graph those points to show the pattern they make. I see there are a couple of regression options, but I can't figure out how to just make a scatterplot.

I will admit I got a little confused with all the windows open, each obscuring what could be important parts of the other.

I saw this problem in Ed Moise's Geometry book (it's in every edition, even in his preliminary notes that the SMSG handed out in the 1950s), which asked students to find the area of the inside square when the points were at the midpoints of each side. Trivial with GeoGebra, but with the ratios of the lengths as x and the ratio of the areas as y, I should get a nice rational function that approaches an asymptote (if you see the picture, you'll know what it is). I'd like the kids to figure out what the formula for that rational function is. But they can't do that without a picture of the function itself.

Square in Square found at https://www.geogebra.org/m/e7kdcjwe.

If you have numbers in A and B columns then

and copy down

Alternatively you could do it using https://wiki.geogebra.org/e... (without the spreadsheet)

definition of y is inverted in the text of your applet. if the ratio>1 the great area must be the numerator

Apparently I did a poor job of saying what my problem is.

I can draw the shapes in the Geometry app. You can see that in my file.

I can get two perfectly good columns of numbers in the spreadsheet app.

Where I am stuck:

Once I have two columns of numbers in the spreadsheet app that were taken from the geometry app, how do I get a graph of those points on an xy-plane? I’m asking what are the steps, the clicks, the commands, that one uses to go from two lists of numbers to a graph of those two lists. The solution needs to take into account that I’m using the geometry app and the spreadsheet app already. I cannot figure out how to do it.

Note that my problems have nothing to do with manipulating the numbers inside the spreadsheet itself. I just want to graph the points, but without using the pane that my geometry graph is on.

as indicated by michael

or you can create only a point and a locus

Wow, you guys are all about the terse answers. I don't know what Michael is telling me to do. Nor do I know what you mean about creating a point and a locus. I've got a set problem and a solution construction that I'd expect Geometry students to be able to do. I'd like to gather their data to a spreadsheet and graph it. Can I get more than a ten word phrase that answers the question?

the answers are in the attached files

open the attached files and then open "construction protocol" view

you can see and analize the methods used in each one

or I can explain it to you in spanish lang

Neither of those files open in Geogebra Classic 6 or in the GeoGenra standalone app.

When I try to open these files on my Mac, it said there was no application associated with it. To determine which application I should use, I used GeoGebra Geometry to try and open it, and received a message that this was not a GeoGebra file. I tried again with GeoGebra Classic and received the same error.

And I have the latest version.

Since this thread is not progressing toward an answer to my question, I opened another one and Michael closed it, referring people to this one. That was also not helping me get an answer to my question.

I opened a third and got a reasonable answer first time: GeoGebra Classic can't record points using Record to Spreadsheet and then plot those points in another graph window. I also got a script that will allow this functionality, but I am doing a presentation and don't want to highlight something GeoGebra can't do. I'll try other options to get the lesson to work.

Loading...Comments have been locked on this page!