University of Maryland Global Campus Statistics Worksheet

Attached is the discussion post. If you read you’ll have 2 classmate responses but it is stated what you have to use for the response in the word document. Attached is a full dicussion topic, one is a example step by step for you and lastly is wk1-2 discussion excel that you will be using for this assignment. Below is just a piece of the discussion. Please open document to see the restA 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 4