Homework about statics in Excel

A data has been collected through a survey for 50 people about their wage rates , Education, Eperience and age.Values are repoted below. Answer the following Questions 1: How many variables are used in data set 2: Is it a time series or Crossectional Data 3:Is it an ordinal data DATA SET obs 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Wage Rate Education Experince 11.55 5.00 12.00 7.00 21.15 6.92 10.00 8.00 15.63 18.22 20.00 4.35 5.00 8.25 15.00 19.00 18.00 7.07 8.00 25.00 17.30 16.00 5.00 8.25 8.00 13.69 19.90 22.00 6.50 12.00 13.39 36.85 12 9 16 14 16 12 12 12 18 18 20 12 5 12 12 14 14 16 14 14 12 12 12 12 12 12 12 12 12 12 12 20 20 9 15 38 19 4 14 32 7 5 31 7 31 14 15 26 23 4 16 27 44 38 19 13 14 20 26 17 1 19 34 21 Age 38 24 37 58 41 22 32 50 31 29 57 25 42 32 33 46 43 26 36 47 62 56 37 31 32 38 44 35 19 37 52 47 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 27.47 6.00 21.54 12.43 19.70 7.50 25.95 25.95 11.53 5.50 9.62 5.25 11.50 17.00 11.00 13.00 7.32 5.50 16 12 18 12 12 12 18 16 18 12 12 12 12 16 12 12 12 12 25 2 19 7 33 11 12 13 29 2 10 3 9 30 30 29 2 6 47 20 43 25 51 29 36 35 53 20 28 21 27 52 48 47 20 24 Answers DATA SET obs Wage Rate Education Experince Age 1 11.55 12 20 38 2 5.00 9 9 24 3 4 5 6 7 8 9 12.00 7.00 21.15 6.92 10.00 8.00 15.63 16 14 16 12 12 12 18 15 38 19 4 14 32 7 37 58 41 22 32 50 31 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 18.22 20.00 4.35 5.00 8.25 15.00 19.00 18.00 7.07 8.00 25.00 17.30 16.00 5.00 8.25 8.00 13.69 19.90 22.00 6.50 12.00 13.39 36.85 27.47 6.00 21.54 12.43 19.70 7.50 25.95 25.95 18 20 12 5 12 12 14 14 16 14 14 12 12 12 12 12 12 12 12 12 12 12 20 16 12 18 12 12 12 18 16 5 31 7 31 14 15 26 23 4 16 27 44 38 19 13 14 20 26 17 1 19 34 21 25 2 19 7 33 11 12 13 29 57 25 42 32 33 46 43 26 36 47 62 56 37 31 32 38 44 35 19 37 52 47 47 20 43 25 51 29 36 35 41 42 43 44 45 46 47 48 49 50 11.53 5.50 9.62 5.25 11.50 17.00 11.00 13.00 7.32 5.50 18 12 12 12 12 16 12 12 12 12 29 2 10 3 9 30 30 29 2 6 53 20 28 21 27 52 48 47 20 24 Mean = What are the average,median and mode wage rates. Median = Mode = Are the wage rates Normaly distibuted? If not eplain the distribution Answers DATA SET Draw the Box and Whisker “Eperien obs Wage Rate Education Experince Age 1 11.55 12 20 38 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 5.00 12.00 7.00 21.15 6.92 10.00 8.00 15.63 18.22 20.00 4.35 5.00 8.25 15.00 19.00 18.00 7.07 8.00 25.00 17.30 16.00 5.00 8.25 8.00 13.69 19.90 22.00 6.50 12.00 13.39 36.85 27.47 6.00 21.54 12.43 19.70 7.50 25.95 25.95 9 16 14 16 12 12 12 18 18 20 12 5 12 12 14 14 16 14 14 12 12 12 12 12 12 12 12 12 12 12 20 16 12 18 12 12 12 18 16 9 15 38 19 4 14 32 7 5 31 7 31 14 15 26 23 4 16 27 44 38 19 13 14 20 26 17 1 19 34 21 25 2 19 7 33 11 12 13 24 37 58 41 22 32 50 31 29 57 25 42 32 33 46 43 26 36 47 62 56 37 31 32 38 44 35 19 37 52 47 47 20 43 25 51 29 36 35 41 42 43 44 45 46 47 48 49 50 11.53 5.50 9.62 5.25 11.50 17.00 11.00 13.00 7.32 5.50 18 12 12 12 12 16 12 12 12 12 29 2 10 3 9 30 30 29 2 6 53 20 28 21 27 52 48 47 20 24 Draw the Box and Whisker plot For the variable “Eperience”. DATA SET Which variable has mor obs 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Wage Rate Education Experince 11.55 5.00 12.00 7.00 21.15 6.92 10.00 8.00 15.63 18.22 20.00 4.35 5.00 8.25 15.00 19.00 18.00 7.07 8.00 25.00 17.30 16.00 5.00 8.25 8.00 13.69 19.90 22.00 6.50 12.00 13.39 36.85 27.47 6.00 21.54 12.43 19.70 7.50 25.95 25.95 11.53 5.50 9.62 12 9 16 14 16 12 12 12 18 18 20 12 5 12 12 14 14 16 14 14 12 12 12 12 12 12 12 12 12 12 12 20 16 12 18 12 12 12 18 16 18 12 12 20 9 15 38 19 4 14 32 7 5 31 7 31 14 15 26 23 4 16 27 44 38 19 13 14 20 26 17 1 19 34 21 25 2 19 7 33 11 12 13 29 2 10 Age 38 24 37 58 41 22 32 50 31 29 57 25 42 32 33 46 43 26 36 47 62 56 37 31 32 38 44 35 19 37 52 47 47 20 43 25 51 29 36 35 53 20 28 44 45 46 47 48 49 50 5.25 11.50 17.00 11.00 13.00 7.32 5.50 12 12 16 12 12 12 12 3 9 30 30 29 2 6 21 27 52 48 47 20 24 Which variable has more variability? DATA SET Draw a scattar digram between Ag Eperience, Is their any relationship variables? obs 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Wage Rate Education Experince 11.55 5.00 12.00 7.00 21.15 6.92 10.00 8.00 15.63 18.22 20.00 4.35 5.00 8.25 15.00 19.00 18.00 7.07 8.00 25.00 17.30 16.00 5.00 8.25 8.00 13.69 19.90 22.00 6.50 12.00 13.39 36.85 27.47 6.00 21.54 12.43 19.70 12 9 16 14 16 12 12 12 18 18 20 12 5 12 12 14 14 16 14 14 12 12 12 12 12 12 12 12 12 12 12 20 16 12 18 12 12 20 9 15 38 19 4 14 32 7 5 31 7 31 14 15 26 23 4 16 27 44 38 19 13 14 20 26 17 1 19 34 21 25 2 19 7 33 Age 38 24 37 58 41 22 32 50 31 29 57 25 42 32 33 46 43 26 36 47 62 56 37 31 32 38 44 35 19 37 52 47 47 20 43 25 51 38 39 40 41 42 43 44 45 46 47 48 49 50 7.50 25.95 25.95 11.53 5.50 9.62 5.25 11.50 17.00 11.00 13.00 7.32 5.50 12 18 16 18 12 12 12 12 16 12 12 12 12 11 12 13 29 2 10 3 9 30 30 29 2 6 29 36 35 53 20 28 21 27 52 48 47 20 24 raw a scattar digram between Age(Independent variable) and perience, Is their any relationship exits between two ariables? Draw a stem and leaf Diagram DATA SET obs 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Wage Rate Education Experince 11.55 5.00 12.00 7.00 21.15 6.92 10.00 8.00 15.63 18.22 20.00 4.35 5.00 8.25 15.00 19.00 18.00 7.07 8.00 25.00 17.30 16.00 5.00 8.25 8.00 13.69 19.90 22.00 6.50 12.00 13.39 36.85 27.47 6.00 21.54 12.43 19.70 7.50 25.95 25.95 12 9 16 14 16 12 12 12 18 18 20 12 5 12 12 14 14 16 14 14 12 12 12 12 12 12 12 12 12 12 12 20 16 12 18 12 12 12 18 16 20 9 15 38 19 4 14 32 7 5 31 7 31 14 15 26 23 4 16 27 44 38 19 13 14 20 26 17 1 19 34 21 25 2 19 7 33 11 12 13 Age 38 24 37 58 41 22 32 50 31 29 57 25 42 32 33 46 43 26 36 47 62 56 37 31 32 38 44 35 19 37 52 47 47 20 43 25 51 29 36 35 41 42 43 44 45 46 47 48 49 50 11.53 5.50 9.62 5.25 11.50 17.00 11.00 13.00 7.32 5.50 18 12 12 12 12 16 12 12 12 12 29 2 10 3 9 30 30 29 2 6 53 20 28 21 27 52 48 47 20 24 raw a stem and leaf Diagram for variable” Age’ Draw a freuency Distributio Experience and then draw H DATA SET obs Wage Rate Education Experince Age 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 11.55 5.00 12.00 7.00 21.15 6.92 10.00 8.00 15.63 18.22 20.00 4.35 5.00 8.25 15.00 19.00 18.00 7.07 8.00 25.00 17.30 16.00 5.00 8.25 8.00 13.69 19.90 22.00 6.50 12.00 13.39 36.85 27.47 6.00 21.54 12.43 19.70 7.50 25.95 12 9 16 14 16 12 12 12 18 18 20 12 5 12 12 14 14 16 14 14 12 12 12 12 12 12 12 12 12 12 12 20 16 12 18 12 12 12 18 20 9 15 38 19 4 14 32 7 5 31 7 31 14 15 26 23 4 16 27 44 38 19 13 14 20 26 17 1 19 34 21 25 2 19 7 33 11 12 38 24 37 58 41 22 32 50 31 29 57 25 42 32 33 46 43 26 36 47 62 56 37 31 32 38 44 35 19 37 52 47 47 20 43 25 51 29 36 40 41 42 43 44 45 46 47 48 49 50 25.95 11.53 5.50 9.62 5.25 11.50 17.00 11.00 13.00 7.32 5.50 16 18 12 12 12 12 16 12 12 12 12 13 29 2 10 3 9 30 30 29 2 6 35 53 20 28 21 27 52 48 47 20 24 raw a freuency Distribution Table for the Variable xperience and then draw Histogram for that table.