Graphing Assignment
Graphing Assignment
This is an in individual assignment. It must be YOUR work. The assignment must be submitted on Crowdmark by Monday, March 3th, 2025.
Exercise 1:
In the lab you collected a set of data, V(x). Make a graph of the data. The graph should:
a) have the axes labelled.
b) show the data points clearly.
c) show error bars. (You may want to change the data point markers to circles and reduce their size so that you’ll be able to see the error bars clearly.)
d) show an Excel trendline.
e ) show an equation which describes the trendline. The equation should include an estimate of the uncertainties on the slope and intercept (appropriately rounded). To estimate the uncertainties, use the Excel function LINEST.
Submit the following:
- A copy of your spreadsheet data with calculated and appropriately rounded uncertainties. (Make sure that everything in the table is labelled. Show the LINEST output).
- The graph should be separate and fill an entire page.
Exercise 2:
a) In Excel, Create a table of y vs x for the function
y = 7x5
for x=0 to 10 in steps of 0.5. Plot a graph of y vs x. Presumably the graph is as you expected…
b) For the function in part (a), plot a graph of y vs x5. Use the Excel trendline function to find the slope and intercept of the resulting line.
Submit the following:
- A copy of the graph in part (b) showing the trendline and the equation that describes it.
- Explain how the slope and intercept are related to the parameters in the original y(x) function.
Exercise 3:
a) For the same function in part Exercise 2 a), create a table of ln(y) vs ln(x) and plot it. The result should once again be a straight line. (Zero is the function exponential raised to a very negative number. Notice how the spreadsheet handles it. You will want to omit the false point in your trendline analysis.)
Submit the following:
- A copy of the graph from part (a) showing the trendline and equation which describes it.
- Explain how the slope and intercept relate to the parameters in the original y(x) function.
Exercise 4:
In the lab, a student collects a set of data y(x). A ln-ln plot of the data produces a reasonably straight line. The best fit to the line has a slope of 0.25 and an intercept of 0.72. What function, y(x), best describes the data?
Submit the following:
- The equation y(x) that best describes the data.