You are Here: Home >< Maths

# Help with statistics watch

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.
2. You can do scatter graphs on Excel to show the relationship between age and earnings.
3. 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

### Related university courses

TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Updated: March 29, 2011
Today on TSR

### Top unis in Clearing

Tons of places at all these high-ranking unis

Poll
Useful resources

### Maths Forum posting guidelines

Not sure where to post? Read the updated guidelines here

### How to use LaTex

Writing equations the easy way

### Study habits of A* students

Top tips from students who have already aced their exams