Skip to content
中文Sign in

FOLLOW AN IDEA

Knowledge graph

Explore concepts, videos and verified content locations.

Select a node to inspect its connections.

Nodes and connections

Spreadsheet mean and population standard deviation

video
  • Application → Variance
    EvidenceReviewed application connection to Variance.
  • Application → Variance
    EvidenceUse a spreadsheet to compute the mean and population standard deviation of12 monthly temperatures for Taipei, Kaohsiung and Hsinchu. The lesson enters AVERAGE and STDEVP with row ranges and copies their formulas down. Changing Taipei month6 from28 to20 updates its displayed mean from23.48 to22.82 and standard deviation from5.19 to5.08; the linked chart follows. Values are displayed rounded, and the sample/population distinction is introduced without proving the denominator correction.

Variance

concept
  • Application → Spreadsheet mean and population standard deviation
    EvidenceReviewed application connection to Spreadsheet mean and population standard deviation.
  • Application → Spreadsheet mean and population standard deviation
    EvidenceUse a spreadsheet to compute the mean and population standard deviation of12 monthly temperatures for Taipei, Kaohsiung and Hsinchu. The lesson enters AVERAGE and STDEVP with row ranges and copies their formulas down. Changing Taipei month6 from28 to20 updates its displayed mean from23.48 to22.82 and standard deviation from5.19 to5.08; the linked chart follows. Values are displayed rounded, and the sample/population distinction is introduced without proving the denominator correction.