20 2b. 2. 20 Problem: The data set below contains information on 300 employees who work at ABC corporation in columns G and Hand starting in row 23 create a frequency distribution to the age of the employees in the 10-year ranges from 21 to 30, 31 to 40, 41 to 50, 51 to 60 and 61 to 70. READ THISI! You must the FREQUENCY function to solve the problem. Your results should update appropriately if the data in column changes What you end up with incolumn should look like what you see in column M Problem z incolumn starting in row 21. enter the native frequency for each value in your frequency distribution. What you end up with in columns should look what you see in column Problem Xe The Human Resources manager wondered whether or not the distribution of the number of employees in each of the 10-year age brackets 21 30, 3140, 41-50,510 and 61 - 70s shown in cel N2 N27, was uniformly tributed. She did a chi square goodness-of-fittest to check this out. In cel 2, enter the value of her chisquare statistic. The result you get should be the value in cell 32. It OK (in fact, it is recommended to other cris to find intermediate values as you develop your answer, but the formula you enter in cella must automatically update if the data in changes Problem 24 incelenter the value issociated with the state. The result you get should be the value in cell 34 READ THESH Your answers in cele 12 and 34 must be Excel formules that produce the correct numbers even if the data in column of the table changes. Nore if you are not able to get coll 2 toga, use call to calculate the p-value Points Problem 2a 2b Nama Ape Gender Undergraduate Graduate Frequency Relative Frequency 62 63 30 40 .50 60 70 J.L Desa | | | 4.R.Chen LL. Meilton V. HII J.Puchett V.Son 5. Hamilton NL Bender D. Wagner 1. McLaughlin U. McNamara Ulayer W. Moon 1. Woodard Desa H Wallace K. Lawrence G 36 41 32 33 35 27 30 24 34 45 23 23 49 28 28 21 24 Male Male Male Male Male Female Male Female Female Female Male Male Female Male Male Male Female Female MT Yes Yes Yes Yes No Yes Yes Yes No Yes Yes Yes Yes No Yes Yes Yes No Yes Yes No No No No Yes Yes Yes No Yes No 2c. Chi square stat Yes 2d, p-value Yes No No Yes Yes No Y Score Sheet Cover Sheet Problem 1 Problem 2 Problem 3 Problem 4 Data Prol MacBook F1 F2 80 0 F3 OOD 000 F4 41 to 50, 51 to 60 and 61 to 70. READ raginately if the data in column 3 change 2. Score 2d. Score distribution. What you end up within employees in each of the 10-year ago She did a chi square goodness of fittest value in cell 132. It is OK (In fact, it is s you enter in all must automatically value in cell 34 even if the data in column of the table Points Problem 2a 2b Frequency A Bencen Frequency Netti FRANCE Chi su Frequency 1999 21 to 30 31100 41 to SD Sito 60 61 60 70 70 Points 2c. Chi we statistics Problem 2. 20. 2d. p-value + em 3 Problem 10 Data Problem 4 Problems 5, 6, 7, 8 and 9 MacBook Pro F9 FB: F90 FIN F FS F6 * ) & C 9 6 7 8 0 21 Age Gender Undergraduate Graduate Graduate Bins Fr 30 40 50 62 63 36 41 32 33 35 27 30 24 60 70 Yes No No No No Yes Yes Yes No Yes No Yes Yes No Name 22 23 J.L. Desai 24 H. 5. Chng 25 H. R. Chen 26. E. 1. Melton 27 IV. HILI 28 U. F. Puckett 29 O. V. Song 30 A S. Hamilton 31 E N. Bender 32 A D Wagner 33 C.I. McLaughlin 34 C.U. McNamara 35 A U. Raynor 36 0 W. Moon 37 O. T. Woodard 38 EL Desal 39 A H. Wallace 40 Lawrence 41 R. J. Griffin 42 O. F. Dougherty 43 O. J. Powers 44 AM May 45 T. D. Steele 46 E. Teague 47 LV. Vick 48 A. B. Gallagher 49 O.W. Solomon 50 AI. Walsh 51 O. M. Monroe 52 0. 5. Connolly 53 A. 1. Hawkins 54 I. N. Middleton 55 O. K. Goldstein 56 A. I. Watts 57 0.B. Johnston 58 E. S. Weeks 59 LT. Wilkerson 60 A. O. Barton 61 ANWalton 34 45 23 23 49 28 28 21 28 28 Male Male Male Male Male Female Male Female Female Female Male Male Female Male Male Male Female Female Male Female Male Female Female Male Female Male Male Male Male Female Male Male Male Female Male Female Male Male Female Yes Yes Yes Yes No Yes Yes Yes No Yes Yes Yes Yes No Yes Yes Yes No Yes No Yes Yes Yes Yes Yes No Yes Yes Yes No No No Yes Yes Yes Yes No Yes Yes 24 31 70 43 35 28 22 52 26 22 29 Yes Yes No Yes No No Yes No No No No No Yes No No No No No No No Yes No Yes Yes 24 42 35 56 44 37 52 Score Sheet Cover Sheet Problem 1 Problem 2 Problem 3 Problem 4 20 2b. 2. 20 Problem: The data set below contains information on 300 employees who work at ABC corporation in columns G and Hand starting in row 23 create a frequency distribution to the age of the employees in the 10-year ranges from 21 to 30, 31 to 40, 41 to 50, 51 to 60 and 61 to 70. READ THISI! You must the FREQUENCY function to solve the problem. Your results should update appropriately if the data in column changes What you end up with incolumn should look like what you see in column M Problem z incolumn starting in row 21. enter the native frequency for each value in your frequency distribution. What you end up with in columns should look what you see in column Problem Xe The Human Resources manager wondered whether or not the distribution of the number of employees in each of the 10-year age brackets 21 30, 3140, 41-50,510 and 61 - 70s shown in cel N2 N27, was uniformly tributed. She did a chi square goodness-of-fittest to check this out. In cel 2, enter the value of her chisquare statistic. The result you get should be the value in cell 32. It OK (in fact, it is recommended to other cris to find intermediate values as you develop your answer, but the formula you enter in cella must automatically update if the data in changes Problem 24 incelenter the value issociated with the state. The result you get should be the value in cell 34 READ THESH Your answers in cele 12 and 34 must be Excel formules that produce the correct numbers even if the data in column of the table changes. Nore if you are not able to get coll 2 toga, use call to calculate the p-value Points Problem 2a 2b Nama Ape Gender Undergraduate Graduate Frequency Relative Frequency 62 63 30 40 .50 60 70 J.L Desa | | | 4.R.Chen LL. Meilton V. HII J.Puchett V.Son 5. Hamilton NL Bender D. Wagner 1. McLaughlin U. McNamara Ulayer W. Moon 1. Woodard Desa H Wallace K. Lawrence G 36 41 32 33 35 27 30 24 34 45 23 23 49 28 28 21 24 Male Male Male Male Male Female Male Female Female Female Male Male Female Male Male Male Female Female MT Yes Yes Yes Yes No Yes Yes Yes No Yes Yes Yes Yes No Yes Yes Yes No Yes Yes No No No No Yes Yes Yes No Yes No 2c. Chi square stat Yes 2d, p-value Yes No No Yes Yes No Y Score Sheet Cover Sheet Problem 1 Problem 2 Problem 3 Problem 4 Data Prol MacBook F1 F2 80 0 F3 OOD 000 F4 41 to 50, 51 to 60 and 61 to 70. READ raginately if the data in column 3 change 2. Score 2d. Score distribution. What you end up within employees in each of the 10-year ago She did a chi square goodness of fittest value in cell 132. It is OK (In fact, it is s you enter in all must automatically value in cell 34 even if the data in column of the table Points Problem 2a 2b Frequency A Bencen Frequency Netti FRANCE Chi su Frequency 1999 21 to 30 31100 41 to SD Sito 60 61 60 70 70 Points 2c. Chi we statistics Problem 2. 20. 2d. p-value + em 3 Problem 10 Data Problem 4 Problems 5, 6, 7, 8 and 9 MacBook Pro F9 FB: F90 FIN F FS F6 * ) & C 9 6 7 8 0 21 Age Gender Undergraduate Graduate Graduate Bins Fr 30 40 50 62 63 36 41 32 33 35 27 30 24 60 70 Yes No No No No Yes Yes Yes No Yes No Yes Yes No Name 22 23 J.L. Desai 24 H. 5. Chng 25 H. R. Chen 26. E. 1. Melton 27 IV. HILI 28 U. F. Puckett 29 O. V. Song 30 A S. Hamilton 31 E N. Bender 32 A D Wagner 33 C.I. McLaughlin 34 C.U. McNamara 35 A U. Raynor 36 0 W. Moon 37 O. T. Woodard 38 EL Desal 39 A H. Wallace 40 Lawrence 41 R. J. Griffin 42 O. F. Dougherty 43 O. J. Powers 44 AM May 45 T. D. Steele 46 E. Teague 47 LV. Vick 48 A. B. Gallagher 49 O.W. Solomon 50 AI. Walsh 51 O. M. Monroe 52 0. 5. Connolly 53 A. 1. Hawkins 54 I. N. Middleton 55 O. K. Goldstein 56 A. I. Watts 57 0.B. Johnston 58 E. S. Weeks 59 LT. Wilkerson 60 A. O. Barton 61 ANWalton 34 45 23 23 49 28 28 21 28 28 Male Male Male Male Male Female Male Female Female Female Male Male Female Male Male Male Female Female Male Female Male Female Female Male Female Male Male Male Male Female Male Male Male Female Male Female Male Male Female Yes Yes Yes Yes No Yes Yes Yes No Yes Yes Yes Yes No Yes Yes Yes No Yes No Yes Yes Yes Yes Yes No Yes Yes Yes No No No Yes Yes Yes Yes No Yes Yes 24 31 70 43 35 28 22 52 26 22 29 Yes Yes No Yes No No Yes No No No No No Yes No No No No No No No Yes No Yes Yes 24 42 35 56 44 37 52 Score Sheet Cover Sheet Problem 1 Problem 2 Problem 3 Problem 4