NEED helP- Execel Wizz!?!, for assignment

[steve2rule]

IF ANYONE CAN HELP, I'll send you the data sheet through email.
Sheet (1): Students Marks
[FONT=Times New Roman,Times New Roman][FONT=Times New Roman,Times New Roman]a. Fill in the missing values on this sheet in accordance with the weighting scale and grading criteria (A, B, C, D, F) presented on the same sheet. Thus, you need to record the grade letter against the term average for each student.
b. Give a summary of these marks via descriptive statistics using both: formulae input and Data Analysis tools available in ‘Excel’; and draw an appropriate histogram showing your summary.
c. Find out whether there is some kind of a relationship between the two variables: ‘Course Work’ mark and the ‘Exam’ mark. Provide your own interpretation of such relationship, showing the trend line and the coefficient correlation value.
[/FONT][/FONT]Sheet (2): ‘StudentsOrigin’ Sheet:
[FONT=Times New Roman,Times New Roman][FONT=Times New Roman,Times New Roman]a. Complete the missing figures by answering the questions presented on the ‘StudentsOrigin’ sheet
b. Draw an appropriate graph that shows the amount of fees paid by each origin category (e.g. UK, EU, Canada, etc.) on Undergraduate as well as postgraduate studies.
c. Explain your method for summarising the data and why you chose a certain type of chart to represent your findings.
[FONT=Times New Roman,Times New Roman][FONT=Times New Roman,Times New Roman]Sheet (3): Company Report
[/FONT][/FONT]a. Amend the values on this sheet in accordance with the set of assumptions presented on this sheet
b. Give the projected values of this company’s income and expenses for further five years starting with the year 2010 until 2014.
c. Explain your use of cells with absolute references and relevant references in the tables presented on Sheet (3).
[FONT=Times New Roman,Times New Roman][FONT=Times New Roman,Times New Roman]Sheet (4): Spending on Frames
[/FONT][/FONT]a. Analyse the data presented on this sheet by presenting descriptive statistics.
b. Show through the relevant data representation the relationship between age and spending; and between gender and spending.
c. Discuss what type of impact the two variables – age & gender – have on the willingness to increase spending on a pair of frames. Comment on how strong such impact is – in case there is any.
[FONT=Times New Roman,Times New Roman][FONT=Times New Roman,Times New Roman]Sheet (5): Employees Data
[/FONT][/FONT]a. Fill in the missing values for descriptive statistics and probabilities on this sheet.
b. Find out whether there is some kind of a relationship between the two variables: ‘salary’ and the level of ‘experience’.
c. Provide your own interpretation of such relationship, showing the trend line and the coefficient correlation value.
[/FONT][/FONT]

 

[xld]

So, when we have done your homework for you, do we get your grade?

 

[steve2rule]

Only asking for the help, we have had 5 classes, and they expect us to know Excel like a genius!, if you like to help out, improve your excel skills teaching others how to use excel by helping up to you.

 

[JackDanIce]

Could the last slave you had provide any references please? I appreciate this may be difficult if they've unfortunately passed away. Whilst you're at it a well made cup of coffee would be nice, ta

 

[Special-K99]

You wouldnt be tested on anything you weren't taught. You obviously didn't understand any of it.

 

[steve2rule]

ok, obviously this aint a forum where you ask questions and for help :S - and in 5 classes ttrying to do tasks, difficult to remmeber how to do formulaes just liket that etc.

 

[JackDanIce]

Sounds like you need to either review your class material more frequently, speak to your tutor about the speed at which you're being taught and expected to learn, ask for a refund or appreciate how to ask a question in a forum like this.

Alot of what you're asking in what appears to be a copy and paste job is not Excel work but that you're being lazy and trying to get other people to do your homework for you e.g. Provide your own interpretation of such relationship, showing the trend line and the coefficient correlation value.

 

[Smitty]

ok, obviously this aint a forum where you ask questions and for help :S

Welcome to the Board!

Quite the contrary, that's the entire reason for the board's existence. But, as you've found out, we don't do homework. We will however point you in the right direction, but you need to take some initiative and show what you've tried with each question, and what you're having a problem with.

 

[Norie]

That appears to be 15 questions you've asked - perhaps if you split things up a bit people might be more conducive to help.

Also a lot of it seems rather vague. eg 'interpretation', 'appropriate' etc