Business Finance
American Institute of Pharmaceutical Technology Null and Alternative Hypothesis Sheet

Question Description

I don’t understand this Excel question and need help to study.

I already did the problems I just need help stating the null and alternative. Attached is the requirements and the finished HW file.

1.Complete Problems 29 and 30

a. Question 29: Using the Excel file Facebook Survey, determine if the mean number of hours spent online per week is the same for males as it is for females.

b.Question 30: Determine if there is evidence to conclude that the mean number of vacations taken by married individuals is less than the number taken by single/divorced individuals using the data in the Excel file Vacation Survey. Use a level of significance of 0.05. Would your conclusion change if the level of significance were 0.01?

§For each hypothesis test, state the null and alternative hypotheses.

§For each hypothesis test, state whether you would reject or not reject the null hypothesis.

§For each hypothesis test, interpret the conclusion of the test in context.

§For each hypothesis test, use the unequal variances procedure

2.Complete Problem 38

a.Question 38: Using the data in the Excel file Ohio Education Performance, test the hypotheses that the mean difference in writing and reading scores is zero and that the mean difference in math and science scores is zero. Use the paired-sample procedure.

§State the null and alternative hypotheses.

§State whether you would reject or not reject the null hypothesis.

§Interpret the conclusion of the test in context.

Unformatted Attachment Preview

