Can you please answer questions 5-7 and show properly how to do it on excel and how to write the answers Exercise 1:Step 1. Test Set-upThe average family home in Dry Gulch, Arizona uses 69 gallons of water a day (u = 69), and the populationstandard deviation is presumed to be 8 gallons per day (o = 8). The town leaders want to reduce waterconsumption. They have instituted a study of new equipment designed to reduce water consumption. Thenew equipment is installed in 100 homes. The research question: Does the new equipment reduce waterconsumption? Test at a 5% significance level. Here are the average daily gallons of water consumed in thetest homes:Assignment04.pdfPage 1 of 5Assignment 4: Chapters 13 & 14Daily Water Use is Gallons69 65 64 66 67 63 69 68 70 6563 65 68 66 66 67 73 71 69 6767 67 68l 73 66 66 66| 65| 69] 6063 69 65 66 65 68 68 69 66 7066 63 65 63 67 62 62 69 67 6964 64 66 69 61 69 69 66 68 6771 65 67 63 65 60 67 67 69 6565 66 64 60 68 69 66 67 65 6666 69 67 64 68 66 63 65 74 6867 65 68 64 69 68 65 67 72 67Question 1: Sample SizeCohen's d effect size is estimated at 0.25, which is a small effect. See the table below:Cohen's d ESThresholdsSmall0.2Medium 0.5Large0.8Using the Statistics Kingdom sample size calculator run an a priori statistical power calculation. Will a sampleof 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 appropriationbox:Yes NoQuestion 2: What test statistic should you use and why? Place an X in the correct box. Providethe reason for your answer below the checklist.CheckCorrectTestTestz-test for the population mean, µt-test for the population mean, µz-test for the population proportion, nAnswer: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.CheckCorrectTestTailsLeft-tailTwo-tailsRight-tailAnswer:Step 2. Select the Level of Significance, aA 5 percent significance level has been selected. Use the Excel file Finding_ CVs_p-values.xlsx to findthe critical value or values. Report the critical value or values here:Question 4: What is (are) the critical values(s)?Answer: 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 andmathematical symbols. You can copy the correct symbols from this table and paste them above.%3D

Question

Can you please answer questions 5-7 and  show properly how to do it on excel and how to write the answers Exercise 1:Step 1. Test Set-upThe average family home in Dry Gulch, Arizona uses 69 gallons of water a day (u = 69), and the populationstandard deviation is presumed to be 8 gallons per day (o = 8). The town leaders want to reduce waterconsumption. They have instituted a study of new equipment designed to reduce water consumption. Thenew equipment is installed in 100 homes. The research question: Does the new equipment reduce waterconsumption? Test at a 5% significance level. Here are the average daily gallons of water consumed in thetest homes:Assignment04.pdfPage 1 of 5Assignment 4: Chapters 13 & 14Daily Water Use is Gallons69 65 64 66 67 63 69 68 70 6563 65 68 66 66 67 73 71 69 6767 67 68l 73 66 66 66| 65| 69] 6063 69 65 66 65 68 68 69 66 7066 63 65 63 67 62 62 69 67 6964 64 66 69 61 69 69 66 68 6771 65 67 63 65 60 67 67 69 6565 66 64 60 68 69 66 67 65 6666 69 67 64 68 66 63 65 74 6867 65 68 64 69 68 65 67 72 67Question 1: Sample SizeCohen's d effect size is estimated at 0.25, which is a small effect. See the table below:Cohen's d ESThresholdsSmall0.2Medium 0.5Large0.8Using the Statistics Kingdom sample size calculator run an a priori statistical power calculation. Will a sampleof 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 appropriationbox:Yes NoQuestion 2: What test statistic should you use and why? Place an X in the correct box. Providethe reason for your answer below the checklist.CheckCorrectTestTestz-test for the population mean, µt-test for the population mean, µz-test for the population proportion, nAnswer: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.CheckCorrectTestTailsLeft-tailTwo-tailsRight-tailAnswer:Step 2. Select the Level of Significance, aA 5 percent significance level has been selected. Use the Excel file Finding_ CVs_p-values.xlsx to findthe critical value or values. Report the critical value or values here:Question 4: What is (are) the critical values(s)?Answer: 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 andmathematical 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 examplesshown 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 theeffect size.Question 6:Answer (Paste your work from Excel here.):z-value =p-value =Cohen's d ES =Interpretation of ESStep 6: Decide and Report. Your report show cover what your findings mean, whether the test haspractical significance, and whether the test has sufficient statistical power or is under or overpowered. Do not use the personal pronoun “I&#34; in your report.Question 7:Answer:Exercise 2Step 1. Test Set-upTony V. owns a house painting business in Seattle. Based in his data, that it takes his crew three-and-a-halfdays to paint the interior of a typical house (µ = 3.5). He has no estimate of the population standarddeviation, o. He is testing a new paint that is supposed to dry faster than the paint he has been using for overthirty years. The new paint is just as good as the old paint and costs the same. Research Question: Does thenew paint allow Tony to complete a house painting job faster than the paint he has been using?Question 1: Sample SizeCohen's d effect size is estimated at 0.25, which is a small effect. See the table below:Cohen's d ESThresholdsSmallMediumLarge0.20.50.8Using the Statistics Kingdom sample size calculator run an a priori statistical power calculation. Will a sampleof 100 be large enough to achieve 80% statistical power. Link: https://www.statskingdom.com/sample size t z.html.

Accepted Answer

Given Information:
Hypothesized value of population mean μ=69
Population standard deviation σ=8…