#HOW TO USE DATA ANALYSIS IN EXCEL 2013 HOW TO#
#HOW TO USE DATA ANALYSIS IN EXCEL 2013 PROFESSIONAL#
#HOW TO USE DATA ANALYSIS IN EXCEL 2013 WINDOWS#

In this case, each assignment is weighted equally, so all we have to do is average all five grades by typing =AVERAGE(B2:B6). Even though we don't know what the fifth grade will be, we can write a formula-or function-that calculates the final grade. In the image below, you can see that the grades on the first four assignments are 58, 70, 72, and 60. You can use Goal Seek to find out what grade you need on the final assignment to pass the class.

Luckily, you have one final assignment that might be able to raise your average. You currently have a grade of 65, and you need at least a 70 to pass the class.

#HOW TO USE DATA ANALYSIS IN EXCEL 2013 HOW TO#

We'll use a few examples to show how to use Goal Seek. Goal Seek works in the opposite way: It lets you start with the desired result, and it calculates the input value that will give you that result. In Excel for Windows, if you dont see the Solver command or the Analysis group on the Data tab, you need to load the Solver add-in. Whenever you create a formula or function in Excel, you put various parts together to calculate a result. It will help all those readers who use MS-Excel regularly to analyze data.

#HOW TO USE DATA ANALYSIS IN EXCEL 2013 PROFESSIONAL#

By clicking on an item of the menu, you activate the dialog box corresponding to the selected function.Optional: Download our practice workbook. This tutorial has been designed for all those readers who depend heavily on MS-Excel to prepare charts, tables, and professional reports that involve complex data. Both XLSTAT toolbar and the XLSTAT tab can be used to access the XLSTAT functions. The XLSTAT tab is also added (see image below).

#HOW TO USE DATA ANALYSIS IN EXCEL 2013 WINDOWS#

Use the Windows Start / Programs / Addinsoft / XLSTAT command, To run XLSTAT for the first time, you can choose one of these options:Ĭhoose the option 'launch XLSTAT' at the end of the installation procedure,

To check the list of supported systems for XLSTAT, follow this tutorial. The other PivotTable buttons preview the various types of pivot tables that can be created from the selected. The Table button previews how the selected data would appear formatted as a table. Excel selects the Tables tab and displays its Table and PivotTable option buttons. It is also recommended that you make sure your Operating system and your Microsoft Office version are compatible with your XLSTAT version. Click the Tables tab at the top of the Quick Analysis options palette. Select the option 'Disable VBA macros except digitally signed macros' for the Macro Settings.Īctivate the option Trust access to the VBA project object modelĬlick OK to close the Trust center windowĬlick OK to close the Excel options windowĮnsuring your OS and Excel version are supported by XLSTAT Select Macro Settings in the middle of the menu bar on the left

Select Trust Center in the middle of the menu bar on the left.Ĭlick on the Trust Center Settings. Here is how to verify that Macros are properly enabled:Ĭlick the Office button on the upper left corner of the Excel window to open the Office Menu (Excel 2007) or click the File tab (Excel 2010, 2013, 2016).Ĭlick on the Excel Options button on the bottom of the Office menu window (Excel 2007) or choose Excel Options in the File menu (Excel 2010, 2013, 2016). Whatever your Excel or XLSTAT version, it is necessary that the Macros security level is set to Medium so that XLSTAT can run. Making sure Microsoft Excel macros are enabled

How to use data analysis in excel 2013