Question

You are working in a bakery, and want to determine if you can use all whole-wheat flour (cheaper, Receipe A) or if you need to continue to use half whole wheat, half almond flour (Recipe B) in one of your popular loaf offerings. You ran some test loaves using Recipe A, and then cleaned your mixing bowls and ran some more test loaves using Recipe B. The measurement in question is the height of your loaves in cm after baking; all other ingredients and baking parameters remain the same. You have run a test and taken the following data. Assume equal variances. You want to test at alpha = 0.05. • HO: Mean height of A = Mean height of B • HA: Mean height of A Mean height of B Here is your data: Observation A B 89 99 2 104 971 3 118 4 5 93 117 101 123 111 110 110 111 114 7 98 18 98 9 103 93 10 92 120 Use Excel to calculate your answers. (You will need to enter the data into Excel.) What is the test statistic value? Round your answer to two decimal places. What is your conclusion? Enter a 1 or a 2, as follows: 1 if you would Reject HO 2 if you would Not reject HO

Answer 1

Steps in excel:

1. Input the data in three columns as given in the question.
2. Next, click Data Analysis on the Data tab.
3. From the popup you got , choose t-Test: Two-Sample Assuming Equal Variances. (as in the sample we are given to assume equal variances )
4. Under Input, select the ranges for both A and B. (I have provided a picture below )
5. In Hypothesized Mean Difference, enter 0.
6. Give Alpha value of 0.05,
7. Select the output range (anywhere except the places were you have written the data)
8. Click OK.

O Bookl - Microsoft Excel Home Insert Page Layout Formulas Data Review View Data Analysis Ed Connections Properties Get External Refresh Data All Go Edit Links Connections Clear Reapply Advanced Zde sort Filter Outline Text to Remove Columns Duplicates Data Tools Sort & Filter Analysis E2 Observation B с D E F G H J K А 1 Observation 2 А B 1 89 99 ? X 3 104 101 N 4 3 97 123 t-Test: Two-Sample Assuming Equal Variances Input Variable 1 Range: $B$2:$B$11 Variable 2 Range: $C$2:$C$11 OK 5 4 118 111 Cancel 6 5 93 110 7 5 117 110 Help 0 8 7 98 111 9 8 98 114 10 9 103 93 11 10 92 120 Hypothesized Mean Difference: Labels Alpha: 0.05 Output options Output Range: $E$2:$I$160 New Worksheet Ply: New Workbook 12 13 14 15 16 17 18 19 KI Sheet1 Point Sheet2 Sheet3 BE 100% NEW

OUTPUT:

t-Test: Two-Sample Assuming qual Variances Variable 1 Variable 2 Mean 100.9 109.2 Variance 97.87778 85.73333 Observati 10 10 Pooled Va 91.80556 Hypothesi 0 df 18 t Stat -1.937 P(T<=t) or 0.034301 t Critical o 1.734064 P(T<=t) tw 0.068603 t Critical t 2.100922

Test statistic value = -1.94

Here p-value for two tailed test is 0.0686

p-value> alpha (0.05)

Hence we fail to reject H₀ at level alpha (0.05)

Hence we would not reject H₀