pearson

  1. Greg Truby

    If Chip Pearson's website ever helped you, please jot a note...

    If you have ever done any serious VBA programming in Excel, then it's almost a lock that at some point you found yourself at an impasse, did a search and found yourself visiting www.cpearson.com where you found a well-documented and well-explained solution to the problem that had been vexing...
  2. MARK858

    Chip Pearson - RIP

    I was sad to see on another forum the reports of the death of Chip Pearson. Although I never had any personal dealings with Chip, I (as I would expect many others) used his site for many years for reference and learning. Just wish to post my condolences to his family and friends and although a...
  3. S

    Unable to get the Pearson Property of the worksheetfunction class

    Greetings, I am receiving the error "Unable to get the Pearson Property of the WorksheetFunction Class" Runtime Error on the line below. Arg1 and Arg2 are both Range variables. J, and i are integer variables. I would like the value of Cells(j,i) to be the value of the Pearson...
  4. S

    Skipping Rows in Formula

    I'm trying to run a Pearson Correlation [=pearson(array1,array2)] between two columns (e.g. A and B, rows 1-20) but wanted to skip a few rows in both columns (e.g. 11-15). When I try to write the equation, skipping the rows by holding ctrl+highlighting, the equation writes itself as...
  5. D

    Excel formula for Pearson IV distribution (w. mean, std dev, skew, & kurtosis)

    Hello Everyone, What is the excelformula to generate the inverse Pearson IV distribution? I have mean, standarddeviation, skew and kurtosis and I plan to generate random outputs given thosestats. How do I write the formula? My question is verydirect and simple. I've looked everywhere for an...
  6. J

    Keyboard Shortcut for Name Box

    Hi, I would like to have a keyboard shortcut which moves the cursor into the Name Box to: - enter a new name or address for selected range, - copy the address/name of selected range. Just like when you use mouse to reach the Name Box, it sets the focus and selects its content. I'm trying...

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Syntax errors
    Good Morning, Trying to compile a workbook, I keep getting a few errors. Here are the first two: [code=rich]Syntax Error: Function...
Top