How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Chris L. Your Own Question
Chris L.
Chris L., Support Specialist
Category: Microsoft Office
Satisfied Customers: 4864
Experience:  Certified Expert with over 10 years experience.
51029781
Type Your Microsoft Office Question Here...
Chris L. is online now
A new question is answered every 9 seconds

pls also advise how do I type a word number on the vertical

Resolved Question:

pls also advise how do I type a word 'number' on the vertical axis, and 'mark' on the horizontal axis. Also how to type the title in the graph sheet ? Thanks
Submitted: 5 years ago.
Category: Microsoft Office
Expert:  John D replied 5 years ago.

Hello again,

 

I need to see the spreadsheet with the data. Could you please send me the file

 

 

Customer: replied 5 years ago.

Attachment: 2011-12-06_180638_graph.xls



the graph is attached; want to put 'number' on the horizontal axis and 'Mark Range' on the horizotal axis. Wish to type title o top of graph sheet as well.
Expert:  John D replied 5 years ago.

Ok will review the file and get back to you

 

 

Customer: replied 5 years ago.
can u please also advise how to calculate the mean (ie average), mdian and standard deviation of the chart for PG137 ?
Expert:  John D replied 5 years ago.

All under this question?

 

Ok will see what I can do

 

 

Customer: replied 5 years ago.
Yes all under one question
Expert:  John D replied 5 years ago.

Ok I am sorry I will not be able to answer all these questions for $9. Will opt out in case someone else can do it. If you do not get any response from other experts you can post back here

 

 

Thank you

 

 

Customer: replied 5 years ago.
thanks anyway I will put the question to back to the floor
Expert:  Chris L. replied 5 years ago.
Hello and thank you for using Just Answer.

In the cell that you would like the standard deviation, please type
=stddev( and then highlight all of the cells that you want the standard deviation of then press enter.

For average type =average( and highlight your cells an press enter

For median type =median( highlight your cells and press enter

If you need further assistance please reply and let me know.

Thank You
Expert:  Chris L. replied 5 years ago.
Here is the complete file:

http://wikisend.com/download/308318/2011-12-06_180638_graph.xls
Chris L., Support Specialist
Category: Microsoft Office
Satisfied Customers: 4864
Experience: Certified Expert with over 10 years experience.
Chris L. and 3 other Microsoft Office Specialists are ready to help you

Related Microsoft Office Questions