1. Complete Problems 29 and 30 a. Question 29: Using the Excel file Facebook Survey, determine if the mean number of hours spent online per week is the same for males as it is for females. b. Question 30: Determine if there is evidence to conclude that the mean number of vacations taken by married individuals is less than the number taken by single/divorced individuals using the data in the Excel file Vacation Survey. Use a level of significance of 0.05. Would your conclusion change if the level of significance were 0.01? ▪ For each hypothesis test, state the null and alternative hypotheses. ▪ For each hypothesis test, state whether you would reject or not reject the null hypothesis. ▪ For each hypothesis test, interpret the conclusion of the test in context. ▪ For each hypothesis test, use the unequal variances procedure 2. Complete Problem 38 a. Question 38: Using the data in the Excel file Ohio Education Performance, test the hypotheses that the mean difference in writing and reading scores is zero and that the mean difference in math and science scores is zero. Use the paired-sample procedure. ▪ State the null and alternative hypotheses. ▪ State whether you would reject or not reject the null hypothesis. ▪ Interpret the conclusion of the test in context. A. one tailed test Critical value -1.76 P-value 0.138 Hypothesis can't be rejected B. one tailed test Critical value 1.76 P-value 0.138 Hypothesis can't be rejected C. two tailed test Critical value 2.144 P-value 0.276 Hypothesis can't be rejected Student 1 2 5 6 7 9 10 11 12 14 17 19 22 23 24 25 27 28 31 33 Gender female female female female female female female female female female female female female female female female female female female female Hours online/week Friends 4 150 10 400 9 260 5 70 7 90 12 110 2 30 6 80 2 30 6 240 8 340 4 50 4 280 5 60 9 100 12 380 2 80 7 170 2 50 7 170 Student 3 4 8 13 15 16 18 20 21 26 29 30 32 Gender male male male male male male male male male male male male male Hours online/week Friends 7 120 15 500 5 250 3 200 6 150 4 90 10 450 4 120 6 180 8 430 6 90 4 50 5 70 t-Test: Two-Sample Assuming Unequal Variances Mean Variance Observations Hypothesized Mean Difference df t Stat P(T<=t) one-tail t Critical one-tail P(T<=t) two-tail t Critical two-tail Variable 1 Variable 2 6.15 6.38461538 10.02894737 10.2564103 20 13 0 26 -0.206535149 0.418990897 1.70561792 0.837981794 2.055529439 Age Gender Relationship Status Vacations per Number of Year Children 24 26 28 33 45 49 29 37 37 38 38 39 39 40 42 42 43 44 44 45 46 46 48 48 Male Female Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Married Married Married Married Married Married Married Married Married Married Married Married Married Married Married Married Married Married Married Married Married Married Married Married 2 4 2 4 2 1 4 1 5 1 2 1 5 2 2 1 2 2 3 2 2 2 1 5 0 0 2 0 0 2 0 2 1 5 2 4 2 3 3 3 1 2 2 2 4 3 3 2 24 26 28 32 34 37 39 46 49 50 Female Male Male Male Female Male Male Male Male Male Single/Divorced Single/Divorced Single/Divorced Single/Divorced Single/Divorced Single/Divorced Single/Divorced Single/Divorced Single/Divorced Single/Divorced 0 6 7 6 4 5 2 1 2 6 0 0 0 0 0 0 3 2 0 0 t-Test: Two-Sample Assuming Unequal Variances Variable 1 Variable 2 Mean 2.416666667 3.9 Variance 1.81884058 6.1 Observations 24 10 Hypothesized Mean Difference 0 df 11 t Stat -1.791202793 P(T<=t) one-tail 0.050391771 t Critical one-tail 1.795884819 P(T<=t) two-tail 0.100783543 t Critical two-tail 2.20098516 School District Writing Reading Math Indian Hill 95 98 Wyoming 98 96 Mason City 96 92 Madiera 94 95 Mariemont 99 92 Sycamore 85 88 Forest Hills 93 91 Kings Local 92 86 Lakota 90 88 Loveland 85 93 Southwest 92 82 Fairf ield 90 86 Oak Hills 88 86 Three Rivers 87 85 Milford 82 86 Ross 84 85 West Clermont 88 83 Reading 88 80 Princeton 83 75 Finneytown 79 71 Norwood 86 77 Lockland 88 79 Franklin City 85 79 Winton Woods 82 77 Northwest 75 74 North College Hill 77 76 Mount Healthy 87 72 Felicity Franklin 52 64 St. Bernard 81 59 Deer Park 69 66 Cincinnati Public 63 59 State Averages 79 79 89 86 85 88 74 80 73 78 73 72 73 71 75 66 72 66 63 58 59 61 64 52 49 55 51 50 40 52 40 40 35 60 Citizenship Science 95 93 94 82 89 87 85 82 85 86 78 83 77 84 82 75 73 76 76 67 75 82 70 65 62 66 62 81 41 43 50 72 91 87 86 88 88 84 88 78 81 86 73 77 79 77 76 78 70 75 63 62 67 64 67 59 61 57 53 64 48 52 44 68 All 83 81 72 69 68 68 67 64 64 61 58 57 57 56 53 52 48 46 46 45 44 41 40 40 38 35 32 28 26 25 23 46 t-Test: Paired Two Sample for Means Mean Variance Observations Pearson Correlation Hypothesized Mean Difference df t Stat P(T<=t) one-tail t Critical one-tail P(T<=t) two-tail t Critical two-tail Variable 1 84.75 97.6129032 32 0.79997661 0 31 3.13580736 0.00186853 1.69551878 0.00373706 2.03951345 t-Test: Paired Two Sample for Means Mean Variance Observations Pearson Correlation Hypothesized Mean Difference df t Stat P(T<=t) one-tail t Critical one-tail P(T<=t) two-tail t Critical two-tail Variable 1 64.0625 220.705645 32 0.93546557 0 31 -7.9781913 2.6171E-09 1.69551878 0.0000 2.03951345 Variable 2 81.21875 104.757056 32 Variable 2 71.59375 167.023185 32 ...
Purchase answer to see full attachment
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

Final Answer

Finished! here it is. I also added a conclusion using the critical value method so you have whole answers! If you enjoyed working with me do not hesitate to invite me to your future questions! Also a positive comment would be appreciated and tips are always welcomed (pls! jijij) !! :)D...

RebeccaG1910 (213)
Purdue University

Anonymous
Return customer, been using sp for a good two years now.

Anonymous
Thanks as always for the good work!

Anonymous
Excellent job

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Questions
Related Tags