Northeastern University



Excel Lab 2 Guide Sheet

Data Plotting and Curve-FItting

GEU 110 S. Freeman (BKJ)

❑ Reading: Chapters 4 and 5. All topics are not included on the Guide Sheet.

❑ Review: The 3-way convention of accomplishing tasks in Microsoft (sometimes only 2 ways):

-

-

-

❑ Common Chart Types (know applications):

- C - S

- B - A

- L - H

- P - Custom

❑ Selecting Regions of data; Selected regions of data:

❑ Creating a chart - the 3-way convention w/ F11:

❑ Chart Location:

❑ Chart Objects & Formatting a Chart:

o Titles

o Legend

o Plot Area

o Gridlines

o Data Labels

o Axes

❑ Data Series / Series of Data:

❑ Source Data:

o Data Range

o Identifying

o Selecting

o Editing

❑ Selecting Non Adjacent Data Cells:

❑ Selecting the Labels (or not):

❑ Multiple Series of Data:

❑ Connecting the Dots: Adding Connecting Lines, Selecting a Line Chart, or adding a Trendline:

❑ Trendlines:

o Displaying Equation on Chart

o Formatting Line & Equation.

o Displaying R2

❑ Correlation & R2:

❑ R2 - The Bigger the Better?:

❑ Inserting Text Boxes:

❑ Drawing Objects and the Drawing Toolbar:

❑ Histograms

❑ Data - Automatic Updates:

❑ Using the Function Key – fx:

❑ Writing Formulae - even more tips that someday you might thank me for:

o Precedents vs. Dependents

o Relative vs. Absolute referencing

o Providing variable names for single cells or ranges

❑ Text Formatting in the Cells (again):

o 2 lines of text in one cell

o Writing, but not calculating equations & functions

❑ More Axis Formatting in the Charts:

o Number of Decimal Places

o Major Units & Minor Units

o Relocating the Axis

❑ Viewing the Worksheet:

o Normal

o Page Break

❑ Preparing to Print:

o Page Setup

o Preview

❑ Default Charts - OK, I’ve fixed this chart the way I like it, let’s make more just like it:

❑ Creating Histograms – Data Analysis under Tools, data, bins, Chart

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download