Reference no: EM132509112
In this assignment, you will have the opportunity to review concepts from your previous coursework in statistics. Two highly relevant concepts that carry over from fundamental to more intermediate statistics courses include an understanding of probability and the mechanics of running statistical tests using commonly used software.
Two types of software used in business and research are Microsoft Excel and the Statistical Package for the Social Sciences (SPSS). There are many other tools available, but the former is highly common at home and work, and the latter is the tool of choice for quantitative analysis in graduate programs. In this assignment, you will be asked to run an analysis in Excel and replicate it in SPSS.
This assignment contains two datasets, one in an Excel file and the other in an SPSS data file. The dataset contains three variables: age measured in years, engagement (average score of a survey on a five-point Likert scale), and extroversion (average score of a survey on a five-point Likert scale). The higher the Likert scale numbers, the more engaged and/or extroverted the person is. Once you have completed your analysis, please upload your manuscript with narrative explanations of the findings, the Excel file containing the results of your analysis, and the SPSS output file also providing the results of your analysis.
In this assignment, please calculate the following in both Excel and SPSS:
Calculate descriptive statistics for each of the three variables:
Mean, median, mode, standard deviation and interpret them in narrative form.
Pearson Product Moment Correlations between all three variables. Interpret these findings.