ttest

  1. S

    Counting entries from multiple sheets

    I am trying to pull information from sheet "data" into sheet "results" I need to know how many times a person's name was listed on the data sheet. I need it to separate out according to the date as well as the person's name. A formula is preferred, I need the number of times "ttest" shows up...
  2. G

    Excel / Significance Testing

    Hi all, My question here is two-fold: Firstly, I have been asked to statistically analyse the customer satisfaction results for a pilot which has two groups - One, where the customer is asked a question by a receptionist before they are routed to the correct department; the other where they are...
  3. Y

    Ignore Hidden Rows with TTest

    Hi, I'd like to have Ttest ignore hidden rows. Normally: =TTest(A1:A10,A11:A20,2,3) would compare group 1 (A1 to A10) with group 2 (A11 to A20) but how to ignore hidden rows? I know the function SUBTOTAL can ignore hidden cells but the function used in subtotal does not have TTest. Please...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top