Question

1.) Using the level of significance of .10, test the claim that the average number of...

  • 1.) Using the level of significance of .10, test the claim that the average number of classes skipped by CLC students is less than 5. The sample data used to test the claim is as follows:
    2, 3, 6, 4, 1, 1, 7, 4, 3, 2, 0, 5, 0, 1, 2, 4, 0, 3, 6, 1, 3, 2, 2

    • Find the mean (=average(data))

    • Find sample standard deviation (=stdev.s(data))

    • Find the test value using TTest on your calculator.

    • Find the p-value using T.dist on Excel

    • Find the critical value using T.inv on Excel

    • State conclusion based on p-value

    • Translate conclusion (use complete sentence)

  • I NEED HELP SOLVING THIS ON AN EXCEL SHEET USING EXCEL FUNCTIONS PLEASE! IM REALLY CONFUSED!

Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Note: the letters in the formula indiactes the column numer & numbers indicates the row numbers

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
)Using level of significance of .05, test the claim that the soda preference for CLC students...
)Using level of significance of .05, test the claim that the soda preference for CLC students are not uniform. Soda Pepsi Diet Pepsi Mountain Dew Cherry Pepsi Root Beer Other Frequency 30 45 32 21 25 28 a. Place the Soda in column 1, place frequency in column 2, place expected frequency in column 3 , . Find the test value for this goodness of fit test using calculator and type it on Excel, Find the p-value for this goodness...
You wish to test the following claim ( H a ) at a significance level of...
You wish to test the following claim ( H a ) at a significance level of α = 0.02 . For the context of this problem, μ d = μ 2 − μ 1 where the first data set represents a pre-test and the second data set represents a post-test. H o : μ d = 0 H a : μ d < 0 You believe the population of difference scores is normally distributed, but you do not know the...
You wish to test the following claim ( H a ) at a significance level of...
You wish to test the following claim ( H a ) at a significance level of α = 0.02 . For the context of this problem, μ d = P o s t T e s t − P r e T e s t where the first data set represents a pre-test and the second data set represents a post-test. (Each row represents the pre and post test scores for an individual. Be careful when you enter your data...
You wish to test the following claim ( H a ) at a significance level of...
You wish to test the following claim ( H a ) at a significance level of α = 0.002 . H o : p 1 = p 2 H a : p 1 ≠ p 2 You obtain 16.2% successes in a sample of size n 1 = 395 from the first population. You obtain 18.3% successes in a sample of size n 2 = 613 from the second population. For this test, you should NOT use the continuity correction,...
You wish to test the following claim ( H a Ha ) at a significance level...
You wish to test the following claim ( H a Ha ) at a significance level of α = 0.001 α=0.001 . For the context of this problem, μ d = μ 2 − μ 1 μd=μ2-μ1 where the first data set represents a pre-test and the second data set represents a post-test       Ho:μd=0Ho:μd=0       Ha:μd<0Ha:μd<0 You believe the population of difference scores is normally distributed, but you do not know the standard deviation. You obtain pre-test and post-test...
You wish to test the following claim (HaHa) at a significance level of α=0.001α=0.001. For the...
You wish to test the following claim (HaHa) at a significance level of α=0.001α=0.001. For the context of this problem, μd=μ2−μ1μd=μ2-μ1 where the first data set represents a pre-test and the second data set represents a post-test.      Ho:μd=0Ho:μd=0 Ha:μd<0Ha:μd<0 You believe the population of difference scores is normally distributed, but you do not know the standard deviation. You obtain pre-test and post-test samples for n=50n=50 subjects. The average difference (post - pre) is ¯d=−6.7d¯=-6.7 with a standard deviation of...
You wish to test the following claim (HaHa) at a significance level of α=0.001α=0.001. For the...
You wish to test the following claim (HaHa) at a significance level of α=0.001α=0.001. For the context of this problem, the first data set represents a pre-test and the second data set represents a post-test. You'll have to be careful about the direction in which you subtract.      Ho:μd=0Ho:μd=0 Ha:μd>0Ha:μd>0 You believe the population of difference scores is normally distributed, but you do not know the standard deviation. You obtain pre-test and post-test samples for n=47n=47 subjects. The average difference...
You wish to test the following claim (H1) at a significance level of α=0.002. For the...
You wish to test the following claim (H1) at a significance level of α=0.002. For the context of this problem, d=x2−x1 where the first data set represents a pre-test and the second data set represents a post-test.       Ho:μd=0       H1:μd≠0 You believe the population of difference scores is normally distributed, but you do not know the standard deviation. You obtain pre-test and post-test samples for n=178 subjects. The average difference (post - pre) is ¯d=3.1with a standard deviation of the differences...
You wish to test the following claim (HaHa) at a significance level of α=0.002α=0.002. For the...
You wish to test the following claim (HaHa) at a significance level of α=0.002α=0.002. For the context of this problem, μd = PostTest − PreTest. Each row gives the scores of a single individual.       Ho:μd=0       Ha:μd<0 You believe the population of difference scores is normally distributed, but you do not know the standard deviation. You obtain the following sample of data: pre-test post-test 33.5 58.5 36.4 10.8 47.5 16.5 54.4 21.8 51.7 55.5 38.9 71.5 39.1 31.1 40.9...
You wish to test the following claim ( H 1 ) at a significance level of...
You wish to test the following claim ( H 1 ) at a significance level of α = 0.005 . H 0 : μ = 74.5 H 1 : μ > 74.5 You believe the population is normally distributed, but you do not know the standard deviation. You obtain a sample of size n = 15 with mean ¯ x = 86.8 and a standard deviation of s = 13.2 . What is the test statistic for this sample? (Report...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT