Use the free Linear Trend Calculator below: your data never leaves your browser — all work happens on your device, and nothing is uploaded to any server.
When two things change together, a straight line often captures the pattern well enough to be useful. Study hours rise and scores rise with them. Advertising spend rises and sales rise with it. Weeks pass and a plant grows taller. The Linear Trend Calculator fits the best straight line through pasted X and Y pairs by the least-squares method, reports the slope and intercept, and lets you predict Y for a new X. It turns a cloud of points into one equation you can actually use.
This tool is built for people who need a line, not a statistics package. You do not need to install software, learn a formula, or upload your data. Everything happens in your browser, on your own device. Your numbers never leave the page, and nothing is sent to a server. That matters when the pairs hold business figures or private measurements.
To use it, paste X and Y pairs with a header row first, one pair per line, as the sample shows. Press Fit line and the result gives the equation in the form y equals slope times x plus intercept. The slope tells you how much Y tends to change for each one-unit change in X: a slope of two means Y rises by about two for each extra unit of X. The intercept is the predicted Y when X is zero, which is sometimes meaningful, such as a base cost, and sometimes just a mathematical anchor far outside the data, so read it with care.
The tool also reports R squared, a number between zero and one that says how much of the variation in Y the line explains. A value near one means the points hug the line closely, while a value near zero means the line explains almost nothing and the points scatter widely. R squared is a useful guide, but it is not a verdict on its own: a high value can still come from a curved pattern forced into a straight line, and a low value can hide a real but noisy relationship. Always look at the points themselves, not just the number.
Prediction is the most useful and the most abused part of a fitted line. Enter a new X value and the tool predicts Y from the equation, which is fine when the new X sits inside the range of your data. Predicting far outside that range, called extrapolation, is risky, because the straight pattern may not continue: growth slows, costs jump, and trends break. A line fitted on weeks one to ten should not be trusted blindly for week fifty, and the tool will still give you the number, so the judgment is yours.
Two honest limits deserve emphasis. First, a fitted line shows association, not cause. A line linking ice cream sales and sunburn does not mean one causes the other; heat drives both. Second, a single extreme point can drag the line. Check any point far from the rest in the source data before trusting the slope, because a typing error such as 250 instead of 25 will tilt the whole line, while a genuine extreme may be the most interesting case in the data.
People use fitted lines for pricing, forecasting, and checking hunches. A freelancer fits hours against income to set a rate, a shop fits advertising against sales to judge a campaign, and a student fits revision time against scores to plan study. In each case the line is a summary, not proof, and it earns trust by surviving a look at the raw points and a second fit without any suspicious point.
How to fit a line to XY data
- Paste X,Y pairs with a header row first.
- Press Fit line and read the slope, intercept, and R squared.
- Enter a new X value to predict Y inside the data range.
- Check any point far from the line in the source data.
Frequently asked questions
What does the slope mean? The average change in Y for each one-unit change in X.
What does R squared mean? How much of the variation in Y the line explains, from zero to one. Higher is tighter, but look at the points too.
Can I predict far outside my data? You can, but trust it less. Trends break outside the range they were fitted on.
Is my data uploaded? No. All fitting happens in your browser.
Paste a pair of columns you already have and fit the line, then check the points before you trust the slope. A line that survives that check is a genuinely useful summary.