how to perform Ttest using Excel VBA on a large dataset

[amalchacko]

Hi ,
I have a large dataset of traffic volume for 50 intersections corresponding to 12 movements for 5 time periods in 15 minute intervals for 2 months from consecutive years

I am trying to make a comparison between same month, same intersection, same movement, same time period using the T Test. How can I implement this in the macro. The problem that I am facing is when the number of time stamps reduce from the 16 ( in the attached file ) to 15 how do I take this into account. Is there a way to perform the test only when intersections ,movement, month, day, time period equals for either year.

[arlu1201]

Hello amalchacko,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

[xladept]

Hi amalchako,

We need to be able to define the two ranges specifically - have you criterion for such?

[xladept]

Hi amalchako,

Try this:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

If you haven't used macros before you'll need to go to:
File- options - trust center -trust center settings - macro settings ,
the second option down (disable all macros with notification)

Then - Copy the code to the clipboard

Open your Workbook

Press ALT + F11 to open the Visual Basic Editor.

Select "Module" from the Insert menu

Type "Option Explicit" then paste the code under it

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name