Say if I wanted to add the third quartile of the data to the output, I would just add a definition of qthree, change the number of rows for MAKEARRAY, then add the new statistic name and output value to each of the CHOOSE statements. The LAMBDA going in to MAKEARRAY is pretty simple, we’re just using CHOOSE in both columns 1 and 2 to either place the name of the statistic, or the return value, in the output.Īnd of course, if you wanted to extend this to add statistics that are important to your work, or remove statistics from the list that aren’t, you could always modify the lambda accordingly. If you need to add the data analysis ToolPak in your version of Excel, follow these instructions. The number of rows is (number of descriptive statistics)+1 for the header, and 2 columns – one for the name of the statistic and one for the return value. It is possible to use software packages to produce a summary of key descriptive statistic measures: Useful step-by-step instructions for obtaining the descriptive statistics data analysis ToolPak add-on in Excel written by Excel Easy. Here I’ve tried to do them in an order so that if a result for one calculation is needed in another, it can be reused (as with rang=maxm-minm).įinally, we are using MAKEARRAY to construct the output. We then calculate each of the required statistics separately, using native Excel functions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |