# Statistical Inference

### Chi Square Goodness of Fit Test in Excel (Part 1)

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

### Two Sample t-Test in EXCEL: Unequal 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 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".

### Two Sample t-Test in EXCEL: Equal 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".

### Inference on the variance of a normal population in EXCEL

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).

### Inference on the mean of a population (variance unknown) in EXCEL

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).

### Confidence Interval For The Difference Of Two Means With Unequal Standard Deviations in EXCEL

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

### Confidence Interval For The Difference Of Two Means With Equal Standard Deviations in EXCEL

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

### Confidence Interval For The Difference Of Two Means With Known Standard Deviations in EXCEL

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

### Chi Square Test of Independence with MS Excel

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.

### Chi Square Goodness of Fit Test in Excel (Part 2)

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

### F-test two sample for variances

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".

### Paired Sample T-Test in EXCEL

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."

### z-Test: Two-Sample for Means in EXCEL

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".

### Hypothesis testing in EXCEL

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.

### Confidence Intervals in EXCEL (Summary)

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.

### Statistics, Sample Distributions and Point Estimates in EXCEL

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.

### The Central Limit Theorem in EXCEL

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.

### Type II error and operating-characteristic curve in EXCEL

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).

### Significance level (0.05) and confidence level (95%) in EXCEL

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

### Analysis ToolPak in EXCEL

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

### Inference on the mean of a population (variance known) in EXCEL

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).

### Confidence Interval for the Variance in EXCEL

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

### Confidence interval for the Mean (Variance unknown) in EXCEL

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

### Confidence interval for the Mean (Variance known) in EXCEL

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