Week 1 Assignment
1. A boss had wanted to know if employees were in their 20s, 30s, 40s etc. Create a frequency distribution table for the following ages of employees. Include more than just frequency. Find other frequencies (like relative frequency) that you can add. Make sure the table would be ready for a business presentation (title, etc.).
50 40 60 60 50 60 60 50 40 40 50 60 50
30 40 30 50 40 60 20 60 60 20 60 20 50
2. Your new boss has asked about the ages of the employees in your department. These ages are found in question 1. What would you tell him/her about the ages of the employees? Provide him with information not only about the numbers, but also how that might impact the company in other ways. Be thorough!
3. Given this set of data, create a scatter diagram in Excel with pages on the x axis and price on the y axis. Create the chart in such a way that it clearly communicates information and is ready to be put on a Power Point slide. Before submitting, think about what all graphs need to clearly communicate information.
Book Pages (x variable) Price (y variable)
A 215 $7.00
B 325 $8.00
C 300 $7.50
D 415 $8.50
E 288 $7.25
F 350 $7.95
G 187 $6.95
Week One’s Task
1. A employer needed to know if his staff were in their twenties, thirties, forties, or fifties. Make a frequency distribution table for the employees of the following ages. Include more than just the number of times. Other frequencies (such as relative frequency) can be added. Ascertain that the table is prepared for a business presentation (title, etc.).
50 40 60 60 50 60 60 50 40 40 50 60 50 40 40 50 60 50 40 40 50 60 50 40 40 50 60 50 30 40 30 50 40 60 20 60 60 20 60 20 50
2. Your new supervisor has inquired about the ages of your department’s personnel. These ages have been called into question. 1. What would you say to him about the employees’ ages? Not only should you provide him with information about the situation, but you should also provide him with information about yours
