Descriptive statistics summary report excel mac

DESCRIPTIVE STATISTICS SUMMARY REPORT EXCEL MAC SERIES

If there are 500 students in each university and the data is collected from 3 such universities, then the researcher must concise the view of the data to understand its broader aspects, characteristics and trends. The data set might be of two or more universities having the 5 variables listed. where the input could be a continuous variable or discrete one. The data set might comprise of multiple variables like age, gender, course, ethnicity, marks obtained etc. In all the above cases, the researcher might gather a large amount of data.

if the percentage of students passing any course is the same in the university X.

if the average marks scored in the test is more than 52%.

what percentage of students who have enrolled in a program are males?.

if there are more girls completing a course compared to boys in a chosen sample,.

Suppose your research question wants to determine When should we use Descriptive Statistics? It is different from Standard Deviation which indicates the concentration of data around the mean and uses the same units.

The variance is the square of Standard Deviation.

This takes care of outliers in the data set.

In a normally distributed data set, about 67 вЂ“ 68% of the data lie within the distance of 1 Standard Deviation from the Mean, 95% within 2 Standard deviations and 99% of the data set within 3 Standard deviations.

It is the difference between the maximum and minimum number in the data set.

The range is the simplest of the three.

The commonly used estimates are range, standard deviation, and variance. The objective of measure of dispersion or variation is to identify the extent to which the entire data set is spread from the central tendency вЂ“ specifically mean.

DESCRIPTIVE STATISTICS SUMMARY REPORT EXCEL MAC SERIES

The value of the estimates of central tendency help in the next series of characteristics of the data set вЂ“ dispersion or variation.

Mode indicates the most commonly occurring value in the data set.Д¬ommonly if the mean, median and mode are equal then the data is said to be normally distributed.

You can use the data analysis option in Microsoft Excel too to determine the median. Usually, the data is sorted in ascending order and the middle value is considered as the mean.

Median is the middle of the entire data set.

The central tendency is estimated using the mean, median and mode. The measures of central tendency are used to show the centre of the data set. The bar chart is handy if the data is nominal or ordinal. The histogram is preferred in case of continuous data set as it shows whether the data is normally distributed or left or right skewed.

The distribution of the dataset is measured using frequency distribution and is presented in graphical form using a bar chart or a histogram. Age or weight is the most common example of continuous data set.Discrete data means 1 banana or Male participant.The explanation of the data set is arrived at using 3 characteristics of the data out of which one is graphical: What are Descriptive Statistics?Дescriptive statistics present a concise view of a large data set. In this blog, we will briefly discuss what is the various estimates of descriptive statistics, when should we use them and why. Before we plunge into the details or start generalizing the data and make inferences and extrapolate the findings for an entire population, it is sensible to describe the gathered and tabulated data set. When we collect data from a particular sample or a population to answer our research questions, it is important that we first talk about the broader characteristics of the data. There are two main types of statistics applied to collected data вЂ“ descriptive and inferential. Statistics is widely used in all forms of research to answer a question, explain a phenomenon, identify a trend or establish a cause and effect relationship.

Descriptive statistics summary report excel mac