Each week, you will be asked to respond to the prompt or prompts in the discussion forum. Your initial post should be 75-150 words in length, and is due on Sunday. By Tuesday, you should respond to two additional posts from your peers.
Last week, we looked at a scenario in which:
ABC Enterprises is a growing company in which employees must frequently travel by car for business a few times each week. Currently, each employee is allotted 30 dollars each travel day to cover all meals. Sales employees often travel in a 1.5-hour radius of the office and frequently have multiple appointments each week. They have complained that that dollar amount for food is not enough, especially on days with multiple meetings. A survey, given by the CEO, was taken to get a sense of what the employees recommended for a new allotment. Although not all responded, the response rate was pretty good – 67%. Note: The 30 dollars is for food. Gas is a different amount given to the employees – please do not assume the 30 dollars includes fuel.
This week, you are going to use several key numbers to interpret the data.
January 2022 Master.xlsx
Calculate the following in EXCEL. (There is a practice sheet in my Hints document in the discussion)
Mean, median, mode, range, standard deviation of the SAMPLE,
Then, answer these questions.
• What was the most frequent dollar amount given? Does that number seem to be in alignment with the other measures of central tendency? Why or why not?
• What is standard deviation? Does the standard deviation show that the data is clumped all together or spread apart?
• Let’s say that the data is normally distributed. The assigned chapters of the week mention the Empirical Rule. What dollar amount range is one standard deviation from the mean? What percentage of values are within one standard deviation from the mean?
• Using that same Empirical rule and let’s say the data is normally distributed, in what monetary range do 95.44% of all the responses fall?
• What is your analysis of what the company should do? What should the new dollar amount be? Why?
You will be asked to react to one or more prompts in the discussion thread each week. Your first post should be between 75 and 150 words long and due on Sunday. You should react to two more posts from your peers before Tuesday.
We looked at a case last week in which:
ABC Enterprises is a thriving firm with employees that must travel by automobile several times per week for business. Each employee is currently given $30 every travel day to cover all meals. Salespeople usually travel within a 1.5-hour radius of the business and have several appointments per week. They have complained that the food budget is insufficient, particularly on days when they have many meetings. a study
