Hi, could anyone please help me with this?
I´ve been given two sets of data: "This survey was subsequently performed and questionnaires from a random sample of 30 male employees and 50 female employees were obtained. You have been asked by the union executive to analyse the data relating to the gross monthly earnings and age of these 80 employees"
Now they ask me to: "Use Excel to investigate and summarise the gross monthly earning data for both males and females separately. Only descriptive statistical techniques are required (such as graphs, tables and numerical summaries) to explore and determine the main features of the data. You should select what you believe to be appropriate ways of illustrating and summarising the data. Graphs/Charts should be fully labelled and numerical summaries given to a relevant number of decimal places, with units."
I have no idea how to do that on Excel.
Help with statistics Watch
- Thread Starter
- 29-03-2011 17:05
- 29-03-2011 17:45
You can do scatter graphs on Excel to show the relationship between age and earnings.
- 30-03-2011 00:26
All of that can be done in excel but it is quite difficult to explain how to do it without being next to you, i would suggest searching online for an excel tutorial to try and learn some of the basic data manipulation fundtions