2
Dk`ol bi Xric·. K.Ue. Cànoi Jopõloti 7 p`r`ic`noiHfk`ol.eik TMOSD^UOB@BD CDBD^@L BI X@^À - TCX@ K`mu`l p`r` ` eimstruæåi bd uk` k`troz bd eirrdl`æåi p`r` bdcomor uk kibdli bd rdfrdssåi lomd`r sokplds. @nr` i `rquovi @lumis.xlsx @ p`rtor b` fuo` B`bis, mi frupi @màlosd, elo- qud dk @màlosd bd B`bis. S`kis e`leul`r ` Eirrdl`æåi dxostdmtd dmtrd `s v`roàvdos Ob`bd, @ltur` d Xdsi. Udldeoimd Eir- rdl`æåi d dk sdfuob` eloqud dk IA. Xrddmej` ` tdl` sdfuomtd eimcirkd is b`bis `n`oxi. @põs osti, eloqud dk IA. @ k`troz bd eirrdl`æåi fdr`b` sdrà ` sdfuomtd7 Insdrvd qud ` rdl`æåi k`os cirtd ï dmtrd Xdsi d @ltur`, qud rdsultiu mi v`lir `prixok`bi bd 8,6566 iu 65,66%. @fir`, vilt`mbi miv`kdmtd p`r` ` fuo` B`bis, mi fru- pi @màlosd, eloqud dk @màlosd bd B`bis. S`kis fdr`r i kibdli bd rdfrdssåi lomd`r sokplds dm- trd `s v`roàvdos Xdsi d @ltur`. Udldeoimd ^dfrdssåi d dk sdfuob` eloqud dk IA. Xrddmej` ` tdl` sdfuomtd eimcirkd is b`bis `n`oxi. @põs osti, eloqud dk IA. X^IC· K.Ue. Komoeursi bd Dxedl @v`mæ`bi >808 CÀNOI JOXÕLORI Eirrdl`æåi d ^dfrdssåi Uokplds www.c`noijopiloti.eik.nr  L@UOF/FDXDE @LTMI(@)7 Dxedl >808 # Cr`sd b` `pistol`7 Dmqu`mti dxostor rdspor`æåi bdmtri bd kok, ordo pdr- sostor. Xir dmqu`mti du eimjdæi uk bis promeëpois bi suedssi7 Ud pdrsostor bur`mtd tdkpi sucoeodmtd, ordo f`mj`r.(If K`mbomi) 

Ap4-Correlação e Regressão-Estatistica

Embed Size (px)

DESCRIPTION

Calculando correlação e regressão utilizando Excel2010

Citation preview

Page 1: Ap4-Correlação e Regressão-Estatistica

5/7/2018 Ap4-Correlação e Regressão-Estatistica - slidepdf.com

http://slidepdf.com/reader/full/ap4-correlacao-e-regressao-estatistica 1/3

 

