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
Get a custom-written paper by an expert in this subject. Plagiarism-free, on time, any citation style.
- ✓ PhD & Masters qualified writers
- ✓ Turnitin-safe — 0% similarity
- ✓ Free revisions + money-back guarantee
From $11/page · All academic levels
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?
Our expert writers specialise in this subject and deliver original, well-researched papers.
Nursing & Healthcare · PhD Edinburgh
Business & Law · MBA London
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:
Join 12,400+ students who trust us with their academic success. Every order includes: free revisions within 30 days, plagiarism report, on-time delivery guarantee, and full confidentiality.
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
