Opening Data in Microsoft® Excel® and Running Descriptive Statistics

Introduction

Excel is a powerful tool used by millions of people each day. It’s not just for analysts, though. Whether you’re managing a small team or working on an important project, Excel can help you answer your questions and get things done quickly. You already know how to use Excel; but maybe there are some new techniques or different ways of doing things that will make your work easier! In this article we’ll walk through the steps of opening a new workbook in Microsoft Excel and running descriptive statistics on it.

Step 1: Open Excel by clicking on the Start menu and selecting Microsoft Excel.

Open Excel by clicking on the Start menu and selecting Microsoft Excel.

Excel is a powerful tool for data analysis, but it can be intimidating to new users because of its vast array of features. In this chapter, we’ll focus on two of the most important functions: opening data in spreadsheets, and running descriptive statistics using SPSS Statistics software.

Step 2: Click on File, then click on Open.

• Click on File.

• Click on Open.

• Select the file you want to open, then click Open.

• Select Data Analysis from the drop-down list and select your desired analysis from the Edit Analysis menu (see Figure 4). The input range will be automatically selected if it’s already selected in Excel; otherwise, click inside of it and then press Enter/Return to select it as an input range for this calculation/analysis process. You can also choose to run multiple analyses at once by clicking Add Analysis in any empty area of your workbook before proceeding with Step 3 below!

Step 3: Select the file that you would like to open, then click Open.

• Select the file that you would like to open, then click Open.

• If you don’t have the file, you can copy and paste the data from a website or other source into Microsoft Excel and run descriptive statistics on it there before opening it in Microsoft Excel as an external data source (see Step 4).

Step 4: To run descriptive statistics in Excel, click on Data Analysis from the add-in tab (if it isn’t already selected).

To run descriptive statistics in Excel, click on Data Analysis from the add-in tab (if it isn’t already selected).

Then click on Descriptive Statistics.

Finally, you will be presented with a window with three sections: Variables, Data Summaries and Graphs.

In this section you can select variables that you wish to include in your analysis. In addition to selecting variables, you also have the option of changing their levels or grouping them together based on their values. This can be done by choosing one of two options under each variable—change its level or group it into categories according to its value range—or clicking OK when finished making changes in order for these changes to take effect immediately without having any further effects if nothing else has been changed since last time we looked at our data set prior using tools like those provided here so far (i’m talking about all those tools within this section).

Takeaway:

You may have heard of descriptive statistics, but you don’t know what it is or how to use it. A good thing to do is to start by asking yourself a few questions:

• What am I trying to learn from my data?

• How can I take this information and make sense of it?

• Is there a pattern in my data that I should be looking for?

Conclusion

I hope this helps you to open a file in Excel and run descriptive statistics.