NEVADA GAMING CASE – EXCEL EXERCISE

Congratulations! Nevada Gaming, Incorporated has just awarded you a statistical consulting contract. Nevada Gaming is one of the world’s leading suppliers of microprocessor-based gaming devices, including video poker machines and both video and reel-spinning slot machines. These devices are sold to casinos worldwide. Nevada Gaming is a publicly held corporation founded in 1980 by gaming legend Jack "the King of Video Gaming" Potts. Nevada Gaming’s manufacturing plant is located in Jean, Nevada where 800 factory workers are employed. Jack has two tasks that require your statistical insight. He had his personnel department select 36 factory employees at random for the statistical study and these sample results are available on Blackboard. Open the Excel spreadsheet called Nevada Case – Employee Sample Results. Click on the Names tab at the bottom. Find your Name and the Code Number of the data you should use. Click the tab for your Code Number. This is your data.

Task 1: Jack would like you use your knowledge of Descriptive Statistics and Statistical Estimation to enlighten him concerning the gender and age of his factory workers.

Task 2 : The Human Resources Department has questioned the accuracy of the screening process it currently uses in selecting which applicants should be hired as factory workers. Nevada Gaming employs 800 factory workers and there is constant turnover for this type of employee. The Human Resources department currently requires that each factory job applicant take both a General Aptitude test and a Manual Dexterity test as part of their screening process. The General Aptitude test measures general intelligence and practical problem solving. The Manual Dexterity test measures coordination and other physical abilities that are essential in factory work. The applicant’s qualifications, references, and the results of the two tests are analyzed to determine who should be hired. Obviously, the company wants to hire employees that will become productive workers. Nevada Gaming subscribes to two testing services to provide updated General Aptitude and Manual Dexterity exams at a significant cost. These tests also take substantial time to administer, grade and analyze. Jack Potts is wondering about the accuracy of each test as a screening device and whether both tests are really necessary as part of the hiring process.

Price: $27.15

Solution: The downloadable solution consists of 13 pages, 1415 words and 2 charts.
Deliverable: Word Document