Can Someone Help Me With This Chart I Dont Know How To Find The R^2 Value Of A Datas Fit To A

How can I get de X-Y data from a trendline graph in Excell using VBA?

As others have mentioned, I don’t think that VBA is necessary in this case.For a simple linear trendline, you can determine the value of any value Y based on a value X using the SLOPE and INTERCEPT formulas. The formula would take the form ofy = mx + bwhere “y” is the dependent variable, “m” is the slope of the line, “x” is the independent variable and “b” is the Y-intercept. Assuming X values in cells A2:A10, Y values in cells B2:B10 and your desired “X” variable in cell C1, you would enter this as :=SLOPE(B2:B10, A2:A10)*C1+INTERCEPT(B2:B10, A2:A10)However, your question indicates that you are interested in a Moving Average trendline. In this case, you can calculate any given data point by taking the average of the previous “n” observations, where “n” is the number of periods in your moving average.For example, to calculate a 2-Period Moving Average (“n” = 2), simply average the last two values. A simple example is copied below.If you are set on using VBA, then this code should do the trick with minor modifications as you see fit. As is, it should work for simply selecting a range of X/Y pairs and running the macro. The result will be a very basic XY Scatter chart with the chart title indicating the next XY pair in the sequence.Hope this helps out.BenSub AddXYScatter()

Dim r As Range
Dim c As Chart
Dim x As Long
Dim s As String

Set r = Selection

If r.Columns.Count <> 2 Then
MsgBox "Please select your X/Y pairs and try again"
Exit Sub
End If

x = Application.InputBox("Number of Periods?", "Periods?", 2, , , , , 1)

If r.Rows.Count <= x Then
MsgBox "Not enough observations, please select more rows or reduce periods."
Exit Sub
End If

ActiveSheet.Shapes.AddChart(xlXYScatter).Select
Set c = ActiveChart

With c
.SetSourceData Source:=r
.SeriesCollection(1).Trendlines.Add
With .SeriesCollection(1).Trendlines(1)
.Type = xlMovingAvg
.Period = x
End With
.SetElement (msoElementChartTitleAboveChart)
s = "Next X | Y Pair: "
s = s & Format(WorksheetFunction.Average(r.Offset(r.Rows.Count - x, 0).Resize(x, 1)), "0.00")
s = s & " | " & Format(WorksheetFunction.Average(r.Offset(r.Rows.Count - x, 1).Resize(x, 1)), "0.00")

.ChartTitle.Text = s
End With

Set r = Nothing
Set c = Nothing

End Sub

How can I add an exponential trendline on Microsoft Excel?

You can add an exponential trendline as follows:Select your data and graph it. You can either use a SCATTER plot Do not use the LINE plot because if you have two columns of data it will graph the individually instead of an input-output graph.Select the curve on the graph itself and then right-click. Click on Add Trendline. A dialog box will pop up giving you the option for plotting a curve based on different criteria. Choose EXPONENTIAL.You have an option here as well. You can also have Excel display the trendline equation on the chart as well which is also very useful.If you are statistically savvy, what you can also do is have Excel display the R-squared value on the chart. This value rates the trendline on how close or far away it is from the actual data values between 0 and 1.Click OK. There you have it.

What does R^2 tell in a linear regression analysis?

R-square tells the percentage of variance in dependent variable that can be explained by the independent variable.Example:y=B0+B1*xIf R-square=.73, then we can say that 73% of variation in dependent variable(y-variable) can be explained by the dependent variable(x-variable).