Statistical Inference

View application MS EXCEL Chi-square Pearson test for simple hypotheses.

Consider using MS EXCEL when testing statistical hypotheses about the difference of the average values of 2-distributions in the case of unknown variances (the variance in these 2 distributions are different). Compute the value of the test statistic t0*, consider the procedure "two-sample ttest" will calculate the P-value (P-value). Using add-ins the analysis ToolPak will make "two-sample t-test with different variances".

Consider using MS EXCEL when testing statistical hypotheses about the difference of the average values of 2-distributions in the case of unknown variances (the variance in these 2 distributions are the same). Compute the value of the test statistic t0 consider the procedure "two-sample ttest" will calculate the P-value (P-value). Using add-ins the analysis ToolPak will make "two-sample t test with equal variances".

Consider using MS EXCEL when testing statistical hypotheses about the variance of the normal distribution. Compute the test statistics ?2 and P-value (P-value).

Consider using MS EXCEL when testing statistical hypotheses about the average value of the distribution in the case of unknown variance. Compute test statistics t0 consider the procedure "test ttest" will calculate the P-value (P-value).

Construct a confidence interval for the difference of the average values of 2 distributions in case of unknown and unequal variances.

Construct a confidence interval for the difference of the average values of 2 distributions in case of unknown but equal variances.

Construct a confidence interval for the difference of the average values of 2 distributions with known variances.

test of independence Chi-square is used to determine the relationship between two categorical variables. Examples of pairs of categorical variables are: marital status vs. The level of employment of the respondents, Breed vs. The profession of the owner, the Level of s/n vs. Specialization engineer etc. When calculating tests of independence tested the hypothesis that between the variables there is no connection. Calculations will be done using MS EXCEL 2010 ХИ2.TEST() and the usual formulas.

View application MS EXCEL Chi-square Pearson test to composite hypotheses.

Consider using MS EXCEL when testing statistical hypotheses about the equality of variances of 2 normal distributions. Compute the value of the test statistic F0 consider the procedure "two-sample Ftest" will calculate the P-value (P-value), construct a confidence interval. Using add-ins the analysis ToolPak will make "two-sample F-test for dispersion".

Consider using MS EXCEL when testing statistical hypotheses about the difference of the average values of 2-distributions in the case of unknown variances (paired test). Compute the value of the test statistic t0 consider the procedure "two-sample ttest" will calculate the P-value (P-value). Using add-in analysis ToolPak will do "Paired two sample t-test for average."

Consider using MS EXCEL when testing statistical hypotheses about the difference of the average values of 2 distributions with known variances. Compute the value of the test statistic Z0 consider the procedure "two-sample z-test", compute P-value (P-value). Using add-ins the analysis ToolPak will make "two-sample z-test".

Here are links to articles about testing statistical hypotheses about the mean and variance of the distribution. Also considered the two-sample ztest ttest Ftest.

Here are links to articles about constructing confidence intervals to estimate the average and variance of the distribution. Also considers the construction of confidence intervals in the case of two samples.

the paper let us recall some notions of mathematical statistics: sample statistics, point estimation, sampling distribution. Demonstrate MS EXCEL convergence of certain statistical distributions to the normal distribution, the distribution of CHI-squared, student distribution and F- distribution.

will Show the main conclusions of the Central limit theorem MS EXCEL we build the sampling distribution of the average, calculate the standard error and compare the values obtained on a sample basis, with the findings of the CPT.

we Define the expression to calculate the error of the second kind and power of the test construct MS EXCEL curves operational characteristics of (Operating-characteristic curves).

Give the definition of terms level of reliability and the level of significance. Show how and where they are used MS EXCEL.

add-ins "analysis ToolPak" will help to simplify the calculations for statistical or engineering analysisfor.

Consider using MS EXCEL when testing statistical hypotheses about the average value of the distribution in the case of known variance. Compute test statistics Z0 consider the procedure "one-sample z-test", compute P-value (P-value).

Construct a confidence interval for estimating the variance of a random variable, distributed according to normal law, MS EXCEL.

Construct confidence interval to estimate the average values of the General population in the case of unknown variance.

built in MS EXCEL confidence interval to estimate the average value of the distribution in the case of known variance.