This preview shows pages 1–7. Sign up to view the full content.
Welcome to Our First Lab for MATH 221!!!
These labs are designed to show you how to use Excel to help with statistical analysis.
If you are familia
Excel, that is great!
If not, don't worry, we'll show you everything you need to know to successfully work t
the labs.
To start, this file contains several worksheets.
The names "Accounts, Cereal, Milk Production,
appear at the bottom.
Each of these worksheets has an assignment for you to complete.
Simply follow t
instructions in yellow to complete each worksheet's assignment.
Be sure to view the Tutorials that are associated with each lab.
These Tutorials are interactive presentat
someone actually using Excel to work through examples similar to the labs you are asked to do.
What You Should Turn In:
Each lab should consist of ONE file that you turn in.
Use Excel to perform the calculations or generate th
but then COPYandPASTE your work
from Excel into Word
.
To CopyandPaste cells (or graphs) from Excel to Word:
1.
Highlight the cells (or select the graph) in Excel you want to copyandpaste
2.
From the Excel menu, select Edit, then Copy
3.
Go into Word and place the cursor where you want to paste your cells.
4.
From the Word menu, select Edit, then Paste
5.
Your work should have copied itself into Word.
(Note:
Can also rightclick to select copy and/or paste.)
Save your ONE Word file using the filename format
"lastname_firstinitial_week#lab".
For example, if
Albert Einstein and you are submitting your Week 6 lab, the filename should be "einstein_a_week6lab".
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document ar with
through
, " etc.
the
tions of
he graph,
f you are
9
7
5
10
14
15
1
3
3
1
3
3
10
11
12
9
11
11
9
1
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document AA
1
5
AB
2
8
AC
3
11
AD
4
12
AE
5
15
AF
6
15
AG
7
16
AH
8
17
AI
9
18
AJ
10
25
AK
11
43
AL
12
45
AM
13
48
AN
14
49
AO
15
50
AP
16
52
AQ
17
53
AR
18
65
AS
19
67
AT
20
74
AU
21
AV
22
AW
23
AX
24
AY
25
AZ
26
BA
27
BB
28
BC
29
BD
30
BE
31
BF
32
BG
33
BH
34
BI
35
BJ
36
BK
37
BL
38
BM
39
BN
40
BO
41
BP
42
BQ
43
BR
44
BS
45
BT
46
BU
47
BV
48
Account
Name
Random
Sample
Ordered
Sample
BW
49
BX
50
BY
51
BZ
52
CA
53
CB
54
CC
55
CD
56
CE
57
CF
58
CG
59
CH
60
CI
61
CJ
62
CK
63
CL
64
CM
65
CN
66
CO
67
CP
68
CQ
69
CR
70
CS
71
CT
72
CU
73
CV
74
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document Instructions:
Randomly select 20 of the accounts at left.
(You may want to add a numerical column
beside the account names!)
Use the
column at right (Random Sample) to list the
raw account numbers.
Then, order the
column to create an ordered list.
Question:
This is the end of the preview. Sign up
to
access the rest of the document.
This note was uploaded on 05/29/2011 for the course MATH 221 taught by Professor Bethdodson during the Spring '10 term at DeVry Chicago.
 Spring '10
 BethDodson
 Math

Click to edit the document details