Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x

Statistical Packages

Statistical packages are software titles, such as JMP and GNU Octave, and programming languages, such as MATLAB, R and SAS, that are used to discover, explore and analyze data and suggest useful conclusions, either to learn something unexpected or to confirm a hypothesis. The field includes the design and analysis of techniques to give approximate but accurate solutions to hard problems in statistics, econometrics, time-series, optimization and 2D- and 3D-visualization. Data analysis has multiple facets and approaches, encompassing diverse techniques under a variety of names, in different business, science, and social science domains.

Share tech news, updates, or what's on your mind.

Sign up to Post

I can upload a into RStudio server using shiny.  However, I cannot open the file for editing and saving for processing by the R code.  Apparently, the randsontable library function ransdontable() takes as input a dataframe.  I am using the code below: DF = as.data.frame(read.delim(inFile$datapath))
    rhandsontable(DF, width = 550, height = 300)

but I get the message:

Warning: Error in as.data.frame.default: cannot coerce class "c("rhandsontable", "htmlwidget")" to a data.frame

Is there a solution for this, or is there any other way to open and edit file using shiny?

EDIT:
My code was completely wrong. If anyone wants to find more about the R rhandsontable, please post a question. I will be happy to help.
0
Free Tool: Site Down Detector
LVL 11
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

