Employee Proposal Plan Review Worksheet

Plan Review EmailFrom: Previous Employee
Sent: September 30, 2021 9:41 AM
To: New Employee
Subject: Plan for Analysis of Desirability Survey
Hi New Employee,
I didn’t get a chance to meet you before I left my position, but I wanted to leave you some of my ideas for
analyzing the results of the desirability survey. I’m not really sure if they will be helpful. Actually, it might
be a good idea to check for errors since statistics were never one of my strengths. Nevertheless, I think
this plan can save you some time and use the information to support the organization!
For what it is worth, here is my proposal for data analysis:
The purpose of the analysis will be to understand the desirability of professional development amongst
staff members and if there are differences in desirability between managers and employees.
To investigate this, first I will use a chart to visually represent the data. I think using a pie chart will help
me see the data the best because I can see, visually, if anything looks different between the two groups.
After visually inspecting the data on my pie chart, I will compute the mean, median, mode, and standard
deviation of the manager and employee groups’ responses. I will compare these values and determine if I
need to run a t-test to see if there are differences between the groups.
Frankly, I can’t really remember what differences the t-test will test for. But I think it is differences in the
standard deviations. I get a little confused about if I should be choosing a one-tailed (directional) or twotailed (non-directional) t-test. Since I’m not really sure which group might be higher or lower than the
other, I think I will choose a non-directional test. I will conduct the t-test using Microsoft Excel.
After running the t-test, I need to decide if the results are statistically significant. To do this, I will look for
the p value associated with the t-test to determine if the differences between the two groups are able to
be inferred to the population (I am considering the rest of the employees and managers at the
organization who didn’t take the test to be that population). If the p value is less than 0.08, I will be able to
infer the results to the population (I will be testing at an alpha of 0.05). From this information, I will be able
to tell our supervisors a few things: (1) If people even find professional development desirable and (2) if
employees and managers see professional development as the same desirability.
I hope this is useful. I apologize that I couldn’t get further along in the analysis before leaving the
company!
Regards,
Previous Employee
Plan Review Worksheet
Based on the former employee’s e-mail showing their attempt at analyzing the results of the desirability
survey, complete the table below in complete sentences and according to the following guidelines:
•
Column 1 provides the review item for each component of the employee’s plan.
•
In Column 2, write a 25- to 50-word explanation of the employee’s plan for each component.
•
In Column 3, write a 25- to 50-word explanation of whether you think this is the correct plan for
each component. Explain your rationale.
•
In Column 4, write a 25- to 50-word description of any modifications you might make to each
component of the plan, if applicable. Explain your rationale.
Item to Review
Purpose of analysis
Creating a chart (visual
representation)
Examining descriptive
statistics (central
tendency and variance)
Understanding what
quantitates a t-test
examines
Choosing the type of ttest
Determining statistical
significance
Inferences that will be
made from data
Employee’s Proposal
(What did the
employee plan to
do?)
Your Assessment (Is
this plan correct and
appropriate?)
Modifications (What
changes might you
make to the plan?)