"SEC | S20W3 | Data Analysis with Excel: (Charts, and data analysis techniques.)

Hello friends, it is nice joining the Steemit engagement Challenge for the week. I hope to make the best out of this first entry.

Charts all over in an application platform especially in excel as discussed here are the representation of data collated.and entered for purposes of given a clearer illustration of trends and patterns of an event. No matter how complex os the data collated, charts are medium to simplify them and make them more understandable.

They can also be used when we want to compare values, identify trends and variations during data computation and analysis. It clearly shows us when there are distortations and variations in data. With the use.of excel charts, it gives us feedback capable of identifying areas for improvement and actions driven type, which form basis for decision making.

Examples of excel charts include;

• Column Chart
• Line Chart
• Pie Chart
• Bar Chart
• Area
• Scatter Chart
• etc.

Identifying this chart types, we will simply do one thing which is clicking on the "INSERT" option from the menu bar. We will see a display of these charts.

^{Column Chart}

^{Pie Chart}

^{Bar Chart}

• from the spreadsheet, highlight requested data
• click on the insert option
• select the bar chart as required

From the bar chart image, we can deduce the following.

• Nigeria repeesents the highest numner of Steemians as captured in the date with 122
• Second from last in the list with Romania with 4 appearance.

Data analysis technique in excel is simply the representation of all forms of analytics required in carrying out our desired data computation. By mere entering data in our spreadsheet, it does not make sense not until we add some formulas and instructions.

These are tools when used help give us simple clarity and guidelines on what next to do. Results from the application of data analysis technique help us make informed decisions.

On how to organize data in excel fir analysis, it may involve the following;

1. Highlighting working data on the spreadsheet to allow for full capture of data to be processed.
2. The use of the "Sort & Filter" option from the home button.
3. Apply Formulas which has the autosum, logical, lookup, etc
4. Use of data tool that help remove duplicates, enhance data validation, etc
5. We have the cell "wrap text", and "merge/center" tool that help organize and reorganize data outlook and description.

1. Click on the Cell with the name of the first country "Nigeria "
2. Click on the sort & filter tool
3. Then click on "Sort A to Z"

Thank you.

I invite @chant, @eveetim, and @bela90