The specific questions I need help with are part of statistics homework. My progress so far is in an excel spreadsheet. The source data is labeled "case data", and the different responses are in different worksheets.
Here are the questions:
Produce a histogram for each data set. (DONE)
Which indicator of central tendency would you use to describe each data set? Why? (NEED HELP)
Use a hypothesis test to determine whether statistically significant improvement has occurred between the two tests. (NEED HELP)
The CEO would like the mean score for all employees to be no more than ten percentage points lower than the mean score of the strategy-formulation group.
Given the CEO's goals, should we conduct further training? (NEED HELP)
Thanks in advance! The "backstory" for the data follows...
The executives of Mega-Corp decided that they needed to communicate their corporate strategy to each of their employees. Surveys were distributed to a sample of employees in order to assess their understanding of the corporate strategy. Their responses were graded based upon the CEO's answers. The respondents were subsequently apprised of the organization's strategy through various modes of communication. The same respondents were subsequently retested.
See attachments which summarize the survey results before and after the strategy communication (results are in random order, and not paired). We have also included the results of administering the same survey to the members of the strategy-formulation group. The CEO would like the mean score for all employees to be no more than ten percentage points lower than the mean score of the strategy-formulation group.