I’m working on a statistics discussion question and need guidance to help me understand better.

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.

Instructions

Scenario (information repeated for deliverable 01, 03, and 04)

A major client of your company is interested in the salary distributions of jobs in the state of Minnesota that range from $30,000 to $200,000 per year. As a Business Analyst, your boss asks you to research and analyze the salary distributions. You are given a spreadsheet that contains the following information:

• A listing of the jobs by title
• The salary (in dollars) for each job
• 
  
  You have previously explained some of the basic statistics to your client already, and he really liked your work. Now he wants you to analyze the confidence intervals.

  Background information on the Data

  The data set in the spreadsheet consists of 364 records that you will be analyzing from the Bureau of Labor Statistics. The data set contains a listing of several jobs titles with yearly salaries ranging from approximately $30,000 to $200,000 for the state of Minnesota.

  What to Submit

  Your boss wants you to submit the spreadsheet with the completed calculations, answers, and analysis.

1. In your textbook, Essential Statistics, review:
   1. Chapter 6, Section 1: “The Standard Normal Distribution”
   2. Chapter 6, Section 2: “Real Applications of Normal Distributions”
2. Watch the following videos explaining the Excel skills you will need to complete the problems. Note that the version of Excel presented in the video may differ from the one you are using.
   1. “Normal Distribution Lecture”
   2. “Normal Dist Functions A”
   3. “Normal Dist Functions B”
3. Complete the 10 problems in the file WS3Homework (Excel). Each problem is on a separate tab (worksheet)

Topics: Logic, integers, sets and functions, prime numbers, relations, real and complex
numbers, greatest common divisor and modular arithmetic, infimum and supremum, sequences,
limits of sequences, functions and limits of functions, continuity, groups.