Need a discussion for Business statistic class. The word document is just the problem. The excel named week 2 hint is to follow
Need a discussion for Business statistic class. The word document is just the problem. The excel named week 2 hint is to follow on how to build the data graph. The problem needs to be completed in excel.
1
4
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?
,
Sheet1
| Age | Requested Amount | |
| 51 | 90 | |
| 25 | 50 | |
| 22 | 75 | |
| 58 | 80 | |
| 60 | 150 | |
| 21 | 35 | |
| 34 | 40 | |
| 63 | 190 | |
| 31 | 55 | |
| 24 | 60 | |
| 49 | 75 | |
| 52 | 70 | |
| 33 | 40 | |
| 27 | 45 | |
| 54 | 50 | |
| 45 | 55 | |
| 38 | 45 | |
| 55 | 75 | |
| 49 | 70 | |
| 53 | 75 | |
| 61 | 70 | |
| 63 | 85 | |
| 59 | 65 | |
| 46 | 30 | |
| 22 | 30 | |
| 21 | 50 | |
| 36 | 45 | |
| 31 | 55 | |
| 47 | 45 | |
| 50 | 65 | |
| 21 | 45 | |
| 26 | 45 | |
| 25 | 45 | |
| 45 | 45 | |
| 51 | 60 | |
| 50 | 55 | |
| 34 | 45 | |
| 37 | 60 | |
| 30 | 45 | |
| 54 | 50 | |
| 57 | 60 | |
| 60 | 70 | |
| 61 | 80 | |
| 49 | 75 | |
| 39 | 45 | |
| 55 | 75 | |
| 47 | 45 | |
| 51 | 55 | |
| 38 | 60 | |
| 44 | 65 | |
| 58 | 45 | |
| 60 | 70 | |
| 51 | 60 | |
| 43 | 60 | |
| 30 | 45 | |
| 21 | 30 |
,
Formulas
| How to Use Excel to calculate the mean, median mode… | |||
| ** formulas will appear in the box above | |||
| Data set | |||
| 15 | |||
| 17 | |||
| 22 | |||
| 11 | |||
| 13 | |||
| 80 | |||
| To do | Notes from Dr. Klotz | ||
| mean | 26.3333333333 | Click in the green cell to see the formula used | |
| median | 16 | Click in the blue cell to see the formula used | |
| mode | ERROR:#N/A | There is no mode because no number is repeated | |
| minimum | 11 | Click on the orange cell to see the formula used | |
| maximum | 80 | Click on the red cell to see the formula used | |
| range | 69 | Range is maximum minus minimum | |
| variance | 705.4666666667 | Click on the gray cell to see the formula used | |
| standard deviation | 26.5606224827 | Click on the pink cell to see the formula used |
You try
| You try | |||||||||
| Select the cell next to the name of what it is. They are highlighted in yellow. | |||||||||
| type =aver | |||||||||
| the word "average" appears | |||||||||
| double click on the word "average" | |||||||||
| highlight the cells in the data set | |||||||||
| hit "enter" | |||||||||
| The average should appear. | |||||||||
| Repeat with =min, =max, =std, =var, =medi, =mode…. To get all the values. I have an answer key so that you know if you did it right | |||||||||
| Data set | |||||||||
| 3 | |||||||||
| 9 | |||||||||
| 7 | |||||||||
| 7 | |||||||||
| 8 | |||||||||
| 2 | Answers | ||||||||
| mean | 6 | ||||||||
| median | 7 | ||||||||
| mode | 7 | ||||||||
| standard deviation | 2.8284271247 | ||||||||
| variance | 8 | ||||||||
| maximum | 9 | ||||||||
| minimum | 2 |
Empirical Rule
Who We Are
We are a professional custom writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework.
Do you handle any type of coursework?
Yes. We have posted over our previous orders to display our experience. Since we have done this question before, we can also do it for you. To make sure we do it perfectly, please fill our Order Form. Filling the order form correctly will assist our team in referencing, specifications and future communication.
Is it hard to Place an Order?
1. Click on the “Place order tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
2. Fill in your paper’s requirements in the "PAPER INFORMATION" section and click “PRICE CALCULATION” at the bottom to calculate your order price.
3. Fill in your paper’s academic level, deadline and the required number of pages from the drop-down menus.
4. Click “FINAL STEP” to enter your registration details and get an account with us for record keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
5. From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.
Need this assignment or any other paper?
Click here and claim 25% off
Discount code SAVE25