Question 1

Which of the following 2016 Excel functions computes the p-value for the chi-square test?

Accepted Answer

CHISQ.TEST is the Excel function used to compute the p-value for the chi-square test, which is used to determine if there is a significant association between two categorical variables.

Question 2

Which of the following is true while applying the Excel ANOVA tool?

Accepted Answer

The input range for the Excel ANOVA tool must be a rectangular region that includes all the data to be analyzed, ensuring that the tool can correctly interpret and process the data.

Question 3

In a two-sample test for means with the population variance being known, the z-test uses a test statistic that is based on the standard normal distribution.

Accepted Answer

In a two-sample test for means where the population variances are known, the z-test is appropriate and the test statistic is calculated based on the standard normal distribution.

Question 4

For a lower-tail test, the p-value in the output from an Excel tool:

Accepted Answer

For a lower-tail test, the p-value is directly interpreted from the output when the test statistic is negative, as it indicates the probability of observing a test statistic as extreme as, or more extreme than, the observed value under the null hypothesis.

Question 5

In conducting a hypothesis test, what is usually to be proven statistically is identified as the null hypothesis.

Accepted Answer

In conducting a hypothesis test, the null hypothesis represents what is assumed to be true before any evidence is collected, often a statement of no effect or no difference. The alternative hypothesis represents what one aims to support or prove statistically.

Question 6

For a two-sample test for means with the population variance being known, the Excel procedure used is the Excel z-test.

Accepted Answer

The Excel z-test is used for a two-sample test for means when the population variances are known, as it relies on the standard normal distribution.

Question 7

Which of the following Excel tools is used for a two-sample test for equality of variances?

Accepted Answer

The Excel F-test Two-sample for variances tool is specifically designed to compare the variances between two samples, making it the correct choice for a two-sample test for equality of variances.

Question 8

Use the data given below to answer the following questions).
The following extract from a manufacturer's database shows a sample of 10 suppliers, their transportation charges, and the estimated and actual total costs of supplying materials. Note: Assume a significance level of 0.05 wherever necessary.) $$\begin{array} { | l | c | c | c | } 
\hline \text { Supplier } & \begin{array} { c } 
\text { Transportation } \
\text { Charges }
\end{array} & \begin{array} { c } 
\text { Estirnated Total } \
\text { Cost }
\end{array} & \text { Actual Total Cost } \
\hline \text { Peter } & 340 & 4,500 & 4,680 \
\hline \text { Jdhry } & 560 & 4,500 & 4,790 \
\hline \text { Martin } & 480 & 4,500 & 5,110 \
\hline \text { Philip } & 290 & 4,500 & 4,780 \
\hline \text { Mark } & 370 & 4,500 & 4,810 \
\hline \text { Thomas } & 520 & 4,500 & 4,770 \
\hline \text { Jaison } & 350 & 4,500 & 5,250 \
\hline \text { David } & 430 & 4,500 & 4,930 \
\hline \text { Carter } & 510 & 4,500 & 5,010 \
\hline \text { Leonard } & 270 & 4,500 & 4,810 \
\hline
\end{array}$$
-Conduct the appropriate type of one-sample test-statistic to determine whether the average transportation charge is less than $430. Apply a decision rule using the observed level of significance and draw a conclusion.

Accepted Answer

The answer of Use the data given below to answer...

Question 9

Use the data given below to answer the following questions).
The following extract from a manufacturer's database shows a sample of 10 suppliers, their transportation charges, and the estimated and actual total costs of supplying materials. Note: Assume a significance level of 0.05 wherever necessary.) $$\begin{array} { | l | c | c | c | } 
\hline \text { Supplier } & \begin{array} { c } 
\text { Transportation } \
\text { Charges }
\end{array} & \begin{array} { c } 
\text { Estirnated Total } \
\text { Cost }
\end{array} & \text { Actual Total Cost } \
\hline \text { Peter } & 340 & 4,500 & 4,680 \
\hline \text { Jdhry } & 560 & 4,500 & 4,790 \
\hline \text { Martin } & 480 & 4,500 & 5,110 \
\hline \text { Philip } & 290 & 4,500 & 4,780 \
\hline \text { Mark } & 370 & 4,500 & 4,810 \
\hline \text { Thomas } & 520 & 4,500 & 4,770 \
\hline \text { Jaison } & 350 & 4,500 & 5,250 \
\hline \text { David } & 430 & 4,500 & 4,930 \
\hline \text { Carter } & 510 & 4,500 & 5,010 \
\hline \text { Leonard } & 270 & 4,500 & 4,810 \
\hline
\end{array}$$
-On studying the database, the manufacturer found out that the average difference between the estimated and actual total costs was $394. Based on the sample data, can the manufacturer conclude that the average difference between the estimated and actual total costs is different from zero?

Accepted Answer

The answer of Use the data given below to answer...

Question 10

Use the data given below to answer the following questions).
In a lower one-tailed hypothesis test, chosen level of significance = 0.10, sample size = 55, and t- test statistic = -1.76.
-Which of the following is the conclusion?

Accepted Answer

The critical value for a one-tailed test with 54 degrees of freedom at a 0.10 significance level is approximately -1.296. Since -1.76 is less than -1.296, the null hypothesis is rejected.

Question 11

Using the following data, test for the independence of the variables. Note: Assume a significance level of 0.05 wherever necessary.) $$\begin{array} { | c | c | c |} 
\hline \text { Respandent } & \text { Gender } & \text { Brealfast Preference } \
\hline 1 & \text { Fernale } & \text { Fruits } \
\hline 2 & \text { Male } & \text { Cereal } \
\hline 3 & \text { Male } & \text { Milk } \
\hline 4 & \text { Fernale } & \text { Fruits } \
\hline 5 & \text { Fernale } & \text { Milk } \
\hline 6 & \text { Male } & \text { Cereal } \
\hline 7 & \text { Male } & \text { Milk } \
\hline 8 & \text { Male } & \text { Milk } \
\hline 9 & \text { Fernale } & \text { Fruits } \
\hline
\end{array}$$ $$\begin{array} { | c | c | c | } 
\hline 10 & \text { Male } & \text { Fruits } \
\hline 11 & \text { Male } & \text { Cereal } \
\hline 12 & \text { Fernale } & \text { Cereal } \
\hline 13 & \text { Fernale } & \text { Milk } \
\hline 14 & \text { Male } & \text { Fruits } \
\hline 15 & \text { Female } & \text { Fruits } \
\hline
\end{array}$$

Accepted Answer

The answer of Using the following data, test for the...

Question 12

During a study, individuals were asked to rate a product on a scale of 1-5. From the following data, help the researcher determine whether any significant differences exist in opinions among individuals from different regions. Note: Assume a significance level of 0.05 wherever necessary.) $$\begin{array} { | c | c | c| } 
\hline \text { Quintasin } & \text { Paraland } & \text { Bayundera } \
\hline 3 & 1 & 5 \
\hline 4 & 4 & 1 \
\hline 2 & 2 & 3 \
\hline 5 & 2 & 2 \
\hline 1 & 3 & 2 \
\hline 5 & 5 & 5 \
\hline 3 & 5 & 1 \
\hline & 1 & 4 \
\hline & 4 & \
\hline & 2 & \
\hline
\end{array}$$

Accepted Answer

The answer of During a study, individuals were asked to...

Question 13

Which of the following tests is used to determine if two categorical variables are independent?

Accepted Answer

The Chi-square test is specifically designed to test the independence between two categorical variables, determining if there is a significant association between them.

Question 14

In order to reject the null hypothesis, the F-test statistic must be greater than the .

Accepted Answer

The F-test statistic must be greater than the F critical value (F crit) to reject the null hypothesis. The F critical value is determined based on the significance level and the degrees of freedom for the numerator and denominator.

Question 15

For a two-sample hypothesis which tests for differences in population parameters 1) and 2), a two-tailed test seeks evidence that:

