A Bachelor's Degree High School Diploma No High School Diploma 22.50 12.68 11.21 19.57 11.23 8.54...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A Bachelor's Degree High School Diploma No High School Diploma 22.50 12.68 11.21 19.57 11.23 8.54 24.13 19.53 12.52 27.23 9.85 9.06 27.00 15.76 14.21 28.60 12.31 13.40 16.85 12.27 11.46 22.70 8.57 11.22 26.69 11.06 9.56 20.14 11.47 9.43 21.33 13.38 10.98 18.33 9.85 10.41 17.86 12.35 11.73 20.47 10.68 8.28 21.08 10.70 8.59 17.05 11.54 13.30 21.70 13.55 7.91 22.19 17.80 12.28 23.80 15.70 10.72 22.30 17.50 15.97 22.42 6.50 10.58 22.29 8.98 9.59 27.43 12.14 10.92 23.14 8.83 9.70 22.84 13.02 7.64 21.86 8.90 10.39 29.32 13.80 4.62 26.00 21.67 13.04 30.53 8.74 6.29 21.44 7.47 10.27 Texas Workforce Commission Case Study GBA 305 Statistical Methods of Business I Texas is home to more than one million undocumented immigrants, and most of them are stuck in low-paying jobs. Meanwhile, the state also suffers from a lack of skilled workers. The Texas Workforce Commission estimates that 133,000 jobs are currently unfilled, many because employers cannot find qualified applicants (The Boston Globe, September 29, 2011). Texas was the first state to pass a law that allows children of undocumented immigrants to pay in-state college tuition rates if they have lived in Texas for three years and plan to become permanent residents. The law passed easily back in 2001 because most legislators believed that producing college graduates and keeping them in Texas benefits the business community. In addition, since college graduates earn more money, they also provide the state with more revenue. Raymond Holt, who sits on the Board of Directors for the Texas Workforce Commission suggests the board should hire your consulting firm, Stat Solutions, to estimate the mean hourly wage of workers with various levels of education. You accept the job and a sample is collected of the hourly wages of 30 Texas workers with a bachelor's degree or higher, 30 Texas workers with only a high school diploma, and 30 Texas workers who did not finish high school. Mr. Holt wants you to provide a full report for him to present at the next meeting of the Texas Workforce Commission Board of Directors which occurs in 10 days. WORKFORCE TEXAS COMMISSION Requirements and Associated Point Values Requirement 1: Calculate and use descriptive statistics to compare hourly wages for each of the education levels. Be sure to include the mean, standard deviation, and margin of error with 95% confidence for each of the 3 levels (9 calculations). These calculations range in value from 3-4 points each for a total of 33 points. Note: See page 293 for the margin of error formula. (See Requirement 3 for more information about calculations.) Requirement 2: Construct and interpret 95% confidence intervals for the mean hourly wage at each education level. There should be an upper and lower number for each of the 3 levels. The end result should be 6 numbers which are valued at 3 points each for a total of 18 points. (See Requirement 3 for more information about calculations.) Requirement 3: Use Excel functions for the majority of your calculations. A total of 25 points are allocated to your calculations and the use of Excel. Your instructor will review the cells to find/confirm your formulas and summations. Excel is a great tool that will serve you well in your future endeavors. Requirement 4: Write up your findings in report form. In your report, discuss the difference between the statistics (mean, etc.). What do you find? Does education seem to make a difference? Remember these are dollar value wages. Please note: you are expected to use proper statistical terminology when appropriate but keep in mind that you are writing for a group who may not be as knowledgeable about statistics as you are. You must be sure they can understand your findings while also writing a professional report. This portion of the case study is valued at 39 points. Of those points, 14 will be allocated to proper grammar and spelling. Data File and Grading Rubric: The data file for the case study is in the Excel spreadsheet attached to the Case Study assignment and titled "Texas Workforce Commission Data." The grading rubric the PDF file attached to the Case Study assignment and titled "GBA305 - Case Study Grading Rubric." Submission Link and Due Date: The submission link is located in the "Case Study" folder in the "Assignments" section of Blackboard. Please refer to the Course Schedule for the assignment due date. GBA305-CASE STUDY GRADING RUBRIC Case Study - Grading Rubric (115 points) Insufficient Criteria 0 points Mean Calculations No mean calculations Standard Deviation Calculations Margin of Error Calculations Confidence Interval Calculations Calculations and Use of Excel Written Report and Discussion of Findings Writing Mechanics and Formatting Guidelines or incorrect mean calculations. 0 points No standard deviation calculations or incorrect standard deviation calculations. 0 points No margin of error calculations or incorrect margin of error calculations. 0 points No confidence interval calculations or incorrect confidence interval calculations. O points Excel was not used/ calculations were not shown. 0 points No written report or discussion of findings. 0 to 2 points Unfocused, rambling, or contains serious errors; does not follow specified guidelines. Multiple spelling and/or grammar errors. Novice 3 points Competent 6 points Proficient 9 points Accurate calculation of one mean. Accurate calculation of two means. Accurate calculation of three means. 12 points 4 points Accurate calculation of one standard deviation. 4 points Accurate calculation of one margin of error. 1 to 6 points Calculation of confidence interval for one education level. 1 to 8 points Rarely used Excel formulas or summation functions. Calculations were unclear, incorrect, or not provided. 1 to 8 points Written report in which answers and/or findings were unclear, incorrect, or not provided. 3 to 6 points Frequent grammar or spelling errors, but still a clear presentation of ideas. 8 points Accurate calculation of two standard deviations. 8 points Accurate calculation of two margin of error. 7 to 12 points Calculation of confidence interval for two education levels. 9 to 16 points Used some Excel formulas and summation functions correctly. Calculations had errors or were somewhat unclear. 9 to 16 points Well-organized written report that answered most questions and correctly discussed most findings. 7 to 9 points Occasional grammar or spelling errors, but still a clear presentation of ideas. Accurate calculation of three standard deviations. 12 points Accurate calculation of three margin of error. 13 to 18 points Calculation of confidence interval for three education levels. 17 to 25 points Used Excel formulas and summation functions correctly. Clearly showed accurate calculations. 17 to 25 points Well-organized, thorough written report that answered all questions and correctly discussed findings. 10 to 14 points Demonstrates clarity, conciseness, and correctness; formatting is appropriate and writing is free of grammar and spelling errors. A Bachelor's Degree High School Diploma No High School Diploma 22.50 12.68 11.21 19.57 11.23 8.54 24.13 19.53 12.52 27.23 9.85 9.06 27.00 15.76 14.21 28.60 12.31 13.40 16.85 12.27 11.46 22.70 8.57 11.22 26.69 11.06 9.56 20.14 11.47 9.43 21.33 13.38 10.98 18.33 9.85 10.41 17.86 12.35 11.73 20.47 10.68 8.28 21.08 10.70 8.59 17.05 11.54 13.30 21.70 13.55 7.91 22.19 17.80 12.28 23.80 15.70 10.72 22.30 17.50 15.97 22.42 6.50 10.58 22.29 8.98 9.59 27.43 12.14 10.92 23.14 8.83 9.70 22.84 13.02 7.64 21.86 8.90 10.39 29.32 13.80 4.62 26.00 21.67 13.04 30.53 8.74 6.29 21.44 7.47 10.27 Texas Workforce Commission Case Study GBA 305 Statistical Methods of Business I Texas is home to more than one million undocumented immigrants, and most of them are stuck in low-paying jobs. Meanwhile, the state also suffers from a lack of skilled workers. The Texas Workforce Commission estimates that 133,000 jobs are currently unfilled, many because employers cannot find qualified applicants (The Boston Globe, September 29, 2011). Texas was the first state to pass a law that allows children of undocumented immigrants to pay in-state college tuition rates if they have lived in Texas for three years and plan to become permanent residents. The law passed easily back in 2001 because most legislators believed that producing college graduates and keeping them in Texas benefits the business community. In addition, since college graduates earn more money, they also provide the state with more revenue. Raymond Holt, who sits on the Board of Directors for the Texas Workforce Commission suggests the board should hire your consulting firm, Stat Solutions, to estimate the mean hourly wage of workers with various levels of education. You accept the job and a sample is collected of the hourly wages of 30 Texas workers with a bachelor's degree or higher, 30 Texas workers with only a high school diploma, and 30 Texas workers who did not finish high school. Mr. Holt wants you to provide a full report for him to present at the next meeting of the Texas Workforce Commission Board of Directors which occurs in 10 days. WORKFORCE TEXAS COMMISSION Requirements and Associated Point Values Requirement 1: Calculate and use descriptive statistics to compare hourly wages for each of the education levels. Be sure to include the mean, standard deviation, and margin of error with 95% confidence for each of the 3 levels (9 calculations). These calculations range in value from 3-4 points each for a total of 33 points. Note: See page 293 for the margin of error formula. (See Requirement 3 for more information about calculations.) Requirement 2: Construct and interpret 95% confidence intervals for the mean hourly wage at each education level. There should be an upper and lower number for each of the 3 levels. The end result should be 6 numbers which are valued at 3 points each for a total of 18 points. (See Requirement 3 for more information about calculations.) Requirement 3: Use Excel functions for the majority of your calculations. A total of 25 points are allocated to your calculations and the use of Excel. Your instructor will review the cells to find/confirm your formulas and summations. Excel is a great tool that will serve you well in your future endeavors. Requirement 4: Write up your findings in report form. In your report, discuss the difference between the statistics (mean, etc.). What do you find? Does education seem to make a difference? Remember these are dollar value wages. Please note: you are expected to use proper statistical terminology when appropriate but keep in mind that you are writing for a group who may not be as knowledgeable about statistics as you are. You must be sure they can understand your findings while also writing a professional report. This portion of the case study is valued at 39 points. Of those points, 14 will be allocated to proper grammar and spelling. Data File and Grading Rubric: The data file for the case study is in the Excel spreadsheet attached to the Case Study assignment and titled "Texas Workforce Commission Data." The grading rubric the PDF file attached to the Case Study assignment and titled "GBA305 - Case Study Grading Rubric." Submission Link and Due Date: The submission link is located in the "Case Study" folder in the "Assignments" section of Blackboard. Please refer to the Course Schedule for the assignment due date. GBA305-CASE STUDY GRADING RUBRIC Case Study - Grading Rubric (115 points) Insufficient Criteria 0 points Mean Calculations No mean calculations Standard Deviation Calculations Margin of Error Calculations Confidence Interval Calculations Calculations and Use of Excel Written Report and Discussion of Findings Writing Mechanics and Formatting Guidelines or incorrect mean calculations. 0 points No standard deviation calculations or incorrect standard deviation calculations. 0 points No margin of error calculations or incorrect margin of error calculations. 0 points No confidence interval calculations or incorrect confidence interval calculations. O points Excel was not used/ calculations were not shown. 0 points No written report or discussion of findings. 0 to 2 points Unfocused, rambling, or contains serious errors; does not follow specified guidelines. Multiple spelling and/or grammar errors. Novice 3 points Competent 6 points Proficient 9 points Accurate calculation of one mean. Accurate calculation of two means. Accurate calculation of three means. 12 points 4 points Accurate calculation of one standard deviation. 4 points Accurate calculation of one margin of error. 1 to 6 points Calculation of confidence interval for one education level. 1 to 8 points Rarely used Excel formulas or summation functions. Calculations were unclear, incorrect, or not provided. 1 to 8 points Written report in which answers and/or findings were unclear, incorrect, or not provided. 3 to 6 points Frequent grammar or spelling errors, but still a clear presentation of ideas. 8 points Accurate calculation of two standard deviations. 8 points Accurate calculation of two margin of error. 7 to 12 points Calculation of confidence interval for two education levels. 9 to 16 points Used some Excel formulas and summation functions correctly. Calculations had errors or were somewhat unclear. 9 to 16 points Well-organized written report that answered most questions and correctly discussed most findings. 7 to 9 points Occasional grammar or spelling errors, but still a clear presentation of ideas. Accurate calculation of three standard deviations. 12 points Accurate calculation of three margin of error. 13 to 18 points Calculation of confidence interval for three education levels. 17 to 25 points Used Excel formulas and summation functions correctly. Clearly showed accurate calculations. 17 to 25 points Well-organized, thorough written report that answered all questions and correctly discussed findings. 10 to 14 points Demonstrates clarity, conciseness, and correctness; formatting is appropriate and writing is free of grammar and spelling errors.
Expert Answer:
Posted Date:
Students also viewed these mathematics questions
-
Assuming @Weather is a valid repeatable annotation that takes a String, with its associated containing type annotation @Forecast, which of the following can be applied to a type declaration? (Choose...
-
Dogs-R-Us and K-9, Inc. are two retail stores that cater to the needs of dog owners in the greater Charleston area. There is healthy competition between these two establishments. Both operate 52...
-
What are the benefits of APIs?
-
Hunter, Inc., analyzed its accounts receivable balances at December 31, and arrived at the aged balances listed below, along with the percentage that is estimated to be uncollectible: The company...
-
The 2018 income statement and comparative balance sheet of Rolling Hills, Inc. follow: Additionally, Rolling Hills purchased land of $21,100 by financing it 100% with long-term notes payable during...
-
Assume the TCP sender in Part a) is in the linear congestion avoidance phase and has a window size of 48 segments. If it experiences a single packet loss, what are the resulting window sizes for...
-
Swayne Johnson has been assigned as the audit senior for the audit of Sports Entertainment Limited (SEL) for the year ended 31 st December 2020. He has been assigned the role of audit senior due to...
-
A(n) 0.0712 kg baseball is thrown with a speed of 21.8 m/s. It is hit straight back at the pitcher with a final speed of 13.5 m/s. What is the magnitude of the impulse de- livered to the ball? Answer...
-
Alyeska Services Company, a division of a major oil company, provides various services to the operators of the North Slope oil field in Alaska. Data concerning the most recent year appear below:...
-
An 855 kg drag race car accelerates from rest to 111 km/h in 0.749 s. What change in momentum does the force produce? Answer in units of kg. m/s. part 2 of 2 What average force is exerted on the car?...
-
Current fertility rates (average number of children) for Germany and Japan are about 1.5 and 1.4 respectively, far below the fertility rates needed to replace a population (about 2.05-2.4). These low...
-
Desy Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is considering investments in three different technologies to develop wireless communication...
-
This assignment is designed to consolidate your learning of the key skills and knowledge needed when facing a financial report audit of a company, and how to analyse, research and pinpoint facets of...
-
Simplify the expression. Assume that all variables are positive. 23VI1 2 V44 8
Study smarter with the SolutionInn App