Measure-Object for statistics in PowerShell - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ Predict Output

intermediate

Output of Measure-Object with Sum and Average

What is the output of the following PowerShell code snippet?

PowerShell

1..5 | Measure-Object -Sum -Average | Select-Object Sum, Average

A @{Sum=15; Average=2.5}

B @{Sum=10; Average=2.5}

C @{Sum=15; Average=3}

D @{Sum=10; Average=3}

💡 Hint

Sum is the total of numbers 1 to 5, average is the sum divided by count.

The sum of numbers 1 to 5 is 15. The average is 15 divided by 5, which is 3.

❓ data_output

intermediate

Count and Maximum Value from Measure-Object

Given the array 3, 7, 2, 9, 5, what does this command output?

PowerShell

3,7,2,9,5 | Measure-Object -Maximum -Count | Select-Object Maximum, Count

A @{Maximum=9; Count=5}

B @{Maximum=9; Count=4}

C @{Maximum=7; Count=4}

D @{Maximum=7; Count=5}

💡 Hint

Count is the number of items, Maximum is the largest number.

There are 5 numbers, and the largest is 9.

🔧 Debug

advanced

Identify the error in Measure-Object usage

What error does this code produce?

PowerShell

1..3 | Measure-Object -Sum -Median

A No error, outputs Sum and Median correctly.

B Parameter set cannot be resolved using the specified named parameters.

C Runtime error: Median is not a valid property.

D Syntax error: Missing pipe operator.

💡 Hint

Check if Measure-Object supports combining Sum and Median parameters.

Measure-Object does not allow Sum and Median together because they belong to different parameter sets.

🚀 Application

advanced

Calculate Standard Deviation using Measure-Object

Which option correctly calculates the standard deviation of the numbers 4, 8, 6, 5, 3 using Measure-Object and additional code?

A $nums = 4,8,6,5,3; $mean = ($nums | Measure-Object -Sum).Sum / $nums.Count; [math]::Sqrt(($nums | ForEach-Object {($_ + $mean) * ($_ + $mean)} | Measure-Object -Sum).Sum / $nums.Count)

B $nums = 4,8,6,5,3; $mean = ($nums | Measure-Object -Average).Average; [math]::Sqrt(($nums | ForEach-Object {($_ - $mean)} | Measure-Object -Sum).Sum / $nums.Count)

C $nums = 4,8,6,5,3; $mean = ($nums | Measure-Object -Average).Average; [math]::Sqrt(($nums | ForEach-Object {($_ - $mean) * ($_ - $mean)} | Measure-Object -Sum).Sum / $nums.Count)

D $nums = 4,8,6,5,3; $mean = ($nums | Measure-Object -Average).Average; [math]::Sqrt(($nums | ForEach-Object {($_ - $mean) * ($_ - $mean)} | Measure-Object -Sum).Sum / ($nums.Count - 1))

💡 Hint

Standard deviation uses squared differences from the mean and divides by count minus one for sample SD.

Option D correctly computes sample standard deviation using sum of squared differences divided by n-1.

🧠 Conceptual

expert

Understanding Measure-Object Output Properties

Which property is NOT included in the output of Measure-Object when using the -Average parameter?

A Maximum

B Average

C Count

D Sum

💡 Hint

Think about which statistics are calculated by default with -Average.

Measure-Object with -Average returns Sum, Average, and Count but does not include Maximum unless specified.