Question

What type of chart is appropriate to visually represent the numerical data? Describe how you will adapt the formatting, labeling, formulas, and organization of your Excel document to fit the purpose of the document and its audience. What type of number format would be appropriate for representing the information required? For example, how many decimal spaces will you include? Will you use a number format or a currency format?

Answer 1

The Chart that can be visually appealing and simple to understand is the "Bar Chart". It can help us to relatively compare data points on the basis of linearity, spread and skewness.

In terms of formatting, The axis (Major and Minor Gridlines) can be labelled and scale can be formatted to give better clarity of data. The Texture and background can also to formatted to give visual appeal.

In terms of labelling, different data points can be labelled over and above the graph, with the graph title labelled as well.

In terms of formula, the trendline formula (Either as logarithmic, polynomial or exponential) can be modelled and also, the regression analysis can be done for the same.

For representing in the number format, the number with two decimal points can be used. This can help approximate the final value to desired accuracy values.