Forum Discussion

franpere's avatar
franpere
Copper Contributor
Apr 25, 2022
Solved

excel for statistics. ¿how to compute some descriptive statistics with case selection?

I'm teaching statistics using Excel. I want to compute some descriptive statistic, for instance, the first quartile. The following data shows sex (male of female) and age (in years) of the members o...
Formulas and Functions
  • JoeUser2004's avatar
    JoeUser2004
    Apr 26, 2022

    franpere  wrote:  ``this works fine with excel 365. But the problem is that computers at university classroom have office professional plus 2016 and it does not work there.``

     

    Array-enter the formula (in Excel 2016 at least) by pressing ctrl+shift+Enter.

     

    Office 365 Excel does not require that.  I do not know if it allows, nevertheless.

JoeUser2004's avatar
JoeUser2004
Bronze Contributor
Apr 26, 2022

franpere  wrote:  ``this works fine with excel 365. But the problem is that computers at university classroom have office professional plus 2016 and it does not work there.``

 

Array-enter the formula (in Excel 2016 at least) by pressing ctrl+shift+Enter.

 

Office 365 Excel does not require that.  I do not know if it allows, nevertheless.

franpere's avatar
franpere
Copper Contributor
Apr 26, 2022

JoeUser2004 Thank you so much for your answer. It solved the problem and works fine. You have help me a lot. Thank you!

Resources