1Q)

Name +- 3: Susi tha

claw +- Ule oe-v

Reg No {- 321606402314
a Assignecent Subs Businen Frnatethes

cata worksheet ty te excel

Moai tu dota w the bas

F -furction to inthude neo

File € Cre dtt Rusk Date’ using |

Columng , cha mifying “tre crecking
Datarces ao low tf: the balance
YT at least g2sv but tow Than 4
torSe

ee 2 eS Tea

Step-! : Open tre Excel me Credvt Rsk pata” ond navigate

tn the ‘base Data wlorksheet ° |

Bp # ; Sastre Colannny pevgt Of, sme custing checking

and Savings balance Columns .

“checking Balance clamification "and

ard savings account

vs ley Han Jasr , media

20000 , ? hugh other |

dobel thom os

" gonnngs Rotance clomification ”. | |

Step-3 : Enter the TE Funchion tor Checking Balance

Classi fitattoo , Assume the checking batonce ' vo
column B and stant from vow2.

Formula: TF (e? ¢ asv¥ “(ow', TF (2 <2000 ytmedium’, Und)

etep-4: Gopy tre formula down , Prag -tne filt handle

down to apply -the formula to tre entre Column -

ekep-5* Enter tne OF Funthibn for Savings . Balance

Clanifrcation , Assume the Savings balance i's
ca | Column BD ond starts -from Youd 2

Formula: +F (02 2950, "low", TF ( p2 ¢2000 medium", tnt")

Slep- 6 ' Foltouw Stepy

hei
=
: Et'ttered Rexcutt aE

mE) a Tec
von :
oh Gerder Orcepahda | Employrrent:
eee tee | 35 aie an it ee
kt ;
Oe ag MES | eke | ae I> 000
4 lemed Caw [single — | Unnkrlled 000
Lsoun ais Wor ker tO q;

Use database -funchons to find +the average amount ef Savings

or toch of te Sthuakiot cereribed in problem 2 |

dean | L000 | Gende, |Mavihtal | Oteup- lerploy- Checking Saings ph

ro type |Gen ‘on | Ornitnt ee
a joe | c | ht eee longi] Gna
ewtor | - ” Skilled - Be |
new | Fe Single a) & [500 | 3000 | 15000
2 jneoOr) F | éingle Fare 4e | Q500., | 8002 pece?)
= | Educator M— | Mpsued | Unekilled |) | 500 | 600 j4D00 |
‘- worker y } me hae
4 \Ued@s | £ mamed | aewted | 24 | 1000 |1200 | 8000
worker
S |€ducahbo F | Single — |undletied | 1% aco | Spd |600°
) | lorker Mate , ,
G vsedtor) M | Sinde |umskaled) g | 300) |. 15D | #000
Worker am bi
4 |plwocor) M | Marted | skrUed| Go | OO | ged [aspoo
Wwoorkes, y P
g ; ; | men | 1460 |Wbed
Eduction F | gwritd | Poforlo-) 36 (000 | [a
ral es
wd |. | coaelenall 6petted | gob yam (iAP. 1807
9 U x F Sing Levee. ! "13
10 | New Lanes yoo Theo tte t °
nt
eo oo oo

“that oO rondorn Somple of Yoo :

(C) that is the probability

Students wil jaw 0 wean cuore dim +hon 583?

Bree Given Gata t-

. . + Population meron (p) 1607

| Poputolion tordard deviation (=) 1018
| ~» Gomple Sig (W) $304 for port 0 and 4 fos port c.
(8) Standard Evor het ieee sem]
| aul 53 o> population s’P
= n> Sample Ire
For the Comple ef Bou atudents ?
> ae = ees PO
Yau «It
+ron 614.

.) Peo bai lity of a mean Store qrecites

:
y ~- écow forrnulo *.

Z=- *-H X%—> Sample mean

cal > populahion man

For won Score of GI%s

oan G14 “GOT hy tal 8

6-56 6.56

Z > 1-82 C protoowt ity )

> 4 216% Cumalative probaleti'hy
Zz vite ¢s OFFIC 0:96 64

ry

P (21-83) ra L -0:%66y : pD336. bs

1—> Probability % <- 2 is

ESE ate oe
¢€) “t°
( Probe bi l'ty o a nean cot (mM +nan 59% fo 4oo

Studeok °
Standard
Bem - us is
W400 20
Y-Store = 586-60¥ ~ ~(1Q9 5 ~ 3-22
5°40 §*40
Ung +h. x -table Ov a nomoal digi buhibn Colcuda bye -

— The Cumnmulalive probabi lily fos £322 4

4p owv00e (x-stable)

envror {s Somple of Yoo Student:

: 40

veuy (Lose

P (x £ -322) = 9:0006
A Suney | 5D peng profesional found hat trey Spent
an average of 4 20-21 for dining ott, votth a Std dev of
4, |3-8¢ > Find the ower & Upper hounds e asi Confideete
antouwal - Cae ig Conclude statisheolly 4rat +he populatibo

amon 5 gscater 4+ran $23.9

Cample six (nd 2 50

Sample mean (¥) : ¢ 20:2)
Sampk sid dev (s) + $13-88
Confidence hevet Ge 7/, hho
(1) Cotouate tne 95% Confirdeace [evel
—» A451 Confidente intuvol for the mean
5 -t- Cittthutibn (Bit) < 30

a) pelumre tre dale t- nol x 5D-!

=->4Qq
af ea
SEM = po. - 12:88 1334 ~, |-96
Vv" VSb 4-07

c) Colcutate the Mongo of Cro (Me)

= 2-004 K1-9b

= 3-93

da) Compute rh Confidence interval

colower Bound = xk - ME
= 90-91 - 3°93

| 2 ae bs

y+ ME
o:2)\- 3:94

‘
=;

_ Upp Bound =

= >4-l4

| at Con fidete bdipeet for the mean expe

approuimatily ( $le- 23, 4 ou l4)

rdttu re ys

Greater yan 7 2

1°5
(2) Test < eine pao a
Us a one -gumple hi ly sl eeisey
a’) up Hypotnes + t

Nutt Hy pother’s (to) Ween

Atte Hive “Hypothesis (rt p>23

b) Calculate the test Statist }

+= m Po Mo = 23

sctEM : i vie :
3 pay rc ——

4 = 20:21 ~ a3 9:99
ae “Th %

the P va lus

e-'%

(t) Determine

esr #49 degree

of freedom
fo o one tarled bai 7 {6 7o0l0

P-value

P- value i y+o-S
+p —> not nveyeck +he uu Aaypottents

vecoras the vocnyt

Dir qy~ inchuctor”

of 3 male high So echo Students . The ween suoerght — vo0s:
found be. [UO pounds and ~ne siardard deviahon of &
poputotio? iS 20 pounds - How donge a cumple thould be
elected to eshirrote snat ne mean rs — volthin os with
asl. Confident level
Aves Lim atondad | peviatibo fo3:' 50 pounds
Mogin Of peor 0 eee ee
Confud ence level * qs" |
mn) ped rE Ou lle Ganfidente level t-
asl) — Confido i). are ee Conttical gly 's
Approx 1°96
0) Coleutote -ine Required somple SE $0) (2) voy
m= (ee Be) ‘ig Sivas (sh fr 95)
ge ee 5 Ds c.g Tt ae ale
aso

a) mow gin Of exror

N= (isaex20) "= jee?) re
—— << . (4¢”

N= GI5°>°

nm ~~ GIG
to ental sine Mmeon wxignt vutthin .0*S pounds with 4571
(. required .

Gon fidemce , a gomple Sie of Gb Sluden

une people yeod an coer o more
month, fi Suwey Of 20 vando mn persons
mmeon m0» Of hooks they yead was 24

According 4p O ey
tmn 3 books um
Found thot t<

wit a SP of |-23

tye Magazints Cloum >» Oat ghould he me

a) ‘To deat 4

oppropw'ote hypothe rw ?
+n test statiche

b) Compute

c) using a level of ; tip o| 0 Daa us the bch'cal

wolut ° ony |

A Find tre P-value fr tre tel ee Ce

e) What ts the Conclusion 9 | , :

Giver dota,

Sample alte (9) 520

Sample meon (K) 42°9

ne Gd dev (3)! 1-23 di

oun by The M ati | More tan |
"4 5 books sper mort

aa (evel (x) 1 005

Ve
i
E¥plasy tov to ux this toformation to drtw G Conchyton

f tre nut Ay po treats K Apt pp- pms = 0° Cle arte State H,,

tte Covvect Crtbical voulue and P-vause and your Conclurion .

b Explacn show to We -thnit <4" eddie to draco & Conclunon

rf tre nutt ny potron's i Hot Ue -Hm 7 = 0° Cheasty State H, »

He towect Critical value and p-value and your Conclunon .

Explaco how to Wwe ths in for matios to dratio a Conthuntorn

if the Nutt hy potneds 9S Ho ii Hp-Mm=O + Clearly etate H,,
tine Conect Crititol value and p-value Ond your Conclinion .

=) tev tupotrems: Ho: Mp ~ Hm sO

Alternative Hy potinen's ( H1) ! Mp “myo ; |

one -fated tut wttu te attenatve uypotien’ imdicahing

that te won no-g movits. lalatched by females t's
greater thon that by males. i

—> Crolital value :- One tasted bet af O Significamie level of

0-05, tre critval yvolue VS [#6 |

4- slate IS -bI33.

: ‘

ls ¢+-stat :- Th Computed
| 5 pvatue fone-tarl) : 07198

| Conctuston }-

F 4-stobe (- ,.13) < ordfital value (1-40) g the pvalue (oi3e)

y He significance level (0-05)

lle {out to vejeck the ru ny pothes's

— ses is mot enough eur dence to support the cLoahry
thal formless watth mort movies tuan moles.

aD
i aoe a re
rie ate jane
sol:4

—> This is not enough eutderce 40 Conthude ted, -Hrere fs

a Stgn'ficant Af ference un the 0-o movies watched

betucen malts and forala.

10)/ A manufacturer of atuto motot les is bringing out O Neo

th advertising Camporgn, te eronufack -

moo ote -
—urer wanh to detenmue whether Hoe modls appeor vot tt

be dependent on 2 particular age group » A sample of &

uv Oy sevealed He following :

yo create

Gurtumen
Appeat /Age grup > | under 20 | 26-28 | Yoru |sv gakwe|
Like {uo 40 | 40 Qs
Dis UKE |
60 Yo
20 b 6S;

What Con the monufacturer Conctude °

Steps for Ct Square Test +

(1) stote Hy pothen's i

« af

age Group
7 dependent on age, OUP :

(2) Cotcutote fre Expected prequence’e f-

Ey peck ed Prequenty = Row total ¥ Column “Deol

Grand +otal

Hp 2 ‘rppeot of the automobile model ic in dependent q

*e Given dato.
; sininiapaians
| | Appeal / Age Group |
| | al AY DT ~ Cunder 20 20-34 UO-4O | soz anove Total
| lithe \uo 40. «14.35 Sih 205
pislike “Cpa ted § :
60 a+ S10 BO" 165 Las
Total 200 {to | too Qo §00
Xm 9:60 4 O12-4 [US + 1608 + 41S -++ O16 4 2:05 4+ 25-60

x? es $243
De termine ate hegre of freeclon
df =2(o0-of vous <i KeLOT

Gluumns i

Bee f5-1) Tusa eer ee

Find “the ont tic \iobse @ p-volue

~» chi-square distributive tore , find the cniticol vous Pr
df-3 oat v= 0:06.
oxthital value > 4-815
tital VoUre °

> cni-squev statist Compote wot On

bo La Ye» Walt ae Slo tish'cally significort

—> P-value axouuted yotth Go Chi- [Link] sta take of

Con pust0O a

atatswe (x>) 2 52°45

vow emo (much Lm Anan 00S)

i gp wore :
air, ue vejeck

y2> cribital wotue G P-value 1's 6

tn MUL ld

S31