MATH 534 Week 2 Course Project, Part A - Exploratory Data Analysis

Introduction Yourinstructorwillprovideyouwithadatafilethatincludesdataonfivevariables: SALESrepresentsthe numbersales madethisweek.CALLSrepresentsthenumberofsalescallsmadethisweek.TIME represents the average timeper callthisweek. YEARSrepresentsyearsofexperienceinthecallcenter. TYPErepresentsthetypeoftrainingtheemployeereceived. PartA:ExploratoryDataAnalysis Preparation • Openthefilesforthe CourseProjectandthedataset. • For each of the five variables, process, organize, present, and summarize thedata.Analyzeeachvariablebyitselfusinggraphicalandnumericaltechniquesof summarization. Use Excel as much as possible, explaining what the results reveal.Some of the following graphs may be helpful: stem-leaf diagram, frequency/relativefrequency table, histogram, boxplot, dotplot, pie chart, and bar graph. Caution: notall of these are appropriate for each of these variables, nor are they all necessary.Moreisnotnecessarilybetter.Inaddition,besuretofindtheappropriatemeasuresofcentraltendency,themeasuresofdispersion,andtheshapesofthedistributions(for the quantitative variables) for the above data. Where appropriate, use the fivenumber summary (the Min, Q1, Median, Q3, Max). Once again, use Excel asappropriate,andexplainwhattheresultsmean. • Analyze the connections or relationships between the variables. There are 10possiblepairingsoftwovariables.Usegraphicalaswellasnumericalsummary measures.Explaintheresultsoftheanalysis.Be suretoconsiderall10pairings.Somevariables showclear relationships,whereasothersdonot. ReportRequirements • Fromthevariableanalysisabove,providetheanalysisandinterpretationfor threeindividualvariables.Thiswouldincludenomorethanonegraphforeach, oneortwomeasuresofcentraltendencyandvariability(asappropriate),theshapesof the distributions for quantitative variables, and two or three sentences ofinterpretation. • For the 10 pairings, identify and report only on three of the pairings, again usinggraphicalandnumericalsummary(asappropriate),withinterpretations.Pleasenotethatat leastonepairingmustincludeaqualitativevariable,andatleast onepairingmustnot includeaqualitativevariable. • Prepare the report in Microsoft Word, integrating graphs and tables with textexplanationsandinterpretations.Besuretoincludegraphicalandnumerical backupfortheexplanationsandinterpretations.Beselectiveinwhatisincludedinthereportto meettherequirementsofthereportwithoutextraneousinformation. • AllDeVryUniversitypoliciesareineffect,includingtheplagiarismpolicy. • ProjectPartAreportis duebytheendofWeek2. • ProjectPartAisworth100totalpoints.Seethegradingrubricbelow. Submission:Thereport,includingallrelevantgraphsandnumericalanalysisalong withinterpretations Formatforreport: A. BriefIntroduction B. Discussthefirstindividualvariable,usinggraphical,numericalsummaryandinterpretation. C. Discussthesecondindividualvariable,usinggraphical,numericalsummaryandinterpretation. D. Discussthethirdindividualvariable,usinggraphical,numericalsummaryandinterpretation. E. Discussthefirstpairingofvariables,usinggraphical,numericalsummaryandinterpretation. F. Discussthesecondpairingofvariables,usinggraphical,numericalsummaryandinterpretation. G. Discussthethirdpairingofvariables,usinggraphical,numericalsummaryandinterpretation. H. ConclusionSubmityourassignment. PartA:GradingRubric Category Points % Description Threeindividualvariables—12pointseach 36 36 Graphical analysis, numericalanalysis (when appropriate), andinterpretation Threerelationships—15pointseach 45 45 Graphical analysis, numericalanalysis (when appropriate), andinterpretation Communicationskills 19 19 Writing,grammar,clarity,logic,cohesiveness, adherence to theabove format Total 100 100 A quality paper will meet orexceedallof the above Category Points % Description requirements.