Search results for query: *

thanks for the input. I'll try it later and let you know. rgds

Hi folks I need help on loading data from many different workbooks into a different workbook/worksheet so I can analyse the data. All Excel files have the same path, but some workbooks have the specific worksheet others not. The specific worksheets have the same name and the cell range is the...

you could "DAVERAGE" as well: DAVERAGE(database,field,criteria. You can also use Boolean operators to create multiple criteria

You could make a pivot table with averages and select the specific time you want.

cross validation is a type of test in which a data set is split in "k" sub-groups. The model is tested on those sub-groups that were not used for the model building. So your cross-validation SSE (Sum of Squared Errors) is very close to the initial model SSE, meaning it is robust.

Good point. The normal quantile plots have very good linearity and normal fitting pass Shapiro-Wilk W test. Back to PCA: I have one variable and multiple data sets. Can I do a PCA in such situation? Does PCA requires we have more than one variable?

someone help me on this: I did a fitting on my data usinga monotonic function and the residuals are normally distributed, mean ~ 0, constant sigma. So I assume that my function describes the data very well. Now a colleague did Principal Components Analysis and found bumps. Now, do we have...

Thanks "m". Very interesting points. About the customer, they over-engineer things a bit. You got it right, now it is taking longer and longer to replicate. Let you know next week.rgds

hi folks the problem is the following: we collected many measurements under certain conditions and create a "golden signature reference". Subsequent parts results are compared to the golden for dispositioning. This golden can be generated after a curve fitting or by averaging all measurements...

Hi guys. I figured out to do like this: Dim counter As Integer For counter = 2 To 13 SolverOk SetCell:=Cells(66, counter).Address, MaxMinVal:=3, ValueOf:="0", ByChange:="$C$2:$C$5" SolverSolve Userfinish:=True ActiveSheet.Range("B69:B85").Copy ActiveSheet.Cells(90...

I'm getting there folks. thx. Now I need to copy and paste - text only - the results from each column. I'm using a subroutine for each fitting it got posted by joerd in dec'05 (thanks joerd, it works pretty well): Sub EthBal3() Dim C As Range For Each C in [$AF$5:$AF$8] SolverOk...

gonna try, thanks

I don't know how to use Macros. Besides, at this stage all the calculations need to be transparent so when I transfer to other people they can follow step by step or change the equation for the fitting rgds

You could use Origin from OriginLab (www.originlab.com). It is pretty good for fitting, with many built-in models or use-defined models

Hello Folks I'm using Solver to fit data in columns, one at a time to a user-defined function. As the function is the same, the "changing cells" - the constant of my function - are shared for each data column. Therefore, for each data set, the fitted results are changed, so I have to copy and...