Hi,
I need help! I am trying to graph some data to show the confidence level and mean.
I get how to get the answer, but not how to create a graph using excel.
I already have the answer to the the problem but I just don't get how to create the graph?
How can I make a confidence interval graph in Excel?
The individual CONFIDENCE() function [CONFIDENCE(alpha, STDEV, n)] returns a
different confidence interval than if you use Descriptive Statistics Analysis
[Tools>Data Analysis>Descriptive Statistics]. In fact, I've been witnessing
a 25% difference between the two values.
Any ideas why these two methods of calculating the confidence interval yield
different results?
Hi,
I have a series of values that I used to solve a Regression Equation. Now I want to plot the confidence intervals (95%) for the line. Is there a way to plot confidence intervals for a linear regression equation? The confidence function in Excel does not provide what I need.
Thank you,
Deb
Hello All,
I am lacking in my statisical know-how...I need some help with a confidence level calculation.
Background Info:
I am doing a weibull analysis on failure data. Some of the data is right censored. I have already run a maximum likelihood estimate to obtain the estimated weibull parameters with Excel's SOLVER function. I am good on this part.
Help Needed With:
Now I want to calculate these parameters with a 95% confidence interval. I can't seem to find information on calculating confidence intervals with right censored data.
Any help would be greatly appreciated.
Hi. I want to plot sets of data with 10 points per set.
I'd like to show the 95% confidence interval.
I could also calculate the confidence interval and plot it mysef.
Except I don't know how to plot categorical vertical lines given the average
point and the half width lengths.
Thank you so much in advance!
Hi,
I'm having a lot of trouble adding a calculated field to a pivot table. The data source for the pivot table is a very large access table, which contains raw 'scores'.
The pivot table has three levels of row headers (categoryA, categoryB and categoryC), and one level of column headers (5 columns in width). I have brought in the score three times as data - one as average ("Mean"), one as count ("N") and one as standard deviation ("SD").
The formula for the 5% confidence interval is SD/Sqrt(N)*1.96. Is there any way to add this confidence interval calculation to the pivot table as a calculated field, so that it updates every time the pivot table is changed? I can't add the calculation to the source table because the records in the table are not at an aggregated level. I have tried adding the calculation to a different worksheet, but my problem is that the pivot table orientation frequently changes - although it starts off with the three row headers mentioned above, the number of row headers can be anything from 1 to 3 levels, and the actual categories vary, so the height & width of the pivot table varies as a result.
Tim
I'm trying to predict the amount of revenue an account will produce in the next month, and I'm familiar with a linear trendline (LINEST) function to determine the best linear estimate of the increase. However, what I don't know how to do is generate the confidence interval for that. I believe that the closer the R squared (RSQ) value is to 1, the smaller my prediction interval should be, but I don't know how to convert the RSQ value into an interval around the trendline, for say a 95% certain estimate.
I have converted the YTD revenue to a monthly revenue and then taken the mean of these monthly revenues, calculated the Standard deviation, and used the (Confidence) function, but the mean does not taken into consideration the order the revenues were recieved, whereas a linear estimate does. Can anyone help me forecast into the future, and put some sort of interval around this estimate?
THanks,
Jason in Dallas
Can someone show me a real life Excel 2007 example of how and when to use CONFIDENCE?
