Ms. Lisa Mannin is the budcet duccler fer NexuS ene Inc. She Would like to compere thhe deily trerel expense fr the soles sterf ond the eudif She collected the folloins Semple into, Medie 129 174 133 147 159 138 143
Contingency Table
A contingency table can be defined as the visual representation of the relationship between two or more categorical variables that can be evaluated and registered. It is a categorical version of the scatterplot, which is used to investigate the linear relationship between two variables. A contingency table is indeed a type of frequency distribution table that displays two variables at the same time.
Binomial Distribution
Binomial is an algebraic expression of the sum or the difference of two terms. Before knowing about binomial distribution, we must know about the binomial theorem.
Excel Procedure:
Enter the data for ‘sales’ and ‘Audit’ in Excel sheet>Data>Data Analysis>Select ‘t-Test: Two-Sample Assuming Equal Variances’ and click on ‘OK’>Select the column of ‘sales’ under ‘Variable 1 Range’>Select the column of ‘Audit’ under ‘Variable 2 Range’>Enter 0 under ‘Hypothesized Mean Difference’>Click on ‘OK’.
Excel Output:
From the output, the one sided critical value is 1.796.
Decision Rule:
Reject H0 if t>1.796
Step by step
Solved in 2 steps with 1 images