Instruction for QPro and Least Squares Analysis
CHEM 1211& 1212 Lab GPC - Dunwoody
BREIF INTRODUCTION TO SPREADSHEET
The basic instructions for spreadsheets given here are applicable to EXCEL and QUATTRO PRO as well as LOTUS-123. They differ one from another mostly in the graphing methods and advanced commands.
First, open Excel or QuattroPro Program from the Windows Desktop
You will be introduced into an empty first page (with a tab at the bottom labeled “Sheet 1” for Excel or “A” for Quatrro Pro) of a blank spreadsheet notebook.
1) To write a text or a number into a cell:
Click on a cell, then type in a text or a numerical value. Then press Enter.
2) To write (or code) a formula into a cell:
Click on a cell, then type in the + or = sign first before you write any formula into it.
3) To copy a content of a cell (or block) into to other cell(or block):
Click on the cell that is to be copied. Click on Edit, and select Copy.
Click on other cell to be copied into. Click on Edit, and select Paste.
4) To call a mathematical functions into a formula:
For Excel: Select a function from the pull-down menu of the first field of the Formula Bar.
For Qpro: All function precede with @ sign. For an example , +@SQRT(C100), takes
square root of a content in a cell C100 and places the value in a current cell.
An Exercise:
Find a sum and an average value of the following five numbers:
3.088, 3.063, 2.477, 2.518, and 3.114.
Type the five numbers into the cell B3 to B7 in the column B, or into any other five cells in a same column. Let’s write the sum into cell B9, and the average into a cell B10.
Click on the cell B9, type in the following : =B3+B4+B5+B6+B7, then Enter.
Or you can simply call a sum function: =@SUM(B3..B7), then enter for the sum.
Click on the cell B10, type in the following =B9/5, then enter for the average.
(4/23/99; modified 01/26/00, 02/14/03, MHK)
................
................
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
- instruction for qpro and least squares analysis
- finding the linear regression equation in excel
- multiple regression ii
- chapter 1 linear regression with 1 predictor
- practice part iii
- calculating a standard deviation
- columbia university in the city of new york
- notes on least squares method
- activity name hit the target pennsylvania council of
Related searches
- how to graph least squares regression line
- equation of least squares regression line calculator
- slope of the least squares regression line
- least squares regression line example
- how to use least squares regression
- least squares equation
- the least squares regression line calculator
- method of least squares equation
- least squares regression calculator
- least squares regression equation calculator
- weighted least squares regression excel
- least squares regression method