A town official claims that the average vehicle in their area sells for more than the 40th percentile of your data set. Using the data, you obtained in week 1, as well as the summary statistics you found for the original data set (excluding the super car outlier), run a hypothesis test to determine if the claim can be supported. Make sure you state all the important values, so your fellow classmates can use them to run a hypothesis test as well. Use the descriptive statistics you found during Week 2 NOT the new SD you found during Week 4. Because again, we are using the original 10 sample data set NOT a new smaller sample size. Use alpha = .05 to test your claim.(Note: You will want to use the function =PERCENTILE.INC in Excel to find the 40th percentile of your data set. Hopefully this Excel function looks familiar to you from Week 2.)First determine if you are using a z or t-test and explain why. Then conduct a four-step hypothesis test including a sentence at the end justifying the support or lack of support for the claim and why you made that choice.I encourage you to review the Week 6 Hypothesis Testing PDF at the bottom of the discussion. This will give you a step by step example on how to calculate and run a hypothesis test using Excel. I DO NOT recommend doing this by hand. Let Excel do the heavy lifting for you. You can also use this PDF in Quizzes section.There were 5 additional PDFs that were created to help you with the Homework, Lessons and Tests in Quizzes section. While they won't be used to answer the questions in the discussion, they are just as useful and beneficial. I encourage you to review these ASAP! These PDFs are also located at the bottom of the discussion Instructions: Make sure you include your data set in your initial post as well.

his Assignment has two parts. Part 1 has questions about forecasting. You will submit your answers for the first part using the Unit 6 Assignment template for Part 1.Part 2 requires you to analyze a case. For this, you will prepare a PowerPoint presentation to present your findings.The data you need for Part 2 is provided in an Excel file in the course. Make sure to use that file. Do not type anything manually from the case or use other sources for the data.View the Assignment Rubric for full Assignment details.Assignment RubricUse this spreadsheet to complete Part 2 of this Assignment.

Find the amplitude of the function below.y = 4 sinΘπ2π48==================Find the period of the function below.y = 4 sin Θπ2π4=================Find the period of the function below.π/2π2π4π=============Find the amplitude of the function below.y = 2 sin 4Θ24ππ/2================Which of the following functions is shown in the graph below?y = 2 tan Θy = 2 cot Θy = 2 cot (Θ/2)y = 2 tan (Θ/2)===============Which of the following functions is shown in the graph below?y = (1/3)sec 2Θy = 2 sec(Θ/3)y = 2 csc(Θ/3)y = (1/3)csc 2Θ=================Which of the following shows a graph of the function below?A.B.C.D.==================Which of the following graphs shows the function below?y = 2 sec xA.B.C.D.===============A marker buoy off the coast of Gulfport, Mississippi, bobs up and down with the waves. The distance between the highest and lowest point is 6 feet. The buoy moves from its highest point to its lowest point and back to its highest point every 8 seconds. Which of the following equations represents the motion of the buoy if it is at equilibrium when t = 0 and it is moving up from the normal water level.A. B. C. D. ===============A marker buoy off the coast of Gulfport, Mississippi, bobs up and down with the waves. The distance between the highest and lowest point is 6 feet. The buoy moves from its highest point to its lowest point and back to its highest point every 8 seconds. Which of the following graphs represents the motion of the buoy if it is at equilibrium when t = 0 and it is moving up from the normal water level.A.B.C.D.