Posts by Rildo • 133 points
8 posts
-
1
votes1
answer282
viewsA: How to create a dynamic table with multiple line fields using VBA?
I figured out how to solve: Variable X must be set to String Dim X as String X = Wsheet.Range("F" & i) Also, there was an error in the command for for i should start with 1…
-
1
votes1
answer282
viewsQ: How to create a dynamic table with multiple line fields using VBA?
I want to create a dynamic table with several line fields. But, these line fields need to be changed according to the data entered in the Excel spreadsheet. I tried to define the variables and use…
-
2
votes1
answer110
viewsQ: Testing Accuracy of an ARIMA model
I am creating a function to run ARIMA models. After storing the function results in an object to do the Accuracy test, returns the following error: Warning message: In trainingaccuracy(f, test, d,…
-
1
votes2
answers49
viewsQ: Redeem results in r
It is possible to rescue only p-value from a simple linear regression in R? I have the following code: reg<-lm(abscissa~ordenada) summary(reg) the answer is: Call: lm(formula = abscissa ~…
-
0
votes3
answers125
viewsA: Sum of intervals
You can use the following table: Formulas: C1:=ARREDMULTB.MAT(E1;5)/5 D1:=E1-(C1*5) E2:=SE(C1=0;D1*B1;SE(C1=1;(B1*5)+(B2*D1);SE(C1=2;(B1*5)+(B2*5)+(B3*D1);SE(C1=3;(B1*5)+(B2*5)+(B3*5)+(B4*D1)))))…
-
1
votes2
answers678
viewsA: Convert an excel file (xls, xlsx) to PDF
You can convert Excel to PDF only by changing the file type at the time of Save As. Change the file type to PDF. Just below the file name.…
-
2
votes1
answer88
viewsQ: How to chart in r with variable titles?
I need to create a function that returns graphics in which the title name contains the variable name, as in the example. Dados<-c(5,4,8,9,2,1,6,2,5) Validação <- function(y){ plot(y,…
-
3
votes2
answers114
viewsQ: How to create one vector from another in r?
I need to create the vector fixo of NA and 0 from another vector coef. If coef<-c(1,4,10) then fixo = (NA,0,0,NA,0,0,0,0,0,NA) I tried to use str_detect: num<-c(1,4,10) maiorn <- max(num)…