Exercise 1: Step 1. Test Set-up The average family home in Dry Gulch, Arizona uses 69 gallons of water a day (u = 69), and the population standard deviation is presumed to be 8 gallons per day (o =...

Can you please answer questions 5-7 and show properly how to do it on excel and how to write the answers


Extracted text: Exercise 1: Step 1. Test Set-up The average family home in Dry Gulch, Arizona uses 69 gallons of water a day (u = 69), and the population standard deviation is presumed to be 8 gallons per day (o = 8). The town leaders want to reduce water consumption. They have instituted a study of new equipment designed to reduce water consumption. The new equipment is installed in 100 homes. The research question: Does the new equipment reduce water consumption? Test at a 5% significance level. Here are the average daily gallons of water consumed in the test homes: Assignment04.pdf Page 1 of 5 Assignment 4: Chapters 13 & 14 Daily Water Use is Gallons 69 65 64 66 67 63 69 68 70 65 63 65 68 66 66 67 73 71 69 67 67 67 68l 73 66 66 66| 65| 69] 60 63 69 65 66 65 68 68 69 66 70 66 63 65 63 67 62 62 69 67 69 64 64 66 69 61 69 69 66 68 67 71 65 67 63 65 60 67 67 69 65 65 66 64 60 68 69 66 67 65 66 66 69 67 64 68 66 63 65 74 68 67 65 68 64 69 68 65 67 72 67 Question 1: Sample Size Cohen's d effect size is estimated at 0.25, which is a small effect. See the table below: Cohen's d ES Thresholds Small 0.2 Medium 0.5 Large 0.8 Using the Statistics Kingdom sample size calculator run an a priori statistical power calculation. Will a sample of 100 be large enough to achieve 80% statistical power. Link: https://www.statskingdom.com/sample size t zhtml. . Will a sample of 100 homes achieve 80% or more statistical power? Place and X in the appropriation box: Yes No Question 2: What test statistic should you use and why? Place an X in the correct box. Provide the reason for your answer below the checklist. Check Correct Test Test z-test for the population mean, µ t-test for the population mean, µ z-test for the population proportion, n Answer: Question 3: Based on the research question is this a left-tailed, two-tailed, or right-tailed test? Place an X in the correct box. Provide the reason for your answer below the checklist. Check Correct Test Tails Left-tail Two-tails Right-tail Answer: Step 2. Select the Level of Significance, a A 5 percent significance level has been selected. Use the Excel file Finding_ CVs_p-values.xlsx to find the critical value or values. Report the critical value or values here: Question 4: What is (are) the critical values(s)? Answer:


Extracted text: Step 3. State the null hypothesis (Ho) and alternate hypothesis (H1) Question 5: Но: H1: Follow the examples shown in Clear-Sighted Statistics. You must use the appropriate Greek letters and mathematical symbols. You can copy the correct symbols from this table and paste them above. %3D < n² | x² step 4. compose the decision rule using critical values not p-values. follow the examples shown in clear-sighted statistics. question 6: answer: step 5. calculate the value of the test statistic, p-value, and cohen's d effect size. interpret the effect size. question 6: answer (paste your work from excel here.): z-value = p-value = cohen's d es = interpretation of es step 6: decide and report. your report show cover what your findings mean, whether the test has practical significance, and whether the test has sufficient statistical power or is under or over powered. do not use the personal pronoun “i" in your report. question 7: answer: exercise 2 step 1. test set-up tony v. owns a house painting business in seattle. based in his data, that it takes his crew three-and-a-half days to paint the interior of a typical house (µ = 3.5). he has no estimate of the population standard deviation, o. he is testing a new paint that is supposed to dry faster than the paint he has been using for over thirty years. the new paint is just as good as the old paint and costs the same. research question: does the new paint allow tony to complete a house painting job faster than the paint he has been using? question 1: sample size cohen's d effect size is estimated at 0.25, which is a small effect. see the table below: cohen's d es thresholds small medium large 0.2 0.5 0.8 using the statistics kingdom sample size calculator run an a priori statistical power calculation. will a sample of 100 be large enough to achieve 80% statistical power. link: https://www.statskingdom.com/sample size t z.html. n²="" |="" x²="" step="" 4.="" compose="" the="" decision="" rule="" using="" critical="" values="" not="" p-values.="" follow="" the="" examples="" shown="" in="" clear-sighted="" statistics.="" question="" 6:="" answer:="" step="" 5.="" calculate="" the="" value="" of="" the="" test="" statistic,="" p-value,="" and="" cohen's="" d="" effect="" size.="" interpret="" the="" effect="" size.="" question="" 6:="" answer="" (paste="" your="" work="" from="" excel="" here.):="" z-value="p-value" =="" cohen's="" d="" es="Interpretation" of="" es="" step="" 6:="" decide="" and="" report.="" your="" report="" show="" cover="" what="" your="" findings="" mean,="" whether="" the="" test="" has="" practical="" significance,="" and="" whether="" the="" test="" has="" sufficient="" statistical="" power="" or="" is="" under="" or="" over="" powered.="" do="" not="" use="" the="" personal="" pronoun="" “i"="" in="" your="" report.="" question="" 7:="" answer:="" exercise="" 2="" step="" 1.="" test="" set-up="" tony="" v.="" owns="" a="" house="" painting="" business="" in="" seattle.="" based="" in="" his="" data,="" that="" it="" takes="" his="" crew="" three-and-a-half="" days="" to="" paint="" the="" interior="" of="" a="" typical="" house="" (µ="3.5)." he="" has="" no="" estimate="" of="" the="" population="" standard="" deviation,="" o.="" he="" is="" testing="" a="" new="" paint="" that="" is="" supposed="" to="" dry="" faster="" than="" the="" paint="" he="" has="" been="" using="" for="" over="" thirty="" years.="" the="" new="" paint="" is="" just="" as="" good="" as="" the="" old="" paint="" and="" costs="" the="" same.="" research="" question:="" does="" the="" new="" paint="" allow="" tony="" to="" complete="" a="" house="" painting="" job="" faster="" than="" the="" paint="" he="" has="" been="" using?="" question="" 1:="" sample="" size="" cohen's="" d="" effect="" size="" is="" estimated="" at="" 0.25,="" which="" is="" a="" small="" effect.="" see="" the="" table="" below:="" cohen's="" d="" es="" thresholds="" small="" medium="" large="" 0.2="" 0.5="" 0.8="" using="" the="" statistics="" kingdom="" sample="" size="" calculator="" run="" an="" a="" priori="" statistical="" power="" calculation.="" will="" a="" sample="" of="" 100="" be="" large="" enough="" to="" achieve="" 80%="" statistical="" power.="" link:="" https://www.statskingdom.com/sample="" size="" t="">