A user I support needs me to purchase the JMP software (which is available from the https://www.sas.com/jmpstore/software/jmp/prodJMP.html website).

I have visited this website and have found that this software is being sold for $1,700.

Are there any other places or vendors where the full version of this software can be purchased for less?
0
I have an excel spread sheet that has a column with either b, g or r
I would like to create a formula in a separate column which will convert this to either Blue, Green or red

Gordon
0
Installing SQL 2017 we were asked to "Accept" on "Microsoft R Open".  We looked it up some sort of open source, but What is it to us Microsoft product users?, also  Why click "Accept" it in this SQL install? and How can we take advantage of this "Microsoft R Open"?
0
TABLEI have a table with data R. Virgo (3 Rows). I want to query the most recent only the frist row and not all the data with this code:

    Private Sub DISPLAY()
        conn.Close()
        Dim cmd2 As New MySqlCommand
        Dim myDA2 As New MySqlDataAdapter(cmd2)
        Dim myDT2 As New DataTable
        cmd2.Connection = conn
        cmd2.CommandText = "SELECT * FROM esd_reco where IDNumber = '" & txtG.Text & "' ORDER BY Date DESC"
        myDA2.Fill(myDT2)
        dghistory.DataSource = myDT2
        conn.Close()

Open in new window


txtG.text is the ID Number
Help please, thank you.
0
below is a VBA formula for subtotalling filtered data and  which works fine if I define the column number as a given number  in in the section of code to the right
However I would like to define the column number as a variable ie Col Number 2 or Column Number 6 etc
Have seen some suggestions how this might work but doesnt seem to like the formula I am using
I know what I have put in is wrong but am trying to figure out the correct if possible version

Sub Analysis_Testdev()
 Dim ColNumberx As Integer
 ColNumberx = 2


   
    Sheets("WsheetA").Select
    Range("B10").Select
    Application.CutCopyMode = False
'
    ActiveCell.FormulaR1C1 = _
        "=IF('123WsheetA'!RC[-1]>-.1,SUMPRODUCT(SUBTOTAL(109,OFFSET('123WsheetA'!R48C5,ROW('WsheetA'!R49C5:R20000C5)-ROW('WsheetA'!R48C5),,1)),--('WsheetA'![R49C&ColNumberx]:[R20000C&ColNumberx]='WsheetA'!RC[-1])),"""")"
           
           
    ' my problem is getting this bit of the above equation to work in that I want the Column Number to be a variable ColNumberx and i cant seem to get it to work
       '   --('WsheetA'![R49C&ColNumberx]:[R20000C&ColNumberx]='WsheetA'!RC[-1])),"""")"
       ' the aim is to create a valid formula in B10 based on whatever column I choose and then copy it to cells B10:B29 but I cant get the column number based on a variable right
           
       
    Range("B10").Select
    Selection.Copy
    Range("B10:B29").Select
    ActiveSheet.Paste
   
   
 
End Sub
0
I had this question after viewing How to change this macro to find last column instead of A to J?.

Sub Commas2Rows()
  ' hiker95, 05/18/2017, ME1006027
  Dim lr As Long, lc As Long, r As Long, s, i As Long
  Application.ScreenUpdating = False
  With ActiveSheet
    lr = .Cells(Rows.Count, 1).End(xlUp).Row
    lc = .Cells(2, Columns.Count).End(xlToLeft).Column
    For r = lr To 2 Step -1
      If InStr(.Range("G" & r), ", ") Then
        s = Split(.Range("G" & r), ", ")
        .Rows(r + 1).Resize(UBound(s)).Insert
        .Range("G" & r).Resize(UBound(s) + 1) = Application.Transpose(s)
        .Range("A" & r + 1 & ":F" & r + 1).Resize(UBound(s)).Value = .Range("A" & r & ":F" & r).Value
'        .Range("H" & r + 1 & ":J" & r + 1).Resize(UBound(s)).Value = .Range("H" & r & ":J" & r).Value
        .Range("H" & r + 1 & ":" & Chr(64 + lc) & r + 1).Resize(UBound(s)).Value = .Range("H" & r & ":" & Chr(64 + lc) & r).Value
      End If
    Next r
  End With
  Application.ScreenUpdating = True
End Sub
0
I have to install an R program and several open source proteomics programs in a linux box.  The R program calls the open source proteomics programs.  The pipe line starts by one of the programs taking as input a raw data file and all the programs produce output files some of which may be input to the other programs in the pipe line.  The users will be able to run the R program online.
1. Is it possible to do this? I am using the open open source version of RStudio which s single threaded (users responses to program requests wait until the previous user in the chain finishes running the pipeline. This implies that the proteomics programs called by R will be called by a single user at a time.

2.  Is there any way of synchronizing the linux box and the users pcs so that the files can be created in both the linux server and the PCs, otherwise the users will have to send the raw data file to the Linux box and to import data files from the linux box to their PCs.
0
The R program that we have calls other proteomics open source software installed in the user PCs.  I am going to install RStudio server and the Sniny server in linux so that everyone can access the program remotely.  The idea is to keep the proteomics software in the user PCS and just install the R program in the server.  Is this possible? Will the server be able to locate the software installed in the user PCs?
0
Guys I have codes here that is working in Numeric only.
I need a code that whatever is the last number it will generate the next number.Whether I changed the last or not it will generate a next number. Here's my code for the numeric number but I need to generate a number  using alpha-numeric.

Dim Ws As Worksheet
    Dim r As Long
    Dim ReqNo As String
    Set Ws = Worksheets("MainRecord")
getNum:
    r = Ws.Cells(Ws.Rows.Count, "D").End(xlUp)
    ReqNo = CODES.Text & "-" & r + 1
    If IsNumeric(Application.Match(ReqNo, Worksheets("MainRecord").Range("D:D"), False)) Then GoTo getNum
    On Error Resume Next
    Me.REQUESTNO.Value = ReqNo

I dont know what code to use.To generate an Alpha-Numeric number
0
Free Tool: Path Explorer
LVL 11
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

In process of rebuilding...installed SSD...Win 7 / 64 Pro...new RAM...
All drivers installed...correctly...

HOWEVER...this bugger will NOT update BIOS...

According to Belarc which I ran before the rebuild...I have BIOS v2.7...
The latest BIOS on Toshiba download site is BIOS v4.10
Everytime I try to install the BIOS i get the error message......"This computer is not supported"...

Any suggestons appreciated...
0
We hv external consultants who will be stationed at our office to do
Data warehse statistical analysis using R & Python :
what are the risks to watch out for ?  We provide hardened PCs

Don't allow Internet access?
Any patches needed?
Secure Coding to adhere to?
0
I have this query that returns the count within each dollar range of quotes. I would like to add the sum of the dollar value of those quotes as well. Is that possible within this one query? If so, how would you do it?

SELECT T.RANGE AS [Range_Value],COUNT(*) AS [Number_of_Quotes]
FROM (
      SELECT CASE
            WHEN CONT_AMNT >=0 AND CONT_AMNT <= 1000 THEN ' 1) $0-$1000'
            WHEN CONT_AMNT >1000   AND CONT_AMNT <= 5000 THEN ' 2) $1000-$5000'
            WHEN CONT_AMNT >5000   AND CONT_AMNT <= 10000 THEN ' 3) $5000-$10000'
            WHEN CONT_AMNT >10000  AND CONT_AMNT <= 50000 THEN ' 4) $10000-$50000'
            WHEN CONT_AMNT >50000  AND CONT_AMNT <= 100000 THEN ' 5) $50000-$100000'
            WHEN CONT_AMNT >100000 AND CONT_AMNT <= 150000 THEN ' 6) $100000-$150000'
            WHEN CONT_AMNT >150000 AND CONT_AMNT <= 200000 THEN ' 7) $150000-$200000'
            WHEN CONT_AMNT >200000 AND CONT_AMNT <= 500000 THEN ' 8) $200000-$500000'
            WHEN CONT_AMNT >500000 AND CONT_AMNT <= 1000000 THEN ' 9) $500000-$1000000'
            WHEN CONT_AMNT >1000000 THEN '10) $1000000+'
     END AS RANGE
       FROM (
         SELECT SUM(TOTAL_SELL_PRC) AS CONT_AMNT,CUSTOMER_NUMBER AS CUSTNMBR
   FROM [CSTQUTHD]
   WHERE DATE_OF_QUOTE>= '2016/01/01' AND DATE_OF_QUOTE<'2016/12/31'
   GROUP BY CUSTOMER_NUMBER) R ) T
   GROUP BY T.RANGE
0
I dont think SQL can store a table with 190,005 columns and 5000 Rows.

What I have now.
Right now what I have is a table with 5001 observations. Each observation has 190,005 possible scenarios.  That's 950,215,005 rows.

My objective.
I would like to pivot this table so my observations is the first column and all the possible outcomes are columns.
The observation is an int and the possible observations are bit (basically yes or no for outcome).

I am using Microsoft SQL server 2016.

My goal.
I am trying to create a matrix to do correlation analysis. I will be bring the data into R some how i am sure that's going to be a challenge as well.

If SQL cant do it that's fine but how then can I get this data into a Text file from SQL?

Basically Type becomes columns and isTrue flag is now going horizontal so there is 1 row per Key. Remember there are 190,005 different Types for each member. Yes I do know every possible Type value. For the sake of this example I didnt think it would be wise to list all 190,005.
Here are my columns
Key, Type, isTrue
1,V3201,1
1,F123,0
1,S20341,0
2,99080,1
2,R4570,1
2,S26995,0
3,D4567,0
3,SX34526,0
3,F5678,1
3,E9807,1
3,ST5688,0

Open in new window


Thank you in advance for your help.
0
I am getting the following error when running make while trying to cross-compile OpenSSL:

make[1]: mips-linuxar: Command not found
Makefile:652: recipe for target 'libcrypto.a' failed
make[1]: *** [libcrypto.a] Error 127
make[1]: Leaving directory '/home/dev/openwrt/package/openssl-1.1.0f'
Makefile:128: recipe for target 'all' failed
make: *** [all] Error 2


From the Makefile:

PLATFORM=linux-generic32
OPTIONS=--cross-compile-prefix=mips-linux no-asan no-crypto-mdebug no-crypto-mdebug-backtrace no-ec_nistp_64_gcc_128 no-egd no-fuzz-afl no-fuzz-libfuzzer no-heartbeats no-md2 no-msan no-rc5 no-sctp no-ssl-trace no-ssl3 no-ssl3-method no-ubsan no-unit-test no-weak-ssl-ciphers no-zlib no-zlib-dynamic
CONFIGURE_ARGS=("linux-generic32", "--cross-compile-prefix=mips-linux")

ARFLAGS=
AR=$(CROSS_COMPILE)ar $(ARFLAGS) r


Line 652
      $(AR) $@ $?

I am new to this. Please tell me how I can make this question more useful.

Thank you.
Makefile
Configure
0
How to find the returns of multiple, irregular inflows & outflows over a short period, lets say in 4 months?

I don't want to use the XIRR as it gives the compounded annualized return, which will be misleading. I want to calculate the returns for the duration of the investment only.

For eg., please refer to the attached excel sheet which lists out 5 transactions of Buy & Sell over 4 months period.

Thanks and regards

R
Question.xlsx
0
Hi,
I received a new computer last week but cannot get Task Scheduler to successfully run a VBS script.  It says it is running but the spreadsheets are not updating.  I created a new script to open Notepad and type a few words and Task Scheduler says it is running, ran successfully, but it did not..Notepad never opened.

I can manually run both scripts and they work fine.  Spreadsheets get updated and Notepad opens, types a few words, and stays open until I close Notepad.

My company's computer support has not been able to help at this time and I am currently waiting for the next level of help.  However, that could be more than a week until someone contacts me.

Attached are some screen shots I hope will help, with some identifying text blacked out with a description of what info was there.

Would any of you have any ideas as to why the scripts work when I double click on them manually to get them to run but Task Scheduler will not successfully get them to run, even though it says they are running?

Thanks.
0
I run VMware 6.0 one of my ESXI hosts lose two datastores
This host has 4 datastores 3 are local ATA drives and one is NFS
Two 0f the ATA drives are Dead or Error.
If I restart the ESXI Host they come back.

I swapped the drives out with two other drives and the same thing happened Dead or Error after about 24 hours.

I was lucky to have Veeam B& R nd I was able to recover the VMs on those two datastores.

Is my ESXi host corrupted ? or do you guys think I have a hardware problem

I found this
http://www.enterprisedaddy.com/2017/06/datastore-shows-inactive-unplanned-pdl/

And ran those commands but I had no VMS running on these datastores

Maybe if I put the original drives back in the results may be different I would rather keep the existing drives in now

If there some sort of cache or something I need to clear on this host?

Thanks Tom
0
Please look at the following VBA code that relates to the attached spreadsheet. The relevant section of this sub is the second paragraph where the first line comment is 'Delete all data in the "TME" tab older than one week. The other paragraphs of this sub work fine as far as I can tell.

This section of the sub refers to the attached sheet, which is the TME tab of a much larger workbook. As you see, the intent of this section of the sub is to delete all records on the TME sheet older than one week from TODAY (the date in column I, Row 1 or relative cell 1,9). For reference, the formula in I1 is =(TODAY()-MOD(TODAY()-1,7))-3. This formula works fine - no need to change it.

The problem is that this second paragraph of the sub below does not actually do any deleting of rows. It also does not stop execution for any errors, but proceeds right on to the next section of the sub without doing anything. I want it to delete all rows from row 2 of the attached sheet and continue deleting until the date in column A is one week older than the date in cell I1.

What needs to be changed to this section of the sub to get it to properly delete the required rows?

Thanks!

Glenn S.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Sub sub1()
'Import the daily data from the Cognos extract
Dim rng As Range, region As Range, col As Range
Dim rcount As Long, r As …
0
Get your problem seen by more experts
LVL 11
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

I need to ensure ALL mandatory cells in a row are filled in before another row is added.  Please see attached file for example.  
I've intentionally left blank columns I, O, R and S.  
Before I add a second row, I'd like to see an error message identifying the unfilled cells, or even better those unfilled cells highlighted.
If this is not able to be done, any suggestions are most welcome.
EE-Assets-Multi-Road-Template.xlsx
0
123.JPGi have a code like this but it call only pull up numeric character.Any ways so that i can pull up using alpha-numeric character?
Private Sub TextBox1_Change()
    Find = Val(Me.TextBox1.Value)
    c = Application.WorksheetFunction.CountIf(Sheet3.Range("C:C"), Find)
    If c = 0 Then
        REQUESTNO.Text = ""
        ISSUE.Text = ""
        FLOOR.Text = ""
        PALACE.Text = ""
        LOCATION.Text = ""
        DEPARTMENT.Text = ""
        REQUESTOR.Text = ""
        TFINISH.Text = ""
        CONTACTN.Text = ""
        STATUS2.Text = ""
        DFINISH.Text = ""
        REMARKS2.Text = ""
        Exit Sub
    End If
    r = Application.WorksheetFunction.Match(Find, Sheet3.Range("C:C"), 0)
    Me.REQUESTNO.Value = Sheet3.Range("c" & r).Value
    Me.ISSUE.Value = Sheet3.Range("d" & r).Value
    Me.FLOOR.Value = Sheet3.Range("e" & r).Value
    Me.PALACE.Value = Sheet3.Range("f" & r).Value
    Me.LOCATION.Value = Sheet3.Range("g" & r).Value
    Me.DEPARTMENT.Value = Sheet3.Range("h" & r).Value
    Me.REQUESTOR.Value = Sheet3.Range("i" & r).Value
    Me.CONTACTN.Value = Sheet3.Range("j" & r).Value
    Me.DFINISH.Value = Sheet3.Range("k" & r).Value
    Me.TFINISH.Value = Sheet3.Range("l" & r).Value
    Me.STATUS2.Value = Sheet3.Range("m" & r).Value
    Me.REMARKS2.Value = Sheet3.Range("o" & r).Value
End Sub
0
I have a code that generates a serial number.
Dim ws As Worksheet
    Dim r As Long
    Dim ReqNo As String
    Set ws = Worksheets("MainRecord")
getNum:
    r = ws.Cells(ws.Rows.Count, "C").End(xlUp)
    ReqNo = r + 1
    If IsNumeric(Application.Match(ReqNo, Worksheets("MainRecord").Range("C:C"), False)) Then GoTo getNum
    On Error Resume Next
    Me.REQUESTNO.Value = ReqNo

It can pull up but only number but when I format my codes using these format

Dim ws As Worksheet
    Dim r As Long
    Dim ReqNo As String
    Set ws = Worksheets("MainRecord")
getNum:
    r = ws.Cells(ws.Rows.Count, "C").End(xlUp)
  ReqNo = "RAS17" &  format(r + 1,"00")
    If IsNumeric(Application.Match(ReqNo, Worksheets("MainRecord").Range("C:C"), False)) Then GoTo getNum
    On Error Resume Next
    Me.REQUESTNO.Value = ReqNo

I am getting an error because maybe of the ISnumeric  code.

I ll be glad if you can help me with this.21223.JPG
0
Hi,

Im hoping someone can help me. I have the below code with I am using to take screenshots and open up a draft email in Excel with the screenshot in the main body. But the screenshot is really small. I think this is to do with the actual Excel sheet been zoomed to 70% but it doesn't change when I set it back to 100%. Is there any way of writing in the code, or can someone amend my cose so it resizes the picture? The code is...

Private Sub CommandButton1_Click()
'Copy range of interest
Dim r As Range
Set r = Range("B3:N40")
r.Copy

'Paste as picture in sheet and cut immediately
Dim p As Picture
Set p = ActiveSheet.Pictures.Paste
p.Cut

'Open a new mail item
Dim outlookApp As Outlook.Application
Set outlookApp = CreateObject("Outlook.Application")
Dim outMail As Outlook.MailItem
Set outMail = outlookApp.CreateItem(olMailItem)

'Get its Word editor
outMail.Display
Dim wordDoc As Word.Document
Set wordDoc = outMail.GetInspector.WordEditor

'Paste picture
wordDoc.Range.Paste
End Sub
______________________________________________________________
Many thanks in advance.
0
Hello,
I have the following query returning results on faculty members by group by facultyid, fname and lname.  The results are displayed in a table on a secured site.  What I need to do next is insert a page break once the facultyid does not match so faculty can print each group on a separate page.  The query is below:

$printqry ="select C.facultyid,S.fname+' '+ S.lname as 'Faculty Name', C.sname, Q.qualify_name, R.fname+' '+ R.lname as Reviewer, C.lastupdate as 'Date and Time Updated'
from courserating as C,FQS_STaff as S,Qualify as Q, Review_Team as R
where
C.facultyid = S.id and
C.rating = Q.id and
C.reviewerid = R.id  
and C.reviewerid = ".$_SESSION['reviewer']." and  convert(date,C.lastupdate) = convert(date,getdate())
group by S.lname, S.fname,C.sname, Q.qualify_name, R.lname, R.fname, C.lastupdate, C.facultyid
order by S.lname, S.fname  ";

while(odbc_fetch_row($printqrydo))
{
    $facultyid = odbc_result($printqrydo,1);
    $facultyname = odbc_result($printqrydo,2);
    $sectionname = odbc_result($printqrydo,3);
    $qualifyrating = odbc_result($printqrydo,4);
    $reviewername = odbc_result($printqrydo,5);
    $lastupdate_db = odbc_result($printqrydo,6);
             
                 
        echo '<tr class="break"><td  >'.$facultyname.'</td> <td >'.$sectionname.'</td><td>'.$qualifyrating.'</td><td>'.$reviewername.'</td>
       <td>'.$lastupdate_db.'</td></tr>';
 
}
 

i tried a number of solutions and can't seem to get it to …
0
Hey guys,

We're in the middle of migration to Office 365. We moved a lot of users already mostly through ECP on Office 365. Then we decided to move some users Archives only first and it was working just fine. So, when we try to move the user's  primary mailbox for users who already have Archive Online migrated earlier - it gives us following error:

[PS] C:\Windows\system32>New-MoveRequest -id "user@domain.com" -Remote -RemoteHostName "email.domain.com" -Target
DeliveryDomain domain.mail.onmicrosoft.com -RemoteCredential $LocalCredential -primaryonly
Target user 'User' already has a primary mailbox.
    + CategoryInfo          : InvalidArgument: (user@domain.com:MailboxOrMailUserIdParameter) [New-MoveRequest], R
   ecipientTaskException
    + FullyQualifiedErrorId : [Server=EX01,RequestId=1bdf2276-2d56-47ef-9545-28a88uu402cb,TimeStamp=7/27/2017 6:59:13
   PM] [FailureCategory=Cmdlet-RecipientTaskException] 338394AD,Microsoft.Exchange.Management.Migration.MailboxReplic
  ation.MoveRequest.NewMoveRequest
    + PSComputerName        : ex01.domain.com


Not sure where the error is. User's primary mailbox still on premises. And Archive is online. User can access both from Outlook. ECP on Exchange don't have this user as a recipient. When I run Get-MailboxStatistics I see that user still on-prem and only archive on Office 365

[PS] C:\Windows\system32>Get-MailboxStatistics -Identity jlavo@domain.com | fl


RunspaceId                                 :
0

Statistical Packages

Statistical packages are software titles, such as JMP and GNU Octave, and programming languages, such as MATLAB, R and SAS, that are used to discover, explore and analyze data and suggest useful conclusions, either to learn something unexpected or to confirm a hypothesis. The field includes the design and analysis of techniques to give approximate but accurate solutions to hard problems in statistics, econometrics, time-series, optimization and 2D- and 3D-visualization. Data analysis has multiple facets and approaches, encompassing diverse techniques under a variety of names, in different business, science, and social science domains.

Top Experts In
Statistical Packages
<
Monthly
>