Graphing Question (Software Related)

  • Thread starter SRForum
  • Start date
  • Tags
    Graphing
In summary: MS Excel can do a curve fit from a data table. It can even give you an equation for the graph. In summary, Excel can do a curve fit from a data table to create a graph.
  • #1
SRForum
6
0
Hello everyone,

For a Physics Lab, I have to graph the acceleration of an object. I was curious as to which programs would be reccomended in using, keeping in mind that it has to contain a smooth curve. Thanks in Advance,

SRForum.
 
Physics news on Phys.org
  • #2
MS Excel can do a curve fit from a data table. It can even give you an equation for the graph. Have you tried that?
 
  • #3
Nope, I haven't. But I've been told that Excel can't do that? But I will give it a shot personally, thanks. When you say equasion, do you mean like a parabala?
 
  • #4
It absolutely can. Plot your data. In the plot left click on the data series once and then right click. The menu that pops up will have an option to "Insert Trendline." If the acceleration is a constant, select linear from the type. Also, go to the options tab and put a check mark in the "display equation" and "display R^2 value" to have the regression equation shown on your plot.
 
  • #5
If you have never plotted graphs using Excel before, here is a quick primer.

(1) pair your data in two columns, left column for horizontal axis, right column for vertical axis
(2) highlight both columns
(3) select the chart wizard (icon in toolbar or with pulldown menu Insert>Chart chart type - choose XY scatter, sub-type - data points connected by smoothed lines. The subtype appears as an icon (read text below find the one with smoothed lines)
(4) continuing with the wizard, you will have option to Label your - Chart Title, X-axis and Y-axis. You can keep a Legend or delete it
(5) To view your graph, select it and with pulldown menu and select File>Print Preview

There are lots of ways you can manipulate your plot after that, like getting rid of the default gray background, replace it with no background color; adding vertical lines, choosing your own endpoints for horizontal and vertical axes. If you are curious how to do that, just ask.. or your can learn how to use these features from the Excel Help files.
 
  • #6
Thank you all! I managed to get exactly what I've wanted through Excel, you guys are great.

Thanks again,

SRForums
 

FAQ: Graphing Question (Software Related)

How do I create a graph using graphing software?

To create a graph using graphing software, you will first need to input your data into the software. Then, you can choose the type of graph you want to create and customize it with labels, colors, and other features. Once you are satisfied with your graph, you can save it or export it to use in other programs.

Which graphing software is the best for beginners?

There are many graphing software options available, but some popular choices for beginners include Microsoft Excel, Google Sheets, and Tableau Public. These programs offer user-friendly interfaces and a variety of graphing options.

Can I import data from other programs into graphing software?

Yes, most graphing software allows you to import data from other programs such as Excel, CSV files, or text files. This can save time and effort when creating graphs with large amounts of data.

Is there a limit to the number of data points I can use in a graph?

This depends on the specific graphing software you are using. Some programs have a limit on the number of data points, while others can handle large datasets. It is best to check the software's documentation or contact the provider for more information.

How can I customize the appearance of my graph?

Most graphing software allows you to customize the appearance of your graph by changing the colors, fonts, labels, and other features. You can also add titles, legends, and annotations to make your graph more informative and visually appealing.

Back
Top