All posts must 100% original work. no plagiarism. Post results must be provided using Excel. MAKE SURE YOU INTERPRET YOUR RESULTS ON A WORD DOCUMENT LISTING EACH CALCULATION BY STEPS FOR PEERS TO UNDERSTAND THE CALCULATION. Attach is the Forum 2 excel for the calculation.
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 Forum 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 Forum 2 NOT the new SD you found during Forum 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 Forum 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.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more