Notice that the label on so H-1 is the header. And this happens quite a bit with the tool packs. The descriptive statistics in order to see everything clearly you have to expand column A.
Click OK this opens the tab with the results. I'll check some statistics to see the results. You also have to check at least one of the remaining boxes. This means that the results will appear in a new tab. It's a good idea to go with the default output option new worksheet plie. It's a good idea to go with the default option. So I'll check the checkbox next to labels in the first row. It's important to let Excel know that the first cell in the range is the label. If the scores are in rows you have to click the rows radio button.
This happens with the tools in the tool bag as you can see Excel assumes the data are grouped by columns.
Age 10 knows that Excel has added dollar signs to the cell identifiers. So our click H-1 hold down the Shift key and click. The first thing we have to do is let the tool know where the data are that goes into the input range box which is active. And that opens up the descriptive statistics dialog box every tool in the tool pack has its own dialog box and each one is different depending on what the tool does. Here the analysis tools box also like descriptive statistics and click OK. I click it to open up the set of data analysis tools as you can see this opens up the data analysis dialog box. So I click that tab and we'll get started after you add in the tool pack. There is a button to get to the tool pack lives on the Data tab. I'll use one of the tools to calculate descriptive statistics of the scores you see here in column H. This video shows you how to use Excel data analysis tool pack the tool pack includes a lot of tools that you'd find in a software package dedicated to statistics but they come free and excel as an add in you just have to add the men in an earlier video I showed you how to do just that.
0 kommentar(er)
