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.

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.