# Solver: Confidence Intervals

May 7, 2009Does Solver provide confidence intervals around its parameter estimates?

View 9 RepliesDoes Solver provide confidence intervals around its parameter estimates?

View 9 RepliesADVERTISEMENT

I've managed to figure out how to normalize my data and create several bell curves. However, these charts do not display the mean, std deviation, or confidence intervals. Any way to add these into my charts?

View 7 Replies View RelatedConfidence 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.

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.

I have a cell, D5, which is the sum of three other cells, A5 B5 and C5. (all currently empty). Cells A1 through C4 are filled with various numbers.

What I've been trying to do is use solver to say: Make D5 equal 200, do it by manipulating only A5 B5 and C5, and make it subject to the constraint that A5 must equal a value selected from A1:A4, and B5 must equal a value from B1:B4, and C5 ...etc. I have deliberately set it up so that there is only one solution.

I was doing fine until trying to create the constraints. How can I make a constraint that says "this cell" must equal "one of the following cells"? And if I can't do that, is there an alternate method of achieving the same result?

I have to use use the solver to calculate something (a mean-variance framework).

I am using the solver to minimize a cartain cell (variance) by making two cells equal through (expected return) by varying 10 cells( weights of assets), but I have to repeat this for 500+ times (for different expected returns).

Someone told me that I could best use some sort of loop through VBA. But I don't have a clue how that works.

I want to use solver program. But when solver "changes cells" i want it to trigger my pivot tables in the workbook. So i added the code to my worksheet:

Private Sub Worksheet_Change(ByVal Target As Range)

ThisWorkbook.RefreshAll

End Sub

So when a change occurs, all my pivot tables will get refreshed and my data will change. Is solver able to trigger this event while solving an optimization problem?

I am trying to write a macro for transposing one row into multiple columns where the starting point for each column will be 15 cells starting from B4. I want to replicate the transpose for 200 rows.

View 4 Replies View RelatedHow do i change my data file from 1' intervals to 5' intervals?

The way it is now The way I need it

8300 8300

8301 8305

8302 8310

8303

8304

8305

8306

8307

8308

8309

8310

thru 11,000

My sheet consists of the following Data in the table ( to be increased to 99 rows or events )

I need to find the Next Date Occurence till the End_date

Next_Date1 = Start_date + Interval

Next_Date2 = Next_date1 + Interval

and so on till Next_Datexx is greater than End_date

I need a VBA code to fill the adjacent columns ie Next_date1 to Next_Date99 ( till the end_date), only if the Status is "DONE". If the Status is blank then the relevant colums must not fill.

I can do it with formulas, but need the VBA code.

Also the number of rows can be increased to 99 rows

Event

Start_date

End_date

Interval

[Code].....

I'm trying to make a histogram with the data analysis tool. The problem is that whenever I make a chart it doesnt show my intervals correctly. It puts them under the bars instead of between them.

View 3 Replies View RelatedI'm making use of a histogram to visualize my data. The only problem is that 90% of the data has a value which lies close to eachother but 10% is very different.

For example:

Interval-----Frequency

0-10------5

10-20-----7

20-30-----6

30-40-----0

40-50-----0

50-60-----0

60-70-----0

70-80-----0

80-90-----0

90-100----0

100-110---2

Now the histogram I will obtain won't look very good. Is there a way I can have an interval like 40 - ... which resembles everything above 40?

I'm trying to determine how much time our agents are spending for their lunch/breaks during 30 minute intervals. Range A8:A200 lists the agent's names, Range B8:B200 lists their lunch/break start times, Range C8:C200 lists their lunch/break end times, and Column E lists the times (8:00, 8:30, 9:00, etc.). If an agent starts their break at 10:57 (Column B) and ends at 11:10 (Column C), the value next to 10:30 (Column E) would have 0:03:00 and the value next to 11:00 would have 0:10:00. But would need to sum all the agents which took a break/lunch between 10:30-11:00, and 11:00-11:30.

View 2 Replies View RelatedIs there a formula that can identify all the consecutive intervals that have value below 90%.

View 1 Replies View RelatedI think I've had enough of using excel generated macro's as an excuse for decent code. I need to turn this:

Small procedure, function, what have you that will continue this pattern until I hit some kind of indicator to tell it to stop. This just clears the contents from 7 rows, hops down 9 rows and does it again.

I have posted earlier thread on similar problem but i did not get much response.I am really having a tough time to record a macro, where my columns will be selected with an interval and then will be pasted in to another sheet....

View 6 Replies View RelatedI would like to write a formula to average cells F27 - F11007 in a spreadsheet for every 96 values. That is, I want the average of F27:F122, F123:F218, F219:F314 and so on up to F10912:F11007. Ideally I would be able to pull down the fill handle and perpetuate the formula since this is a lot of data.

I've been trying to use INDIRECT and OFFSET formulas but I get a #REF! or #VALUE error.

Below is the code i want to be run evey 2 minutes Thanks

Sub WebData()

Dim wSU As Worksheet

Dim wSR As Worksheet

Dim wSS As Worksheet

Dim iForRow As Integer

Dim iLastRow As Integer

Dim sURL As String

08:00 26calls

12:00 50calls

16:30 16calls

