DSCI 232 Fall 2014 (12609)
Professor: Dr. Gioconda Quesada 1
DSCI 232 – 10 (CRN 12609). Business Statistics II Professor: Dr. Gioconda Quesada Office: BCTR 434 (Beatty Center) Meeting Times: ONLINE E-mail: [email protected] Office Hours: Office Phone: (843) 953-4277** By Appointment (via skype) (Skype: drquesada.cofc) **Do not leave voice messages; instead send me
an email, I don’t check voice messages! Course Description: Advanced statistical analysis with applications in business and economics utilizing relevant computer software. Topics include business applications in descriptive and inferential statistics emphasizing such topics as simple and multiple regression, analysis of variance, forecasting, quality control, and non-parametric techniques. Academic Prerequisite
EXCEL Requirements before Week 1 Click on the icon on the left to open the link to the Video or Tutorial.
The student is expected to have some Excel knowledge. These videos/tutorials are mandatory and students should be able to duplicate all the material learned in those videos before the first day of class. The professor will assume the topics explained in these videos/tutorials are the base knowledge of all students after the first week of class!!! People who really feel behind in Excel Skills, should buy a Simnet Account at: https://cofc.simnetonline.com; you must select the course "DSCI 232 Dr. Quesada/Dr. Gonzalez". You must cover the Excel lessons during the first two weeks of class. It is a lifetime license, so you can use it later on. Cost: $85 (select “Simnet 2010”). A video to show you how it looks like can be found at:http://youtu.be/nT-KL5ppvV8
Create your First Spreadsheet Length: 40-50 minutes
How to Create Formulas? Length: 35-45 minutes
Create a Chart in Excel Length: 30-40 minutes
How to activate Data Analysis? Length: 1-2 minutes
How to create a Histogram? Length: 4:28 minutes
Get started with Pivot Tables. Length: 40-50 minutes
MAC USERS. Data Analysis/Histograms. Length: 6:32 minutes
D
Pr
�SQ
�
�
�
*Aa�Stastw
�
DSCI 232
rofessor: Dr. G
1. Interp2. Apply�
probab3. Use�sta4. Apply�
applica5. Apply�
applica6. Apply�
making
chool�of�BQuantitative�F
Quesada,�GStepͲByͲSteBooks�of�Ch
*Exam*ExamFinal�ExQuizzeHomew
A�proctored�estudent�whiltudents�who�s�scheduled�bwo�weeks�bef
x Find�a�two�wPleaseCLOSE
x A� go(https:
x All�exa
Gioconda Ques
ret�business�dsimple� concbilities)�and�patistical�testshypothesis� tations.�ANOVA� and�ations.�ChiͲSquared�g.�
Business�Leluency:�Stude
Te
G.�and�Gonzaep�Cougar�Apharleston***�
NO�
>=�92Ͳ94.87Ͳ91.83Ͳ86.80Ͳ82.76Ͳ79.
�1�(Ch.�1�to�5�2�(Ch.�5�to�7xam�(Ch.1Ͳ�9)s�work�
exam�is�one�tle�he�or�she� ilive�within�50by�the�instrucfore�the�begintest�proctorieeks�prior�toe� fill�out� the�D�FRIEND,�ORod� facility�://www.promams�should�st
sada
data�using�decepts� of� probprobabilities�(�to�make�infetesting� for� on
goodness� o
tests�and�reg
earning�Goents�will�dem
ext�and�Co
lez,�M.�Springpproach”.�**CUSTOM�WOOLDER�VERS
Grading�anLETTE
95� A�99� AͲ�99� B+�99� B�99� BͲ�99� C+�
)ͲSeptember�)ͲOctober�22n
)�–�December
hat�is�overseis�taking�an�e0�miles�of�Cofctor.�As�an�altnning�of�the�cing�site�at�a�l�the�start�of�“RequestProR�A�STUDENTis� Sylvan�
metric.com/enart�at�3:30�pm
�
Learninescriptive�statbability� distrgiven�statisticerences�aboutne� and� two�
f� fit� for� test
gression�for�t
oal�Addressonstrate�com�
ourse�Mate
g�2014.�“Busi**Available� inORKBOOK.��SIONS�ARE�A
nd�EvaluatER�GRADE�
��
73Ͳ70Ͳ66Ͳ63Ͳ60Ͳ
22nd�3:30Ͳ5pmnd�3:30Ͳ5pm�ar�6th�12Ͳ3pm�i
en�by�an�impexam.�The�profC�campus�arternative�to�fclass,�the�facuocal�universitclass.�ContacoctorAcceptan.�Learning� C
nͲus/Pages/hm�EST�on�the�
ng�Objectivtistics�techniqibutions� to� bcs)�for�normat�a�populationpopulations�
ing� for� differ
testing�relatio
sed�mpetency�in�lo
erials:�
iness�Statistin� the�Bookst
ALLOWED!!!
tion:�
Ͳ75.99 C�Ͳ72.99 CͲ�Ͳ69.99 D+�Ͳ65.99 D�Ͳ62.99 DͲ�<�60 F�
m�at�ECTR109at�ECTR�108�on�TCFE�130�o
�artial�individuoctor�ensurese�encouragedaceͲtoͲface�eulty�member�ty.�Informatioct�informationnceForm”.� YO
Centers� httpome.aspx)��assigned�dat
ves:�ques,�includinbusiness� proal,�tͲStudent,�n�based�on�a�to� test� for�m
rences� amon
onships�betw
ogical�reasoni
ics�for�Managtore�and�Uni
9�or�in�Proctoor�in�Proctorinor�in�Proctorin
ual�(called�a�ps�the�securityd�to�take�the�exams,�if�you�requires�the�fon�about�thisn�and�a�link�tOU�CANNOT�
p://www.sylv
e�(no�excuses
ng�the�use�of�soblems,� solvinChiͲSquared�sample.�means� and� p
ng�multiple� p
ween�variables
ing�and�data�a
gers:�A�iversity�
oring�Facility�ng�Facility��ng�Facility�
proctor)�who�y�and�integritexams�face�tsent�the�instfollowing:�s�site�must�beto�their�websUSE�A� PERSO
vanlearning.
s).�
Fall 2014
spreadsheet�fng� for� statistand�F�distribu
proportions� in
populations� in
s�for�busines
analysis�skills
15%�15%�20%�20%�30%�
monitors�or�ty�of�the�examto�face�in�the�ructor�an�em
e�sent�to�theite�should�beON� THAT� IS�
.com/)� or�
4 (12609)
2
functions.�tics� (given�utions.�
n� business�
n� business�
s�decisionͲ
s.�
supervises�m�process.�classroom�
mail�at�least�
�instructor�e�provided.�FAMILY,�A�
Prometric�
DSCI 232 Fall 2014 (12609)
Professor: Dr. Gioconda Quesada 3
Rules�Specific�to�Online�Learning��
x The�asynchronous�onͲline�format�allows�selfͲmotivated,�taskͲdriven�students�the�flexibility�to�complete�coursework�over�the�internet.�If�you�are�not�selfͲmotivated/taskͲdriven,�it�might�not�be�a�good�idea�to�take�this�course�online!�
x Because�we�don't�actually�meet�faceͲtoͲface�(only�for�the�exams),�it's�essential�that�you�maintain�an�active�presence�in�the�class,�checking�OAKS�regularly�and�viewing�the�assigned�lectures/videos�as�soon�as�they�are�posted,�before�the�next�videos/lectures�come!��Remember�that�I�can�see�when�you�log�onto�OAKS�and�monitor�your�progress�through�the�class.�
x Online�is�NOT�easier�than�a�physical�class�environment.�On�the�contrary,�if�you�don’t�have�the�discipline�and�organization�to�keep�up�with�the�class�on�your�own,�online�can�be�more�difficult�than�regular�physical�environments.�
x Much�of�the�class�will�be�run�like�a�traditional�course,�except�that�the�online�format�should�encourage�more�exchanges�between�students�than�you�might�be�accustomed�to�in�a�physical�classroom.��You�will�be�expected�to�do�the�same�sorts�of�activities�that�you�do�in�a�regular�class�such�as�reading�and�writing,�guided�by�feedback�from�me,�and�heavy�video�watching�and�practicing�on�your�own.��
x It�is�essential�that�you�stay�on�top�of�the�course�assignments.��I�will�post�due�dates�and�reminders,�but�it�is�on�you�to�make�sure�that�you�don't�get�behind.�Do�not�make�the�mistake�of�thinking�this�is�an�easy�class�because�we're�meeting�online.�The�material�is�quite�difficult,�and�will�take�a�lot�of�effort�on�your�part�to�master.��A�regular�physical�class�normally�entails�2.5�hours��of�classroom�time�per�week,�plus�minimum�of�7�hours�per�week�of�study�time.�The�workload�for�this�class�will�be�the�same�for�you�to�succeed.���
x Weekends!�Although�I�expect�you�to�be�working�on�the�course�during�weekends,�you�should�not�expect�me�to�answer�emails�during�Weekends�or�night�time.�My�times�to�answer�emails�are�8:30�am�to�5�pm.�Every�now�and�then�I�answer�emails�outside�the�set�time,�however,�do�not�expect�me�to�do�so�on�a�regular�basis.�Maximum�time�for�me�to�respond�emails�during�the�week�is�24�hours.�If�I�have�not�responded�to�your�email�within�this�time,�please�send�the�email�again,�and�make�sure�you�do�not�send�it�to�“[email protected]”.�My�email�address�is�“[email protected]”.�
x Students�are�expected�to�be�polite�and�respectful�in�ANY�communication�with�others�in�our�course�community.�This�includes�emails,�discussion�postings,�etc.��
Required�Technology�
x Hardware:��o Computer�with�high�speed�internet�access,�WebCam,�sound�and�video�card�(to�play�videos).�
x Software:��o Microsoft�Office�2010�(Windows�Version).��o If�you�have�a�Mac,�you�can�still�use�it�for�everything�we�do�in�class,�but�you�will�have�to�learn�it�on�
your�own,�if�they�happen�to�be�different�from�the�Windows�version.�If�you�are�a�Mac�User,�you�must�install�StatPlus�(for�free)�and�learn�how�to�use�it�on�your�own!��
o Adobe�Flash�Player�o Adobe�Reader�o Browser�o OAKS�(you�must�check�in�OAKS�everyday:�Calendar/Assignments/New�Videos,�etc)��o Skype�for�online�office�hours:�drquesada.cofc��(you�have�to�make�an�appointment�since�I�don’t�
have�it�active�all�the�time)�x For�help�with�basic�Excel�material�that�is�not�covered�in�the�class:���
o The� Student� is� expected� to�have� some� Excel� knowledge.� If� you� lack� this� knowledge,�please� all�videos�posted�under�CONTENTͲVIDEOS/TUTORIALSͲEXCEL�BASICS,�in�OAKS.��
o These�videos/tutorials�are�mandatory�and� students� should�be�able� to�duplicate�all� the�material�learned� in� those� videos� after� the� first� week� of� class.� The� professor� will� assume� the� topics�explained�in�these�videos/tutorials�are�the�base�knowledge�of�all�students�after�the�first�week�of�class!!!�
DSCI 232 Fall 2014 (12609)
Professor: Dr. Gioconda Quesada 4
o Links�to�all�videos�are�posted�on�OAKS,�including�videos�for�Microsoft�Office�2003Ͳ2010�and�Mac.�People� who� really� feel� behind� in� Excel� Skills,� should� buy� a� Simnet� Account�at:�https://cofc.simnetonline.com;� you� must� select� the� course� "DSCI� 232� Dr.� Quesada/Dr.�Gonzalez".�You�must�cover� the�Excel� lessons�during� the� first� two�weeks�of�class.� It� is�a� lifetime�license,�so�you�can�use�it�later�on.�Cost: $85 (select “Simnet 2010”). A�video�to�show�you�how�it�looks�like�can�be�found�at:�http://youtu.be/nTͲKL5ppvV8�
TECHNICAL�SUPPORT�
x If�you�have�technical�problems,�please�contact�the�Student�Computing�Support�Desk�at�843.953.5457�or�email�[email protected].�Check�for�computing�downloads�and�tutorials�at�blogs.cofc/scs/�
x Resolve�problems�promptly.�Computer�failure/unavailability�does�not�constitute�an�excuse�for�not�completing�assignments�by�the�due�date.�You�must�not�leave�homework/quizzes/exams�to�the�last�minute!�
x Simnet�technical�support��at�1Ͳ800Ͳ331Ͳ5094�or�by�chat:�http://mpss.mhhe.com/contact.php�x The�professor�won’t�provide�any�technical�assistance�on�connect�or�any�computer�related�problem,�you�
must�use�either�Connect�technical�support�or�Student�Computer�Support�Desk.��
EͲmail�Business�Etiquette�
Do�not�abandon�business�etiquette� in�your�use�of�eͲmail!� I�will�not�respond� to�eͲmails� if�you�do�not� follow� the�below�guidelines:��
x BusinessͲlike�writing�style�(Dear�Dr.�Quesada,�Sincerely,��etc..)�x Be�concise�and�to�the�point.�x EͲmail�alias�so�recipient�sees�your�full�name,�or�your�full�name�with�@g.cofc.edu,�in�his/her�eͲmail�inbox.�x Subject�line�meaningful�to�recipient�(consider�identifying�your�class�DSCI�232ͲONLINE).�Always�include�this�
as�your�subject�line!!!�Including�section�number.�x Content�clear�states�the�purpose�of�the�eͲmail�including�any�action�to�be�taken�from�the�professor.�x Clear�signature�block�with�your�full�name,�postal�mailing�address�and�return�eͲmail�address�(obviously�
there�is�no�handwritten�signature,�nor�do�I�require�a�digital�signature).�x Be�careful�about�including�quotations�and�sayings�in�your�signature�block.�Obviously�don't�include�
anything�that�has�potential�to�be�offensive�or�misunderstood.�Think�about�the�impression�your�message�sends�to�someone�who�doesn't�know�you,�and�be�judicious.�
Missing�Exams�x No�makeup�exams/quizzes�will�be�given.��x Dates�for�exams�are�posted�in�the�Calendar�a�month�in�advance�class�starts.�x There�will�be�NO�MAKE�UPS�under�ANY�circumstances.��x A�dropbox�in�OAKS�will�be�opened�to�submit�files�during�exams.�x EXAMS�AND�QUIZZES�ARE�CLOSED�BOOKS/CLOSED�ADDITIONAL�MATERIALS�AND�ARE� INDIVIDUAL�WORK.�
THE�HONOR�CODE�WILL�APPLY!!!!��
SNAP�Students/Special�Accommodations/Athletes�x Students�needing�special�accommodations�should�present�official�letters�to�the�professor�within�the�week�of�
class.�x No�additional�time�will�be�given�for�homework/quizzes.�We�measure� in�homework/quizzes�the�ability�of�the�
student�to�respond�within�a�specific�time�what�is�being�tested,�additional�to�answering�the�question�correctly.�x For�all�other�tests,�students�will�get�the�extended�time,�but�within�the�window�in�which�the�examination�will�
be�opened�(you�must�start�the�exam�close�to�the�time�of�the�rest�of�the�class�in�the�SNAP�computer�lab).�If�I�open� the� quiz� or� homework� window� for� 24� hours� or� 3� hours,� SNAP� students� must� also� complete� the�quiz/homework� in� that� window,� no� additional� time� outside� this� window� will� be� allowed� under� any�
DSCI 232 Fall 2014 (12609)
Professor: Dr. Gioconda Quesada 5
circumstances.� Please� consider� the� additional� time� you� have� for� your� special� accommodation� in� order� to�prevent�from�finishing�the�homework/exam�after�the�window�closes.�
x The�College�will�make�reasonable�accommodations�for�persons�with�documented�disabilities.��Students�should�apply� at� the� Center� for�Disability� Services� /� SNAP,� located� on� the� first� floor� of� the� Lightsey� Center,� Suite�104.��Students�approved�for�accommodations�are�responsibility�for�notifying�me�as�soon�as�possible�and�for�contacting�me�one�week�before�accommodation�is�needed.�
�College�of�Charleston�Honor�Code�
x Lying,�cheating,�attempted�cheating,�and�plagiarism�are�violations�of�our�Honor�Code�that,�when� identified,�are�investigated.��Each�incident�will�be�examined�to�determine�the�degree�of�deception�involved.�
x Incidents�where�the�instructor�determines�the�student’s�actions�are�related�more�to�a�misunderstanding�will�handled�by�the� instructor.� �A�written� intervention�designed� to�help�prevent�the�student� from�repeating�the�error�will�be�given�to�the�student.��The�intervention,�submitted�by�form�and�signed�both�by�the�instructor�and�the�student,�will�be�forwarded�to�the�Dean�of�Students�and�placed�in�the�student’s�file.����
x Cases� of� suspected� academic� dishonesty�will� be� reported� directly� by� the� instructor� and/or� others� having�knowledge�of� the� incident� to� the�Dean�of� Students.� �A� student� found� responsible�by� the�Honor�Board� for�academic� dishonesty� will� receive� a� XF� in� the� course,� indicating� failure� of� the� course� due� to� academic�dishonesty.� � This� grade�will� appear�on� the� student’s� transcript� for� two� years� after�which� the� student�may�petition� for� the�X� to�be� expunged.� � The� student�may� also�be�placed�on�disciplinary�probation,� suspended�(temporary�removal)�or�expelled�(permanent�removal)�from�the�College�by�the�Honor�Board.��
x Students�should�be�aware�that�unauthorized�collaborationͲͲworking�together�without�permissionͲͲ� is�a�form�of�cheating.� �Unless�the� instructor�specifies�that�students�can�work�together�on�an�assignment,�quiz�and/or�test,�no�collaboration�during�the�completion�of�the�assignment�is�permitted.���Other�forms�of�cheating�include�possessing�or�using�an�unauthorized�study�aid�(which�could�include�accessing�information�via�a�cell�phone�or�computer),�copying�from�others’�exams,�fabricating�data,�and�giving�unauthorized�assistance.�
x Research� conducted� and/or� papers�written� for� other� classes� cannot� be� used� in�whole� or� in� part� for� any�assignment�in�this�class�without�obtaining�prior�permission�from�the�instructor.���
x Students� can� find� the� complete� Honor� Code� and� all� related� processes� in� the� Student� Handbook� at��������http://studentaffairs.cofc.edu/honorͲsystem/studenthandbook/index.php�
x Each�student�is�expected�to�complete�their�own�work�in�assignments/quizzes/exams�without�additional�help.���
Miscellaneous�Policies:�x Although� I�will�try�to�maintain�the�class�schedule�and�objectives,� I�may�need�to�make�adjustments.�You�are�
responsible� to� check� OAKS� schedule� for� the�most� recent� calendar� of� activities� and� dates.� Don’t� ask� the�professor�about�exams�dates,�since�he/she�will�not�give�you�as�accurate�information�as�the�OAKS�schedule.�
x The�professor�does�not�give�additional�projects� to� increase�students’�grades�before�or�after� the�exam(s).�The�professor�does�not�round�grades,�a�59.9�total�grade�is�an�F.��
x No�food�or�drinks�allowed�in�the�lab.�This�is�a�SchoolͲwide�policy,�nonͲnegotiable!��x The�professor�has�the�right�to�disable�OAKS�4.5�hours�before�the�test.�You�still�have�your�book�to�study�lastͲ
minute� concepts.�However,� plan� accordingly� that� you�will� have� no� access� to� data� or� videos� or� any� other�material�in�OAKS.�
x Homework�is�individual�work,�and�should�be�completed�only�by�the�student�taking�the�course!!!�Students�will�be�able�to�obtain�feedback�1�hour�after�the�due�date�of�the�homework.�No�late�homework�assignments�will�be�accepted�under�any�circumstances.�� �
DSCI 232 Fall 2014 (12609)
Professor: Dr. Gioconda Quesada 6
Complaints�about�Exams�Grading�x The�professor�encourages�students�to�review�in�detail�when�exams/quizzes�are�returned.�You�have�3�working�days�after�the�graded�evaluation�is�turned�back�to�you�to�make�any�questions�or�complaints�about�it.�If�that�time�is�passed,�it�means�you�have�accepted�the�grade�given�and�no�further�complaints�are�accepted.�x No�complaints�are�accepted�for�any�reason�if�the�3Ͳday�period�has�passed�(nonͲnegotiable).��
Teaching�Method�x Lecture (videos), assigned reading, hands-on exercises, and problems. We will use e-learning as a support tool in the course, therefore, students should have the responsibility to learn how to use Excel (use the videos in Microsoft website to review Excel OR BUY simnet (https://cofc.simnetonline.com (make sure to select the right class-DSCI 232). You must buy the Simnet 2010 only. The professor will assume you know ALL the tasks practiced in the videos posted in OAKS under Excel Basics). Any detailed questions about excel, should be done outside the classroom to avoid distracting class objectives. x All assignments, videos, assigned readings should be completed by 2 pm (EST-Eastern Standard Time) on the assigned date. No late assignments will be accepted under any circumstances!!! Solutions to assignments are usually posted right after due date. All students are expected to have access to their account on OAKS and are responsible for keeping their email account active and check it frequently. I will have to use the official g.cofc.edu email account. Course materials and links to each module will be placed in OAKS and you should regularly check-in for announcements and updates, CHECK THE CALENDAR REGULARLY TOO. Make sure you update your oaks profile to reflect your active email account otherwise you will not get my e-mails. x The official computer hardware is PC-windows based. If you are a Mac user, you must learn on your own how to use StatPlus, which pretty much takes care of everything (except for histograms). All videos are using a windows environment. ALL EXAMS ARE TO BE COMPLETED IN A WINDOWS ENVIRONMENT!!! x Quizzes and exams are time restricted, no additional time is allowed. x Homework, Quizzes and Exams that require you to submit the "hard copy" means that you must scan, take a picture, etc, of the work and submit it to the professor using the Dropbox no later than 2 pm on the due date. Failure to show the "hard copy" will result in a grade of 0. x Computer failure/unavailability does not constitute an excuse for not completing assignments by the due date. The recommendation is to start homework as soon as it is posted, in that case, if you have a computer problem, you will have time to fix it before the due date/time. x ALL VIDEOS ARE MANDATORY from start to finish!!!!
Topical�Coverage��
1. Introduction.�Descriptive�Statistics.�2. Continuous�Probability�Distributions:�Normal,�tͲStudent,�ChiͲSquared�and�F.�3. Interval�Estimation.�4. Hypothesis�Testing�–�One�Population�5. Hypothesis�Testing�–�Two�Populations�6. ANOVA�Single�Factor�7. Goodness�of�Fit�Test�8. Test�of�Independence�9. Simple�Regression�10. Multiple�Regression�
��
You�will�find�the�most�updated�schedule�in�OAKS�schedule!�� �
DSCI 232 Fall 2014 (12609)
Professor: Dr. Gioconda Quesada 7
HOMEWORK�POLICY��
SelfͲgrading�have�many�benefits.�If�you�grade�your�own�homework,�you�see�exactly�where�your�mistakes�are.�You�also�obtain�feedback�sooner�than�if�the�instructor�collects�the�homework,�grades�it,�and�then,�returns�it�some�days�later.��A�minute�after�the�homework�is�due,�you�can�go�back�to�OAKS>GRADES>QUIZZES�and�click�on�the�arrow�next�to�the�homework�name.�Then,�select�SUBMISSIONS�and�when�the�submissions�show,�click�on�ATTEMPT�1.�You�will�be�able�to�download�an�instructor�key�for�the�homework.�Notice�that�the�specific�formulas�vary�by�student,�the�downloaded�version�will�have�a�standard,�but�you�will�have�to�double�check�with�individual�feedback�for�the�questions.��You�must�correct�mistakes�on�your�work�using�a�different�colored�writing�utensil.�You�must�write�a�note�about�what�you�missed�(such�as�math�error�or�“wrong�test�statistic�formula”�or�“did�not�multiply�by�2”).�Your�student�id�number�and�HOMEWORK�NUMBER�should�be�on�top�of�the�first�page.��Write�the�score�for�each�problem�and�the�score�for�the�whole�assignment�at�the�top�of�the�front�page.���Submit�the�selfͲgrade�homework�with�the�homework�name�PLUS�selfgrading�on�it.�i.e.�“homework3_selfgrading”.�And�upload�it�to�Dropbox�HOMEWORK�to�the�corresponding�homework�dropbox.�This�is�due�24�hours�after�due�date/time.�i.e.�If�homework�is�due�at�2�pm,�then,�the�selfͲgraded�homework�is�due�at�2�pm�the�next�day.��SAME�AS�HOMEWORK,�ONLY�ONE�FILE�SHOULD�BE�SUBMITTED�EACH�TIME.�IF�YOU�HAVE�MULTIPLE�PICTURES,�JUST�CREATE�A�WORD�DOCUMENT�AND�ADD�EACH�IMAGE�TO�A�PAGE,�MAKE�SURE�IT�IS�READABLE�AND�CLEAR.�ALL�HOMEWORK�SHOULD�SHOW�THE�WORKINGS�ON�BOOK�TEMPLATES�ASSIGNED.���Scanned�homework�will�be�picked�at�random�for�grading.�There�are�a�total�of�22�homework�assignments.�All�of�them�require�complete�solutions�scanned�and�uploaded�to�the�Dropbox.�The�complete�solutions�require�all�diagrams,�formulas,�all�parts�of�the�templates�completed�(even�if�it�is�not�requested�in�the�online�version�of�the�homework)�for�it�to�be�100%�correct.�It�is�the�student’s�responsibility�to�complete�all�22�homework�assignments�as�if�each�of�them�will�count�towards�their�grade.�The�instructor�will�randomly�select�assignments�for�full�grading�and�the�grade�shown�in�the�online�submission�could�drop�due�to�incomplete�scanned�solutions.�Students�don’t�get�to�pick�which�homework�assignments�will�be�graded.�You�could�have�worked�on�all�21�and�left�1�without�complete�solutions,�if�that�one�is�your�assigned�graded�assignment,�that�would�be�the�grade�that�reflects�your�homework.�Please�do�not�rely�on�incomplete�solutions,�all�students�should�work�hard�on�homework�to�prepare�for�tests.�The�professor�will�randomly�choose�students�to�verify�complete�solutions�are�submitted.�If�you�are�a�chosen�one�today�and�you�don’t�have�complete�solutions�in�the�dropbox�or�the�solutions�don’t�match�the�online�submissions,�your�grade�will�drop�to�0�even�if�your�quiz�grade�is�100.��Failure�to�submit�the�selfͲgrading�homework�results�in�a�grade�of�0�for�that�particular�assignment.�The�same�rule�applies�if�the�student�does�not�complete�all�the�work�in�the�designated�templates�on�the�book�with�complete�formulas,�diagrams,�etc.�� �
D
Pr
T
EXBA(Wbeclst
Ch(Wbeclst��
DSCI 232
rofessor: Dr. G
The following
UNIT�CHA
XCEL�ASICS�Week�efore�ass�tarts)�
IntrExcPreCou
h.�1�Week�efore�ass�tarts)�
PreCou
Gioconda Ques
g is just an o
TEXT�APTERS/TOPICroduction�to�el�erequisite�urse�Review�
erequisite�urse�Review�
sada
Coutline, what
C
C��
Course�Outt I expect to
Course�Out
�
VIDEO123
OFFIC123456
MAC�U12
�
Chapt
�
SYLLA12
CONT(Lectu
123
�
�
CHAPT¾¾
¾
line�and�Timdo each wee
line�and�Tim
OS/TUTORIALS>. Simnet�Exc. Navigating�. How�to�tak
CE�2007/2010. How�to�Loa. Create�you. Create�a�Ch. How�to�Cre. Get�Started. How�to�CreUSERS�(ADDͲO. AddͲOn�to�. How� to� i
Descriptiveter�1
ABUS�AND�GRA. Online�Day�. How�to�tak
TENT>Chapter1ures/Tutorials). Unit1_Vide. Unit1_Vide. Unit1_Vide
TER�1:¾ Review�and¾ Study� Theo
Questions�(¾ Solve� Pract
with�“Solut
metable�ek. It is certa
metable�LESSON�PLAN�
>Excel�Basics�(el�Help�(4:37)in�OAKS�(09:1
ke�a�quiz/home
ad�Data�Analysr�First�Spreadshart�in�Excel�(3eate�Formulas?d�with�Pivot�Taeate�a�HistograON�INSTALLATIUse�Data�Analinstall� Stat� Pe�Statistics�(6:3
ADING�DISTRIBUy�1�(9:29)�ke�quizzes�and�
1ͲIntroduction�):�eo1�(22:41)�eo2_YouTube�(eo3_YouTube�(
d�Solve�“Solvedory� and� Solve(page�19)�tice� Problemstions�to�Book�P
ainly suitable
�(all�under�Con
mandatory�be
1)�ework�in�OAKS�
sis�(Analysis�Tosheet�(40Ͳ50�m0Ͳ40�min)�?�(35Ͳ45�min)�ble�Reports�(4am�(4:28)�ION)�ysis�Similar�EnPlus,� create�32)�
UTION:
get�feedback�
�to�Business�St
(6:20)�(10:22)�
d�Examples”�(pe� Review� Prac
s� (pages� 35Ͳ38Practice�Proble
Fall 2014
e to change.
ntent)�
fore�class�start
and�get�feedb
olpak)�min)�
40Ͳ50�min)�
vironment�Histograms� a
tatistics>Ch1ͲV
pages�14Ͳ18)�ctice� for� Mult
8)� and� compaems”�under�Con
4 (12609)
8
ts)
back�(04:00)�
and� obtain�
Videos�
tipleͲChoice�
are� answers�ntent.�
D
Pr
Ch(DAu
DSCI 232
rofessor: Dr. G
h.�2.��Day1)�ug�20th��
ConProDist(NoProDist
Gioconda Ques
ntinuous�bability�tributions�ormal�bability�tribution)�
sada
�
Chapt
�
CONT(Lectu
12345678
Additi9
1
1
1
�
�
CHAPT¾¾
¾
¾
Study�evaluain�tho
Chaptpm�tocannotime�o
ter�2�(only�page
TENT>Chapter2ures/Tutorials). Understand. Unit2_Vide. Unit2_Vide. Unit2_Vide. Unit2_Vide. Unit2_Vide. Normal�Pro. Normal�Pro
ional�suggested. Computing
Tail):�YouTu0. Computing
Tail):�YouTu1. Computing
Between):�Y2. Normal� P
Probability
TER�2¾ Review�and¾ Learn� form
and�probabnormal�dist
¾ Study� TheMultipleͲCh
¾ Solve� Practwith�“Solut
and�get�readyated�both�on�cse�videos�and�
ter�1.Multiple�o�2�pm�but�it�is�ot�close�it�and�cor�you�will�get�
es�39Ͳ46)
2ͲContinuous�P):�ding�the�Normeo1�(05:02)�eo2�(02:29)�eo3�(13:04)�eo4�(03:12)�eo5�(03:03)�obability�Probleobability�Proble
d�videos:�g� Values/Probaube�(15:05) �g�Values/Probaube�(18:08)�g� Values/ProbYouTube�(11:3Probability� P:�YouTube�(5:0
d�Solve�“Solvedmulas�on�How�tbilities� (given�vtributions�in�EXory� (pages� 3hoice�Questiontice� Problemstions�to�Book�Py�with�“Prerequconcepts�(theoin�Chapter�1�o
Choice/Fill�in�ttime�limited�acome�back,�yoa�0�in�the�quiz
Probability�Dis
al�Distribution
em�(Tables)�(3em�(Excel)�(11
abilities� for� N
abilities� for�No
abilities� for�30)�ProblemͲComp00)�
d�Examples”�(pto�solve� for�vavalues�of�x)� foXCEL�(pages�579Ͳ46)� and� Sons�(pages�55Ͳ56s� (pages� 59Ͳ69Practice�Probleuisite�Course�Rry)�and�practicof�the�book.�
the�Blanks�Quiand�it�must�be�tur�quiz�duratioz.�Quizzes�are�in
Fall 2014
stributions>Ch2
n:�YouTube�(13
7:30)�:17)�
Normal� Distrib
ormal�Distribu
Normal� Distri
pute� Values�
pages�42Ͳ45)�alues� (given�pror�a�normal�an7)�olve� Review� P6)�9)� and� compaems”�under�ConReview”.�You�wce�of�the�mater
iz�in�OAKS�(avataken�all�at�onon�cannot�excendividual�work
4 (12609)
9
2ͲVideos�
:40)�
ution� (LeftͲ
tion� (RightͲ
bution� (InͲ
given� a�
robabilities)�nd�standard�
Practice� for�
are� answers�ntent.�will�be�rial�covered�
ailable�2:00ce,�you�eed�the�quiz�k!!�
D
Pr
Ch(DAu
Ch(DAu
DSCI 232
rofessor: Dr. G
h.�2�Day2)�ug�25th���
ConProDist(StuSqu
h.�3.�Day3)�ug�27th���
SamDist(SamandPro
Gioconda Ques
ntinuous�bability�tributions�udent�t,�ChiͲuare�and�F)�
mpling�tributions�mple�Mean�d�Sample�portion)�
sada
�
�
�
Chapt
�
CONT(Lectu
12345
�
�
CHAPT¾¾
¾¾
�
HOMEthe�fil1ͲIntroand�u“HomEach�wthat�wHome65Ͳ66COPY�DROP�Chapt
�
CONT(Lectu
1234
�
�
CHAPT¾
¾
¾
HomeComp(formDROP�Chaptto�2�pclose�or�you
ter�2�(pages�39
TENT>Chapter2ures/Tutorials). Unit2_Vide. Unit2_Vide. Unit2_Vide. Unit2_HWS. Unit2_Vide
TER�2¾ Review�and¾ Learn� form
and� probadistribution
¾ Study�Theo¾ Solve� Pract
with�“SolutEWORK�1�(duee�“ExcelTutorioduction�to�Bupload�the�file�iework1”.�Submworksheet�showorksheet.�Theework�2�(due�b).�Complete�in�(with�completBOX�NO�LATER
ter�3�(pages�91
TENT>Chapter3ures/Tutorials). Unit�3ͲVide. Sampling�D. Unit�3ͲVide. Unit2_Vide
TER�3¾ Review�and
“Solved�Exa¾ Study� Theo
MultipleͲCh¾ Solve�Pract
answers� wContent.�
ework�3 (due�bplete�in�OAKS>Qulas,�diagramsBOX�no�later�t
ter�2.Multiple�m�but�it�is�timeit�and�come�bau�will�get�a�0�in
9Ͳ54)
2ͲContinuous�P):�eo6�(18:22)�eo7�(05:22)�eo8�(05:48)�Solution_SummeoSolutionHW2
d�Solve�“Solvedmulas�on�How�tabilities� (givens�in�EXCEL:�t,�Cory�(pages�47Ͳ5tice� Problemstions�to�Book�Pe�by�2pm). Follals_Graphs�(Housiness�Statistiin�Dropbox>Homitting�wrong�ould�have�the�ne�histogram�is�before�2�pm).�S�OAKS>Quizzete�solutions:�foR�THAN�2�PM!!
1Ͳ98)
3ͲSampling�Dis):�eo�1�(15:07)�Distribution�of�Seo�3�(10:16)�eoHW�(07:46)�–
d�Solve�“Solveample�3.4”�(paory� (pages� 91hoice�Questiontice�Problems�with� “Solution
before�2 pm).�SQuizzes>Homes,�etc)�TO�SUBMhan�2�pm!!!�
Choice/Fill�in�te�limited�and�iack,�your�quiz�dn�the�quiz.�Quiz
Probability�Dis
mer2013�(07:42_Fall2013�(14
d�Examples”�(pto�solve� for�vaen� values� ofChiͲSquare�and54)�s� (pages� 70Ͳ82Practice�Probleow�pages�22Ͳ3omework�1)”,�cs>Ch1ͲData�Fomework�ALL.�or�empty�file�rname�of�the�granot�accepted�uSolve�Problemss>Homework2ormulas,�diagra!!��
stributions>Ch
Sample�Mean:
–�after�comple
ed�Examples�3.age�100)�1Ͳ101)� and� Sons�(pages�102Ͳ1(pages�105Ͳ10s� to� Book� Pr
Solve�Problemsework3�SCAN�ITMIT�ONE�SINGL
the�Blanks�Quiit�must�be�takeduration�cannozzes�are�individ
Fall 2014
stributions>Ch2
46)�4:30)�
pages�49Ͳ53)�alues� (given�prf� x)� for� thed�F�(page�58)
2)� and� compaems”�under�Con34�on�the�bookunder�ContentFiles.�Follow�thFile�name�shoresults�in�a�graaph�corresponusing�a�Mac�Cos�2.10.�and�2.12�AND�SCAN�THams,�etc)�UNDE
h3ͲVideos�
�YouTube�(24:0
ting�HW2�
.1Ͳ3.3”� (pages�
olve� Review� P103)�08,�106Ͳ116)�anractice� Proble
s�45�to�56�(pagT�with�compleLE�DOCUMENT
iz�in�OAKS�(avaen�all�at�once,�yot�exceed�the�dual�work!!!�
4 (12609)
10
2ͲVideos�
robabilities)�e� following�
are� answers�ntent.�k.�Download�t>Chapter�e�tutorials�uld�be�de�of�0.�nding�to�Computer!!!�1�(pages�HE�PAPER�ER�
06)�
95Ͳ98)�and��
Practice� for�
nd�compare�ems”� under�
ges�75Ͳ76).�te�solutions�T�TO�
ailable�2�pmyou�cannot�quiz�time�
D
Pr
Ch(DSe
DSCI 232
rofessor: Dr. G
h.�3.�Day4)�ept�1st����
SamDist(SamandPro
Gioconda Ques
mpling�tributions�mple�Mean�d�Sample�portion)�
sada
�
�
Chapt
�
CONT(Lectu
12
�
�
CHAPT¾
¾
¾
HomeOAKS>118�toDropbbe�opknow�close�t
ter�3�(pages�91
TENT>Chapter3ures/Tutorials). Unit�3ͲVide. Sampling�D
�
TER�3¾ Review�and
“Solved�Exa¾ Study� Theo
MultipleͲCh¾ Solve�Pract
answers� wContent.�
ework�4 (due�b>Grades>Quizzo�complete�solbox�no�later�thaened�several�tyour�final�answthe�browser�w
1Ͳ104)
3ͲSampling�Dis):�eo�2�(17:58)�Distribution�of�S
d�Solve�“Solveample�3.4”�(paory� (pages� 91hoice�Questiontice�Problems�with� “Solution
before�2 pm): Szes>�Homeworutions�(formulan�2�pm!!!�Subimes�unless�yowers�are�savedwithout�submitt
stributions>Ch
Sample�Propor
ed�Examples�3.age�100)�1Ͳ101)� and� Sons�(pages�102Ͳ1(pages�105Ͳ10s� to� Book� Pr
Solve�Homework�4.�Use�templas,�diagrams,�bmit�the�quiz�bou�Submit�it,�sod!�Otherwise,�jting�so�you�can
Fall 2014
h3ͲVideos�
rtion:�YouTube
.1Ͳ3.3”� (pages�
olve� Review� P103)�08,�106Ͳ116)�anractice� Proble
ork�4�under�plates�on�pagesetc)�and�uploabefore�2�pm.�Tho�don’t�submitust�save�each�n�go�back�to�it.
4 (12609)
11
e�(8:55)�
95Ͳ98)�and��
Practice� for�
nd�compare�ems”� under�
s�117�and�ad�it�in�he�quiz�can��it�until�you�answer�and�.�
D
Pr
Ch(DSe��
DSCI 232
rofessor: Dr. G
h.�4.�Day5)�ept�3rd��
ConIntePop(Meknopro
Gioconda Ques
nfidence�ervals�for�One�pulation�eans�sigma�own�and�oportions)�
sada
�
Chapt
�
CONT(Lectu
12345
6
7
�
�
CHAPT¾¾
¾
�
HomeOAKS>pagesThe�qsubmisave�ego�bacHome110).�submipm!!!�
�
Chaptpm�tocannotime�(work!
ter�4�(pages�12
TENT>Chapter4ures/Tutorials). Unit4_Vide. Unit4_Vide. Unit4_Vide. YouTube�Vi. YouTube� V
(after�minu. YouTube� V
Known�(firs. YouTube�V
Raw�Data:�YTER�4¾ Solved�Exam¾ Review�how
(pages�130table�using�
¾ Solve�practto�Book�Pra
ework�5 (due�b>Grades>Quizz�119�and�120�iuiz�can�be�opeit�it�until�you�keach�answer�anck�to�it.�ework�5b�(due�SCAN�it��with�cit�ONE�SINGLE�
ter�3.Multiple�o�2�pm�but�it�is�ot�close�it�and�c15�min)�or�you!!�
21Ͳ136)
4ͲConfidence�In):�eo0�(15:10)�eo2�(10:59)��eo3�(18:18)�ideos>ConfideVideos>How� tute�4:11)�(3:43)Videos>How� tst�4�minutes�ofVideos>ConfideYouTube�(8:36
mple�4.2.�(124w�to�obtain�D0Ͳ131;�134Ͳ135�“Pivot�Tables”tice�problems�actice�Problem
before�2 pm): Szes>�Homeworn�the�Dropboxened�several�timknow�your�finand�close�the�br
before�2�pm).�complete�solutFILE�in�dropbo
Choice/Fill�in�ttime�limited�acome�back,�you�will�get�a�0�in
ntervals>Ch4Ͳ
ence�Intervals�fto� Compute�)�o� Compute� Sf�video):�(4:00)�ence� Intervals�6)�
4Ͳ125),�Solved�Eescriptive�Stat5)�and� learn�ho”�(pages�132Ͳ1and� compare
ms”�under�Cont
Solve�Homework�5.�Submit�yox�under�Homewmes�unless�you6/l�answers�arrowser�withou
Solve�Problemtions�(formulasox�called�Home
the�Blanks�Quiand�it�must�be�tur�quiz�duration�the�quiz.�Quiz
Fall 2014
Videos�
for�ProportionsSample� SizeͲ
Sample� Size� M
for�MeanͲSig
Example�4.3.�(1tistics�using�Daow�to�obtain�a33)��answers�withtent.�
ork�5�under�our�complete�wwork�5�before�u�Submit�it,�so�re�saved!�Othet�submitting�so
ms�3.5�to�3.8�(ps,�diagrams,�etework�5b�no�la
iz�in�OAKS�(avataken�all�at�onon�cannot�excezzes�are�individ
4 (12609)
12
s�(4:52)�Proportions�
MeanͲSigma�
ma� Known:�
125Ͳ126)��ata�Analysis�a� frequency�
h� “Solutions�
workings�on�due�date.�don’t�rwise,�just�o�you�can�
pages�109Ͳtc)�and�ater�than�2��
ailable�2:00ce,�you�eed�the�quiz�dual�
D
Pr
Ch(DSe��
DSCI 232
rofessor: Dr. G
h.�4.�Day6)�ept�8th��
ConIntePop(meknorev
Gioconda Ques
nfidence�ervals�for�One�pulation�eans�sigma�notown�and�iew)�
sada
t��
Chapt
�
CONT(Lectu
12
3
�
�
CHAPT¾
¾
¾
�
HOMEOAKS>pagesbeforeit,�so�dOthersubmiHOMEOAKS>pagesbeforeit,�so�dOthersubmi
ter�4�(pages�12
TENT>Chapter4ures/Tutorials). Unit4_Vide. YouTube� V
Known�(11:. YouTube� V
Known�(2)�(
TER�4¾ Review�and
Example�4.¾ Review�how
(pages�130table�using�
¾ Solve�practto�Book�Pra
EWORK�6�(due>Grades>Quizz�153Ͳ155,�(cleae�due�date.�Thdon’t�submit�itrwise,�just�saveitting�so�you�caEWORK�7(due�>Grades>Quizz�157Ͳ158�(cleae�due�date.�Thdon’t�submit�itrwise,�just�saveitting�so�you�ca
21Ͳ136)
4ͲConfidence�In):�eo4�(11:29)�Videos>Confid:41)�Videos>� Confi(5:14) �
d�Solve�“Solved2.�(124Ͳ125),�Sw�to�obtain�D0Ͳ131;�134Ͳ135�“Pivot�Tables”tice�problems�actice�Probleme�before�2 pm)zes>�Homeworarly�numberede�quiz�can�be�ot�until�you�knoe�each�answer�an�go�back�to�ibefore�2�pm):zes>�Homeworarly�numbered)e�quiz�can�be�ot�until�you�knoe�each�answer�an�go�back�to�i
ntervals>Ch4Ͳ
ence� Interval
dence� Interva
d�Example�4.1.Solved�Exampleescriptive�Stat5)�and� learn�ho”�(pages�132Ͳ1and� compare
ms”�under�Cont: Solve�Homewrk�6.�Submit�yod)�in�the�Dropbopened�severaw�your�final�anand�close�the�it.�:�Solve�Homewrk�7.�Submit�yo)�in�the�Dropboopened�severaw�your�final�anand�close�the�it.�
Fall 2014
Videos�
ls� for� MeanͲ
als� for� MeanͲ
”�(pages�122Ͳ1e�4.3.�(125Ͳ126tistics�using�Daow�to�obtain�a33)��answers�withtent.�work�6�under�our�complete�wbox�under�Homal�times�unless�nswers�are�savbrowser�witho
work�7�under�our�complete�wox�under�Homeal�times�unless�nswers�are�savbrowser�witho
4 (12609)
13
ͲSigma� Not�
ͲSigma� Not�
123),�Solved�6)��ata�Analysis�a� frequency�
h� “Solutions�
workings�on�mework�6�you�Submit�
ved!�out�
workings�on�ework�7�you�Submit�
ved!�out�
D
Pr
Ch(DSe��
DSCI 232
rofessor: Dr. G
h.�5.�Day7)�ept�10th��
HypTesPop
Gioconda Ques
pothesis�ting�for�One�pulation��
sada
�
Chapt
�
CONT(Lectu
1234
5
�Addit6
7
�
�
CHAPT¾
¾¾
�
Home150).�submiHOMEOAKS>page�2due�ddon’t�just�sacan�go�Chaptpm�tocannotime�(
ter�5�(pages�15
TENT>Chapter5ures/Tutorials). Unit5_Vide. Unit5_Vide. Unit5_Vide. Unit5_Vide
under�video. Unit5_Vide
tional�suggeste. YouTube�V
(36:22)�. You� Tube�
values�for�N
TER�5¾ Review�and
formulas�on¾ Get�familia¾ Solve� Pract
“Solutions�t
ework�7b (due�SCAN�it��with�cit�ONE�SINGLE�EWORK�8�–CH4>Grades>Quizz205�(clearly�nuate.�The�quiz�csubmit�it�untilave�each�answo�back�to�it.�
ter�4.Multiple�o�2�pm�but�it�is�ot�close�it�and�c15�min).�Quizz
59Ͳ178)
5ͲHypothesis�T):�total�79.43�meo1�(17:16)�eo�1_YouTube�eo4�(17:42)�eo5� (14:18)� �Do�link�eo9�(12:42)�
ed�videos:�ideos>Hypothe
Videos>Excel�Normal�Distrib
d�Solve�“Solvedn�page�178��r�with�Procedutice� Problems�to�Book�Practi
before�2 pm).�complete�solutFILE�in�dropbo4(due�before�2zes>�Homeworumbered)�in�thcan�be�opened��you�know�youer�and�close�th
Choice/Fill�in�ttime�limited�acome�back,�yozes�are�individu
Test�for�One�Pominutes�
(04:43)�
Download�data
esis�Test�with�
Functions� to�ution�(7:41)�
d�Example”�(pa
ure�on�page�161,� 3,� 4,� 5� ance�Problems”�u
Solve�Problemtions�(formulasox�file�named�H2��pm):�Solve�Hrk�8.�Submit�yoe�Dropbox�und�several�times�ur�final�answerhe�browser�wit
the�Blanks�Quiand�it�must�be�tur�quiz�duratioual�work!!!�
Fall 2014
opulation>Ch5
a� to� follow� alo
Critical�Value�a
Compute� Val
ages�171Ͳ174)
67.�d� compare� anunder�Content
ms�12�and�13 (ps,�diagrams,�etHomework�7bHomework�8�unour�complete�wder�Homeworkunless�you�Subrs�are�saved!�Othout�submitti
iz�in�OAKS�(avataken�all�at�onon�cannot�exce
4 (12609)
14
5ͲVideos�
ong.�Data� is�
and�pͲvalue�
ues� and� pͲ
and�review�
nswers�with�t.�
pages�149Ͳtc)�and�
nder�workings�on�k�8�before�bmit�it,�so�Otherwise,�ng�so�you�
ailable�2:00ce,�you�eed�the�quiz�
D
Pr
Ch(DSe��
DSCI 232
rofessor: Dr. G
h.�5.�Day8)�ept�15th��
IntrHypTesPop
Gioconda Ques
roduction�to�pothesis�ting�for�One�pulation��
sada
�
Chapt
�
CONT(Lectu
1234
Additi5
6
�
�
CHAPT¾
¾¾
�
HOMEOAKS>pagesHomeunlessare�sawithoHOMEOAKS>(pagesetc)�aHome�
ter�5�(pages�15
TENT>Chapter5ures/Tutorials). Unit5_Vide. Unit5_Vide. Unit5_Vide. Unit5_Vide
ional�suggested. YouTube� V
(38:41)�. Unit5_Vide
TER�5¾ Review�and
formulas�on¾ Get�familia¾ Solve� Pract
“Solutions�t
EWORK�9 (due>Grades>Quizz�204,�206�and�ework�9�befores�you�Submit�itaved!�Otherwisut�submitting�EWORK�9b�(du>Grades>Quizzs�181Ͳ182).�SCAnd�submit�ONEework�9b�
59Ͳ178)
5ͲHypothesis�T):�total�79.43�meo2�(09:22)�eo6�(09:41)�eo8�(09:28)�eo10�(08:45)�
d�videos:�Videos>Confid
eo�2_YouTube�
d�Solve�“Solvedn�page�178��r�with�Procedutice� Problems�to�Book�Practi
e�before�2 pm)zes>�Homewor208�(clearly�nue�due�date.�Thet,�so�don’t�submse,�just�save�easo�you�can�go�ue�before�2�pmzes>�HomeworAN�it��with�comE�SINGLE�FILE�i
Test�for�One�Pominutes�
ence� Interval
(08:21)�
d�Example”�(pa
ure�on�page�161,� 3,� 4,� 5� ance�Problems”�u
: Solve�Homewrk�9.�Submit�youmbered)�in�the�quiz�can�be�omit�it�until�youach�answer�andback�to�it.�
m):�Solve�Homerk�9b.�Completmplete�solutionin�dropbox�wit
Fall 2014
opulation>Ch5
s� and� Hypot
ages�171Ͳ174)
67.�d� compare� anunder�Content
work�9�under�our�complete�whe�Dropbox�unopened�severalu�know�your�find�close�the�bro
ework�9b�undete�Problems�5.ns�(formulas,�dth�the�file�name
4 (12609)
15
5ͲVideos�
hesis� Tests�
and�review�
nswers�with�t.�
workings�on�der�l�times�nal�answers�owser�
r�2�and�5.3�diagrams,�ed�
D
Pr
Ch(DSe��
Ch(DSe��
DSCI 232
rofessor: Dr. G
h.�5.�Day9)�ept�17th��
HypTesPop
h.�6.�Day10)�ept�22nd��
ExaWhTimWhBooprapro�
PRTE
Gioconda Ques
pothesis�ting�for�One�pulation�
am�1�here?�ECTR109�me?�3:30Ͳ5PM�hat�to�Bring?�ok�with�ctice�oblems�solved�
ROCTOREDST!!!!!�
sada
�
D�
Chapt
�
CONT(Lectu
123
Additi1
2
�
�
CHAPT¾
¾¾
�
HOMEOAKS>on�pagbeforeit,�so�dOthersubmiHOMEOAKS>on�paghypotHomeunlessare�sawithoChaptpm�tocannotime�(
�
Exam�REMENO�M�****Lit�musappoitest.�
ter�5�(pages�15
TENT>Chapter5ures/Tutorials). Unit5_Vide. Unit5_Vide. Unit5_Vide
ional�suggested. Hypothesis
Quesada�(1. You� Tube�
values�for�N
TER�5¾ Review�and
formulas�on¾ Get�familia¾ Solve� Prac
answers� wContent.�
EWORK�10 (du>Grades>Quizzge�210�(clearlye�due�date.�Thdon’t�submit�itrwise,�just�saveitting�so�you�caEWORK�11�(du>Grades>Quizzges�212�and�21thesis�test�temework�11�befors�you�Submit�itaved!�Otherwisut�submitting�ter5.Multiple�Co�2�pm�but�it�is�ot�close�it�and�c15�min).�Quizz
1Ͳ Chapters�1ͲMBER!!!�OAKSAKEUPS�
Location�can�best�be�approvedntment�on�we
59Ͳ178)
5ͲHypothesis�T):�total�55.42�meo3�(12:21)�eo7�(10:14)�eo11�(06:34)�
d�videos:�s� Test� for� 1�13:44)�Videos>Excel�Normal�Distrib
d�Solve�“Solvedn�page�178�(onr�with�Proceductice� Problem�with� “Solution
ue�before�2 pmzes>�Homewory�numbered)�ine�quiz�can�be�ot�until�you�knoe�each�answer�an�go�back�to�iue�before�2�pmzes>�Homewor14Ͳmake�2�extrplates!!!�(clearre�due�date.�Tht,�so�don’t�submse,�just�save�easo�you�can�go�Choice/Fill�in�ttime�limited�acome�back,�yozes�are�individu
Ͳ5S�is�empty�afte
e�changed�to�ad�by�the�instrucek�1�to�make�s
Test�for�One�Pominutes�
Population� P
Functions� to�ution�(7:41)�
d�Example”�(panly�for�Proporture�on�page�16� 5.1.� (pages�s� to� Book� Pr
m): Solve�Homerk�10.�.�Submitn�the�Dropbox�opened�severaw�your�final�anand�close�the�it.�m):�Solve�Homerk�11.��Submit�ra�copies,�sincerly�numbered)he�quiz�can�be�mit�it�until�youach�answer�andback�to�it.�the�Blanks�Quizand�it�must�be�tur�quiz�duratioual�work!!!�
r�11�am!!�Plan
a�proctoring�cector�on�week�1sure�you�will�be
Fall 2014
opulation>Ch5
Proportion� Rig
Compute� Val
ages�168Ͳ170)tions).�67.�179Ͳ180)� an
ractice� Proble
ework�10�undet�your�completunder�Homewal�times�unless�nswers�are�savbrowser�witho
ework�11�undeyour�completee�you�require�4�in�the�Dropboopened�severau�know�your�find�close�the�bro
z�in�OAKS�(avaitaken�all�at�onon�cannot�exce
�ahead!�
nter,�but�reme1�and�you�muste�there�at�the�
4 (12609)
16
5ͲVideos�
ght� TailͲDr.�
ues� and� pͲ
and�review�
d� compare�ems”� under�
r�e�workings�
work�10�you�Submit�
ved!�out�
r�e�workings�4�ox�under�al�times�nal�answers�owser�
ilable�2:00ce,�you�eed�the�quiz�
ember�that�t�make�the�time�of�the�
D
Pr
Ch(D12Seto29
Ch(DO
DSCI 232
rofessor: Dr. G
h.�6.�Days�11Ͳ2)�ept�24th�o�Sept�9th��
HypTesPop
h.�6.�Day�13)�ct�1st��
HypTesPop
Gioconda Ques
pothesis�ting�for�Two�pulations�
pothesis�ting�for�Two�pulations��
sada
�
�
Chapt
�
CONT(Lectu
123456
�
�
CHAPT¾ Rev
215¾ Rev
ho¾ Ge¾ Ru
varfortheondat
�
HOMEOAKS>P1ͲP2
howeDEPEINTERChapt
�
CONT(Lectu
123456
�
�
CHAPT¾ Rev238
¾ Ge¾ Stu¾ Solwit
�
HOMEOAKS>on�pag13�befSubmOthersubmi2pm�
ter�6�(pages�21
TENT>Chapter6ures/Tutorials). Unit6_Vide. Unit6_Vide. Unit6_Vide. Unit6_Vide. Unit6_Vide. Unit6_Vide
TER�6view� and� und5Ͳ223�AND�theview� and� Solvw�to�do�it�in�Exet�familiar�withles:� If�you�havriable�2,�just�mr�the�test�statise�hypothesizede� is�hypothesita�if�the�questiEWORK�12�(du>Grades>Quizzto�indicate�t
ever,�for�homNDENT�sampRNET�EXPLORter�6�(pages�23
TENT>Chapter6ures/Tutorials). Unit6_Vide. Unit6_Vide. Unit6_Vide. Unit6_Vide. Unit6_Vide. Unit6_Vide
TER�6view� and� Solv8)�and�learn�hoet�familiar�withudy�Theory�(palve� Practice� Pth�“Solutions�t
EWORK�13�(du>Grades>Quizzges�288�to�290fore�due�date.�it�it,�so�don’t�srwise,�just�saveitting�so�you�ca
15Ͳ229,�232Ͳ23
6ͲHypothesis�T):�eo1a�(06:48)��eo1b�(10:17)�eo2�(21:41)�eo3�(22:11)�–�deo4�(2)�–�data�reo5�(12:08)�
derstand� how�e�videos.�ve� “Solved� Exaxcel�(pages�242�Procedure�onve�a�D0�=�0,�yomake�sure�you�stic!!!�Now,�if�Dd�higher�value.zed�to�be�highion�indicates�wue�9/29�beforezes>�Homeworthe�hypothesmework�purpoples�problemsRER,�THERE�A30Ͳ238)
6ͲHypothesis�T):�eo6�(06:31)�eo7�(4:14)�eo8�(05:56)�eo9�(08:57)�eo10�(10:00)�eo11�(03:39)�**
ve� “Solved� Exaow�to�do�it�in�E�Procedure�onages�215Ͳ238)roblem� 6.7.� (o�Book�Practic
ue�before�2�pmzes>�Homewor0�(clearly�numb�The�quiz�can�bsubmit�it�until�ye�each�answer�an�go�back�to�i
3)
Test�for�Two�Po
data�required�required�
to� setup� hyp
ample� 6.4.”� (p2Ͳ246).�n�page�229.�ou�can�choose�follow�the�samD0�т�0,�you�mu�If�the�questioher,�go�to�the�which�one�theye�2�pm):�Solve�Hrk�12.��Usuallyes�for�all�meaoses,�please�is.�DUE�BEFORARE�A�LOT�OF�
Test�for�Two�Po
*Must�watch�U
amples� 6.3.,� 6Excel�(pages�24n�page�229.�
pages� 271Ͳ272ce�Problems”�u
m): Solve�Homerk�13.�.�Submitbered)�in�the�Dbe�opened�sevyou�know�yourand�close�the�it.�HOMEWORK
Fall 2014
opulations>Ch
potheses� based
pages� 232Ͳ233
arbitrarily�varme�order�whest�choose�varian�does�not�inddata,�but�dony�think�it�is�highHomework�12�y,�I�don’t�minans�problemsindicate�Pd�foRE�2�pm.�USE�SYMBOLS!!!
opulations>Ch
Unit6_Video10
6.4.� and� 6.5”� (42Ͳ258).�
2)� and� compaunder�Content.
ework�13�undet�your�completDropbox�under�veral�times�unler�final�answersbrowser�withoK�IS�DUE�NO�LA
4 (12609)
17
h6ͲVideos�
d� on� pages�
)� and� learn�
riable�1�and�n�you�solve�able�1�to�be�dicate�which�’t�go�to�the�her.�under�
nd�using�s,�or�E��
h6ͲVideos�
0�FIRST**�
(pages� 230Ͳ
are� answers��
r�e�workings��Homework�ess�you��are�saved!�out�ATER�THAN�
D
Pr
Ch(DtoOO��
DSCI 232
rofessor: Dr. G
h.�6.�Days�14�o�15)�ct�6th�to�ct�8th��
HypTesPop
Gioconda Ques
pothesis�ting�for�Two�pulations��
sada
�
Chapt
�
CONT(Lectu
123456
�
�
CHAPT¾
¾¾¾
¾
�
HOMEOAKS>on�pagHomeunlessare�sawithoLATERHOMEit��witSINGLChaptam�tocannotime.�
ter�6�(pages�21
TENT>Chapter6ures/Tutorials). Unit6_Vide. Unit6_Vide. Unit6_Vide. Unit6_Vide. Unit6_Vide. Unit6_Vide
�
TER�6¾ Review� and
230Ͳ238)�an¾ Get�familia¾ Study�Theo¾ Solve� Prac
answers� wContent.�
¾ Solve� Pracanswers� wContent.�
EWORK�14�(du>Grades>Quizzges�291�and�29ework�14�befors�you�Submit�itaved!�Otherwisut�submitting�R�THAN�2pm�.EWORK�14b�(dh�complete�soLE�FILE�in�dropbter6.Multiple�C�2�pm�but�it�is�ot�close�it�and�cQuizzes�are�ind
15Ͳ259)
6ͲHypothesis�T):�eo12�(10:59)�eo13�(12:00)�eo14�(07:13)�eo15�(10:37)�eo16�(6:34)�eo17�(7:10)�
d� Solve� “Solvend�learn�how�tr�with�Proceduory�(pages�215Ͳctice� Problem�with� “Solution
ctice� Problem�with� “Solution
ue�before�2�pmzes>�Homewor92�(clearly�numre�due�date.�Tht,�so�don’t�submse,�just�save�easo�you�can�go�
due�before�2�pmlutions�(formubox�with�the�fiChoice/Fill�in�ttime�limited�acome�back,�yodividual�work!
Test�for�Two�Po
ed� Examples� 6to�do�it�in�Exceure�on�page�22Ͳ238)�� 6.8.� (pages�s� to� Book� Pr
� 6.1.� (pages�s� to� Book� Pr
m): Solve�Homerk�14.�.�Submitmbered)�in�the�he�quiz�can�be�mit�it�until�youach�answer�andback�to�it.�HOM
m):�Problem�6ulas,�diagrams,�le�named�Homthe�Blanks�Quiznd�it�must�be�tur�quiz�duratio!!�
Fall 2014
opulations>Ch
6.3.,� 6.4.� and�el�(pages�242Ͳ229.�
273Ͳ274)� anractice� Proble
260Ͳ261)� anractice� Proble
ework�14�undet�your�complet�Dropbox�undeopened�severau�know�your�find�close�the�broMEWORK�IS�DU
.4�(pages�265Ͳetc)�and�subm
mework�14b�z�in�OAKS�(avaitaken�all�at�onon�cannot�exce
4 (12609)
18
h6ͲVideos�
6.5”� (pages�258).�
d� compare�ems”� under�
d� compare�ems”� under�
r�e�workings�er�al�times�nal�answers�owser�UE�NO�
266).�SCAN�mit�ONE�
ilable�12:01�ce,�you�eed�the�quiz�
D
Pr
Ch(DtoOto20
DaO
DSCI 232
rofessor: Dr. G
h.�7.�Days�16�o�18)�ct�13th�o�Oct�0th���
ANO
ay�19�ct�22nd��
ExaWhTimWhBooprapro�
PRTE
Gioconda Ques
OVA�
am�2�here?�TCFE�130me?�2Ͳ3:15PM�hat�to�Bring?�ok�with�ctice�oblems�solved�
ROCTOREDST!!!!!�
sada
0�
D�
�
Chapt
�
CONT(Lectu
¾¾¾¾
¾
¾
�
�
CHAPT¾
¾¾
¾
�
HOMEOAKS>on�pagbeforeit,�so�dOthersubmi2�pm.HOMESCAN�ONE�S
�
ChaptEXPEClimiteback,�individ
�
Exam�REMENO�M
ter�7�(pages�31
TENT>CHAPTERures/Tutorials)¾ Introductio¾ Unit7_Vide¾ Unit7_Vide¾ Unit7_Vide
Content>Ch¾ Unit7_Stud
ANOVA>Ch¾ Unit7_Stud
ANOVA>ChTER�7¾ Review�and
and�learn�h¾ Get�familia¾ Study� Theo
MultipleͲCh¾ Solve� rem
compare� aunder�Cont
EWORK�15�(du>Grades>Quizzge�363Ͳ364�(cle�due�date.�Thdon’t�submit�itrwise,�just�saveitting�so�you�ca
EWORK�16�(duit��with�compleSINGLE�FILE�in�dter7.Multiple�CCTED�(availabled�and�it�must�byour�quiz�duradual�work!!!�2Ͳ Chapters�5ͲMBER!!!�OAKSAKEUPS�
11Ͳ326)
R�7ͲAnalysis�of)�on�to�ANOVA:�Yeo1�(15:22)�eo2�(6:22)�eo3� (12:17).h.7ͲANOVA>ChdentVideo1� (h7ͲVideos(LectdentVideo72�h7ͲVideos(Lect
d�Solve�“Solvehow�to�work�thr�with�Proceduory� (pages� 31hoice�Questionmaining� Practianswers�with� “tent.�ue�10/15�beforzes>�Homeworearly�numberee�quiz�can�be�ot�until�you�knoe�each�answer�an�go�back�to�i
ue�10/20�beforete�solutions�(dropbox�with�tChoice/Fill�in�te�June�19th�frombe�taken�all�at�ation�cannot�ex
Ͳ7.�S�is�empty�afte
f�Variance(ANO
YouTube�(4:44
Description�h7ͲVideos(Lect(7:06).� Data�ures/Tutorials(19:13)� Dataures/Tutorials
ed�Examples”� (he�examples�inure�on�page�3111Ͳ326)� and� Sns�(pages�327Ͳ3ice� Problems“Solutions� to�
re�2�pm):�Solverk�15.�.�Submited)�in�the�Dropopened�severaw�your�final�anand�close�the�it.�HOMEWORK
re�2�pm):�Problformulas,�diagthe�file�namedthe�Blanks�Quizm�12:01�am�toonce,�you�canxceed�the�quiz
r�11�am!!�Plan
Fall 2014
OVA)>Ch7ͲVid
)�
of� Probletures/Tutorials
is� in� Con)�a� is� in� Con)�
(pages�315Ͳ31�Excel�(pages�314.�olve� Review� P328)�s� (pages� 334Book� Practice
e�Homework�15t�your�completpbox�under�Hoal�times�unless�nswers�are�savbrowser�withoK�IS�DUE�NO�LA
lem�7.15�(pagegrams,�etc)�andd�Homework�16z�in�OAKSͲ CALo�2�pm�but�it�is�not�close�it�anz�time.�Quizzes�
�ahead!�
4 (12609)
19
deos�
em� is� in�s)�ntent>Ch.7Ͳ
ntent>Ch.7Ͳ
6,�318Ͳ326)�332Ͳ333)�
Practice� for�
4Ͳ362)� and�e� Problems”�
5�under�e�workings�mework�15�you�Submit�
ved!�out�ATER�THAN�
es�361Ͳ362).�d�submit�6�LCULATIONS�time�d�come��are�
D
Pr
Ch(DtoOto29
DSCI 232
rofessor: Dr. G
h.�8.�Days�20�o�21)�ct�27th�o�Oct�9th���
GooTesInd
Gioconda Ques
odness�of�Fit�t�and�Test�of�ependence�
sada
�
Chapt
�
CONTVideo
123456
StudeUnit8_Unit8_�
�
�
CHAPT¾¾¾
¾
�
HOMEit��witSINGLHOMESCAN�ONE�S�
ter�8�(pages�36
TENT>CHAPTERos�(Lectures/Tu. Unit8_Vide. Intro�to�Go. Lecture�on�. Unit8_Vide. Unit8_Vide. Unit8_Vide
nt�Videos:�_StudentProbl_StudentProbl
TER�8¾ Review�and¾ Get�familia¾ Study� Theo
MultipleͲCh¾ Solve� rem
compare� aunder�Cont
EWORK�17�(duh�complete�soLE�FILE�in�dropbEWORK�18�(duit��with�compleSINGLE�FILE�in�d
67Ͳ375)
R�8�– Goodnessutorials)�eo1�(10:04)�oodness�of�Fit�ͲTest�of�Indepeeo2�(16:42)�eo3�(13:48)�eo5�(19:30)�
em1�em2�
d�Solve�“Solvedr�with�Proceduory� (pages� 36hoice�Questionmaining� Practianswers�with� “tent.�ue�10/29 beforlutions�(formubox�with�the�fiue�11/5�beforeete�solutions�(dropbox�with�t
s�of�Fit�and�Tes
Ͳ�Youtube�(09:5endence�(10:00
d�Examples”�(pure�on�page�3667Ͳ375)� and� Sns�(pages�376Ͳ3ice� Problems“Solutions� to�
re�2�pm):�Problulas,�diagrams,�le�named�Home�2�pm):�Probleformulas,�diagthe�file�named
Fall 2014
st�of�Independ
52)�0)�
pages�369Ͳ375)68.�olve� Review� P377)�s� (pages� 379Book� Practice
lem�8.1�(page�3etc)�and�subm
mework�17.�em�8.7�(page�39grams,�etc)�andd�Homework�18
4 (12609)
20
dence>Ch8Ͳ
)�
Practice� for�
9Ͳ408)� and�e� Problems”�
379).�SCAN�mit�ONE�
91Ͳ392).�d�submit�8.�
D
Pr
Ch(DtoNto17
(DtoNto1s
De
��
DSCI 232
rofessor: Dr. G
h.�9.�Days�22�o�25)�ov�5th�o�Nov�7th���
Reg
Days�26�o�28)�ov.�19th�o�Dec.�st��
REV
ec�6th�� FinWhTimWhBooprapro�
PRTE�
Gioconda Ques
gression�
VIEW�
nal�Exam�here?�TCFE�130me?�12Ͳ3�PM�hat�to�Bring?�ok�with�ctice�oblems�solved�
ROCTOREDST!!!!!�
sada
0�
D�
�
�
Chapt
�
CONT123456789
�
�
CHAPT¾¾¾
¾
�
ChaptCALCUlimiteback,�individ
�
HOMEOAKS>on�a�bbeforeit,�so�dOthersubmi2�pm�
�
Online
�
ChaptCALCUbut�it�and�coare�in
�
ChaptNo�MaClosed
ter�9 (pages�41
TENT>CHAPTER. Introductio. Introductio. More�than�. Learn�manu. Simple�Reg. Simple�Reg. Multiple�Re. Multiple�Re. Simple�Reg
TER�9¾ Review�and¾ Get�familia¾ Study� Theo
MultipleͲCh¾ Solve� rem
compare� aunder�Cont
ter8. Nov.�17th.ULATIONS�EXPEd�and�it�must�byour�quiz�duradual�work!!!�EWORK�19�(du>Grades>Quizzblank�page�(clee�due�date.�Thdon’t�submit�itrwise,�just�saveitting�so�you�ca
e�Synchronous
ter9. Nov.�19th
ULATIONS�EXPEis�time�limitedome�back,�youdividual�work!ters�1�to�9.ake�Ups.�d�books/notes/
11Ͳ436)
R�9�– Regressioon�to�Simple�Reon�to�Regressioan�Introductioual�computatiogression�Problegression�Probleegression�Part�egression�Part�gression�Examp
d�Solve�“Solvedr�with�Proceduory� (pages� 41hoice�Questionmaining� Practianswers�with� “tent.�.�Multiple�ChoECTED�(availabbe�taken�all�at�ation�cannot�ex
ue�11/12 beforzes>�Homeworearly�numberede�quiz�can�be�ot�until�you�knoe�each�answer�an�go�back�to�i
s�Class�
.�Multiple�ChoECTED�(availabd�and�it�must�bur�quiz�duration!!�
/videos.��
on>Ch9ͲVideosegression�(5:18on�(5:15)�on�to�Regressioons�behind�Regem�Part�I�(21:22em�Part�II�(05:2I�(La�Quinta�InII�(28:53)�ple2�(14:18)�
d�Examples”�(pure�on�page�4111Ͳ427)� and� Sns�(pages�437Ͳ4ice� Problems“Solutions� to�
ice/Fill�in�the�Bble�12:01�am�toonce,�you�canxceed�the�quiz
re�2�pm):�Solverk�19.�.�Submitd)�in�the�Dropbopened�severaw�your�final�anand�close�the�it.�HOMEWORK
oice/Fill�in�the�ble�on�6/30th�frbe�taken�all�at�on�cannot�excee
Fall 2014
s�(Lectures/Tut8)�
on�(27:40)�gression�(08:292)�26)�n)�(26:23)�
pages�428Ͳ436)14.�olve� Review� P438)�s� (pages� 440Book� Practice
Blanks�Quiz�in�Oo�2�pm�but�it�isnot�close�it�anz�time.�Quizzes�
e�Homework�19t�your�completbox�under�Homal�times�unless�nswers�are�savbrowser�withoK�IS�DUE�NO�LA
Blanks�Quiz�in�rom�12:01�am�once,�you�canned�the�quiz�tim
4 (12609)
21
torials)
9)�
)�
Practice� for�
0Ͳ484)� and�e� Problems”�
OAKSͲs�time�d�come��are�
9�under�e�workings�mework�19�you�Submit�
ved!�out�ATER�THAN�
OAKSͲto�2�pm�not�close�it�me.�Quizzes�
D
Pr
�
DSCI 232
rofessor: Dr. G
OAKS�WILL�
Gioconda Ques
BE�DISABLED
sada
D�4.5�Hours�be�
DUR
efore�Exam�st
RING�EXAMS�
tarts!�(please�ignore�any�vvideos�that�sh
Fall 2014
how�a�differen
4 (12609)
22
�nt�time)�
D
Pr
DSCI 232
rofessor: Dr. GGioconda Quessada
Fall 20144 (12609)
23�
D
Pr
DSCI 232
rofessor: Dr. GGioconda Quessada
Fall 20144 (12609)
24