Hi! I desperately need some help with some statistics homework as I am having major difficulty grasping the concepts this week. Attached is the homework assignment along with the "Plan Email" that is the information we are supposed to refer to.

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. Employee's Proposal Item to Review What did the Your Assessment (Is Modifications (What employee plan to this plan correct and changes might you make to the plan?) do?) appropriate?] 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 t- test Determining statistical significance Inferences that will be made from dataPlan Review Email From: 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 two- tailed (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 inter 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