Question

Question 7 (1 point) Questions 6-10 is one hypothesis testing problem using an Excel data called vacation. We want to know if


C 3 Last year od 11 A B 1 Vacation Budget 2 This year 4 1123 960 5 954 400 6 2500 850 7 1200 750 900 720 9 900 600 10 2134 13
0 0
Add a comment Improve this question Transcribed image text
Answer #1

ans Q7) :

Last year This year
1123 960
954 400
2500 850
1200 750
900 720
900 600
2134 1300
590 650
800 500
1200 0
460 2100
750 800
1900 1000
2400 1000
3740 840

from the given data we calculate sample means and sample standard deviation

\small \bar{X}1 =1436.73

\small \bar{X}2 = 831.33

s1=911.51

s2 = 462.63

n1= 15

n2=15

Claim that there is difference between the average individual vacation budget of this year and that of last year

and here we assume that population variance are unequal

Let \small \mu 1 : Average individual vacation budget of this year

\small \mu2 : Average individual vacation budget that of last year

Test of Hypothesis :

To Test :

H0 :µ1- µ2 versus H1 : µ1 \small \neq µ2  

Test Statistic

X1 X2 t= s12 n1 + s22 n2

1436.73 – 831.33 t= 911.512 15 + 462.632 15

t = 2.29

Ans : The test statistic is t = 2.29

a) 2.29

Ans Q.8)

Claim that there is difference between the average individual vacation budget of this year and that of last year

and here we assume that population variance are unequal

Let \small \mu 1 : Average individual vacation budget of this year

\small \mu2 : Average individual vacation budget that of last year

Test of Hypothesis :

To Test :

H0 :µ1- µ2 versus H1 : µ1 \small \neq µ2  

here we have to use two tailed t test for the difference between population mean

Now to calculate  the critical value

given that \small \alpha = 0.05

df = 20.76

then critical value = t20.76,0.05 = 2.081

Critical region is If | t | > t20.76,0.05 then reject null hypothesis

critical value = 2.08

Ans : critical value = \small \pm 2.08

a) \small \pm 2.08

Add a comment
Know the answer?
Add Answer to:
Question 7 (1 point) Questions 6-10 is one hypothesis testing problem using an Excel data called...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Question 9 (1 point) Questions 6-10 is one hypothesis testing problem using an Excel data called...

    Question 9 (1 point) Questions 6-10 is one hypothesis testing problem using an Excel data called vacation. We want to know if there is a difference between the average individual vacation budget of this year and that of last year. We collected two independent samples of 15 individuals' vacation from each year. We assume population variances are unequal. You already downloaded the data file in Question 6, so you do not have to open it again. Just run a correct...

  • Question 6 (1 point) Questions 6-10 is one hypothesis testing problem using an Excel data called...

    Question 6 (1 point) Questions 6-10 is one hypothesis testing problem using an Excel data called vacation. Click the file name to download the Excel data file. We want to know if there is a difference between the average individual vacation budget of this year and that of last year. We collected two independent samples of 15 individuals' vacation from each year. We assume population variance are not equal. What is the null hypothesis? O a) H1-H2 = 0 Ob)...

  • Question 4 (1 point) (Quesitons 1-5 are in one hypothesis testing problem using Teaching Methodology data)....

    Question 4 (1 point) (Quesitons 1-5 are in one hypothesis testing problem using Teaching Methodology data). A teacher of statistics wants to know if a new teaching methodology that includes IT is efficient in terms of increased average score. He took a class with old methodology and a class with new methodology for samples and gave a same test. Once you opened the file in question 1 and ran Excel, you need not open it again. Just use the Excel...

  • Question 2 (1 point) (Quesitons 1-5 are in one hypothesis problem using Teaching Methodology data) A...

    Question 2 (1 point) (Quesitons 1-5 are in one hypothesis problem using Teaching Methodology data) A teacher of statistics wants to know if a new teaching methodology that includes IT is efficient in terms of increased average score. He took a class with old methodology and a class with new methodology for samples and gave a same test. Once you opened the file in question 1 and ran Excel, you need not open it again. Just use the Excel output...

  • Question 1 (1 point) ✓ Saved (Quesitons 1-5 are in one hypothesis testing using Teaching Methodology...

    Question 1 (1 point) ✓ Saved (Quesitons 1-5 are in one hypothesis testing using Teaching Methodology data). Click the data file name to download the data A teacher of statistics wants to know if a new teaching methodology that includes IT is efficient in terms of increased average score. He took a class with old methodology and a class with new methodology for samples and gave a same test. Open the file by clicking the file name above. Once you...

  • Question 2 (1 point) (Quesitons 1-5 are in one hypothesis problem using Teaching Methodology data). A...

    Question 2 (1 point) (Quesitons 1-5 are in one hypothesis problem using Teaching Methodology data). A teacher of statistics wants to know if a new teaching methodology that includes IT is efficient in terms of increased average score. He took a class with old methodology and a class with new methodology for samples and gave a same test. Once you opened the file in question 1 and ran Excel, you need not open it again. Just use the Excel output...

  • ten * Excel File Insert Data Review Home X Cut View 10 A Help - A...

    ten * Excel File Insert Data Review Home X Cut View 10 A Help - A A E LU Tell me what you want to do = = 29 Wrap Text E Merge & Center - Alignment Copy - Paste BTUR Format Painter Clipboard Undo FE 1 Expectations Theory 3 4 4-yr. Treasury security yield 6-yr. Treasury security yield 5.75% 730% Formulas 6 7 8 9 Algebraic solution: Total return eamed on 6-year securities Total return eamed on 4 year...

  • Week 10b - Ch23 Comparing Two Proportions: Problem 6 Previous Problem List Next (1 point) (a)...

    Week 10b - Ch23 Comparing Two Proportions: Problem 6 Previous Problem List Next (1 point) (a) Find the size of each of two samples (assume that they are of equal size) needed to estimate the difference between the proportions of boys and girls under 10 years old who are afraid of spiders. Assume the 'worst case scenario for the value of both sample proportions. We want a 98% confidence level and for the error to be smaller than 0.07. Answer:...

  • please this question is giving me problem. please help me to solve for it .please Excel...

    please this question is giving me problem. please help me to solve for it .please Excel Online Structured Activity: Lease versus Buy Sadik Industries must install $1 million of new machinery in its Texas plant. It can obtain a bank loan for 100% of the required amount. Alternatively, a Texas investment banking firm that represents a group of investors believes that it can arrange for a lease financing plan. Assume that these facts apply: 1. The equipment falls in the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT