Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 762
Default 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
Email
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



  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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
Email
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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
standard deviation [email protected] Charts and Charting in Excel 3 April 16th 08 01:04 AM
Standard deviation Svi Excel Discussion (Misc queries) 5 October 15th 07 10:13 AM
standard deviation ckatz Excel Worksheet Functions 1 October 25th 06 08:31 PM
standard deviation Arne Hegefors Excel Discussion (Misc queries) 7 August 6th 06 01:12 PM
Standard Deviation Carlos Excel Worksheet Functions 10 January 2nd 06 09:17 AM


All times are GMT +1. The time now is 04:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"