The problem is the data is output as above just outputing intervals with data.

I need to convert this data to 15 minute intervals as below:

08:00 13calls

08:15 13calls

12:00 25calls

12:30 25calls

16:30 8calls

16:45 8calls

I have a range, intervals and need to find out how many observations are in those intervals...

RANGEINTERVALFREQUENCE-0.10773-0.10773-0.11 ?-0.10144-0.11 -0.05 -0.0983-0.05 0.01 -0.085110.01 0.07 -0.0810.07 0.13 -0.078760.13 0.19 -0.07580.19 0.25 -0.071360.25 0.31 -0.070750.31 0.37 -0.06930.37 0.43 -0.068420.43 0.49 -0.068060.49 0.55 -0.067390.55 0.61 -0.060030.61 0.67 -0.059350.67 0.73 -0.057470.73 0.79 -0.05290.79 0.85 -0.052570.85 0.91 -0.05190.91 0.97 -0.051340.97 1.03 -0.050011.03 1.09 -0.048051.09 1.15 -0.046941.15 1.21 -0.046411.21 1.27 -0.045311.27 1.33 -0.045291.33 1.39 -0.045061.39 1.45 -0.045021.45 1.51 -0.044341.51 1.57 -0.043321.57 1.63 -0.042231.63 1.69 -0.041661.69 1.75 -0.041441.75 1.81 -0.040051.81 1.87 -0.038661.87 1.93 -0.038561.93 1.99 -0.037811.99 2.05 -0.037112.05 2.11 -0.036272.11 2.17 -0.033292.17 2.23 -0.032872.23 2.29 -0.032672.29 2.35 -0.031322.35 2.41 -0.029372.41 2.47 -0.029262.47 2.53 -0.028292.53 2.59 -0.028222.59 2.65

I am trying to do is calculate (sum) results data for time intervals. For example, between 0500-0559hrs then 0600-0659hrs and so on. Data is collected at 1 minute intervals and may have a result of 0 or anywhere up to 30.

Column A has all time data e.g. 0500,0501,0502 etc

Column B has sum of instances e.g. 0,1,2,3 etc

I want to create 15 minute time intervals from the data. I attached the file for reference. I would like to sum the data column that corresponds to each interval. I created an example using the formulas and I want to be able to do that automatically either using VBA or the formulas.

View 5 Replies View RelatedI want to set something up so the following text, is repeated at set intervals down the sheet, a number of times defined by an integer input box at the top of the sheet. Next to each new text array, I'd like to define a dynamic name range, calling each an increment above the one before. So:

Question Title

Question no.

Assessment Target

Level

No. of Marks

With name ranges being, (for e.g.) P1QT, P2QT, P3QT. For three sets of papers for the "Question Title" range.

I am trying to drive Solver in Excel 2000 with a Visual Basic (version given as 9969) macro. SolverReset is observed, and SolverAdd puts the constraints in. But the SolverOK statement does nothing, so the SetCell and the ByChange windows stay empty.

SolverSolve is trying to do something, because the spreadsheet cell that should receive the return code from Solver gets an error value #VALUE! (The macro then stops, unable to process this entry.)

Solver is checked off ok in the References list in V.Basic.

The same macro, same spreadsheet, in the same Excel file, works fine on the other computer in my office with what I am told is a more recent version of Excel; i.e. this doesn't look like a coding error.

Count the number of occurences on 1 day within a 60 minute timeframe. data includes dates and times

View 5 Replies View RelatedI've been working on this for days, i still got no solution on what formulas I will put on cells in "To" tab. The excel file is composed of two tabs "To" and "From". We will convert the "From Tab" to "To" format. What formula will I put in D3 to V3 and drag down in "To" tab to convert datas from "From" tab.

View 9 Replies View RelatedI'm using Excel 2007 and I want to plot data vs dates. Furthermore I want the dates on the dates axis to increment by month not by a certain number of days. So something like this:

1-Jan-09

1-Feb-09

1-Mar-09

...

There's the Major/Minor Units on the Axis Options screen but I cannot type in a constant number since the number of days for each month is different.

I have been given the task of finding out who logs in at what time of the day.

I have attached the raw data that I have to work with.

In essence I need to see how many login's there were for 06.00 - 10.00 at 15 minute intervals e.g:

06:00 - 5 Logins

06:15 - 1 Logins

06:30 - 3 Logins

06:45 - 11 Logins

etc

Has anyone got any suggestions?

I'm the Held desk manager . I'll have my folks logging in every time interval and work for 9hrs. Now I wanted to see at any given point a day the number of folks I have on my desk .

I have created table " A " and I'm looking for a formulae so that I get my data like table " B " .

To give more insight about table '" B " - During 00:00 - 00:30 , I'll have 41 people slowly goes down as people log off..

In the attached excel file I'd like to use data that was polled every 15 minutes. i.e 00:15, 00:30, 00:45, etc. Can I do this without having to manually delete all the nonrequired data per each row?

Also I have many files of such data that and would like to combine the all them into one to represent data for the whole year polled at every 15 minutes.

I have to write the word "hyllvagn" in column A in every fifth row starting with $A$2.

The range should be $A$2:$A$100.

Copyrights 2005-15 www.BigResource.com, All rights reserved