ࡱ> gf f2ɀ\pBuff Ba==<8X@"1bCalibri1bCalibri1bCalibri1bCalibri1bCalibri1 bCalibri1bCalibri14bCalibri1 bCalibri1bCalibri1bCalibri1,8bCalibri18bCalibri18bCalibri1>141<bCalibri1?bCalibri1h8bCambria1bCalibri1 bCalibri1bCalibri1bCalibri1hbCalibri1bCalibri1bCalibri1bCalibri1hbCalibri"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                                                                       ff + ) , *     P  P        `            a>  ( #  @     @      "    "   "   (@@  ( @      ||L9}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-} 00\);_(*}-}  00\);_(*}-}  00\);_(*}-}  00\);_(*}-}  00\);_(*}-}  00\);_(*}-} 00\);_(*}-} 00\);_(*}A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef;_(@_) }A} 00\);_(*ef ;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L;_(@_) }A} 00\);_(*L ;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A} 00\);_(*23;_(@_) }A}  00\);_(*23;_(@_) }A}! 00\);_(*23 ;_(@_) }A}" 00\);_(*;_(@_) }A}# 00\);_(*;_(@_) }A}$ 00\);_(*;_(@_) }A}% 00\);_(*;_(@_) }A}& 00\);_(*;_(@_) }A}' 00\);_(* ;_(@_) }A}( 00\);_(*;_(@_) }}) }00\);_(*;_(@_)    }}* 00\);_(*;_(@_) ??? ??? ??? ???}-}+ 00\);_(*}-}, 00\);_(*}-}- 00\);_(*}-}. 00\);_(*}-}/ 00\);_(*}A}0 a00\);_(*;_(@_) }A}1 00\);_(*;_(@_) }A}2 00\);_(*?;_(@_) }A}3 00\);_(*23;_(@_) }-}4 00\);_(*}}5 ??v00\);_(*̙;_(@_)    }A}6 }00\);_(*;_(@_) }A}7 e00\);_(*;_(@_) }}8 00\);_(*;_(@_)    }}9 ???00\);_(*;_(@_) ??? ??? ??? ???}-}: 00\);_(*}-}; 00\);_(*}U}< 00\);_(*;_(@_)  }-}= 00\);_(*}-}> 00\);_(*}-}? 00\);_(*}-}@ 00\);_(*}-}A 00\);_(*}-}B 00\);_(*}-}C 00\);_(*}i}D 00\);_(*;_(@_)   }U}E 00\);_(* ;_(@_)  }i}F 00\);_(*;_(@_)   }-}G 00\);_(*}-}H 00\);_(*}-}I 00\);_(*}-}J 00\);_(*}-}K 00\);_(* 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text % 0Good;Good  a%1 Heading 1G Heading 1 I}%O2 Heading 2G Heading 2 I}%?3 Heading 3G Heading 3 I}%234 Heading 49 Heading 4 I}% 5InputuInput ̙ ??v% 6 Linked CellK Linked Cell }% 7NeutralANeutral  e%3Normal % 8Noteb Note   9OutputwOutput  ???%????????? ???:$Percent ;Title1Title I}% <TotalMTotal %OO= Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight16` 7LVDT_dataset_for_lectureo Lecture demo8:2t / 3 A@@   Displ. (mm) LVDT 1 A/D signal (V)LVDT 2 A/D signal (V)slope = y-interceptBest fit line LVDT1&Use of LINEST() from 15NOV2010 LectureBJFurman:1. Drag cursor over 5 rows x 2 columns (leave highlighted)q4. Use the slope and intercept to calculate y-values for the 'best fit' line through subset of x-values you want.:3. Enter the formula as an ARRAY by using CTRL+Shift+ENTER82. Type in the formula: =LINEST(B8:B20,A8:A20,TRUE,TRUE)(The first TRUE stipulates to calculate the intercept normally. If instead you use FALSE, then the intercept is forced to be zero. The second TRUE requests additional regression statistics. See the Help for LINEST() ) Lecture demo 07OCT20114 U5ccB f2ɀ !N=GH  dMbP?_*+%,&ffffff?'ffffff?(?)?MJPrimoPDFlS odXXLetterPRIV0''''l\KhC{SMTJPrimoPDFResolution600dpiPageSizeLetterPageRegionLeadingEdgeInputSlotOnlyOne"dXX333333?333333?&<3U} $ } I } m !,,X,,,; ,, , , , , ,,,,,,; ,,,,,,,,   > > > >~ @aTR' @BC@}?5^I@UN@UB@K7A@/$@ h"l@ r @.!@)Wx'@Mb@a4o@`<^@'Dv@ DDD~ o@0*@C9ѮB @E$ @ DLD K7A@ @u@r@ EVoG6 @ Mb? HPs@ VyO EirAMb4@`5!FkdM r Cl QK7AL7A`%47}?5^I-Cq@x~ @߾ mb ?GL@? !( %%B1H;^f*   @5`?Ah o?   I  IIIII@g:?A.Ьn?   IIIIII@ٽ$AA&@ J JJJJJIIIIII<^ 82666apGUUUQUUUUQU6662nb , BY=`@  C@xa? JJJJJJIIIIIItJ I.K(  n + c 4NChart 1z3]+@  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"333333?333333?3&<3s7@p(  p# p J]TextBox 1"ÉPK![Content_Types].xmlJ0*miG]`Hm6 Xwt?. g#Wi3E).+7 >ON ޑ1ˋz "+R RhB.} /<^ITխ%rHK4uK~I0xM e`|X}đ I`߽N4aG2$RKIZ)4(M9`ctB{m:f@`3n|O,ܗr޾jxR0T ,0@}WBLǬ5vPK! ]vdrs/shapexml.xmln0cml .h/EL)*JrCQf_͌cAZ![ /wk`ΣnP-9PC$NenaۣW4$ܫ$O2{hleu^9V[kXfEefcȺ^l={I撞E)bsX/zm|u ƞp?QG3 1!԰`>_!7Ib5WtLL2*V|vP߯ecEgd!`O9B`*gbA"Vx|q)1S$BZO8Ws KХUAnv8pд)W0CRI[Nć[U: a٥{ѲTQbk}V59a?q@{|;M;[tPK!mdrs/downrev.xmlOO1&~fL.H!`B$AvOܶVvD7o}3&I+v@KkĭԪ0Qd|}5Cek*BJE!>-PK߲;4ˬ2t9WN+ގײ4t;|*0\}i~t7x|̷/M3} sݬn_9neǭ+RNT&-;3g5sIbЍ{pepi~QD=D>sqI\s PK-![Content_Types].xmlPK-!1_a ._rels/.relsPK-! ]v)drs/shapexml.xmlPK-!m7drs/downrev.xmlPK~ B]`  <full data set<  p VP]TextBox 2"PK![Content_Types].xmlJ0*miG]`Hm6 Xwt?. g#Wi3E).+7 >ON ޑ1ˋz "+R RhB.} /<^ITխ%rHK4uK~I0xM e`|X}đ I`߽N4aG2$RKIZ)4(M9`ctB{m:f@`3n|O,ܗr޾jxR0T ,0@}WBLǬ5vPK!mdrs/shapexml.xmlU]o0}`=# (:u/51A36w mڎ 7s|}|Y$;al4D(J2zs}9YPbVNXz(Ն gt\[QF(Ԧ?mP#p-8 o8/ya2#人_0 V^]4mN4gmh$.EN?,=)NIlCjF3Jڭʐ`tF}tKbZ vx@-M=5T eB˒ ,N0S1IyzzP$^M" lIoP3c߭x F>u>lJʏ4dQ4qH^׸{ZA!?_։Gj:Uj4` 4=d|fi~㭔z(UC@èBqBcGH֮"⽼>vBBMn8w]way ƬWQv,&$i'4SX +"0\Ha!X8=kIb,nFL{}{|iPK!!Ndrs/downrev.xml|[O1M͘&R1xpIoe7n[Vv't;3qc*EJgZtiղr0xtz2j;<07΃*r˝72kT$7.P}?EWjo[_f^fr,bòz^g`wtw/L^壴F&V;ü/L}ؿyxqT|F vwi {㇎PK-![Content_Types].xmlPK-!1_a ._rels/.relsPK-!m)drs/shapexml.xmlPK-!!Ndrs/downrev.xmlPK e | [ ]` . </subset of the data y=1.6866x-0.0275 R2=0.99998< %&.@83d23   MR R R RI3~S S4 3Q: .LVDT 1 A/D signal (V)Q ;Q ;Q3_ M MM  NR R R R8   K"-xxS S4ES S 4 3Q: .LVDT 2 A/D signal (V)Q ;Q ;Q3_ M MM  NR R R R8   K"-S S4ES S 4  3Q: *Best fit line LVDT1Q ;Q ;Q3_ MM  ""dR R R RuqEg  K"# S S4ES S 4 3QQQQ3_  MM  MMdR R R RJS S4JKS S 4D$% 0`!3O&QR RS S4$% `!3O&Q4FA_op 3O0LL3*&! R RR Ru,S S43* &! ! R Ru,u,-$͒S S4%  K 3OEj&Q $Displacement, mm23 M NMR RR Rp]S S4'<׵7߷?a֘?p\ xxxxxxxxxxxxxxxx K/@S S4% | Z3OZg&Q &Output Voltage, V23 M  MR RR Rpn] S S4'<U$?s-?߫;x xxxxxxxxxxxxxxxxx K/0 S S4523 M  MR R;n]S S43d" 3OwP% 03O&Q423   MR RR R R R*;ړ0 S S4<TScϰ?j5?̒m?+?-$͒ K/0 S S 4S S4S S4D0LL=Gvb?B%j?yp6?-?% |'  3O+&Q L$LVDT Output Voltage vs. Displacement23 M  MR RR RTn] S S4'<Y4c?I ?h.P?0d xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx K/S S4% + @ 3O?t-&P Q23   MR RR R; ړ0# S S4'< ܿe˶O?S S4-$͒ K[xxS S 4eee*Kven-US?Kl  , s `6Straight Arrow Connector 3#"@PK!%[Content_Types].xmlN &jZcL՘L[b;;^k7i3$.+)mp{-߷Oŝ :3-@r\^}Fr9+EvP" O&z0=U6`E^2dSЙ1_$ Fa.]ZGoMfR5RJv44HW!կ |OjR~6c(hXWNT6/zOpJ\[|JWjPK!3X _rels/.rels=k1 B%C)%l!}d$sM}LWu^σԈɴ#ĐwNђʳҳҲԶ%#ɠG侱J̤)<6T;OLL1z%r''c]Qgi]Zvw>]@VEF/VER2Ww|ϙU7 תd~㬏zԈ-.1d&|NCh Ĥ TI33=.7;.1J}1?`~HCsFW꺮RW+ilQYe^aCD+@r]䤍Fu@-6Bd@|"tBwJ(.JÏ{Dt#4b;gKgQpU'P80!i{4Da]W>8aŒҞ ->87)c'yd+q#JataalA{bi \l]|PK!jKv ~drs/downrev.xml\N0EHC4H,mSUlDXG& *bs\댦BLaLL)|sfڌ'8DQ9!\12=kUci[R[6p%IkXq`=<}) 2d r߆5JE]Qz7 |WB5( o] cwc )2׌±i$Iaxl]d!f ,\c4L`qPK-!%[Content_Types].xmlPK-!3X 1_rels/.relsPK-!sEw1+.drs/connectorxml.xmlPK-!jKv ~drs/downrev.xmlPK@],`x - s `6Straight Arrow Connector 4#"@PK!%[Content_Types].xmlN &jZcL՘L[b;;^k7i3$.+)mp{-߷Oŝ :3-@r\^}Fr9+EvP" O&z0=U6`E^2dSЙ1_$ Fa.]ZGoMfR5RJv44HW!կ |OjR~6c(hXWNT6/zOpJ\[|JWjPK!3X _rels/.rels=k1 B%C)%l!}d$sM}LWu^$OӛČAkzCcۣ1!=E0uZ (Qo}w]_Y~9wkuUqs&˧x3U I]1' s^/t|V>XѷÓ& jl5}oɽFTSRƢP+,I T:=D}%%ZY\H݇]@LXqzNsJN]Y¹ d% ֛7u*; eQ*jeZ8|56τ\ȷNơ%xn1{vB) g{Qmp"0!A?w?= p^Kޢ,a,B0i炅D6GakFđQý \#ToE߼AF#|Q0' PK!#}drs/downrev.xml\J0!i֭ueYxUpB6&)Ilo]93ߙn=5UD֝i9|)EopvVd̛%hb|&8R_)_A5i0u-\E#բ38AA>_CFTAq~{39s/ZsH`9πuK8= ,B4^d8VuƯ\1[zIL/PK-!%[Content_Types].xmlPK-!3X 1_rels/.relsPK-!ǓM&.drs/connectorxml.xmlPK-!#}drs/downrev.xmlPK&]-` . s b8Straight Arrow Connector 10#"@PK!%[Content_Types].xmlN &jZcL՘L[b;;^k7i3$.+)mp{-߷Oŝ :3-@r\^}Fr9+EvP" O&z0=U6`E^2dSЙ1_$ Fa.]ZGoMfR5RJv44HW!կ |OjR~6c(hXWNT6/zOpJ\[|JWjPK!3X _rels/.rels=k1 B%C)%l!}d$sM}LWu^3oϟCkJ6R([2Ils`7g \:55;diJlom1w=IwM.-65e׋<[fMmh,7+l /@gHMȜ}6=*K/~ &tS,_!ϼA=OFwhFAFvҳ3T@V5")Nmc0n@M7JL pGhq)?`h9GCbC1:Wxfk%j y9F D,r> %XU؎8_[åz),VK> ~3b;iБ rTȯE܃+>I5Jźd'u&xU,mTT@X}87xy4йV/wGtqd1N)@{4n|PK!Ho drs/downrev.xmlLMN0H!$vI M u h98q"$LJv73{^o&A8YC!Y mݙaLY#( f͊ڎS FQ!!K_^4 غԎ\+h Y/^MA%RIǰ$I僬9w py|'0gJ48ҺnՑ##r(`2Ƌ@!˓_9O)̀x'/<;jg<_b&N[PK-!%[Content_Types].xmlPK-!3X 1_rels/.relsPK-!bjמ4-.drs/connectorxml.xmlPK-!Ho drs/downrev.xmlPKPM ].`h?`,-.>@d***   ggD f2ɀ   dMbP?_*+%,&ffffff?'ffffff?(?)?",333333?333333?&<3U} } } m,,@,,,,, , , , , ,,,,,,,,,,,,  K > > >~ @aTR' @BC@}?5^I@UN@UB@K7A@/$@ h"l@ r @.!@)Wx'@Mb@a4o@`<^@~ o@ 0*@ C9ѮB @ K7A@ @u@r@ Mb? HPs@ VyO Mb4@`5!U`wP?!(%%B1|% r Cl Q0f*?Ayz?K7AL7A`%47Lt@?-? }?5^I-Cq@xЧ)@3@~ @߾ mbvf?̀@T)?4*266662(666266662ttt 0 ,(  ,n  , c 4NChart 4 ] @  f2ɀPPPZaajk&ffffff?'ffffff?(?)?"333333?333333?3&<3PHPt0(  th3d23   MR R R RI3~S S4 3Q: .LVDT 1 A/D signal (V)Q ;Q ;Q3_ M MM  NR R R R8   K"-S S4ES S 4 3QQQQ3_  MM  MMdR R R RJS S4JKS S 4D$% 0`!3O&QR RS S4$% `!3O&Q4FA' 3OA<f 3* &! R RR Ru,-$͒S S43* &! R R͒u,͒8 -$͒S S4523 M  MR R͒n]S S43d" 4S S4DA<f % +h 3On+&Q23 M NMR RR R͒]S S4'<,(\ K/S S4%  1h@3Or+&P Q23 M NMR RR R ]S S4'<S S4-$͒ K[S S 4eee*Kven-USKl >@b͒ʒ12ggD Oh+'08@T d p| Buff FurmanBuff@)N@(fA՜.+,0HP X`hp x  LVDT_dataset_for_lecture Lecture demo  Worksheets  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUWXYZ[\]_`abcdeRoot Entry FT;'WorkbookSummaryInformation(VDocumentSummaryInformation8^