U.S. flag

An official website of the United States government

Dot gov

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Https

Secure .gov websites use HTTPS
A lock () or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

Breadcrumb

  1. Home
  2. Tools
  3. Simple Linear Regression Tool

Simple Linear Regression Tool


Last Updated : 02/23/2024

A template employing multiple MS Excel functions where the user need only enter paired data observations assigning the independent and dependent variable. The data is graphed showing the estimated trend line along with fit statistics (SE, CV, R^2), Analysis of Variance (ANOVA) Table, and intercept/slope significance (T) statistics with associated probabilities. This tool saves the user having to separately employ multiple MS Excel functions in order to obtain this information. An instruction worksheet (Getting Started) explains the tool including password protected worksheets to avoid inadvertent corruption of these worksheets. Unprotected worksheets are included to allow the user to modify display elements such as column widths and number of significant digits displayed in the output. An annotated worksheet is also provided where comment flags appear to explain certain elements and statistics when hovering over these cells.

RATINGS

0 out of 5 | 0 Reviews
Rate this tool:

You Might Also Consider

Related Tools

Related Events