Open the files for the Course Project and the data set.
For each of the five variables, process, organize, present, andsummarize the data. Analyze each variable by itself using graphicaland numerical techniques of summarization. Use Excel as much aspossible, explaining what the results reveal. Some of the followinggraphs may be helpful: stem-leaf diagram, frequency/relativefrequency table, histogram, boxplot, dotplot, pie chart, and bargraph. Caution: not all of these are appropriate for each of thesevariables, nor are they all necessary. More is not necessarilybetter. In addition, be sure to find the appropriate measures ofcentral tendency, the measures of dispersion, and the shapes of thedistributions (for the quantitative variables) for the above data.Where appropriate, use the five number summary (the Min, Q1,Median, Q3, Max). Once again, use Excel as appropriate, and explainwhat the results mean. Analyze the connections or relationshipsbetween the variables. There are 10 possible pairings of twovariables. Use graphical as well as numerical summary measures.Explain the results of the analysis. Be sure to consider all 10pairings. Some variables show clear relationships, whereas othersdo not. Report Requirements From the variable analysis above,provide the analysis and interpretation for three individualvariables. This would include no more than one graph for each, oneor two measures of central tendency and variability (asappropriate), the shapes of the distributions for quantitativevariables, and two or three sentences of interpretation. For the 10pairings, identify and report only on three of the pairings, againusing graphical and numerical summary (as appropriate), withinterpretations. Please note that at least one pairing must includea qualitative variable, and at least one pairing must not include aqualitative variable. Prepare the report in Microsoft Word,integrating graphs and tables with text explanations andinterpretations. Be sure to include graphical and numerical back upfor the explanations and interpretations. Be selective in what isincluded in the report to meet the requirements of the reportwithout extraneous information. All DeVry University policies arein effect, including the plagiarism policy. Project Part A reportis due by the end of Week 2. Project Part A is worth 100 totalpoints. See the grading rubric below. Submission: The report,including all relevant graphs and numerical analysis along withinterpretations Format for report: Brief Introduction Discuss thefirst individual variable, using graphical, numerical summary andinterpretation. Discuss the second individual variable, usinggraphical, numerical summary and interpretation. Discuss the thirdindividual variable, using graphical, numerical summary andinterpretation. Discuss the first pairing of variables, usinggraphical, numerical summary and interpretation. Discuss the secondpairing of variables, using graphical, numerical summary andinterpretation. Discuss the third pairing of variables, usinggraphical, numerical summary and interpretation. Conclusion
| Sales (Y) | Calls (X1) | Time (X2) | Years (X3) | Type |
| 48 | 168 | 12.3 | 5 | ONLINE |
| 36 | 131 | 16.4 | 4 | NONE |
| 46 | 162 | 15.7 | 3 | NONE |
| 47 | 183 | 13.0 | 3 | ONLINE |
| 44 | 177 | 15.3 | 3 | ONLINE |
| 49 | 181 | 12.4 | 2 | ONLINE |
| 35 | 123 | 19.0 | 3 | NONE |
| 46 | 169 | 14.8 | 3 | GROUP |
| 44 | 158 | 13.9 | 1 | GROUP |
| 39 | 146 | 15.4 | 3 | GROUP |
| 48 | 178 | 12.6 | 4 | ONLINE |
| 42 | 142 | 17.0 | 0 | ONLINE |
| 45 | 137 | 13.0 | 2 | ONLINE |
| 54 | 195 | 15.2 | 2 | ONLINE |
| 43 | 146 | 16.4 | 0 | ONLINE |
| 44 | 165 | 17.4 | 3 | ONLINE |
| 34 | 121 | 13.2 | 2 | NONE |
| 44 | 146 | 16.5 | 1 | NONE |
| 40 | 132 | 18.2 | 1 | NONE |
| 51 | 182 | 17.9 | 2 | ONLINE |
| 41 | 151 | 18.0 | 1 | NONE |
| 45 | 146 | 15.6 | 3 | ONLINE |
| 52 | 190 | 13.2 | 3 | ONLINE |
| 39 | 150 | 19.4 | 0 | GROUP |
| 41 | 149 | 13.2 | 3 | GROUP |
| 45 | 167 | 14.5 | 4 | GROUP |
| 46 | 189 | 20.0 | 1 | GROUP |
| 47 | 162 | 16.4 | 3 | ONLINE |
| 42 | 147 | 13.2 | 3 | GROUP |
| 45 | 171 | 19.4 | 2 | ONLINE |
| 44 | 165 | 15.0 | 0 | ONLINE |
| 50 | 175 | 15.1 | 3 | ONLINE |
| 46 | 161 | 13.2 | 3 | GROUP |
| 53 | 188 | 11.0 | 2 | ONLINE |
| 39 | 136 | 17.3 | 0 | NONE |
| 39 | 135 | 17.7 | 1 | ONLINE |
| 48 | 168 | 15.9 | 5 | ONLINE |
| 46 | 167 | 10.1 | 0 | ONLINE |
| 43 | 150 | 17.4 | 3 | GROUP |
| 44 | 151 | 15.2 | 2 | GROUP |
| 42 | 141 | 12.2 | 3 | NONE |
| 39 | 131 | 19.4 | 2 | NONE |
| 49 | 174 | 18.3 | 0 | ONLINE |
| 41 | 154 | 14.5 | 4 | NONE |
| 42 | 131 | 20.2 | 3 | GROUP |
| 39 | 128 | 15.3 | 1 | GROUP |
| 37 | 126 | 13.4 | 4 | NONE |
| 46 | 180 | 15.1 | 4 | NONE |
| 45 | 166 | 19.5 | 5 | NONE |
| 44 | 152 | 16.0 | 2 | ONLINE |
| 50 | 179 | 12.8 | 3 | ONLINE |
| 39 | 140 | 18.2 | 1 | NONE |
| 43 | 154 | 15.3 | 1 | ONLINE |
| 45 | 164 | 17.2 | 3 | ONLINE |
| 42 | 139 | 18.6 | 2 | NONE |
| 44 | 165 | 19.2 | 2 | NONE |
| 45 | 172 | 12.6 | 3 | GROUP |
| 41 | 147 | 18.5 | 3 | GROUP |
| 43 | 152 | 17.2 | 1 | GROUP |
| 48 | 160 | 15.8 | 2 | ONLINE |
| 42 | 159 | 13.6 | 4 | GROUP |
| 46 | 186 | 14.1 | 3 | GROUP |
| 46 | 150 | 20.7 | 2 | GROUP |
| 43 | 155 | 11.2 | 3 | ONLINE |
| 45 | 157 | 16.3 | 4 | ONLINE |
| 48 | 170 | 12.1 | 1 | ONLINE |
| 45 | 175 | 18.3 | 2 | GROUP |
| 49 | 186 | 17.5 | 1 | GROUP |
| 51 | 181 | 11.4 | 4 | GROUP |
| 47 | 171 | 17.3 | 2 | ONLINE |
| 50 | 185 | 16.4 | 0 | ONLINE |
| 39 | 146 | 15.8 | 1 | GROUP |
| 42 | 156 | 18.6 | 2 | GROUP |
| 46 | 157 | 19.3 | 2 | ONLINE |
| 43 | 163 | 11.7 | 1 | GROUP |
| 54 | 175 | 14.2 | 1 | ONLINE |
| 51 | 175 | 12.0 | 2 | ONLINE |
| 50 | 173 | 13.3 | 1 | ONLINE |
| 41 | 140 | 14.9 | 3 | NONE |
| 43 | 156 | 20.5 | 2 | ONLINE |
| 40 | 146 | 18.2 | 2 | NONE |
| 42 | 148 | 10.5 | 2 | GROUP |
| 50 | 183 | 11.7 | 1 | GROUP |
| 49 | 191 | 13.1 | 2 | GROUP |
| 40 | 149 | 14.2 | 4 | ONLINE |
| 40 | 143 | 18.3 | 2 | NONE |
| 47 | 185 | 15.2 | 2 | ONLINE |
| 41 | 136 | 17.4 | 3 | GROUP |
| 51 | 198 | 13.0 | 1 | ONLINE |
| 43 | 153 | 13.2 | 3 | GROUP |
| 38 | 129 | 15.2 | 3 | NONE |
| 44 | 158 | 11.8 | 3 | ONLINE |
| 43 | 149 | 12.7 | 1 | GROUP |
| 47 | 175 | 13.9 | 2 | GROUP |
| 40 | 154 | 16.4 | 3 | GROUP |
| 43 | 151 | 14.3 | 1 | GROUP |
| 46 | 153 | 22.0 | 0 | ONLINE |
| 46 | 167 | 14.8 | 1 | ONLINE |
| 46 | 167 | 15.8 | 0 | ONLINE |
| 39 | 143 | 17.7 | 3 | NONE |
| | | | |
