Question

Complete the appropriate graphic for each of the following scenarios. You should have 4 different graphics after completing assignment. Use Microsoft Excel or compatible package to create graphics. Paste the completed graphics into the same Word document that contains the document revision above.

After each graphic, provide a short justification a s to why your graphic is the best approach--that is, why did you choose this particular graphic and why is it the most effective way of presenting the information?

On a production line there are three machines producing widgets. The production output for the last six months of these three machines was: For the month of July, machine A produced 139, machine B 222, machine C 168. For the month of August, machine A produced 175, machine B 240, and machine C 115. For the month of September, machine A produced 148, machine B 195, and machine C 145. For the month of October, machine A 205, machine B 155, and machine C 140. For the month of November, machine A produced 100, machine B 240, and machine C 50. For the month of December machine A produced 250, machine B 110, and machine C produced only 20.

Answer 1

1) First choice graphic method(Chart Tools->bar):

Steps to create given scenario in microsoft excel:

• Should enter given data in to excel as per given below.
• To select given data and using "Chart Tools->bar" option click it.  

The result as follows:

-----------------------------------------------------------------------------------------

2) Second choice graphics method(Chart Tools->Column):

---------------------------------------------------------------------------------------------------------------------------------

3) Third choice graphics method(Chart Tools->pie):

-------------------------------------------------------------------------------------------------------------------------------------

4) Fourth choice graphic method(Chart Tools->Area):

As my opinion, "Bar" chart or "Column" choice is best approach to given scenarios. The reason is that, machine produce wideget's values is clearly visible and easy to understand with compare of other graphs(pie and area). Then the most effective way of presenting the information is possible in Bar and Column charts.