Scatter chart excel upper bound limit
What if I want to enter the median and quartiles, or some other kind of error bars? The error bars will end at the Y values you enter.
![scatter chart excel upper bound limit scatter chart excel upper bound limit](https://i.stack.imgur.com/hqBqb.png)
These are added to (or subtracted from) the value you enter as the mean to compute the end point of the error bars. When you format the subcolumns for entry of +/- error values, the values you enter are interpreted as distances.
![scatter chart excel upper bound limit scatter chart excel upper bound limit](https://peltiertech.com/images/2010-08/wageplot3.png)
It is easy to confuse the +/- and upper/lower choices for entry of preaveraged data. The difference between entering +/- errors and upper/lower limit errors Temperature in C or F is not a ratio variable, because a temperature of 0.0 doesn't mean no heat. Weight is a ratio variable, because a weight of 0.0 means no weight. This is only useful for ratio variables, where zero means none of that value. Since the SD and Mean are in the same units, the %CV is a unitless percentage. The %CV is the coefficient of variation as a percentage, so is defined as 100*SD/Mean. If you also enter n, Prism can account for scatter and sample size, and the curve fit will be the same as if you had entered raw data. If you enter the data as mean and SD or SEM, Prism will fit the means, and ignore the values you enter as SD or SEM. You want accurate nonlinear regression.t tests, ANOVA and more require knowing sample size. If you enter SD or SEM with n, Prism can switch between plotting whatever form of error value you want to show. You want to be able to switch between graphing SD, SEM and CI error bars.It is necessary to enter n in these situations: It is ok to omit the "n" values, or to format the table for entry of Mean with SD or SEM, but without n. If you only want to make a graph showing mean and SD or SEM, you only need to enter those values into the data table.
![scatter chart excel upper bound limit scatter chart excel upper bound limit](https://i.stack.imgur.com/hlZ7q.png)
If you enter mean and SD or SEM, why also enter n? When creating (or reformatting) a Grouped or XY table, you can choose to format the table for entry of preaveraged data. Choosing to enter precalculated error values