Graphing in Excel
Graphing Using Excel This exercise shows you how to handle Beer's Law and kinetics data using Excel.
Beer's Law Type in [K2CrO4] in the A1 cell (x-axis) and Absorbance in the B1 cell (y-axis). Enter the data for concentration and absorbance.
Highlight the concentration and absorbance columns and click on Insert on the top menu and click on Chart on the drop down menu.
1
Click on the xy scatter option and click Finish. 2
Right click in the graph area and click on Chart Options. You can remove the Legend, add gridlines, Graph Title, and labels for the x and y axes. Then click OK.
3
By clicking in the graph area and using the cursor you can enlarge the graph. 4
Click on Chart in the top menu and click on the Add Trendline option. This will put in the linear regression line or best fit straight line through the data points.
5
................
................
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
- 1 5phase lineandbifurcationdiagrams
- derivative graph notes arlington public schools
- second order differential equations
- higher derivatives concavity and the second derivative test
- introduction to xrpd data analysis
- experiment 10 titration curves
- bond graph models of electromechanical systems the ac
- math 1a calculus worksheets
- 10 moment generating functions mathematics home
- chapter 23 magnetic flux and faraday s law of induction
Related searches
- loan calculator in excel format
- alt enter in excel formula
- amortization calculator in excel formula
- how to calculate percentage in excel formula
- formula in excel for compounding interest
- formula in excel to calculate 10 discount
- how to calculate hours in excel timesheet
- percent discount in excel formula
- change formula in excel sheet
- how to calculate dates in excel spreadsheet
- age in excel between two dates
- sum by color in excel 2010