Question

In: Math

(EXCEL) DATA 1 : Participant Before After 1 200 180 2 240 165 3 280 215...

(EXCEL) DATA 1 :

Participant Before After
1 200 180
2 240 165
3 280 215
4 200 220
5 190 145
6 230 250
7 195 175
8 230 185
9 210 140
10 190

172

THE QUESTIONS :

Q1\ The value of the test statisic ?

Q2\ The value of the p value of the test ?

Q3\ What is the H0 rejection region for the testing at the 1% level of significance ? t > ____

Q4/ interpret the result based on your Excel Outputs .

_________________________________________________________________

(EXCEL) DATA 2:

Group 1 Group 2 Group 3 Group 4

44 54 55 44

73 65 78 42

71 79 86 74

60 69 80 42

62 60 50 38

THE QUESTIONS :

Q1\ The value of the test statisic ?

Q2\ The value of the p value of the test ?

Q3\ What is the H0 rejection region for the testing at the 5% level of significance ? F >= ____

Q4/ interpret the result based on your Excel Outputs .

Solutions

Expert Solution

1)

Q1\ The value of the test statisic

Q2\ The value of the p value of the test;

Q3\ What is the H0 rejection region for the testing at the 1% level of significance :

for two tail test.

Q4/ interpret the result based on your Excel Outputs .

Therefore the result is not significant at 1% level of significance.

Therefore we fail to reject the null hypothesis and we do not have sufficient evidence to conclude that the participant has significance difference between before and after the participation.

in order to test whether the participant before after after has any significant change, we define the test hypothesis as:

null hypothesis as:

against the alternative hypothesis as:

( this is two tail test)

the test statistics is define as:

under the null hypothesis t distribution follows degree of freedom.

where and sample standard deviation is

Therefore the test statistics is determined as:

  

Now the t critical value at 1% level of significance at for two tail test is

Therefore the observed t statistics is less than the critical value of the t at 1% level of significance.

and the p value of the test statistics is:

Therefore the result is not significant at 1% level of significance.

Therefore we fail to reject the null hypothesis and we do not have sufficient evidence to conclude that the participant has significance difference between before and after the participation.

Excell output as follows:

2) In oredr to test the null hypothesis that each group has the same mean, we define the test hypothesis as:

against the alternative hypothesis as:

By applying ONE factor ANOVA we get the espected reslt as:

Q1\ The value of the test statisic:

Q2\ The value of the p value of the test:

Q3\ What is the H0 rejection region for the testing at the 5% level of significance:

Q4/ interpret the result based on Excel Outputs .

As

and the p value of the F statistics is

Therefore we reject the null hypothesis and we have sufficient evidence to conclude that the population mean of different groups is differ significantly at 5% level of significance.

t-2.929


Related Solutions

Pat.# Before After 1 195 125 IN EXCEL To the left is 2 datasets measured for...
Pat.# Before After 1 195 125 IN EXCEL To the left is 2 datasets measured for a sample of 107 patients with high colestrol level before and after taking medication. Obatin the following for both sets: 2 208 164 3 254 152 1- the mean, mode and median 4 226 144 5 290 212 2- the variance and standard deviation 6 239 171 7 216 164 3- First, second and third quartiles 8 286 200 9 243 190 10 217...
The Excel file Burglaries contains data on the number of burglaries before and after a Citizen...
The Excel file Burglaries contains data on the number of burglaries before and after a Citizen Police program. Apply the Descriptive Statistics tool to these data. Does Chebyshev’s theorem hold for the number of monthly burglaries before and after the citizen-police program? Data : Before Citizen-Police Program Month Monthly burglaries 1 60 2 44 3 37 4 54 5 59 6 69 7 108 8 89 9 82 10 61 11 47 12 72 13 87 14 60 15 64...
Person Height Weight 1 60 114 2 60 60 3 61 200 4 62 240 5...
Person Height Weight 1 60 114 2 60 60 3 61 200 4 62 240 5 63 133 6 63 220 7 64 104 8 65 135 9 65 120 10 65 123 11 66 113 12 66 205 13 66 54 14 67 170 15 67 186 16 67 198 17 67 132 18 68 142 19 69 150 20 69 188 21 70 199 22 70 201 23 70 106 24 71 112 25 71 115 26 72...
Chapter 9: Applying Excel Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1...
Chapter 9: Applying Excel Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales 40,000 60,000 100,000 50,000 70,000 80,000 • Selling price per unit $8 per unit • Accounts receivable, beginning balance $65,000 • Sales collected in the quarter sales are made 75% • Sales collected in the quarter after sales are made 25% • Desired ending finished goods inventory is 30% of the budgeted unit sales of the next quarter • Finished...
Chapter 8: Applying Excel Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1...
Chapter 8: Applying Excel Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales        40,000         60,000      100,000      50,000         70,000         80,000 • Selling price per unit $8 per unit • Accounts receivable, beginning balance $65,000 • Sales collected in the quarter sales are made 75% • Sales collected in the quarter after sales are made 25% • Desired ending finished goods inventory is 30% of the budgeted unit sales...
USE EXCEL TO SOLVE After heat treatment, the 2-cm thick metal plates (k = 180 W/m·K,...
USE EXCEL TO SOLVE After heat treatment, the 2-cm thick metal plates (k = 180 W/m·K, ρ = 2800 kg/m3, and cp = 880 J/kg·K) are conveyed through a cooling chamber with a length of 10 m. The plates enter the cooling chamber at an initial temperature of 500°C. The cooling chamber maintains a temperature of 10°C, and the convection heat transfer coefficient is given as a function of the air velocity blowing over the plates h = 33V0.8, where...
Use Excel to test. For each paired difference, compute After – Before. In Data Analysis, t-Test:...
Use Excel to test. For each paired difference, compute After – Before. In Data Analysis, t-Test: Paired Two Sample for means, select the After data for Variable 1 Range. Note that the critical value output by Data Analysis for this test is always positive. In this problem, the sign of the critical value is negative corresponding to 1-tailed test with lower reject region and negative lower critical value.                Person   Before   After    1   176   164   ...
Time(weeks): 0 |   2 |   6 | 10 Level: 210| 200 | 190| 180 1. The...
Time(weeks): 0 |   2 |   6 | 10 Level: 210| 200 | 190| 180 1. The table above gives the level of a person’s cholesterol at different times during a 10-week treatment period. What is the average level over this 10-week period obtained by using a trapezoidal approximation with the sub-intervals [0, 2], [2, 6], and [6, 10]? 2. Water is pumped out of a lake at the rate R(t)= 12 square root (t/(t+1) cubic meters per minute, where t...
Participant Stress Level (X) Test Score (Y) 1 18 6 2 3 17 3 12 9...
Participant Stress Level (X) Test Score (Y) 1 18 6 2 3 17 3 12 9 4 8 22 5 15 7 6 7 11 What's the slope of this data (round to two decimal places)? What's the Y intercept (round to two decimal places)? What's the predicted test score for a stress level of 10 (round to two decimal places)? What's the error of participant 5's score (round to two decimal places)? What's the standard error of the estimate?...
The following data are provided. (Nonlinear regression using excel) x 1 2 3 4 5 y...
The following data are provided. (Nonlinear regression using excel) x 1 2 3 4 5 y 2.2 2.8 3.6 4.5 5.5 Fit the model y=a+bx+c/x, where a, b and c are constants for the model. Perform nonlinear regression in EXCEL using solver to get model constants. Plot y model (model and data) vs x to see the quality of fit.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT