Graphing spreadsheet results

Lee Creighton shared this question 1 year ago
Answered

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.

Comments (15)

photo
1

If you have numbers in A and B columns then


C1=(A1,B1)

and copy down


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

photo
1

...

photo
1

I can't seem to get anything going, as the spreadsheet does unexplained things. There's no way to erase what you've done int he past and have GeoGebra fill into the newly blank cells. And there's no way to reset the spreadsheet.

photo
photo
1

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

photo
1

Thanks for this -- i fixed it.

photo
photo
1

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.

photo
1

as indicated by michael

Files: foro.ggb
photo
1

or you can create only a point and a locus

Files: foro.ggb
photo
1

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?

photo
1

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

photo
1

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

photo
1

They both open fine for me. Please be more precise than "Neither of those files open" and make sure you have the latest version

photo
photo
1

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.

photo
1

dfd8656eb8d747dd72cb227097da58b6

photo
photo
1

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.

© 2020 International GeoGebra Institute