The LINEST function performs linear regression calculations and is an array function, which means that it returns more than one value. Send No thanks Thank you for your feedback! × English (United States) Contact Us Privacy & Cookies Terms of use & sale Trademarks Accessibility Legal © 2016 Microsoft Skip navigation UploadSign Working... Type LINEST(, use the mouse to select your y-data, type a comma, use the mouse to select your x-data, type another comma, then type true twice separated by a comma and

No, create an account now. I just wanted to know what the best way of calculating an error for a slope is. Sign in Transcript Statistics 15,802 views 46 Like this video? Loading...

Syntax The syntax for the SLOPE function in Microsoft Excel is: SLOPE( known_y_values, known_x_values ) Parameters or Arguments known_y_values The known y-values in data points used to calculate the slope. How can we improve it? That makes F the independent value and it should be plotted on the x-axis. The const and stats should be labeled true and true as shown below.

Example Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. Rating is available when the video has been rented. Notice that the slope of the fit will be equal to 1/k and we expect the y-intercept to be zero. (As an aside, in physics we would rarely force the y-intercept Close Yeah, keep it Undo Close This video is unavailable.

Generated Sat, 15 Oct 2016 10:04:27 GMT by s_wx1131 (squid/3.5.20) Sign in to make your opinion count. Bionic Turtle 159,719 views 9:57 excel LINEST function.mp4 - Duration: 8:04. The set of independent data points.

Click OK In the table that is written into your worksheet, the slope is the number after "X Variable 1", and the error (standard deviation) in the slope is the number If known_y's and known_x's are empty or have a different number of data points, SLOPE returns the #N/A error value. If Data Analysis does not appear in the Tools menu: Select Add-Ins from the Tools menu Check "Analysis ToolPak" and click OK Data Analysis should now appear in the Tools menu It can be used as a worksheet function (WS) in Excel.

Loading... Sign in 47 10 Don't like this video? Chris Doner 6,170 views 7:04 FRM: Regression #3: Standard Error in Linear Regression - Duration: 9:57. Please re-enable javascript in your browser settings.

The Linest() function in Excel gives the error (or uncertainty) for data in the lab. It calculates the statistics for a line by using the "least squares" method to calculate a Note If the known_y_values and known_x_values parameters contain different numbers of elements, the SLOPE function will return the #N/A error. Sign in to add this video to a playlist. Since it is an array function, select 6 cells (2 columns, 3 rows).

WarPhalange, Oct 5, 2008 Phys.org - latest science and technology news stories on Phys.org •Game over? LINEST() FUNCTION Trendlines are used to graphically display trends in data and to analyze problems of prediction. More... I actually don't know what the second element is.

statisticsfun 468,951 views 4:35 Calculating Titration Curve Slopes in Excel 2007 - Duration: 8:57. Besides that I can say f/B = gamma (what the slope should be), take that for each set of data points, take an average, and propagate that error... As a worksheet function, the SLOPE function can be entered as part of a formula in a cell of a worksheet. Jim Grange 605,678 views 5:20 Calculating the Standard Error of the Mean in Excel - Duration: 9:33.

Sign in Share More Report Need to report the video? Forums Search Forums Recent Posts Unanswered Threads Videos Search Media New Media Members Notable Members Current Visitors Recent Activity New Profile Posts Insights Search Log in or Sign up Physics Forums Because linear regression aims to minimize the total squared error in the vertical direction, it assumes that all of the error is in the y-variable. Redbelly98, Oct 6, 2008 (Want to reply to this thread?

Loading... The slope is the vertical distance divided by the horizontal distance between any two points on the line, which is the rate of change along the regression line. The first element in the third row displays the correlation coefficient. Click the mouse in the formula box and enter the LINEST function. =LINEST(B2:B12,A2:A12,true,true) The B2:B12 interval represent the known y values and the A:2:A12 interval represent the x values.

DON'T HIT ENTER. Generated Sat, 15 Oct 2016 10:04:26 GMT by s_wx1131 (squid/3.5.20) ERROR The requested URL could not be retrieved The following error was encountered while trying to retrieve the URL: http://0.0.0.10/ Connection You systematically varied the force exerted on the spring (F) and measured the amount the spring stretched (s). The first true tells LINEST not to force the y-intercept to be zero and the second true tells LINEST to return additional regression stats besides just the slope and y-intercept.

Such analysis is also called regression analysis. Trendline are useful but it does not give the error in the slope. The friendliest, high quality science and math community on the planet! Stephanie Castle 302,040 views 3:38 Loading more suggestions... Measurements Lab 1,602 views 19:19 How To Compute Confidence Intervals In Microsoft Excel - Duration: 7:41.

The regression output will fill in cells to the right and below the "Output Range" cell. The second image below shows the results of the function. error. Your cache administrator is webmaster.

Please try the request again. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included. Jared Spencer 167,543 views 4:30 IB Physics: Uncertainty in Slope using Excel's LINEST - Duration: 7:04. The equation for the fit can be displayed but the standard error of the slope and y-intercept are not give.

Copyright © 2003-2016 TechOnTheNet.com. Error in a calculated slope? Any other feedback? Syntax SLOPE(known_y's, known_x's) The SLOPE function syntax has the following arguments: Known_y'sÂ Â Â Â Required.