View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
IC Data IC Data is offline
external usenet poster
 
Posts: 3
Default margin of error formula

The blanks are part of the data, just incomplete. I want to be able to
assume a confidence level that the mean of the dataset would not waver if the
blanks were indeed complete.

"bj" wrote:

I do not understand your question,
how are you calculating margin of error and confidence level if you ignore
the blanks?
how do you want the blanks treated?


"IC Data" wrote:

Hello,
I have file with a total size of 1438. However, 919 of the total are blank.
I am doing an analysis on the 519 good items, but I also want to include a
margin of error and/or confidence level that includes the blanks.

How would I accomplish this?