Graphic in excel for practicum

Click For Summary

Homework Help Overview

The discussion revolves around creating charts in Excel for physics measurements, specifically focusing on the application of linear, exponential, and logarithmic trendlines. The original poster expresses difficulty with the last two trendlines not aligning with the data points from their measurements.

Discussion Character

  • Exploratory, Assumption checking

Approaches and Questions Raised

  • Participants inquire about the necessity of the data following specific functions and question the accuracy of the measurements. There are requests for additional information, such as graphs and data, to better understand the issue.

Discussion Status

The discussion is ongoing, with participants seeking clarification and more information before drawing conclusions. There is a focus on understanding the relationship between the data and the expected trendlines.

Contextual Notes

There is an emphasis on the need for visual data representation and the potential implications of measurement accuracy on the trendline fitting.

alkgeo

Homework Statement


So I have to make three charts for the measurments that we made in class (physics experiments but it's not important). The first one had to be with a linear trendline, the second one with a exponential and the third one with a logarithmic trendline. For some reason the last two trendlines don't follow the dots from the measurements.

Homework Equations



What kan I do to fix it?
 
Physics news on Phys.org
It is impossible to tell what went wrong if you don't show the graphs (and the data, if relevant).
Do you expect the data to follow an exponential/logarithmic function?
 
Yes, the last two had to be in a logarithmic\exponential trendline. Do you think the measurments were wrong to begin with?
 
mfb said:
It is impossible to tell what went wrong if you don't show the graphs (and the data, if relevant).
Do you expect the data to follow an exponential/logarithmic function?
Yes the last two had to be those, do you think the measurments were wrong to begin with?
 
mfb said:
It is impossible to tell what went wrong if you don't show the graphs (and the data, if relevant).
@alkgeo ,
You have not responded to the above portion of @mfb 's post.
 
  • Like
Likes   Reactions: mfb

Similar threads

  • · Replies 5 ·
Replies
5
Views
4K
Replies
10
Views
4K
  • · Replies 7 ·
Replies
7
Views
2K
  • · Replies 5 ·
Replies
5
Views
2K
  • · Replies 9 ·
Replies
9
Views
3K
  • · Replies 5 ·
Replies
5
Views
3K
  • · Replies 6 ·
Replies
6
Views
2K
  • · Replies 11 ·
Replies
11
Views
3K
  • · Replies 8 ·
Replies
8
Views
3K
  • · Replies 16 ·
Replies
16
Views
3K