forestbas.blogg.se - Openoffice calc count non empty cells

Copy the 195 observations to the clipboard.

Visit NIST's Heat Flow Meter data set page.

In cell A1, type x to label the column.

You may substitute your own data with the proper modifications to the formulas (more on that later). Getting dataįor our tutorial, let's use the NIST data set Heat Flow Meter 1. Then, based on the data, they were able to estimate how well the sample (those polled in New Orleans) represents the population (everyone in New Orleans). A small note at the bottom of the article indicates the confidence level: "For poll results based on the total sample, one can say with 95 percent confidence that the margin of error is plus or minus 4 percentage points." CNN could not poll everyone, so they polled a sample. The purpose is to estimate the mean (average) of a population from a sample of the population.Īs a typical example CNN reported, "63 percent of respondents say should rebuild" after Hurricane Katrina ( September 2005).

When working with statistics, Calc is handy to calculate a confidence interval.