Turn on thread page Beta
    • Thread Starter
    Offline

    2
    ReputationRep:
    Hi,

    I wonder if anyone could please advise me? I'm not a very competent Excel user.

    I want to add standard deviations to each column in a histogram in the form of error bars. I've attempted to do this (see image attached). Here you can see the standard deviation of the data in my table (below table), plus this plotted as error bars in the accompanying bar graph. Please can anyone advise me as to whether I have done this correctly?

    Many thanks
    Attached Images
     
    Offline

    11
    ReputationRep:
    (Original post by Ggdf)
    Hi,

    I wonder if anyone could please advise me? I'm not a very competent Excel user.

    I want to add standard deviations to each column in a histogram in the form of error bars. I've attempted to do this (see image attached). Here you can see the standard deviation of the data in my table (below table), plus this plotted as error bars in the accompanying bar graph. Please can anyone advise me as to whether I have done this correctly?

    Many thanks
    Assuming you want to put in an error bar for +/- 1 SD then OK but could your data actually be negative?

    Where the measurement is zero, is it prone to any error at all? I have no idea what you data is about but it might be questionable to include the data where the motors recruited has gone to zero?

    After all, depending on the data I might see how many people can throw a calculator (say) beyond a set distance and by adding in distances above the maximum that anyone can throws a calculator I can arbitrarily increase the number of data points I am dealing with by having loads of zeroes for immense distances.
 
 
 
Reply
Submit reply
Turn on thread page Beta
Updated: March 22, 2016

2,698

students online now

800,000+

Exam discussions

Find your exam discussion here

Poll
Who is going to be the top scorer of the World Cup in 2018?
Useful resources

Make your revision easier

Maths

Maths Forum posting guidelines

Not sure where to post? Read the updated guidelines here

Equations

How to use LaTex

Writing equations the easy way

Student revising

Study habits of A* students

Top tips from students who have already aced their exams

Study Planner

Create your own Study Planner

Never miss a deadline again

Polling station sign

Thinking about a maths degree?

Chat with other maths applicants

Can you help? Study help unanswered threads

Groups associated with this forum:

View associated groups

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reply
Hide
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.