117k views
5 votes
Excel computes a two‑sample confidence interval for the difference in proportions just as well and as easily as Minitab and other statistical software.A. TrueB. False

User JSQuareD
by
6.1k points

1 Answer

5 votes

Answer:

See ecplanation below

Explanation:

False.

On the Data analysis tool from excel we can conduct the following procedures:

Anova: Single Factor

Anova: Two factor with replication

Anova: Two factor without replication

Correlation

Covariance

Descriptive statistics

Exponential smoothing

F-test Two sample for Variances

Fourier analysis

Histogram

Moving Average

Random number generation

Rank and percentile

Regression

Sampling

t test: Paired two sample for means

t tes: Two sample assuming equal variances

t test: Two sample Assuming Unequal Variances

z test: Two sample for means

And as we can see we don't have an specific procedure just to obtain confidence interval for the difference of proportions. We need to remember that if we select a z test in excel, for example the output will contain the confidence associated to the parameter, but for this case is not too easy obtain a confidence interval for the difference of proportion like on a statistical software as (Minitab, R, SAS, etc) since all of these statistical softwares are elaborated in order to conduct all the possible statistical tests and confidence intervals for parameters of interest.

User Gilgamesz
by
5.4k points