SCATTER PLOT IN EXCEL

                          << 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