Assignment Needed In The Next 5 Hours On 31st May, 2018

Assignment Need In The Next 5 Hours On 31st May, 2018 You Manage Human

ASSIGNMENT NEED IN THE NEXT 5 HOURS on 31st MAY, 2018 You manage Human Relations for your company. One of your sales managers has retired, leaving an opening. You are considering two different employees for the position. Both are highly qualified so you have decided to evaluate their sales performance for the past year. Use the Week 4 Data Set to create and calculate the following in Excel®: Determine the range of values in which you would expect to find the average weekly sales for the entire sales force in your company 90% of the time.

Calculate the impact of increasing the confidence level to 95%. Calculate the impact of increasing the sample size to 150, assuming the same mean and standard deviation, but allowing the confidence level to remain at 90%. Based on the calculated confidence interval for weekly sales on a sample of 50 reps at a 90% confidence level: Calculate both Reps' average weekly performance and highlight if it is greater than the population mean.

You want to determine whether there is a statistically different average weekly sales between Sales Rep A and Sales Rep B. Create Null and Alternative Hypothesis statements that would allow you to determine whether their sales performance is statistically different or not. Use a significance level of .05 to conduct a t-test of independent samples to compare the average weekly sales of the two candidates. Calculate the p-value.

Considering that this individual was not promoted: Determine whether this person's average weekly sales are greater than the average weekly sales for the 50 sales reps whose data you used to develop confidence intervals. Create Null and Alternative Hypothesis statements that would allow you to determine whether the new Sales Manager's weekly average sales are greater than the sample of Sales Reps. Use a significance level of .05 to conduct a t-test of independent samples to compare the average weekly sales of both. Calculate the p-value.

Paper For Above instruction

In this analysis, we will evaluate several statistical measures and tests related to the weekly sales performance of a sales force in a company. The primary focus revolves around establishing confidence intervals for the sales data, understanding how changes in confidence levels and sample sizes affect these intervals, and performing hypothesis testing to compare sales performances among employees. Using the dataset from Week 4, and employing Excel® tools, we will interpret the sales data to inform managerial decisions regarding employee promotion and performance evaluation.

The initial step involves calculating the 90% confidence interval for the average weekly sales of the entire sales force. This confidence interval provides a range wherein we expect the true mean weekly sales to fall 90% of the time. To determine this, we calculate the sample mean and standard deviation from the provided data. Using the t-distribution (appropriate for small sample sizes or unknown population variance), the margin of error is computed as the critical t-value multiplied by the standard error of the mean. The confidence interval is then expressed as the sample mean plus or minus this margin.

Next, we examine how increasing the confidence level to 95% affects the interval. Since a higher confidence level corresponds with a larger critical t-value, the margin of error expands, resulting in a wider confidence interval. This increase enhances the range's certainty but decreases precision. Conversely, we explore the impact of enlarging the sample size to 150 while maintaining a 90% confidence level. An increased sample size reduces the standard error, thereby narrowing the confidence interval and providing a more precise estimate of the population mean.

Furthermore, the analysis involves calculating the sample mean of weekly sales for a sample of 50 sales representatives at a 90% confidence level. The resulting confidence interval bounds are used to assess whether individual reps’ recorded performances exceed the estimated population mean, offering insights into exceptional performers.

To compare the sales performance between two specific Sales Reps—A and B—we formulate null and alternative hypotheses. The null hypothesis states that there is no difference in their average weekly sales, whereas the alternative posits a significant difference exists. Conducting an independent samples t-test at a significance level of 0.05 yields a p-value indicating the probability that observed differences arise under the null hypothesis. If the p-value is less than 0.05, we reject the null, concluding a statistically significant difference between their performances.

Additionally, we evaluate the sales performance of a candidate who was not promoted. The hypotheses test whether this individual’s mean weekly sales surpass those of the existing sales reps. Using another independent t-test with the same significance level, the p-value informs whether the candidate's sales are statistically greater, supporting or opposing promotion decisions.

Throughout this analysis, Excel® functions such as T.INV.2T, AVERAGE, STDEV.S, CONFIDENCE.NORM, and T.TEST are integral in calculating confidence intervals and conducting hypothesis testing. These measures assist managerial personnel in making data-driven decisions—whether in selecting the best candidate for a position or identifying high-performing employees—ultimately contributing to strategic HR and sales management.

References

  • Field, A. (2013). Discovering Statistics Using IBM SPSS Statistics. Sage Publications.
  • Moore, D. S., McCabe, G. P., & Craig, B. A. (2017). Introduction to the Practice of Statistics. W.H. Freeman.
  • Ott, R. L., & Longnecker, M. (2010). An Introduction to Statistical Methods and Data Analysis. Cengage Learning.
  • Myers, R. H., Montgomery, D. C., & Vining, G. G. (2012). Generalized Linear Models: With Applications in Engineering and the Sciences. Wiley.
  • Lehmann, E. L., & Casella, G. (2003). Theory of Point Estimation. Springer.
  • Walpole, R. E., Myers, R. H., Myers, S. L., & Ye, K. (2012). Probability & Statistics for Engineering and the Sciences. Pearson.
  • Rumsey, D. J. (2016). Statistics For Dummies. Wiley.
  • DeGroot, M. H., & Schervish, M. J. (2012). Probability and Statistics. Pearson.
  • Altman, D. G. (1991). Practical statistics for medical research. Chapman and Hall/CRC.
  • Field, A., Miles, J., & Field, Z. (2012). Discovering statistics using R. Sage Publications.

Related Assignments