Graphing With Desmos, Excel & Google Sheets

CLICK HERE to go to Graphing With Google this is BY Far the easiest option and it has the MOST features too!

CLICK HERE to go to Graphing With Excel

USING DESMOS is kinda cool, but it's also a pain in the butt sometimes!

1) Click HERE to go to Desmos website

2) Click on the plus sign icon and select table

3) Type your data into the table and add x and y axis (don't forget UNITS):

4) To 'connect the dots' type in the basic equation for a line if your data is linear (Scroll down a bit to see how to match a curve):

Graphing Curves with Desmos:

Type in your data as usual by clicking on the "+" icon and selecting "table" and notice that your data is clearly not linear:

Click on the "+" icon as before and select "Expression" and type in the quadratic(?) regression formula: y1~ax12 + bx1 + 1 as shown below (don't forget the subscripts!)

But wait, there's more. That just shows us how well we can match a curve to our data.

We want to show actual best fit values and also restrict the domain of our expression(in this case we are not interested in x<0)

To do that, type in the regression equation WITHOUT subscripts in a new line in desmos (don't forget to click on the circle icon to hide the original regression curve).

Also, you can add additional domain restrictions simply by typing them into additional curly braces {x<5} for example

NOTE: You can restrict the doman to specific values using curly braces:

USING EXCEL (Office 365 Version): 

1) Create a table in Excel with your "x" values in the first column and "y" values in the second column.

2) Highlight all of that data as shown (notice the data labels and data are selected but the title is not-- that's important):

3) Select *Insert* and *Scatter* from the menus as shown below:

4) Notice no line is present on the graph (yet!). Click on one of the data points on the graph and then right click to select "Add Trendline" from the pop-up menu as shown below

Your graph should look like this:

5) Now you have to add labels and such by clicking on the blue "+" sign as shown:

With labels edited:

6) NOTICE that you can cut and paste the graph out of the current page into a brand new tab where it will be a little easier to adust/edit/print (The graph is linked so if you change the data it will change the graph too

GRAPHING WITH GOOGLE SHEETS:

NEW FORMAT (1/19/2018)

1) Go to Google Docs, Select New and Google Sheets

2) Type or paste in your data with x values in the first column and y values in the second column as shown below:

3) From the Google Sheets Menu Bar select <Insert> <Charts> and the default bar graph appears (we pretty much NEVER use bar graphs by the way):

3) Change the graph type to Scatter by clicking on the "Chart Type" drop down list in the upper right part of that chart screen. The chart will change:

4) Now we have to add a line-of-best-fit (Trend Line). Double click on one of your data points on your Google Chart. The following screen appears.

5) Use the slider bar to scroll down a bit until the Treadline Option appears. Select that option by clicking on it and the trendline *should* appear:

6) Make sure that "type" is set to "Linear". There is a bit of a bug here in that sometimes the trendline won't appear on your graph after clicking on the Trendline option box. If that happens, click the drop down button below the "Type" option and reselect Liner... that should do it!

Explore using the various options to format your report for font, font size, font weight, title etc...

OLD GOOGLE SHEETS/CHARTS FORMAT

1) Go to Google Docs, Select New and Google Sheets

2) Type or paste in your data with x values in the first column and y values in the second column as shown below:

3) Highlight/Select the data as shown below:

4) From the menu bar at the top of the screen select "Insert" and then choose "chart" to see the display shown below:

5) Making the Graph

a) Select the "Chart Types" tab at the top of that screen and scroll down to "Scatter Plot" as shown below

 

b) Now select the "Customization Tab" at the top of the screen. Scroll down to the very bottom and find "Trendline". Change the dropdown there to "Linear"

c) Then click on the "Insert" button to place that chart on your sheet

NOTE: Most of the editing/customization is done on this screen BEFORE you click on insert. Although some editing can be done afterwards, you may find it easier to just delete the existing graph and start over fro scratch.

NOTICE also that you can cut and paste the graph into a new tab. The data is linked so the graph will change as your data changes