(1) Develop tables and charts by using Microsoft Excel for presenting and describing business data

(2) Use Mircosoft Excel for statistical and data analysis.

Advertising fees are important source of revenue for any newspaper. In an attempt to boost these revenues and to minimize costly errors, the management of the Herald has established a task force charged with improving customer service in the advertising department. Review the task forces data collection (in the project folder on the Blackboard) and identify the data that are important in describing the customer service problems. For each set of the data, you need to construct the graphs, tables, and charts that are most appropriate for the data and explain your choices. Also, you should suggest what other information concerning the different types of errors might be useful to examine, and offer possible courses of actions for either the task force or management to take that would support the goal of improving customer service.

Requirement: Prepare an analysis report to be submitted to the task force or management. You should include the following information in your report:

(1) Cover page. Please use business design. You should also include your name.

(2) Background and objective of the project.

(3) Data analysis. It should include all the tables, charts, and detailed analysis. Please note that for each of the datasets that you present, you should also clearly analyze the pattern of the data and provide insightful inferences related to the objective of the project.

(4) Conclusions and suggestions.

(5) Appendix, if any.

Chart 1:

Type of Error	Total
Copy error	54
Layout	7
Omits	13
Pasteup	11
Poor reproduction	8
Ran in error	30
Rate quote	13
Space not ordered	7
Typesetting	53
Velox	28
Wrong ad	25
Wrong date	14
Wrong position	45
Wrong manual pasteup	5
Wrong size	6
Total:	319

Chart 2:

Type of Error	Amount ($000)
Copy error	32.6
Layout	3
Omits	36.5
Pasteup	59.4
Poor reproduction	13
Ran in error	108.2
Rate quote	5.3
Space not ordered	12.9
Typesetting	53.1
Velox	23.3
Wrong ad	53.6
Wrong date	35.9
Wrong position	74.9
Wrong manual pasteup	16.5
Wrong size	5.3
Total:	533.5

Chart 3

Type	Frequency	Amount ($000)
Composing room	10	12.8
Policy	16	88.7
Sales	4	6.6
Total:	30	108.1