Social Network Computation

Objectives:

  1. Write a formula in Excel to quantify the relationship between two different people based on certain properties.
  2. Use online tools to collaborate in the collection and analysis of data.
  3. Use a condition to format data.
  4. Write a formula in Excel to scale down data to fit in a graphic.
  5. Represent social network data by creating a visualization using nodes, node color, node size, and lines.
  6. Use a pre-defined function in a formula to transform data.
  7. Calculate a correlation coefficient manually and by using a pre-defined function.
  8. Calculate the significance of correlation between two variables and compare it to a table of accepted values.
  9. Calculate the coefficient of determination to describe the amount of variance that can be explained by a relationship between two variables.

Download Lesson – Social Network Computation.

About Author: py

Comments are closed.

Follow me on Twitter