how to get data analysis on excel lab report

We can repeat this process for each variable in our dataset to visualize the distribution of values for each variable. 3 players scored between 25 and 30 points.2 players scored between 20 and 25 points.1 player scored between 15 and 20 points.4 players scored between 10 and 15 points.This histogram allows us to visualize the distribution of points scored by the players. The following histogram will automatically be created: We can also create charts to visualize the values in the dataset.įor example, to visualize the distribution of values for the Points variable, we can highlight the values in the cell range B2:B11, then click the Insert tab along the top ribbon, then click the Histogram icon within the Charts group: Note: Each formula automatically ignores blank or NA values when calculating each descriptive statistic. We then dragged each formula to the right so that we could calculate the same metrics for the values in columns C and D.īy calculating these descriptive statistics for each variable, we can gain a good understanding of the distribution of values for each variable. Here is the formula we used for each cell in column B: Next, we can calculate the mean, median, quartiles, minimum, and maximum values for each of the three variables in this dataset: This dataset contains three variables (Points, Rebounds, Assists) and some of the variables have blank or NA values, which is common in real-world datasets. Step 1: Create the Datasetįirst, let’s create a simple dataset that contains information about 10 different basketball players:

The following step-by-step example shows how to perform exploratory data analysis in Excel. Summarizing a dataset using descriptive statistics.īy performing these three actions, you can gain an understanding of how the values in a dataset are distributed and detect any problematic values before proceeding to perform a hypothesis test, fit a regression model, or perform statistical modeling. This involves exploring a dataset in three ways:ġ. One of the first steps of any data analysis project is exploratory data analysis.

How to get data analysis on excel lab report