I need help to understand how to do this if someone can please help me. Part A: Exploratory Data Analysis Preparation Op

[answerhappygod]

I need help to understand how to do this if someone can pleasehelp me. Part A: Exploratory Data Analysis Preparation Open thefiles for the course project and the data set. For each of the fivevariables, process, organize, present and summarize the data.Analyze each variable by itself using graphical and numericaltechniques of summarization. Use Excel as much as possible,explaining what the results reveal. Some of the following graphsmay be helpful: stem-leaf diagram, frequency/relative frequencytable, histogram, boxplot, dotplot, pie chart, bar graph. Caution:not all of these are appropriate for each of these variables, norare they all necessary. More is not necessarily better. In additionbe sure to find the appropriate measures of central tendency, themeasures of dispersion, and the shapes of the distributions (forthe quantitative variables) for the above data. Where appropriate,use the five number summary (the Min, Q1, Median, Q3, Max). Onceagain, use Excel as appropriate, and explain what the results mean.Analyze the connections or relationships between the variables.There are ten possible pairings of two variables. Use graphical aswell as numerical summary measures. Explain the results of theanalysis. Be sure to consider all 10 pairings. Some variables showclear relationships, while others do not. Report Requirements Fromthe variable analysis above, provide the analysis andinterpretation for three individual variables. This would includeno more than 1 graph for each, one or two measures of centraltendency and variability (as appropriate), the shapes of thedistributions for quantitative variables, and two or threesentences of interpretation. For the 10 pairings, identify andreport only on three of the pairings, again using graphical andnumerical summary (as appropriate), with interpretations. Pleasenote that at least one pairing must include a qualitative variableand at least one pairing must not include a qualitative variable.Prepare the report in Microsoft Word, integrating graphs and tableswith text explanations and interpretations. Be sure to includegraphical and numerical back up for the explanations andinterpretations. Be selective in what is included in the report tomeet the requirements of the report without extraneous information.Project Part A report is due by the end of Week 2. Project Part Ais worth 100 total points. See grading rubric below. Submission:The report, including all relevant graphs and numerical analysisalong with interpretations Format for report: Brief IntroductionDiscuss 1st individual variable, using graphical, numerical summaryand interpretation Discuss 2nd individual variable, usinggraphical, numerical summary and interpretation Discuss 3rdindividual variable, using graphical, numerical summary andinterpretation Discuss 1st pairing of variables, using graphical,numerical summary and interpretation Discuss 2nd pairing ofvariables, using graphical, numerical summary and interpretationDiscuss 3rd pairing of variables, using graphical, numericalsummary and interpretation Conclusion
Sales (Y) Calls (X1) Time(X2) Years (X3) Type 21 116 19.9 3 NONE 21 116 18.0 2 GROUP 31 118 19.4 4 ONLINE 33 125 16.9 2 ONLINE 32 129 18.5 2 GROUP 29 131 14.6 1 GROUP 33 131 10.0 0 GROUP 42 131 19.4 5 GROUP 40 132 18.5 1 GROUP 33 135 15.3 2 GROUP 33 136 16.9 4 ONLINE 41 136 19.3 3 ONLINE 45 137 15.7 1 GROUP 42 139 12.4 1 GROUP 33 140 17.5 2 GROUP 41 140 13.9 3 NONE 42 141 12.2 3 NONE 42 142 17.0 3 ONLINE 35 143 17.7 3 NONE 40 143 18.3 2 NONE 32 146 15.4 3 GROUP 34 146 15.8 1 GROUP 40 146 18.2 2 NONE 43 146 16.4 0 ONLINE 44 146 16.5 1 NONE 45 146 15.6 3 ONLINE 41 147 18.5 3 GROUP 42 147 13.2 3 GROUP 42 148 10.5 2 GROUP 40 149 14.2 4 ONLINE 41 149 13.2 3 GROUP 43 149 12.7 1 GROUP 32 150 19.4 0 GROUP 43 150 17.4 3 GROUP 46 150 20.7 2 GROUP 41 151 18.0 1 NONE 43 151 14.3 1 GROUP 44 151 15.2 2 GROUP 43 152 17.2 1 GROUP 44 152 16.0 2 ONLINE 43 153 13.2 3 GROUP 46 153 22.0 0 ONLINE 40 154 16.4 3 GROUP 41 154 14.5 4 NONE 43 154 15.3 1 ONLINE 43 155 11.2 3 ONLINE 42 156 18.6 2 GROUP 43 156 20.5 2 ONLINE 45 157 16.3 4 ONLINE 46 157 19.3 2 ONLINE 44 158 13.9 1 GROUP 44 158 11.8 3 ONLINE 42 159 13.6 4 GROUP 48 160 15.8 2 ONLINE 46 161 13.2 3 GROUP 46 162 15.7 3 NONE 47 162 16.4 3 ONLINE 43 163 11.7 1 GROUP 45 164 17.2 3 ONLINE 44 165 17.4 3 ONLINE 44 165 15.0 0 ONLINE 44 165 19.2 2 NONE 45 166 19.5 5 NONE 45 167 14.5 4 GROUP 46 167 10.1 0 ONLINE 46 167 14.8 1 ONLINE 46 167 15.8 0 ONLINE 48 168 12.3 5 ONLINE 48 168 15.9 5 ONLINE 46 169 14.8 3 GROUP 48 170 12.1 1 ONLINE 45 171 19.4 2 ONLINE 47 171 17.3 2 ONLINE 45 172 12.6 3 GROUP 50 173 13.3 1 ONLINE 49 174 18.3 0 ONLINE 45 175 18.3 2 GROUP 47 175 13.9 2 GROUP 50 175 15.1 3 ONLINE 51 175 12.0 2 ONLINE 54 175 14.2 1 ONLINE 44 177 15.3 3 ONLINE 48 178 12.6 4 ONLINE 50 179 12.8 3 ONLINE 46 180 15.1 4 NONE 49 181 12.4 2 ONLINE 51 181 11.4 4 GROUP 51 182 17.9 2 ONLINE 47 183 13.0 3 ONLINE 50 183 11.7 1 GROUP 47 185 15.2 2 ONLINE 50 185 16.4 0 ONLINE 46 186 14.1 3 GROUP 49 186 17.5 1 GROUP 53 188 11.0 2 ONLINE 46 189 20.0 1 GROUP 52 190 13.2 3 ONLINE 49 191 13.1 2 GROUP 54 195 15.2 2 ONLINE 51 198 13.0 1 ONLINE