Reference no: EM131702101

In Chapter 4 of your course textbook, complete Analysis Exercise 4: Matching Training to Software Use (pp. 171-172). You need to use both MS Excel and MS PowerPoint for this assignment. Be sure to address parts a, b, and c properly.

Use data table in page 171 only. There is another data set in page 172 but it is not for this assignment but for another exercise. Do not use the data in page 172.

For additional information to create 3D chart, please use the Present Your Data in a Column Chart tutorial.

3-D Graphing

You have the responsibility to manage software training for Sales, Accounting, and Operations Department workers in your organization. You have surveyed the workers to get a feel for the amounts of time spent us-ing various packages, and the results are shown below.

The values shown are the total number of workers in each department and the total weekly hours the depart-ment's workers spend using each software package. You have been asked to prepare a spreadsheet summarizing these data and comparing the use of the various pack-ages across departments.

Department Employees Spreadsheet Database Presentations Sales 225 410 1,100 650 Operations 75 710 520 405 Accounting 30 310 405 50

a. Create a spreadsheet illustrating each application's average use per department.

To do this, you will first enter the data shown above. Then compute the avenge weekly spreadsheet use by dividing spread-sheet hours by the number of Sales workers. Do this for each department. Repeat these three calculations for both database and presentation use.Round results to the nearest 1/100th.

b. Create a three-dimensional bar graph illustrat-ing the avenges by department and software package.

c. A committee has been formed to plan software training classes at your company.

Prepare a slide presentation with four slides illustrating your findings. The first slide should serve as an introduction to the data; the second slide should .