Skip to content

Instantly share code, notes, and snippets.

@dfinke
Created February 24, 2013 22:43
Show Gist options
  • Save dfinke/5026066 to your computer and use it in GitHub Desktop.
Save dfinke/5026066 to your computer and use it in GitHub Desktop.
param($data=1..50)
$xl = New-Object -ComObject Excel.Application
$xlProcess = Get-Process excel
$wf = $xl.WorksheetFunction
$data = $data|iex
New-Object PSObject -Property @{
Median = $wf.Median($data)
StDev = $wf.StDev($data)
Var = $wf.Var($data)
} | ConvertTo-Html
$xlProcess.kill()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment