Hey Im trying to plot this set of data:
0 0
10 0.6
20 1.01
30 1.428
40 2
50 2.3
60 2.57
70 2.8
80 3.05
90 3.35
100 3.54
110 3.73
120 3.9
130 4.08
140 4.25
150 4.39
160 4.53
170 4.65
180 4.754
190 4.846
200 4.943
210 5.011
220 5.111
230 5.175
240 5.23
250 5.295
260 5.356
270 5.407
280 5.441
290 5.495
300 5.526
The expected exponential fit is about y=6-6e^(x/100). however, when I try to find put an exponential fit with excel, it makes the fit increase instead of decrease. How do I fix this?
To plot the given set of data and fit an exponential curve, you can follow these steps:
Step 1: Open Microsoft Excel and enter the data points in two columns. Label the first column as "x" and the second column as "y".
Step 2: Highlight both columns of data by clicking and dragging over them.
Step 3: Click on the "Insert" tab located at the top of the Excel window.
Step 4: Choose the "Scatter" chart type (usually found in the "Charts" group).
Step 5: Select the scatter plot option that connects the data points with smooth lines.
At this point, Excel will plot the data points and produce a rough trend line. However, since you mentioned that Excel's exponential fit increases instead of decreasing, we need to manually adjust the trendline.
Step 6: Right-click on the trendline and select "Format Trendline" from the context menu.
Step 7: In the "Format Trendline" window, choose the "Exponential" option from the "Trendline Options" panel.
Step 8: Optionally, you can customize the trendline by adjusting the exponential equation's coefficients. In this case, replace the default equation with the expected equation: y = 6 - 6 * EXP(x / 100).
Step 9: Close the "Format Trendline" window. Excel will update the trendline on the plot using the customized equation.
Now you should have an exponential trendline that matches the expected fit, y = 6 - 6 * EXP(x / 100).