ࡱ > C E B E bjbj 4: 7
! ! ! 8 Y $ } L ! # @# B# B# B# B# B# B# $ $ [' l f#
f#
{# v
@# @# ! " %c& ! " ,# # 0 # " ' ' 4 " '
" x f# f# # ' : EXCEL Practice Part I Data
There is a long data set at the end of these instructions. Do not print it!!
The data set below was collected by Bob Zarr of NIST in January, 1990 from a heat flow meter calibration and stability analysis. The response variable is a calibration factor.
1. The data in the Data Set on the next page is comma-delimited. Copy the data (including the headers) and Paste it into an Excel spreadsheet. Convert the text to two columns of data.
Format [Home tab] the column header text in bold italics. Change the size and font of the data to Courier New 12. Center the Test numbers in their cells. Adjust the column width to accommodate the Response column header and numbers.
2. Named Ranges
Select the Test numbers range. Choose Formula | Defined Names | Create from selection Excel names the range "Test" corresponding to the name in the header row. You can change the name.
Repeat the Define Name procedure after selecting the Response range. Reselect each of these two ranges individually and look at the Name box on the toolbar.
Open the Name Manager tool. Look at the box "Refers to:" and the way in which the range is defined with the Sheet name followed by the ! and "$" symbols. The ! is part of the Sheet referral and you see the $ symbols that means they are absolute cell references.
Move the cursor anywhere in the worksheet. Click the down arrow in the Name box. Choose "Response". What happens?
3. Select all the data (Test numbers are also "data"). Choose Data | Sort . Sort the data from smallest to largest response. Resort the data by Test number.
4. Select the header row and 10 rows of data. Copy the data. Click on the sheet icon for a new sheet in the workbook (or choose Home | Insert | Insert sheet). Transpose the data columns and rows into the new sheet by choosing Paste | Transpose. (You can also transpose data already in a worksheet.) Undo the Transpose action.
5. Select some of the Response data. Choose Home | Number | Number tab | Number. Change the number of decimal places in the data to 2. Compare what you see in the cell with what you see in the Formula bar. This is particularly useful for data such as # 15 which has one digit less than the other data. If you select only that data, and increase the decimal places to 6, as for the others, you'll see the 0 that Excel dropped.
Choose Number tab | Scientific. Again compare what you see in the cell with what you see in the Formula bar. Click to the right of the number in the Formula bar. What happens to the number in the cell? Again compare the number as it appears in the cell with how it appears in the Formula bar.
6. Select the range of Test numbers, 195-196. Drag with the copy handle down the column for several rows. Release the mouse button. This is the Autofill feature in Excel.
Start a new column and enter the numbers 1 and 3. Repeat the Autofill procedure. Excel knows you want a series of odd numbers.
Data Set
Test, Response
1, 9.206343
2, 9.299992
3, 9.277895
4, 9.305795
5, 9.275351
6, 9.288729
7, 9.287239
8, 9.260973
9, 9.303111
10, 9.275674
11, 9.272561
12, 9.288454
13, 9.255672
14, 9.252141
15, 9.29767
16, 9.266534
17, 9.256689
18, 9.277542
19, 9.248205
20, 9.252107
21, 9.276345
22, 9.278694
23, 9.267144
24, 9.246132
25, 9.238479
26, 9.269058
27, 9.248239
28, 9.257439
29, 9.268481
30, 9.288454
31, 9.258452
32, 9.28613
33, 9.251479
34, 9.257405
35, 9.268343
36, 9.291302
37, 9.21946
38, 9.270386
39, 9.218808
40, 9.241185
41, 9.269989
42, 9.226585
43, 9.258556
44, 9.286184
45, 9.320067
46, 9.327973
47, 9.262963
48, 9.248181
49, 9.238644
50, 9.225073
51, 9.220878
52, 9.271318
53, 9.252072
54, 9.281186
55, 9.270624
56, 9.294771
57, 9.301821
58, 9.278849
59, 9.23668
60, 9.233988
61, 9.244687
62, 9.221601
63, 9.207325
64, 9.258776
65, 9.275708
66, 9.268955
67, 9.257269
68, 9.264979
69, 9.2955
70, 9.292883
71, 9.264188
72, 9.280731
73, 9.267336
74, 9.300566
75, 9.253089
76, 9.261376
77, 9.238409
78, 9.225073
79, 9.235526
80, 9.23951
81, 9.264487
82, 9.244242
83, 9.277542
84, 9.310506
85, 9.261594
86, 9.259791
87, 9.253089
88, 9.245735
89, 9.284058
90, 9.251122
91, 9.275385
92, 9.254619
93, 9.279526
94, 9.275065
95, 9.261952
96, 9.275351
97, 9.252433
98, 9.230263
99, 9.25515
100, 9.26878
101, 9.290389
102, 9.274161
103, 9.255707
104, 9.261663
105, 9.250455
106, 9.261952
107, 9.264041
108, 9.264509
109, 9.242114
110, 9.239674
111, 9.221553
112, 9.241935
113, 9.215265
114, 9.28593
115, 9.271559
116, 9.266046
117, 9.285299
118, 9.268989
119, 9.267987
120, 9.246166
121, 9.231304
122, 9.240768
123, 9.260506
124, 9.274355
125, 9.292376
126, 9.27117
127, 9.267018
128, 9.308838
129, 9.264153
130, 9.278822
131, 9.255244
132, 9.229221
133, 9.253158
134, 9.256292
135, 9.262602
136, 9.219793
137, 9.258452
138, 9.267987
139, 9.267987
140, 9.248903
141, 9.235153
142, 9.242933
143, 9.253453
144, 9.262671
145, 9.242536
146, 9.260803
147, 9.259825
148, 9.253123
149, 9.240803
150, 9.238712
151, 9.263676
152, 9.243002
153, 9.246826
154, 9.252107
155, 9.261663
156, 9.247311
157, 9.306055
158, 9.237646
159, 9.248937
160, 9.256689
161, 9.265777
162, 9.299047
163, 9.244814
164, 9.287205
165, 9.300566
166, 9.256621
167, 9.271318
168, 9.275154
169, 9.281834
170, 9.253158
171, 9.269024
172, 9.282077
173, 9.277507
174, 9.28491
175, 9.23984
176, 9.268344
177, 9.247778
178, 9.225039
179, 9.23075
180, 9.270024
181, 9.265095
182, 9.284308
183, 9.280697
184, 9.263032
185, 9.291851
186, 9.252072
187, 9.244031
188, 9.283269
189, 9.196848
190, 9.231372
191, 9.232963
192, 9.234956
193, 9.216746
194, 9.274107
195, 9.273776
p t (
)
+
1
2
3
7
=
& 2 6 M T W Ⱦθׅ{nb h+ 5B*aJ ph h3 hV 56\aJ h3 h+ 5aJ
hV 5aJ h3 hV :aJ h+ h+ 5B*aJ ph h+ hV aJ h+ h+ 5aJ
h+ aJ h3 hw 5aJ
hw aJ h3 hw aJ h3 hV aJ h[$ hV hV 5B*\ph hV ;KH OJ QJ h& p p q *
+
'
^ ^gd+ ^` 1$ W ^ _ c d g } g o
e
g
j
k
p
y
~
Ƿǫǥ}s}ǫl
hV 5aJ h h*3 >*aJ h h. >*aJ
h*3 aJ h. h. 5B*aJ ph h3 h. aJ
hV aJ h3 hV 6]aJ h3 hV :aJ
h. aJ h3 hV aJ h+ 5B*aJ ph h3 hV 5B*aJ ph
h+ aJ h+ h+ 5B*aJ ph &
5 > B E J M Q t | $ ' - 0 7 < ? H c v # ) 0 6 ݛݛz
hx}h aJ hx}h 5B*aJ ph h3 h:s aJ
huo aJ h3 hV 5B*\aJ ph h. h. 5B*aJ ph h3 hV :aJ h3 hV 5aJ h3 hV 5B*aJ ph
h. aJ h3 hR}$ aJ h3 hV aJ h3 h. 5aJ 0 h i ) 5 A M Y e q ~ gd |C
^` ^` ]
$ L T g h 5 7 8 : ; = > @ A D E 詡 h!z j h!z U hw hw B*OJ QJ h ph hV B*ph hV h3 hV 5aJ h3 h:s aJ
hr aJ h3 hV :aJ h3 hr aJ
hV aJ h3 h@a0 aJ h3 hV aJ h3 hV 5B*aJ ph & & 3 @ M Z g t gd |C ( 5 B O \ i v + 8 E R _ l w gd |C , 9 F S ` m z gd |C $ 2 @ N \ j x - ; I W e r gd |C ( 6 D R ` n | $ 2 gd |C 2 @ N \ j x , : H U c q gd |C ' 5 6 7 9 : < = ? @ B C D E gd |C 2 &P :p3 / =!"#$8% ^ 2 0 @ P ` p 2 ( 0 @ P ` p 0 @ P ` p 0 @ P ` p 0 @ P ` p 0 @ P ` p 0 @ P ` p 8 X V ~ _HmH nH sH tH < ` < N o r m a l CJ _HmH sH tH Z @ Z H e a d i n g 1 $1$ < @& 5KH OJ QJ h tH u 8 8 H e a d i n g 2 $@& ; D A D D e f a u l t P a r a g r a p h F o n t V i V T a b l e N o r m a l :V 4 4
l a ( k ( N o L i s t Z / Z
F i l e L a b e l $a$# CJ OJ QJ _HmH nH sH tH u @ @ O r g a n i c m a n u a l CJ OJ QJ 4 4 H e a d e r
! 4 "4 F o o t e r
! D C@ 2D B o d y T e x t I n d e n t
^ j Cj w
T a b l e G r i d 7 :V 0 PK ! [Content_Types].xmlj0Eжr(Iw},-j4 wP-t#bΙ{UTU^hd}㨫)*1P' ^W0)T9<l#$yi} ;~@(Hu* Dנz/0ǰ $ X3aZ,D0j~3߶b~i>3\`?/[G\!-Rk.sԻ..a濭? PK ! ֧ 6 _rels/.relsj0 }Q%v/C/} (h"O
= C?hv=Ʌ%[xp{۵_Pѣ<1H0ORBdJE4b$q_ 6LR7`0̞O,En7Lib/Se е PK ! ky theme/theme/themeManager.xml M
@}w7c(Ebˮ CAǠҟ7՛K
Y,
e.|,H ,lxɴIsQ}#Ր ֵ+!,^$j=GW)E+&
8 PK ! P theme/theme/theme1.xmlYOo6w toc'vuر-Mn iP@I}úama[إ4:l ЯGRX^6؊>$ !)O^rC$y@ /yH*)UDb`}"qۋJחX^)I`nEp)liV[]1M<OP6r=zgbIguSe bORD۫qu gZo~ٺlAplxpT0+[}`j zA V2Fi@qv֬5\|ʜ̭NleXd sjcs7f
W+Ն7` g ȘJj|h(KD-
dXiJ؇(x$( :;˹! I_TS 1?E ??ZBΪmU/ ?~xY'y5g&/ɋ>GMGeD3Vq%'#q$8K )fw 9:ĵ
x}rxwr:\TZaG*y8IjbRc|XŻǿI
u3KGnD 1NIBs
RuK>V.E L+M2#'fi ~V vl{u8z H
* :( W ☕
~JTe\O*tHGHY }KNP*ݾ˦ TѼ9/#A7qZ $*c?qUnwN%Oi4 =3ڗP
1Pm \\9Mؓ2aD];Yt\[x]}Wr|]g-
eW
)6-rC Sj
id DЇAΜIqbJ#x꺃 6k#ASh&ʌt(Q% p%m&]caS l=X\P1Mh9MVdDAaVB[݈fJíP|8 քAV^f
Hn- "d>znNJ ة>b&2vKyϼD:,AGm\nziÙ .uχYC6OMf3or$5N HT[XF64T,ќM0E)`#5XY`פ ;%1U٥m;R>QD DcpU'&LE/pm%]8firS4d 7y\`JnίI R 3U~7+#m qBiDi*L69mY&iHE=(K&N!V.KeLDĕ{D vEꦚdeNƟe(MN9ߜR6&3(a/DUz<{ˊYȳV)9Z[4^n5!J?Q3eBoCM m<.vp IYfZY_p[=al-Y}Nc͙ŋ4vfavl'SA8|*u{-ߟ0%M07% < ҍ PK !
ѐ ' theme/theme/_rels/themeManager.xml.relsM
0wooӺ&݈Э5
6?$Q
,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{ P8g/ ]QAsم(#L[ PK- ! [Content_Types].xmlPK- ! ֧ 6 + _rels/.relsPK- ! ky theme/theme/themeManager.xmlPK- ! P theme/theme/theme1.xmlPK- !
ѐ ' theme/theme/_rels/themeManager.xml.relsPK ]
E : W
E 2 E 8 @ 0 (
B
S ? L T 7 7 9 9 : : < = ? @ B C F p p t t ( ( ) + 2 = W W M T W _ c d g }
5 K K ' 0 7 < < c v ]
$ g ( ) * , 4 5 6 8 @ A B D L M N P X Y Z \ d e f h p q s u } ~
%
&
(
*
2
3
5
7
?
@
B
D
L
M
O
Q
Y
Z
\
^
f
g
i
k
s
t
v
x
' ( * , 4 5 7 9 A A 5 5 F
wDu b3 :Du (- c.( aQ0 ^-0 y6H ka eaDu h h^h`OJ QJ o( h h^h`OJ QJ o( h h^h`OJ QJ o( h h^h`OJ QJ o( h h^h`OJ QJ o( h h^h`OJ QJ o( h h^h`OJ QJ o( h h^h`OJ QJ o( h h^h`OJ QJ o( h h^h`OJ QJ o(
y6H aQ0 ka b3 (- ^-0 ea w : c.
o w :s R}$ + @a0 |C JK n N V zc x}h !z .H [$ *3
. uo P; r ? @ A D R o o t E n t r y F uBc&F 1 T a b l e ' W o r d D o c u m e n t 4: S u m m a r y I n f o r m a t i o n ( 2 D o c u m e n t S u m m a r y I n f o r m a t i o n 8 : C o m p O b j y
F' Microsoft Office Word 97-2003 Document
MSWordDoc Word.Document.8 9q