How to do data analysis in excel. Filter your excel data if you only want to display records that meet certain criteria. This section illustrates the powerful features excel has to offer to analyze data. Select your input range identify your groups as columns or rows and tell excel whether you have labels.
Select the cells that contain the data you want to analyze. Selected data with quick analysis lens button visible. Select excel add ins and click on go.
Once you click on add ins at the bottom you will see manage drop down list. Analyzing large data sets with excel makes work easier if you follow a few simple rules. Once you click on go.
After that hit ok. Click the quick analysis button image button that appears to the bottom right of your selected data or press crtl q. You can sort in ascending or descending order.
Use the data analysis button to open the analysis tools window and select correlation. Unleash data analysis tool pack in excel.