Accepted Answer

The answer of For a two-sample hypothesis which tests for...

Question 16

In statistical terminology, the variable of interest is called a .

Accepted Answer

The variable of interest in a study or experiment is referred to as a "factor." Factors are the independent variables that researchers manipulate or observe to determine their effects on dependent variables.

Question 17

Which of the following is true about chi-square distribution?

Accepted Answer

The chi-square distribution is indeed characterized by its degrees of freedom, which essentially means the number of independent values or variables that have a role in the calculation of a statistic. This characteristic influences the shape of the chi-square distribution curve.

Question 18

If the alternative hypothesis includes the symbol <, the rejection region is in the upper tail.

Accepted Answer

When the alternative hypothesis includes the symbol <, it suggests that the research hypothesis is testing for a value that is less than a certain number, which means the rejection region is in the lower tail of the distribution.

Question 19

Use the data given below to answer the following questions).
The following extract from a manufacturer's database shows a sample of 10 suppliers, their transportation charges, and the estimated and actual total costs of supplying materials. Note: Assume a significance level of 0.05 wherever necessary.) $$\begin{array} { | l | c | c | c | } 
\hline \text { Supplier } & \begin{array} { c } 
\text { Transportation } \
\text { Charges }
\end{array} & \begin{array} { c } 
\text { Estirnated Total } \
\text { Cost }
\end{array} & \text { Actual Total Cost } \
\hline \text { Peter } & 340 & 4,500 & 4,680 \
\hline \text { Jdhry } & 560 & 4,500 & 4,790 \
\hline \text { Martin } & 480 & 4,500 & 5,110 \
\hline \text { Philip } & 290 & 4,500 & 4,780 \
\hline \text { Mark } & 370 & 4,500 & 4,810 \
\hline \text { Thomas } & 520 & 4,500 & 4,770 \
\hline \text { Jaison } & 350 & 4,500 & 5,250 \
\hline \text { David } & 430 & 4,500 & 4,930 \
\hline \text { Carter } & 510 & 4,500 & 5,010 \
\hline \text { Leonard } & 270 & 4,500 & 4,810 \
\hline
\end{array}$$
-Conduct the appropriate type of one-sample test-statistic to determine whether the average transportation charge is less than $430.

Accepted Answer

The answer of Use the data given below to answer...

Question 20

For a two-sample hypothesis test for differences in population parameters 1) and 2), which of the following is the correct form of an upper-tailed test?

Accepted Answer

In an upper-tailed test, the null hypothesis (H0) typically assumes that the difference between the two population parameters is less than or equal to zero, while the alternative hypothesis (H1) suggests that the difference is greater than zero. This is correctly represented in option D.

Quiz 7: Statistical Inference

Which of the following 2016 Excel functions computes the p-value for the chi-square test?

Which of the following is true while applying the Excel ANOVA tool?

In a two-sample test for means with the population variance being known, the z-test uses a test statistic that is based on the standard normal distribution.

For a lower-tail test, the p-value in the output from an Excel tool:

In conducting a hypothesis test, what is usually to be proven statistically is identified as the null hypothesis.

For a two-sample test for means with the population variance being known, the Excel procedure used is the Excel z-test.

Which of the following Excel tools is used for a two-sample test for equality of variances?

Use the data given below to answer the following questions) . In a lower one-tailed hypothesis test, chosen level of significance = 0.10, sample size = 55, and t- test statistic = -1.76. -Which of the following is the conclusion?

Which of the following tests is used to determine if two categorical variables are independent?

In order to reject the null hypothesis, the F-test statistic must be greater than the .

For a two-sample hypothesis which tests for differences in population parameters 1) and 2) , a two-tailed test seeks evidence that:

In statistical terminology, the variable of interest is called a .

Which of the following is true about chi-square distribution?

If the alternative hypothesis includes the symbol <, the rejection region is in the upper tail.

For a two-sample hypothesis test for differences in population parameters 1) and 2) , which of the following is the correct form of an upper-tailed test?