As a professional in the real world, you will need to research and understand various aspects of Business applications.  Basic statistical analysis can be used to gain an understanding of current problems.  This course project will assist you in applying basic statistical principles to a fictional scenario in order to impact the clients being served.   

A major client of your company is interested in the salary distributions of jobs in the state of Georgia that range from $40,000 to $120,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

The client needs the preliminary findings by the end of the day. So let’s get to work!!!!

The data set 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 $40,000 to $120,000 for the state of Georgia. 

1. Introduce your scenario and data set.
2. 
   
   • 
     
     • Provide a brief overview of the scenario you are given above and the data set that you will be analyzing.
     • Classify the variables in your data set.
     • 
       
       • Which variables are quantitative/qualitative?
       • Which variables are discrete/continuous?
       • Describe the level of measurement for each variable included in your data set.

2. Discuss the importance of the Measures of Center and the Measures of Variation.
3. 
   
   • What are the measures of center and why are they important?
   • What are the measures of variation and why are they important?

3. Calculate the measures of center and measures of variation. Interpret your results in context of the selected topic.
4. 
   
   • Mean
   • Median
   • Mode
   • Midrange
   • Range
   • Variance
   • Standard Deviation

4. Discuss the importance of constructing confidence intervals for the population mean.
5. 
   
   • What are confidence intervals?
   • What is a point estimate?
   • What is the best point estimate for the population mean? Explain.
   • Why do we need confidence intervals?

5. Based on your selected topic, evaluate the following:
6. 
   
   • Find the best point estimate of the population mean.
   • Construct a 95% confidence interval for the population mean. Assume that your data is normally distributed and σ is unknown.
   • 
     
     • Please show your work for the construction of this confidence interval and be sure to use the Equation Editor to format your equations.
   • Write a statement that correctly interprets the confidence interval in context of your selected topic.

6. Based on your selected topic, evaluate the following:
7. 
   
   • Find the best point estimate of the population mean.
   • Construct a 99% confidence interval for the population mean. Assume that your data is normally distributed and σ is unknown.
   • 
     
     • Please show your work for the construction of this confidence interval and be sure to use the Equation Editor to format your equations.
   • Write a statement that correctly interprets the confidence interval in context of your selected topic.

7. 
   
   • Compare and contrast your findings for the 95% and 99% confidence interval.
   • 
     
     • Did you notice any changes in your interval estimate? Explain.
     • What conclusion(s) can be drawn about your interval estimates when the confidence level is increased? Explain.

8. Discuss the process for hypothesis testing.
9. 
   
   • Discuss the 8 steps of hypothesis testing?
   • When performing the 8 steps for hypothesis testing, which method do you prefer; P-Value method or Critical Value method? Why?

9. Perform the hypothesis test.
10. 
    
    • If you selected Option 1:
    • 
      
      • Original Claim: The average salary for all jobs in Georgia is less than $65,000.
      • Test the claim using α = 0.05 and assume your data is normally distributed and σ is unknown.
        
        
    • If you selected Option 2:
    • 
      
      • Original Claim: The average age of all patients admitted to the hospital with infectious diseases is less than 65 years of age.
      • Test the claim using α = 0.05 and assume your data is normally distributed and σ is unknown.
        
        
    • Based on your selected topic, answer the following:
    • 
      
      1. Write the null and alternative hypothesis symbolically and identify which hypothesis is the claim.
      2. Is the test two-tailed, left-tailed, or right-tailed? Explain.
      3. Which test statistic will you use for your hypothesis test; z-test or t-test? Explain.
      4. What is the value of the test-statistic? What is the P-value?
         What is the critical value?
      5. What is your decision; reject the null or do not reject the null?
      6. 
         
         1. Explain why you made your decision including the results for your p-value and the critical value.
      7. State the final conclusion in non-technical terms.

10. Conclusion
11. 
    
    • Recap your ideas by summarizing the information presented in context of your chosen scenario.

Answer rating: 100% (QA)

I am analyzing a data set that contains information on the salary distributions of jobs in the state of Georgia that range from 40000 to 120000 per year The data set consists of 364 records and includ... View the full answer