Data Handling in Excel: Pre-processing, IF Function, Charts and Graphs

DATA
HANDLING

Table of Contents
PART 1............................................................................................................................................3
1. Use of excel of pre-processing the data...................................................................................3
Use of IF function in Excel......................................................................................................4
Charts and Graphs....................................................................................................................6
PART 2............................................................................................................................................6
2.1 Using the audidealership.csv provided in conjunction with Weka give a specific example
of clustering.................................................................................................................................6
2.2 Explain the most common data mining methods that can be used in business with real
world examples..........................................................................................................................10
2.2.1 Weka J48 algorithm......................................................................................................14
2.2.2 Clustering......................................................................................................................15
2.3 Advantages and disadvantages of Weka over excel............................................................15
REFERENCES..............................................................................................................................17

PART 1
1. Use of excel of pre-processing the data
For corporate, business managers, homemakers, data collection, success reviews on a
day-to-day basis and job, companies are found in Microsoft Excel. For accounting operations
Microsoft Excel is commonly used. The following are the applications in Microsoft Excel:
 ANALYSING AND STORING DATA- Microsoft Excel is a great method for grid
research and management of data. Information may be entered in various rows and
columns of the list (Chen, Chen, He and Xia, 2018). Using maps, maps, and tables
provides data mining. The details from various archives and records can be fetched using
Excel. Data should be stored in an organized manner. This allows everyone to waste a lot
of time, other than that, it's simpler for you to analyze the results. Is not expected, using
Pivot Table, encourages data analysis (Chen and et.al., 2018).
 DATA RECOVERY- When the data is misplaced; Windows allows users to recover it.
The format MS Excel helps to restore details.
 MAKING REPORT- MS Excel and MS Word MS Word may supply the report in prose,
while MS Excel presents the report in table format. The reports are accessible in MS
Excel formats. MS Excel can allow simultaneous device distinctions. Not only is MS
Excel helping owners monitor companies, it also lets employees document their success
reviews on a regular basis. It also allows teachers use maps, patterns, methods, formulas
to assist their pupils.
 RESEARCH- They typically investigates patterns of success in the past, but success
often allows us to complete our potential work. What is the situation or how we will
continue our job this way for a few years. Research helps resolve the query about what is
going to happen and what is not to happen. Users will build prospects for our future
through different formulas and past patterns. The strategy and growth was carried out
according to this study work of corporations (Enders, 2017).
 CONDITIONAL FORMATTING- The use of conditional formatting allows to classify
all relevant people. Conditional formatting allows one to even identify issues to highlight.
It will even help to evaluate meanings, identify duplicates.

 Security- MS Excel primarily offers protections for Excel files, allowing users to manage
their data safely (Enders, 2017). Everything MS Excel files can be stored in an
outstanding repository by way of the visual basic programming. Within the MS Excel,
people store their vital data in order to maintain their data structured to save time. Most
people like to protect their files so that nobody will access them or destroy them and MS
Excel is really good at solving the issue.
Use of IF function in Excel
The IF function or IF statement in excel is made up of three parts separated by a comma.
• Condition
• When to mean when the requirements have been met
• Where to show if the conditions have not been satisfied
In this case, it can see on which point revenue and earnings have been lowered and on what date
retail purchases are that, and how the IF feature is performed step by stage.
• First copy and paste on different sheets the date of payment, revenue and income.
• Now, first rearrange old-date data by sorting excellence sheet function.
• Pick the cell where the "IF Feature" is generated.
• Type the code in the cell = if (Sort of the condition by viruses: B2>B3,)
• Enter the code which user like to see if the requirement has been reached.
• Select a comma:
• If the requirement has not been met, choose: "Increase"
• Closing the bracket and then click Enter.
• The following IF function would look like this