ANOVA, t-test using only mean, stdev, and number?

N

nukeemaway

New Member
Joined
Jul 12, 2009
Messages
34
Good morning everyone.

I have the mean, standard deviation, and number of respondents for 10 categories. I do not have the raw, underlying data from which it was compiled.

Is there any way (within excel itself or using a macro) that I can run ANOVA tests and individual t-tests (i.e. checking each category against the other 9 for significance) using just what I have? I can easily strip the rest of the excel sheet so that I just have the Mean in Column A, Standard Deviation in Column B, and Number in Column C (or any other column arrangement) if that makes it easier.

Thanks a lot for your help!
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
You must log in or register to reply here.

Similar threads

A
  • Question Question
Two dimensional dynamic named range over a pivot table not working as I thought
Replies
4
Views
921
ashleighbrown
A
ChrisMac1
  • Question Question
VBA - Compare specific data in one column on one sheet, with the same column on 4 other sheets, copy specific cells if match found.
Replies
1
Views
427
ChrisMac1
ChrisMac1
C
  • Question Question
Microsoft Advanced Filter works only intermittently. Same exact filter in another workbook with same exact layout doesn't work.
Replies
2
Views
429
c_bro2498
C
J
  • Question Question
Excel VBA .Save Causing a Save As to 'Random' number filename
Replies
2
Views
511
jcoeng
J
B
  • Question Question
Can you shorten my work flow please
Replies
3
Views
401
Skybluekid
Skybluekid

Forum statistics

Threads
1,224,517
Messages
6,179,239
Members
452,898
Latest member
Capolavoro009

Share this page

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
Back
Top