How do I Test a Hypothesis in Excel

[ernestgoh]

Happy new year to everyone!

I would like to know how I can test the hypothesis in excel, for example Tuesdays have lower volume than the average weekday?

Day Volume
Sun 2,650
Mon 2,581
Tue 2,337
Wed 2,972
Thu 3,166
Fri 3,189
Sat 2,408
Avg Day 2,753

Thanks in advance!

[zbor]

Try this:

=AVERAGEIF($A$2:$A$8;"Tue";$B$2:$B$8)<$B$9

However, if you like to change "Tue" better make some cell reference (e.g. C1)

Edit: sorry, WEEKDAY... For that it would be nice to see how your data is stored...

[rwgrietveld]

Assume Average is in B9 then

=B6<$B$9

The result is TRUE/FALSE.

Copy up/down for the other days of the week.

[ernestgoh]

Try this:

=AVERAGEIF($A$2:$A$8;"Tue";$B$2:$B$8)<$B$9

However, if you like to change "Tue" better make some cell reference (e.g. C1)

Edit: sorry, WEEKDAY... For that it would be nice to see how your data is stored...

Hi guys, thanks for your quick reply!

What I had in mind was using the statistics function in Excel through a T-test or confidence interval test?

Thanks again.

[zbor]

Can you upload example where you'll put your inputs and outputs and explain problem more detail

THX