ENTERING DATA INTO EXCEL AND FINDING THE ALGEBRAIC …
ENTERING DATA INTO EXCEL AND FINDING THE ALGEBRAIC MODEL:
1) Put the titles of each column in Row 1.
2) Enter years in column A (be sure to let x = 0 for 1990)
3) Enter population in column B
4) Highlight both columns
5) Go to Insert and down to Chart
6) Choose Scatter; Click Next
7) Click Next. Enter Title (Population of __________) and label the x (years) and y axis (population in millions). Under the legend tab “unclick” show legend.
8) Click Next. Click Finish.
9) Go to Chart at the top and click on the arrows to see all the options. Click “add trendline.” (Your cart
10) Make sure Linear is highlighted. Click on the Options tab. Click on show equation and display r squared value. Click OK. Equation will appear – it is like a text box, you can move it around.
11) For the Quadratic Model: Repeat steps 9 and 10, but click on Polynomial of degree 2 for the quadratic model.
12) To find the r-value: Click on cell D2 and type =CORREL(A2:A12,B2:B12). (Use the range of cells where you put your data into the argument).
13) Double click on the equation of the linear model. Put the r value in the text box under the r2 value. Your completed chart should look something like:
[pic]
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- linear regression in excel
- excel activity a weebly
- chemistry 101l boyd county public schools
- unit three kennesaw state university
- graphing with excel 2003 and 2007
- how to analyze tolerances using excel asq
- calculation of repeatability and reproducibility
- entering data into excel and finding the algebraic
- excel activity 25 weebly
Related searches
- download stock data into excel
- pull pdf data into excel
- finding the topic and main idea exercises
- finding the amplitude and period
- importing stock data into excel
- downloading stock data into excel
- finding the center and radius of circle
- how to input data into r
- how to read data into r
- loading data into r
- read data into r
- import data into excel template