# << Some Introduction >>

* SCATTER PLOT IN EXCEL*

## Objectives

- Enter and format data in an Excel spreadsheet in a form appropriate for graphing
- Create a scatter plot from spreadsheet data
- Insert a linear regression line (trendline) into the scatter plot
- Use the slope/intercept formula for the regression line to calculate a x value for a known y value
- Explore curve fitting to scatterplot data
- Create a connected point (line) graph
- Place a reference line in a graph

*LINEAR REGRESSION*

In statistics,

**linear regression**is an approach to modeling the relationship between a scalar variable*y*and one or more variables denoted*X*. In linear regression, models of the unknown parameters are estimated from the data using linear functions. Such models are called*linear models*. Most commonly, linear regression refers to a model in which the conditional mean of*y*given the value of*X*is an affine function of*X*. Less commonly, linear regression could refer to a model in which the median, or some other quantile of the conditional distribution of*y*given*X*is expressed as a linear function of*X*. Like all forms of regression analysis,*linear regression*focuses on the conditional probability distribution of*y*given*X*, rather than on the joint probability distribution of*y*and*X*, which is the domain of multivariate analysis.

__Part 1 - Beer's Law Scatter Plot and Linear Regression__

__Part 2 - Titration Data Plotting__ü

ü

__Finding the line of best fit__

__Quadratic regression__

## No comments:

## Post a Comment