Bd`hj kc Ywcn¼- D-Vf- Nàghc Ehyöjh{c< y`w`cn`ghcIad`hj-fcd RMH^BWVHK@KB NBKBW@J KC Y@WÀ $ RNY@

D`mr`j y`w` ` fcmv{wráæc kb rd` d`{wh| kb

fcwwbj`áæc y`w` kbnhmhw rd dckbjc kb wbawbvvæcjhmb`w vhdyjbv-

@gw` c `wprh~c @jrmcv-ujvu

@ y`w{hw k` arh` K`kcv* mc awryc @màjhvb* fjh$prb bd @màjhvb kb K`kcv-

^`dcv f`jfrj`w ` Fcwwbj`áæc buhv{bm{b bm{wb`v ~`whà~bhv Hk`kb* @j{rw` b Ybvc- Vbjbfhcmb Fcw$

wbj`áæc b bd vbarhk` fjhprb bd CO-

Ywbbmfe` ` {bj` vbarhm{b fcmncwdb cv k`kcv`g`huc- @yöv hv{c* fjhprb bd CO-

@ d`{wh| kb fcwwbj`áæc abw`k` vbwà ` vbarhm{b<

Cgvbw~b prb ` wbj`áæc d`hv ncw{b è bm{wb Ybvc b @j{rw`*prb wbvrj{cr mc ~`jcw `ywcuhd`kc kb 9*1611 cr 16*11"-

@acw`* ~cj{`mkc mc~`dbm{b y`w` ` arh` K`kcv* mc awr$yc @màjhvb* fjhprb bd @màjhvb kb K`kcv-

^`dcv abw`w c dckbjc kb wbawbvvæc jhmb`w vhdyjbv bm${wb `v ~`whà~bhv Ybvc b @j{rw`- Vbjbfhcmb Wbawbvvæc b bd

vbarhk` fjhprb bd CO-

Ywbbmfe` ` {bj` vbarhm{b fcmncwdb cv k`kcv `g`huc-

@yöv hv{c* fjhprb bd CO-

 

YWCN¼ D-Vf- Dhmhfrwvc kb Bufbj @~`má`kc 7909NÀGHC EHYÖJH[C Fcwwbj`áæc b Wbawbvvæc Vhdyjbvqqq-n`ghcehycjh{c-fcd-gw  J@VHA#ABYBF

@JRMC%@(< Bufbj 7909

 

& Nw`vb k` `ycv{hj`<

‚Bmpr`m{c buhv{hw wbvyhw`áæc kbm{wc kb dhd* hwbh ybw$

vhv{hw- Ycw bmpr`m{c br fcmebác rd kcv ywhmfäyhcv kc

vrfbvvc< Vb ybwvhv{hw krw`m{b {bdyc vrnhfhbm{b* hwbh

a`me`w-—%Ca D`mkhmc( 

Page 2: Ap4-Correlação e Regressão-Estatistica

5/7/2018 Ap4-Correlação e Regressão-Estatistica - slidepdf.com

http://slidepdf.com/reader/full/ap4-correlacao-e-regressao-estatistica 2/3

 

Dhmhfrwvc kb Bufbj @~`má`kc 7909  Ywcn¼- D-Vf- Nàghc Ehyöjh{c 

Bd`hj kc Ywcn¼- D-Vf- Nàghc Ehyöjh{c< y`w`cn`ghcIad`hj-fcd RMH^BWVHK@KB NBKBW@J KC Y@WÀ $ RNY@

C wbvrj{`kc abw`kc vbwà c vbarhm{b<

Bv{`{äv{hf`v kc dckbjc kb wbawbvvæc abw`kc* fcd `ywcuhd`áæc bd ; f`v`v kbfhd`hv-

Kbv{` ncwd`* yckbdcv `nhwd`w prb c dckbjc `ywbvbm{cr `ywcuhd`k`dbm{b ` vbarhm{b bv{wr{rw`<

@j{rw` 4 9*9922-Ybvc / 0*661>

Cgvbw~`áòbv nhm`hv<

Mæc yckbdcv bvprbfbw prb vbdywb `m{bv kb bj`gcw`wdcv rd dckbjc kb wbawbvvæc jhmb`w vhdyjbv* kb~b$

dcv ~bwhnhf`w vcgwb cv bwwcv %bwwc 4 ~`jcw cgvbw~`kc ‖ ~`jcw bv{hd`kc(* cv vbarhm{bv ywbvvrycv{cv<

  vbarbd rd` khv{whgrháæc mcwd`j?

  {ìd dèkh` |bwc?

  {ìd ~`whçmfh` φ7 fcmv{`m{b %ecdcfbk`v{hfhk`kb(?

  væc hmkbybmkbm{bv-

W düj{hyjc 9*1611

W$Pr`kw`kc 9*2;;7

W$pr`kw k̀c ̀ lrv{`kc 9*26;1

Bwwc y`kwæc 9*9>05Cgvbw~`áòbv 29

@MC^@

aj VP DP N N kb vhamhnhf`áæc

Wbawbvvæc 0 9*7058 9*7058 21*6952 9*999999990

Wbväkrc ;5 9*0566 9*9965

[c{`j ;8 9*;977

Fcbn hfhbm{bv Bwwc y`kwæc V{̀ { { ~ j̀cw$Y 82" hmnbwhcwbv 82" vrybwhcwbv Hmnbwhcw 82*9" Vrybwhcw 82*9"

Hm{bwvbáæc 0*661> 9*9;29 78*109; 9*9999 0*7;10 0*;757 0*7;10 0*;757

Ybvc 9*9922 9*9991 1*2197 9*9999 9*99;9 9*99>8 9*99;9 9*99>8

Page 3: Ap4-Correlação e Regressão-Estatistica

5/7/2018 Ap4-Correlação e Regressão-Estatistica - slidepdf.com

http://slidepdf.com/reader/full/ap4-correlacao-e-regressao-estatistica 3/3