Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Population Standard Deviation
Dear Experts,
I will need your kind assistance on this. I am very new towards Excel Functions, hope you have the patience for me. Thank you in advance. The question is: A Researcher wants to carry out a test involving the mean for a sample of size n = 18. She does not know the true value of population standard deviation, but is reasonably sure that the underlying population is approximately normally distributed. Should she use a z-test or at-test in carrying out the analysis? -- Message posted via http://www.officekb.com |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Population Standard Deviation
This really isn't an XL question.
One key is the sample size... You may want to look at a beginning statistics textbook. In article <9135401846fe4@uwe, "roystonteo via OfficeKB.com" <u48590@uwe wrote: Dear Experts, I will need your kind assistance on this. I am very new towards Excel Functions, hope you have the patience for me. Thank you in advance. The question is: A Researcher wants to carry out a test involving the mean for a sample of size n = 18. She does not know the true value of population standard deviation, but is reasonably sure that the underlying population is approximately normally distributed. Should she use a z-test or at-test in carrying out the analysis? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Population Standard Deviation
Dear JE,
Thanks for your speedy respond. Sorry i am very new in this. I believe this is about Hypothesis Testing question? May i know what are the things i lack off? JE McGimpsey wrote: This really isn't an XL question. One key is the sample size... You may want to look at a beginning statistics textbook. Dear Experts, [quoted text clipped - 8 lines] approximately normally distributed. Should she use a z-test or at-test in carrying out the analysis? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200902/1 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Population Standard Deviation
Since the question asks only which test to use, it appears to me that
you lack a good understanding of z-tests and t-tests, and when to apply each. In addition to any introductory statistics text book, you may have access to, you could try: http://wikipedia.org/wiki/Z-test and http://wikipedia.org/wiki/Student's_t-test In article <9135b5b574222@uwe, "roystonteo via OfficeKB.com" <u48590@uwe wrote: I believe this is about Hypothesis Testing question? May i know what are the things i lack off? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Population Standard Deviation
roystonteo -
For classical statistical inference regarding the population mean, the t distribution is appropriate when the sample is used to estimate the unknown population standard deviation (and you are willing to assume that the population values are normally distributed). For that situation, the t distribution can be used for any sample size. For large sample sizes, the t distribution can be approximated by the normal distribution. The usual guideline has been "30 or more." - Mike Middleton Web http://www.MikeMiddleton.com "roystonteo via OfficeKB.com" <u48590@uwe wrote in message news:9135401846fe4@uwe... Dear Experts, I will need your kind assistance on this. I am very new towards Excel Functions, hope you have the patience for me. Thank you in advance. The question is: A Researcher wants to carry out a test involving the mean for a sample of size n = 18. She does not know the true value of population standard deviation, but is reasonably sure that the underlying population is approximately normally distributed. Should she use a z-test or at-test in carrying out the analysis? -- Message posted via http://www.officekb.com |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Population Standard Deviation
Dear JE,
You are right that i have a lack of understanding of z-tests and t-test. That is the purpose, i am checking if anybody can guide me along this question. I need to get it done by today or else i will get killed.. JE McGimpsey wrote: Since the question asks only which test to use, it appears to me that you lack a good understanding of z-tests and t-tests, and when to apply each. In addition to any introductory statistics text book, you may have access to, you could try: http://wikipedia.org/wiki/Z-test and http://wikipedia.org/wiki/Student's_t-test I believe this is about Hypothesis Testing question? May i know what are the things i lack off? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200902/1 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Population Standard Deviation
Dear Middleton,
Thanks for your general introduction. I have just stepped into a new room, which i still need time to pick up, but i do not have the luxury of time as i need to complete this question within today. Any idea to help me, your help will be very much appreciated. Mike Middleton wrote: roystonteo - For classical statistical inference regarding the population mean, the t distribution is appropriate when the sample is used to estimate the unknown population standard deviation (and you are willing to assume that the population values are normally distributed). For that situation, the t distribution can be used for any sample size. For large sample sizes, the t distribution can be approximated by the normal distribution. The usual guideline has been "30 or more." - Mike Middleton Web http://www.MikeMiddleton.com Dear Experts, [quoted text clipped - 8 lines] approximately normally distributed. Should she use a z-test or at-test in carrying out the analysis? -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
standard deviation | Charts and Charting in Excel | |||
Standard deviation | Excel Discussion (Misc queries) | |||
standard deviation | Excel Worksheet Functions | |||
standard deviation | Excel Discussion (Misc queries) | |||
Standard Deviation | Excel Worksheet Functions |