Purpose of Assignment

The purpose of this assignment is to develop students’ abilities to combine the knowledge of descriptive statistics covered in Weeks 1 and 2 and one-sample hypothesis testing to make managerial decisions. In this assignment, students will develop the ability to use statistical analysis and verify whether or not a claim is valid before advertising it.

Assignment Steps

Resources: Microsoft Excel®, Spicy Wings Case Study, Spicy Wings Data Set

Develop a 700-word statistical analysis.

Use descriptive statistics to compute a measure of performance John can use to analyze his delivery performance. Find the following for your measures:

• Mean
• Standard deviation
• Sample size
• Five-number summary on the total time

Conduct a formal hypothesis testing to help John decide whether to offer the delivery guarantee or not.

Estimate the probability of an order taking longer than 30 minutes.

Make a recommendation in a short narrative including the following:

• Based on the sampled data, should John offer the guarantee?
• What percent of the Saturday deliveries would result in a customer receiving a free order?
• What recommendations might help John improve his Saturday delivery times?

Format your assignment consistent with APA format.

The assignment: You are the HR manager for a company that has approximately 2,000 employees. While there is not a profit sharing plan, there are matching funds to a 401k, as well as health benefits, which employees must pay a portion. The employees are divided into three divisions, with division two and three doing similar tasks.

The first division operates relatively lean, and is the operations of the company. The second and third divisions are collectively lean, and have employees that are all necessary in fulfilling the mission of the organization. Both the second and third divisions hired personnel as the company was growing.

Unfortunately, over-hiring was done in the second division, as the second division became stagnant and the third division had stronger growth. The third division has significantly more personnel; however, the number is not proportionate with the second division, nor with the workload required. More personnel are needed in the the third division, due to the growth it is experiencing. Fewer are consequently need in the second division. Not everyone in the second division can perform the duties necessary in the third division. Everyone in the third division can perform the duties of those in the second division.

Upper management will be making a decision as to what to do about the over-hiring in the second division and the under-staffing in the third division. They have sought your advice as to a potential solution or solutions, and will meet with the Board of Directors to determine the appropriate action. What are the plan(s) that you propose to upper management?