Answer for common question in Excel test for interview

Answer for common question in Excel test for interview

This page list answers for some common question in an Excel test for interview. This page will be updated regularly to ensure it’s most updated accuracy. Please come back regularly or consider to have this page bookmarked. Common question in an Excel test for interview 1) What is Microsoft Excel? Microsoft Excel is software that … Read more

Python Tutorial 12: Data conversion in Python

Data conversion in Python, can be done implicitly (implicit data conversion) and explicitly (explicit data conversion) for primitive and non-primitive data structures. Python Implicit Data Conversion Implicit data conversion or coercion is something that will happen automatically in python during compilation or run time. It is handled by Python directly without losing any information. For … Read more

How to use if function with multiple conditions and outcomes in Excel

Excel If Statement with multiple condition

This paragraph is original in English. From my last blog, we have introduced the if function in Excel where following is the syntax: Syntax: if function with multiple conditions and outcomes What if we have multiple conditions? Can we use the if function with multiple conditions? The answer is “Yes”. There are two ways to … Read more

Python Tutorial 24 : Descriptive statistics in Python

Python support following Descriptive statistics  function Averages and measures of the central location mean() Arithmetic mean (“average”) of data. harmonic_mean() Harmonic mean of data. median() Median (middle value) of data. median_low() Low median of data. median_high() High median of data. median_grouped() Median, or 50th percentile, of grouped data. mode() Mode (most common value) of discrete data. … Read more

Splunk Tutorial 10: How does Splunk read input data?

Imaging when you upload machine data into a Spunk engine, you are basically uploading a bunch of data that are most likely unstructured and cannot be understand or stored by traditional relational database in a structured way. However, Splunk can get you the result in less than one second when you search it. Splunk must have some special way to classify the data. Have you even image how does Splunk read your machine data?

The selling point of Splunk is its unique ability to index machine data. This ability allows Splunk to quickly search for analysis, reporting and alerts.

What? Splunk index machine data? Yes! Remember, from previous blog Splunk Tutorial 03: Licensing of Splunk 7.1.1, we have mentioned that Splunk is charged per indexed data. Splunk actually read your data by indexing it with it’s own way.

Following is how splunk index your data.

Read more